473,230 Members | 1,811 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,230 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 1862
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: mikeyatsony | last post by:
Hi all.. I'm trying to send multiple INT values to a Stored Procedure that will be handled in an IN statement. ASP Code: strSQL = "SP_Get_Selections '29, 32' where 29 and 32 are 2 integer...
2
by: Not Me | last post by:
Hey, Coming back to a piece of work I did a while back, which used a stored procedure to populate a list box. The SP takes a single parameter, and I think this is the reasoning for using 'exec'...
0
by: Ken | last post by:
Hello, I have a webform that gets a record from SQL Server by using a stored procedure. The stored procedure uses 3 parameters in which after the record is found, stored procedure #2 runs to...
2
by: John | last post by:
Hi, First of all sorry for my not perfect english. I've got listbox in my .aspx page where the users can make multiple selection. So, Users can select 7 items in listbox, I have to take value...
8
by: Steve Schroeder | last post by:
For some reason I cannot get the OnSelectedIndexChanged event to fire for a listbox I have on a page. I'm able to populate the listbox with data from a stored procedure, but cannot trigger the...
3
by: James Radke | last post by:
Hello, I was curious, is it possible to create drag and drop interface from listbox to listbox on a webform application (i.e. vb.net)? Basically the application would need to load multiple...
1
by: Chris | last post by:
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...
1
by: karups | last post by:
Hi, I've got listbox in my .aspx page where the users can make multiple selection. So, Users can select 7 items in listbox, I have to take value from items and pass it to stored procedure to...
6
by: binky | last post by:
Good afternoon folks, I have a performance question if anybody might have suggestions. Functionally, everything i'm about to describe works as intended. The only problem I'm having is speed. ...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

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.