Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
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
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008


all groups > dotnet ado.net > april 2004 > threads for monday april 12

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

ADO.net and Record Locking
Posted by mbs at 4/12/2004 8:51:17 PM
I am switching to ADO.net from DAO and have a question. How do you handle record locking with a Dataset which is disconnected from the Database? Do you just test to see if the data in the Database has changed before you write the data in the Dataset back to the Database? mbs ...more >>

SQL SELECT statement
Posted by Tom McLaughlin at 4/12/2004 7:42:50 PM
I'm having a problem understanding the syntax of the SQL SELECT statement in Visual Basic. Can someone point me to some examples. Thanks Tom ...more >>

Oracle Configuration
Posted by Jim Heavey at 4/12/2004 7:38:39 PM
Hello, I convinced my company to give .Net a try. I just got through installing VS.Net and all went well, but now I have to figure out how to configure VS.Net to access the Oracle Tables and I a little bit lost on how to do this. How do I get VS.Net to see my Oracle Tables? I configured...more >>

Bulk insert into Database
Posted by Baz at 4/12/2004 4:31:15 PM
Hi, I am designing an application that needs to do the following on a daily basis: - Parse XML files & extract relevant information. The number of XML files is in thousands... - Write the extracted information to a database. I was considering the use of Datasets for this application. Howev...more >>

Oracle ODP Strongly Typed DataSet (runtime)
Posted by kzimme at 4/12/2004 3:06:04 PM
I am trying to use strongly typed Dataset Objects in my project but I seem to be missing something I created a class library project named DSCommon. I then used the Server Explorer to create an XML Schema of my Oracle table and then I generated a DataSet (http://www.developer.com/db/article.php/1...more >>

OLEDB Erros Enums?
Posted by localhost at 4/12/2004 2:58:22 PM
I am looking for all of the HRESULT codes that ADO.NET might get from an OleDb provider error. For example, -2147217913 is a SP parameter error, -2147217871 is a connection timeout, etc. I want to trap for all possibilities in my ..catch{} block. Thanks. ...more >>

Resize datagrid columns?
Posted by emde at 4/12/2004 10:44:02 AM
Is there a way to have the datagrid columns auto resize with the data? Double clicking the columns will do this but I would like to do this for the user. tia ...more >>

datagrid dataset links
Posted by Andrius N at 4/12/2004 10:11:31 AM
I have a dataset with 5 fields, 4 displayed in datagrid .1 is hidden by this method as I dont need to display it: ds.Tables(0).Columns("id").ColumnMapping = MappingType.Hidden (also is there any other/better way to hide a column or size it to 0 width??) I want to retrieve this ID column v...more >>



How to export/import SQL Defs/Data
Posted by Donald Adams at 4/12/2004 9:46:41 AM
Any plugable options out there that I can use to export database/table setup and actual data to xml? Best yet, would be a .Net class that I could use to control the process for creating a setup file and then using my own install program to import the defs/data. Thanks in Advance, Donald Adam...more >>

Multiposting vs crossposting
Posted by Rob Richardson at 4/12/2004 8:27:31 AM
Cor, In a recent reply you wrote: "Please do not multipost, I answered this in the language.vb groups. Regulars in the dotnet newsgroups like it when you crosspost." I have seen you write similar things before, in which you say that multiposting is bad but crossposting is good. Could yo...more >>

connection.CreateCommand vs. new SqlCommand
Posted by Kevin Burton at 4/12/2004 8:01:09 AM
For a long time I have used CreateCommand to access stored procedures within our database. Now for performance reasons I would like to statically create the command with all of the parameters and just fill in the values at run time. This change requires me to switch from CreateCommand to new SqlComm...more >>

Return value from stored procedure questions
Posted by Anthony Reynolds at 4/12/2004 6:56:04 AM
I have a question regarding accessing a stored procedure's "return" value. Some of my SQL Server stored procedures return a result set. The only way I can see what the stored procedure return in the "return" value is by using the .ExecuteNonQuery command method. If I use the .ExecuteReader method...more >>

ADO error: Very Simple Question!!!
Posted by sajid_yusuf NO[at]SPAM yahoo.com at 4/12/2004 12:01:07 AM
Hello!, After I drag and drop ODBCDataAdapter on my form and reach the section (during the wizard) where you have the button for Query Builder. Just after clicking the Query Builder button I receive the following error message: ADO error: Multiple-step OLE DB operation generated errors. Che...more >>


DevelopmentNow Blog