private void button_person_Click(object sender, EventArgs e) { FormPersoninputUserID_M formPersonUserID = new FormPersoninputUserID_M(); formPersonUserID.Show(); this.Hide(); }
private void FormPersonM_Load(object sender, EventArgs e) { String id = label_id.Text.Trim(); try { con.Open(); string sql = "SELECT * FROM SysUser WHERE UserID = '" + id + "'"; SqlCommand command = new SqlCommand(sql, con); SqlDataAdapter dataAdapter = new SqlDataAdapter(command); //创建DataSet对象 DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet, "SysUser"); int c = dataSet.Tables["SysUser"].Rows.Count; if (c > 0) { label_schoolid.Text = (string)dataSet.Tables["SysUser"].Rows[0]["UserSchoolID"]; label_mobile.Text = (string)dataSet.Tables["SysUser"].Rows[0]["UserMobile"]; label_birth.Text = dataSet.Tables["SysUser"].Rows[0]["UserBirthday"].ToString(); Byte[] mybyte = new byte[0]; mybyte = (Byte[])(dataSet.Tables["SysUser"].Rows[c - 1]["UserPhoto"]); MemoryStream ms = new MemoryStream(mybyte); pictureBox1.Image = Image.FromStream(ms); } else { pictureBox1.Image = null; con.Close(); MessageBox.Show("该用户不存在,请返回输入正确的用户名!", "Tips", MessageBoxButtons.OK, MessageBoxIcon.Warning); FormPersoninputUserID_M formPersonUserID = new FormPersoninputUserID_M(); formPersonUserID.Show(); this.Close(); } //以上为读取个人信息 } catch (Exception ex) { MessageBox.Show(ex.Message); label_id.Text = "出错!"; } finally { con.Close(); } }