Line 672: da.Fill(ds,"cv");<br /> Line 673: da1=new OleDbDataAdapter(sql,con);<br /> Line 674: da1.Fill(ds1,"cv");<br /> Line 675: int r=0,r1=0;<br /> Line 676: DataRow []rs;
s1 = TextBox1.Text.Trim(); s2 = TextBox2.Text.Trim(); con.Open(); string sql = "select * from cv"; // string sql1 = "select * from cv"; da=new OleDbDataAdapter(sql,con); da.Fill(ds,"cv"); da1=new OleDbDataAdapter(sql,con); da1.Fill(ds1,"cv"); int r=0,r1=0; DataRow []rs; DataRow []rs1; rs=ds.Tables["cv"].Select("email='" + s1 + "'"); r=rs.Length; rs1=ds1.Tables["cv"].Select("pass='" + s2 + "'"); r1=rs1.Length; try { if (s1 == "" && s2 == "") { Label1.Text = "Please enter your Email ID and Password"; } else { if (r>0) { if(r1>0) { Response.Redirect("account.aspx"); } else { Label1.Text = "Email ID not registred or Check your Password"; } } } } catch (Exception ex) { Response.Write(ex.Message); } con.Close();
con
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)