[RESOLVED] [02/03] Datagrid problem of my row index was out of range....

need help you guys out there how do i solve this problem.. I have screenshot here..

http://www.vbforums.com/images/ieimages/2007/07/1.jpg



I also need to know guy hows to group in my datagrid like for example I have the same Description and I want it to group in my query...How can I do it? i need it badly...

Firstly, without seeing the code we can't possibly know why that exception was thrown other than to say that you used an invalid row index. If there are N rows then the row index must be in the range 0 to (N-1). Anything else is invalid. Simple.

As for grouping data, there's no way to group multiple rows in a DataGrid. You can combine multiple records in one row using aggregate functions in your SQL code. Each of those rows is then displayed by the DataGrid as always. Is that what you want?

thanks jm i already got it...How about the query on how to group the data?

How about it? I already addressed that.

ahhh...ok...sorry jm i forgot...a million thanks to you jm...Have a nice day and God Bless..You're really a great wizard!