Bill,

The UPDATE statement is automatically generated the first time you run a SELECT with the object in question. So, let's say the first time you run a GetDataSet it's for a lookup or any other query that doesn't involve the PK field(s) for that table, the UPDATE statement will be lacking information it needs.

To get around this, use the UpdateSelectStatement property:

//Just an example.  You may not need all fields here.
this.UpdateSelectStatement = "SELECT * FROM YourTable";

Hope that helps,
---J


>I think I got the data stuffing working, but when I try to save the dataset it is throwing an error:
>
>Exception Details: System.InvalidOperationException: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.
>
>
>
>>>Nope!
>>