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();

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();

}