HOW TO Refresh a Drop Down List Box ???

[Brad Isaacs]

ASP.NET 2.0 / SQL Server 2000 db / Visual Basic Code behind

On my .aspx page I have added an SQL Datasource that contains the SQL query
to retrieve the list for my Drop Down List Box.

Using this SQLDataSource I can retrieve my drop down list data.

SELECT DISTINCT responsibleMini ster
FROM responsibleMini ster
WHERE languageID = @languageID
ORDER BY responsibleMini ster ASC
I have a button that I have added that calls a stored Proc to INSERT DATA
into that same table

BEGIN
-- Find the next PK value for responsibleMini sterID
DECLARE @responsibleMin isterID smallint
SELECT @responsibleMin isterID=MAX(res ponsibleMiniste rID)+1
FROM dbo.[responsibleMini ster]
WHERE languageID=@lan guageID

INSERT INTO dbo.[responsibleMini ster](
[responsibleMini sterID],
[languageID],
[responsibleMini ster])
VALUES (
@responsibleMin isterID,
@languageID,
@responsibleMin ister)
END

The Insert Stored Procedure works well, however, I now need to UPDATE my
Drop Down List box with the data that lies within the responsible Minister
table.

I tried to enable Post Back but that did not refresh the drop down list.

Can someone please help me resolve this issue of "How I may REFRESH the list
found within the drop down list box with the new values found within the
database table"???

Any ideas would be greatly appreciated,

Thanks,

~Brad
------------------------------
Brad Isaacs

[bpd]

On Mar 28, 12:44 pm, "Brad Isaacs" <bisa...@rogers .comwrote:

ASP.NET 2.0 / SQL Server 2000 db / Visual Basic Code behind

On my .aspx page I have added an SQL Datasource that contains the SQL query
to retrieve the list for my Drop Down List Box.

Using this SQLDataSource I can retrieve my drop down list data.

SELECT DISTINCT responsibleMini ster
FROM responsibleMini ster
WHERE languageID = @languageID
ORDER BY responsibleMini ster ASC

I have a button that I have added that calls a stored Proc to INSERT DATA
into that same table

BEGIN
-- Find the next PK value for responsibleMini sterID
DECLARE @responsibleMin isterID smallint
SELECT @responsibleMin isterID=MAX(res ponsibleMiniste rID)+1
FROM dbo.[responsibleMini ster]
WHERE languageID=@lan guageID

INSERT INTO dbo.[responsibleMini ster](
[responsibleMini sterID],
[languageID],
[responsibleMini ster])
VALUES (
@responsibleMin isterID,
@languageID,
@responsibleMin ister)
END

The Insert Stored Procedure works well, however, I now need to UPDATE my
Drop Down List box with the data that lies within the responsible Minister
table.

I tried to enable Post Back but that did not refresh the drop down list.

Can someone please help me resolve this issue of "How I may REFRESH the list
found within the drop down list box with the new values found within the
database table"???

Any ideas would be greatly appreciated,

Thanks,

~Brad
------------------------------
Brad Isaacs

I'm assuming you're binding the datasource to the dropdownlist control
somehow.
After the insert/update, you'll need to re-bind.

[Latish Sehgal]

Call the DataBind() function of the drop down list.

[Brad Isaacs]

bpd & Latish,

Thank you very much for your input

~Brad
:)))
"Latish Sehgal" <la***********@ gmail.comwrote in message
news:11******** *************@n 76g2000hsh.goog legroups.com...

Call the DataBind() function of the drop down list.