// 保存
protected void Button3_Click(object sender, EventArgs e)
{
FileStream fs = null;
SqlConnection conn = new SqlConnection("Data Source=--IP--; Initial Catalog=--数据库--; User ID=--数据库帐号--;Pwd=--数据库密码--");
SqlCommand comm = new SqlCommand("insert into Bin values(@values_)", conn);
fs = new FileStream(Server.MapPath("c.jpg"), FileMode.Open, FileAccess.Read);
byte[] blob = new byte[fs.Length];
fs.Read(blob, 0, blob.Length);
fs.Close();
SqlParameter p = new SqlParameter("@values_", SqlDbType.VarBinary, blob.Length);
p.Value = blob;
comm.Parameters.Add(p);
conn.Open();
comm.ExecuteNonQuery();
if (int.Parse(comm.ExecuteNonQuery().ToString()) > 0)
{
Label3.Text = "成功";
}
else
{ Label3.Text = "失败"; }
conn.Close();
}
//读取
protected void Button4_Click(object sender, EventArgs e)
{
Byte[] blob = null;
FileStream fs = null;
SqlConnection conn = new SqlConnection("Data Source=--IP--; Initial Catalog=--数据库--; User ID=--数据库帐号--;Pwd=--数据库密码--");
SqlCommand comm = new SqlCommand("select pic from bin where id=8", conn);
conn.Open();
SqlDataReader dr = comm.ExecuteReader();
dr.Read();
blob = new Byte[dr.GetBytes(0, 0, null, 0, int.MaxValue)];
dr.GetBytes(0, 0, blob, 0, blob.Length);
dr.Close();
conn.Close();
fs = new FileStream(Server.MapPath("x1.jpg"), FileMode.Create, FileAccess.Write);//保存在程序路径下
fs.Write(blob, 0, blob.Length);
fs.Close();
Image3.ImageUrl = "x1.jpg";//从程序路径下 读到图片框中
}
我还是菜鸟...第一次写 写的不好 别笑我!
--加油、自己--