How to fill an ASP.NET 4.0 GridView from a Stored Procedure
I have a GridView on a web form with DropDownList in one column. I need to populate the TextBoxes in the next column over with a COUNT query using the value from the DropDownList as a parameter. There are two tables involved in the query, so I can't just bind to a SqlDataSource.
How can I populate a field in the GridView using a multi-table query. I expect I'll have to use a StoredProcedure? Are there any examples of this?