Problem updating images

GoingCranky · Apr 28, 2012

I have a file upload screen that lets a user upload an image and then display the image on the screen via an image control. It works fine the first time they upload an image, but the second time they over write the first image it will not refresh the image control unless they hit the refresh button. I have tried all kinds of things like response.redirecting back to the page, loading in a dummy image then loading in the uploaded image, etc, but none of these work. I am guessing it is more of an IE issue where IE is caching the first image, any idea on how to stop it from caching the image so that each and every time the image is pulled from disk?... articles on ASP (classic) that tells about disabling the back button. It'll explain caching and how to avoid it. Then, it shouldn't be too difficult to take that and apply it to .NET. -DougI tried a bunch of those ideas, all of them that I could find actually but none seem to work. I can not get IE to stop caching on a response.redirect back to the same page. Anyone else have ideas?I had a similar caching problem with a datagrid. The page was a database editor. The first time the table was updated and the datagrid was binded with the new data from the table. But if you tried to update the table again it would not change the datagrid even though I binded the datagrid. With multiple updates the datagrid was always one step behind the data in the table. I solved the problem by binding the datagrid and then response.redirect and binding the datagrid again on Page_Load. If anyone has a better way of doing it let me know. Thank you Aaron P.S. here is the database editor page: <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <%@ Page Trace="False" %> <html> <script language="VB" Debug="true" runat="server"> Dim oConnection As OleDbConnection Dim oCommand As OleDbCommand Dim myReader as OleDbDataReader Sub Page_Load(Src As Object, E As EventArgs) 'Create the connection oConnection = New OleDbConnection(ConfigurationSettings.AppSettings("constring")) Message.InnerHtml = "Enter in Sql" if Len(Request.QueryString("sql")) > 0 then BindGrid(Request.QueryString("sql")) Message.InnerHtml = Request.QueryString("executed") Page.DataBind() end if If Not (IsPostBack) End If End Sub Sub sql_Click(Sender As Object, E As EventArgs) Message.InnerHtml = sqltext.text if Instr(sqltext.text, "select ") then BindGrid(sqltext.text) else oCommand = new OleDbCommand(sqltext.text, oConnection) oCommand.Connection.Open() Try oCommand.ExecuteNonQuery() Dim Sqlparts as Array Dim select_table as String = "select * from " if Instr(sqltext.text, "delete from ") then Sqlparts = Split(sqltext.text, " ") select_table = select_table & Sqlparts(2) else if Instr(sqltext.text, "update ") then Sqlparts = Split(sqltext.text, " ") select_table = select_table & Sqlparts(1) end if if Instr(sqltext.text, "insert into ") then Sqlparts = Split(sqltext.text, " ") select_table = select_table & Sqlparts(2) end if end if if Len(select_table) > 0 then BindGrid(select_table) Response.Redirect (Request.ServerVariables("Path_Info") & "?sql=" & select_table & "&executed=" & sqltext.text) end if Message.InnerHtml = "Executed : " & sqltext.text Catch Exp As OleDbException 'Trace.Write("Exp.Message",Exp.Message) Message.InnerHtml = "ERROR: A OleDbException." & Exp.Message & " " & sqltext.text Message.Style("color") = "red" End Try oCommand.Connection.Close() end if End Sub Sub BindGrid(Sqlstr As String) Dim DS As DataSet Dim oCommand As OleDbDataAdapter oCommand = new OleDbDataAdapter(Sqlstr, oConnection) DS = new DataSet() Try oCommand.Fill(DS, "SqlTable") Dim Source As DataView = DS.Tables("SqlTable").DefaultView MyDataGrid.DataSource = Source MyDataGrid.DataBind() Catch Exp As OleDbException 'Trace.Write("Exp.Message",Exp.Message) Message.InnerHtml = "ERROR: A OleDbException." & Exp.Message & " " & sqltext.text Message.Style("color") = "red" End Try End Sub </script> <body> <form runat="server"> <ASP

ataGrid id="MyDataGrid" runat="server" Width="800" BackColor="#ccccff" BorderColor="white" ShowFooter="false" CellPadding=3 CellSpacing="0" Font-Name="Verdana" Font-Size="8pt" HeaderStyle-BackColor="#aaaadd" /> <asp:textbox id="sqltext" value=http://aspmessageboard.com/archive/index.php/"" rows="10" cols="60" TextMode="Multiline" runat="server" /> <input type="submit" OnServerClick="sql_Click" value="Execute Sql" runat="server"> </form> </body> </html>

Problem updating images

GoingCranky

New Member