有时我们需要将将dataGridView内容放入DataSet或DataTable中,应用:
DataTable dt = (DataTable)dataGridView1.DataSource;或 DataTable dt = dataGridView1.DataSource as DataTable ;
应用后dt中为空值,主要是因为没有将dataGridView1.DataSource绑定DataTable ;
应用时:
private void Form1_Load(object sender, EventArgs e)
{
try
{
openSql();
string strSql = "SELECT * FROM tab where Name='张三'";
SqlDataAdapter s = new SqlDataAdapter(strSql, strCon);
s.Fill(dt);
dataGridView1.DataSource = dt;//绑定
}
catch (Exception ex)
{
throw ex;
}
finally
{
closeSql();
}
}
private void button2_Click(object sender, EventArgs e)
{
DataTable dt1 = dataGridView1.DataSource as DataTable ;
}