ASP+SQL SERVER2000电子商城系统 第25页

myCommand.CommandType = CommandType.StoredProcedure;
           
            // Execute the command
            myConnection.Open();
            SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
           
            // Return the datareader
            return result;
           
       
        }
 
        public SqlDataReader Category_BName_List(String AName)
        {
       
       
            // Create Instance of Connection and Command Object
            SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ESMS"]);
            SqlCommand myCommand = new SqlCommand("Category_BName_List", myConnection);
 
            // Mark the Command as a SPROC
            myCommand.CommandType = CommandType.StoredProcedure;
 
            // Add Parameters to SPROC
 
            SqlParameter parameterAName = new SqlParameter("@AName", SqlDbType.VarChar ,30);
            parameterAName.Value = AName;
            myCommand.Parameters.Add(parameterAName);
           
            // Execute the command
            myConnection.Open();
            SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
           
            // Return the datareader
            return result;
           
       
        }
 
 
        public SqlDataReader Category_Name_List(String BName,String AName)
        {
       
       
            // Create Instance of Connection and Command Object
            SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ESMS"]);
            SqlCommand myCommand = new SqlCommand("Category_Name_List", myConnection);
 
            // Mark the Command as a SPROC
            myCommand.CommandType = CommandType.StoredProcedure;
 
            // Add Parameters to SPROC
 
            SqlParameter parameterBName = new SqlParameter("@BName", SqlDbType.VarChar ,30);
            parameterBName.Value = BName;
            myCommand.Parameters.Add(parameterBName);
 
            SqlParameter parameterAName = new SqlParameter("@AName", SqlDbType.VarChar ,30);
            parameterAName.Value = AName;
            myCommand.Parameters.Add(parameterAName);
           
            // Execute the command
            myConnection.Open();
            SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
           
            // Return the datareader
            return result;
           
       
        }
 
 
        public SqlDataReader Products_AName_List(String AName)
        {
       
       
            // Create Instance of Connection and Command Object
            SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ESMS"]);
            SqlCommand myCommand = new SqlCommand("Products_AName_List", myConnection);
 
            // Mark the Command as a SPROC
            myCommand.CommandType = CommandType.StoredProcedure;
 
            // Add Parameters to SPROC
 
            SqlParameter parameterAName = new SqlParameter("@AName", SqlDbType.VarChar ,30);
            parameterAName.Value = AName;
            myCommand.Parameters.Add(parameterAName);
           
            // Execute the command
            myConnection.Open();
            SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
           
            // Return the datareader
            return result;
           
       
        }
 
        public SqlDataReader Products_BName_List(String BName)
        {
       
       
            // Create Instance of Connection and Command Object
            SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ESMS"]);
            SqlCommand myCommand = new SqlCommand("Products_BName_List", myConnection);
 
            // Mark the Command as a SPROC
            myCommand.CommandType = CommandType.StoredProcedure;
 
            // Add Parameters to SPROC
 
            SqlParameter parameterBName = new SqlParameter("@BName", SqlDbType.VarChar ,30);
            parameterBName.Value = BName;
            myCommand.Parameters.Add(parameterBName);

 << 上一页  [21] [22] [23] [24] [25] [26] [27] [28] [29] [30]  ... 下一页  >> 

ASP+SQL SERVER2000电子商城系统 第25页下载如图片无法显示或论文不完整，请联系qq752018766