I am new entity frame work I am develop a login form it will work perfectly.
So now I want I use login form with the entity frame work .following my code I cannot know how I use it .please help me ..
Following my login form code.
WebFom1Code
protected void Button1_Click(object sender, EventArgs e)
{
string strcon = "Data Source=.\\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|Database1.mdf;User Instance=true";
SqlConnection con = new SqlConnection(strcon);
SqlCommand com = new SqlCommand("Emplogin", con);
com.CommandType = CommandType.StoredProcedure;
SqlParameter p1 = new SqlParameter("@Usename", TextBox1.Text);
SqlParameter p2 = new SqlParameter("@Password", TextBox2.Text);
com.Parameters.Add(p1);
com.Parameters.Add(p2);
con.Open();
SqlDataReader rd = com.ExecuteReader();
if (rd.HasRows)
{
rd.Read();
Label3.Text = "Login successful.";
Session["User"] = TextBox1.Text;
Response.Redirect("WebForm2.aspx");
}
else
{
Label3.Text = "Invalid username or password.";
TextBox1.Text ="";
TextBox2.Text = "";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
Response.Redirect("WebForm1.aspx");
}
}
}
WebForm2.aspx
protected void Page_Load(object sender, EventArgs e)
{
if (Session["User"] == null)
Response.Redirect("WebForm1.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
Session.Remove("User");
Response.Redirect("WebForm1.aspx");
}
}
}
please Help me to Solve it how stored procedure defination Excess in Entity Frame work.