471,349 Members | 1,927 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,349 software developers and data experts.

sending webform listbox values to stored procedure in asp.net

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

Jul 21 '05 #1
1 1792
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
Jul 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Ken | last post: by
2 posts views Thread by John | last post: by
8 posts views Thread by Steve Schroeder | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.