How to delete all rows in a dataSet, Update problems

  • Thread starter Thread starter rdt
  • Start date Start date
R

rdt

In ASP.net

Is there a way of deleting all the rows in a table in the dataset.

In regards to deleting all the rows is there a Delete/Remove function
similar to the simple update function of an DataAdapter
i.e objDataAdapter.Update(objDataSet, "TableName")?


In relation to updating is there anyway to update into a column with spaces
in its name using the simple update function - i.e objDataAdapter.Update
(objDataSet, "TableName")

Also is there a way finding out how many rows in a dataset?

Thanks
 
rdt said:
In ASP.net

Is there a way of deleting all the rows in a table in the dataset.

In regards to deleting all the rows is there a Delete/Remove function
similar to the simple update function of an DataAdapter
i.e objDataAdapter.Update(objDataSet, "TableName")?
Click to expand...

Use exactly the same thing, having deleted the rows from the tables -
and make sure your data adapter has a delete command.
In relation to updating is there anyway to update into a column with spaces
in its name using the simple update function - i.e objDataAdapter.Update
(objDataSet, "TableName")
Click to expand...

Yup, just make sure the command has the table name in quotes or in
square brackets or whatever your database requires.
Also is there a way finding out how many rows in a dataset?
Click to expand...

int total=0;
foreach (DataTable table in dataSet.Tables)
{
total += table.Rows.Count;
}

(Or something very similar - that's off the top of my head.)
 
Back
Top