Hi, my btn for my app isn't working and I can't figure out why, I need to show all my access data in the datagridview without sql. any help?

See more:

VB

MS-Access

Imports System.Data.OleDb
Public Class Form1
Dim dtHospitalBilling As DataTable()
Dim dbConnection As OleDbConnection
Dim dbCommand As OleDbCommand
Dim dbDataAdapter As OleDbDataAdapter
Dim ConnectString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Nuri\Documents\Visual Studio 2010\Projects\HospitalBilling\HospitalBilling\Hospital.accdb"
Dim dtHospital As DataTable
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'HospitalDataSet1.Hospital' table. You can move, or remove it, as needed.
dbConnection.Open()
Me.HospitalTableAdapter.Fill(Me.HospitalDataSet1.Hospital)

End Sub

Private Sub btnAll_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAll.Click
Dim DbConnection As OleDbConnection
Dim dsFirstName As New DataSet()

DbConnection = New OleDbConnection(ConnectString)
dbDataAdapter = New OleDbDataAdapter()
dbCommand = New OleDbCommand()
dbCommand.CommandText = ""
dbCommand.CommandType = CommandType.StoredProcedure
dbDataAdapter.SelectCommand = dbCommand
dbDataAdapter.SelectCommand.Connection = dbConnection
DbConnection.Open()
dbCommand.ExecuteNonQuery()
dbDataAdapter.Fill(dsFirstName, "Hospital")
DataGridView1.DataSource = dsFirstName
DataGridView1.DataMember = "Hospital"
DbConnection.Close()



End Sub