有人告诉我要引用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}