private void confirm_Click(object sender, EventArgs e) { string memid = this.IDreceive.Text; memberid = memid; if (memid.Equals("")) { MessageBox.Show("ID不能为空"); } else { string connString = @"Server = .; Data Source = 127.0.0.1; Initial Catalog = 族谱数据库; Persist Security Info = True; User ID = sa; Password = 123456"; SqlConnection SqlCon = new SqlConnection(connString); //数据库连接 SqlCon.Open(); //打开数据库 string sql = "Select * from Member where M_ID=" + memid; //查找用户sql语句 SqlCommand cmd = new SqlCommand(sql, SqlCon); cmd.CommandType = CommandType.Text; SqlDataReader sdr; sdr = cmd.ExecuteReader(); if (sdr.Read()) { //从结果中找到 { MessageBox.Show("成功定位成员", "提示"); memchange2 memchange2 = new memchange2(); memchange2.memberid2 = this.memberid; memchange2.Show(); Close(); } } else { MessageBox.Show("ID错误", "提示"); return; } } }
private void confirm_Click(object sender, EventArgs e) { string memid = this.IDreceive.Text; memberid = memid; if (memid.Equals("")) { MessageBox.Show("ID不能为空"); } else { string connectionString = "Data Source=无趣中心;Initial Catalog=电子族谱管理系统;Integrated Security=True"; SqlConnection SqlCon = new SqlConnection(connectionString); //数据库连接 SqlCon.Open(); //打开数据库 string sql = "Select * from 成员表 where M_ID=" + memid; //查找用户sql语句 SqlCommand cmd = new SqlCommand(sql, SqlCon); cmd.CommandType = CommandType.Text; SqlDataReader sdr; sdr = cmd.ExecuteReader(); if (sdr.Read()) { //从结果中找到 { MessageBox.Show("成功定位成员", "提示"); memchange2 memchange2 = new memchange2(); memchange2.memberid2 = this.memberid; memchange2.Show(); Close(); } } else { MessageBox.Show("ID错误", "提示"); return; } } }