title: Fill data grid view from sql table
body: <p>I have four columns in <code>Datagridview</code>. I want to fill first two columns with data from sql database. I try to fill <code>Datagridview</code>. It not display data, but it generate rows. </p>
  
  <p>This is my code:</p>
  
  <pre><code>getConnect()
      Try
          Conn.Open()
          Dim strSQL As String = "SELECT EMP_ID, EMP_NAME FROM EMPLOYEE ORDER BY EMP_NAME ASC"
          Conn.Close()
          Dim da As New SqlDataAdapter(strSQL, Conn)
          Dim dt As New DataTable("EMPLOYEE")
          da.Fill(dt)
          ATCGRID.DataSource = dt
      Catch ex As SqlException
          MsgBox(ex.Message, MsgBoxStyle.Critical, "SQL Error")
      Catch ex As Exception
          MsgBox(ex.Message, MsgBoxStyle.Critical, "General Error")
      End Try
  </code></pre>
  
  <p>Please check my code and give me solution...</p>