存储过程,在线等!!!!!!!!!

Question

private const string INFO_TOP ="@top";
public InfoData GetInfo(string top)
{
dsCommand.TableMappings.Add("Table",InfoData.INFO_TABLE);
selectCommand = GetSqlCommandForStoredProcedure("GetInfo");
SqlParameter SQL_TOP = new SqlParameter(INFO_TOP, SqlDbType.Int, 4, top);
sqlParams = selectCommand.Parameters;
sqlParams.Add(SQL_TOP);
dsCommand.SelectCommand = selectCommand;
return (InfoData)(DataAdapterFill(new InfoData()));
}
protected SqlCommand GetSqlCommandForStoredProcedure(string storedProcedureName)
{
CheckDataAdapter();
SqlCommand sqlCommand = new SqlCommand(storedProcedureName, conn);
sqlCommand.CommandType = CommandType.StoredProcedure;
         return sqlCommand;
}
protected DataSet DataAdapterFill(DataSet dataSet)
{
dsCommand.Fill(dataSet);
return dataSet;
}
请问为什么参数传不到存储过程GetInfo里面啊

Answer 1

SqlParameter SQL_TOP = new SqlParameter("@INFO_TOP", SqlDbType.Int, 4, top);

Answer 2

试试
SqlParameter SQL_TOP = new SqlParameter(INFO_TOP, SqlDbType.Int);
SQL_TOP.Value=Convert.ToInt32(top);

Answer 3

sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "AutoCreateSchool";
SqlParameter para = sqlCommand.Parameters.Add("@school_id",SqlDbType.VarChar);
para.Value = ""+school_id;
sqlCommand.ExecuteNonQuery();

Answer 4

AutoCreateSchool 这是什么东西啊,