title: Update values in table: sql - APSX
body: <p>I have the following code:</p>
  
  <p><strong>updated</strong></p>
  
  <pre><code> try
      {
          ArticleId = Request.QueryString["ArticleId"].ToString();
          NewArticleTitle = Request.Form["ArticleTitle"].ToString();
          NewArticleDate = Request.Form["ArticleDate"].ToString();
          NewArticleBody = Request.Form["ArticleBody"].ToString();
  
  
          string dpath = Server.MapPath(@"App_Data") + "/MySite.mdb";
          string connectionstring = @"Data source='" + dpath + "';Provider='Microsoft.Jet.OLEDB.4.0';";
          OleDbConnection con = new OleDbConnection(connectionstring);
          string QuaryString = String.Format("update tblarticles set articletitle='{0}', articlebody='{1}', postdate='{2}'  where articleid={3}", NewArticleTitle, NewArticleBody, NewArticleDate, ArticleId);
          OleDbCommand cmd = new OleDbCommand(QuaryString, con);
          OleDbDataAdapter da = new OleDbDataAdapter(cmd);
          DataSet ds = new DataSet();
          da.Fill(ds, "tbl");
          con.Close();
          Response.Redirect("ArticlesTable.aspx");
      }
          catch { }
  </code></pre>
  
  <p>The ArticleId is an AUTO INCREMENT (in number type) 
  When it  got to this line  <code>da.Fill(ds, "tbl");</code> the program coutinue to the catch.
  My quastion is how can I prevent it so the table will be really update ?
  Wish for help, thanks!</p>