DataTable dt = DbHelperSQL.Query("select VehImage1 from JC_GCCheckRec").Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
System.IO.MemoryStream ms = new System.IO.MemoryStream((byte[])dt.Rows[i]["VehImage1"]);
System.Drawing.Image img = System.Drawing.Image.FromStream(ms);
if (!Directory.Exists(Directory.GetCurrentDirectory() +@"\INFTest\"))
{
Directory.CreateDirectory(Directory.GetCurrentDirectory()+@"\INFTest\");
}
img.Save(Directory.GetCurrentDirectory()+@"\INFTest\" + i.ToString() + ".jpg");
}