GridView: Handle multiple fields/columns returned from a Stored Procedure

P

pichula

I recently started with .NET and C#.

I have a stored proc in SQL Server that returns a dynamic/variable set
of columns depending on the parameter I pass. I'd like to display the
information in a gridviewand be able to show the column header names
correctly.


Is it possible to do this with a GridView?


Thanks for any help/suggestions I can get.


Pichula
 
C

chanmm

Do it with a DataSet and bind your DataGridView to the DataSet will be
easier.

chanmm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invalid Column Name Sql-Error :Executing a stored procedure 1
Stored procedure with output parameter 7
Call stored procedure in SSMS from Access 2016 doesn't work. 0
display data in stored procedure from multiple tables in label con 2
Sorting a Gridview Control / Linq Result Set from SPROC 4
T-SQL - How can I name result sets returned by my Stored Procedure?? 2
Intercepting invalid parameters to a stored procedure 10
Entity Framework Return Value from Stored Procedure - Getting Error 1

Top