Hi currently I have a DataGridView table read from a Oracle database,One of the column is meant to take in only "1" or "0" as a value, so I was wondering if I can make the whole column into a combobox and read the current value as well as letting th user to change using the combobox.
Thanks in advance for any help offered.
localSQL = "SELECT KEYID,TAG,DESC,STATE,FROM PRODUCT1";
OracleCommand cmdOracle = new OracleCommand(localSQL, localConnection);
cmdOracle.CommandType = CommandType.Text;
OracleDataReader drOracle = cmdOracle.ExecuteReader();
DataTable ordt = new DataTable();
OracleDataAdapter orda = new OracleDataAdapter();
orda.SelectCommand = cmdOracle;
dataView1.DataSource = ordt.DefaultView;
dataView1.RowsDefaultCellStyle.BackColor = Color.White;
dataView1.Columns.Width = 150;
dataView1.AlternatingRowsDefaultCellStyle.BackColor = Color.LightBlue;