currently i am working a one project and i got this type of error.
i excuted the procedure and in debugging mode prcedure pass the data to entity file but when i go back to aspx page so that time i got this null exception.
how can i resolve.
any one help me?.
UserDAL file
this is a prcedure
public UserENT PR_IP_User_LoginUser(SqlInt32 UserID)
{
using (SqlConnection objconn = new SqlConnection(ConnectionString))
{
objconn.Open();
using (SqlCommand objcmd = objconn.CreateCommand())
{
try
{
#region Prepaed Command
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.CommandText = "PR_IP_User_LoginUser";
objcmd.Parameters.AddWithValue("@UserID", UserID);
#endregion
UserENT entuser = new UserENT();
#region Read and set controls
using (SqlDataReader objSDR = objcmd.ExecuteReader())
{
while (objSDR.Read())
{
if (!objSDR["User_Name"].Equals(DBNull.Value))
{
entuser.User_Name = Convert.ToString(objSDR["User_Name"].ToString().Trim());
}
if (!objSDR["Password"].Equals(DBNull.Value))
{
entuser.Password = Convert.ToString(objSDR["Password"].ToString().Trim());
}
if (!objSDR["User_ID"].Equals(DBNull.Value))
{
entuser.User_ID = Convert.ToInt32(objSDR["User_ID"]);
}
if (!objSDR["ContactNo"].Equals(DBNull.Value))
{
entuser.ContactNo = Convert.ToString(objSDR["ContactNo"]);
}
if (!objSDR["Email_ID"].Equals(DBNull.Value))
{
entuser.Email_ID = Convert.ToString(objSDR["Email_ID"]);
}
if (!objSDR["Is_Admin"].Equals(DBNull.Value))
{
entuser.Is_Admin = Convert.ToBoolean(objSDR["Is_Admin"]);
}
}
return entuser;
}
#endregion
}
catch (Exception e)
{
Message = e.InnerException.Message;
return null;
}
finally
{
objconn.Close();
}
}
}
}
#endregion
on client side or can say aspx page
on button click event
protected void btnLogin_Click(object sender, EventArgs e)
{
#region Server Side Validation
String strerr = "";
if (txtusername.Text.Trim() == "")
{
strerr += "Enter UserName";
}
if (txtpassword.Text.Trim() == "")
{
strerr += "Enter Password";
}
if (strerr != "")
{
lblMessage.EnableViewState = true;
lblMessage.Text = strerr;
}
#endregion
#region Gather Data
SqlString Username, userpass;
if (txtusername.Text.Trim() != "")
{
Username = txtusername.Text.Trim();
}
if (txtpassword.Text.Trim() != "")
{
userpass = txtusername.Text.Trim();
}
#endregion
UserBAL baluser = new UserBAL();
UserENT entuser = new UserENT();
SqlInt32 UserID_Res;
SqlString User_name_res, User_Password_res;
SqlInt32 userid = Convert.ToInt32(txtuserid.Text.Trim());
if (Request.QueryString["User_ID"] == null)
{
if (baluser.Login(userid) != null)
{
User_name_res = entuser.User_Name.Value.ToString().Trim();
UserID_Res = Convert.ToInt32(entuser.User_ID.Value);
User_Password_res = entuser.Password.Value.ToString().Trim();
if (User_name_res == txtusername.Text.Trim() || User_Password_res == txtpassword.Text.Trim())
{
Response.Redirect("AddSubject.aspx");
}
else
{
Response.Redirect("AddTopic.aspx");
}
}
}
#endregion
2
Answers
Thanks every one who help to solve my error. now i resolve my error. i Just pass the data to procure and check the data in procedure and return Boolean value. Thanks Again :)
The C# code associated with a ".aspx" page (or code behind) is executed on the server side.
I assume that UserBAL.Login() function returns the user’s data once logged in. It may be necessary to get the returned object.
On button click event :