Find a record in ADO .NET

[vsusi]

Might be very simple to everyone. But I need it soon. No time to research.

Dim ADOConOle As OleDb.OleDbConnection
    ADOConOle = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Application.StartupPath & "\Accounts.mdb")
    Dim rsLocal As New OleDb.OleDbDataAdapter
    Dim rsCurrent As New DataSet
    rsLocal.SelectCommand = New OleDb.OleDbCommand("SELECT * FROM CUSTOMER", ADOConOle)
 
    txtCustID.DataBindings.Add("text", rsCurrent.Tables(0), "Cust_Id")
    txtName.DataBindings.Add("text", rsCurrent.Tables(0), "Name")
    txtAddress1.DataBindings.Add("text", rsCurrent.Tables(0), "Address1")
    txtAddress2.DataBindings.Add("text", rsCurrent.Tables(0), "Address2")
    txtAddress3.DataBindings.Add("text", rsCurrent.Tables(0), "Address3")

I just want to do display a record (like Find method in ADO) for the entered ID in txtCustID field.

Thanks

Susindran

[Borry]

Hello,

you need to use a dataview so you can sort/filter a dataset.

Look :

Dim dv as dataview = ds.tables(0).defaultview
 
dv.RowFilter = "City = 'Berlin'"

HTH !

[vsusi]

Does it Filter (like in ADO) or Find?

Thanks

Susindran

[Borry]

It filters. But I don't see the difference between 'find' and 'filter'.

[vsusi]

How do I bind to the text fields again with the found record?

Thanks

[vsusi]

Any help on this?

[Hole-In-One]

Are you trying to search you dataset for a row say with the ID "10" then return the column values for that row?

Is the column ID your primary key in your database?

[vsusi]

You are exactly correct.

Cust_Id is the Primary Key in table CUSTOMER.

I am able to bind and navigate it. But unable to find a record (also not able to save it).

I couldn't find any help in any site or book regarding finding a record and binding it back to controls.

Thanks

[unisse]

It has to be possible as the typed Datasets has a built in function for each table where you can find a row by using the primary key. So for example if a table has a primary key named CustomerID a typed dataset will have a function for that table named FindByCustomerID.

Create a typed dataset using the drag and drop in a project and search for that function to see how its done if you don't want to go with a typed dataset yourself.

/Nisse

[vsusi]

I am new to .Net. Can you post with sample code?

Thanks

[unisse]

Create a typed dataset using the drag and drop in a project and search for that function to see how its done if you don't want to go with a typed dataset yourself.

Create a table in for example SQL and give it a primary key. Drag the table from the server explorer (next to the toolbox) in VS and drop it on a form. A connection to the database and a dataadapter will be created. Rightclick the dataadapter and choose "generate dataset". You know have yourself a typed dataset. Enter the code and look for the FindByXXXX function where XXXX is the name of your primary key column.

/Nisse

[taxes]

Hi unisse,

"Create a table in for example SQL and give it a primary key. Drag the table from the server explorer (next to the toolbox) in VS and drop it on a form."


I'm completely lost on this. Where exactly is the "Server Explorer"? I have nothing next to the toolbox.

[unisse]

If its not visible next to the toolbox, it can be found here:

View -> Server Explorer.

[taxes]

Hi unisse,

Many thanks. I shall enjoy looking at that!!

[taxes]

"Create a table in for example SQL and give it a primary key. Drag the table from the server explorer (next to the toolbox) in VS and drop it on a form."

Don't forget to rightclick on the DataConnection node in the Server Explorer to create a reference to your database.