Rex,
It's kinda screwy the way it works ... not only do you have to use .NewRow, but you also have to do an Add after.
DataRow row = objDataSet.Tables(TableName).NewRow()
-- do stuff with your row object, then add to the Rows collection
objDataSet.Tables(TableName).Rows.Add(row)
Seems silly to me to have to do it that way, but ... there it is ....
HTH,
~~Bonnie
>All,
>
>I have a blank DataTable (TableName) in a DataSet (objDataSet) to which I want to add an empty row. I filled the DataSet from a parameterized select statement with a parameter value which cannot be in the table. I check for the existance of the table before I try to add a new row. I use the following comamnd:
>
>objDataSet.Tables(TableName).NewRow()
>
>After the above is executed I check the rowcount and it is still 0. I have placed the command in a Try block, and no errors were caught.
>
>What am I doing wrong?
>
>TIA
>
>Rex