private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("server = USER-20150322KM;database = huanghe;uid = sa; pwd = 121212");
SqlDataAdapter sda = new SqlDataAdapter("select * from 表1",conn);
DataSet ds = new DataSet();
sda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
和
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("server = USER-20150322KM;database = huanghe;uid = sa; pwd = 121212");
SqlCommand cmd = new SqlCommand("select * from 表1",conn);
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataSet ds = new DataSet();
sda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
有什么区别?两个输出的结果是一样的啊。还有 sda.Fill(ds);这行, sda.Fill(ds);和 sda.Fill(ds,"表1");结果也是一样的啊。晕了。求大神指教
因为你是按索引取的,如果你按名字取,就不一样了
你取的是ds.Tables[0],取第一个表,不管表名是什么,所以都一样