写图片c:1.jpg到表cinfo中

复制代码 代码如下:

private static void AddCinfo()

{

string strSql = "insert into cinfo (srvtitle,csttitle,introduction,logo) values

(@srvtitle,@csttitle,@introduction,@logo)";

SqlParameter[] parms =

{

new SqlParameter("@srvtitle",SqlDbType.VarChar,30),

new SqlParameter("@csttitle",SqlDbType.VarChar,30),

new SqlParameter("@introduction",SqlDbType.NVarChar,500),

new SqlParameter("@logo",SqlDbType.Image)

};

parms[0].Value = "旅业互动";

parms[1].Value = "lyhd";

parms[2].Value = "简介";

string filePath = @"c:1.jpg";

FileStream fs = File.OpenRead(filePath);

byte[] content = new byte[fs.Length];

fs.Read(content, 0, content.Length);

fs.Close();

parms[3].Value = content;

DBHelper.ExecuteNonQuery(CommandType.Text, strSql, parms);

}

读取图片的页面 test.aspx

复制代码 代码如下:

protected void Page_Load(object sender, EventArgs e)

{

string strSql = "select * from cinfo where id=1";

SqlDataReader reader=DBHelper.ExecuteReader(CommandType.Text, strSql, null);

if(reader.Read())

{

byte[] c=(byte[])reader["logo"];

Response.BinaryWrite(c);

}

}

用来显示图片的页面 test2.aspx

复制代码 代码如下:

<img src="test.aspx" />