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();
}
