Please help to see if this is using .net to access the stored procedure, but don't know what's wrong there

draculadue

SqlConnection dbConn = Utility.OpenConnection ();
            SqlDataReader dbReader;
            SqlCommand dbComm = new SqlCommand ();
            SqlParameter dbParameter;

            dbComm.CommandText = "List";
            dbComm.Connection = dbConn;
            dbComm.CommandType = CommandType.StoredProcedure;

            dbParameter = new SqlParameter ("@ RecordCount", SqlDbType.Int, 4);
            dbParameter.Direction = ParameterDirection.Output;
            dbComm.Parameters.Add (dbParameter);

            dbParameter = new SqlParameter ("@ PageCount", SqlDbType.Int, 4);
            dbParameter.Direction = ParameterDirection.Output;
            dbComm.Parameters.Add (dbParameter);

            dbParameter = new SqlParameter ("@ PageIndex", SqlDbType.Int, 4);
            dbParameter.Direction = ParameterDirection.Input;
            dbParameter.Value = Pageindex;
            dbComm.Parameters.Add (dbParameter);

            dbParameter = new SqlParameter ("@ PageSize", SqlDbType.Int, 4);
            dbParameter.Direction = ParameterDirection.Input;
            dbParameter.Value = Pagesize;
            dbComm.Parameters.Add (dbParameter);

            dbReader = dbComm.ExecuteReader ();
// The above sentence made an error and said [SqlException (0x80131904): The object name 'LOG_User' is invalid. ]

忧伤蓝调

Not a C# statement error
Check your stored procedure
Instead of ExecuteReader()
Did you write "LOG_User" or something in the stored procedure?

draculadue

CREATE PROCEDURE List
@PageIndex INT, --Enter the current page number
@PageSize INT, --Number of records per page
@RecordCount INT OUT, --Number of records
@PageCount INT OUT - number of pages

AS

SELECT @RecordCount = COUNT(*) FROM BLOG_Info INNER JOIN LOG_User ON BLOG_Info.uid = BLOG_User.uid
SET @PageCount = CEILING(@RecordCount * 1.0 / @PageSize)

DECLARE @SQLSTR NVARCHAR(1000)

IF @PageIndex = 0 OR @PageCount <= 1 - first page

set @SQLSTR = "select top "+STR( @PageSize )+" BLOG_Info.title, BLOG_Info.detail, BLOG_User.uname, BLOG_Info.dtime, BLOG_User.url, BLOG_Info.iid FROM BLOG_Info INNER JOIN BLOG_User ON BLOG_Info.uid = BLOG_User .uid order by BLOG_Info.dtime desc"

else if @PageIndex = @PageCount-1 - last page

set @SQLSTR = "select top "+STR( @PageSize )+"BLOG_Info.title, BLOG_Info.detail, BLOG_User.uname, BLOG_Info.dtime, BLOG_User.url, BLOG_Info.iid FROM BLOG_Info INNER JOIN BLOG_User ON BLOG_Info.uid = BLOG_User .uid where BLOG_Info.iid>(select max(BLOG_Info.iid) from (select top "+STR(@PageSize * @PageIndex )+" BLOG_Info.title, BLOG_Info.detail, BLOG_User.uname, BLOG_Info.dtime, BLOG_User.url , BLOG_Info.iid FROM BLOG_Info INNER JOIN BLOG_User ON BLOG_Info.uid = BLOG_User.uid order by BLOG_Info.dtime desc )) order by BLOG_Info.dtime desc"

else
set @SQLSTR = "select top "+STR( @PageSize )+"BLOG_Info.title, BLOG_Info.detail, BLOG_User.uname, BLOG_Info.dtime, BLOG_User.url, BLOG_Info.iid FROM BLOG_Info INNER JOIN BLOG_User ON BLOG_Info.uid = BLOG_User .uid where BLOG_Info.iid>(select max(BLOG_Info.iid) from (select top "+STR(@PageSize * @PageIndex )+" BLOG_Info.title, BLOG_Info.detail, BLOG_User.uname, BLOG_Info.dtime, BLOG_User.url , BLOG_Info.iid FROM BLOG_Info INNER JOIN BLOG_User ON BLOG_Info.uid = BLOG_User.uid order by BLOG_Info.dtime desc )) order by BLOG_Info.dtime desc"

EXEC (@SQLSTR)
GO

This is my stored procedure to see if it is wrong.

draculadue

Found the problem just now, mainly because of missing a letter, but now it becomes the error below
SqlException (0x80131904): Line 1: There is a syntax error near')'. ]

draculadue

Strange, I changed the value of @PageSize to 10.

一桶姜山

There is an error in your stored procedure.
"+STR( @PageSize )+"

Not so written.

draculadue

How should I write it, but at present I change the input value @PageSize to 1, 2, it won't work, oh forget to say that the total number of records is three