Columns Order In Datagridview

mahesh waghela

What is the correct way of datagridviewcomboboxcolumn bind with sql database and re- arrange with other column. Suppose if I have columns like below.

Srno
Particulars // this columns is for datagridviewcomboBoxColumn
Amount.

I wants the datagridview's columns correct order as above and the same is for the purpose

of data entry.

Suppose if I have Following Dummy Table like

dummy

Srno
Particulars
Amount.

MySqlConnection Code is as below.

 string cons = "server=.;initial catalog=maa;uid=mah;pwd=mah";

SqlConnection con = new SqlConnection(cons);
con.Open();
string sql = "select particulars from dummy";
SqlDataAdapter dap = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
dap.Fill(ds);
DataGridViewComboBoxColumn cmb = new DataGridViewComboBoxColumn();
cmb.DataSource = ds.Tables[0];
cmb.DisplayMember = "name";
cmb.ValueMember = "name";
dataGridView1.Columns.Add(cmb);

The above datagridviewcomboboxcolumn is set to dgv.columns[0] where as I wants the dgv

columns orders as below.

Datagridview.columns[0] is for srno
Datagridview.columns[1] is for Particulars //For datagridviewcomboBoxColumn.
Datagridview.columns[2] is for Amount

Note:- "I need the correct way to add all three columns in datagridview as above order"

3 Replies

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

mahesh waghela16y ago

The Correct way to design Datagridview for Data Entry Mode as per my question is as below.

//databound DGV
string cons = "server=.;initial catalog=maa;uid=mah;pwd=mah";
SqlConnection con = new SqlConnection(cons);
con.Open();
string sql = "select particulars from dummy";
SqlDataAdapter dap = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
dap.Fill(ds);
DataGridViewComboBoxColumn cmb = new DataGridViewComboBoxColumn();
cmb.DataSource = ds.Tables[0];
cmb.DisplayMember = "name";
cmb.ValueMember = "name";
dataGridView1.Columns.Add(cmb);
//Unbound DGV
DataGridViewTextBoxColumn srno = new DataGridViewTextBoxColumn();
dataGridView1.Columns.Insert(0, srno);
DataGridViewTextBoxColumn amt = new DataGridViewTextBoxColumn();
dataGridView1.Columns.Insert(2, amt);
0

MWmahesh waghela16y agoPosted Nov 4, 2010, 2:00 AM Hi Suthish Read Carefully my question the sql string query is only for datagridviewcomboBoxColumn. If I change the query as per your suggestion than How can I add dgvcomboBoxColumns in DGV. I wants to add all three columns as per suggested above and the same is prepare for data entry mode. 0
Suthish Nair16y agoPosted Nov 3, 2010, 12:02 PM change your query to.. select srno, particulars, Amount from dummy 0