求救！asp.net+c#上传图片到access数据库及显示图片的代码？

[unexpectedly]

不要VB.net和带SQL Server存储过程的方法，用不上哦！

[unexpectedly]

U P

[sjc0]

我用了存储过程不过你改改
Stream stream = insertimg.PostedFile.InputStream;
byte[] buffer = new byte[insertimg.PostedFile.ContentLength];
int aa = stream.Read(buffer, 0, (int)stream.Length);
string filename = System.IO.Path.GetFileNameWithoutExtension(insertimg.PostedFile.FileName.ToString());
string expandname = Path.GetExtension(insertimg.PostedFile.FileName.ToString());
int size = (int)stream.Length;
stream.Read(buffer, 0, size);
你把buffer传入你的image字段就可以了！

[elite2018]

store it :


Stream imgdatastream = File1.PostedFile.InputStream;

int imgdatalen = File1.PostedFile.ContentLength;

string imgtype = File1.PostedFile.ContentType;

string imgtitle = TextBox1.Text;

byte[] imgdata = new byte[imgdatalen];

int n = imgdatastream.Read(imgdata,0,imgdatalen);

string connstr=

((NameValueCollection)Context.GetConfig

("appSettings"))["connstr"];

SqlConnection connection = new SqlConnection(connstr);

SqlCommand command = new SqlCommand

("INSERT INTO ImageStore(imgtitle,imgtype,imgdata)

VALUES ( @imgtitle, @imgtype,@imgdata )", connection );



SqlParameter paramTitle = new SqlParameter

("@imgtitle", SqlDbType.VarChar,50 );

paramTitle.Value = imgtitle;

command.Parameters.Add( paramTitle);



SqlParameter paramData = new SqlParameter

( "@imgdata", SqlDbType.Image );

paramData.Value = imgdata;

command.Parameters.Add( paramData );



SqlParameter paramType = new SqlParameter

( "@imgtype", SqlDbType.VarChar,50 );

paramType.Value = imgtype;

command.Parameters.Add( paramType );



connection.Open();

int numRowsAffected = command.ExecuteNonQuery();

connection.Close();

[elite2018]

show it :

private void Page_Load(object sender, System.EventArgs e)

{

string imgid =Request.QueryString["imgid"];

string connstr=((NameValueCollection)

Context.GetConfig("appSettings"))["connstr"];

string sql="SELECT imgdata, imgtype FROM ImageStore WHERE id = "

+ imgid;

SqlConnection connection = new SqlConnection(connstr);

SqlCommand command = new SqlCommand(sql, connection);

connection.Open();

SqlDataReader dr = command.ExecuteReader();

if(dr.Read())

{

Response.ContentType = dr["imgtype"].ToString();

Response.BinaryWrite( (byte[]) dr["imgdata"] );

}

connection.Close();

}

[unexpectedly]

多谢楼上两位兄弟，上传图片有没有不带存储过程的？你们的都带啊？

[xhzuo]

你把存储过程中的sql语句提取出来，不就能用了吗