Datasources in asp.net

Question

My colleague wants to connect a Gridview's datasource to a dynamic Stored procedures. The Stored procedure is not showing up in the list so I put the stored procedure in the select command. I need to pass it parts of sql statements and not just regular string parameters. How can i accomplish this?

Answer 1

You can code it like this article.

http://www.aspnettutorials.com/tutorials/database/db-storedprocs-aspnet2-csharp.aspx