sqlconnection con = new sqlconnection(连接); sqldataadapter da = new sqldataadapter("select * from table",con); dataset ds = new dataset(); da.fill(ds); ds.table[0];//这就是datatable
for (int k = 0; k < dataSet.Tables[0].Rows.Count; k++) { DataRow dr = dt.NewRow(); dr.ItemArray = dataSet.Tables[0].Rows[k].ItemArray; dt.Rows.Add(dr); }
DataTable dt = new DataTable(); SqlConnection sc = new SqlConnection(连接字符串); SqlDataAdapter da = new SqlDataAdapter("select * from table", sc); da.Fill(dt);
sqldataadapter da = new sqldataadapter("select * from table",con);
dataset ds = new dataset();
da.fill(ds);
ds.table[0];//这就是datatable
{ DataRow dr = dt.NewRow();
dr.ItemArray = dataSet.Tables[0].Rows[k].ItemArray; dt.Rows.Add(dr);
}
SqlConnection sc = new SqlConnection(连接字符串);
SqlDataAdapter da = new SqlDataAdapter("select * from table", sc);
da.Fill(dt);