leegold2
Technical User
- Oct 10, 2004
- 116
Hi,
I have a mysql database with an enumerated type/column, the column is a varchar type and is limited to coupe, sedan, station_wagon. So when I edit a table cell in phpmyadmin for example it drops down and I have only those choices for the cell value.
In VS 2010 C# I have a datagridview of another table without the enumerated column just to initially test things out. With "select *" show the table in a form/datagrid. I also have it set up where I can edit this datagridview's cells and it will update the values in the mysql table.
What I want to do is show the user the mysql table with enumerated cols (and it also has some cols which are not enumerated too) in a datagridview and have a drop-down for the enum table cols in the datagrid where the user can select and also have the action of updating the actual mysql table.
How is this done? I can provide existing code if needed. Thanks.
I have a mysql database with an enumerated type/column, the column is a varchar type and is limited to coupe, sedan, station_wagon. So when I edit a table cell in phpmyadmin for example it drops down and I have only those choices for the cell value.
In VS 2010 C# I have a datagridview of another table without the enumerated column just to initially test things out. With "select *" show the table in a form/datagrid. I also have it set up where I can edit this datagridview's cells and it will update the values in the mysql table.
What I want to do is show the user the mysql table with enumerated cols (and it also has some cols which are not enumerated too) in a datagridview and have a drop-down for the enum table cols in the datagrid where the user can select and also have the action of updating the actual mysql table.
How is this done? I can provide existing code if needed. Thanks.