How do I bind a grid to a stored procedure in Visual Studio 2005? The twist is that I would like to setup the grid at design time. Column headings, sizes, any additional formatting that I would otherwise have to do in code. Do I somehow create a dataset to bind the grid to initially?



P.S. I really appreciate the general .NET forum... its nice to be able to pull on your knowledge of .NET also.



Thanks

The BOMapper does not currently support mapping a business object to a stored procedure.  So, to create a strong-typed business object that maps to a stored procedure, you'll need to create a view that has the same structure as the stored procedure (it doesn't have to be deployed with the database, just created for temp purposes) or create a temp DDT profile and create a table in there with the same structure as the stored procedure.  Either of those will give you a source for the mapping information within the BOMapper.  Once the BO is mapped, it doesn't care where the data comes from, so you can create the structure from a separate object.