在使用三层体系结构时从数据集中获取价值 [英] taking value in dataset while working with 3-tier architecture

问题描述

我正在尝试在三层体系结构中加载数据集中的数据.但是我无法做到这一点?..我正在尝试像这样

创建一个storeprocedur-

I am trying to load data in dataset while working 3-tier architecture.But i am not able to do this?..I am trying as like this

creating a storeprocedur --

Alter proc SP_UserLoginInfo(@emailid varchar(50),@password varchar(50))
as
begin 
declare  @LoginStatus int
 if exists(select US_Email from tbl_User where US_Email=@emailid and Us_status='1')
	Begin
		If exists( select US_Password from tbl_User where US_Email=@emailid and US_Password= @password)
			Begin
				Set @LoginStatus=1 --Successful login
			End
		else
			Begin
				Set @LoginStatus=0 -- Password icorrect
			End
	End
Else
	Begin			
			Set @LoginStatus =2 -- Invalid emailID 
	End
End
return @LoginStatus

-------------------------------------------------- ---------------
现在BLL中的内容-


类用户
{

-----------------------------------------------------------------
NOw in BLL--


class user
{

private string _userEmail;
    private string _userPassword;
    private int _loginstatus;

    public int loginstaus
    {
        get { return _loginstatus; }
        set { _loginstatus = value; }
    }

    public string userEmail
    {
        get { return _userEmail; }
        set { _userEmail = value; }
    }
    public string userPassword
    {
        get { return _userPassword; }
        set { _userPassword = value; }
    }

public DataTable    Login_User()
        {
            //DataSet  ds = new DataSet();
            DataSet ds = new DataSet ();
            
      try
            {
                SqlDbHelper sdh = new SqlDbHelper();
                sdh.AddParameter("@emailid", userEmail);
                sdh.AddParameter("@password", userPassword);
                //sdh.AddParameter("@LoginStatus",loginstaus);

                ds=sdh.ExecuteDataSet("SP_UserLoginInfo", CommandType.StoredProcedure);

            }
      catch (Exception Ex)
      {
          throw Ex;
      }
            return ds.Tables[0];
             

        }

--------------------------------------

但是我不能在数据集中取值或表格.因此，请给我

--------------------------------------

But i am not able to take value or table in dataset. So Please give help me

推荐答案

，看来您存储的proc具有3个参数，但是在代码中，您只有2个参数.因此，它肯定会失败.添加第三个参数作为输出参数，然后尝试

It looks like you stored proc have 3 parameters, but in the code, you have only 2 parameters. So it will definitely fail. add third param as output parameter and try

这篇关于在使用三层体系结构时从数据集中获取价值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！