sending webform listbox values to stored procedure in asp.net

[Guest]

Hi,

I have an application written in ASP and I am converting to ASP.NET

in the old ASP page users can add items to a listbox control.
When the user hits the "submit" command button on the form.
It fires a stored procedure in the SQL Server Database.

The listbox items are converted into a comma delimited string and sent to
stored procedure. This SP constructs a temp table variable out of the
delimited string and then is joined to other physical tables in the database
to complete the query.

question:
is there neat new way to do this using ASP.NET in VB?
I'd like to be able to

leverage the power of the resources available to me over vbscript if possible.

Also it would solve the maximum character length of 8000 for the delimited
string,
thanks

Chris

 

[Cor Ligthert]

Chris,

Probably yes however it is a hard way to tell.

You can use in ASPX.
Classic ASP style of coding using ASPX controls and syntax
Newer ASPX scripting style
ASPX with compiled DLL's for what you cannot go around Visual.Studio Net (my
opinion)

Than even with the first two you have to use to do it well, the server side
to take the actions.

Trying to translate your message in a procedure would that mean, that you on
the server side extract the selecteddata from your listbox and create from
that the delimited string for the SP. This means than that there is nothing
to sent over Internet to complete the query.

What I find a nice site with samples for that is this

http://samples.gotdotnet.com/quickstart/

I hope that I understood you and that my answer did help?

Cor