using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
string ImgPath = FileUpload1.PostedFile.FileName;
string ImgName = ImgPath.Substring(ImgPath.LastIndexOf("//") + 1);
string ImgExtend = ImgPath.Substring(ImgPath.LastIndexOf(".") + 1);
if (!(ImgExtend == "bmp" || ImgExtend == "jpg" || ImgExtend == "gif"))
{
Label3.Text = "上傳圖片的格式不正確!";
return;
}
int FileLen = this.FileUpload1.PostedFile.ContentLength;
Byte[] FileData = new Byte[FileLen];
HttpPostedFile hp = FileUpload1.PostedFile;//建立訪問用戶端上傳檔案的對象
Stream sr = hp.InputStream;//建立資料流對象
sr.Read(FileData, 0, FileLen);//將圖片資料放到FileData數組對象執行個體中,其中0代表數組指標的起始位置,FileLen表示要讀取流的長度(指標的結素位置)
SqlConnection con = new SqlConnection("server=(local);user id=sa;pwd=;database=");
con.Open();
SqlCommand com = new SqlCommand("INSERT INTO tb_15 (name) VALUES (@imgdata)", con);
com.Parameters.Add("@imgdata", SqlDbType.Image);
com.Parameters["@imgdata"].Value = FileData;
com.ExecuteNonQuery();
Label1.Text = "儲存成功!";
}
catch (Exception error)
{
Label1.Text = "處理出錯!原因為:" + error.ToString();
}
}
}