您好参数的错误 [英] hi igot error in parameter

问题描述

我在下面出现了错误

hi i got error in below

public static DataSet getAllStatesByCountryID(int CountryID)
{
SqlParameter parameter = new SqlParameter("@CountryID", SqlDbType.Int)
{
Value = CountryID
};
return SqlHelper.ExecuteDataset(ConnectionString.GetConnectionString(), CommandType.StoredProcedure,
"spGetAllStatesByCountryID", new SqlParameter[] { parameter });
}

其显示错误；; CountryID

its showing error in ;excepted near the CountryID

推荐答案

Hi，
附近除外 试试这个:

Hi,
Try this:

public static DataSet getAllStatesByCountryID(int CountryID)
{
    SqlParameter[] parameter = new SqlParameter[]
    {
        new SqlParameter("@CountryID", CountryID)
    };
    return SqlHelper.ExecuteDataset(ConnectionString.GetConnectionString(), CommandType.StoredProcedure,
    "spGetAllStatesByCountryID",  parameter);
}

--Amit

--Amit

public static DataSet getAllStatesByCountryID(int CountryID)
{
SqlParameter parameter = new SqlParameter("@CountryID", SqlDbType.Int)
{
Value = CountryID;// You have put <code>;</code> in wrong place.Please check this line
}
return SqlHelper.ExecuteDataset(ConnectionString.GetConnectionString(), CommandType.StoredProcedure,
"spGetAllStatesByCountryID", new SqlParameter[] { parameter });
}

您需要在语句末尾添加分号

You need to add a semicolon to the end of your statement

SqlParameter parameter = new SqlParameter("@CountryID", SqlDbType.Int)
{
   Value = CountryID;
}

这篇关于您好参数的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！