hi,

I have a datagrid, the columns of which i have to populate from values returning from a stored procedure.
Say there are 10 columns in the datagrid.
My 9 columns have to be populated from the output of a stored Procedure. The input of the stored proc is going to be the value of column 1.

My doubt is how will i bind the data returned by the stored proc to the datagrid??

Thanks in advance,

Jaya

So you aren't really populating a datagrid from a stored procedure. You are using the sproc to retrieve a single row dataset for a given value. It sounds like you are calling this sproc once for every row in the datagrid.

Where are the initial values coming from for that first column?

Peter
----------------------------------------
Work smarter, not harder.

hi Peter,

Yes u r right. I m using the sproc to populate every row.

The values for the first column are populated by firing a query.
So using a loop.
That is the main query which returns the first column and for every value returned by tht query, I m calling the sproc.

Thanks
Jaya

Is there is a reason that you can't get all your data with a single query? This would be much more efficient if you have the database do all the work to assemble the data, then you can just bind the grid to a single result.

If there isn't a way do optimize it at the database, then I'll see if I can suggest something you can do at the datagrid.

Peter
------------------------------------------------------
Work smarter, not harder.