How to make a search and edit for an Access Database?

[Maxwell175]

Hello all,

I am building a Access database for my bank account. :smash:

I made the database itself, now I need to make the forms. :concern:
Since I know whey more VB.NET then VB for applications. So, can someone give me a code sample or something to start with? :err:

FYI: I have a Access 2007 & Access 2003 database file. :courage:

 

[jmcilhinney]

You might want to follow the Data Walkthroughs link in my signature and check out the relevant topic(s).

 

[Maxwell175]

I found some code on the net:

[XCODE=vb]Dim SearchJob As String = TextBox1.Text

        Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=C:\Users\Maxwell\Documents\BCPA project\BCPA_Accounting.mdb")
        ' Use wildcard'  
        Dim cmd As OleDbCommand = New OleDbCommand("SELECT Person.Last_Name, Person.First_Name, Person.Addr_ln1, Person.Addr_ln2, Person.City, Person.Zip, Person.State, Person.Email, Person.Membship_status, Person.Member_Key FROM (Person) WHERE UCase([Person].[Last_Name] LIKE (" & Chr(34) & UCase(TextBox1.Text) & Chr(34) & ");")
        ' or Where JobNo='" & SearchJob & "'  


        con.Open()
        Dim myDA As OleDbDataAdapter = New OleDbDataAdapter(cmd)
        Dim myDataSet As DataSet = New DataSet()
        myDA.Fill(myDataSet, "Person")
        DataGridView1.DataSource = myDataSet.Tables("Person").DefaultView
        con.Close()
        con.Dispose()
        myDA.Dispose()
        cmd.Dispose()[/XCODE]

On the line:

myDA.Fill(myDataSet, "Person")

:kaioken: :heart-borken:
I get error: InvalidOperationException was unhandled

Fill: SelectCommand.Connection property has not been initialized.

What is the problem and how do I solve it?

 

[Maxwell175]

You might want to follow the Data Walkthroughs link in my signature and check out the relevant topic(s).

Here is the topic I found:Walkthrough: Connecting to Data in an Access Database (Windows Forms)The problem is that I created the data connection but I have absolutely no idea how to use it. Please see the code in my previous post. That may be some help .

 

[Maxwell175]

Here is the topic I found:Walkthrough: Connecting to Data in an Access Database (Windows Forms)The problem is that I created the data connection but I have absolutely no idea how to use it. Please see the code in my previous post. That may be some help .

Ok, now I put the data connection into a DataGridView. Now I need to know how to filter the DataGridView so it would show only the records where the amount is the same as the amount typed into a textbox.

 

[jmcilhinney]

The steps are:

1. Execute a query to populate a DataTable.
2. Bind the DataTable to a BindingSource.
3. Bind the BindingSource to your control(s).
4. Use the Filter and Sort properties of the BindingSource to filter and sort the data.

 

[Maxwell175]

The steps are:

1. Execute a query to populate a DataTable.
2. Bind the DataTable to a BindingSource.
3. Bind the BindingSource to your control(s).
4. Use the Filter and Sort properties of the BindingSource to filter and sort the data.

I am sorry if I am being annoying but I don't know how to do any of that. :redface:

 

[nK0de]

Google for tutorials on ADO.NET
This one I came across in a quick search. (A Basic ADO.NET Tutorial in Visual Basic.NET - CodeGuru)