Gridview FIll VB.net

Dynamic fill data gridview using VB.net

Public Sub fill_gridview(ByRef dt As DataGridView, ByVal sql As String)

        Dim con As New OleDbConnection(getconstr)

        Dim da As New OleDbDataAdapter(sql, con)

        Dim ds As New DataSet

        Try

            da.Fill(ds, "My_table_temp_name")

            dt.DataSource = ds.Tables("My_table_temp_name")

        Catch ex As Exception

            MsgBox("Grid Filling Error from from class function" & vbCrLf & ex.Message)

        End Try

    End Sub

Next Topic