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 DataAdapter), and each card has a boolean 'confiscated' field in the database.
[Code]...
Hoping for some advice, probably an easy question for most people on here but I'm a mere learner. Basically, what would generally be the reason for using a Data Set via adapter rather than just connecting to the database directly using an SQL connection?
View 2 RepliesI'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
How do I add a row and then refill or refresh a DGV? The row is added/inserted successfully.What I can't work out is how to get the new row to show in a properly refreshed DVG.In one case I keep the old DVG view but the new row is missing.
View 1 RepliesI have VS2005, Microsoft Access 2003
ComboA is binded to the Customerstbl and displays the CustomerNames. ComboB is Binded to the CustomerContactstbl for the selected customer above and displays all Contacts for that customer is a second cbobox.
I am having a hell of a time with this, When I select a customers name in ComboA, I want ComboB to automattically query the contacts in ComboB based on ComboA's selection. where do I create the query for getting the contacts for that customer?
In the Customer or Contacts tbl?
Is this something that would be better hard coding or is VS2005 that much improved that its ok to use these binding features?
I have a combobox which is populated using a tableadapter. I set the selection to nothing on form load
Me.OfficersTableAdapter.Fill(Me.DsOfficers.tblOfficers)
[code]....
How can I make the combo show the correct items ?
I want to update the contents of a combobox in a VB program. So I change the underlying data structure (which is an ArrayList), and according to the documentation in [URL] there's a RefreshList method which should do this. But Visual Studio tells me that there's no such method, and when I type it in manually I get an error saying that RefreshList is not a member of System.Windows.Forms.ComboBox.
[Code]....
How Do I show the values from the dataset to the text box based on the selection from the combobox list i already populated the combobox my code is. [code]
View 3 RepliesI can't figure out how to refresh the combobox on my main form after I have added or deleted an item to the table that populates the combobox. I use a separate form to add, change and delete items in the combobox table. I have tried different suggestions that I have found on the subject on the web. Nothing seams to work... Here is what I have right now that does not work.
[Code]...
I have a databound combobox that displays a list of items, and I have a windows form that opens after clicking a button that allows me to make changes to the table that the combobox gets it's values from. When I make the changes and save them (successfully) and return to the parent window, the changes aren't reflected in the combobox. If I exit the app and launch it again the changes are reflected perfectly. I've tried me.combobox.refresh() on the forms GotFocus event, but no luck.
View 3 Replieson a windows form i have a combobox called currency, it is populated by a table-adapter called exchan-gerate which is turn populated by a dataset called mydataset. on form load, i issue update commands to the back-end database that holds the table which populates the dataset - they work. if i look at the update to the combobox, they are not reflected until i exit and restart the app - then they're fine. further down the form load i've tried:
Me.exchangerate.Update(Me.DataSet.Currency)
Me.CurrencyComboBox.Refresh()
am i missing something silly to have the values in the combobox change and refresh at the time of the update to the database? as i said, an exit and restart of the app displays the accurate data.
I am working on a huge multiform project for my company, and one of the few issues I am having is that when I am on the Main Menu Form, then go into a specific form (i.e Sales Order, etc.), do updates, changes, or just view data then close the Sales Order Form, if I happen to go back into the Sales Order Form without closing the entire project, then the Sales Order Form will display data instead of opening a blank form like when I first opened it.
Is there something that I should be adding to the Form Close Event to dump all of the data or refresh the data adapters so that if I open the form again, it will display a blank form that is ready to be used like when I first opened it?
I have tried using;
Me.Dispose()
Me.Close()
when closing these subforms, but if I open them again, the data fields (combo boxes and text boxes) will have random data in them.
when i try to insert data from database into dataset using data adapter, it takes long time, i want to use hourglass but i'm confused how or when i type the code so user will know that application still work.
View 1 Repliesi am trying to join 2 tables together and display them in a list view. i have this code so far
[Code]....
I have two textboxes...on the textchanged event of one textbox, readonly property of other textbox gets defined...e.g. first textbox is retrieving data as add,update,delete...when the first textbox text is changed to update then & then only second textbox readonly property is set to false...Now the problem,I am facing is....whenevr first textbox text is add,delete,its working fine..& second textbox is fetching the correct data..but once first textbox data gets changed to update,second textbox data remain unchanged though its readonly property gets changed correctly..it shows the same data as it was showing the first time when first textbox was changed to update...but after that,its data is not changing.
View 4 RepliesIt uses a Drawmap() sub with map data to create the map on the game load, but I can't seem to get it to refresh, and then re-draw the map based on player location. For example, if the player walks into a door, then it refreshes the map to show them in a building. Any advice on this? Code below:
Imports System.Drawing
Imports System.Windows.Forms
Public Class Form1
[code].....
I have a windows form program that pulls data from a sql server. That same data is being read from a ASP.NET website that sets properties for the site. The SQL server has 3 tables: tblWebPage, tblObjects, tblProperties. and 6 views for the 6 web page: vWebPage01, vWebPage02, vWebPage03..ect. When the program loads you see buttons for each web page on the site. When the user clicks on the Home Page it loads this data: [code]Now, the problem lies in updating vWebPage02, vWebPage03, ect.. I assume with the same data I can copy my form with the code and change the form name and the data set to build and update. So that's just what I did changed the form name where needed and changed "vWebPage01" to "vWebPage02".When I tested the program My "vWebPage01" form it built and updated no problem. when I went to test "vWebPage02" it built the dataset and table adapter fine but it did not update at all.
View 1 RepliesI would like the client app being able to refresh the data every 30 minutes.
View 2 RepliesThis looks like an easy fix but I can't figure this out. I'm trying to have button click event on a subForm (NewTournament), add a record to a database, and then to notify a data grid which lists the records from the same database automatically (the grid is listed on HomeForm).I so for am able to update the database and call upon a new window. But I can't get it to refresh that datagrid for anything. I know I'm supposed to clear the datagrid, get changes, then refill the grid. But everytime I do this, the code is NOT updating. Furthermore, I can very well see that the record is being added.
Private Sub CreateTournament_Click(sender As System.Object, e As System.EventArgs) Handles CreateTournament.Click
' Check the form for errors, if none exist.
[code]......
I'm facing a problem with a datagridview datasorce, or refreshing it. I'll try to explain what is happening. So I have a datagridview called dgvMaterials, I'm binding datasorce to the datagridview from one table in mySQL server. Here is the code:
Dim ds As New DataSet
Private Sub frmSettings_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code].....
I have some processes that run as a background job, allowing a user to continue to use a page, when the jobs are finished (which can take a few minutes) i want to display a message to the user, the best place to display this would be the masterpage AFAIK (incase they move from page to page on the site) so i have defined a div in the masterpage file.
I am trying to find the best method for displaying the data, at the moment i have a method in the masterpage vb file which polls a database to see if the job(which involves complex logic and some db access) has completed, if it has, it shows a message in the div e.g. "Job 13132 has completed" - which works fine.
The problem is this is not dynamic, and i have to refresh the page to call the function that checks if the processes have finished, how can i use AJAX to deliver this content automatically every 5 seconds?
I have tried using an asp timer with a 5 second tick time but the entire page refreshes on the timer click event every 5 seconds.Protected Sub Timer1_Tick(Byval sender as Object, Byval e As EventArgs)
[Code]...
Is there a way to only refresh the div with the updated message, without a full refresh happening using this code? Or if this is not possible, is there any way to replicate the above function using jQuery and still be able to update the DIV text only if a job as finished?
I have a combobox bound to a dataset. I want the combobox to update when changes are made to the dataset.I thought i read soewhere that it is supposed to do that on its own when bound to a dataset but I don't see it happening.Now I am having to refill the combobox from the updated dataset.Is there a way to get that to work?
Code: Public Sub FillDomainDropdown() DomainDropdownDS.ReadXml(My.Settings.DomainDropDownList)
some code here that remove certian rows based on other conditions
With ComboBox1 .DataSource = DomainDropdownDS.Tables(DomainDDTableName) .DisplayMember = "Name" .ValueMember = "Name" End With End Sub
Then if the user makes changes I then call the above sub (from another form someone clicks "done") again to then refill the DS based on the new conditions.so it may add/delete rows from the DS and then fill it. But when its is called from the other class it does not 'refill'
I have two dropdownlist, one is State and one is City. When a State is selected, the City dropdownlist becomes populated. At that point you can select a city, however if you select a city and go back and select a different state, the city dropdownlist is populated by the cities for both states. How do I get it clear the cities for the first state?
Here is the code behind
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
End Sub
[Code].....
i had insert data to my database.and it run perfectly like i want.but when i refresh the server explorer all the data that i inserted using my form is lost when i debug it again.
View 5 Replieshave a main form that displays a users score.I hide the main form when going to a child form.When that child form is closed, it will show the main form.The problem is that the datathat has been changed when going to the child form is not displayed on the main form since it has not been closed.Is there anyway around this?
View 1 RepliesI load up a datatable - bind it to a binding source and a binding navigator - and lots of textboxes on the screen bound to that as well.When I get a concurrency violation - another user has already changed my vendor, let's say - what is the best method to go about refreshing the datatable with current data from the DB?
View 10 RepliesGetting data from csv. Works fine and has done for ages. Problem is when data is in the form of 'SS01' up to SS09. datatable shows as 1.000 for SS01...Any other data is read fine.
Dim Conn As System.Data.Odbc.OdbcConnection
Dim da As System.Data.Odbc.OdbcDataAdapter
Dim strConnstr As String
[code]....
Does this work the way I think it should?
Private _adapter As New SqlDataAdapter("Select CaseId, CaseNum, DateLoaded, Status1, DateDiff(mm,DateLoaded,GetDate()) as mm From Case_T" _
& ";Select CF.CaseId, CFV.VendorId, CFV.DueDate From CaseFileVendor_T CFV Left Join CaseFile_T CF on CF.FileId=CFV.FileId" _[code]....
i'm using vb 2008 and local database sql server compact 3.5 to build a application.the problem is that i can't insert a new data to the database from the app. i'm wrote the query right at dataset and using table adapter. but when i call the query, it succeed but the data don't exist at database.why when i add data, it's not working. actually when i run it, it says that adding process is success, no error, and it shows at the datagrid. but when i look at database. the data that i add is not there.and in tableadapter, i also make sortData, seachData query, i can use both of them perfectly when i run the app.so, i really confuse why is the insert query didn't work.
View 2 RepliesI'm confused with this piece of code listed below. This code calls the update method of the dataadapter object to save the changes made to the dataSETback to the database itself. What I don't understand about this code is that it creates an update command(cmdUpdate), insert command (cmdInsert) and delete command (cmdDelete). My understanding is that the update method saves the changes back to the database. So I don't understand why the author creates these additional commands.
View 6 Replies