title: How to use a stored procedure to retrieve the largest CustID number then add 1 to this returned CustID number and display this in the CustID textbox
body: <p>I need to do exactly as the title says, I have created the stored procedure as shown below.</p>
  
  <pre><code>CREATE PROCEDURE FindMaxCustID    
  AS
  SELECT max(CustID) 
  FROM Customer
  </code></pre>
  
  <p>Now I just need to call it and add 1 to the returned CustID, then display it in my txtCustID textbox. This is what I have so far...</p>
  
  <pre><code>Clear();
  command.Connection = conn;
  command.CommandType = CommandType.StoredProcedure;
  command.CommandText = "FindMaxCustID";
  </code></pre>
  
  <p>But now I am stuck, I don't know how to code it.</p>