my aspx code is:login.aspx
My login.aspx.cs code is :
protected void Unnamed6_Click(object sender, EventArgs e)
{
//TextBox User_N = (TextBox)this.FindControl("UserName");
//TextBox User_P = (TextBox)this.FindControl("Password");
OleDbConnection connect = new OleDbConnection();
connect.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Diary Model_CurrentBuild.mdb;Persist Security Info=False;";
connect.Open();
// string sqlstring = "Insert
OleDbCommand command = new OleDbCommand();
command.Connection = connect;
// string a = Convert.ToString(this.FindControl("UserName"));
TextBox box = (TextBox)this.FindControl("UserName");
string st = box.Text;
command.CommandText = "Select * from STAFF where staffName = '" + st + "' OR password = '" + this.FindControl("Password") + "'";
OleDbDataReader reader = command.ExecuteReader();
if (reader.Read())
{
Response.Redirect("../Default.aspx");
}
connect.Close();
}
Omer RehmanPosted Oct 9, 2012, 7:36 AM
Santhosh Kumar JayaramanPosted Oct 9, 2012, 3:51 AM
string st =UserName.Text;
instead of creating a textbox reference