User343984601 posted
Hi, I created custom database to valdiate the user login, no i am trying to create the session for each user.
i am trying to use the SQL server session mode, used aspnet_regsql cmd with persistant mode to add two tables (Aspnet TempSession and TempApplication) to the sql server databse and tables are created automatically. here is the sql connection string
<sessionState
mode="SQLServer"
sqlConnectionString
="Data Source=KENETICS-PC-011\SQLEXPRESS; Integrated
Security=SSPI; Initial Catalog=LoginDetails Trusted_Connection=yes"/>
now
i need to conncet with the string that is to create the session after i login, How to use serializable code for this?
the
codebehind shown below for login validation
public
void LoginButton_Click(object
sender, EventArgs
e)
{
if(IsPostBack)
{
string connectionString =
"Data Source=KENETICS-PC-011\\SQLEXPRESS;Initial Catalog=LoginDetails;User ID=sa;Password=password ";
SqlConnection con =
new
SqlConnection
(connectionString);
SqlCommand sd =
new
SqlCommand("SELECT
OfficerID, Password FROM SecureUser WHERE OfficerID = @OfficerID AND Password = @Password", con);
sd.Parameters.Add("@OfficerID",
SqlDbType.NVarChar).Value = tOfficerID.Text;
sd.Parameters.Add("@Password",
SqlDbType.NVarChar).Value = tPassword.Text;
//String OfficerID = OfficerID.ToString();
con.Open();
//Executing using Data Reader
SqlDataReader
r = sd.ExecuteReader();
if(r.Read())
{
lblOfficerID.Text = r["OfficerID"].ToString();
lblPassword.Text = r["Password"].ToString();
Response.Redirect("Client\\Report.aspx",
true
);
}
else
{
InvalidCredentialsMessage.Visible =true;
}
r.Close();
con.Close();
}
}
Please
suggest me some solution,
Thanks
