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?

Hi,

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

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"ad" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?
>