use stored procedure that select from dynamic table with different number of fields in c#

Hi,

I am not able to understand what you want to do if you can then explain your problem with a example and still as your question in am giving answer,

You can pass the name of fields using comma separation and in stored procedure you can directly use.

you can use like below example.

Create procedure proc_DynamicFields(@items varchar(max))
as
Begin
declare @sql varchar(max)

set @sql = 'select ' + @items + ' from tbl_TableName'

Exec(@sql)
End

You can call above Procedure in c# add fill Data Adapter after that you can get the dynamic fields of particular table in Data Adapter.

Hope, it will Work
Thanks