how to bind dynamic gridview i.e AutoGenerateColumns=true

until you specify the column names in GridView explicitly, the GridView is dynamic anyway. So, just call your SP and bind the result to GridView.

 

Note:- As a best practise, Always stored connection string in config file and retrieve from there

 

Hi, If you have the datatable, simply bind it with gridview.