Call Execute A Query Stored In Access Database File In

[Solved] Call Execute A Query Stored In Access Database File In | Vb - Code Explorer | yomemimo.com
Question : call/execute a Query stored in Access database file in VB.NET

Answered by : braxton-bell

Imports System.Data.OleDb     
    
Public Class Form1     
   
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click     
        Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=D:\myDB.mdb")     
        Dim cmd As New OleDbCommand     
        cmd.CommandType = CommandType.StoredProcedure     
        cmd.CommandText = "MyQueryName"   
        cmd.Parameters.Add("@Parameter1", OleDbType.VarChar).Value = "value1"  ' Add Parameter
        cmd.Connection = con     
        con.Open()     
        Dim da As OleDbDataAdapter = New OleDbDataAdapter(cmd)     
        Dim ds As DataSet = New DataSet()     
        da.Fill(ds, "Table1")     
        DataGridView1.DataSource = ds.Tables("Table1")  ' Binding to DataGridView   
        con.Close()     
    End Sub   
   
 End Class

Source : https://social.msdn.microsoft.com/Forums/en-US/e4344a25-93e5-40d4-a97d-c5ee0b573577/running-access-query-in-vbnet?forum=vbide | Last Update : Mon, 04 Jul 22

Answers related to call execute a query stored in access database file in vb net

Code Explorer Popular Question For Vb