Hi

I have just started to learn VB.Net, I would like to create a recoredset where I pass different varaibles into the where clause, I do have an example, but it is for SQL, where as I am using a Access back end.

for example:-
select *
from Table
Where ?
entered into the dataadapter and

sqldataadapter1.selectcommand.parameters("@Param1" ).value = "Clause"

in the code

I have tried replacing the SQL dataaapter with a OLE one, but it didn't work.

Very stuck

Thanks

Louisa

Try this:

Make sure you import your namespaces at the top of the page:

Imports System.Data
Imports System.Data.OLEDB

---------------------------

For this example, this could go in a button's click event:

---------------------------

Dim conn as OleDbConnection
Dim da as OleDBAdapter
Dim ds as New DataSet

conn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=drivename:\Path\DBName.mdb")

da = New OleDBDataAdapter("SELECT * FROM Table WHERE pri_key = " & txtInput.Text, conn)

da.Fill(ds, "NameYourDSTable")

---------------------------

You can then fill a datagrid (or something else) by:

dgName.DataSource = ds.Tables("NameYourDSTable").DefaultView

dgName.DataBind()

---------------------------

Note that for this example, you will have to have a datagrid on your form named "dgName". You will also have to have a text box named "txtInput" and a button or something to respond to the change in the text box.

I think I got everything. Hope this helps.

J

Very helpful

Thank you very much

Louisa