Please modify the code .. i want to convert the datatable result into the list ..
the following is my code ..
public List
{
List
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
VulpesPosted Sep 14, 2011, 9:18 AM
vinnuPosted Sep 14, 2011, 9:03 AM
but i have to convert to
list
i dont know how ...?
Prabhu RajaPosted Sep 14, 2011, 8:55 AM
// Assuming there is a DataTable called dt
List drlist = new List();
foreach (DataRow row in dt.Rows)
{
drlist.Add((DataRow)row);
}
----------------------------------
If this post helps you, then mark as "Correct Answer"
Thank You