Creating a Drop down list in SQL Express

mark jones

18y7.8k

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....

4 Replies

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

Ryan Alford18y ago
you could probably do this with a DataGridDropDown column. http://www.dnzone.com/ShowDetail.asp?NewsId=914
Vijaya Kadiyala18y ago
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 jones18y ago
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 Kadiyala18y ago
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