日期:2009-05-18  浏览次数:20448 次


    public int FePicDataSet(string strPicTitle, string strPicDate, string strPicName, int intPicType, string strPicIntro, string strThumbnail, int opID)
        {

            //string strPicTitle,
            //string strPicDate,
            //string strPicName,
            //int intPicType,
            //string strPicIntro,
            //string strPicName,
            //string strThumbnail,
            //int opID
            SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
            SqlCommand myCommand = new SqlCommand("mag_FePicDataSet", myConnection);
            // Mark the Command as a SPROC
            myCommand.CommandType = CommandType.StoredProcedure;

            // Add Parameters to SPROC
            SqlParameter parameterUserId = new SqlParameter("@opID", SqlDbType.Int);
            parameterUserId.Value = opID;
            myCommand.Parameters.Add(parameterUserId);
            
            SqlParameter parameterPicTitle = new SqlParameter("@picTitle", SqlDbType.Char, 30);
            parameterPicTitle.Value = strPicTitle;            
            myCommand.Parameters.Add(parameterPicTitle);

            SqlParameter parameterPicDate = new SqlParameter("@picDate", SqlDbType.Char, 10);
            parameterPicDate.Value = strPicDate;
            myCommand.Parameters.Add(parameterPicDate);        

            SqlParameter parameterPicName = new SqlParameter("@picName", SqlDbType.Char, 50);
            parameterPicName.Value = strPicName;
            myCommand.Parameters.Add(parameterPicName);        

            SqlParameter parameterPicType = new SqlParameter("@picType", SqlDbType.Int);
            parameterPicType.Value = intPicType;
&