1. How to get the picture from the input of the client side and how to write it into the corresponding field in the SQL Server table?(use Sql sentence only or use Active control?)
2. And how to show it to the client side when the client want to see it?
if somebody can give the answer in details (sample provided is the best) I will be very grateful!
<% dim conn,re
set conn=server.CreateObject ("adodb.connection")
conn.open "dsn=xx" 'xx为自己的DSN名
set re=conn.execute("select xx from xxx") 'xx为字段属性为“image"的字段名,xxx为表名
if re.eof=false then
Response.BinaryWrite (re.Fields.Item(0).GetChunk (re.Fields.Item(0).ActualSize ))
re.close
end if
conn.close
set re=nothing
set conn=nothing
%>