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

There are some changes to the way the BBS works that haven't been published, yet, so if anything doesn't work the way you want it to, be patient, the next release will most likely fix it.

Oh, and if you want to just set the DataSource of the grid to just a plain data table, you can do that as well.  You can create a method on a business object that will call GetDataTable instead of FillDataTable, and return the retrieved table which you can then set as the DataSource of the grid.  Works the same way as using the BBS to bind the business object to the grid.  You can still configure your columns at design-time.