I have a problem with an OLEDBConnection object that is supposed to serve for
a number of clients that need data from my Access(mdb) database.
These clients are placed in different threads and try to load data from this
connection. The problem is that when the connection is ...

MS SQL
here is what the connection string looks like (i changed the username and
password for security)
<add key="datasrc" value="Initial Catalog=db1;Data

For any of the microsoft guys :
Is there a way to tell ADO.Net to use a default value from the stored
procedure ?
I know the only way to do it is to not create the default parameter at all

I have a dataadapter where i have changed the insertcommand.commandtext to
have the following insert and select:
"INSERT INTO my_table (col1) values (@p1); select scope_identity() as pk"
I modify the dataset and perform an update on the dataadapter so the changes

Is it alright if I took a static class that wrapped around a
SQLConnection object on a web application? Or should I make it an
instance class?
If I have a static class, would there be just one code instance of the

How do you get the number of columns in a dataset?
I know that I can get the number of rows by:
DataSetObj.Tables(0).Rows.Count.
Also, how do I get the name of the column.  I can get to the data by name

Right now I have a vb.net windows form project that does a whole bunch of
things on the form.load event.  The problem with this is that the user does
not see the form until all the those things are done.
Is there a way for a form to be shown first AND THEN have it automatically

I'm trying to use parameterised stored procedures to select, and
eventually update, a sql server database. But i'm not sure i'm passing
the parameters correctly into the sp as no rows are showing in the
datagrid. Here's the code:

Hey Folkes:
I a general question regarding autonumbering.  I see a lot of posts with
people having trouble with inserting records with autonumber fileds. I see
people suggesting Scope_Identity() and @@IDENTITY and ways to prevent each

I've converted an old VB3 program that loops through the lines of a
text file, then uses that info to write to a database.  I use mostly
OLEDB DataAdapters, DataSets, and DataTables and Rows to insert/update
the database.  The problem is, this is extremely slow (with one

i have some modules in my app.. reads data (always)
i am using datareader and should i set any transaction and isolation level
so that
like specified in MSDN, lower isolation level will give lot of performance..

    I am new at this group/forum. I am a .Net Programmer from Manila,
Philippines.
I like to ask anyone who can help me how to use mySQL database in
programming Visual Studio .Net Smart Device Application (.Net Compact

Like the dataset, is the datareader also a disconnected datasource? It
doesn't look like because of two reasons:
(1) It is forward only. Having a connected stream would make more sense
to reflect recent updations to the original database from other

What's a better way to add a new row to a table:
(1) An Insert SQLCommand object? or;
(2) Through the DataRows collection doing it manually and then calling
Update on the Adapter?