I am trying to update my form once the delete button is clicked. There are several fields like Name, Date, Date of Birth and so on. Once I delete record I want the form to automatically load with new / updated data. This form fetches data from MS Access using OLEDB. Once when I close the application and reopen then form will be updated with new values. But I want this to happen once the form loads after deleting.[code]
View 1 Replies
how to trigger a refresh on a form when an update occurs in my business logic.
This isn't an issue for 95% of my forms because they call the update from the form that needs to be updated. However, In some cases an inner form does and update that requires an outer form to reflect this. I've read about Handles, Delegates, AddressOf etc etc and I'm drowning in options.
In simple terms, I need three things to happen
1. Form2 (inner form) has updated info, so the user clicks Save
2. Save calls my Data Access Layer and updates the database
3. Form1 (outer form) has a DataGrid that needs to be notified so it can update via a Sub LoadGrid
It's stage 3 I can't do. How do I trigger a Sub in Form2 (LoadGrid) to do the refresh from an external class.
I want to make a Reset Button. When I click Reset Button, Form1 will be loaded again, all data will be resetted.
View 5 RepliesLets 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 RepliesLet's say that I have a windows application in which I have a form with some controls that are bound to a dataset. A DataAdapter or TableAdapter fills the dataset on form load with a large number of records and user can navigate and change the details for each record. This works fine ... but this app runs on a network. And let's say meanwhile you've loaded your form and you're navigating through it (for half an hour let's say whithout saving changes or reloading the dataset) another user modifes the data and updates the database but as long as you have your application running you can't see those changes !!! what is the method to know whether the database has been updated or how to refresh the datagrid view with the new changes updated by other users while the application is running?
code is
Imports
System.Data.OleDb
Public
[Code]....
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 have a main form with player information (it's a sports application). To add or edit a player the user presses a button which opens another form. They either add or edit from this point. When they click 'OK', it saves the data to the database table then goes back to the main form. The amended or new info doesn't appear. If they close the application, then reopen, the new info appears in the datagrid now.
how I can get the datagrid to refresh once I press 'OK' on the input form?
How can i trigger my update panel to refresh after a certain period of time.
View 3 RepliesI have a datagridview with data from a mysql database, i want to know if is possible to autorefresh datagrid when mysql database is update.
View 5 RepliesI have a vb.net form with a dataGridView
The dataGridView data source is the dgvTableAdapter with this sql statement
SELECT membres.ID, membres.refere_par, bands.titre,
membres_1.prenom & ' ' & membres_1.nom AS reference_nom
FROM ((bands INNER JOIN membres ON bands.ID = membres.[band])
INNER JOIN membres membres_1 ON membres.refere_par = membres_1.ID)
[Code]....
I know the delete statement works because I saw the changes in the database. If I close the form and reopen it, the dataGridView is up to date.
The membres table is an access table
I'm running the app in visual 2010 debug mode.
I'm making a game using vb.net and GDI+. I've been encountering frame rate problems and one solution that was suggested to me was to only refresh certain parts of the screen. I was also told one way to make this happen was to use rectangle or region structures and since I already have these as hitboxes it seems like a perfect way to efficiently reduce the drop in frame rate.
The only problem is that I have no idea how this would work and so far my google searches have been fruitless. Yet again I turn to this very helpful forum, can anyone help me? By the way I've set doublebuffered to true on my form to get rid of the annoying flicker.
Questions. How do I update or refresh only certain parts of the screen?
I'm using a timer set to tick every millisecond to run everything and it refreshes the screen every 2 milliseconds simply using me.invalidate; each time it ticks things move a little bit and stuff happens that triggers other events etc. The problem is that when the framerate supposedly "drops" things start to change. "Bullets" and projectiles appear to travel many times faster and much less smoothly than they do when there a less objects moving on the screen, it's almost as if the timer runs faster... What's the reason for this? Is there a way I can change this? I remember hearing about a "stopwatch" or something that someone used in their game that was more consistent or something.
Also I'm aware that vb.net with GDI+ isn't exactly the best language to make a video game in but it's for a school project and I have no choice in the matter.
how would i go about resetting or refreshing a table adapter before it fills a data grid view (load event). As i have tried a number of things to get it to refresh but it seems that the data connection to the Database is simply not closing and re- openingwould i have to program it to be a manual thing to retrieve the data from the database or am i just not doing it right
View 2 Repliesi am using a listview on my admin form to see those who are logged in. so i have a table which captures users logging in and logging out. this table data is reflected onto this listview. but i want the listview to refresh itself as soon as the user has logged out. this way the admin doesn't have to keep pressing refresh.so i want to know if there is way to refresh the listview on database update.
View 2 RepliesI'm trying to refresh the datagrid after using the SQL UPDATE statement. The data changes physically in the database but the datagrid is not affected. The data is changed only after i restart the program.
How can i get the datagrid to refresh or update? I have tried using, among other code, the refresh() method, but it does not work.
how would i go about resetting or refreshing a table adapter before it fills a data grid view (load event). As i have tried a number of things to get it to refresh but it seems that the data connection to the Database is simply not closing and re- opening would i have to program it to be a manual thing to retrieve the data from the database or am i just not doing it right.
View 2 RepliesFor some reason my tab pages won't update their data when I change the data contained in them. I have to scroll to the next Company and then scroll back for the changes to be reflected in that particular tab. I have no clue why this is as when I walk through my code in debugging, it shows that the appropriate labels are being set the appropriate values. But if I have one of the tabs as the one in focus when I change my company, it is updated correctly.
View 2 RepliesI have a mdiChild which changes it's text (caption) when I click on a MenuItem. The Text changes as it should, but the mdiWindowListItem does not change. So I tried to refresh it and update it, but both commands didn't make any difference.
View 2 RepliesTo me it seems that Update, Refresh and Repaint all do the same job but there are no doubt rules about when to use which. I would be grateful for any enlightenment.
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've made a windows form in which I can change names in my databasetable 'stations'. To select which station to change I've used a databound ComboBox which gets all stations from the database table.
Now when I change the name of a station I want to get it immediatly updated in my combobox without restarting the application.
I have a windows form with a DataGridView control.I bound it into an attached DB file (.mdf).I perform insertion by generating a dynamic Insert statement. I then pump this sql statement into a SqlCommand object and perform ExecuteNonQuery() method. All of these is performed by handling a Button click event. The button and the gridview is located on the same form.
Public Sub InsertRow(ByVal param1 As String, ByVal param2 As String, ByVal param3 As String)
Dim strConn As String = (the connection string)
Dim sqlConn As New SqlConnection(strConn)
[code]....
After the code execution, the DataGridView is not updating (remains intact). I have to exit the form and reload it to have the updated gridview.For certain reasons, I can't use DataTable object.But I would like to have this gridview updated everytime I run the insertion.
I have an aspx page which is made of 3 user controls (ascx). I have an update panel wrapping the 3 user controls like this:
<asp:UpdatePanel ID="UpdatePanelWrapper" runat="server">
<ContentTemplate>
<uc1:UserControl1 ID="UserControl1" runat="server" />
[code].....
My listview clears and updates every 2seconds. Is there an easy to refresh the list information without clearing first? Like taskmanager
View 2 Repliesi have a dynamically created gridview button that fires off a modal popup when clicked. I do this onclientside like so:
function openModal(btnId, v) {
deptdata(v);
// __doPostBack('<%=DropDownList1.ClientID %>', '');
[code].....
I have several reports that all merge onto the same datatable. The user can click several to run and then hit the 'find records' button to run them all simultaneously. Since they each take so long, I'd like to update the user on the status bar as each of these stored procedures is called successfully. However, when I call the procedure, i only get one update at the very end listing evertyhing.
[Code]...
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 a datagrid view containing a customer list that if if double click on a row it brings up a customer maintenance window. Once I hit a save bottom on the second form how can I automatically update the database, refresh the grid on the initial window but remain on the same row on form1 that I double clicked on in the first place. Currently I am re-loading the datagrid on the initial form with all the data once I close the second window down.
View 6 RepliesI have written a Type Converter for a TrackBar. I was wondering if there is any way to get the value being changed in the Dropdown so I can update the PropertyGrid item value dynamically instead of just at the end?
Here is the Type Converter code:
Code:Imports System.Windows.Forms.Design
Public Class Slider
Private editorService As IWindowsFormsEditorService
Private m_Value As Integer
[Code]...
I have a validation Summary I am using for the RequiredFieldValidators to use to show the error messages while an image shows up next to the controls being validated.I have set the required field validator to Display="Dynamic". When I select something in the dropdown it removes the image next to the control right away like I want but the errormessage text stays on the ValidatorSummary.What can I do to make the ValidatorSummary to update dynamically like the RequiredFieldValidator when it removes the image next to the dropdown?
View 1 Repliesi have a pretty standard crystal report that shows a quote for materials for various customers - i also have a form, lets call it form1 for arguments sake - on form 1 i have two data grid views - one attaches to the customer table, one attaches to the quote table. Customer and quotes are linked on customer number at the database level.
i dragged and dropped these on to the form and they work great, as i scroll through each customer in the customer datagridview, that customer's respective quotes show up in the quotes datagridview.
now the problem - as a third tier, i have a crystalreportviewer that has all the nice graphics and presentation of this quote, company logo, etc etc, i've also done all the standard report sources etc etc, but the darn thing won't cycle through the quotes as i scroll through them in the quotes datagridview.
am i missing something simple? all i want to do is highlight "abc company", see their list of 50 different quotes pop up in the quotes datagrid view, then click a quote number and see the quote display in the fancy smanshy crystal report viewer so i can then print or export or whatever.
