private void button1_Click(object sender, EventArgs e)
{
if (textBox4.Text == "")
{
MessageBox.Show("请输入年龄!");
return;
}
if (textBox7.Text == "")
{
MessageBox.Show("请输入工龄!");
return;
}
if (comboBox1.Text == "")
{
MessageBox.Show("请选择部门!");
return;
}
int age = Convert.ToInt32(textBox4.Text);
int gonglin = Convert.ToInt32(textBox7.Text); String cnno = "Data Source=HP-PC;Initial Catalog=FIRST;Integrated Security=True;Pooling=False";
SqlConnection connection = new SqlConnection(cnno);
string sql = string.Format("Insert into Xinxi values('{0}','{1}','{2}',{3},'{4}','{5}',{6},'{7}','{8}','{9}') ", textBox1.Text, textBox2.Text, textBox3.Text, age, comboBox1.Text, textBox6.Text, gonglin, textBox8.Text, textBox9.Text, textBox10.Text);
connection.Open();
SqlCommand command = new SqlCommand(sql, connection);
//int num = Convert.ToInt32(command.ExecuteScalar());
int num = command.ExecuteNonQuery();
try
{
if (num > 0)
{ MessageBox.Show("添加成功!");
this.Close();
}
else
{
MessageBox.Show("添加失败!");
}
}
catch (Exception ex)
{ MessageBox.Show("错误异常" + ex);
}
finally
{
connection.Close();
} }
这是我刚写的。。往数据库里加信息,其中Xno是主键,在添加一样的主键时会提示出错,得怎么改呀。。在下新手,求大神指导。。
{
if (textBox4.Text == "")
{
MessageBox.Show("请输入年龄!");
return;
}
if (textBox7.Text == "")
{
MessageBox.Show("请输入工龄!");
return;
}
if (comboBox1.Text == "")
{
MessageBox.Show("请选择部门!");
return;
}
int age = Convert.ToInt32(textBox4.Text);
int gonglin = Convert.ToInt32(textBox7.Text); String cnno = "Data Source=HP-PC;Initial Catalog=FIRST;Integrated Security=True;Pooling=False";
SqlConnection connection = new SqlConnection(cnno);
string sql = string.Format("Insert into Xinxi values('{0}','{1}','{2}',{3},'{4}','{5}',{6},'{7}','{8}','{9}') ", textBox1.Text, textBox2.Text, textBox3.Text, age, comboBox1.Text, textBox6.Text, gonglin, textBox8.Text, textBox9.Text, textBox10.Text);
connection.Open();
SqlCommand command = new SqlCommand(sql, connection);
//int num = Convert.ToInt32(command.ExecuteScalar());
int num = command.ExecuteNonQuery();
try
{
if (num > 0)
{ MessageBox.Show("添加成功!");
this.Close();
}
else
{
MessageBox.Show("添加失败!");
}
}
catch (Exception ex)
{ MessageBox.Show("错误异常" + ex);
}
finally
{
connection.Close();
} }
这是我刚写的。。往数据库里加信息,其中Xno是主键,在添加一样的主键时会提示出错,得怎么改呀。。在下新手,求大神指导。。
SqlCommand command = new SqlCommand(sql, connection);
//int num = Convert.ToInt32(command.ExecuteScalar());
try
{
int num = command.ExecuteNonQuery();
if (num > 0)
{ MessageBox.Show("添加成功!");
this.Close();
}
else
{
MessageBox.Show("添加失败!");
}
}
catch (Exception ex)
{ MessageBox.Show("错误异常" + ex);
}
finally
{
connection.Close();
}
先 select 一下呗
或者 catch 里面 写
编号已存在
你把上面的代码异常那里改下面这个就是你要的结果了,不过ex的内容差不多也是这个意思啦: try
{
int num = command.ExecuteNonQuery();
if (num > 0)
{
MessageBox.Show("添加成功!");
this.Close();
}
else
{
MessageBox.Show("添加失败!");
}
}
catch (Exception ex)
{
MessageBox.Show("“此编号存在");
}