SQL Statement - Change The Word Mobinil When The User Choose Another Item From The Combobox?
Oct 14, 2009
the below statment is right 100% but what i need is to change the word mobinil when the user choose another item from the combobox
cmd.CommandText = "select * from warehouse where mobinil ='" + ComboBox2.Text + "'".I thought that i can do the follwoing dim x as string x= here will be the item selected by user- and ofcourse i need it to be put instead of the word Mobinil
cmd.CommandText =
"select * from warehouse where x value ='" + ComboBox2.Text + "'" is that possible ?
View 8 Replies
ADVERTISEMENT
Dec 23, 2009
I have a problem with a combobox. I have a form (with information about clients) with textboxes binded to a dataview. One of the columns in the dataview contains a number that tells me what kind of client it is. I don't my users want that my users have to fill in a number in a textbox, but I want them to choose a item from a combobox. De selected value should be the value that is actually saved in the database.
This is my
Dim cmd As New SqlCommand
Dim dr As SqlDataReader
VerbindingMaken()
cmd.Connection = cnnVraagbaak
cmd.CommandType = CommandType.StoredProcedure
[Code] .....
De Datasource is the information in my combobox. With Databindings I'm trying to bind it to my dataset (or view, that doesn't work either) with clients. Every time I get a NullReferenceExeption. The moment I remove the line cbo.DataSource = dsRelatie.Tables("Relatiesoort"), I don't get an error, but it doesn't work either.
That dataset is filled (I've checked) and also the derived view. The column Relatiesoort exists. What do I have to do to make it possible for my users to choose an item from a combobox and save the selected value to the underlying dataset?
View 1 Replies
Oct 31, 2009
Just started on vb.net
I have a combo box with "yes" and "no" with i select Yes i want the label2 to change the text to "yes" likewise with "no"
I've tried to code it in a logical way as possible but it just doesn't works except for the "wtf" so i think that overall my code is correct but the way i want to retrieve the selected item from combo box is wrong.
Public Class Form1
Dim aa As String
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
[Code].....
View 3 Replies
Jun 17, 2011
I am new to vb.net and I am using visual studio 2010. I have two comboboxes on a form, each combobox is set to DropDownList so that a list of items can show in the combobox, but no text is allowed to be entered.
For combobox A, if user chooses item 1, the list of combobox B should be updated accordingly. I think this is quite common on a lot of applications. But I do not know to implement it. I even do not know the keyword to search for the relevant property or event handler.
View 1 Replies
Nov 1, 2010
I am creating the items in a combobox in my code behind. I am setting the display member and the value member. When the user makes a selection from the combo box, I need to get the value of the selected item. I have written some code, but when I step through it, it says that the selectedvalue is Nothing.
Here is the code where I am creating the items in the combo box:
Do While drReader.Read
cboTheater.Items.Add(drReader("TheaterDesc"))
cboTheater.ValueMember = CStr(drReader("TheaterID"))
cboTheater.DisplayMember = CStr(drReader("TheaterDesc"))
Loop
In the selected index change event for the combo box, I am doing the following:
Dim strTheater As String
strTheater = CStr(cboTheater.SelectedValue)
When I step thru the code, strTheater is Nothing
View 2 Replies
Apr 10, 2012
How do I change particular item font(or)text color of a Combobox in VB6?
View 4 Replies
May 15, 2012
What I to do is really simple. I want to add a group of text boxes in my VB net application. note that the number of text box only can be known at run time.
I want to give default value to this group of text boxes. At run time, users can input text and change the text for each item.
How can I do this? Is there a control to do this?
What I can remember is ComboBox control. However, I only can display the item text and do not know how to change the text for each item.
View 1 Replies
Aug 12, 2009
how do i change the label text when I select one item from the combobox.
E.g my combobox contain : A, B, and C
When i click "C" from my combobox, my text label will also change to "C"
View 6 Replies
Apr 7, 2010
I can't seem to get this to work so I need a fresh set of eyes on it! I have a combobox dropdown with some names. When I select a certain name from the list, I want it to change the textbox property.I tried :if combobox1.selecteditem= "edward" thentextbox1.maxlength= "2"
View 2 Replies
May 2, 2012
What i'm attempting to do is have several textboxes where the user input's there information and a seperate text box to give there input a name so it can be sent to a combobox and saved with my.settings so when the program loads or the user needs the textboxes populating they can select the name in the combobox and it fill out the textboxes.
[Code]...
View 1 Replies
Oct 19, 2010
I am trying to change the image in a picture box using a combobox with item collections 0-8.When I run the program no matter what I choose in the combobox it selects case 0 and willnot change. code below for selected index changed.
Private
Sub ComboBox1_SelectedIndexChanged(ByVal
sender As System.Object,
ByVal e
[code]....
View 2 Replies
May 8, 2009
I have a combobox called cbMaterialType on a windows form that's bound to a table in SQL - everything loads great and the combobox displays 'Material' items as it should, in that table I have two fields - Material (as mentioned above) which is a char(25) and InStock which is an nchar(1). If the InStock field contains a '1', I'd like the individual material to be green in the combobox, if '0', then red. I have the simple code in the drawitem event of the combobox as follows, but can't seem to get any results at all:
Private Sub cbMaterialType_DrawItem(ByVal sender As Object, ByVal e As System.Windows.Forms.DrawItemEventArgs) Handles cbMaterialType.DrawItem
If MaterialTableAdapter1.GetData.Item(cbMaterialType.SelectedIndex).InStock = 1 Then
cbMaterialType.ForeColor = System.Drawing.Color.Green
Else
cbMaterialType.ForeColor = System.Drawing.Color.Red
End If
End Sub
I've never worked with any form of color in comboboxes before and this is my first attempt at the drawitem event.
View 10 Replies
Mar 14, 2009
in Visual Basic 2008 i need to no how to get a sertin peace of text from ("texstbox1.text")like say ("textbox1.text") has this in it
"""""""""""""""""""""""""""""""""""""""""""""""""" """"""""""""""""""""""""""
"""""""""""""""""""""""""""""""""""""""""""""""""" """"""""""""""""""""""""""
<!doctype html><head><title> vbforums - Google Search</title><script>window.google={kEI:"Mfa4Sdj0OoHasAPm oNRB",kEXPI:"17050",kHL:"en"};
[code]....
how do i only get the vbforums text?
View 4 Replies
Aug 19, 2011
I have a combobox on a form with the dropdownstyle set to drop down. Users can either salect a value from the list, or type in any value they wish. This all works fine. However, when one particular item in the list is selected I wish to set a different value. Unfortunately I don't appear to be able to set the combobox Text property from within any of the events that fire when the selected item is changed.
[Code]...
View 6 Replies
Oct 21, 2009
title is a bit vague. Is there any way I can tell if it's the user or the code that's altered a combobox? I want certain things to happen when a combobox is updated, but I don't want them to happen when the code is altering the combobox at runtime, only when the user selects something out of them. Unfortunately, if I use the 'Selectedindexchanged' option that triggers when I change the contents in code too. I've tried disabled the combobox while I update it, but that doesn't seem to work. Any way to detect user input only? My combobox is drop-down only by the way, so it's only if they select an option - they can't type anything.
View 10 Replies
Jan 18, 2011
Write an application that tests the user�s knowledge of road signs. The application should display a random sign image and ask the user to select the sign name from a Combobox.
View 12 Replies
Apr 3, 2011
How do i set a label text to display any of the declared string list randomly.
CODE:
View 4 Replies
Oct 18, 2011
solve the problem, I'm unbale to drag icon from tools, I guess I'm wrongly delete something., I already Unstall and install back stil facing same problem.
View 5 Replies
Sep 28, 2010
I try to add .NET items in my ToolBox (choose items...) by browsing. When I click Open, I get this message:
"The security state of an AppDomain was modified by an AppDomainManager configured with the NoSecurityChanges flag."
I work with VB 2010 and Windows 7 - 64 bits
View 4 Replies
May 24, 2010
Contact Title has a default value which is Sales Person. Anyhow, when a user click Edit on the chosen ListView record, i need Contact Title to have the right value that corresponds to the chosen record. For example, if user clicks edit, the fields on the left side will be filled with values. In this case, i want Contact Title to view the right value.
View 1 Replies
Feb 1, 2010
This is my first web-based application using VB 2008. I had no idea where to start so I just chose the 'Wpf Browser Application' and started adding the controls on the form and naming them the same as I would do with a normal non-web-based vb app. I ran the XBAB file under bin/debug using IE and the form showed up but I couldn't enter text or anything even though the textbox was set to enabled?
View 7 Replies
Oct 15, 2010
After display list of data in combo box, next I would like to choose the data from the combo box and display all the information from the chosen data to texboxes , the data from combo box was link from my database (ms access).
View 3 Replies
Nov 2, 2010
I made a pop-up blocker in my Visual Basic browser. Here is my code:
WebBrowser1_NewWindow
e.cancel = true
msgbox "Pop-Up Blocked!"
But how can I make it to where the user can choose if they want the pop-up blocker on or off? Also, how can I make it block pop-ups, but still open clicked links in a new window of my browser? Just curious.
View 9 Replies
Mar 29, 2010
I want to choose a value dynamically from comboBox depending of the values selected previously in two comboBoxes.the code that loads the comboBoxes:
Private Sub LightClassComboBox_DropDown(ByVal sender As Object, ByVal e As System.EventArgs) Handles AreaClasificationComboBox.DropDown
TrafficDensityComboBox.DropDown,.....
[code]....
The problem is that in the last Sub in the If sentence gives an error of: Null Reference Exception, because the compiler thinks that in that event the data are not loaded, although the data are loaded when loadcomboBoxes sub is executed.
View 1 Replies
Apr 3, 2011
I have used the command:
For Each Proc as process in process.getprocesses
Combobox1.Items.Add(Proc.MainWindowTitle)
to populate a combo box with the list of current process windows, however for every process that doesnt have a main window title there is a blank space, is there a way that I could tell it to not insert the item if it's mainwindowtitle field is blank?
View 7 Replies
Dec 29, 2011
i have a combobox containing countries name and their codes like INDIA:CNT001 then i have a textbox that store the code of country i.e CNT001(fetching from database) Now i want to match that code with the combobox code so that the combobox is set to that item when i click a button. i m using vb.net and sql server as database.
View 5 Replies
Apr 7, 2011
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
'Creates a string that holds the path to your file.
'this path uses the Special Dir .MyDocuments
'so on my computer LogPath = "C:UsersTechNoHickDocuments"
'on your computer LogPath might = "C:UsersKirbyDocuments"
Dim LogPath As String = String.Format("{0} est", My.Computer.FileSystem.SpecialDirectories.MyDocuments)
Dim FileName As String = "test.txt"
[Code]...
I am using visual basic 2010 express and would like to know how i can use a text box of sorts or windows explorer function to allow a user to save a file to a location of their choosing.At the moment a folder and .txt file is created in the mydocuments folder of the user's computer using this code
View 2 Replies
Feb 23, 2009
add an if statement and an exit statement to my do loop that exits when my future value (FV) is greater than 1000, then to change the exit statement to a continue statement so my loop will continue even though my fv is greater then 1000, point is to get this to run even though my if statement doesnt do anything. problem something wrong in my code and an exception error (xception of type 'System.OverflowException' occurred in mscorlib.dll)
so can someone show me where or why I have an error is, what am I overthinking now! I could use a hint, OMG i could use a tutor for that matter
[Code]...
View 3 Replies
Feb 2, 2012
Here is some code that I have that works perfectly:
[Code]...
Is it possible to change the keysize and maybe even choose between MD5 and SHA1 encryption with this code? If not, can someone point me in the right direction to find some that does?
View 1 Replies
Feb 13, 2011
my program downloads into a combobox every item(line) that is in a text file located on a server.
Every line in the text file ends with "a)" or with "g)".
Now I just want to make 3 radio buttons:
- one that will allow the download in the combobox only the item ending with "g)"
- one that will allow the download in the combobox only the item ending with "a)"
- one that will allow the download in the combobox of both (I already know how to do).
How can I do so?
To download the entire list in the combobox I do:
Dim List As String = client.DownloadString("http://mywebsite.com/mytextfile.txt)Dim lines As String() = List.Split(New String() {ControlChars.CrLf}, StringSplitOptions.RemoveEmptyEntries)ComboBox1.Items.Clear()
ComboBox1.Items.AddRange(lines)
View 13 Replies
