Im trying to figure out how to query a dataset when I select multiple values in a list box? I have the list box linked to the dataset and am using a button to search the values selected in the list box. I don't know what to do!
View 7 Replies
I have a listbox populated with dates in the format of dd/mm/yyyy e.g. 12/03/1983, 06/07/1987 etc.. Could someone please post the code that I could use so that I could search the listbox to multi-select the dates that fall within a specific month (not year or day). So for example I might want to highlight all the dates that contain the month **/10/** (october). I'm really struggling with this.
View 4 RepliesI have a list box on a form and it works fine for what I want to do.I am wanting to edit items on the form, this means populating the listbox and then selecting the relevant items.
My listbox contains a list of item sizes, i want to select the sizes which belong to the item being edited.
can someone give me some pointers.I tried me.lstItemSizes.SetSelected(i,true) but this only works for a single item.
[Code]...
I want to select many items from the listbox in vb .net i. e i have the following code:
For i As Integer = 0 To Me.lstdep.Items.Count - 1
If dt.Rows(0)(3).ToString.Trim = Me.lstdep.Items(i).ToString.Trim Then
lstdep.SetSelected(i, True)
End If
Next
running the above code i can select only a single item from the sql server 2005.But i want to select multiple items which are seperated by comma in the back end ....
i have having a annoying problem to do with loops.
[Code]...
When the user selects a few rows from my list box i want to run code on them selected items which i can do fine, but when the user only selects one of items and hits the button. it goes throught the loop first and gets the picture and all is fine its when it comes back to this function after there are no more items to perform tasks on. it increments index again and then falls over because its out of bounds of the array. i want it to stop after one loop but i also want it to be able to have the multiselect option still so the user has a choice.
I have created a SELECT FROM WHERE query to perform a search here is my code:
SELECT EmployeeID, DepartmentID, Forename, Surname, Role, Email, Telephone, Extension, Mobile, Photo FROM Employees
WHERE (Forename = ? or ? = '') and (Surname = ? or ? = '') and (Role = ? or ? = '')
I have then put the folllowing code to rung the query within my form:
Me.EmployeesTableAdapter.FillByName(Me.myDataSet.Employees, Me.ForenameTextBox.Text, Me.ForenameTextBox.Text, Me.SurnameTextBox.Text, Me.SurnameTextBox.Text, Me.RoleTextBox.Text, Me.RoleTextBox.Text)
When i search by forename or surname it works fine but when i search by role i get this error..oledbException occured No value given for one or more required parameters.
Im writing a simple VB program that connects to an oracle DB which retreives and inserts data to a table I created.[code].....
I want to be able to search through a table I have created to store all the information.Rather than just searching for one variable which would be easy to do, I want to give the user the option to filter out the search from the form.So say the user hits "Find", they would be given access to 10 comboboxes, they would select the information they want to search for (They do not have to select every box) and then click "Do Find".Then the form would display all the results of the query in the form.
I am to make a program that lets the user save certain data values with a delimiter(":") to a text file(done) Example of data entries [code]Then i am to load those values to a listbox , i was able to do that as well and i include the delimiter when i load the values.Now i am supposed to let the user enter any month/year value for date(mm/yyyy) such as 06/2010 and if any of the entries match the search string then either the program selects those values in the listbox or a popup msgbox is used to show the entries. How the result is displayed is a little irrelevant, but how do i search and atleast select the matching entries in the listbox ? and not just the first instance but all instances of the search string.
View 3 RepliesCode:
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
If Me.ComboBox1.SelectedIndex >= 0 Then
' get new owner owner = Me.ComboBox1.SelectedItem
' apply filter to C1Schedule's data source (show only current owner's appointments)
[Code] ....
I have it filtering results based on which doctor I select. I also have a "SHOW ALL" item, how would I get it to actually show all the appointments regardless of doctor? Put it all in an if/then statement and check to see if the selected index of the drop down list is the SHOW ALL option? I'm not sure how to programmatically get it to show all though. It actually shows all the appointments (without filtering) as soon as it's opened, it only filters when I want I just need it to go back to unfiltered when I pick SELECT ALL.
I tried every combo I could think of to get it not to filter the results when I select SHOW ALL, but none have worked.
If Me.ComboBox1.SelectedIndex >= 0 Thenfilterelseme.ComboBox1.SelectedIndex = -1
If Me.ComboBox1.SelectedIndex >= 1 Thenfilterelseme.ComboBox1.SelectedIndex = -1
I don't know how to get it back to -1. The drop down list is populated with three doctors, and I added the string SHOW ALL, so as far as I know the index starts at 0 and would start with SHOW ALL. I tried an ElseIf me.combobox1.selectedindex = 0 then me.combobox1.selectedindex = -1 too and that doesn't work either.
I am trying to Query a table with data from another table and return a filtered result
Dim i As Integer = 0
For Each lrow In dtlist.Rows()
Dim lat As Double = dtlist.Rows(i)("Latitude") 'CDbl(Me.SubjLat_txt.Text)
Dim lon As Double = dtlist.Rows(i)("Longitude") 'CDbl(Me.SubjLon_txt.Text)
[code]....
Obviously doesnt work but the idea is thats the Value i need to put in the Value Column of dtlist In short the project, loops through one table(dtlist) of address's and gets the distances of it from the address's in the second table(dtsold) then gets the higest value from dtsold within a certain distance?
I have a query that can be summarised in SQL as follows;
Select
S.StockCode
From
StockToCheck As S
[Code]....
Where the S var is a list of strings. This gives the error 'S' is not declared and points to the S in the function call / join (GetPOSStock). So it does not seem possible to do this in Linq, can anyone confirm?
I'm a bit of a noob at this and finding that all my research that's led me to wanting to do things right for data integrity are making it a bit more complicated on the front end.
Presently I have a Form in which I have two DataGridViews that I'm populating, each with it's respective stored procedure.
What the form is for is for linking rows from the one DataGridView (I'll call it DGV1) to a different one in the other DataGridView (DGV2).
Now to facilitate the ease of doing this for the user I want to both have the dgvs fully populated so that if the user wants they can just slide on through and manually select the rows in each they want and then there'll be a button to select which I'm planning to then use another stored procedure to then insert this connection between these two items into the database.
Another thing to facilitate this is a search bar. I want them to be able to type in something and have the datagridviews both navigate to where their selection is as well as selecting it so that it's then ready to be bound to the selection in the other.
What I'm wanting to know, and having a hard time figuring out, is how do you get such a search function to work on DataGridViews that I have bound to these read only stored procedures? How do I search and select within the DataGridView? And then how would I go about using the selection from two different datagridviews and putting those as parameters in the stored procedure that I wanted to use to then record the relationship in the database?
Currently i have this code:
If InStr(1, UCase(TextBox3.Text), TextBox2.Text) <> 0 Then
End If
which sees if text from textbox2 is in textbox3, but if there are multiple lines in textbox3 then it wont search.
have an app where the user can select to search websites I have "Hard-Coded" into the app and select categories and sub-categories to search within those websites.What i need is to figure out how to take a user defined search query (Example: The Holy Bible King James Version), then search the relevant websites (behind the scenes) then output the results something like a google or bing search, then allowing the user to download directly their search query
View 3 RepliesI have searched for a simple way to search a string array. MS gives a clean simple solution for a one dimesion string.
Dim StrArray() As String = {"ABCDEFG", "HIJKLMNOP"}
Dim FindThisString As String = "JKL"
For Each Str As String In StrArray
[code]......
I want to select to multiple sql tables using select query in vb.net..I have 2columns in sql table..I have tried this query.. But i'm getting error.
TextBox11.Text = Val(27)
cmd = New SqlCommand("SELECT outside,power FROM vijay21 INNER JOIN vijay22 ON vijay21.outside=vijay22.outside WHERE outside BETWEEN " & Val(TextBox11.Text) & " AND " &
[code].....
Private Sub ListBox1_DragDrop(stuf) Handles ListBox1.DragDrop
If e.Data.GetDataPresent(DataFormats.FileDrop) Then
Dim Fs() As String
[code]....
'look at the picture
'dtg1.cell(0) = file directory
'im select multi file and i want to chang attrib all file select in dtg1
For Each fl As System.IO.File In dtg1.SelectedRows
System.IO.File.SetAttributes(dtg1.Rows(dtg1.MultiSelect).Cells(0).Value, &H80)
Next
Can a listview multiselect in the same way as a listbox can, when it is set to electionMode = multiSimple?for instance when the listbox is set to selectionMode = multiSimpleyou can just select any number of items in the listbut...with a listview you can only multi-select when you hold down Ctrl. As soon as you lift the Ctrl key and click on an item it de-selects everything and only selects the last one you selected
View 4 Repliesi have been given the task of making a small program in vb.net to have two list boxes. The first list box contains the data and the second one is blank, when you select the one bit of data from the first list box it can be draged and droped into the other list box. my task is to make it so you can select multiple bits of data from the first list box and all that is selected is draged over to the second one when you drag and drop it.
View 1 RepliesSQL String with multi line query
View 14 Repliesafter i get a successful ping response i need to send an HTTP request to the device examine the response and then display it. i'm trying to multi thread the 2nd bit with no joy so far.
Imports System.Net
Imports System.Net.NetworkInformation
Imports System.Threading
[code].....
im trying to write a query using multi 'where' conditions however am having so difficulty making it suitable for vb, sql = "SELECT * FROM Room WHERE [Room Size]= '" & Noofppl.Text & "'" AND [Number of PC's] = '" & noofpcs.Text&"'"
View 7 RepliesMeans if i have two columns in database namely name & email i wanna search the users or email by entering either name or email on textbox then after clicking the search button record will be displayed in gridview ?can anybody tell me the select query for this ?
View 1 RepliesRegarding multi column search, i want to clear you the situation where one column contains say FirstName and the another column contains LastName for the 'Contacts Combo box', then when user types either FirstName or LastName for the person, combo box should search for the appropriate value into both columns.
for my fifth question consider the same combo box with FirstName, LastName all typed together shows in one column only then, by default combo box searches only for strings that 'Start' with the string typed in the textbox portion, insted of which i need a feature which allows me to let set the behavior of combo box search system tobe able to search for the typed strings within any part of record.i.e. If user types 'Ja' in textbox portion, the the list should show following maches
Micle Jackson
Sandeep B Jakhotya
Javid Akhatar
Suresh Jadhav
[code]....
What I am trying to do here is search a multi-line textbox that contains the source of a particular website.what I would like is something like this but i do not know how to right it like i need
Dim MyString, FirstWord, LastWord, MidWords As String MyString = "Mid Function Demo" ' would be the textbox FirstWord = Mid(MyString, 1, 3) ' Returns "Mid". LastWord = Mid(MyString, 14, 4) ' Returns "Demo". MidWords = Mid(MyString, 5) ' Returns "Function Demo".
this function works fine only when you define len.what I need is a function that will do something like this, "note obviously interpreted code"
Dim text, A,B,C as string text = textbox1 A = "<body>" B = "information between A and C being of variable len" C = "</body>" textbox2 = B
I do not want anything like,
remove "<>?|?()}{][" etc.
I had set the multiselect option to true for listbox.Let me know how to move the list items up and down with this option.
View 2 RepliesI have been given the task of making a small program in vb.net to have two list boxes. The first list box contains the data and the second one is blank, when you select the one bit of data from the first list box it can be dragged and dropped into the other list box. my task is to make it so you can select multiple bits of data from the first list box and all that is selected is draged over to the second one when you drag and drop it.
View 1 RepliesI have a list box that is bound to a table in a database. It produces a list of companies. The user will then come along and select multiple companies that they want to view information about, and then they hit a select button which I'll display the company information (e.g company name, company site, address e.t.c) in a gridview underneath. However the issue that I am having is that it only displays ONE of the multiple companies selected and its always the top one. How I get all the companies to be displayed in the gridview?
I am programming in vb.net
<asp:ListBox ID="ListBox1" runat="server"
DataSourceID="SqlDataSource11" DataTextField="compName"
DataValueField="compDataID" SelectionMode="Multiple" AutoPostBack="True"></asp:ListBox>
<asp:SqlDataSource ID="SqlDataSource11" runat="server"
ConnectionString="<%$ ConnectionStrings:IWSRiskAssessmentConnectionString %>"
[Code] .....
I made a program (As usual) that plays media files using the ax.interlop.wmp.dll (windows media player). I also made a listview on the form that has gridlines. i have a problem with my mutiselect feature though. it just adds the same filename for every file, but in the amount files (Ex: if there is 8 files, it adds the name of the first one 8 times) i just want it to add every single filename to different rows, here is the current code that i have:
Sub openFile()
With OpenFileDialog1
.DefaultExt = "Mp3"
[Code].....
