How to Populate Data with DataGridViewComboBoxColumn from database

Question

Hi Experts...Am developing windows application..I want to insert one DataGridViewComboBoxColumn to DataGridView control at design time, and access it and populate data with it at run time..Please Help me out..Thanks in advance..

Amit Choudhary · Answer

Take a sqlDataSource in design time on your .aspx page and bind it to your DataGridViewComboBoxColumn set the properties with following values DataPropertyName = Category DataSource = CategoryBindingSource DisplayName = Name ValueMemeber = (blank) Hope this helps you. Thanks.

Zoran Horvat · Answer

Shivaraj You can read data from the database into DataTable object - just use the DbCommand to populate the DataTable. Then set this DataTable object to DataGridViewComboBoxColumn's DataSource property and that will populate the column. Zoran