110,534
社区成员
发帖
与我相关
我的任务
分享
private void btnAddUserData_Click(object sender, EventArgs e)
{
//单击添加按钮,将用户资料写入数据库
string ConStr = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=siyindt.mdb";
OleDbConnection con = new OleDbConnection(ConStr);
con.Open();
string sql = "insert into userInfo(username,sex,tel,idnumber,address,notes)values('" + txtAddUserName.Text.Trim() + "','" + cboAddSex.Text + "','" + txtAddTel.Text.Trim() + "','" + txtAddIdNumber.Text.Trim() + "','" + txtAddAddress.Text.Trim() + "','" + txtAddNotes.Text.Trim() + "')";
OleDbCommand cmd = new OleDbCommand(sql, con);
cmd.ExecuteNonQuery();
MessageBox.Show("添加成功!");
con.Close();
}