First of all thanks to Shawn Walcheske for help on the solution..
Here was the problem.

I have a addblog.aspx. This page allows me to enter a new blog such as this one. Upon save of the new entry I wanted to be redirected to default.aspx where I would proudly see my new entry. The problem was I wasnt seeing the new entry.

I would enter the blog, press save, see default and need to refresh my browser to see the new entry. This looked like a clear case of viewstate. I tried everything.

Here was the code:

  strSQL = "Insert into blogs (user_name,blogdate,subject,message) values "
        strSQL &= " ('" & System.Web.HttpContext.Current.User.Identity.Name.ToString & "', "
        strSQL &= " #" & Now() & "#, "
        strSQL &= " '" & txtSubject.Text.Replace("'", "''") & "', "
        strSQL &= " '" & txtBody.Text.Replace("'", "''") & "') "
        comm.Connection = conn
        comm.CommandText = strSQL

        comm.ExecuteNonQuery()
        System.Threading.Thread.Sleep(1000)
        conn.Close()

Notice the new line:
System.Threading.Thread.Sleep(1000)

This worked like a charm. Well let me check it first…

Anyway. This is the deal. The page was refreshing quicker than the datatable in my access (I know, I know) database. I needed to give poor access 2003 a little more time to do its job.

Thanks Shawn.

No Comments
Uncategorized