Combo box Value and PostgreSQL.Net

[aspirevishal]

Hi ,


I dont know if this clasify as specific VB.net Question or PostgreSQL .Net Question.

Anyways :

When I use to do PHP and if a database had a two colum one with serial no and the other the corresponding value for that sno like

Code: Select all

sno|item
---------
1   | sugar
2   | salt

what i use to do is simple query it

like
select sno,tem from table;

then in PHP for combobox I use to populate the value as and the display would come with


In HTML

Code: Select all

Sugar

Then in insert statement of another table I simply use to insert the value of option tag

How can I accomplish the same with PostGreSQL.net and combobox

[SecureGen]

Here is an example of an .aspx page with data binding set up for a DropDownList:

Code: Select all

    Untitled Page


    
    
        "
            providername=""
            selectcommand='SELECT * FROM "dept"'>
        
        
    
    
    

[aspirevishal]

lots of thanks that gave me a pointer