.net传图片到MySQL_ASP.NET 上传图片至数据库并读取图片显示

淡淡的烟草味﹌ 2022-10-31 13:56 253阅读 0赞

aspx

![noimg.gif][]

相关图片:

\--%>

aspx.cs

public string \_path = "";

protected void Page\_Load(object sender, EventArgs e)

if (!IsPostBack)

if (Request.QueryString\["key"\] != null)

string sql = "select \* from ChiH\_Material where id=" + Request.QueryString\["key"\].ToString();

DataTable dt = bc.ReadTable(sql);

if (dt.Rows.Count > 0)

imghead.Src = dt.Rows\[0\]\["picture"\].ToString();

else

protected void Button1\_Click(object sender, EventArgs e)

try

uploadfile2();

if (Request.QueryString\["key"\] != null)

string sql = "update ChiH\_Material set inside\_model='" + inside\_model.Value.Trim() + "',model='" + model.Value.Trim() + "',high\_flower='" + high\_flower.Value.Trim() + "',breadth='" + breadth.Value.Trim() + "',Stock='" + Stock.Value.Trim() + "',go\_code='" + go\_code.Value.Trim() + "',product\_price='" + product\_price.Value.Trim() + "',Grey\_price='" + Grey\_price.Value.Trim() + "',remark='" + remark.Value.Trim() + "',picture='" + \_path + "' where id=" + Request.QueryString\["key"\].ToString();

bc.execsql(sql);

else

string sql = "insert into ChiH\_Material(inside\_model,sup\_no,model,high\_flower,breadth,Stock,go\_code,product\_price,Grey\_price,remark,picture) values('" + inside\_model.Value.Trim() + "','" + sup\_no.Value.Trim() + "','" + model.Value.Trim() + "','" + high\_flower.Value.Trim() + "','" + breadth.Value.Trim() + "','" + Stock.Value.Trim() + "','" + go\_code.Value.Trim() + "','" + product\_price.Value.Trim() + "','" + Grey\_price.Value.Trim() + "','" + remark.Value.Trim() + "','" + \_path + "')";

bc.execsql(sql);

Response.Write("");

catch (Exception)

Response.Write("");

public void uploadfile2()

bool fileOK = false;

string path = Server.MapPath("../drawimg/");

\_path = "../drawimg/" + FileUpload1.FileName;

if (FileUpload1.HasFile)

String fileExtension = System.IO.Path.GetExtension(FileUpload1.FileName).ToLower();

String\[\] allowedExtensions = \{ ".gif", ".png", ".bmp", ".jpg" \};

for (int i = 0; i < allowedExtensions.Length; i++)