While using DataAdapter following steps are followed:
1) Open a connection
2) Create a DataAdapter
3) Fill a table using DataAdapter
4) Bind table to GridView
Reference from below link:
http://www.dotnetperls.com/sqldataadapter[
^]
If above steps are followed, ensure the
"AutoGenerateColumns"
property of GridView is set to
TRUE
or you will need to define each column of the gridview. I think GridView should be visible using these steps. Please reply back if otherwise.