How to Set Default value for datagridview combobox column

Madhan Kumar

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Madhan Kumar10y ago
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
0
Nilesh Sawardekar10y ago
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,
PrivateSubdgvDetails_DataError(senderAsObject,eAsDataGridViewDataErrorEventArgs)HandlesdgvDetails.DataError
OnErrorResumeNext
EndSub
above is vb.net code, update it as you needed
0
Raja T10y ago
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
0