c#数据库连接

c#数据库连接

            SqlConnection oconn;
            string strconn;
            oconn = new SqlConnection();
            strconn = "Data Source=localhost//sqlexpress;Initial Catalog=asfd;Integrated Security=SSPI";
            oconn.ConnectionString = strconn;
            oconn.Open();

            SqlCommand myCommand = new SqlCommand("select UserName,PassWord From Password", oconn);
            SqlDataReader myDataReader = myCommand.ExecuteReader();

 

登陆

            while (myDataReader.Read())
            {
                if (myDataReader[1].ToString().Trim() == Password.ToString()&&myDataReader[0].ToString().Trim()==UserName)
                {
                    MessageBox.Show("登陆成功！", "Load", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    Form2 myform = new Form2();            
                    myform.Show();
                    this.Opacity = 0;
                }
             }
             MessageBox.Show("用户名或密码错误！", "非法登陆", MessageBoxButtons.OK, MessageBoxIcon.Error);
        
         }