Breaking News: Grepper is joining You.com. Read the official announcement!

call/execute a Query stored in Access database file in VB.NET

Braxton Bell answered on June 27, 2022 Popularity 1/10 Helpfulness 1/10

answer call/execute a Query stored in Access database file in VB.NET

call/execute a Query stored in Access database file in VB.NET

Comment

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

Popularity 1/10 Helpfulness 1/10 Language vb

Source: social.msdn.microsoft.com

Tags: database file vb.net vba

Link to this answer
Share Copy Link

Contributed on Jun 27 2022

Braxton Bell

0 Answers Avg Quality 2/10

call/execute a Query stored in Access database file in VB.NET

Contents

More Related Answers

call/execute a Query stored in Access database file in VB.NET

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.