110,536
社区成员
发帖
与我相关
我的任务
分享
private DataSet dataSet = new DataSet(); // 声明并初始化DataSet
private SqlDataAdapter dataAdapter; // 声明DataAdapter
public TeacherListForm()
{
InitializeComponent();
}
// 窗体加载时填充数据
private void TeacherListForm_Load(object sender, EventArgs e)
{
// 查询用的 sql 语句
string teacherSql = "SELECT × FROM Teacher";
// 初始化 DataAdapter
dataAdapter = new SqlDataAdapter(teacherSql, DBHelper.GetConnection());
DBHelper.GetConnection().Open();
// 填充 DataSet
dataAdapter.Fill(dataSet, "Teacher");
DBHelper.GetConnection().Close();
// 绑定DataGridView的数据源
dgvTeacher.DataSource = dataSet.Tables["Teacher"];
}
// 单击“保存修改”按钮时,将数据集的更改提交到数据库
private void btnUpdate_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("确实要将修改保存到数据库吗?","操作提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Question);
if (result == DialogResult.OK)
{
SqlCommandBuilder builder = new SqlCommandBuilder(dataAdapter);
DBHelper.GetConnection().Open();
dataAdapter.Update(dataSet, "Teacher");
DBHelper.GetConnection().Close();
}
}
// 单击“刷新”按钮时,重新填充数据集
private void btnFresh_Click(object sender, EventArgs e)
{
dataSet.Tables["Teacher"].Clear(); // 清空原来的数据
DBHelper.GetConnection().Open();
dataAdapter.Fill(dataSet,"Teacher"); // 重新填充
DBHelper.GetConnection().Close();
}