Creating a Drop down list in SQL Express

Question

Can someone please help me with following problem.

I have created a Sql table in SQl express but I want to create a drop down list directly in one of the columns in the sql database so that I can see the drop down list when I load my c# datagrid. Whats the best way of going about this.

Thanks for any help....

Ryan Alford · Answer

you could probably do this with a DataGridDropDown column. http://www.dnzone.com/ShowDetail.asp?NewsId=914

Vijaya Kadiyala · Answer

Hi Just to understand a bit more Right now you have one grid which gets the data from database. I guess this is displaying in Cell. when you want to edit you ar ehaving textboxes to do this. Now instead of this you want to have dropdown lists to select values appropriate to that column. this is something similar to Sates in US. Is this what your requirment is? Thanks -- Vj http :// dotnetvj . blogspot . com http :// oravj . blogspot . com

mark jones · Answer

I currently have a datgrid bound to the sql database that I am using. Once the program is running the table appears in a datagrid and I am able to edit data in the SQL database direct through the datagrid. What I want is a drop down menu to appear in one of the columns so that I can pick one of several catgories but am not sure hot to go about this. Thanks for any help.

Vijaya Kadiyala · Answer

Hi Where is this Dropdown list? is it in any Front-end application?? Can you be more clear on what you are looking for. Thanks -- Vj http://dotnetvj.blogspot.com http://oravj.blogspot.com