Using system;
Using system. Data;
Using system. configuration;
Using system. collections;
Using system. Web;
Using system. Web. Security;
Using system. Web. UI;
Using system. Web. UI. webcontrols;
Using system. Web. UI. webcontrols. webparts;
Using system. Web. UI. htmlcontrols;
Using system. Data. sqlclient;
Using system. IO;
Using system. drawing;
Public partial class _ default: system. Web. UI. Page
{
Protected void page_load (Object sender, eventargs E)
{
If (! Page. ispostback)
{
Sqlconnection con = new sqlconnection ("Server = (local); User ID = sa; Pwd =; database = database name ");
Sqldataadapter Ada = new sqldataadapter ("select * From tb_17", con );
Con. open ();
Dataset DS = new dataset ();
Ada. Fill (DS );
Dropdownlist1.datasource = Ds;
Dropdownlist1.datatextfield = "field ";
Dropdownlist1.datavaluefield = "field ";
Dropdownlist1.databind ();
Image1.visible = false;
}
}
Protected void button#click (Object sender, eventargs E)
{
Image1.visible = true;
Sqlconnection con = new sqlconnection ("Server = (local); User ID = sa; Pwd =; database = database name ");
String imagename = "";
Try
{
Con. open ();
Sqlcommand COM = new sqlcommand ("Select name from table name where field =" + dropdownlist1.text + "", con );
Sqldatareader DR = com. executereader ();
Dr. Read ();
Memorystream MS = new memorystream (byte []) Dr ["name"]);
Bitmap image = new Bitmap (MS );
String filepath = server. mappath ("files /");
Directoryinfo dir = new directoryinfo (filepath );
Fileinfo [] filecount = dir. getfiles ();
Int I = filecount. length;
Imagename = filepath + (I + 1) + ". jpg ");
Image. Save (imagename );
Dr. Close ();
Image1.imageurl = "files/" + (I + 1) + ". jpg ");
}
Finally
{
Con. Close ();
}
}
}