I'm trying to figure out/learn how to overwrite previously saved data. Right now when I save data to my excel form and then reopen it, to edit, a duplicate row with the edited data is shown along with the previously saved data as well.
View 7 RepliesI need to work with a previously stored listbox. Example: You save a file and it comes in the listbox, I can click it and I see it in all my textboxes. And if I restart the program it's still in the list. The files can be anywhere on the computer, that's why I need this method. The name that need to be in the listbox is the name of the save file.
View 4 RepliesI would like the autocomplete list of a textbox to be the words that the user has previously typed and saved. For example if they enter "dog", "cat" and "fish" I want the autocomplete suggests to show these three options. So far my Code only shows the last user input. I expect there is an easy solution as I am new to all this, but I can't seem to find it on my own.
[Code]...
I'm having this weird problem with my windows application, I have fields for entering data into an underlying access database, my problem is after clicking the submit button upon entering the first data it shows neatly in the datagrid but subsequent data entered repeats what was initially entered into the datagrid.
Private Sub BtnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnSubmit.Click
'Sets Null Fields to 0
[Code].....
I have three dropdown list boxes and a gridview. The gridview shows data based on what is entered in the dropdown list boxes. I have added a button that allows the user to insert a record into the database and then the page refreshes. The problem is that when the page refreshes the gridview goes back to whatever was initially in the dropdown list boxes when I first brought up the page. Is there a way to refresh and maintain the data in the list boxes so the gridview shows the same data? My code is below.
[Code]...
This has been driving me insane all day and I think I have the problem narrowed down, but it just doesn't make sense how it could be happening. I have 2 public shared functions and 2 private shared functions. One provides a list of custom objects and one filters the objects based on some parameters in the function call. Both return List(of custom object). The 2 private shared functions are the predicate functions used in the List(of t).RemoveAll function.
[Code]...
Now, the next time I call the GetItemList function it only returns 50 item objects, not the 100 item objects that it should be returning due to the cache being set! I have verified this in the debugger and by running many, many different tests to see what combinations of parameters may be causing the problem. In my testing, as soon as one of the .RemoveAll functions is used the GetItemList item list will get set to whatever the NarrowItemList function returned.
Even if the cache wasn't being set correctly, shouldn't it just get the data again from the database and return 100 items again? What could I be missing???
I have a program that records time data in database when the user performs task. When I published the program for user install, I did not specify any update location. So, since initial creation, whenever I need to update the software, I simply install the new .exe file and this overwrites the old version and erases all data created by the old version (similar to uninstall and reinstall). Is there a way to only install updates to the software so that all data is not erased each time I need to update? Seems like this would be simple, but I can't figure out how to do it and am quite new to programming. I will eventually want to have the software check for updates online, but I need to understand how to update from a local file location first (without erasing current data).
View 3 RepliesI was wndering if its possible to change specific data in a text file from VB.NET code? i want to use a save game feature, and update the score of the user currently logged in, but i dont know how to do this. Any ideas? my text files stores 4 fields from the user; Username, Age, Score and Password.[url]...
View 3 RepliesI'm programming in VB, using Visual Studio 2008.
View 3 RepliesHow can I save an Excel-file, which I'd edit with VB.NE, to a file, which already exists? Evertime there is a dialog: File already exists. Do you really want to overwrite? YES|NO|Abort
How can I overwrite without this dialog?
What I am trying tot achieve is the following:User inputs data in one form that saves to the dataset table no problems. On an edit screen I want the current data saved to appear in this page within all the relevant fields but when saving I want this data to add to the dataset table as an additional line of data so the transaction records are kept.I want to add a new datarow regardless of it saving one change or all 7 changes that are possble.
e.g. Line 1 - user inputs 7 cells of data Line 2 - user amends 2 cells of data Line 3 - user amends 1 cell of data an so on. Unfortunately the terminology for certain items above may not be correct as I am still new to this programming and still on a massive learning curve.At the moment I do not have the code for what I am trying to achieve as I really dont know where to start with it.I am currently able to save the data and have it appear in the "edit" panel however only the cells changed are saved an it overwirtes the initial input.
[code]...
Using VB 2008 Express, I've constructed a simple database type app for saving contacts. The table data I save at design time is always saved correctly but data entered at run time seems to get saved even after closing the app and VB. However, after restarting the computer, the newly entered data is usually gone. Why would this be? I've seen a few video tutorials on creating simple database apps and did everything they did and am getting the same problem. I thought it was a configuration problem so I actually re-installed Windows and VB 2008 Express (as well as 2010 Beta 2). I have noticed that in the database explorer, the .mdf file has a red x to the bottom right of the yellow database icon and when I click the + it seems to turn into a black plug. Is this normal?
View 4 Repliescreating an application using VB 2010 Express. i found data I entered into table were not saved (after I clicked"Save" button)successfully into Microsoft access file which I had added successfully as datasource.These are the codes:
Private
Sub
SaveToolStripButton_Click(ByVal
[code]....
I have datagridview in which 2 & 3 rd columns are Combo Box. I have saved the data to the database from datagridview. But while retrive if i assign datatgridview.datasource= mydatatable.It addes new coulm show the values. for my combobox columns it shows the value member values. If change the datagridview.autogeneratecolumns =false
View 4 RepliesI am creating a simple button based rpg and was wondering if someone could help me with 3 things how to hold information within the game until the player save's the game, Saving the game, and Loading the game.I want the saved games to be saved onto a encryted file like .db or .dat file..
View 3 RepliesI have made several posts on here lately regarding master/detail or parent/child data setups but no one has been able to help. It seems like a subject people don't like to tackle BUT I really need help.
I'm having a real hard with the DataView.RowFilter functionality and it is driving me insane.
For the most part, I have the basic master/detail functionality working. When you select a record in the first grid, it shows the correct data in the second grid. When you enter a record in the first grid, you can enter related data in the second grid. I accomplish this by using a dataview and row filter bound to the 2nd grid. When you change the record in the first grid, the rowfilter for the 2nd grid is restated and reapplied.
The problem arises when I overwrite the primary field value in the first grid and the detail records become orphaned. You would think all I have to do is change the ID in the 2nd grid to match the new ID in the 1st grid but this is where I am having problems. I wrote a loop to change the ID of each record currently loaded in the 2nd grid to match the newly changed ID in the first grid. The code is here:
Code:
Dim I As Integer
For I = AuthorizationGroupsDGV.Rows.Count - 2 To 0 Step -1
AuthorizationGroupsDGV.Rows(I).Cells(0).Value = StrEmployeeID
Next
I have used this code before and it works great. It has to step backwards through the grid because when the ID's are changed, they no longer match the RowFilter criteria and they disappear from the grid. They still exist in the dataset. The problem is, while the code "works" the intended effect does not. Some of the records completely disappear from the dataset and do not reload when I restate the row filter against the new ID number.
Does any one know how to clear all saved autofill data of browser in Asp.Net
View 2 RepliesI have a simple Master/Detail program the database contains 2 tables and the form contanis 2 datagridview controls getting it's data from 2 bindingsource controls
I use this code to save data
Me.Validate()
Me.DataGridView1.EndEdit()
Me.DataGridView2.EndEdit()
[Code]....
my problem is when I enter a new record in the grid that belongs to the master table and enter a detail to that data the data of the new master record is saved but not it's detalis but when I enter new details for old master record the save is done well
how I can enter an new record for master table and enter a detail for it and save without loosing detail data
I have tried to test out the add delete and save function on a datagridview but the data that I added during testing would disappear after I made some changes to the code.
View 3 RepliesI have made a application that detects already saved hotkeys and data assigned to them, so now whenever I press the hotkey to send the assigned data to active window it does sends the data to active but it won't stop sending data...I am calling my function that reads data from the database in timer device and the function that detects the hotkey...
Here is my code
Private Sub Hot_Checker_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Hot_Checker.Tick
gKey.CheckBox()
'is the object that calls the function to check the pressed hotkey
keyTemp = gKey.getHkey()
[Code] .....
trying to find the main error that is causing this to happen, after pressing the hotkey my app won't stop sending the data to the active window. My app should wait for the next hotkey press rather than sending data.
I am a freshman by using vb and I had search several website to learn the method to display the previous saved data in a label but none of it is related to my problem.
View 1 RepliesHow data is saved DataGridView after shutdown By Settings in vb.net 2008.This is an example for ListBox.I want an example of DataGridView..[code]
View 3 RepliesI have form with combobox I have database contained 2 filed "ItemID" and "ItemName" The combobox fill her data from the database from field "ItemName" I do when I choose in the combobox any item and save, the data saved in database "ItemId" Not "ItemName" by define string put on it "itemId" when the user choose any item in combobox I need when I get the data that saved in database the combobox value="ItemName"
View 2 Repliescan you write me code of data storage?for example: I want to saved the data through textboxes when the program does not work.
View 2 RepliesI 'm trying to develop a database whereby all information input via vb 2008 will be saved into a microsoft access database. I've tried to populate a few information. The data was saved at that point, but when i reopen my system the next day, all the rows are gone. [code]
View 6 RepliesI am having a hard time figuring this out. It's about ExecuteNonQuery() method and sql server database. I done several testing and still getting the desired result which is data captured from application window and saved into sql server database table.
Some results i gotten from my testing:Query - Senario 1:From application window, data was captured into variable memory but didnt save into database and end up with blank database. (Tested many rounds still end up in this senario)Senario 2:Used the command console in the data explorer frame, with the insert query along with required value, an entry was made. (Test a couple of rounds and i know it worked)
ExecuteNonQuery() - Tested using if/else method as shown below and the result was pass that show the method is working. This testing method was found from this link: [URL]Below is my create Method(sentence with ' are comments):
Dim DatabaseConnection As String = My.Settings.QuotationDatabase [color="#00FF00"]'Connection to Database[/color]
Dim SqlConnection As New System.Data.SqlClient.SqlConnection(DatabaseConnection) [color="#00FF00"]'Linking Database Connection via SqlClient to Application[/color]
Dim Query As String = "Insert Into Clients2 (Title, Name, Email, Designation, ResidentialNumber, MobileNumber, CompanyName,
[code]....
well this is the code i have to save the data to the db, but it isnt giving any error nor the data is been saved
vb
Private Conn As OleDb.OleDbConnection
Private cmd As OleDb.OleDbCommand
[code].....
I'm using this code to update my access database.
[Code]...
If i run the program in debugmode and then do a update it will be saved to the database.(must stop and run again to see the update. How to se the update directly?)
My main problem is that if a build the program and run it outside VS then update never being saved. How can i solve this. I tried using "commit"(maybe totaly wrong) but that didnt work.
I currently save the data the user input into the textboxes like:
[SAVEACCOUNTDATA]ACCOUNT[/SAVEACCOUNTDATA]
[ACCOUNT0]Graham[/ACCOUNT0]
[ACCOUNT1]McCann[/ACCOUNT1]
[ACCOUNT2]graham23s@*********[/ACCOUNT2]
[ACCOUNT3]graham23s[/ACCOUNT3]
[ACCOUNT4]********[/ACCOUNT4]
when reading it back into the textboxes i was needing to chop off the surrounding parameters:
[]Just need this data[/]
Is there a way to just grab the data in between the brackets like an explode function of sorts?
I have store the variable in
Dim Lastname, Surname, Middlename, age As String
and the data are saved in notepad. how can I put them back in their exact label.one of my lable is
lbl_surname.Text