Best Method - Displaying The Items That The User Has Selected?
Mar 4, 2010
I'm building an online shop, but have run into a problem.When the user click that they want to add a product to their basket, i add the product ID to an array that is held on the session.This all works great and i display how many items they have selected etc..The problem comes when i get to the checkout page.Whats the best way of displaying the items that the user has selected?
should i use a datagridview? if so, how do i pass the array into the SQL in order to get all the data rows that i need?
should i use a repeater? this gives me the same problem as above though.I just cant seem to work out how to get the values fro the array and then run the sql for each ID to get the information to show on the screen.I could loop through the array using each ID as a parameter in the SQL but then where do i put the data? in a dataset? a datatable?
View 4 Replies
ADVERTISEMENT
Jan 18, 2012
I seem to be having issues with the selected index on a list box.
The list box is having various items inserted depending on the user selection. An example would be:
LiIndex = ListBox1.Items.Count
ListBox1.Items.Insert(LiIndex, "Item1")
LiIndex = ListBox1.Items.Count
ListBox1.Items.Insert(LiIndex, "AND")
[CODE]......................
This all work and displays without a problem. The issue I have is if I select the second of the two AND's. If I click the second "AND" in the list and then a button to fire a method, the selected index is always the index of the first "AND". Dim listIndex as integer = ListBox1.SelectedIndex
I can't work out why, the listbox itself will always show the second one as selected, but the action will happen against the first one.
View 2 Replies
May 29, 2009
I have created an access database which i want to search with vb.net, I tried a few thing but it didnt work as desired.
Firstly the program is suppose to display items in the database base on the criteria selected by the user. what i've succefssfully done so far is I've added a datagrid 2 combobox, 1 (searchcbo) with the columns in the database and the other (searchcbo1) will autoload the items under the column selected in and a button (searchbtn) but i have no clue of the code to put in the button. i also tried the fill method but that didnt work as i wanted to. ultimately i want a combobox with the list of columns and a textbox to enter criteria and of course a search button.
The searchbtn should act as the "WHERE" sql command, e.g. SELECT EmployeeNumber, Firstname, LastName, Phone, Location....etc FROM CallLog WHERE searchcbo.text = searchcbo1.text And display the results in the datagrid.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'CallLogDataSet.CallLog' table. You can move, or remove it, as needed.
Me.CallLogTableAdapter.Fill(Me.CallLogDataSet.CallLog)
[CODE]....................
Attached image(s)
View 3 Replies
Sep 1, 2011
In my Windows Form I have a ComboBox that is filled by a Stored Procedure with a list of names. I have the Combobox set for AutoComplete to "Suggest" and From "ListItems". When a user starts to type in and the AutoComplete does not find any matches in the listitems the user can tab out of the ComboBox and leave what they typed in the combobox even though it is not one of the Valid Items. Is there a way to check the Comboxbox to make sure of of the selected Items has been selected?
View 3 Replies
Jul 5, 2011
I'm creating a BASIC application, and I can't figure out how to save a user selected file (FolderBrowserDialog) to a location selected in another dialog (SaveFileDialog).
View 5 Replies
Feb 28, 2009
i have a table in sqlserver2005 which has currently following data...CUST_ID
[Code]...
Now i want to show highligted rows in a DGV according to there status, i mean show only rows of each cust_id "notpaid" status...the 1st "notpaid" status. like in cust_id 1, first "notpaid" row. I think now u got the idea wht exactly i m trying...please guide me step by step with proper code...actually i m new and i think myself as copy-paste king.
View 10 Replies
Jul 23, 2010
I am using DevExpress.XtraEditors.LookUpEdit to display the information about the classes available. Currently it has 3 columns. The lookupedit is working perfectly except when I set the editValue to the last row. When the editvalue is set to any row other than the last one it shows the selected row when the lookupedit isn't opened yet when the lookupedit is set to the last row nothing is displayed.
[Code]...
Right now the lookupedit displays the selected text unless I select the last row, row number tableData.Rows.Count which then displays nothing. Yet when I print the values they are correct and when I remove the +1 when setting the lookupedit it sets it to the previous line I want an the first row can't be displayed.
View 1 Replies
Apr 19, 2011
I need to display a button when a textbox is being used.
View 1 Replies
Jan 18, 2009
Please see Image : [URL] am not supposed to paste external links, but just wanted to share the concept clearly. In the picture, I have department and listbox. Now, I have a Table name - "Company_Data" with the Columns:
Name|Age|Department|Salary
All I want is when I select the department in the drop down, the list should show all the names under the department. Also, when I select the name in the list and click delete. It should delete the complete record from the Table.
View 1 Replies
Apr 16, 2010
I am creating a DB application using the DataSources Wizard to create a strongly typed DataSet. Let's say that I'm working with the Employees Table of the Northwind DB, and my code is like this:
Dim nWindDs As New NorthwindDataSet
Dim empDT As New NorthwindDataSet.EmployeesDataTable
Dim empTA As New EmployeesTableAdapterempTA.Fill(NorthwindDataSet.Employees)
'Fill the Datagridview:Datagridview1.DataSource = nWindDs.Employees
View 4 Replies
Oct 8, 2011
Using VB.NetWindows application Form (Gridview and Textbox)GridView1
ID Name
001 Rajan
002 Sajan
[code].....
View 1 Replies
Nov 13, 2010
This code will display selected checkboxes Text in textbox as in the order I checked it 1,2,3,4,5,6,7,8,9. But it will not display selected checkboxes Text in textbox after 9
Partial Class _45seater_WebUserControl
Inherits System.Web.UI.UserControl
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim str As String = Nothing
Dim id As String = Nothing
How to show after chekbox10, checkbox11, checkbox12 in text box as 10,11,12 ......so on using this code
View 1 Replies
May 4, 2011
My program is working and doing everything it is supposed to do outside of two things. My program is supposed to take the items that are under 5 items and show up in a listbox saying they are low stock by clicking file and then display low stock items. The other problem I have is that I am supposed to show everything in the inventory that has a retail price given to it in the other list box that is blank on my mainform. The attempt I have made on the low stock inventory makes the program go into debugging mode.[code]
View 1 Replies
Oct 11, 2011
work using Access 2010, however am having to use VBA as the Macros are not compatible.I have a form which for this I will call Form1, on this form I have a Combo Box called Combo202, this combo box lists a selection of Building Names, and a button called Command201.The process goes;User selects a Building Name from the drop down list in Combo202, and then clicks Command201. This then opens a form, Form2, which displays a record based on the field [Building Name] in Form2 matching that value in Combo202. I have been using this code;
View 1 Replies
Dec 2, 2009
I have a combobox that has filter items in it:
Me.cmbFilter.DataSource = (From f In files _
Let extension = "*" & Path.GetExtension(f) _
Order By extension _
Select extension Distinct).ToArray()
Displays OK in Vista - doesn't in XP
View 3 Replies
Jan 24, 2009
I have a listbox filled with Tag numbers like this
[Code]...
View 1 Replies
Nov 1, 2010
How to display text in a rich text box when an item is selected in a listbox. Here's a snippet of my
Private Sub radGunsNRoses_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles radGunsNRoses.Click
'Declares songs into variables
Dim strSong1 As String = "1. Sweet Child O' Mine"
Dim strSong2 As String = "2. Novemeber Rain"
Dim strSong3 As Integer = "3. Welcome to the Jungle"
'Band Picture
[Code] .....
What I really want is that when radGunsNRoses is checked, the listbox displays the songs and when one is clicked, it shows the song's lyrics in the ritfSongs. Same thing goes for radACDC but the songs are different and the lyrics.
View 2 Replies
May 3, 2009
How can I save ALL of the items in a listview, items that were added by the user? I tried application Settings and tried creating a settings file but there is not a settings option for listview items.
View 8 Replies
May 30, 2012
The Combo-box only has three items (Top View, From South looking North, From West looking East). Bound data from an Access Query called qryViewsFilteredByJob. I'm using it to pass a parameter to the filter for a binding source on a second query called qryAllSections2 (I don't think that's important though.)
When the form loads up it displays correctly stating on 'Top View', and I can click another other item just fine. When I pick another item, however, the first item, 'Top View', disappears and it replaced by whatever item I just clicked. So if I clicked 'From South looking North', the three item choices are now 'From South looking North', 'From West looking East', and 'From South looking North' again...
View 2 Replies
Aug 2, 2010
I want to get items into the ListBox from Database on FormLoad.
My code is:
database
Private Sub Models_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim qry As String
[Code]....
I am already having three models in database that has to be loaded in ListBox on formload.
View 9 Replies
Feb 17, 2010
if i pressed the RadioButton .. ENGLISH.. only Teacher's which teach English will be displayed in the listbox and so on. there is in access table called TEACHER which has all these information. i used the following code for displaying the TEACHERS' name in listbox and it worked pefectly but what i want is displaying according to radiobutton checked.
Sub conxn1()
Connection.Open()
Dim da As New OleDb.OleDbDataAdapter("select * from Teacher ", Connection)
[Code]....
View 5 Replies
Jun 11, 2011
I have a table being imported into my VB application that has 3 columns. I have written code to import the table, and have written code to display on the first column (country) in a list view.
What I want to do now is have the user select / highlight an item in the list view, and have the third column (currency) related to that selected country appear in a text box when a button is clicked.
Here's the code I've written that successfully imports the data and displays the first column:
Private Sub frmCountry_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim dataCountry As New DataTable()
[Code]...
Should I perhaps use something other than a list view?
View 3 Replies
Nov 24, 2009
I have a list view control and for each item I set to display an icon it will change the icons for the other items that already have icons, to the most recently added icon.
Here is my code.
vb.net
Dim ext As String = Strings.Right(e.Item.Text, 4)
Dim fileandparam As String = IconsInfo(ext).ToString
[Code].....
View 2 Replies
Apr 26, 2011
This is my ListView, Column 1 for ID and Column 2 for Notes I have a Multi-Line textbox and a Button Like this I want to load the selected note on the textbox when the button is clicked.How can I do this ?
View 2 Replies
Apr 23, 2012
So I have three listboxes, LB1 is an uploaded list, LB2 is a master list, and LB3 is generated from LB1 items that are NOT in LB2. I have a button that replaces the selected item from LB1 with the selected item from LB2, woot.Since LB3 is a subset of LB1, I want to be able to select the items from LB2 and LB3 and have it replace the item from LB1 but running into some trouble with finding the appropriate item without selecting it. [code]
highlight Fred from LB1 and Freddy from LB2, click and Fred becomes Freddy in LB1. I want this same change to happen but by selecting the "Fred" located in LB3 (If LB1 is hundreds of names long, I don't want to have to sift through it and only make the changes that need to be made). [code]
View 2 Replies
Jul 6, 2010
I have 2 checkedlistbox on my form. I need to show the not selected items from first one in second one. User may select and deselect anytime so the second checkedlistbox should always shows the latest not selected items from the first one.
View 6 Replies
Jul 15, 2010
I am trying to use a checkedlistbox to tell how many of the items are selected. I can figure it out when I click a button. What I would like to happen is that when I check or uncheck the box I would like it to oupdate. Not wait until the index is changed. It would be nice if the checkedlistbox would throw an event when the spacebar is used to check and uncheck?
View 1 Replies
Apr 10, 2009
I have a listBox called fairsListBox. By question is how can I but into a List the items that are selected from the fairsListBox?
View 4 Replies
Jan 7, 2011
I have a CheckBoxList where one of the options includes a textbox to fill in your own value. So I need to have that textbox become enabled when its checkbox (a ListItem in the CheckBoxList) is checked.This is the code behind, I'm not sure what to put in my If statement to test if that certain ListItem is checked.
Protected Sub CheckBoxList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CheckBoxList1.SelectedIndexChanged
If ___ Then[code]......
View 3 Replies
Mar 6, 2009
There is a listbox whith SelectionMode set to MultiExtended and it has multiple items selected.[code]...
View 8 Replies
