SqlConnection contest = new SqlConnection("server=.;database=foodblog;uid=sa;pwd=fuyiyun0506");
contest.Open();
string biaoti1 = biaoti.Value;
string caixi = Request.Form["type"];
string cidyuju = String.Format("select c_id from class where c_name='" + caixi + "'");
SqlCommand sql0 = new SqlCommand(cidyuju, contest);
object cid = sql0.ExecuteScalar();
contest.Close();
if (fil1.HasFile) //判斷是否選種檔案
{
string getfile = fil1.PostedFile.FileName;
string imgtype = fil1.PostedFile.ContentType; //檔案型別
int i = getfile.LastIndexOf(".");
string filename;
filename = getfile.ToLower().Substring(i, getfile.Length - i);
if (!(filename == ".jpg" || filename == ".jpeg" || filename == ".gif" || filename == ".png"))
{
ClientScript.RegisterStartupScript(ClientScript.GetType(), "uploaderr", "<script language='javascript' defer>alert('上傳檔案格式不正確')</script>");
return;
}
//上傳檔案
//FileUploadCompant(this.FileUpload1);
string strpath = fil1.PostedFile.FileName; //檔案名
byte[] getimage = new byte[fil1.PostedFile.ContentLength]; //將圖片轉為二進制檔案 ContentLength表示上傳檔案的長度
Stream filestream = fil1.PostedFile.InputStream;
//讀取資料
filestream.Read(getimage, 0, fil1.PostedFile.ContentLength);
contest.Open();
if (Session["username"] != null)
{
//定義
string eid = filename;
string uid = Session["username"].ToString();
string zhengwen = Request.Form["zhengwen"];
string nianyueri = DateTime.Now.ToString("yyyy-MM-dd");
// SqlConnection contest = new SqlConnection("server=.;database=foodblog;uid=sa;pwd=fuyiyun0506");
SqlCommand command = new SqlCommand("INSERT INTO essay(e_id,c_id,user_id,e_name,e_content,e_time,imgtype,imgdata,impath)VALUES(@e_id,@c_id,@user_id,@e_name,@e_content,@e_time,@imgtype, @imgdata, @impath)", contest);
//用引數的方式存進資料庫
SqlParameter pare1 = new SqlParameter("@e_id", SqlDbType.NChar, 10);
pare1.Value = eid;
command.Parameters.Add(pare1);
SqlParameter pare2 = new SqlParameter("@c_id", SqlDbType.NChar, 10);
pare2.Value = cid;
command.Parameters.Add(pare2);
SqlParameter pare3 = new SqlParameter("@user_id", SqlDbType.NChar, 10);
pare3.Value = uid;
command.Parameters.Add(pare3);
SqlParameter pare4 = new SqlParameter("@e_name", SqlDbType.NChar, 10);
pare4.Value = biaoti1;
command.Parameters.Add(pare4);
SqlParameter pare5 = new SqlParameter("@e_content", SqlDbType.VarChar, 8000);
pare5.Value = zhengwen;
command.Parameters.Add(pare5);
SqlParameter pare6 = new SqlParameter("@e_time", SqlDbType.Date);
pare6.Value = nianyueri;
command.Parameters.Add(pare6);
SqlParameter paretype = new SqlParameter("@imgtype", SqlDbType.VarChar, 50);
paretype.Value = imgtype;
command.Parameters.Add(paretype);
SqlParameter pareimgdata = new SqlParameter("@imgdata", SqlDbType.Image);
pareimgdata.Value = getimage;
command.Parameters.Add(pareimgdata);
SqlParameter pareimgpath = new SqlParameter("@impath", SqlDbType.VarChar, 200);
pareimgpath.Value = strpath;
command.Parameters.Add(pareimgpath);
int iresult = command.ExecuteNonQuery();
if (iresult > 0)
{
string strMsg = "提交成功！";
System.Web.HttpContext.Current.Response.Write("<Script Language='JavaScript'>window.alert('" + strMsg + "');</script>");
}
else
{
string strMsg = "提交失敗！";
System.Web.HttpContext.Current.Response.Write("<Script Language='JavaScript'>window.alert('" + strMsg + "');</script>");
}
contest.Close();
}
}
uj5u.com熱心網友回復：
大家幫幫忙
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/234771.html
標籤：ASP