SqlCommandBuilder的运用
namespace WindowsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
string strUrl = "data source=syy;initial catalog=hterp;user id=sa;";
string strSql = "select * from ht_test";
DataSet ds = new DataSet();
private void Form1_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(strUrl);
SqlDataAdapter da = new SqlDataAdapter(strSql, conn);
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(strUrl);
SqlDataAdapter da = new SqlDataAdapter(strSql, conn);
SqlCommandBuilder sqlBuilder = new SqlCommandBuilder(da);
da.Fill(ds);
da.Update(ds.Tables[0].GetChanges());
ds.Tables[0].AcceptChanges();
}
private void button2_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(strUrl);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(strSql, conn);
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
}
}