求教,为啥使用如下代码插入ACCESS数据库的时候一下插入n多
如题,代码如下,运行的时候插入数据未响应,半天后发现插入了数十次,求大侠帮忙看看问题出在哪里....小弟感激不尽...
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();
}
------解决方案--------------------你这段代码写在哪了,是不是被循环触发了,跟踪一下看看吧
------解决方案--------------------