i did this code to delete data from the database and update the dropdownlist of the combobox(i.e,remove the deleted data from the dropdownlist of the combobox):
Private Sub Delete_Btn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Delete_Btn.Click
Dialog1.ShowDialog()
[Code]....
I have a checkbox in my application,when the checkbox is checked then i want to fetch the data from the database and add it to the dropdownlist of the combobox.Again when the checkbox is unchecked then i want to ramove all the data from the dropdownlist of the combobox.
I did this
Private Sub CheckBox1_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CheckBox1.CheckedChanged
If CheckBox1.Checked = True Then
con = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=Etech.mdb")
[CODE]...
When the checkbox is checked then the data is added from the database to the dropdownlist of the combobox but when i uncheck it then the data is not removed from the dropdownlist of the combobox. In the above code i think i need to add an else condition to remove the data from the dropdownlist of the combobox and make it empty when the checkbox is unchecked.......but i cant give the proper else condition in the above code.
I would like to know the best, or standard, way to accomplish real-time client updates in a small multi-user application using an access data table as a data source.
Specifically, this application will be used by 3-4 people. It uses a datatable which is filled on form load and bound to a datagrid at design time. The datatable is stored on a shared drive. The data table on the shared drive is updated in two ways:
1) Users can update the datagrid which then updates the datatable on the shared drive via the data adapter's Update method.
2) A server application does some work on some text files, periodically updating the data table.
I need the clients to reflect the changes to the data table on the shared drive as closely to real-time as possible. I know that the data table stored in memory on the client is disconnected from the data table on the shared drive, so I must query again to get the updates.
I have two questions:
1) Is there an alternvative model I can use which is connected, and which will automatically reflect the updates in the data table on the shared drive?
2) If not, what is the best way to check for changes in the data table (so I can know when to call the data adapter fill method)? I am planning to poll the drive for a change to the .mdb file, raise an event and then fill the data adapter when the event is triggered. I am using this method successfully now to check for changes to a text file in another application, and I know how to implement it
part of my code is in below
[Code]...
I would expect to see the path.Path include the new record, however, I also notice that tempnextgen also include the new record. Can anyone help me out on this issue? Why the tempnextgen got updated as well, how to prevent this unexpected operation?
I have some text boxes in my form that takes data and saves the data to the database. There is a combo box on the form 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 updated record (field)?
the combobox name is cboManager
the Displaymember: Mname
Here's the code
Private Sub frmAdmin_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'UserDataSet.Manager' table. You can move, or remove it, as needed.
[Code]....
I am using the following method to set a value to ComboBox1 whose dropdown type is set to dropdownlist:
ComboBox1.Items.Clear()
ComboBox1.Items.Insert(0, "ABC")
ComboBox1.SelectedIndex = 0
Is there any other and better way to do it?
i am using one combobox and displaying all the emp name available in my database.i have one text box and one button .if i press on button one emp record will be deletes from mytable.then if i click on dropdownlist of combobox i want to display updated result how?
View 2 Repliesi have a bound datagrid that allows users to delete & edit records within the grid using 2 buttons. delete deletes the record from the datatable. edit takes the cell values and places them in controls outside of teh datagridview for teh user to update, they then click an update button (outside datagridview) which updates the datarow
i delete a record using the dt.Rows[e.RowIndex].Delete method so that i can use the Rowstate property to do a final update on all records the problem arises when i delete a record then go to edit a record the CurrentRow index is incorrect as it still see's the deleted record.
if i delete the first record in the grid, then go to edit the next record (which is now rowIndex 0) i get an error saying unable to update deleted row contents
i then tried to use the defaultView property of the datatable when updating the row - which will update the row on screen but when i go to do the final update it see the modified row as its original deleted rowstate.
I have a combo box with four lines of data:
Reina Beatrix Arpt, Aruba, AW (AUA)
Grantley Adams Intl Arpt, Barbados, BB (BGI)
Owen Roberts Arpt, Grand Cayman Island, KY (GCM)
[code].....
I'm currently coding an ATM system in VB, and when a user picks a card to 'log on' with, they have 3 attempts to log on before the card is confiscated.
The card numbers are in a combobox (which are retreived from an SQL database using the binding source which is linked to a data adapter), and each card has a boolean 'confiscated' field in the database.
It does actually set the card to confiscated after the 3 tries, however I'd like the form to 'refresh' so the card no longer appears in the combobox, without having to close down the form and reload it. Is there a way to do this? I've tried refreshing the combobox and data adapter (.Refresh) but this does nothing
i create my custom combobox control and i'd like to set DropDownStyle property on DropDownList but it not works correctly. [Code] When i put my custom control in my form i want to see DropDownStyle set to DropDownList and not DropDown as default.
View 9 RepliesWhat's the difference between Simple, DropDown, and DropDownList in the ComboBox?
View 2 RepliesI have written a function before to delete and update records, but never anything to return values back to my call of the function. Here is my code, and I will try to explain what I'm trying to acheive.
If Not Att1 = "" Then
Attribute1.Text = Att1
Attribute1.Visible = True
ComboBox1.Visible = True
[code]....
That codes goes on up to att20. It works just fine, but it is forever long, and I would like to clean it up.I want to do something like:
Or, should I pass the combobox number also, so that the code can fill the appropriate combobox? Like.comboboxfill(Att1,Combobox1) how to write the function and how to pass back the information or just how to make it work in general?
i have an app that has many suggest append comboboxes in the style of just straight dropdown.
I also clear the text in all of these draopdowns via resettext() in a loop when my user clicks a 'New' button
is there any way to either A:
make the combobox read only (without selecting dropdownlist)
or B:
allow suggest append to fire on all keystrokes instead of only when it sees a match in the combobox....
example: combobox1 contains the following items:
- apples
- oranges
- bananas
as of right now, if my user types in "pears" it won't see any 'P' and won't suggest anything else or even drop down the combobox and allow "Pears" to be entered and because my app does processing only on the items in the list, "pears" then throws an exception....I'm trying to force them to choose only the items in the list and not be allowed to enter anything else while still enjoying the clean look of a resettext() on a combobox
When 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....
I have an windows mobile application. In the windows form of it, I have a combo box.I load the values in the combobox on frm_load event.Now we all know what the combo box has the facility that it allows to enter text as well as chose from the dropdown.So when they enter the text, I want to validate it against the list that is in it.If not then msbox error.
My loading of the combo box is here.
Private Sub mainfrm_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim con As New SqlConnection("XXXX")
Try
[code]....
I would like to know the best, or standard, way to accomplish real-time client updates in a small multi-user application using an access data table as a data source.Specifically, this application will be used by 3-4 people. It uses a datatable which is filled on form load and bound to a datagrid at design time. The datatable is stored on a shared drive. The data table on the shared drive is updated in two ways:
1) Users can update the datagrid which then updates the datatable on the shared drive via the data adapter's Update method.
2) A server application does some work on some text files, periodically updating the data table.
I need the clients to reflect the changes to the data table on the shared drive as closely to real-time as possible. I know that the data table stored in memory on the client is disconnected from the data table on the shared drive, so I must query again to get the updates.
1) Is there an alternvative model I can use which is connected, and which will automatically reflect the updates in the data table on the shared drive?
2) If not, what is the best way to check for changes in the data table (so I can know when to call the data adapter fill method)? I am planning to poll the drive for a change to the .mdb file, raise an event and then fill the data adapter when the event is triggered. I am using this method successfully now to check for changes to a text file in another application, and I know how to implement it?
I have a combo box on my application (working with VB.net) called CmbAttendantstatus. I have sent the dropdownstyle = dropdownlist at the Properties level of the combobox.
There are 200 field types e.g;
Current Attendant
Ever Attendant
Never Attendant etc
The issue is I can only select one from the list, fine, but I want to be able to type the first letter on the combobox and it takes me to the nearest field type rather than looking through the entire drop list. For example I want Never Attendant, I just need to type N and the drop list takes me to anything starting from N and if I add E for example any field starting with NE shows up for selection. Presently, when the dropdownlist is selected you are not allowed to type anything...
I am facing a strange situation. I am having a database inside my my Vb.net application and having various table in it. when I am saving data in my database, the data got saved in it but and every thing works very nicely but after some times means after 5 to 10 minutes the data gets deleted automatically from my database.
View 3 RepliesI'm having the hardest time figuring out something that must be easy. I'm using VB 2005, created a new Web Project and on one of my pages, I have a Dropdownlist Control. Around 10 things or so get put into it at run from a SQL Database. I have that part working just fine. My problem is that once someone makes their choice, how do I assign their choice to some variable. I don't want to update the database, I just want to assign it to a variable to be used somewhere else in the program. I have tried a number of different lines of code that are similiar to
[Code]...
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 got a problem in showing report. The system flows like below -Systems insert records in CSV file into a table,A in ms access database by batch.Systems update in another table, B, based on these inserted records.
View 1 RepliesBindingsource.position/current. after data been updated
View 8 RepliesWhat I have managed to do is currently display a chart with 3 bars on it linked to textboxes what have numerical values in them when the form is loaded. i.e TextBox1 has an initial value set in it's properties of 10, TextBox2 has a value of 20, TextBox3 has a value of 30.
When I run the program the graph displays these values correctly.
I have also got a button, Button1 which when pressed will plot the chart again, (so if I manually change the values in the TextBoxes after the form has loaded), it will display the new values via the bars.
The problem I have is that if if once the initial values have been plotted when the form loads, i.e. 10, 20 & 30, the Y axis of the chart has a maximum value of 35, so that all the initial values for the bars are shown. But if I change the values to say 15, 30, 80. and then press Button1 to update that bars to thier new values, the bars change but the one that show's 80 can not been seen fully as it goes off the chart, as the Y axis still only shows a maximum value of 35!
Does anyone know how to get the chart to resize to be able to display all the bar values within the chart each time the values are changed and the Button1 is pressed, whether it be reducing the graph for smaller values or enlarging the chart for higher values?
I am not 100% sure I am going about it in the correct way as I have not got any experience in using charts and am having to stuble about the net trying to find basic example code of how to setup and use a chart
My code so far is:
Imports System.Windows.Forms.DataVisualization.Charting
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
I have a project where I have data in the my.settings part of the project. When I compile the project and run it on an XP machine, a Vista machine, and a Windows 7 beta machine, the data is not getting updated. In fact I can't even find the .config file that should be created when my application runs. The code I am using to update the data is this:my.settings.properties. item ("Agent").defaultValue = "Andy"my.settings.save()my.settings.reload()What do I need to do to get the changes to be saved?
View 3 Repliesi try to update the table but not sucessful. In access database the following fields with datatype as under;
Parameters=text
Value=Number
Units=text
[code].....
[Code]...
I have the following records in the table student(see in fig 1). I am trying to update the Name of student whose Roll no =1. But Record is not updated in the database,
I have an issue with a data table that I have updated using the datatable.update command.The datatable is bound to the datagridview using dgv.datasource = datatable.I have used INSERT and UPDATE commands and the INSERT command writes the data back to the database ok. However my problem is that it the dgv is not updated with the primary key (ID field) from the database. So when I save a second time, instead of updating it just inserts the data again.
[Code]...
how to get the updated database data and print into crystal report using VB.net?
Dim rpt As New CrystalReport1()
Dim myConnection As SqlConnection
Dim MyCommand As New SqlCommand()
[Code].....
VB2008 with MS Access Database updated related data ?
View 9 Replies