用户登录代码

用户登录代码 priviate void button1_Click(object sender,System.EventArgs e) { SqlConnection conn=new SqlConnection("@Data Source="(local);Integrated Security=SSPI;Initial Catalog=DBApp""); SqlCommand cmd=conn.CreateCommand(); cmd.CommandType=CommandType.Text; cmd.CommandType = CommandType.Text; if (txtUserName.Text.Length == 0) { MessageBox.Show("ÓÃ????ÄÜΪ?Õ??Çë?éÑ?ºóÊäÈë"); txtPassWord.Focus(); return; } cmd.CommandText = "select count(*) from UserList where UserName='" + txtUserName.Text + "'"; conn.Open(); if ((int)cmd.ExecuteScalar() == 0) { MessageBox.Show("???æÔÚ?ËÓÃ????Çë?ì?éºóÖØÐÂÊäÈë"); txtPassWord.Focus(); return; } cmd.CommandText = "select UserName, PassWord from UserList where PassWord='" +txtPassWord .Text + "'"; SqlDataReader myReader = cmd.ExecuteReader(); if (myReader.Read()) { if (txtPassWord.Text == myReader[0].ToString() && txtUserName.Text.Length != 0) ; MessageBox.Show("µÇÂ??É??", "??Ï?", MessageBoxButtons.OK, MessageBoxIcon.Information); frmMain fm = new frmMain(); fm.ShowDialog(); } else { MessageBox.Show("ÓÃ??" + txtUserName.Text + "µÄÃÜÂë??ÕýÈ?", "ÃÜÂë", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); txtPassWord.Focus(); return; } } private void button2_Click(object sender, EventArgs e) { this.Close(); } }