populate dropdown items via stored procedure

[ellen89]

Hi All,

I am new to this field, and is using VS.2005, language is C#.

1) created a database "Test" in sql 2005, had a table "NameList", a stored proc "GetAllName "
2) created a new website, on .aspx page has a dropdown control "ddlName"

Wish could have help at following:

Now I want to all the names from NameList will be populated at 'ddlName" when page loaded.

There is no problem for me to complete this task using data adapter, but I want to use stored procedure.

Thank you in advance. Your time is great appreciated.

ellen89

[kunal pawar]

then at time of define dataadatper u can used store procedure

like
oSqlDa = new SqlDataAdapter( "Store Procedure", connection object)
oSqlDa.fill(oDs ,"Namelist")

ddl.datasource = oDs.Table(0)
ddl.datameber = oDs.Table(0)
ddl.dataValuefi eld = "field name"
ddl.dataTextfie ld = "field name"
ddl.databind()