See the below
Imports System.Data
Imports System.Data.OleDb
Public Class Form1
[Code]....
the last value inserted into the access database will be add to the drop down list of their corressponding combo box.
I have some text boxes in my form that takes data and saves the data to the database. There is a combo box at the bottom of the page that loads data from a specific field of a database. when I enter and save the new data (using the textboxes), the combobox doesn't show the newly entered data. I tried to refresh the combobox using code like combobox.refresh, me.refresh etc, to refresh the form but nothing is working the combobox only display the new data when I close the form and reload the form again. anyway, the data loading in the combobox is done using datasource, displaymember, valuemember in the properties. So, how can I make the combobox show the just added record (field)?
View 1 RepliesI am trying to create a simple Word doc that when the user presses the button it takes the information in the boxes and tosses it into a template style paragraph. But my issue is that I have two combo list boxes as seen in the picture. I want to have two values in the drop down list as seen in the labels next to them but for the life of me I can't figure out how to do this in Word 2007. In Visual Studio this is much easier but I am work and need to snap this out for the folks at work. Is there an option that I can choose in the properties where I type in the values for each drop down or do I have to add them in at run time?
View 1 RepliesMy listview clears and updates every 2seconds. Is there an easy to refresh the list information without clearing first? Like taskmanager
View 2 RepliesImagine you expand onto 'Sofas and armchairs' and click 'fabric sofas', it will redirect to next page on click and it will send data '10661' to the next page. Then the listview will updated with reference '10661'. After that click on another link, maybe leather sofas. The listview will re-update table with new reference '10662'
View 4 RepliesI want to make a Reset Button. When I click Reset Button, Form1 will be loaded again, all data will be resetted.
View 5 RepliesI have a drop down list with font names and I would like to display them with their styles and not names and giving that style to a custom message as shown below This is actually what I need it.How do I acheive this?
Here is how I am loading fonts from my system
For Each f As System.Drawing.FontFamily In System.Drawing.FontFamily.Families
DropFont.Items.Add(f.Name)
Next
Environment = VB.NET 2005 & Pervasive SQL 9.5 ADO.NET In a simplified example, I have single database table (customers) with the columns "customer_code_PK" and "customer_name" This table is presented in VB.NET 2005 as a single form datagrid (bindingsource/dataset). In this example, the database table is populated with the following data
customer_code_PK customer_name
SHELLShell Oil
BPBritish Petrolium
MOBMobile
In very simplified terms, code does the following;
sub on form load
fill dataset with database records (select * from customers)
[code]....
The datagridview loads the records correctly.Here is the sequence of operations that produces the bizzar behaviour.In the editable datagrid;
1.remove the row with PK = MOB -> save_button -> Database correctly updates
2.add a new row with PK = KFC -> save_button -> Database correctly updates
3.remove row with PK = SHELL -> save_button -> Database exception occurs
On this last command, the row SHELL is INSERTED!!, not removed.However, If I change ths save_button routine to this
save_button
call generate_custom_updateinsertdeletecommands
bindingsource endedit
[code]....
It works correctly !Is it correct that you would need to "refresh" the sql update commands after every tableadapter.update?
I want to select some user from list of user(listbox1) to another listbox(listbox2). The listbox1 contains the userids which is from a access table. If i move from listbox1 to listbox2 with the default values it is working fine, but when i try to do the same which is loaded from access table i am getting error. "Items collection cannot be modified when the DataSource property is set." [Code]
View 2 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 am working on button component, and I would like to get up and down arrow keys on the button, and on the click event of these arrow keys to display the images, proposed functionality in the form can be done further. I want to display an image with the text and the arrow keys to display the images when I click on the button like this:
View 17 RepliesHow to use a databound combo box to display one field in the drop down, and another as the combo box text on roll up? Using VS 2005... For example, I have a datatable that has 2 fields. One called "ShortDesc" and one called "LongDesc". I want to be able to see the "LongDesc" column values in the drop down on the combo box. When I make a selection, I want the text in the combo box to read the corresponding "ShortDesc" value.
[Code]...
i have an application integrating the an API (autotask web services). I get the data by using a XML query opposed to a SQL query. I'm trying to figure out how to fill a dropdown list with the returned data. Here is my
Dim AccountID As Integer = 29783925
' Query returns Account details for account with the ID AccountID
Dim strQuery As String = "<queryxml><entity>Account</entity>" & _
[Code]....
I have a combo which contains a lot of different colours. If I press b it goes to the b's in the list and if I press it again it goes to the next b. Is it possible to jump to the colour as I type it so if I type blu it would go to blue. Currently it jumps to the first b when I type b but ignores the lu for blue.
View 4 RepliesI have 2 drop down lists and 1 submit button. It works such that after the user has selected values from BOTH the drop down lists, then the user will click a "Search" button. My problem is, after the user click the "Search" button, the second drop down list is no longer displayed with the selected value, instead it displayed a default value. May I know how can I make sure the selected value remain selected even after the user clicks the "Search" button on the page?
For your info, my coding goes as
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim strSelectedUsername As String
[Code]....
after selecting an item from a drop down list the focus can move to a button control with example code in .Net
View 1 Repliesi developed an application which takes input from drop down list and then creates files when we click on that button for specified value in dropdownlist.And if we click on send button it sends to remote database.All the application is working fine. Can any one suggest me how to run this application without user interaction.I dont have any idea about task scheduler, people said it can be done with task scheduler.
View 3 RepliesI created a reporting utility for my users to view, send (via email), export SSRS reports. I have set up date parameter boxes with calendar drop down and they are able to send via email a URL link that would either display the report via ReportViewer or send a link that would let then view the report in Excel or PDF. This is working just fine. Now I just added a button for adding new email addresses and a new windows form with a textbox for entering the email address and a command button for Save Email Address. I get an error msg Quote: Objects added to a BindingSource's list must all be of the same type.[code]
View 5 RepliesI am trying to add things from a text box to a list box. I am running vb.net on visual studio 2005. At the moment, i have a list box, a text box and two buttons one for adding what is typed into the text box and one for deleting what ever is selected in the list box. i understand that for the adding from the text box to the list box i use the button1_click and need to define the entry as a variable but how do i move it accross to the list box? and also how would i delete the items in the list? the code is as follows: cmdAddZp_click is the add button, Zp is the text in the text box called txtnewZp and the list box is lstZp.
Public Class Form1
Private Sub cmdAddZp_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdAddZp.Click
Dim Zp As Integer = txtnewZp.Text
[Code]....
I have used this form to add new records on my database(ms access) in my database I have a column name 'ID' which is my primary key 'ID' is set as auto number. Now I am having a trouble on creating my update and delete button it's always saying "cannot be delete/update"
Here's my code on add, update and delete
Public Sub SaveRecord()
Try
Dim dbConn As OleDbConnection
Dim dbInsert As New OleDbCommand
Dim str1, str2, str3, str4, str5, str6, str7, str8, str9 As String
[Code] .....
Note my add is working perfectly fine. I just can find the error on my delete and update. Also I have used this to view it to my datagrid I don't know if its the right thing but it's working fine too.
'declared dbpath globally'
Dim dbPath As String = "Provider=Microsoft.Jet.Oledb.4.0; Data Source=../VG.mdb;Persist Security Info=False"
[Code] .....
Another thing is how to code each textbox and combobox to bind it to my records so that when I click on the datagridview each column will be distributed on each respective textbox.
Lets say i label "label1" , and 2 buttons named "button1" and "btnRefresh " [code]So , when user press the button 1 , the text will change. But what should i put inside btnRefresh to reload the forms ? and display the default label.text = "Form Load" ???
View 9 Repliesurl...I've got a drop down inside an update panel, and I am trying to get it to allow the person using the page to add users to a list that is bound to a gridview. The list is a global variable, and on page_load I set that to the gridview's datasource and databind it. However, anytime I click the 'add a user' button, or the button to remove the user from the list. It appears like it is doing a full post back even though all these elements are inside the update Panel.[code]Now I thought the point of an update panel was to be able to update things inside of it without doing a full post_back and reloading the page. So if that's the case, why is it calling page_load everytime I click the buttons? I ran this code and debug and I see that even before any of the code associated with button press fires, page_load runs again.I tried putting the gvAssociatedUser.Datasource = associatedFaculty and the line below inside the Page.IsPostBack check, that prevented the page from working. I tried every combination of settings of the update panel for ChildrenAsTriggers and UpdateMode, and none of them worked.
I've tried won't get it to work.It wasn't causing a full postback so I was wrong as to the cause. I thought the page was doing a full post back thus resetting my associatedFaculty list global variable, but it isn't doing a full postback.The issue I am having is everytime I click btnAddUser it will add one element to the associatedFaculty list and thus bound to gvAssociatedusers. This works the first time, but the second time I click it, it overwrites the first element. So it appears like my associated Faculty list is getting reset each time I click the button?
I have 22 images and I am trying to add them into an array and then assign them randomly to a button so when the button is pressed it will change to the assigned image. Also is it possible to randomize the array.
View 4 RepliesIf you have a form with two datagridviews that were dragged on to the form from a datasource that have a parent/child relationship with foreign key constraints. Is there any difference between using the binding navigator Delete button or adding a button to the form and in the Click event put "somebindingsource. RemoveCurrent". Basically what I'm trying to find out is if clicking the navigator Delete button causes "Removecurrent" or does it do something else or something additional.
View 2 RepliesI have a program where a user can select something from a combo box in a data grid view control. I have it so that they can add something to the combo box via input box. The new item would automatically show up in the combo box at the bottom.
Now the problem is with deletion. I have it so that a user will click delete and a dialog box will pop up with the combo box. There a user will select an item and click delete. The item deletes just fine from the db but it doesn't update the combo box on either the delete dialog box or the datagridview. The only time it shows deleted is when I exit the program and reload.
Here is my load event that populates everything.
Public Sub LoadData()
Try
Dim cmTasks As New SqlClient.SqlCommand("Select * from Tasks where Department_ID =
[Code]....
I just had a question because I cannot seem to find the answers anywhere on the internet... also we are not upto this part in class yet.. Say I have 2 combo boxs... cmb1 and cmb2.. both are datasets from an access table.. how do I make it so cmb2 refreshes based on the value of cmb1? eg; if cmb1 is say, period 1, then i want cmb2 to only show results bases on items I have in period 1?
View 2 RepliesThe ComboBox Items collection is an ObjectCollection, so of course you can store anything you want in there, but that means you don't get a Text property like you would with, say, a ListViewItem. The ComboBox displays the items by calling ToString() on each item, or using reflection if the DisplayMember property is set.
My ComboBox is in DropDownList mode. I have a situation where I want to refresh the item text of a single item in the list when it gets selected by the user. The problem is that the ComboBox doesn't re-query for the text at any time besides when it loads up, and I can't figure out how else to do what I want besides removing and re-adding the selected item like so:
PlantComboBoxItem selectedItem = cboPlants.SelectedItem as PlantComboBoxItem;
// ...
cboPlants.BeginUpdate();
int selectedIndex = cboPlants.SelectedIndex;
[Code]....
This code works fine, except for the fact that my SelectedIndex event ends up getting fired twice (once on the original user event, and then again when I re-set the property in this code). In this case, it's not a big deal that the event is fired twice, but it's inefficient, and I hate that. I could rig up a flag so it exits the event the second time, but that's hacking.
I have a Main form (a window form) in VB.NET which has a Combo Box to display a list of countries. A sub form activated from a "Button" on the Main form allows users to add Countries to their list. But After Adding a new entry the Combo Box on the Main form does not show the update (while it is still open). I have to exit the main form and relaunch it to see the update.
The populate function in shown below. I call this method after adding new countries but still; not good. I have used Invalidate function of combo box but of no use as well.
Public Sub PopulateCountry()
Dim rsLocal As New ADODB.Recordset
Try
[Code]......
I have a datagridview bound to a bindingsource. This datagridview contains one column which is a combo-box.
Upon a click on a button,I change the underlying datasource. The selected values of the combo-boxes change.
But the change doesn't appear on the screen ! To make the changes visible (refresh each combo-box), I have to hover on the datagridview with the mouse or use the scrollbar !
Question 1 : why do I see this ?
Question 2 : what should I do to make the changes immediately visible ?
Does anyone know if it is possible to make a drop down list control (when clicked) list its contents above the item, rather than below? Effectively, I need a drop up list rather than a drop down list...
View 1 Replies