i have 2 form. form 1 have combobox and second form textbox...how to load data form textbox into combobox..if i type hitachi in text box, automatictly "hitachi" will save in dropdownlist combobox..
View 5 RepliesWhen the form loads I want to fill the combobox with the data present in the database. So I did the below
Private Sub BindCombo()
con = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:UsersGautamDocumentsVisual Studio 2005ProjectsF1pracF1pracBank_Account.mdb")
con.Open()
cmd = New OleDbCommand("Select * from BankAccount", con)
[Code] .....
Doing this code the data is added up in the combobox dropdown list. But when I am selecting a data from the combobox dropdown list,the all the corresponding data of the other combobox also get filled automatically. I don't want to let the other combobox filled with their data automatically....
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]....
Private Sub AddIngoing_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
i have a combo box that contains persal numbers and when a persal nuber is selected or entered, it is suppose to populate the textbox for surname and initials and component description. but with the code i have i get the error:An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll.
[Code]...
I have a problem when trying to show details of XML file by choosing an item from Combobox. I have two XML files, called Employee.XML & Subject.XML. The format is like below
<Employee>
<EmployeeID> </EmployeeID>
<Position> </Position>
[code]....
The Combobox contains Employee and its Position also (eg: A1 - IT professor). When I choose an item in here, its Subject details will automatically show in Textbox (one EmployeeID can have many subjects). I cannot use Combobox.SelectItem because I already set Option Explicit On & Option Strict On. I also make EmployeeID by ascending coming up with its position. How can I show details in TextBox by using Subject.XML? I tried many methods but none can work properly.
Is it possible to have a Textbox on a form that when the user inputs data, ( during Runtime )that data remains in the Textbox for good and the Textbox then becomes read only ? Is it also possible to make it so that the CD with the programme on, is in the PC when the programme is being used. Perhaps writing the Textbox data back onto the CD ?
View 1 Repliesi hve create combobox & text box and add database source to my project...i know how to binding data or load data to combobox using SELECT query..but can i change SELECT to INSERT query cz i wont when i type data into textbox,data will be in database...second..can i binding without add database to project..i mean mydatabase in debug folder..i hve problem binding data if database is not in myproject..
View 7 RepliesI have a tab control application, each tab loads a particular user control and each of those user controls will then add other user controls that are used amongst other the user controls. For example, I have an "ucQuotes" page and an "ucInventory" page, when the specific tab is selected, the "uc****" user control is loaded on that page, and in the case of "ucQuotes" and "ucInventory" they both use a control called "ucPartNumber"; a user control consisting of a combobox, textbox, and button. I have no issues reusing the shared user controls, in this case. My problem arises with my "ucQuickPrice" control, as it is always present at the bottom of the tab control form (separate from the tabcontrol, but on the same form), and it too uses ucPartnumber.
Here's my issue, as I type into the ucPartnumber combobox, the text I type does not appear in the combobox, it appears in the textbox of the ucPartnumber control that is being used on the tabcontrol page. There are no shared instances of ucPartNumber, nor do I have this issue between typing on one tab page and the text showing on the user control of another tab page.I tried just creating the ucPartNumber controls on the ucQuickPrice control, not adding a new instance of ucPartnumber on the .Load event, and the issue persists.
The combobox(s) in question are bound programmatically with about 40,000 items, ".datasource = dataset.tablename" not to a bindingsource. Autocomplete is set to none, I added code to utilize tool tips and the basic combobox filtering functionality. Is this a bug, or is there something I'm neglecting? I'm about 95% complete with this application, and this just happened today. I made the decision, to just reuse the ucPartNumber control on the ucQuickPrice control (originallly it's size and orientation would not fit, but I added some coding to detect what parent is adding ucPartNumber and to change its appearance accordingly). Before, I made this change, I did not have this problem. And, in trying to go back to how I had things set up before the change, the problem will not go away. if the whole control within a control verbage I used is a bit confusing, let me know and I'll try to better explain what is happening. At this point, I'm going to close and reopen vbexpress, as when I started this ordeal, vb started acting weird and wanted me to save all my work, it usually does this before locking up.
i have an error when executing this
ExecuteReader: CommandText property has not been initialized
i create 2 combobox in form, comboproduct & combomodel. i using accessdatabase and using oledbconnection..database in debug folder... i create 1 table, i name it"stock" & 2 column.. first column is product,second model..
i wont load data in product column into comboproduct and model to combomodel..like binding data..
how to load the combo box'values from one form to another form's combobox
Example:
form1:
cust(table name)
no(textbox)
[code]....
now i load the form1's name which is the combo values .. to form 2's combo box whixh is name of 'CName'
I'm trying to do a windows application. I have a combobox with this
Dim sql As String = "Select EMPLID from PS_EMPLOYEES Order by EMPLID"
Dim da As New Data.SqlClient.SqlDataAdapter(sql, "data source = DATASERVERR;initial catalog = HRSYS83;user id=sa; password=sa")
Dim ds As New DataSet
[CODE]...
This works fine, but i want to load a textbox with the name of the employee that i selected in the combobox.
i using this code to load data from accessdatabase to 2 combobox
Dim cmd As OleDbCommand = New OleDbCommand("SELECT product,model FROM combo_table", conn)
conn.Open()
[Code].....
use can see in this picture hve 2 button, Product Entry and New Product..when i insert new product "Khink "automaticly Stock entry will load new data from accessdabase, but problem is if i go to form Stock Entry, old product in combobox will be double..when i close that form, and open it again, product name "Khink" will be double 2 and samsung,hitachi will be triple..
How can MS-SQL Database access wise vb.net
1-How can load data to combobox from table filed?
2-How can check how meany data in the database filed.
I'm creating a dynamic combo box and adding to a form. I'm trying to fill the combo box with a DataSource from an ArrayList and then selecting an item in the combo box based off a value from a property.Problem is, the combo box items don't get bound until after the Form_Load event has finished and the form is visible. So the combo box is empty when I try to set the selected index of the combo box. See code for what I'm doing in detail, and refer to comments in
[code]...
How to select the right selected index for combo box without a hack (Load timer or something stupid like that)?
how to load 1 column data from accessdatabase into combobox item...i mean, i have 1 table " info_table and 1 column "product..so in product column have data like nokia and sony"..i want nokia and sony to be load into combobox item or dropdownlist..
View 4 RepliesI want to load data from a txt in a combobox and a listbox. The txt is composed as follows:
ID NAME
0001,name1
0002,name2
0020,name3
[Code].....
In the combobox I want to load 'NAME " And in the listbox I want to load "ID"
I have two forms, forms a and b. Each form has a combo box. The user selects an item from form A's combo box and saves their selection to a database by pressing a button. How can I display their combo box selection from form A in form B's combo box on form B's form_load event?
View 1 RepliesI have a text file in which there is a list which is composed as follows:
3236, Alberto
5894, Peter
7894: Alonso
and so on ...
What I want is loaded into a listbox the numbers to the first semicolon and load the combobox names.
at the moment i can change the datagridview combobox cell style using the cellvaluechanged event handler using the following code:
Private Sub DataGridView1_CellValueChanged(ByVal sender As Object, ByVal System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellValueChanged
If e.RowIndex <> Column1.Index Then
[code]...
How can I have the information entered into textbox1 of Form 1 load into textbox7 of Form 2 for VB.Net?
View 3 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 have a couple of tables in a sql server database and i want to load the data from them in form load.
Here is the code i use to load the first table
connection string here
Con.Open()
Dim objCmd As New SqlCommand("SELECT * FROM Customers", Con)
Dim cust As SqlDataReader = objCmd.ExecuteReader()
[Code]...
Put the cursor in a Textbox when I load a formla
View 4 RepliesHow to focus TextBox after form is shown? I try with textbox.focus() inload, activated and visiblechanged event but with no success.
View 14 RepliesHow do i load the Main form of a WPF so that a seperate thread goes and gets data from the database while the form is in an apartmentstate? (drag-able / movable) I Know this is possible with opening a new window from your main form like this :
Private Sub openOrderWindow()
Dim OrderWindow As Orders = New Orders
OrderWindow.ShowDialog()
End Sub
[code]....
I've tried putting MyBase.ShowDialog() and .Show() and .9000+ other things The only benefit I've got out of using a seperate thread to load from the databse is i can see the screen right away (as oppose to it being a transparent box until it loads) but i cannot move it around or minimize it?is there any way to make it Movable while it loads?
In my form, I have TextBox/ComboBox to add data into MS Access. There is a Seacrh Option too, When I search it, the results are shown on a DataGrid on same form. When I click on a particular ROW on the DataGrid, the info of that row are displayed on the TextBox/ComboBox that I have, I m using this code for that :
Dim i As Integer
i = DataGridView1.CurrentRow.Index
cboPoll.Text = DataGridView1.Item(1, i).Value
txtHn.Text = DataGridView1.Item(2, i).Value
[Code]...
I have 3 Form[code]...
I use CustomerListForm to transfer text to OrderForm[code]...
the program working normal(Transfer Text Done) if Start Up Form is OrderForm.
but the problem is, if Start up Form is MainForm(MdiParent), OrderForm(MdiChild), CustomerListForm(MdiChild)
I want to format textbox to decimal : I use this code in button1.click , it worked :
TextBox1.Text = Format(CType(TextBox1.Text, Decimal), "##,###.###")
But each time button1.click and textbox is formatted will bring a unexpected error for me. I want in form.load event. I format textbox. I tried above code but it is error.