Storing and displaying images in a database (storage one)

Data | database | Display using system;using system.data.sqlclient;using system.data.sqltypes;using system.io;string Imagefilelocation= "D:\images\"; string imagefileprefix= "cereal"; int numberimagefiles=7;string imagefiletype= ". gif" ; int maximagesize=10000; SqlConnection imageconnection=null; SqlCommand Imagecommand=null;] Several methods to use; void OpenConnection () {//create SqlConnection Object imageconnection=new SqlConnection ( Configurationsettings.appsettings["Wind"]); Open connection Imageconnection.open (); }void CloseConnection () {//close the connection imageconnection.close ();} void CreateCommand () {imagecommand=new SqlCommand (); imagecommand.connection=imageconnection;} void ExecuteCommand (String commandtext) {int commandresult;imagecommand.commandtext=commandtext;commandresult= Imagecommand.executenonquery ();} void Createimagetable () {ExecuteCommand ("IF exists{" + "SELECT table_name" + "from Infoemation_schema.) TABLES "+" WHERE table_name= ' imagetable ' "+") DROP TABLE imagetable "); ExecuteCommand (" CREATE TABLE imagetablE ("+" ImageFile NVARCHAR (), "+" ImageData IMAGE "+") ");}