将数据表转换为列表 [英] Convert datatable into list

问题描述

嗨..



请修改代码..我想将数据表结果转换为列表..

以下是我的代码..

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

推荐答案

如果您看到此技巧的替代方法:

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.

这篇关于将数据表转换为列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！