I'm trying to convert a datatable into a datatablereader but i'm getting this error

DataTableReader is invalid for current DataTable

does everyboth nows about it

i'm running the simple command "

mydatatable.GetChanges(DataRowState.Added)

"

Hi, Mahesh819

You must do dataTableReader.Read(); first to get the record.

The code can be:

public void Execute()
{

using (DataTableReader dataTableReader = new DataTableReader(myDataTable))
{

if(dataTableReader.Read())

{
object[] values = new object[dataTableReader.FieldCount];

int fieldCount = dataTableReader.GetValues(values);
string id= values[4].ToString();
string Type = values[0].ToString();

}
}
}

If you have further problems, please feel free to let me know.

Thank you

Hi,

this is the definition from the msdn for the getChanges method

Gets a copy of the DataSet that contains all changes made to it since it was loaded or since AcceptChanges was last called.

Basically, it is fullfilled with only the changes that were done in the DataSet, in your case, where the RowState property of the columns is Added., so you can not get a DataReader from a Table using this method.

Then, remember that a DataReader is a connected object, so it needs a connection for working. so, you can not convert something is disconnected like a dataset and its datatables in a connected object.

What do you want to do

Best Regards

here is my situation...

I have to apply a filter....
Then i'm doing this...

DataTable blah = MyDataTable.Clone();
blah.ImportRow(MyDataRow);
blah.AcceptChanges();
DataTableReader Reader = blah.CreateDataReader();

When the method CreateDataReader is called the exception comes on my screen...

I'm lost...

Could you help me

I found the problem !!!
I forgot the method Reader.Read();

tks everyone