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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|