Click here to Skip to main content
14,240,705 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hi ..

Please modify the code .. i want to convert the datatable result into the list ..

the following is my code ..

 public List<test> GetData(string id, string Name)
            List<test> list = new List<test>();
            test objTest = new test();
            SqlConnection conn = new SqlConnection();
            conn.ConnectionString = "Data Source=localhost;Initial Catalog=test;User ID=sa;Password=*********";
            string myQuery = "select * from Rest";
            SqlCommand myCommand = new SqlCommand(myQuery, conn);
            SqlDataAdapter da = new SqlDataAdapter(myCommand);
            DataSet dt = new DataSet();
            da.Fill(dt, "Rest");
            int count = Convert.ToInt32(dt.Tables[0].Rows.Count);
            DataTable dtt = dt.Tables["Rest"];
            // How to add the datatable to list

           return list;

Help me

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

If you have a look at the Alternative posted to this tip: Converting a List to a DataTable[^] there is an extension method that converts table -> list.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100