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 RepliesPrivate Sub ListBox1_DragDrop(stuf) Handles ListBox1.DragDrop
If e.Data.GetDataPresent(DataFormats.FileDrop) Then
Dim Fs() As String
[code]....
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 RepliesI 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 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've spent FAR too long trying to troubleshoot this simple operation.I want the user to select multiple files in an OpenFileDialog (called OpenFileDialog1), click OK, and then have the filenames display in a listbox (called ListBox1). When I run, the openFile dialog allows the user to select mutliple files. However, on clicking OK, the dialog repons allowing the user to select only a SINGLE file. Then, it throws an "outside of array" exception.
[Code]...
so basically, (pretty simple) I have this listbox, filled with items like
(eg.)
Billy Bob
Jerry
Jo-Shmo
Okay, how can I 'search' and listbox item containing 'Bob', like I click a button on a form with the listbox presented, and then it auto-selects the one that contains bob? HOW COULD I DO THAT?
I have two dates. [code] How to print all dates between these two dates in one listbox, for example: [code]
View 8 Replies[Code]...
and Also statment to search between 2 Times. [URL]
I have a list of File_Name, File_Date.
I need to check this list sometimes against a file name and sometimes against both a filename and a file date.
I've been doing a for each loop and checking each value, I've tried a hash table keyed on file_name which is much faster, however I also need to check to see if the file_name and File_Date combination exist.
Is it possible to have a list that I can do a quick search on using either the filename or both the filename and filedate.
I am writing tests for flights. I need to select dates between 30th march 2011 to 30th april 2011. for departure and return flights.
View 1 Repliesmy problem is want to use WHERE clause to extract only year that fulfill a specified criterion. My coding as below, the coding below is extract all the month,day and year. But i only want year only. I am using MS Access. My textbox(cbYear) can select January To December. Can anyone give me a guideline to correct the coding.
sql = "SELECT * FROM sumPercent WHERE plants = '" & yieldsummary.cbPlant.Text & "' AND [b]dates = #" & cbYear.Text & " #[/b] AND line = '" & ds.Tables("sumPercent").Rows(a).Item("line") & "'"
I have a database (MDB, Access) and I connect it to my program using an OLE object,
now I have in the db a column filled with dates (ddmmyy),
I want to search and view (in Data grid view) all the fields that has a date before a Specific Date that I define .
the code of search that I used is :
SQLstr = "SELECT * FROM tb WHERE anomber = '" & TextBox1.Text & "'"
cmd = New SqlCommand("select * from employee_log where log_datetime >='" + DateTimePicker1.Value.Date + "' And log_datetime<= '" + DateTimePicker2.Value.Date + "'", cn)
Suppose if I select two dates june 21 and june 30 then records between 21 and 30 including 21 and 30 should be shown. But the records of june 30 is not shown..only from 21 to 29 is shown by this code. What should I add or edit to this code?
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?
been a long time since i came to the forum. i use to program a lot in vb6 but its been a long time since i did it so im really rusty. now that im trying to get back to programming, im finding it a bit of a challenge in vb2008... i have this question, im using a datetimepicker control to select dates in a calendar. what im trying to do is disable the textbox in the datetimepicker so that the user can only use the drop down calendar to select the date and not enter the date manually! does any one knows how to disable the textbox in the datetimepicker but still be able to select a date from the calendar???
View 4 RepliesI'm trying to select all the work's accidents between two dates, but my datatype in sql server 2000 is varchar instead datetime.
For example when i want the fields from 01/01/2010 to 01/10/2010 it shows me all the values from 01 to 10 but from other year and month. I know the easy way to do it is changing my datatype into the database but when i do it the value saved into the table is 01/01/1900.
I'm Using MonthCalendar Control in my Form to select Multiple Dates. (for eg. 1st April,20th April,25th April). I'm planning to Change the date the user clicked by making it BOLD during run time, so that i can retrieve the results in a Date array. [code] MessageBox clearly shows the date selected, but no effect for the "addboldeddate'.
View 3 RepliesCurrently 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 am trying to make a reminder, but i can't figure out one thing. Anybody out there knows how? I would like my reminder to have a function when you select one date it automaticaly adds 2 reminders up to the day of the event. For example if you select the event at date 24 it would automatically add two events at the calendar at the dates 17 and 10.
View 3 RepliesI am have an issue with my between sql string. After testing this i have figured out the problem but don't know how to fix this. When i select two dates i want to get the records between(from two date time pickers) the sql string is taking the day as the month so if i: Input 7/10/2011 the sql between string reads it as 10/7/2011
This is my function :
Function ShowTableBetweenSetDates() As DataSet
Dim ds As New DataSet()
Try
[CODE]...
I 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]...
'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 RepliesI have a listbox which on form load generates correctly from a text file like so in a listbox...ex"John Doe, 1""Bob Brown,2"I now would like to search the listbox if it contains either a "1" or a "2" which is does in this case and copy the item to another listbox. The 1 and 2 indicate positions I have a position listbox for each position. So 3 listbos, first one contains the names on form load, 2 other empty listboxes one for position 1 other for position 2...I have tried the following
If xReservationListBox.SelectedIndex = xReservationListBox.FindString("1") Then
'MessageBox.Show("Found It")
xSpot1ListBox.Items.Add(xReservationListBox.Items(0))
[code].....
Means 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]....