Skip to main content

Disable DataGridView control automatically generate columns

In WinForm programming, when you use a DataGridView to display your data from a data source, you might see a problem: You've only specified the columns which should be display. But the gridview isn't only display that columns but also display others.

The reason: Your data source contains many data fields. Although you've created for it some need columns, the gridview will display all of them for users through a funtions called AutoGenerateColumn.

How to resolve this: It's easily. You just need disabling AutoGenerateColumn function:


  • Specify the columns which you want to display it for users. Of course, you must set Header text and DataPropertyName for them.




  • Browse your form code, go to where you set data source for the grid view. Put below code before that set data source code line (like: YOUR_GRIDVIEW_NAME.DataSource = YOUR_DATA_TABLE;):


[csharp]YOUR_GRIDVIEW_NAME.AutoGenerateColumns = false;[/csharp]
That's all.
Wish succeed!

Comments

Popular posts from this blog

Turn off AutoPlay on Windows

On Windows, when you insert an USB or a CD/DVD into your computer, they are usually opened automatically. So the computer maybe infected autorun virus. To avoid that, you should turn off AutoPlay function.

Install and play Pokemon Go on unsupported device

Pokemon Go is great mobile game for smart devices (Android, iOS...). Many people can install and play it normally. However, some device has not been supported yet (Intel inside smartphone: Asus Zenfone, Dell Veune, ...; Windows Phone devices...). Here we show you how to play it in all your devices. For Android devices: Enable “Unknown sources” in the settings. Download Pokemon Go app setup:  Link 1  / Link 2   Open the downloaded file to install app. Enable all the settings when promted. Now you can open and run Pokemon Go to catch 'em. ... That's all. Wish succeed!