如题,代码如下,运行的时候插入数据未响应,半天后发现插入了数十次,求大侠帮忙看看问题出在哪里....小弟感激不尽...
string ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Application.StartupPath + @"\db1.mdb";
OleDbConnection conn = new OleDbConnection();
String str = "./db1.mdb";
OleDbConnection OleDbcon = new OleDbConnection("Provider=Microsoft.jet.OLEDB.4.0;Data Source=" + str + ";User ID=admin;Password=;Jet OLEDB:Database Password=");
try
{
OleDbcon.Open();
OleDbCommand cmd = new OleDbCommand("insert into "+comboBox1.Text.ToString()+" (商品名称,单位,售价,进价) values(@textBox2,@textBox3,@textBox4,@textBox5)", OleDbcon);
cmd.Parameters.AddWithValue("@textBox2", textBox2.Text.Trim());
cmd.Parameters.AddWithValue("@textBox3", textBox3.Text.Trim());
cmd.Parameters.AddWithValue("@textBox4", textBox4.Text.Trim());
cmd.Parameters.AddWithValue("@textBox5", textBox5.Text.Trim());
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
button6_Click(null, null);
textBox2.Text = string.Empty;
textBox3.Text = string.Empty;
textBox4.Text = string.Empty;
textBox5.Text = string.Empty;
}
else
MessageBox.Show("添加失败!");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
OleDbcon.Close();
}
string ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Application.StartupPath + @"\db1.mdb";
OleDbConnection conn = new OleDbConnection();
String str = "./db1.mdb";
OleDbConnection OleDbcon = new OleDbConnection("Provider=Microsoft.jet.OLEDB.4.0;Data Source=" + str + ";User ID=admin;Password=;Jet OLEDB:Database Password=");
try
{
OleDbcon.Open();
OleDbCommand cmd = new OleDbCommand("insert into "+comboBox1.Text.ToString()+" (商品名称,单位,售价,进价) values(@textBox2,@textBox3,@textBox4,@textBox5)", OleDbcon);
cmd.Parameters.AddWithValue("@textBox2", textBox2.Text.Trim());
cmd.Parameters.AddWithValue("@textBox3", textBox3.Text.Trim());
cmd.Parameters.AddWithValue("@textBox4", textBox4.Text.Trim());
cmd.Parameters.AddWithValue("@textBox5", textBox5.Text.Trim());
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
button6_Click(null, null);
textBox2.Text = string.Empty;
textBox3.Text = string.Empty;
textBox4.Text = string.Empty;
textBox5.Text = string.Empty;
}
else
MessageBox.Show("添加失败!");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
OleDbcon.Close();
}
private void button6_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(textBox2.Text.Trim()))
{
MessageBox.Show("你妹的,都填上!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox2.Focus();
}
else if (string.IsNullOrEmpty(textBox3.Text.Trim()))
{
MessageBox.Show("你妹的,都填上!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox3.Focus();
}
else if (string.IsNullOrEmpty(textBox4.Text.Trim()))
{
MessageBox.Show("你妹的,都填上!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox4.Focus();
}
else if (string.IsNullOrEmpty(textBox5.Text.Trim()))
{
MessageBox.Show("你妹的,都填上!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox5.Focus();
}
else
{
string ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Application.StartupPath + @"\db1.mdb";
OleDbConnection conn = new OleDbConnection();
String str = "./db1.mdb";
OleDbConnection OleDbcon = new OleDbConnection("Provider=Microsoft.jet.OLEDB.4.0;Data Source=" + str + ";User ID=admin;Password=;Jet OLEDB:Database Password=");
try
{
OleDbcon.Open();
OleDbCommand cmd = new OleDbCommand("insert into "+comboBox1.Text.ToString()+" (商品名称,单位,售价,进价) values(@textBox2,@textBox3,@textBox4,@textBox5)", OleDbcon);
cmd.Parameters.AddWithValue("@textBox2", textBox2.Text.Trim());
cmd.Parameters.AddWithValue("@textBox3", textBox3.Text.Trim());
cmd.Parameters.AddWithValue("@textBox4", textBox4.Text.Trim());
cmd.Parameters.AddWithValue("@textBox5", textBox5.Text.Trim());
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
button6_Click(null, null);
textBox2.Text = string.Empty;
textBox3.Text = string.Empty;
textBox4.Text = string.Empty;
textBox5.Text = string.Empty;
}
else
MessageBox.Show("添加失败!");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
OleDbcon.Close();
}
}
if (result > 0)
{
button6_Click(null, null);
textBox2.Text = string.Empty;
textBox3.Text = string.Empty;
textBox4.Text = string.Empty;
textBox5.Text = string.Empty;
}
button6_Click(null, null);
确实删除这句就好了,请教下,为啥有这句会重复添加呢?