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>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)