title: Select from table, then insert that (value + 1) into another table?
body: <p>Thanks for viewing my question. Hopefully I can get an answer. I have a project in C#. I am trying to grab an IF field from a table. Once I have that data, I want to increment the value by 1. (For example, I grab 10000, and add 1 which makes it 10001.) Then, I want to input the incremented value into another table. </p>
  
  <p>This is what I have so far (only the select query): </p>
  
  <pre><code>cmd = new SqlCommand("select reqID from [RequestID] where (ID = 1)", con);
  </code></pre>
  
  <p>I have tried using DataSet without any progress. I'm not too familiar with coding, but trying!</p>
  
  <pre><code>DataSet ds = new DataSet();
  myDA1.Fill(ds, "RequestID");
  Int64 RequestID = default(Int64);
  RequestID = ds.Table("RequestID").Rows(0).Item("ReqID");
  RequestID += 1;
  </code></pre>
  
  <p>Any help will be appreciated!</p>
  
  <p>Josh</p>