绑定: SqlConnection conn = new SqlConnection(); conn.ConnectionString = "server=.;database=Test;uid=sa;pwd=accp5.0"; SqlDataAdapter da = new SqlDataAdapter("select * from Users", conn); DataTable dt = new DataTable(); da.Fill(dt); dataGridView1.DataSource = dt;更新: SqlConnection conn = new SqlConnection(); conn.ConnectionString = "server=.;database=Test;uid=sa;pwd=accp5.0"; SqlDataAdapter da = new SqlDataAdapter("select * from Users", conn); SqlCommandBuilder scb = new SqlCommandBuilder(da);
现在我做的是这样的:在窗体加载的时候对 DataGrid控件进行数据绑定,然后再在按钮事件中进行更新操作,现在我郁闷的是每次更新只能进行一次,当我想第二次更新就不起作用了,只有等我把窗体关闭才能重新进行更新操作!
究竟该怎么改?
你们看看我的代码:
/// <summary>
/// 初始化DataGrid数据
/// </summary>
private void DataGridDataInit()
{
string MySQL = "Select * from Book";
ds = new DataSet();
cmd = new SqlCommand(MySQL,sqlconnection);
sda = new SqlDataAdapter(cmd);
cmb = new SqlCommandBuilder(sda);
sda.Fill(ds,"Book");
dg_Book.DataSource = ds.Tables[0];
}
/// </summary>
/// 更新修改后数据
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Save_Click(object sender, EventArgs e)
{
if(MessageBox.Show("确定保存所进行的修改吗","提示",MessageBoxButtons.YesNo,MessageBoxIcon.Question)==DialogResult.No)
return;
try
{
int MyCount=sda.Update(ds,"Book");
string MyInfo = "更新成功" + MyCount.ToString() + "条记录!";
MessageBox.Show(MyInfo,"信息提示!",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
catch (Exception exp)
{
MessageBox.Show("保存失败!" + exp.Message);
}
}
其中DataGridDataInit()在Form_Load事件中调用。
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=.;database=Test;uid=sa;pwd=accp5.0"; SqlDataAdapter da = new SqlDataAdapter("select * from Users", conn); DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;更新:
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=.;database=Test;uid=sa;pwd=accp5.0"; SqlDataAdapter da = new SqlDataAdapter("select * from Users", conn);
SqlCommandBuilder scb = new SqlCommandBuilder(da);
DataTable dt =(DataTable) dataGridView1.DataSource;
da.Update(dt);
你看看我代码,在我的代码的基础上改改。
看是什么问题?
发给小弟学习学习,不甚感激!涌F相报