返回首页

有人告诉我要引用default1默认上传按钮被点击一次,
返回无效操作异常的用户代码未处理
填写SelectCommand.Connection属性尚未初始化:

default1

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

using System.IO;

 



namespace Defult

{

    public partial class _Default : System.Web.UI.Page

    {

        //SqlConnection sqlcon = new SqlConnection("PDF_Files");

        SqlCommand sqlcmd = new SqlCommand();

        //SqlDataAdapter da = new SqlDataAdapter();

        DataTable dt = new DataTable();

        protected void Page_Load(object sender, EventArgs e)

        {

 

            if (!Page.IsPostBack)

            {

                LoadGrid();

            }

            Label1.Text = "";

 

        }

 

        void LoadGrid()

    {

        //SqlConnection sqlcon = new SqlConnection("PDF_Files");

        SqlCommand sqlcmd = new SqlCommand("select * from Files");

       SqlDataAdapter da = new SqlDataAdapter(sqlcmd);

        da.Fill(dt);

        if (dt.Rows.Count > 0)

        {

            GridView1.DataSource = dt;

            GridView1.DataBind();

        }

        //sqlcon.Close();

    }

 

        protected void Button1_Click(object sender, EventArgs e)

        {

            //PDF Upload Code to SQL SERVER database table

            if (FileUpload1.HasFile)

            {

                Stream fs = default(Stream);

                fs = FileUpload1.PostedFile.InputStream;

                BinaryReader br1 = new BinaryReader(fs);

                byte[] pdfbytes = br1.ReadBytes(FileUpload1.PostedFile.ContentLength);

                

                SqlCommand sqlcmd = new SqlCommand("insert into Files(pdfname,pdfcontent) values (@pdfname,@pdfcontent)");

                sqlcmd.Parameters.Add("@pdfname", FileUpload1.FileName);

                sqlcmd.Parameters.Add("@pdfcontent", pdfbytes);

                sqlcmd.ExecuteNonQuery();

                //sqlcon.Close();

                Label1.Text = "Successfully pdf upload to SQL Server database.";

                LoadGrid();

            }

 

        }

 



    }

}

默认2
{C}

回答

评论会员: 时间:2