I am executing a batch of insert statements (inserts data to 10 tables)
using SqlCommand - ExecuteNonQuery().  Some of the insert fails even though
the insert query is right.  
This happens not all the time but once in a while.  so it makes difficult

I'm getting said error on the line Do While reader.Read()
Looks like reader is defined to me.....so I'm lost....
This is for role based security, and this sub is in Global.asax if it makes
any difference.

I know I can do this if I'm using a real database and queries.  I don't
want to assume the presense of a decent engine on people's machines so
I'm trying to use just the .Net Framework (ie: DataSet).
Among many other tables/fields/etc. I have...

Hi
we have Windows Applcation with sql server 2000.i want to enable connection
pooling in database for best perfomance.
i added connection string in app.config this

I have an ODBC connection (to Perforce) using a System DSN. In a console app
I can open the connection, in an ASP.Net webform I can't, and get the error...
[OdbcException: ERROR [HY000] [
ERROR [HY000] []

I am debugging a stored proc inside the IDE which is great.  However,
the stored proc dumps some data into temp tables. Is there a way to see
the contents of the temp tables while in debug mode?
Thanks

Does anybody know how to use power raising in a datacolumn expression ??
Example:
NewColumn = FirstColumn ^ 1.2345
or

According the MSDN documentation on the SqlDataReader.Close method, it says
that:
The Close method fills in the values for output parameters, return values
and RecordsAffected, increasing the amount of time it takes to close a

If I call the Prepare() method on a SqlCommand object, does it apply only to
that instance of the SqlCommand object or to the SqlConnection instance?
Also, I am assuming that Prepare() will aid in performance when calling the
same query multiple times.  Is this true?

I am looking for C# code that will allow me to take an ADO Recordset
previously persisted to a file as XML and convert it to a Dataset.  I
have seen some solutions but have yet to make any of them work.  Can
someone please help me with functional code?

I have a need to generate an XML based on a table in the DB.  The table
contains self-referential data, e.g. it has these columns
employee_id
employee_name

What is the future of SQL DMO?   Samples are available to interop DMO in C#.
There is no equivalent of SQL DMO in .NET world. Will it be part of ADO.NET
technology? What is the roadmap for DMO releases?
Another thing is SQL DMO is MS SQL server specific. How about other

Object reference not set to an instance of an object.
at System.Data.DataTable.RecordStateChanged(Int32 record1, DataViewRowState
oldState1, DataViewRowState newState1, Int32 record2, DataViewRowState
oldState2, DataViewRowState newState2)

I am planning to design a lightweight dataset, any links or any pointers will
be helpful.

I have a small prob, so pls help me to solve it.
I have 2 tables
Products(ProductID, ProductName, Price)
Stores(StoreID, StoreName)