Grid Problem

[MY3MCS]

Can anybody help me with this please?

I have a grid and a button named loadbtn. When I click this button, I want to see only those records from my database whose transaction date (field name is TRANDATE) is 05/15/2003. Can you tell the step by step procedure please? To tell you honestly I'm not that good in Visual Basic programming.


Thanks.

 

[aco2x]

You might start with something like this in your command button click procedure:

    Dim MyRS As ADODB.Recordset
    Dim MySQLString As String
    
    Set MyRS = New ADODB.Recordset
    MyRS.CursorLocation = adUseClient
    MySQLString = "SELECT * FROM myTable WHERE Trandate = '05/15/2003'"
    MyRS.Open MySQLString, MyConnection, adOpenDynamic, adLockOptimistic
    
    Set MyGridControl.DataSource = MyRS

 

[zemp]

A simple method would be to use an ADO data control and bind it to the grid. There is good information in the help files, this forum, forum709 and msdn. Take a look and get back to us when you are stuck.

Thanks and Good Luck!

zemp

 

[MY3MCS]

Thanks but how can i get in to forum709? Is it in FAQs? Under what title? Thanks again.

 

[zemp]

To get into the forum just click on the link I and you provided. Then use the keyword search for 'ADO data control' or 'ADODC' or 'ADODC1'.

Thanks and Good Luck!

zemp

 

[zemp]

Don't forget to search this forum as well.

Thanks and Good Luck!

zemp