自己第一次做数据库软件,当做到需要在DataGridView中添加删除数据时,发现数据库操作成功时,DataGridView中的数据依旧原封不动。上了百度,google,上了论坛,依旧未找到解决方法。后来终于在VS在线帮助文档中找到了解决方法。
MessageBox.Show("用户添加成功");
//数据库删除成功后,执行以下两句,实现DataGridView显示更新
usersBindingSource.DataSource = GetData("select * from Users");
dataGridView1.DataSource = usersBindingSource;
return;
//GetData方法
private static DataTable GetData(string sqlCommand)
{
string connectionString = @"Server=.\DB;DataBase=TeachingMaterialBookingSys;UID=sa;PWD=duke";
SqlConnection northwindConnection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(sqlCommand, northwindConnection);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
DataTable table = new DataTable();
table.Locale = System.Globalization.CultureInfo.InvariantCulture;
adapter.Fill(table);
return table;
}