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?

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);

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);

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

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

Answers

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

Abhilash J A

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?

Answers (4)

Next Recommended Forum

What are the differences and similarities of Get and Head ?

zoom in and zoom out in iframe

Leaderboard

View all

Netaji Junghari

+79

George

Lokendra Singh

-1

View all

Yesterday's leader

Netaji Junghari

Bangalore (India)

897

103.7k

852

Member of the month

Shafaet Hossain

C#, .NET, ASP.NET, Blazor

Dhaka (Bangladesh)

711

9.7k

1.3k

Speaker of the month

Shubhankar Banerjee

Blockchain, Solidity, Polygon, C#, NodeJS, HTML, C Language, C++, JavaScript, CSS, ReactJS, MySQL

Kanpur (India)

156

117.7k

11.8k

500

Upcoming events

View all

Suggested for you

View all

Aymen Amri

Mohammad Rabie

Abhishek Singhal

Diptiranjan Sutar

Rinki

Forum Statistics

Please welcome our newest member Nimblesite Pty Ltd.
3,078,320 users have contributed to 147,418 threads and 483,404
In the past 24 hours, we have 6 new threads, 25 new posts, and 68 new users.
In last week, the most popular thread is 'Get 24 months rollover value from database'.