If I have this:
Dim myTable as new DataTable
Dim grid as new DataGrid
myTable = MyObject.GetTable1()

Hi, All,
In ADO.NET, when executing sql statement, the table will be locked.
Except for using "with nolock" in the sql statement to avoid locking
the table, is there any other ways that can get the same result?

I'm having a problem with a SqlException that I am serializing and
deserializing.  I do not know if this is the correct place to post,
but I thought someone might know.
A particular error that occurs, if the connection string does not pass

I am using a SqlCommand to perform an insert statement, after which to
return the ID (Idnetity field). However, it doesn't seem to work. Following
is the code which doesn't work. Can anyone point me where I did wrong?
Thanks.

Is there an easy way of reading names of tables in a database? I would like
to read all user tables from a SQL Server database and show table names in
a list (to let user select which ones to export). I use C#, ADO.NET and SQL
Server.

   Is there a way to implement dirty checking using databinding?  I've
tried handling the BindingManagerBase.CurrentChanged event, but it only
fires after the user moves focus away from a control with changed text,
instead of firing when the user begins to type a new value into the ...

I have to display columns from multiple database tables in a grid.  I have
been able to 'query' back a single DataTable using a custom SELECT (so I
have this DataTable in a DataSet).  The DataSet binds to the grid fine.
The problem is in the UPDATE.  I would like to the use the

People ...help me. This seems simple but yet I cannot update the table. I
can see the change in
the dataset when I display it on the datagrid. But all fails when it
executes the last line....... I cannot get it

This is the error message I receive every time I run the program.
An unhandled exception of type 'System.InvalidOperationException' occurred
in system.data.dll
Additional information: Update requires a valid InsertCommand when passed

I sporadically get the following problem when running asp.net applications
with the Data Application Block:
Configuration Error
An error occurred during the processing of a configuration file required to

If I would like to use connection pooling in the web application that I am
making, do I need to explicitly code it, or does it just magically happen
behind the scenes?
Do I have to use ADO.net in any particular way to make sure that it happens?

I can't execute ExecuteNonQuery if I use an parameter OracleType.Timestamp.
I have an User object with a field that store the timestamp from the row. Te
field is DataTime type, and on the database (Oralce 9.2.0) it's Timestamp.
The code to do the update is:

Hi, i'm developing a smal program to insert records in a ORACLE Database, but my client has a sequence fort the PK of the table, how do i get the value generated by the sequence? Without this value i can't insert child records..
Thanks

I am having a really strange problem with reading cursors from an Oracle 9i
database for a "particular" procedure. My DataReader does not contain any
rows after I execute the command object. I have tried
cmd.ExecuteReader

I am a totally newbie to .NET, so first of allI would like to ask you some
tutorial URL-s. :).
My problem is that I have to show a list of orders with lines where I
summarise the value of them by the sorted column. So if the sort is by