DataGridView增加,修改,删除数据

1、 保存DataGridView所做修改方法

/// <summary>
/// 保存DataGridView所做修改
/// </summary>
/// <param name=”sql”></param>
/// <param name=”myConn”></param>
/// <param name=”dg”></param>
/// <returns></returns>
public bool UpdateDataGridView(string sql, SqlConnection myConn, DataGridView dg)
{
bool result = true;

try
{
DataTable dt = new DataTable();

SqlDataAdapter ada = new SqlDataAdapter(sql, myConn);
SqlCommandBuilder cb = new SqlCommandBuilder(ada);

dt = ((DataTable)dg.DataSource).Copy();

ada.Update(dt);
dg.Update();
dt.AcceptChanges();
}
catch
{
result = false;
}
return result;
}
２、调用

public partial class frmExpInfoMangent : Form
{
eCMy.DataAccessLibrary.Data.Database ecMy;
SqlDataAdapter adpOrders;
SMSMangent mySms = new SMSMangent();
System.Data.Common.DbConnection myDbConn;

string strSql = “select [ExpenseID] as f_id,substring(cast([ExpenseID] as varchar),1,len([ExpenseID])-3) as f_front,expensemc as f_name,userid from eCBMExpense “;

public frmExpInfoMangent()
{
InitializeComponent();

ecMy = eCMy.DataAccessLibrary.Data.DatabaseFactory.CreateDatabase();

myDbConn = ecMy.CreateConnection();
}

private void BindData() //帮定数据库数据到DataGridView显示
{
this.dataGridView1.DataSource = ecMy.SimpleExecuteDataSet(” select [ExpenseID] as f_id,substring(cast([ExpenseID] as varchar),1,len([ExpenseID])-3) as f_front,expensemc as f_name,userid from eCBMExpense “).Tables[0];

}

private void frmExpInfoMangent_Load(object sender, EventArgs e)
{
BindData();
}
}