id++;
reader.Close();
//2.然后插入图书信息表
try
{
string query_text_insert_info =
"insert into book_info values("+id+",'"+textBox1.Text+"','"+
textBox2.Text + "','"+ textBox3.Text + "','"+richTextBox1.Text+"')";
cmd.CommandText = query_text_insert_info;
cmd.ExecuteNonQuery();
//3.然后插入图书数量表
string query_text_insert_num =
"insert into book_num values("+id+","+textBox4.Text+")";
cmd.CommandText = query_text_insert_num;
cmd.ExecuteNonQuery();
conn.Close();
}catch(Exception ex)
{
MessageBox.Show("您的输入有误,请重试","错
误",MessageBoxButtons.OK,MessageBoxIcon.Error);
conn.Close();
return;
}
MessageBox.Show("添加成功", "恭喜", MessageBoxButtons.OK);
book_manage_Load(null, null);
}
}