I am using a datagrid to write data to the database. I am using the
walkthrough by msdn "Using a datagrid to Read & write data to Database". But
when i hit the update button I get the following error: :
Object reference not set to an instance of an object.

I want to update MultiDatabase with Microsoft's MSDTC.Just like ADO.Net
provided,
I designed an interface below:
public interface IDistributeTransaction

Anyone who knows how to fill more than one datatable in a single fill using
a dataadapter? I have 4 joined tables in a select-statement that I want to
fill into their datatables. Now I have to make 4 selects to do that, and
that's no good. Alternatively make a datatable ...

I have an ASP.NET application. I need to read records from the SQL database
based on a value entered by the user. I need to get the result in Text boxes.
I am using DATA READER for this.
But how can i view the next record from the database in the text boxes?? I

I am using the ExecuteReader method from the Microsoft DAAB to return a
DataReader which I am iterating through to mainly read a binary value from
one of the returned columns. I am using this value as the raw data to render
a PDF document. After this is successful, I want to ...

Hi, Our database is constantly updated (input data) from another DB, and
sometimes it crashes our ASP.NET applications. My boss told me to write a DB
utility app to check DB and make sure all apps are still running.
The first step of few checks is to compare current DB tables ...

I'm using connection pooling (0 min/100 max) in an asp.net
web application. All users log in using the same
connectionstring.
Is it prudent, for instance, to close and dispose of my

Is it possible to create the DataSet object out of SqlDataReader object?
Thanks.
Vijay K Kerji

Is it possible to add a column to an existing DataTable (in a DataSet) with
the new column being some place other than the end of the column collection?
I looked at Columns.Add and there is no position parameter and there is no
InsertAt method like some other collections.

I have a situation where I have two datasets each equal with the data
from the same table. I want to update one dataset with the records
from the next dataset IDs in tact. Here's the code I have:
' Set AcceptChangesDuringFill = False

I have a windows service that will insert records into an Access database.  Or at least that's the idea.  The insert isn't happening, but the code runs without raising any errors.  When I run the generated sql statement from a query window in Access, the record inserts just fine. ...

Can we get SPID from the SqlConnection in ADO.NET?
If yes,
      how do we get it?
Else

In VS.Net Server Explorer, you can drill down to a SQL Server store procedure
and finally, it diplays not only parameter of the procedure but also the
result columns.
How can I replicate this behaviour in my application?

I am trying to execute several DML statements in a single call to an ADO.NET
SqlCommand object, ie.
update table1 set column1 = x
update table2 set column2 = y

The module to connect to Oracle works fine for the vb.net application
but not for vb.net windows service..
Gives error..TNS service name could not be resolved. Ora12154.
*-----------------------*