ذخیره و بازیابی ادرس عکس در دیتا بیس

[h_r_sh]

using system.IO;

void AddImage(){

openFileDialog o=new openFileDialog();

o.filter="jpeg | *.jpg";

o.title="Select Image";

if(o.showDialog(this)==DialogResult.Ok){

string s=o.FileName;

string t=Path.GetFileNameWithoutExtension(s);

//using mdb access database format

using(OledbConnection cn=new OledbConnection(myConnectionString)){

oledbCommand cmd=new oledbCommand("insert into tblSample (imageAddress,imageName) values(@a,@b)",cn);

oledbParameter ap=new oledbParameter("@a",s);

oledbParameter bp=new oledbParameter("@b",t);

cmd.Parameters.AddRange(new oledbParameter[] {ap,bp});

if(cn.state==ConnectionState.Closed)

cn.open();

cmd.ExecuteNonQuery();}}}