cannot convert type 'datarow ' to 'datatable.' c#

Accepted answer

A DataRow can only be in one table at a time. If you want the same data in more than one table, you will have to copy the data into a new DataRow and add the new row instead. Follow below code:

DataSet ds = new DataSet();
DataRow drow = (DataRow)ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1];
DataTable dt = new DataTable();
dt.ImportRow(drow);
//Or
dt.Rows.Add(dr.ItemArray);

Abhilash J A9y ago

Hello Manas,

I have done that but this error occured,

{"This row already belongs to another table."}

Manas Mohapatra9y ago

Try like below:

DataSet ds = new DataSet();
DataRow drow = (DataRow)ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1];
DataTable dt = new DataTable();
dt.Rows.Add(drow);

Rajeesh Menoth9y ago

Hi, Code : DataRow lastRow = yourTable.Rows[yourTable.Rows.Count-1]; Please check the following reference : http://stackoverflow.com/questions/18528736/how-to-retrieve-values-from-the-last-row-in-a-datatable