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

Question

I have a dataset that contain list of rows. I want last row from the dataset. Then asign this dataset to datatable. DataTable dt = (DataTable)ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]; How to solve this error?

Manas Mohapatra · 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);

Manas Mohapatra · Answer

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 Menoth · Answer

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

Mani Kandan · Answer

Hello Manas I have done that but this error occured { This row already belongs to another table. }