//创建链接数据库的字符串
string SqlStr = "Server=DESKTOP-5R3FQND;User Id=sa;Pwd=123456;DataBase=db_CCSESITE";
SqlConnection sqlcon = new SqlConnection(SqlStr); //创建SqlConnectin对象
SqlDataAdapter sqlda = new SqlDataAdapter(); //创建SqlDataAdapter对象
//给SqlDataAdapter的SelectCommand赋值
sqlda.SelectCommand = new SqlCommand("select title, date, image, content from fast_news where id = 12", sqlcon);
DataSet ds = new DataSet(); //创建DataSet对象
sqlda.Fill(ds); //填充数据集
DataTable dt = ds.Tables[0].DefaultView.ToTable();
//标题 日期 图片 内容
article_title = dt.Rows[0][0].ToString();
article_date = dt.Rows[0][1].ToString();
article_content = dt.Rows[0][3].ToString();
//使用数据库中存储的图片创建内存数据流
MStream = new MemoryStream((byte[])dt.Rows[0][2]);
string base64 = Convert.ToBase64String(MStream.ToArray());
Image1.ImageUrl = "data:image/png;base64," + base64;
前台代码:
<asp:Image ID="Image1" runat="server" />