title: 'Value of type string cannot be converted to system.data.datatable' in vb.net
body: <p>This is my code. I keep having an error "value of type string cannot be converted to system.data.datatable"</p>
  
  <pre><code>Function GetTable() As DataTable
          Dim SQLConnection As New SqlConnection(ConfigurationManager.ConnectionStrings("Zeinchatconnection").ToString())
          Dim CommSQL As New SqlClient.SqlCommand
          Dim ChatDataAdapter As SqlDataAdapter
          Dim paramSQL As SqlClient.SqlParameter
          Dim DStable As DataSet
          Dim table As New DataTable
          Dim szName As String = ""
          Dim szNumber As String = ""
          Try
              If SQLConnection.State = ConnectionState.Closed Then
                  SQLConnection.Open()
              End If
              CommSQL.Connection = SQLConnection
              CommSQL.CommandType = CommandType.StoredProcedure
              CommSQL.CommandText = "spc_newselect"
  
  
  
          CommSQL.ExecuteNonQuery()
  
          ChatDataAdapter = New SqlDataAdapter(CommSQL)
          ChatDataAdapter.Fill(DSTable)
  
          table.Rows.Clear()
          table.Clear()
          table = DStable.Tables(0)
  
          Dim i As Integer = 0
  
          For i = 0 To table.Rows.Count - 1
              szName = szName &amp; "  " &amp; table.Rows(i).Item(0) &amp; table.Rows(i).Item(1)
              szNumber = szNumber &amp; "  " &amp; table.Rows(i).Item(0) &amp; table.Rows(i).Item(1)
          Next
  
          GetTable = "1"
      Catch ex As System.Data.SqlClient.SqlException
          GetTable = "0"
      Catch ex As Exception
          GetTable = "0"
  
          If (IsNothing(ChatDataAdapter) = False) Then ChatDataAdapter.Dispose()
          If (IsNothing(CommSQL) = False) Then CommSQL.Dispose()
          SQLConnection.Close()
      End Try
      Return table
  
  
  End Function
  </code></pre>
  
  <p>The part where the errors are is gettable= "1" and below.</p>