all groups > dotnet ado.net > december 2003 > threads for friday december 26
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Refer to the field by name???
Posted by Frank Rizzo at 12/26/2003 10:02:20 PM
I have the following code:
SqlDataReader dr;
SqlCommand sc = new SqlCommand("SELECT * FROM Articles", oConn);
oConn.Open();
dr = sc.ExecuteReader();
How can I now refer to the fields in the SqlDataReader by name, like
dr.Fields("Title") or something like that.
Because the only thing I ... more >>
Autonumber issue with Jet, ASP.Net, C#
Posted by johnmark1515 NO[at]SPAM yahoo.com at 12/26/2003 7:28:39 PM
Please take a look at this code. When the delegate fires, the debug
statements show the correct values (when not commented out). However,
the fields are not getting updated in my database. I want to capture
the autonumber field when it is created and use it's new value as part
of the HREF fie... more >>
OleDbDataReader failure
Posted by Don at 12/26/2003 3:19:39 PM
here is a snipet of code i am using
Dim myConnection As New OleDbConnection
("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=c:\customers\other\g2.mdb")
Dim myCommand As New OleDbCommand("SELECT * FROM catalog
numbers", myConnection)
myConnection.Open()
Dim myReader As OleDbDataReader = my... more >>
view connection pool/open or used connections?
Posted by DraguVaso at 12/26/2003 11:50:12 AM
Hi,
I had an error concerning the connection-pool: "Timeout expired. The
timeout period elapsed prior to obtaining a connection from the pool. This
may have occurred because all pooled connections were in use and max pool
size was reached." (in VB.NET).
I was already able to solve the pro... more >>
Retrieving DB2 Identity back to Dataset
Posted by Vince at 12/26/2003 9:36:10 AM
Hi,
I have a database table ("Users") in a IBM DB2 database. The table primary key is auto incremented. The PK column is called UserID.
When I do an update of my Users dataset back to the database, how do I get the newly generated primary key(s) back to the UserId column of my dataset?
Any ... more >>
|