Click here to Skip to main content
15,881,867 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi ..



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

the following is my code ..

C#
 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

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.
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900