title: How to convert values of a datatable from string to integer
body: <p>I'm making a fine calculator in a library system. In it,I need to calculate the fine of a given day. For this,I use a data table to load the fine amounts and then,I need to calculate the total fine amount by adding each fine amount.But I'm having a problem in parsing the fine values which are in string format to integer.Here is a screenshot of the error.</p>
  
  <p><a href="https://i.stack.imgur.com/aGAWB.jpg" rel="nofollow noreferrer">Here is a screenshot of the error.</a></p>
  
  <p>And here is the code which I used to convert the string values to integer and calculate the total fine.</p>
  
  <pre><code>int sum1 = 0;
  int myNum;       
  String Display;
  
  private void btnNext_Click(object sender, EventArgs e)
  {
      try
      {
          if (rbtnToday.Checked == true)
          {
              DateTime today = DateTime.Today;
              Con.Open();
              String select_today_query = "SELECT Fine FROM BookReceiveMem WHERE RecDate='" + today + "'";
              Sqlda = new SqlDataAdapter(select_today_query, Con);
              DataTable Dt = new DataTable();
              Sqlda.Fill(Dt);
              Con.Close();
              foreach (DataRow row in Dt.Rows)
              {
                  myNum = int.Parse(Dt.Columns[0].ToString());
                  sum1 = sum1 + myNum;
              }
              Display = sum1.ToString();
              MessageBox.Show("Today Fine Amount is= " + Display, "Today Fine Calculation", MessageBoxButtons.OK, MessageBoxIcon.Information);
          }
  }
  </code></pre>
  
  <p>Is there any method to solve this problem?</p>