Avatar of Basicfarmer
Basicfarmer
Flag for United States of America asked on

Help with Datagrid and Access Database

Experts would someone please show me an example of how to use my datagrid with my access database so that when I make changes to the data grid those changes are reflected in the database?

Below is how i am filling the datagrid.
The SQL query is passed as an argument to my procedure because I have a search function so the user can search the records. When the user presses the search button the query is built and passed to the fillEquipment procedure which displays the records in the datagrid. When the form loads the the procedure is called like fillEquipment("SELECT * FROM Equipment").

    Public Sub fillEquipment(strSql As String)

        Dim da As New OleDbDataAdapter(strSql, con)
        Dim dt As New DataTable
        da = New OleDbDataAdapter(strSql, con)
        da.Fill(dt)
        DataGridView1.DataSource = dt
        
    End Sub

Open in new window

Visual Basic.NETProgramming Languages-Other.NET Programming

Avatar of undefined
Last Comment
Basicfarmer

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Tom

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
ElrondCT

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Basicfarmer

ASKER
Thanks for the great tips guys...
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes