private void button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection("Data Source=.\\sqlexpress;database=Library_Database;Integrated Security=yes"); con.Open(); SqlCommand cmd = new SqlCommand("select * from user_table where U_name=@U_name and U_password=@U_password", con); cmd.Parameters.Add("@U_name", SqlDbType.NVarChar, 50).Value = textBox1.Text; cmd.Parameters.Add("@U_password", SqlDbType.NVarChar, 50).Value = textBox2.Text; //string pwd= cmd.Parameters.Add("@U_password", SqlDbType.NVarChar, 50).Value; //if(@U_password==textBox2) SqlDataReader dr = cmd.ExecuteReader(); Lib_home lh = new Lib_home(); lh.s1 = textBox1.Text; if (dr.HasRows) { dr.Read(); //Lib_home ob = new Lib_home(); lh.Show(); this.Close(); } else { MessageBox.Show("your user name or pwd is wrong"); } }
private void linkLabel1_LinkClicked_1(object sender, LinkLabelLinkClickedEventArgs e) { Login_page n = new Login_page(); n.Show(); this.Close(); Lib_home lib = new Lib_home(); lib.Close(); }
private void label2_Click(object sender, EventArgs e) { Lib_home obj = new Lib_home(); obj.Show(); }
private void Form1_Load(object sender, EventArgs e) { Lib_home ob = new Lib_home(); ob.closs(); }