Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old April 3rd, 2007, 04:57 AM
Registered User
 
Join Date: Mar 2007
Location: , , India.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to chandra_yvr
Default About listbox selection mode

Hi In my web page i have listbox in this i am getting the data from the datasource.so if the user selects 2 or 3 items in the list box how should i store that information into database.

what should i write for insert command for 2 or 3 items of selection

  #2 (permalink)  
Old April 3rd, 2007, 07:50 AM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

The simplest answer is to call one insert for each value. I don't believe that there is a way to insert more than one table row at a time. I think that you would find that even if you used a .NET dataset class and added many rows, that ultimately the underlying logic will also simply execute many individual inserts.

-Peter


Similar Threads
Thread Thread Starter Forum Replies Last Post
ListBox Item selection caterpillar ASP.NET 1.0 and 1.1 Professional 1 July 26th, 2006 12:50 PM
ListBox Value Selection problem caterpillar General .NET 0 July 26th, 2006 11:41 AM
Multiple Selection of Listbox jasminecyriac ASP.NET 2.0 Basics 0 June 22nd, 2006 05:20 AM
listbox selection jon23d Access VBA 1 June 21st, 2005 01:35 PM
Listbox selection in a form jpcoutts Access 1 November 10th, 2004 05:02 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.