Dear Friends,
I have some Error i can't find out that error: can't find table 0 at retun value.
private DataTable deleteSession(string userSession, string mode)
{
DataSet dsData1 = new DataSet();
SqlConnection sqlCon;
SqlDataAdapter sqlCmd;
try
{
using (sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString))
{
sqlCmd = new SqlDataAdapter("USP_UserLogin", sqlCon);
sqlCmd.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlCmd.SelectCommand.Parameters.AddWithValue("@loginID",userSession);
sqlCmd.SelectCommand.Parameters.AddWithValue("@password", string.Empty);
sqlCmd.SelectCommand.Parameters.AddWithValue("@sessionID", string.Empty);
sqlCmd.SelectCommand.Parameters.AddWithValue("@mode", mode);
sqlCon.Open();
sqlCmd.Fill(dsData1);
sqlCon.Close();
}
}
catch
{
throw;
}
return dsData1.Tables[0];
}
protected void hnkLogOut_Click(object sender, EventArgs e)
{
deleteSession(Convert.ToString(Session["UserID"]), "LOGOUT");
Session.Abandon();
Response.Redirect("Login.aspx?mode=logout");
}
[UpDate]
I solved this can't find table problem... Now can't update the values. am using sp for this.
IF @mode = 'LOGOUT'
BEGIN
UPDATE [Users]
SET IsLogin = 0 ,
userSession = ''
WHERE LoginID = @loginID
SELECT 0
END
[UpDate]
But, this Executed:
IF @mode = 'CHANGELOGIN'
BEGIN
UPDATE [Users]
SET IsLogin = 1 ,
userSession = @sessionID ,
LastLogin = GETDATE()
WHERE LoginID = @loginID
SELECT 1
END
What I have tried:
didn't update that sp code... above c# and sp code for logout any mistakes in that.