title: Database Error: There is no row at position 0
body: <p>I believe this question was asked several months back, but i believe my situation is different and the same rules may not apply. </p>
  
  <p>Everytime I execute this method that same error pops up. There is no row at position 0. If I change [0] to [1] or [15]; There is no row at [1] and etc. Could this mean that my database isnt even connecting? Should I write some kind of if statement to determine to check if the rows are even there? </p>
  
  <pre><code>    public bool UpdateOrderToShipped(string order)
  {
      orderNumber = order;
      string batch = ConfigurationManager.AppSettings["SuccessfulOrderBatch"];
      string statement = "UPDATE SOP10100 SET BACHNUMB = '"+ batch +"' WHERE SOPNUMBE = @SOPNUMBE";
      SqlCommand comm = new SqlCommand(statement, connectionPCI);
      comm.Parameters.Add("SOPNUMBE", orderNumber);
      try
      {
          comm.Connection.Open();
          comm.ExecuteNonQuery();
          comm.Connection.Close();
      }
      catch(Exception e)
      {
          comm.Connection.Close();
          KaplanFTP.errorMsg = "Database error: " + e.Message;
      }
  
      statement = "SELECT SOPTYPE FROM SOP10100 WHERE SOPNUMBE = @SOPNUMBE";
      comm.CommandText = statement;
      SqlDataAdapter da = new SqlDataAdapter(comm);
      DataTable dt = new DataTable();
      da.Fill(dt);
      soptype = dt.Rows[0]["SOPTYPE"].ToString();    //errror here
  
      return true;
  }
  </code></pre>