hi,
i will procedure my coding below how get varchar role from stored procedure
login.aspx.cs
public partial class Login : System.Web.UI.Page
{
clsLogin objLogin = new clsLogin();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string str1 = null;
string[] UserName = null;
try
{
if (txtUserName.Text.Contains("@"))
{
string str = txtUserName.Text;
UserName = str.Split('@');
clsLogin.UserName = UserName[0].ToString();
str1 = UserName[0].ToString();
}
else
{
clsLogin.UserName = txtUserName.Text.Trim();
str1 = txtUserName.Text.Trim();
}
clsLogin.Password = txtPassword.Text.Trim();
string Role = objLogin.GetUserLogin();
if (Role == "NoUser")
lblMsg.Text = "User Name and password mismatch. Try again.";
else
if (Role == "Admin")
{
Session["UserName"] = str1;
Response.Redirect("~/Admin/AdminHome.aspx");
}
else if (Role == "Manager")
{
Session["UserName"] = str1;
Response.Redirect("~/HRManager/ManagerHome.aspx");
}
else if (Role == "Employee")
{
Session["UserName"] = str1;
Response.Redirect("~/Employee/EmployeeHome.aspx");
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
}
CLSLOGIN.cs
public class clsLogin:Connection
{
public clsLogin()
{
//
// TODO: Add constructor logic here
//
}
public static string UserName { get; set; }
public static string Password { get; set; }
public static string Role { get; set; }
DataSet ds = null;
public string GetUserLogin()
{
try
{
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@UserName", UserName);
p[1] = new SqlParameter("@Password", Password );
p[2] = new SqlParameter("@Role", SqlDbType.VarChar, 50);
p[2].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "spLoginChecking", p);
Role = Convert.ToString(p[2].Value);
return Role;
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
sankarreddy