Click here to Skip to main content
14,212,526 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);
            myCommand.Connection.Open();
            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

           conn.close();
           return list;
}
</test></test></test>


Help me
Posted

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)



Advertise | Privacy | Cookies | Terms of Service
Web01 | 2.8.190619.2 | Last Updated 14 Sep 2011
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid

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