We are using SQL Server 2005 with stored procedures and trying to develop using typed datasets. If I add a typed dataset with a select and say an insert stored procedure �and then later on I add a delete stored procedure �I don’t seem to get the delete method unless I start from scratch with the typed dataset and add a select, insert, update and a delete stored procedure all at the same time. If I drag a table onto the designer of the dataset and then choose my select and insert stored procedures as above, I am unsure as to the correct way about adding a new row to the DataTable.

DataSet.TableAdpater.DefaultView.AddNew();
BindingSource.ResetCurrentItem();
BindingSource.EndEdit();

When calling the fill method on a dataadapter it tells me that updated_by doesnt allow nulls - I only want to select in this instance I am not calling Insert or Update and thats confusing.

I have looked through several books and online documentation and not really found anything which covers using tableadapters in much detail �the examples seem very basic indeed.

I’m really looking for advice on adding a new row, rebinding the new row, deleting a row and examples on what Methods to use and why as there are so many that look like they do what I need but dont.

Thanks Gregor