filtering a datagrid

[V0lcan1c_A5h]

hi i have a datgrid bound using a dataenvironment and i need to filter it using specific fields

[AndreRet]

What code do you have so far? If any code, where do you get errors?

[V0lcan1c_A5h]

None so far the grid works but i need to filter it. I've also tried binding it with adodc but when i run it it tells me syntax error with FROM clause.

[AndreRet]

What is your field names, which fields needs to be filtered, what do you want to achieve with filtered data? Which database are you using, access, mysql?

Basically you need to show data once you returned a record from an Sql statement and then bind the grid to the recordset.

We will need some more info before we can show you in the right direction.

[V0lcan1c_A5h]

i have the following fields ID, membership ID , name,video,video code and dateborrowed.
i am developing a system for a video lending club so i need to filter the table using th ID field to display only records borrowed by a specific member. Or instead of the datagrid i could use a code that counts the records with similar IDs.

[V0lcan1c_A5h]

this is an example of what i hav so far in the fieldsID: A100,A103,A102,A101,A104,A100 each code refers to specific person in the database. The repeated codes means that the person has more than one video or atleast it shows the number of videos one has but i still need it in actual numeric figures.

[V0lcan1c_A5h]

and i.m using access .mdb

[AndreRet]

Ok, I'm gonna "push" you in the right direction which will help you tremendously in the future. We are going to drop data controls, they are to say the least stupid and useless for proper data manipulation.

First, in your app, click on Project -->> References in your menu bar. Select Microsoft Active x Data Objects .... whichever newest version you have. select the 6.0 backcompat library if you have it, will ensure your app runs in all windows versions.

At the top of your code page, add ...

Option Explicit

In your Form Load event, add the following...

Dim sConn As String
Dim oConn As New ADODB.Connection
Dim oRs As New ADODB.Recordset

    On Error GoTo ErrFailed

    sConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\MyDatabaseNameHere.mdb"

    oConn.Open sConn
    oRs.Open "SELECT * FROM MyTableNameHere WHERE ID ='A100' ORDER BY [Membership ID] DESC", oConn, adOpenKeyset, adLockOptimistic

    ''Try to move away from split naming conventions - Membership ID to membershipid will save you tons of headaches...

    If oRs.EOF = False Then
        ''There are records available to show...
        ''Add code here to manipulate your data.

        datagrid.Datasource = oRs
    End If

    oRs.Close
    oConn.Close

    Exit Sub

ErrFailed:
    MsgBox "Error " & Err.Description

[V0lcan1c_A5h]

thanx

[AndreRet]

Only a pleasure. :)

Did this solve your problem?

[V0lcan1c_A5h]

thanx u were a real help.

[AndreRet]

Only a pleasure. Please mark this as solved, thanx. :)