Archived Months
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
all groups > vb.net data > october 2004

Updating a table with a dataset from another database
Posted by Vicente Cartas via .NET 247 at 10/31/2004 3:56:32 AM
Hello, I?m recieving a serialized dataset from a sql server database=2E I= want to create a similar table in a access database using the= dataset to populate it=2E The dataset was created in this way: 'da is a DataAdapter ds =3D New DataSet da=2EFillSchema(ds, SchemaType=2ESource) da=2E...more >>


nbmvbn
Posted by m m at 10/29/2004 3:15:46 AM
bnmvbmn ...more >>

nmvbm
Posted by m m at 10/29/2004 3:15:33 AM

OdbcDataAdapter
Posted by Fred at 10/28/2004 11:52:28 AM
I am trying to fill a dataset table using an OdbcDataAdapter but I keep getting the error: "An unhandled exception of type 'System.Data.Odbc.OdbcException' occurred in system.data.dll Additional information: System error." It must be Microsofts idea of a joke if 'system error' is supposed t...more >>

selection on LISTBOX ??
Posted by Martin at 10/26/2004 4:53:22 PM
I'm developing a library application that needs to input several authors to the database. So I decided to populate a listbox control with the names of book's author. The question is how to select several names ( list ) using {ctrl + click} like in windows explorer and then add the selected names ...more >>

