dynamically adding rows to mshflexgrid

Hi!. I have a mshflexgrid which has 2 rows. How will I add rows to it during run time? My user will have to type something in the text box. if the value in the textobx matches the one of the records
in my DB then the resulting match will be displayed in the mshflexgrid's first row.

My DB contains more than 10,000 records, so if the user will type 20 times in the textbox, i should have 20 rows displayed with records in it.

BTW. i want the mshflexgrid to reset to 2 rows everyday. So if it has 20 rows today, the following morning it should have 2 rows again and cycle continues....

Any help will be appreciated. Thank you.

MSFlexGrid1.Rows = 99

- or -


MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1

Martin, could you be a little bit more specific? an example would be appreciated much. Thank you

That is pretty specific. If you want the flexgrid to have a certain number of rows (like 99) you do

MSFlexGrid1.Rows = 99

or if you are reading records in a loop and you want to add rows one at a time you do

MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1

my... im so sorry... thanks anyway