How to change rowstate of DataRow

[ad]

When we create a DataSet by Select command like:
//--------------------------------------------------------------------
SqlCommand myCommand = new SqlCommand("SELECT * FROM Suppliers",
myConnection);
myCommand.CommandType = CommandType.Text;

myAdapter.SelectCommand = myCommand;
ds = new DataSet("Customers");
myAdapter.Fill(ds);
//--------------------------------------------------------------------
The RowState of every rows in the dataset is Unchanged.
I want to change the RowState of every rows to Added.
How can I do that?

 

[Miha Markic [MVP C#]]

Hi,

One way would be to set
myAdapter.AcceptChangesDuringFill = false;