Hello every one.,

.. i have this problem about the datagridview..
i try many codes which are being posted by other person to other forum sites. As i can see the codes are really
working, but not for me .. i can add, delete, and retrieve data, but it doesn't show in
datagridview.the codes that are being posted has a button to click with, so that it will display data in datagridview ..i need a code that will automatically display the stored data inside mysql command line client..

can any one help me to find any solution to my problem ..

thanks and godbless=)

Edited 6 Years Ago by neolyte120109: n/a

I may be misunderstanding your question, but this is pretty much all there is to it to show data in a datagridview.
Just call the method from anywhere and it will display the data in the DataGridView.

Private Sub DisplayDataInDataGridView()
   yourDataGridView.DataSource = Nothing
   Dim con As New MySqlConnection(<your connectionstring>)
   Dim da As MySqlDataAdapter = Nothing
   Dim dt As New DataTable
   Dim SQL As String = ""

   Try
      SQL = "<your select query>"
      con.Open()
      da = New MySqlDataAdapter(SQL, con)
      da.Fill(dt)
      con.Close()
      yourDataGridView.DataSource = dt
   Catch ex As Exception
      If con.State = ConnectionState.Open Then
         con.Close()
      End If
   End Try
End Sub

i would like to query using a text.box then click in button then display what u search in datagridview..how?

This article has been dead for over six months. Start a new discussion instead.