我不知道什吗原因,我改了一下写法,就正确了!!改写后的代码如下:
public static DataSet FillBBSDataset(string connectionString,CommandType commandType,string commandText, int iPage,int iPageSize, string TableName,params SqlParameter[] commandParameters)
{
SqlCommand cmd = new SqlCommand();
SqlConnection conn = new SqlConnection(connectionString);
try
{
PrepareCommand(cmd, conn, (SqlTransaction)null, commandType, commandText, commandParameters);
SqlDataAdapter da=new SqlDataAdapter(cmd);
DataSet ds=new DataSet(); int iStartID=(iPage-1)*iPageSize;
da.Fill(ds,iStartID,iPageSize,TableName); cmd.Parameters.Clear(); return ds;
}
catch
{
conn.Close();
throw;
}
}
public static DataSet FillBBSDataset(string connectionString,CommandType commandType,string commandText, int iPage,int iPageSize, string TableName,params SqlParameter[] commandParameters)
{
SqlCommand cmd = new SqlCommand();
SqlConnection conn = new SqlConnection(connectionString);
try
{
PrepareCommand(cmd, conn, (SqlTransaction)null, commandType, commandText, commandParameters);
SqlDataAdapter da=new SqlDataAdapter(cmd);
DataSet ds=new DataSet(); int iStartID=(iPage-1)*iPageSize;
da.Fill(ds,iStartID,iPageSize,TableName); cmd.Parameters.Clear(); return ds;
}
catch
{
conn.Close();
throw;
}
}
{
PrepareCommand(cmd, conn, (SqlTransaction)null, commandType, commandText, commandParameters);
}我是没使用过这样的写法,是不是这样就不行?