How to Show Selected Column from sql in Gridview asp.net

For BouldField columns, setting the DataField as suggested should work. In fact GridView will automatically display all the columns based on your SELECT query if AutoGenerateColumns is set to true, which is the default. If you are using TemplateField columns and wanted to define your own columns, then you have to set AutoGenerateColumns to false and then add ItemTemplate columns for you to add whatever controls you need within the GridView. 

 

You want to download a copy of my ebook here for some tips and tricks: https://www.c-sharpcorner.com/ebooks/asp-dot-net-gridview-control-pocket-guide