Hi All!!
I occasionally get this error
--------------------------------------
System.NullReferenceException: Object reference not set to an instance of an

We use sql and like the way we can create a window,
have the .NET ide find a datatable,generate a connection,
generate a sqladapter, and generate a dataset tied to
that adapter. We also like the way that the .NET ide

I have a dataset which has received its data from a remote web service. How
can I now save the dataset into a local access table?
Thanks
Regards

I was wondering if you can format currency values in a datalist? I have
tried many ddiiferent ways to do this and all have given me errors.
Sean - thanks in advance
<%# DataBinder.Eval(Container.DataItem, "listprice")%>

datagrid doesn't reflect addnew to dataset
I have a form which includes a currency manager (cm), a dataset with one table, and a set of controls that shows the table one row at a time.  The buttons allow edit, delete, addnew, update the dataset, and submitchanges (update the ...

I have an ActiveX control in my web page and the control doesn't install on
a XP machine. It works fine on Win2k pro. The warning dialog box does appear
on both machine and does allow yes to be clicked.
NOTE: <object tag> is used just for this posting because I couldn't use the

What is the best way to test to see if a MS SQL DB is running?  Does it
throw a specific error when trying to connect to it that I can catch?  I am
trying to design my application if the db server is offline to save the db
info locally.  Any ideas?

Let me first say that I'm pretty new to ADO.NET.
I have an application where extra data needs to be added to additional
columns in a dataset that do not come from a database.
Example:

When you set up a DataRelation, does the data need to already be present in
the table, or will it query dynamically to fill up the data to fulfill the
relationship?
eg.

this is the piece of code that if giving problems right now;
cnSQL = New SqlConnection(ConnectionString)
**** strSQL = "UPDATE tb_product SET (ProductID = @cProductID, Code = @Code,
ServiceName = @ServiceName, Price = @Price " & _

I am using the following code to format a DataGrid:
aGridTableStyle.MappingName = "schedule"
       With acol1
           .MappingName = "Week"

In normal asp i used
---------
objRS.Open "tbl_Nieuws", objConn, 1, 3
objRS.AddNew

I have a method that constructs a dataset and sorts table 0 in it
through Table(0).DefaultView.Sort. I need to find a certain row in
this sorted dataview, and have the following code.
My problem is that I get an exception on the call to Find() telling me

I use the example for "WindowsIdentity.Impersonate" to impersonate a user.
This works fine, but if i try to connect to the SQL-Server via trusted
connection (Security=SSPI) the connection is using the _actual_ but not
the impersonated user.

I am getting a dataset from a remote web method. I need to get the data in
the dataset into a local access table. Here is how far I have gone;
Dim ws As localhost.MyService
Dim ds As DataSet = ws.MyMethod