[ANN] October 26, 2004, "ADO.NET with Visual Basic .NET" chat
Posted by Jason Cooke [MSFT] at 10/25/2004 9:53:33 AM
Every application uses data. Join members of the Visual Studio and SQL teams for a discussion of the best approaches for working with data in your applications. Date: October 26, 2004 1:00 - 2:00 P.M. Pacific time 4:00 - 5:00 P.M. Eastern time 20:00 - 21:00 GMT (For a list of local time ...more >>

Acces Database
Posted by Lou at 10/22/2004 2:24:08 PM
I am trying to create my first .Net app comming from VB6. I a have an Access DB. I want to show it in a grid. I have spent 2 days looking through MSDN, Google and can't find any samples on how this is done. I find it hard to believe the lack of sample code. Everthing seems to require sql ...more >>

DataRow.Delete Question
Posted by Daniel at 10/22/2004 7:31:01 AM
Hello Everyone, I am developing an application where the user can select an employee from a list of employees (ListBox) and delete it. The problem is that when I call DataRow.Delete method the row in question remains "Unchanged". The code looks like this: (gl_dsCpm is the Dataset) ...more >>



how to get the id of a new record
Posted by Ray at 10/21/2004 7:51:25 PM
This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C4B7A7.592C3F70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi guys. I have here a pretty common scenario I should think. Let's say that I have a sub like this one belo...more >>

Connecting to Access Database with a VB.NET Windows Application
Posted by ulchm NO[at]SPAM lonelyprogrammer.com at 10/20/2004 1:26:30 PM
Hello all... I'm just curious to see what people think the best way to connect to an Access database on a network with a VB.NET application. The Access DB will be on one of the computers on the network with multiple instances of the application running on the other networked computers. I...more >>

Connecting to MySQL from a web app on IIS.
Posted by duck_thunder NO[at]SPAM msn.com at 10/19/2004 4:08:50 PM
I'm trying to connect to a Mysql server version 4.0.21 running on localhost. The localhost is running on XP Pro and is hosting the web page using the bulit in Microsoft web server. I am using the ODBC drivers and can connect to the server from the development platform on the host pc and run qu...more >>

vb.net newbie - ado...
Posted by Tym at 10/19/2004 1:49:35 PM
OK - thre has to be an easy solution to this... Migrated from VB6 to vb.net *eventually* got to populate a datase (instead of a recordset) with the contents of a table based on an SQL query, but... how the heck do I naviagete? VB6: rsRECORDSET.move rsRECORDSET.moveftist rsRECORDSET...more >>

Copying Data from SQL Server to Access
Posted by SQLScott at 10/18/2004 2:05:03 PM
What is the most effecient way to copy data, programatically, from SQL Server to Access? The table in Access is already created so need to create that programatically, and the structure of both tables (columns, datatypes) is identical. I'm just trying to figure out the fastest and most ...more >>

Problem with DataRead
Posted by Markus Ellebrecht at 10/17/2004 3:15:30 PM
Hello, I am new to this group and I hope someone can help me *g*. I am good in VBS but now I want to switch to vb.net because of getting crazy while creating every form in VBS with InternetExplorer an HTML. OK. Now here is my first question: I have an Access-Database and I want to get so...more >>

Updating a table with a dataset from another database
Posted by Vicente Cartas via .NET 247 at 10/17/2004 3:12:03 AM
Hello, I?m recieving a serialized dataset from a sql server database=2E I= want to create a similar table in a access database using the= dataset to populate it=2E The dataset was created in this way: 'da is a DataAdapter ds =3D New DataSet da=2EFillSchema(ds, SchemaType=2ESource) da=2E...more >>

Problems with adding a record
Posted by davemckie66 NO[at]SPAM yahoo.com at 10/11/2004 9:07:04 AM
Hi all, I am new to VB.NET and ADO.NET, but have experience in VB6 and ADO. I have been trying a simple routine...adding a record to a MS SQL database with no success. I can connect to the database and read records without problem. I have been following a sample from MSDN....the routine fin...more >>

Copy XML data to Access Database
Posted by james at 10/10/2004 5:43:25 PM
I finally found a way to read an XML data file into a dataset and display that in a datagrid. And found a way using ADOX, to create an empty Access database. (no tables) What I am having a problem doing now (after tons of research) is once the xml data is loaded into the dataset, copying the c...more >>

Extracting an array from another array in vb.net
Posted by cdouillet NO[at]SPAM yahoo.com at 10/10/2004 6:43:19 AM
Hi to all, I am trying to find a quick "pointer like" method to extract an array from another array without havong to assign points one by one (too many points). Example: arr1={0,1,2,3,4,5,6,7,8} with LBound(arr1)=0 and UBound(arr1)=8 arr2=extract from arr1, position 2, length=3 result: ...more >>

odbcdataAdapter
Posted by Robert Bravery at 10/7/2004 4:18:58 PM
Hi all, Using VS.net 2003 I dragged an odbcdataadapter onto a new form, the configer dataatapter wizard apears, I click next, and get an error dialog box: unable to log onto the database. Now up to now, I have not specified any database or even what server or anything Help!!! Thanks Robe...more >>

How to Retrieve CLOB with ADODB Command Parameter (StoredProc), NOT by a Select statement
Posted by Khodr at 10/7/2004 3:33:48 PM
Hi everyone, I am calling an Oracle StoredProc that returns a CLOB data type value as an output parameter. What parameter data type should I use? >> I tried adLongVarChar and adVarChar with the sizes 1000, 32000, 1000000 and they all fail. Size of returned value will exceed 50k. >> I know tha...more >>

DataSet killed the Custom Object Model???
Posted by Shannon Richards at 10/5/2004 9:01:09 PM
Hello: I am building a new application and I am investigating data tier options and find myself torn between two approaches: 1) Building a "custom object model" (Collections and Collection items: example: CustomerCollection containing Customer objects) that uses data readers to retrieve da...more >>

Column required???
Posted by nielsh NO[at]SPAM hollandridderkerk.nl at 10/4/2004 3:32:22 AM
Hello, When i crate a database (mdb) with a table, the columns in the table are set to required. So when i want to insert data into the first column and leave the rest of the columns empty, i get an error. For creation of the database i use the following code: ///Code/// Dim tbl A...more >>

Unable to log into the database
Posted by Robert Bravery at 10/1/2004 9:41:10 AM
Hi all, I am using VS.net 2003, and VB. I am new to VB programming. I am trying to connect to a database on a server on our network. There are two databases one is Interbase, and the other is MYSQL. Both are being accessed via odbc. I can open the connections in the server explorer connect to...more >>


DevelopmentNow Blog