thiscommand.CommandText = \ SqlDataReader Dr = thiscommand.ExecuteReader(); while (Dr.Read())//读取数据库信息 {
Users = Dr[\ Pwd = Dr[\
if (Users.Trim() == textBox1.Text && Pwd.Trim() == textBox2.Text)
{
flagshow = true;//用户名存在，则true } }
Dr.Close();
thisconnection.Close();
if (flagshow == true)//当原用户名和密码都正确时，才能改用户名和密码
{
SqlConnection conn = new SqlConnection(\家庭记账系统; User ID =sa; PWD =123\ conn.Open();
SqlCommand cmd = new SqlCommand(); cmd.CommandText = \login set uname=@uname,password=@password \ cmd.Connection = conn;
cmd.Parameters.Add(\ cmd.Parameters.Add(\
cmd.Parameters[\ cmd.Parameters[\ cmd.ExecuteNonQuery(); conn.Close(); this.Close(); } else {
MessageBox.Show(\原用户名与密码不正确，不能修改密码！\提示\
return; } }
（初始化数据库）
if (MessageBox.Show(\你确定要初始化数据库？\\提示\MessageBoxButtons.YesNo) == DialogResult.Yes) {
SqlConnection conn = new SqlConnection(\家庭记账系统; User ID =sa; PWD =123\ conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = \账目表\ cmd.Connection = conn; cmd.ExecuteNonQuery(); conn.Close(); this.Close(); }
（添加收入记录）
if (textBox2.Text.Trim() == \ {
MessageBox.Show(\请输入完整信息！\\错误\MessageBoxButtons.OK, MessageBoxIcon.Error); } else {
SqlConnection conn = new SqlConnection(\家庭记账系统; User ID =sa; PWD =123\ conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = \账目表(日期,类型,金额,备注,记录员)values(@日期,@类型,@金额,@备注,@记录员)\ cmd.Connection = conn;
cmd.Parameters.Add(\日期\ cmd.Parameters.Add(\类型\ cmd.Parameters.Add(\金额\
cmd.Parameters.Add(\备注\ cmd.Parameters.Add(\记录员\
cmd.Parameters[\日期\ cmd.Parameters[\类型\ cmd.Parameters[\金额\ cmd.Parameters[\备注\
cmd.Parameters[\记录员\ cmd.ExecuteNonQuery(); conn.Close(); this.Close(); }