title: Conversion of Varchar to int
body: <p>Need help! I cannot retrieve data in SQ L, because the value is <code>100-200</code>
  and it says that it needs to be converted it to Integer, but it is Var char data type.
  So i think the problem is about the "-", then the error in the code is in
  the data table code, so what to do?</p>
  
  <pre><code>Private Sub RetriveData(ByVal ID As String)
      If Sql.HasConnection() = True Then
  
          Dim DT As DataTable = Sql.ExecuteDataTable("SELECT (EmpID As varchar), FirstName,MidName,LastName,Gender,BirthDate,CivilStat,Address,ContactNum FROM EmployeeTable Where EmpID=" &amp; ID)
          For Each Data As DataRow In DT.Rows
              EmpID_Txt.Text = Data(0)
              FirstName_Txt.Text = Data(1)
              MiddleName_Txt.Text = Data(2)
              LastName_Txt.Text = Data(3)
              Gender_CB.Text = Data(4)
              BirthDate_DTP.Value = Data(5)
              CivilStat_CB.Text = Data(6)
              Address_Txt.Text = Data(7)
              Contact_Txt.Text = Data(8)
          Next
      Else
          MsgBox("System Database Cannot be Connected", MsgBoxStyle.Information)
      End If
  End Sub
  </code></pre>