OleDbConnection objConn = new OleDbConnection();
OleDbCommand objCmd = new OleDbCommand();
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
Server.MapPath("database/mydatabase.mdb") + ";Jet OLEDB:Database Password=;";
objConn = new OleDbConnection(strConnString);
objConn.Open();
OleDbDataAdapter dtAdapter;
DataTable dt = new DataTable();
strSQL = "SELECT * FROM customer WHERE User = '"+ txtUsername.Text +"' AND Password = '"+ txtPassword.Text +"' ";
dtAdapter = new OleDbDataAdapter(strSQL, objConn);
dtAdapter.Fill(dt);
if(dt.Rows.Count > 0)
{
// SESSION
}
Date :
2009-03-15 23:12:41
By :
webmaster
No. 3
Guest
var db = UsersDataConext();
var q = from p in db.Users
where p.UserName == txtUsername && p.Password == txtPassword
Select p;
if(q.count() > 0)
{
// Session
}