Error: Value cannot be null. Name of parameter: datatable. VB.NET

Question

I’m trying to make an appointment at the bank and display it on a datagrid, I have not so much experience, I do technical course and is my first question here, the code I am using is this:

Public Sub PreencheDataGrid(ByRef x As DataGridView, ByVal op1 As Integer, ByVal op2 As Integer)
    Dim SDA As New MySqlDataAdapter
    Dim bSource As New BindingSource

    conectaBanco()

    Dim query As String

    query = "SELECT * FROM vw_tb_clientes"

    objcmd = New MySqlCommand(query, con)
    SDA.SelectCommand = objcmd
    SDA.Fill(dbDataSet)
    bSource.DataSource = dbDataSet

    'Deixa o DataGridView limpo
    x.DataSource = Nothing

    x.DataSource = bSource
    SDA.Update(dbDataSet)

    fechaBanco()
End Sub

From what I understand with mine debug, the error is in the code SDA.Fill(dbDataSet), but I don’t know what’s happening since I have another datagridview with almost the same code and functional, someone could help me?

Answer 1

Failed to specify the table in your DataSet.
See the implementations below to fix the issue:

Public Sub PreencheDataGrid(ByRef x As DataGridView, ByVal op1 As Integer, ByVal op2 As Integer)
    Dim SDA As New MySqlDataAdapter
    Dim bSource As New BindingSource

    conectaBanco()

    Dim query As String

    query = "SELECT * FROM vw_tb_clientes"

    objcmd = New MySqlCommand(query, con)
    SDA.SelectCommand = objcmd

    'Declarei aqui para mostrar o uso do parâmetro
    Dim dbDataSetAs New DataSet("Tab") 'Tab será o nome do nosso dataset e da nossa tabela
    '---
    SDA.Fill(dbDataSet, "Tab") 'Preenche os dados na Tab
    bSource.DataSource = dbDataSet
    bSource.DataMember = "Tab" 'Indica que é para puxar da Tab os dados

    'Deixa o DataGridView limpo
    x.DataSource = Nothing

    x.DataSource = bSource
    SDA.Update(dbDataSet, "Tab")

    fechaBanco()
End Sub