I'm sure i've just overlooked something obvious, or, could this be the way
it was designed?
I've got a Strongly-Typed DataSet with three tables, two of the tables are
children of the same parent (relationships are defined).  Let's call them

I have a problem with the sql update command generated by
SqlCommandBuilder
when the select command's FROM clause specifies a view. It generates
the

Hi and thanks in advance,
I am getting a violation of PRIMARY KEY constraint exception when
calling update on a data adapter, after using LoadDataRow(). This is
what I am doing:

Hello, here's my testing code:
string dbConnStr = "*connstr*";
string sqlQuery;
OleDbCommand myCommand;

I have a datagrid that is bound to a dataset and the dataset is not tied to
a
database (so deleting the record in the db and re-filling the datatable
doesn't work). I have a linkbutton column defining a "delete" event. So

Does setting EnableViewState=true of a dataGrid sent the entire contents of the grid across the wire ?
If so I want to set it to false. But then does my sorting-functionality not work anymore ??
How come ?
Thanks

In a VB.NET-application I use this to open a Database Connection:
   Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
       Dim strConn As String

I'm conneting my dataset to an Access MDB file using the Jet 4 OLE
connector.
I read in my data using:
oleDbDataAdapter.Fill(myDataSet.E);

How looks remote Access 2000 connection
string. Database is placed on another computer,
WWW serwer and i would like to connect
to it from client machine.

I am using the code below to create a new dataset, add a new table to it
called "Inventory" and then add a new row to the table with some data in it.
I am using this to create a temporary dataset so that I can bind a datagrid
to it. All goes well until I try to update it. When it ...

  When I execute a INSERT statement this error is display: "Operation must
use an updateable query"
The Server is a Windows 2003
The users of ASP.NET and IU_...... is in Administrators groups!

I can't to bring ADO.NET to work normaly with FoxPro 8 OLE DB provider and
FoxPro 6 data tables. Error ocure when I try to implement
OleDbDataAdapter,generate a simple SELECT statement, using wizard. Error
like this:

I have this connection string "data source=SRVSQL;initial
catalog=Domain\test;password=passw0rd;persist security info=True; user
ID=test;packet size=4096".
With this I get Login failed for user Domain\test.

Can a typed DataSet be made in code so that code that comes after the type
code will pick up on the dataset's table structure for intellisense?

I'm trying to create my database using a batch of SQL commands via
ExecuteNonQuery().  The SQL batch should create the database and then
all the tables to go into it.  The start of the script is as follows:
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name =