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;
}
}