using(OleDbConnection conn=new OleDbConnection(ConfigurationManager.ConnectionStrings["Conn"].ConnectionString))
{
conn.Open();
//出租日期=?,到期日期=?,
string strUpdate = @"UPDATE HouseDB SET 状态=?,电话=?,身份证号=?,出租日期=?,到期日期=?,租金=?,押金=?,姓名=? " + "WHERE 房间号=?";
OleDbCommand cmd = new OleDbCommand(strUpdate);
cmd.Parameters.Add("@状态", OleDbType.VarWChar, 30).Value = "已出租";
cmd.Parameters.Add("@电话", OleDbType.VarWChar, 30).Value = txtTel.Text;
cmd.Parameters.Add("@身份证号", OleDbType.VarWChar, 30).Value = txtID.Text;
cmd.Parameters.Add("@出租日期", OleDbType.Date, 30).Value = dtpBegin.Value.Date.ToString();
cmd.Parameters.Add("@到期日期", OleDbType.Date, 30).Value = dtpEnd.Value.Date.ToString(); // 注意这个日期的格式 写法
cmd.Parameters.Add("@租金", OleDbType.VarWChar, 30).Value = txtRent.Text.Trim();
cmd.Parameters.Add("@押金", OleDbType.VarWChar, 30).Value = txtCashPledge.Text.Trim();
cmd.Parameters.Add("@姓名", OleDbType.VarWChar, 30).Value = txtName.Text.Trim();
cmd.Parameters.Add("@房间号", OleDbType.VarWChar, 30).Value = roomNum;
cmd.Connection = conn;
try
{
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("添加失败");
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
{
conn.Open();
//出租日期=?,到期日期=?,
string strUpdate = @"UPDATE HouseDB SET 状态=?,电话=?,身份证号=?,出租日期=?,到期日期=?,租金=?,押金=?,姓名=? " + "WHERE 房间号=?";
OleDbCommand cmd = new OleDbCommand(strUpdate);
cmd.Parameters.Add("@状态", OleDbType.VarWChar, 30).Value = "已出租";
cmd.Parameters.Add("@电话", OleDbType.VarWChar, 30).Value = txtTel.Text;
cmd.Parameters.Add("@身份证号", OleDbType.VarWChar, 30).Value = txtID.Text;
cmd.Parameters.Add("@出租日期", OleDbType.Date, 30).Value = dtpBegin.Value.Date.ToString();
cmd.Parameters.Add("@到期日期", OleDbType.Date, 30).Value = dtpEnd.Value.Date.ToString(); // 注意这个日期的格式 写法
cmd.Parameters.Add("@租金", OleDbType.VarWChar, 30).Value = txtRent.Text.Trim();
cmd.Parameters.Add("@押金", OleDbType.VarWChar, 30).Value = txtCashPledge.Text.Trim();
cmd.Parameters.Add("@姓名", OleDbType.VarWChar, 30).Value = txtName.Text.Trim();
cmd.Parameters.Add("@房间号", OleDbType.VarWChar, 30).Value = roomNum;
cmd.Connection = conn;
try
{
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("添加失败");
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}