技术资料 > .Net专区 > Asp.Net开发 : 图片上传的数据库部分(自动生成所略图)

图片上传的数据库部分(自动生成所略图)

March 25,2004

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;
         myCommand.Parameters.Add(parameterPicType);

         SqlParameter parameterPicIntro = new SqlParameter("@picIntro", SqlDbType.Char, 255);
         parameterPicIntro.Value = strPicIntro;
         myCommand.Parameters.Add(parameterPicIntro);

         SqlParameter parameterThumbnail = new SqlParameter("@thumbnail", SqlDbType.Char, 50);
         parameterThumbnail.Value = strThumbnail;
         myCommand.Parameters.Add(parameterThumbnail);

         SqlParameter parameterHostAddress = new SqlParameter("@opIP", SqlDbType.Char, 15);
         parameterHostAddress.Value = Context.Request.UserHostAddress;
         myCommand.Parameters.Add(parameterHostAddress);

         //SqlParameter parameterRID = new SqlParameter("@returnID", SqlDbType.Int);
         //parameterReturnUserID.Value = -1;
         //parameterRID.Direction = ParameterDirection.Output;
         //myCommand.Parameters.Add(parameterRID);



         // Execute the command in a try/catch to catch duplicate username errors
         try
         {
            // Open the connection and execute the Command
            myConnection.Open();
            myCommand.ExecuteNonQuery();
         }
         catch
         {

            // failed to create a new user
            return -1;
         }
         finally
         {

            // Close the Connection
            if (myConnection.State == ConnectionState.Open)
                  myConnection.Close();
         }

         return 1;

      }