ASP编程 PHP编程 JSP编程 NET编程 CGI编程 XML编程 
Google adsense申请技巧本站核心代理域名注册主机业务 快速发布你的买卖域名买卖网站信息 1元注册 cn域名
站长每日新闻导读 √ ·推荐万网空间¥120元 150m 站长网:站长必上的网站网站联盟大全本站代理万网域名55空间120元
 2006-12-10 10:31:14

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

来源: 字体:[ ]
  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;

      &nb
网站地图 - 域名注册续费虚拟主机代理 - 交易论坛 - 网站投稿 - 广告服务 - 帮助中心 - 联系我们
Copyright ©2003-2007 www.Admin5.com All Rights Reserved