How do we extract the data in the selected rows in a data grid? User selects multiple rows, and we need to extract the data in the selected rows. How to do this.
Printable View
How do we extract the data in the selected rows in a data grid? User selects multiple rows, and we need to extract the data in the selected rows. How to do this.
you might have to loop through each record and see if it's selected. The grid might have a selected items collection. i don't use it very often so i'm not sure about either of these methods. but they seem to work for other controls.
hope this helps,
John
John Pirkey
MCSD
http://www.ShallowWaterSystems.com
http://www.stlvbug.org
But Mr.John Pirkey, I've tried this method using the Bookmarks and SelBookMarks methods. What is happening here is the data grid returning the selected records out of the visible records with in the scroll bar range and it is throwing error for those selected rows which are out side the scroll bar range(please catch my point). What to do?. Could you please suggest, if possible code also.
Regards
Rajendra
In general (i have only used msflexgrid) you can use as below:
dim seldata as string
seldata = msflexgrid1.clip
'the variable seldata now holds all data in the selected area.
good luck
bob
Thank you mr. Bob. I'll try this.
Regards,
Rajendra