public ConfidentialMembers_Borrowinfo()
{
InitializeComponent();
InitTable();
TableToBorrow.DataTableSelect(SQL, "更新");
TableToBorrow.dataGrid.SelectionChanged += TableToBorrow_SelectionChanged;
BorrowTotal.Content = TableToBorrow.dt.Rows.Count;
}
private void CommitChanges_Click(object sender, RoutedEventArgs e)
{
string Str = FlagString();
string SQL1 = "update DataLend set Flag = '" + Str + "' where Id ='" + SelectId + "'";
try
{
SqlCommand CMD_1 = new SqlCommand(SQL1, Temp.GetConn());
CMD_1.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("错误：\n\n" + ex);
return;
}
TableToBorrow.DataTableSelect(SQL, "更新");
MessageBox.Show("修改成功！");
}