protected void UpdateImageListing_Click(object sender, EventArgs e) { AmazonS3 util = new AmazonS3(); Hashtable State = (Hashtable)HttpRuntime.Cache[Session.SessionID]; ArrayList image_list = util.GetStockImageUrls(State); DB db = new DB(); db.ViziAppsExecuteNonQuery(State, "DELETE FROM stock_images"); foreach (String url in image_list) { int start = url.IndexOf("apps/images/") + 12; string type = url.Substring(start,url.IndexOf("/",start) - start); string sql = "INSERT INTO stock_images (image_url,type) VALUES ('" + url + "','" + type + "')"; db.ViziAppsExecuteNonQuery(State, sql); } db.CloseViziAppsDatabase(State); Message.Text = "Image URLs have been updated in the database."; }