Question

在C#中怎样把sql查询的结果存放到datatable里？困扰我好久了，希望高手能把代码写出来 万分感谢

for(int i=0;i<dt.rows.count;i++)
ye[i] = dt.Rows[i]["SQYE"].ToString()

类似这种形式的

Answer 1

public void getdate()
{
try
{
SqlConnection sc = new SqlConnection("Data Source=.;Initial Catalog=databaseName;Persist Security Info=True;User ID=sa;Password=sa");
SqlDataAdapter sda = new SqlDataAdapter("select * from t6", sc);
DataSet ds = new DataSet();
sda.Fill(ds, "ctlm06");
DataTable dt = ds.Tables[0];
GridView1.DataSource = dt;
GridView1.DataBind();
}
catch
{
//
}

}