How to filter DataGridView in VB Express?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Big P
    New Member
    • Jan 2011
    • 11

    How to filter DataGridView in VB Express?

    Hello,

    I would like to filter multiple rows in DataGridView ( VB Express)

    My form has 3 Textboxes, 1 Button and 2 DataGridViews. The datagridview1 has 3 columns of data. My datagridview1 looks something like this.
    --------------------------------------…
    Year - Month - Day
    --------------------------------------…
    2010 - April - Monday
    2009 - May - Tuesday
    2008 - June - Wednesday


    Now I want to be able to insert the orders into the textbox1("Year" ), textbox2("Month "), textbox3("Day") and press button1 and the program should filter for that order in the datagridview2. For example, if i type in textbox1(2009), in textbox2(May), in textbox3(Tuesda y), Then the datagridview2 would look like this.

    Datagridview2

    --------------------------------------…
    Year - Month - Day
    --------------------------------------…
    2009 - May - Tuesday


    Pls, any ideas and codes would be very helpful.
    " Notes"
    I am very new to VB Express.
    I am not using SQL.
    If it is possible to do it with one datagridview will be fine too.
Working...