如何加载图片在sql server中

[lrjt1980]

我不知道如何在sql server中存储图片，那位给我仔细的讲一下步骤。

[SK_Aqi]

不要存bit型在数据库中,存路径就可以了
这样项目建一个文件夹下,没有图片都有路径了存起来

[wuyq11]

保存路径到数据库
或保存二进制到到Image字段
using(SqlConnection conn=new SqlConnection(ConnectString))
{
conn.Open();
string strsql = "select photo from testimage where id=" + Request.QueryString["id"];
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = strsql;
SqlDataReader rd = cmd.ExecuteReader();
byte[] data = null;
if (rd.Read())
{
Response.Clear();
data = (byte[])rd["photo"];
Response.BinaryWrite(data);
Response.End();
}
}
Stream ImageStream;
string Path = FileUpload1.PostedFile.FileName;
int Size = FileUpload1.PostedFile.ContentLength;
string Type = FileUpload1.PostedFile.ContentType;
ImageStream = FileUpload1.PostedFile.InputStream;
byte[] Content = new byte[Size];
int Status = ImageStream.Read(Content, 0, Size);

SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
SqlCommand comm = new SqlCommand("insert into testimage(name,photo,Path,Type)values(@Name,@photo,@Path,@Type)", conn);

comm.CommandType = CommandType.Text;
comm.Parameters.Add("@Name", SqlDbType.VarChar, 255).Value = txtUserName.Text;
comm.Parameters.Add("@photo", SqlDbType.Image).Value = Content;
comm.Parameters.Add("@Path", SqlDbType.VarChar, 255).Value = Path;
comm.Parameters.Add("@Type", SqlDbType.VarChar, 255).Value = Type;

conn.Open();
comm.ExecuteNonQuery();
conn.Close();

[waterzouzou]

学习一下