I want my combobox when I type letter all item has the letter I have type will show in the combobox.... because in the current situation in vb .net when I type "A" all item that start from a will display I want this time when i a letter "A" all those have the letter "A" will display..
View 3 RepliesMy combobox dropdownlist contains 60 to 65 items. So i want to show 5 items in the dropdownlist of my combobox and add a vertical scroll bar in it so that the user can scroll it and see the items. How to add a vertical scroll bar in the combobox dropdown list? I want to add this vertical scroll bar only when the dropdown list contains more than 5 items.
View 5 RepliesI added a few items in the combobox dropdown list at the form load event. [code] At the runtime I dont want to allow the user to write something in the combobox as a text.The user can only select an item from the dropdown list of the combobox.
View 13 RepliesI need to load a list of tables and linked tables in an MS Access Database into a combo box. I have this.
vb.net Imports System.Data.OleDb
[Code]...
1. How do I load the access tables and the link tables into my combo without the system tables showing up?
This is the code that i did to fetch data from the database and filling it to the combobox dropdown list at the form load event:
[Code]....
I'm trying to create a Combobox List and I created the following my first try:
Private Sub ComboBox1_DropButtonClick()
ComboBox1.List = Array("LI-3:comparing and contrasting two or more print sources based on
[code].....
I am used to C like languages such as C#. I added a list box with a list of names. In the code behind I added the below code. When I run the code I am getting the MessageBox but it will state "UserName favorite color is " but does not show the color. I thought it might be misspelled or non-matching names but this is not the issue due to the names being correct.
Public Class Form1
Private Sub lstData_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lstData.SelectedIndexChanged
'Declare Variables
[CODE]...
How to list all font in combobox, and how to change selected font in list accordin font in combobox?
View 3 RepliesI 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.
[Code]...
I'm making a combobox on a form. I want the combobox to have a list of choices from a table in a db. The two columns are a String and a Date. I want the date column to only show the year. I'm hoping I have the code right as it is above, but I'm not positive I've done the whole date thing right.
My ComboBox1 have two options, 1 is "R2" another is "R3". I want to put that either the ComboBox1.Text = "R2" or "R3" still will give me Label8.Text = "ok". So i tried put the code like this but it doesn't work.
Code:
If ComboBox1.Text = "R2" or "R3" Then
Label8.Text = "ok"
Else
Label8.Text = "error"
End If
The above code not working But if i took 'or "R3" ' away, it will work.
I am tring to bind a data to listbox with where combobox.selectedvalue. My code is below; I am using data entity in wpf project;
Class Window1
Dim db As New AdvanceEntities
Private Sub Window1_Loaded(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles MyBase.Loaded[code].....
Also I need to create a query with Join In statement. I need to get two table in one query, they have same values in USERID collumn.
I currently have a list of words in a text file sorted in to alphabetical order and put into lower case, but I would like to be able to also display the line numbers on which these words are associated with.. but only one instance of.
For example,
"This is a random text
file that I
have just made
up this second"
[Code].....
As you can see above, I would like to show that "this" for example appears on line 1 and 4. Hopefully tabbed so that it keeps a nice look to it.
I'm having a bit of a 'brain doner' moment here
I have a list of Objects. Each of these Objects contains a list of other Objects (pseudo code) :-
Private Structure Object1
dim Name as string
dim ListOfObject2 as List(Of Object2)
[Code]....
I need to sort the list of Object1 by the Value in Object2. I have a comparison class which sorts Object2 by its Value nicely.
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 ?
I have a function that returns a Datatable. I am passing a list of Integer as an argument. Then I thought tis would work.
Public Function GetEventsByEventType(ByVal EventType As List(Of Integer), ByVal DayInterval As Integer) As DataTable
Using con As New MySqlConnection(strCon)
[Code]...
as you can see. I use string.join to convert the list of integer to something like this. '1,2,3'. Problem is that is read as a string so i get the incorrect results. I need to have where EventType IN(1,2,3).
I want to know what is code can be write for clear all item in list box??..Here i attach my code for looping for.This looping will display are result in list box. For info i am using visual studio 2005.Public Class Form1
Private Sub btnLoop_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOnWard.Click
Dim num As Integer
[code].....
Dim SQLData As New System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("FixedLineProvisioningConnectionString").ToString())
Dim cmdSelect As New System.Data.SqlClient.SqlCommand("INSERT INTO tblTotalComms_custinfo SET nt_username=@nt_username; SELECT @ID=SCOPE_IDENTITY()", SQLData)
[Code] .....
I want to return the value @ID from the insert statement.
In a vb script program, I have the following code objCommand.Properties("Page Size") = 9999..I have converted most of the vb code over, but this statement gives me a "Property Item is ReadOnly" error. How can I rewrite this line to work in vb.net?
View 2 RepliesI have trouble with my vb application.I create query in dataset like this :Select * from Trans where year(dateTrans)=2009 and month(dateTrans)=5But is not work and error message : year and month function not identified, what is the problem ? what a sql date function ?If i create databound from dataset and drag n drop date field in form with datetimepicker control, if i had update dataset, date field is empty.Whats wrong with datetimepicket databound.
View 5 RepliesI need some help working with an OleDbCommand Statement existing statement
OleDb.OleDbCommand("Select *, (([AddressDisplay])&', '&([City])) AS Address
The City is stored in database with the city name and an additional abbreviation added. I need to get rid of the abbreviation, if possible.I DONT control the database its from a 3rd party.
Example: Houston[HST] I need to remove the [HST]
Can this be done? Either in the command statement of perhaps in the displaymember of the combobox that reads the database?
How do I(Can I) code a conditional statement in a TableAdapter query? I have a product code which can be either 8 or 9 characters long. Product codes are stored in an Access 2003 db table. I need to group products so in Access I have a simple Function which work fine in a Jet SQL query. But I can't get it to work in VB 2005.
Public Function ProdCats(ByVal Prod as string)
Dim Cat as string = Len(Prod)
Select Case Cat
[Code]....
I've seen this in two different places & can't quite figure it out. I can think of at least two possibilities but don't have a lot of confidence in either.When stepping thru code I encounter the following:
If x = True Then
y = New ContextMenu
Me.ContextMenu = y
[code]....
x is False. The debugger stops on the If & I press F11 to evaluate it. The Debugger then advances to Me.y.MenuItems.Add(z), which is *not* the next statement that should execute. Nor does it appear as if it does execute as, when I press F11 again, the Debugger exits the Sub, as it should. But why highlight it as if it will execute?This is even more confusing in the next example:
If Not Me.FindForm Is Nothing Then
If Not TypeOf Me Is A AndAlso Not TypeOf Me Is B Then
Me.x = "OFF"
End If
[code]....
Me.FindForm is a Form, so it's not Nothing. Me is type A so the 2nd If is False. The Debugger stops on the 1st If, I press F11 & it advances to the 2nd If, as it should. Then I press F11 again & it advances to FatalException in the Catch block. What? Did the attempt to evaluate the TypeOf Me cause an error? It shouldn't, and it doesn't seem as if it did as F11 again exits the Sub rather than stepping into FatalException. So why did it stop there?
My first thought was that the intermediate code got out of step with the displayed source code. I've seen that in other IDE's with interactive debuggers, but usually because those allow you to run the Debugger without re-compiling the code. Not so with VS-so that seems unlikely.My second thought is that it's stopping there because those are the last 'executable' statements in the Sub. But that doesn't really make sense as, in other Subs, it will stop on the End Sub.
I can't find what I'm doing wrong. When I execute this code,
Dim dr As DataRowView = DirectCast(Me.LOTBindingSource.Current, DataRowView)
'Format variety Text
Dim drV As DataRow()
[code]....
i did this Dim strUser As String = txtacno.Text cmd1 = New OleDbCommand("Select * from BookDetails Where AccountNo =@acno and MemberId=@memid", con)
[Code]...
the select query that i used in the above code,i have use and in it;so is this a valid sql statement?
How would I add the values from this case statement to figure out a total of all commission sales??
'declare variables for commission amount
Dim intAmount As Integer
Dim Sold As Integer
[code]....
intAmount is the commission
I have problem with select case statement. When I click the button, nothing have happens.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim google As String
Select Case google
Case 0
[code]....
I want to learn abt how to use goto statement in vb.net 2005 because if i want to send the control from one form to other form then i want to use goto statement in vb.net 2005
View 9 Repliesinsert sql statement in array (vb 2005), or any other ways to solve it??
View 1 RepliesI know you can alias an Imports statement in
Imports xyz = ProjectABC.ClassABC
But if I want to use the Project Properties, Reference tab to select a namespace to allow a project-wide setting, is it possible to alias that namespace?