Delete image functions unrelated to databases

zj123.sqldb. dbaccess DBA = new zj123.sqldb. dbaccess (this. textbox2.text. trim ();
// insert temporary table data --
string tempinsertsql = "insert into tempdatafiles ([filename]) of the corresponding year and month select [filename] From datafiles where [filename] Like '% "+ this. textbox1.text. trim () + "% '";
string tempdeletesql = "delete from tempdatafiles";
DBA. getstate (tempdeletesql + ";" + tempinsertsql + ";");
stringbuilder sbsql = new stringbuilder ("delete from drivefiles;");
system. io. directoryinfo dir = new system. io. directoryinfo (this. folderbrowserdialog1.selectedpath);

foreach (system. io. fileinfo fi in Dir. getfiles ()
{< br> sbsql. appendformat ("insert into drivefiles ([filename], [filepath]) values ('{0}', '{1}');", Fi. name, Fi. fullname);

}
Foreach (system. Io. directoryinfo di in Dir. getdirectories ())
{
Foreach (system. Io. fileinfo fi in Di. getfiles ())
{
Sbsql. appendformat ("insert into drivefiles ([filename], [filepath]) values ('{0}', '{1}');", Fi. name, Fi. fullname );

}

}
DBA. getstate (sbsql. tostring ());
String tempdeletsql = "select * From drivefiles where [filename] Not in (select [filename] From tempdatafiles )";
Datatable dt = DBA. gettable (tempdeletsql );
Int I = 0;
Int A = DT. Rows. count;
Foreach (datarow DR in DT. Rows)
{
System. Io. file. Delete (convert. tostring (Dr ["filepath"]). Trim ());
I ++;
This. label4.text = "deleting" + I. tostring () + "--- total" + A. tostring (). tostring ();
Application. doevents ();
}