Question

写了一个方法，总是提示：必须声明标量变量 "@ID"。 哪位大侠知道，请帮帮忙吧，不胜感激！

public DataTable SelectTopNews(int ID)
{
string strsql = "select top 1 * from News where ID=@ID";

SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@ID",ID)
};
return SqlHelper.ExecuteDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, strsql, null).Tables[0];
}

Answer 1

用最简单方式试试：
public DataTable SelectTopNews(int ID)
{
string strsql = "select top 1 * from News where ID="+ID;

return SqlHelper.ExecuteDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, strsql, null).Tables[0];
}