vinnu

vinnu

  • NA
  • 61
  • 202.2k

Convert datatable into list

Sep 14 2011 8:47 AM
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;}
Help me

Answers (3)