SqlCommandBuilder

 using System.Data;
using System.Data.SqlClient;

public DataView LoadData()
{
    try
    {
        using (SqlDataAdapter da = new SqlDataAdapter("select * from Provider", ClassConnection.Connection))
        {
            dataView.RowFilter = null; // 清除该筛选器。
            dataView.Table.Clear();
            dataView.Table.BeginLoadData(); // 在加载数据时关闭通知、索引维护和约束。
            da.Fill(dataView.Table);
            dataView.Table.EndLoadData(); // 在加载数据后打开通知、索引维护和约束。
        }
    }
    catch
    {
        MessageBox.Show("加载供应商信息失败！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
    }
    return dataView;
}

public bool SaveData()
{
    try
    {
        DataTable table = dataView.Table.GetChanges();
        if (table == null)
            return true;
        using (SqlCommandBuilder builder = new SqlCommandBuilder())
        {
            builder.DataAdapter = new SqlDataAdapter("select * from Provider", ClassConnection.Connection);
            builder.ConflictOption = ConflictOption.OverwriteChanges; // 所有 Update, Delete 语句仅在 WHERE 子句中包含 PrimaryKey 列。
            builder.SetAllValues = false; // Update 语句仅包含更改的列。
            SqlCommand cmd = builder.GetInsertCommand(true);
            cmd.CommandText = "Insert_Provider";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd = builder.GetUpdateCommand(true);
            cmd.CommandText = "Update_Provider";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd = builder.GetDeleteCommand(true);
            cmd.CommandText = "Delete_Provider";
            cmd.CommandType = CommandType.StoredProcedure;
            builder.DataAdapter.Update(table);
            dataView.Table.AcceptChanges();
            return true;
        }
    }
    catch
    {
        return false;
    }
}