Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Creating a drop list in Sql Express

Author  Topic 

markyjj
Starting Member

8 Posts

Posted - 2008-10-01 : 18:02:10
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....

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-01 : 18:12:33
You can't create a drop down list inside a column. You do that inside your C# application. Drop down lists are a programming concept and not a database concept.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

markyjj
Starting Member

8 Posts

Posted - 2008-10-02 : 06:42:48
Thanks for the advice

So if I do it thorugh C# can I still get the drop down list to actually show in the database column in the datagrid?

cheers
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-02 : 12:46:31
Yes. You should post your C# question on a forum such as www.asp.net, we have one here however we are primarily a SQL Server site.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -