The gridview and the sql command are not meant to work together. Sqlcommand is meant to maintain a database, not to load an application with it.
The best you could hope for is to convert the database to an xml file. Then you could load the xml file with an xml data source.
You will find many angry responses because the ado.net is meant to load things for this. Ado.Net is made to run directly with gridview. Who ever is requiring this is not good and is requiring you to use a bicycle when you have a car. Again, Sql command is an old tool for database work, not for loading Asp.Net.
Introduction to ASP.NET Web Forms: Grid View Control & Data Binding - YouTube[
^]