private void button1_Click(object sender, EventArgs e)
{
string str = "Data Source=localhost;Initial Catalog=bookmanage;Persist Security Info=True;User ID=sa;Password=Ko12345678";
SqlConnection conn = new SqlConnection(str);
conn.Open();
string sql = "select Tcode from teacher"; //要执行的sql语句,你改成你的表名
SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
sda.Fill(dt);//填充数据到dt
int j=1;
for(int i=0;i<dt.Rows.Count;i++)
{
if(dt.Rows[i].ToString().Trim().Equals(textBox1.Text.Trim()))
{
j=0;
}
}
if (j==1)
{
string sql1 = "insert into teacher(Tcode,Tname,Tsex,Tage,Tpassword)values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "')";
SqlCommand cmd = new SqlCommand(sql1, conn);
cmd.ExecuteNonQuery();
MessageBox.Show("该教师信息插入成功^_^");
}
else
{
MessageBox.Show("教师编号不能重复");
}
}
本文仅供个人学习,是转载的别人的,只为留下存根方便以后查看,并不能保证代码一定正确无误
原文链接:https://zhidao.baidu.com/question/1516439656453376620.html