如图中,我希望在按保存时候检测是否存在帐号相同的人如果有,就弹出窗口说存在帐号相同的人,请重新检查,如果没有就可以把数据保存到数据库中。求解?以下是我的代码:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Dataset绑定DataGridview
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
string connStr = @"Server=.;Database=warehouse;Integrated Security=true;";
DataSet ds = new DataSet();
private void Form1_Load(object sender, EventArgs e)
{
string sql = "select * from Staff";
using (SqlConnection conn = new SqlConnection(connStr))
{
SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
sda.Fill(ds);
}
//将table绑定到控件上
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = ds.Tables[0];
}
private void button1_Click(object sender, EventArgs e)
{
string sql = "select * from Staff";
using (SqlConnection conn = new SqlConnection(connStr))
{
using (SqlDataAdapter sda = new SqlDataAdapter(sql, conn))
{ //帮助执行增删改操作
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
//使用Update更新数据,sql语句中必须包含主键
sda.Update(ds);
}
}
}