private int myExecutNoQurey(string sql)
{
OleDbConnection cnn = new OleDbConnection(myConnectionString);
cnn.Open();
OleDbCommand cmd = new OleDbCommand(sql, cnn);
cmd.CommandType = CommandType.Text;
int i = cmd.ExecuteNonQuery();
cnn.Close();
return i;
}
private void button1_Click(object sender, EventArgs e)
{
string sql = string.Format
("insert into Books(Name,Price,Author,Publish,Number) values ('{0}','{1}','{2}','{3}','{4}')"
, textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text);
int flag = myExecutNoQurey(sql);
if (flag > 0)
{
MessageBox.Show("Sccessful!", "Tip", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Defeated!", "Tip", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
{
OleDbConnection cnn = new OleDbConnection(myConnectionString);
cnn.Open();
OleDbCommand cmd = new OleDbCommand(sql, cnn);
cmd.CommandType = CommandType.Text;
int i = cmd.ExecuteNonQuery();
cnn.Close();
return i;
}
private void button1_Click(object sender, EventArgs e)
{
string sql = string.Format
("insert into Books(Name,Price,Author,Publish,Number) values ('{0}','{1}','{2}','{3}','{4}')"
, textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text);
int flag = myExecutNoQurey(sql);
if (flag > 0)
{
MessageBox.Show("Sccessful!", "Tip", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Defeated!", "Tip", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
是否字段名、字段类型正确,是否有重复的主键记录。
("insert into Books([Name],Price,Author,Publish,Number) values ('{0}','{1}','{2}','{3}','{4}')"
, textBox1.Text, decimal.Parse(textBox2.Text), textBox3.Text, textBox4.Text, textBox5.Text);你自己对照数据库表字段类型,进行检查即可。其实这个最好的办法就是断点调试,很快就能定位出错的地方。