圖片上傳的資料庫部分(自動產生所略圖)

來源:互聯網
上載者:User
上傳|資料|資料庫     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;

        }

相關文章

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。