i have a textbox1=Year and a textbox2=Month and a datagridview and as datasource access i want to know the code if i search for a year in databinding and how to look for a month of the focused year?
View 4 RepliesI have 2 listboxes, listbox1 holds File names, listbox2 holds fullpath of the files(listbox2 is hidden just to keep things looking tidy).
What i want to do is (using multiselection) is select files in listbox1 and have listbox2 have the same files(indexes) selected as well.
i am rather new to this but i have tried several ways but listbox2 only selects the first selected file from listbox1.I am using vs2010 visual basic & wpf?
In a small app for demonstrating the use of Regular Expression matching in a text box, I have set it up so I can select one of the matches at a time in the text box to emphasise it. Is it possible to set up a text box so several isolated sections in the text is highlighted so all of the matches are highlighted at the same time. I'm thinking not and could use a picture box to do this but with all the hidden features in vb.net, I wanted to be sure since this would be very handy for my project and would be more useful for large amounts of text. I've read you can make multiple selections in the text box of a combo box.
View 4 RepliesI'm using this code to select all the IDs from the mysql database:[code]The command will return all the names. How can i process each one individually ?
View 6 RepliesWorking with a couple of listboxes to display userid and emailaddress. I am writing an application for viewing SSRS reports instead of using the Report Manager. I am able to select the report and also send an email to users with a web link to SSRS report so that ReportViewer comes up for them to view, export or print the report. Currently I am only able to send to one recipient and I'd like to be able to send to multiple recipients. However I am having difficulty with the multi-select from a listbox. I have set the SelectionMethod to MultiExtended and so I can select multiple items from the listbox. Here is my code -
[Code]...
and I also add a messagebox.show to display my values, in EmailAddressTo variable, it displays "System.Data.DataRowView" so it was not able to capture the email address at all. Then if I debug further I eventually get the error msg - "The specified string is not in the form required for an e-mail address." because of the empty variable. Using SelectedValue, I was able to get at least the first email address but not the second one.
I am a new student of Visual Basic. I am using Vis. Studio 2010. Is there some sample VB code that I can gain access to that shows how to test on multiple selections that were selected within a listbox using the "For each" construct? In this scenario, multiple items have been selected but not 100% of them. I need to know how to test on which ones are selected as I examine each one in the list using the "For each" construct.
View 2 RepliesMy name is Tim I'm having a problem getting my multiple selections from my list box to display in the results label and there is no examples in the text any how I'm thinking I need to use a loop to get it done. is this evern in the ball park?
Option Explicit On
Option Strict On
Option Infer Off
Public Class MainForm
[code].....
Ive got 10 comboboxes on my form, each of them have the same items. I'm trying to get so that if I pick something from the first combo box it doesnt show up in the list for the 2nd box, etc. Also, I didnt want to just remove the item, incase the user changes their selection in a previous combobox. [code] Rest of the comboboxes have that last piece of code, with the boxes and stuff changed to the correct ones.
View 7 RepliesIve got 10 comboboxes on my form, each of them have the same items. I'm trying to get so that if I pick something from the first combo box it doesnt show up in the list for the 2nd box, etc. Also, I didnt want to just remove the item, incase the user changes their selection in a previous combobox.Example of the code I used, as im on a different computer right now.
Code:
Dim cboList As New List(Of String)
Dim index1, index2, index3, index4, index5, index6, index7, index8, index9 As Integer
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code]....
Rest of the comboboxes have that last piece of code, with the boxes and stuff changed to the correct ones.Problem is that it doesnt remove the previous selections correctly.
I have code that works to place two items in listbox into two textboxes when selected (multiple select extended).
Private Sub lstOutput_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lstOutput.SelectedIndexChanged
Dim i As Integer = lstOutput.SelectedIndex
[code]....
I need also to be able to modify the data in the textboxes and replace the lines in the listbox. The reverse code doesn't work properly, it only replaces the first selected item. The "lstOutput.Items(i + 1)" appears not to lead to the second selected item.
Dim i As Integer = lstOutput.SelectedIndex
lstOutput.SelectedItem = lstOutput.Items(i + 1)
lstOutput.Items(i) = txtName.Text
lstOutput.Items(i + 1) = txtPhone.Text
I have scoured the web for ways to manipulate the selected index/indices, with no success.
I'm using Vb .net 2008
I could use some advice/examples to acheive the following:
I have 1 form, 4 text boxes, (textbox1 ,2, 3, 4)
Textbox1 and Text box 3 and single line text boxes.. Textbox2 is multiline.. (a description field which can be as long or short as the user desires..)
Textbox 4 is a large multi-line textbox that will contain the output of Textbox1,2,3.
I need to find out how to output the contents typed into Textbox1,2 and 3 into Textbox4 while maintaining formatting..
For example, contents of Textbox1 should always be the first text displayed in textbox4, immediately under that should be the contents of Textbox2, and under that, Textbox3
I want to ensure that the text is displayed in that order even if the user enters information into Textbox3 first.. and still displayed in the proper order if Textbox2 has 1 line of text or 20 lines of text.
How could I do this? How can I make the text from one box always be inserted before or After text from another specific textbox when its displayed in the destination Textbox.. (think of Textbox4 like a "preview window" of sorts.. which will later be outputted to an actual txt file.
Background: Not a developer by trade. I did however, endeavor to learn VB a few years ago and I got reasonably far but without proper motivation for the time, things were difficult to take further. Fast forward half a dozen years and while working with the sales team in my company, I noticed that they were struggling with cataloguing and tracking their calls to clients. They were all trying to use one excel spreadsheet to tabulate all the clients details and calls. Of course, this was a mess. So the idea is to build them a very simple database app that will allow multiple users to add entries to a db and we could pull reports from the data in the end to check performance and such.
Application: The application so far is a very simple access db with windows forms front end. Two tables, one holding �Client� data and the other �call� data. Idea being that we can now track multiple calls per client as opposed to just the next call as was the norm. Client and CallID are the primary keys of the table, with a clientID foreign key in tbCalls . There is one query which I tried to use to do this, which joins calls and clients so that I had everything in one table. Cool. There are four forms, basically frmCaptureClientInfo, frmSearchClients, frmScheduleCalls and frmMakeCalls. Most of these forms are working fine by just dragging the dataset fields onto the form and allowing the IDE to do the coding and then a little more code to validate that the inputs are correctothing fancy just add, delete, update is all this app does.
Issue: The last form is the killer form. Killer form, because it�s caused a huge rise in blood pressure. Anyway it sounds so simple. On the form is a datagrid that is populated with contents of above query (all client and call details), filtered by the parameter that checks if the call is complete or not. Sweet. Below I have dragged in fields from tblCalls. The �callers� need to edit three fields TimeCompleted, CallNotes and a call completed checkbox. What I need is the tblCallBindingNavigator to jump to the record that I have selected in the Datagrid view. Right now they are independent and I can�t join them. If this is at all possible?I have tried using just the query, which has the right behavior except the update command is not generated automatically. Spent Many hours researching updating queries but either was too complex for me to know it was the solution, or was for different products. If there is a way to do this then that would be awesome.I have also tried editing the CallBindingNavigator databindings settings but I am not sure what is going on there, it seems to block out the navigator controls. Here is some more info:
In VB.NET 2008 I've two forms 1 & 2 containing two datagridviews connected to two data source 'ACCESS 2007 tables' Now I want to select multiple rows from one datagridview (form1) & transferring these to another empty datagridview (form2) with a button_click.
View 3 Repliesi have a datatable named booking_table and i filled it with column names and values
Dim booking_table As New DataTable
booking_table.Columns.Add(
"Time", GetType(String))
[code]....
than the rowindex(0) I want it to start with "8:00" than for example the rowindex(47) should end with "19:00" extra info: every our is parted in four sections of 15 min for example 8:15, 8:30 ,8:45?i want to select the starttime by date.bind to DGV?
im helping a school run a Spelling Bee aimed at children in year 7. And to make it fair and unbiased i need an application that can choose randomise a word from the list box then transfer the string to the text box.So basically something that can pick a random string from the listbox and show it in the textbox1.text property.
View 6 Replieshere's I've got:
Private Sub frm1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim sql, pname, pid, pbrand, description[code]....
This adds the description to the listbox, no problem. How do I retrieve what's selected?I've gone over many documents on the subject, I kinda got it to work, but it gives me the entire description.... I just need the last value (3) to make it work.
im trying to get a selected time and my dataset doesn't return the selections what am i doing wrong in this statement
dim startindex as integer= 0
dim endindex as integer= 0
for each regel as datarow in my dataset.tables("Bookingen").rows
[Code].....
I have a listbox with selection mode set to multiExtended. I want to put whatever is selected into an array, but I can't seem to figure out how to do it. Here is what I have so far, but with this code the selected values go into a single variable and not into an array so only the last item selected is stored.[code]....
View 4 Repliesthis gonna sound like a really basic problem but would some1 be able to tell how me to get a checkbox selection to be displayed as a peice of a text in a listbox or a text box.
View 13 RepliesDim List As New List(Of DateTime)
Then in my button click event:
If InputBookinglength.SelectedValue.ToString = "2" Then
Dim paramstring As New StringBuilder
If Session("SelectedDates") IsNot Nothing Then
[Code]....
This code works fine when selecting multiple days in one month. But when you switch to display a different month, the previous months selections are lost. how to persist the selections when the visible month changes.
Due to some settings changes, my code view cannot make text selections.
View 2 RepliesI have a listbox in a datagrid that is supposed to update upon selection change, and it does, but not on first try. only after it has posted back, after the first time it is clicked will it work as intended.Here is the front end portion of the datagrid with the listbox.
<asp:TemplateColumn HeaderText="Qty">
<ItemStyle HorizontalAlign="Center" Wrap="False" CssClass="grid" />
<HeaderStyle HorizontalAlign="Center" ForeColor="Black" Font-Bold="true" CssClass="grid"
[code].....
I'm creating a VB.NET application that includes two radio buttons inside of a groupbox. If the first radio button is selected, a certain tab on a tab form should be enabled. If the second radio button is selected, that tab should be disabled.
Is there a groupbox method that monitors both radio buttons and fires when the selection changes? Or do I need to set up individual methods for each radio button?
How do you disable additional checkbox selections/deselections without sacrificing the functionality of the ListView? I know you can call: ListView.Enabled = False, but that also disables any scrolling within it.
For example: I have a timer that starts a backup based on the Listview items that are checked. After a certain time, I don't want the end-user to be able to click on any of the checkboxes within the listview (so I have a set number of items to backup), but I do want them to be able to scroll the list while the backup is being performed. I tried this[code]...
I have a combobox that is bound to a dataset. The dataset has 3 columns of data. at any given time there could NOT be any data in the dataset.
When someone selects an item from the box I want to store data from 2 of the columns of the row they selected.I do the 'store' in the selectedindexchanged event.
so currently I am assigning each column/row value to a property from a datarowview i get from combobox.selecteditem.
Code:dim column1 = drv.row.item(0).tostringdim column2 = drv.row.item(1).tostring
But I am getting NullReference exceptions all over the place when there is not data.So i have to wrap it all in a try catch and assign nothing to the properties when the Null exception fires.
I want to also validate that there is a selection made. There must be a selection made if there is no data in the DS fill it.I do this in the combobox validate event.
It just seems like there is a better way to check for no data coming from the combobox.
I wish there was a way to do some sort of .count on the datarowview you get back from the combobox.selecteditem but anything i have found also gives a null ref exception if used.
Also what is used to programmaticly change the selected item?
I have a combobox that is bound to a dataset.The dataset has 3 columns of data.at any given time there could NOT be any data in the dataset.When someone selects an item from the box I want to store data from 2 of the columns of the row they selected.I do the 'store' in the selectedindexchanged event.so currently I am assigning each column/row value to a property from a datarowview i get from combobox.selecteditem.
Code:dim column1 = drv.row.item(0).tostringdim column2 = drv.row.item(1).tostring
But I am getting NullReference exceptions all over the place when there is not data.So i have to wrap it all in a try catch and assign nothing to the properties when the Null exception fires.I want to also validate that there is a selection made. There must be a selection made if there is no data in the DS fill it.I do this in the combobox validate event.It just seems like there is a better way to check for no data coming from the combobox.I wish there was a way to do some sort of .count on the datarowview you get back from the combobox.selecteditem but anything i have found also gives a null ref exception if used.Also what is used to programmaticly change the selected item?.selecteditem.selectedtext.selectedindex.selectedvalue?
I am a new to programming, trying to learn vb.net, so I apologize if my questions are very elementary or my terminology is incorrect. I am trying to format a query to an Oracle table based on user-selected radio buttons on a Windows form (i.e. the query will return different elements from the table based on the radio buttons selected). The query results will be placed in a listbox on the form. My thought was to make a Property containing my query like so:
[Code]...
and then I have a sub that feeds this SQL property (containing the query) into an OracleConnection.My problem is that I don't know how to customize that query depending on what radio buttons are selected by the user. Is a Property the best way to go about this, or is there some other way that may be better?
I have two problems with my datagridview in VB 2005 that I did not encounter in VB6. I would like to add multiple records to a datagridview by allowing the user to tab and type.When they get to the end of a record and tab it should go to the next record like Access does. The user can move to the next record and it even shows the pencil on the left leading them to believe that a new record is being created. But, it will not create the record unless they first click on my button that will add the record with the code BindingSource2.AddNew(). I use a bindingsource to populate the datagridview. Here are some snipits of my code for clarity:
DataGrid2.DataSource = BindingSource2
GetDataDetail(
"Select * from [Order Detail] Where [Order Detail ID] = Null")
[code].....
I have a vb.net project that connects to a sql database.I have a form that contains a datagridview for the database.The database itself contains many different columns (e.g. customer name, serial number, cust phone number, current status)I am concerned about the current status column as it is needed to filter the records in the database. It has different values in each record, such as "Done" or "Waiting" or "Awaiting Collection" or "Damaged".
View 1 RepliesI am trying to add a 2 rows for every record in my sql database.I have 11 records and i want it to be;
Row 1
Row 1 Second Shift
Row 2
Row 2 Second Shift
[code]...
I have tried to add in the for loop that generates the first row tried to copy the row and set the RowCount Just can't work it out
For i = 0 To rowCount - 1
dr.Read()
With dgHours
.Rows.Add()
[code]...