|
|
|
February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
Error: data truncated. Posted by Michel Vanderbeke at 7/30/2007 11:48:18 PM Hello,
When writing a text to a SQL database nvarchar(6) field, I get following
error when the size of the input is larger than the available length of the
textfield (larger than 6).
String or binary data would be truncated.
The statement has been terminated.
How can I make that at l...more >>
Addnew in VB.NET ? Posted by fniles at 7/30/2007 3:56:44 PM In VB6 to add a new record in a recorset, you can use the Addnew method,
then set each column's value, then call the Update method.
How can I do this in VB.NET ?
Thank you.
VB6:
Private m_rs As new ADODB.Recordset
m_rs.Open "SELECT * FROM myTable", adoCon, adOpenKeyset, adLockOptimistic
...more >>
Visual Studio / Microsoft Posted by Bob at 7/28/2007 6:11:57 PM For the first time in my long career as an application developer, I
really do hate my job!
I am used to tools like Borland Basic, Turbo C, Clipper and Foxpro to
develop applications in a short time that simply worked and were fast.
I have been attempting to develop a real application in VB.Net...more >>
Pass date as parameter to Access DB Posted by Tony M at 7/25/2007 10:44:17 PM ASP .net - webforms
I changing things from sql string concatenation to parameters, for sql
injection reasons.
I keep getting a data type mismatch error.
I know the field / column is date/time and it worked with the string
concatenation .
OleCmd.Parameters.AddWithValue("LastChangeTime...more >>
Detach my database from SQL SERVER Posted by Michel Vanderbeke at 7/23/2007 6:02:43 PM Hello,
When I have closed my appliciation in VB.NET, and I try to detach my
database from SQL SERVER, I often get a message that the database cannot be
detatched, because it is still in use.
So I think there is some code missing in my application (in the
MDI_FormClosing?) to make my databa...more >>
cant get data from not visible datagrid column Posted by kpg at 7/20/2007 12:52:25 PM Hi all,
In asp.net 2.0 I'm having trouble getting data from a cell whose
column is marked as not visible
<asp:BoundField DataField="DataID" HeaderText="ID" ReadOnly="True"
Visible="false" />
Sub MyGridView_SelectedIndexChanged(ByVal sender As Object, ByVal e As
EventArgs)
...more >>
Geen inkomend videosignaal Posted by Michel Vanderbeke at 7/17/2007 12:00:00 AM Dag allemaal,
Heel regelmatig gebeurt het dat mijn beeldscherm meldt dat er geen inkomend
videosignaal is. Dit is altijd na een tijd inactiviteit. Blijkbaar gaat
het systeem in een soort van slaapstand, waar het door beweging van de muis
of intoetsen op het toetsenbord niet meer uit geraa...more >>
ADO Createdatabase Posted by JR at 7/16/2007 7:33:49 PM Hi,
I want to make a db sometimes 97 and sometimes 2000 compatible. on my system
it always make an 2003 file. How must I do that? For the furure maybe I need
2007 again how?
Jan
I use this code.
Public Function fMakeDatabase(ByVal FileName) As ADOX.Catalog
Dim catDB As New...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
DAO Deployment Question Posted by Paul Engel at 7/15/2007 10:07:21 PM I have a VB 2005 program that must use DAO. I have it running on my system
using Interop. When I deploy it, I get the following message on the local
PC:
System.Runtime.InteropServices.COMException (0x80040112): Creating an
instance of the COM component with CLSID
{00000010-0000-0010-8000-00AA00...more >>
validate SQL-query Posted by Erik van Engelen at 7/12/2007 6:28:10 PM Is it possible to validate or format a dynamic SQL-query in vb.net?
I have an application that passes data from a form to a MySQL database.
This data can include all kinds of user passed data like single quotes
or reserved words. Before creating the query i want to format the data
with a fu...more >>
Retrieve primary key after insert Posted by Phil at 7/11/2007 5:20:02 PM If I add a record into a database by executing a sql command using an INSERT
INTO query. How can I then get the value of the primary key field for the
new record? The database will be either Access or SQL server.
TIA
Phil.
...more >>
DBNull to database date-field Posted by Finn Stampe Mikkelsen at 7/11/2007 3:12:26 PM Hi
I have defined a table in my database, with 2 date-fields. I have set a
default value to DBNull. I have integrated a nullable datetimepicker control
to my project and set the apropriate NullValue in my datagridview...
Everything works great, with a table-row added manually to the databa...more >>
Dynamically change connectionstring Posted by Lennart Nielsen at 7/9/2007 9:09:28 PM I would like to be able to redirect a dataset "binding" from one database to
another during runtime. The database makeup will be identical, but the
actual files will be located in different folders, depending on current
projects.
They will in all cases reside locally, not on a network.
I...more >>
Hiding Tables...??? Posted by Tym at 7/8/2007 12:00:00 AM IN my old VB6 apps, I used DAO and was able to hide tables using the
following code:
For Each myTableDef In dbLAILOKEN.TableDefs
myTableDef.Attributes = dbHiddenObject
DoEvents
Next myTableDef
Now I'm on vb.net 2005, and using ADO, I can't find a way of doing it...
Can anyone h...more >>
how to pass a <null>to a stored procedure parameter? Posted by Brad Pears at 7/6/2007 4:29:09 PM I have a vb.net 2005 project using an sql server 2000 backend db. I want to
be able to insert null values into two of the date fields on new inserts
(there may be a valid date - but possibly it will be empty). These two
fields are defined as "smalldatetime" in sql server.
In my vb.net code,...more >>
View Consumer Posted by Kenelm Conrad at 7/3/2007 8:15:44 PM I'm not able to a gadget on a SCSI connector to the Fast
hard disk to download to forward on a program.
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |