保存GridControl中修改的数据

保存按钮事件

private void bbiSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
gridView5.FocusedRowHandle = gridView5.RowCount;    //不知道为什么一定要加这一行才能保存数据，有知道的高手请赐教。
try
{
using (SqlConnection conn = new SqlConnection(strConn))
{
using (SqlDataAdapter sda = new SqlDataAdapter("Select EmployeeID, EmployeeName, Gender,Phone, BirthDate, EAddress, Photo, School, Memo from Employee where 1=0", conn))
{
conn.Open();
SqlCommandBuilder sqlcmdBuilder = new SqlCommandBuilder(sda);
sda.Update(objDataSet.Tables["Employee"]);
}
}

MessageBox.Show("保存成功!");
}
catch (Exception ex)
{

MessageBox.Show("保存失败!原因:"+ex.ToString());
}
}

 

填充网格方法

private void FillGridControl5()
{
thisDataAdapter = new SqlDataAdapter("Select EmployeeID, EmployeeName, Gender, BirthDate, Phone, EAddress,Photo, School, Memo from Employee", strConn);
SqlCommandBuilder sqlcmdBuilder = new SqlCommandBuilder(thisDataAdapter);
thisDataAdapter.Fill(objDataSet, "Employee");

gridControl5.DataSource = objDataSet.Tables["Employee"];

}