How to Set Default value for datagridview combobox column

Question

How to Set Default value for datagridviewcombobox column when it creates new one.. I have situation user enter the shift basis calculation and it use datagridview when form load and new row creates default value can load .if user need modified value then user change otherwise it remain same... how can code this.. i'm also tried datagridview_cellformatting event().. it changes when user enter and after new row creates changed to default values help me folkz

Madhan Kumar · Answer

I have done with following code.. any way thank u guys for reply Private Sub GridView1_CellFormatting(sender As Object, e As DataGridViewCellFormattingEventArgs) Handles GridView1.CellFormatting If (e.ColumnIndex = 0) Then If (e.Value = Nothing) Then e.Value = "Day" End If End If End Sub

Nilesh Sawardekar · Answer

Very simple way which I use is, Suppose your datagridview(dgvDetails) with calumn as combobox("DType") having values as follow, ABC, PQR, XYZ and you want to set PQR as your default value then, dgvDetails.Rows(intRow).Cells("DType").Value = "PQR"; here, intRow is your row number. to avoid unnecessary errors u have to write in event of datagridview as follow, Private Sub dgvDetails_DataError(sender As Object ,e As DataGridViewDataErrorEventArgs) Handles dgvDetails.DataError On Error Resume Next End Sub above is vb.net code, update it as you needed

Raja T · Answer

Hi, Try like using System; using System.Data; using System.Windows.Forms; using System.Data.SqlClient; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { dataGridView1.ColumnCount = 3; dataGridView1.Columns[0].Name = "Product ID"; dataGridView1.Columns[1].Name = "Product Name"; dataGridView1.Columns[2].Name = "Product Price"; string[] row = new string[] { "1", "Product 1", "1000" }; dataGridView1.Rows.Add(row); row = new string[] { "2", "Product 2", "2000" }; dataGridView1.Rows.Add(row); row = new string[] { "3", "Product 3", "3000" }; dataGridView1.Rows.Add(row); row = new string[] { "4", "Product 4", "4000" }; dataGridView1.Rows.Add(row); DataGridViewComboBoxColumn cmb = new DataGridViewComboBoxColumn(); cmb.HeaderText = "Select Data"; cmb.Name = "cmb"; cmb.MaxDropDownItems = 4; cmb.Items.Add("True"); cmb.Items.Add("False"); dataGridView1.Columns.Add(cmb); } } } =================================================== void dataGridView_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { if (e.ColumnIndex == 0) //Index of your DataGridViewComboBoxColumn { e.Value = "Default Value"; } } ==================================================== private void OnGridDefaultValuesNeeded(object sender, DataGridViewRowEventArgs e) { e.Row.Cells["Position"].Value = PositionEnum.Any; } ================================================= more details check out below links http://stackoverflow.com/questions/12747256/datagridview-set-column-cell-combobox http://stackoverflow.com/questions/1089889/how-do-i-set-up-a-datagridview-comboboxcolumn-with-a-different-datasource-in-eac http://stackoverflow.com/questions/21250336/how-to-change-the-default-value-of-a-data-grid-view-combo-box-column-with-select