Urgent: Trigger javascript function after bind control

[Mae Lim]

Hi All,

I've a problem here, I want to trigger a javascript function after binding
the ListBox control. Basically the javascript will remove the duplicates
records after recordset is bind in the ListBox control automatically without
users onclick/onchange the ListBox.

I don't want to distinct the records in the SQL query, because I have other
usage for those duplicates records.

How can this be done? Please help, thanks in advance.

[Ken Cox [Microsoft MVP]]

Hi Mae,

Does it have to be client-side and right after binding the control?

It's hard to get into a server-side event like that to do client-side stuff.

Why not loop through the items collection on the server-side to remove the
duplicates?

Or, what about running the JavaScript immediately after the page is loaded?
That's far safer:

http://msdn2.microsoft.com/en-us/lib...tupscript.aspx

Ken
Microsoft MVP [ASP.NET]

"Mae Lim" <Ma****@discussions.microsoft.com> wrote in message
news:59**********************************@microsof t.com...

Hi All,

I've a problem here, I want to trigger a javascript function after binding
the ListBox control. Basically the javascript will remove the duplicates
records after recordset is bind in the ListBox control automatically
without
users onclick/onchange the ListBox.

I don't want to distinct the records in the SQL query, because I have
other
usage for those duplicates records.

How can this be done? Please help, thanks in advance.

[Richard Brown]

Ken Cox [Microsoft MVP] wrote:

Hi Mae,

Does it have to be client-side and right after binding the control?

It's hard to get into a server-side event like that to do client-side stuff.

Why not loop through the items collection on the server-side to remove the
duplicates?

Or, what about running the JavaScript immediately after the page is loaded?
That's far safer:

http://msdn2.microsoft.com/en-us/lib...tupscript.aspx

Ken
Microsoft MVP [ASP.NET]

"Mae Lim" <Ma****@discussions.microsoft.com> wrote in message
news:59**********************************@microsof t.com...

Hi All,

I've a problem here, I want to trigger a javascript function after binding
the ListBox control. Basically the javascript will remove the duplicates
records after recordset is bind in the ListBox control automatically
without
users onclick/onchange the ListBox.

I don't want to distinct the records in the SQL query, because I have
other
usage for those duplicates records.

How can this be done? Please help, thanks in advance.

Can you not use two SQL queries one that returns distinct rows and one
that doesn't and use them accordingly.

[Bill Gregg]

Rather than maintaining 2 SPs, could you use the create a DataView from
the binded DataSet? In other words apply your DataView (where you
remove the duplicates) to the DataSet and then bind your list box to the
DataView?

Bill Gregg
MCP, MCAD
*** Sent via Developersdex http://www.developersdex.com ***