//绑定数据库信息
public void info()
{
set = new DataSet();
adapter = new SqlDataAdapter("Select * From [temp]", conn);
adapter.Fill(set, "temp");
dataGridView1.DataSource = set.Tables["temp"];
}
//修改控件
private void button1_Click(object sender, EventArgs e)
{
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
adapter.Update(set, "temp");//修改表格信息传递到数据库
info();//重新刷新表格信息
}