it seem that data table and Expression field have a lot of Laks, it is
true?
the DataTable is powerfull of Memory relation data that bind to
controls.

A concept I've waffled on from time-to-time with ADO.Net: how often to
submit updates back to the database. For example, I have some CF apps where
it's quite obvious the *when* part of submitting the update -- soon as you
come off of the record. For other desktop apps, it's not ...

(VB Exoress 20005)
I get an exception on this line :  ra = myCommand.ExecuteNonQuery()
{"ExecuteNonQuery requires an open and available Connection. The
connection's current state is closed."}

Where does the datareader store it's data in this scenario:
Create sqlconnection,
Create sqlCommand - query specified here could return 1000 rows
SqlCommand.ExecuteDataReader, returns datareader

How do most people support multiple database types such as SQLServer,
Oracle, Access, etc.? Mainly I am wanting to just support MS (SQLServer and
Access) but may need others in the future.
I am currently looking at creating a simple class that has a few methods for

I'm trying to create a SqlServer express database file on the fly in a web
application..
(mhh.... maybe I should try to get something running in a desktop
application first?)

Is there a trick to keeping a Typed DataSet in sync with the underlying
database other than either manually making the changes or deleting and
adding the table back?
For example, I've created a Typed DataSet with about 10 tables, each table

Hi everyone(happy new year!!),
Well, here we go... I have a problem with datsets, ado.net as i
understand ..I have a sp that in query analizer retrieve 13 columns and
the last 3 like the others have data, but when i see the dataset which

  Can anyone point me to step by step walk-throughs of ADO.NET code - I'd
like to get to the point of being able to programmatically work with
assigning field data to text boxes and then write back changes to the
tables.

How to pass the content of one data table to another data table.I simply
tried using assignment operator...Example: datatable1=datatable2...But,its
not working..
ravindra

I have an sql server on seperate system and my application runs on another
dedicated server - both the machines works on Windows 2003 server OS. From
last 2-3 days one of the .net application which has been working fine for the
last 1 year suddently start giving timeout error ...

I seem to recall, back in the early promise days of Whidbey, that there was
talk (and even an early version) of a set of classes for mapping data
between objects and a database being a part of the release; alas I cannot
remember its name.

I am using VisualStudio 2005 (C#) and have to write a code to access
Oracle Database.  I know that in .NET Framework 1.1, I could download
OracleClient namespace (System.Data.OracleClient.dll) and add
referenct to it in my project.

I have an application that connects to sql server.  Two installs of the
application are frequently experiencing the following error:
"System.InvalidOperationException: Timeout expired."  We've checked and
confirmed that all connections are closed and disposed.  The two sites that ...

Using VS2003 and SQL2k.
I've noticed that if I have an expression column (or relation column) added
to the main table, I cannot do an Update without setting the
UpdatedRowSource to either OutputParameters or None. This works fine ... so