用户代码未处理SqlException “-”附近有语法错误。
用户代码未处理 System.Data.SqlClient.SqlException
HResult=-2146232060
Message=“-”附近有语法错误。
Source=.Net SqlClient Data Provider
ErrorCode=-2146232060
Class=15
LineNumber=1
Number=102
Procedure=""
Server=103.242.172.165
State=1
/// 获取数据列表
public DataTable GetList(int pageIndex, int pageSize, int userId)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("select top " + pageSize + "MemoId,UserId,Title,MemoContent,AddDate,RemindDate,Remark");
strsql.Append(" FROM Memo where MemoId not in( select top " + pageIndex + " MemoId From Memo where UserId=@UserId order by RemindDate desc) and UserId=@UserId order by RemindDate desc");[/size][size=16px]
SqlParameter[] parameters = {
new SqlParameter("@UserId", SqlDbType.Int,4)};
parameters[0].Value = userId;
return db.ExecuteDataTable(strsql.ToString(), CommandType.Text, parameters);
}