private void btnsignin_Click(object sender, EventArgs e) { try { uname = txtusername.Text; //create connection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()); //open connection con.Open(); //pass the procedure SqlCommand cmd = new SqlCommand("proc_login", con); //mention that we are working with stored procedure cmd.CommandType = CommandType.StoredProcedure; //pass the value to the parameter cmd.Parameters.AddWithValue("@ename", txtusername.Text); cmd.Parameters.AddWithValue("@password", txtpwd.Text); //execute the query SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { if (dr.Read()) { salepersonhome s1 = new salepersonhome(); s1.Show(); } } else { MessageBox.Show("Invalid User"); } } catch (Exception e1) { Console.WriteLine(e1.Message); } finally { con.Close(); } }
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { salepersonhome s1 = new salepersonhome(); s1.Show(); }