I had a previous thread about Undo/Redo, but couldn't find it. Anyway, to the point:I use the following code to save and load the states of a RichTextBox control:
Public Structure FieldState
Sub New(ByVal control As RichTextBox)
Me.SelectionStart = control.SelectionStart
[code].....
Having problem in updating an existing record. An error occurs "Data Type Mismatch in Criteria Expression"
Private Sub ToolStripButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolStripButton1.Click
Dim myBuilder As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(dataAdapter)
[code].....
I have a webpage with a form that is used to edit some object. This object contains a Collection of other objects defined like this: Public Overridable Property Employees As List(Of Employee)
On a form I can delete an employee, add a new one or modify existing one. When I click save new values are sent to the server. On a server I check if the user exists. If exists then I modify its values, if it does not exist then I add it. All employees that exist on the server and were not sent are marked as deleted (State changed to EntityState.Deleted). I try to use the following code (dbCollection = database entities, newCollection = collection sent from the form):
[Code]...
This code does not work, because changing to EntityState.Deleted removes the object from collection, and for each loop breaks, since the collection is modified...I know that I can overcome this problem by using a for loop or adding objects to delete to some other list first, but I hope maybe there is a pattern that would make my code nicer.
I have spent several hours trying to delete a row and insert a row into an Access database using the OLEDBDataadapter and dataSets without any success. I don't get any errors it just doesn't update the datatable. Here is the last version of the code I have been trying to get to work. I have done a lot of searching and have
Data save
Private Sub SaveNumDte(ByVal ltoNum As String, ByVal ltoDate As Date)
Dim numTotal, x, MaxRows As Integer
[code].....
how to update the data of an SQL server 2008 express using vb.net 2008? My raw data actually from excel file only and i want to transfer all the data and merge it in my newly installed SQL server 2008.Normally im updating it daily that is why i want to create code.
View 6 RepliesI have made an updater program which updates several files used by another application (again made by me). It works great. But when it comes to updating the updater itself I was in a dilemma.My updater program can download a file from the server but because it is running it can't update itself. I wanna know what would be the best way for the updater to update itself.
I thought after the updater downloads its own new executable i would run a .bat file which would remove the old updater and rename the newly downloaded exe. But again as the updater runs the .bat file and shut down itself, there could be a violation.How can updater update itself in the best way ? (just need a way for updater to get a new exe and get it replaced)
Note: Updater is a single exe application made in .net 3.5. It updater another application by downloading and replacing files.
I am trying to get information into a database from VB 2008. I have an established connection and have pulled fields onto my form. I am able to see data already in the database on the form. Originally, I tried to use an Update button to send the data from the dataset to the database. This did not work. I then added a Save button to the Navigator on my form in hopes this would do it. This too, failed.
View 10 RepliesHaving a problem with my update code for a button to update the password :
[code]...
I have a windows app that I have published to a file server. Users are able to install the app from this location but when I publish updates to the same location (new version), they are not able to get the updates. I have it setup to check for updates before starting. On my computer (development) I can install the app from the file server and receive the updates.
View 3 RepliesI am trying to run an update query that I created in Access thru VB.
View 15 RepliesI have a working data grid on my form which pulls the courses the logged in user has signed up for from my database.
[Code]...
However, i can't figure out how to do this:When a new course is added to the database, i need the data grid to 'refresh' or 'update', which will mean that the new course will show up in the grid automatically.
Currently, users have to restart the application in order for the new course to appear in the data grid.
I have a form which has bound textboxes from 2 tableadapters allowing me to use:
me.datatableTableAdapter.fill(dataset.datatable)
so I assumed that I could use:
Try
[code].....
Right so I have my piece of software, it's complete (for now) and I want to get the final version of it and send it away. Once sent away the only way I'll be able to update it will be via a DVD or maybe if they download the update online.This is what I wanna know: I am just using the .exe file from the Debug folder, is this the right way? Do I need to compile it first and do a proper saving of the .exe file?Is there a way to specifically do the updating of the .exe file that is somewhere else? At the moment my thoughts would be to just copy the .exe file from the debug folder and wack it on a disk with a bat file that xcopys it. Is that considered the right way to do it?
View 1 RepliesI have two forms:frmMain - Allows user to pick process or combination of processes they want to runfrmProcess - Shows progress of their selectionI have three modules. Each runs a specific process.The frmMain allows the user to run any one of the three modules individually or all together in a single process (basically, runs the one after the other until done).
View 7 RepliesI have a MainForm that loads a number of files and SplashScreen that is shown while the loading takes place. SplashScreen contains SplashProgressBar that I want to update as loading of the files in the MainForm goes on. I declared SplashProgressBar Public in the SplashScreen and coded a mutator for ProgressBar:
[Code]...
I am bit baffeled by this one but I am guessing its security reasons why its not working but just wanted to check. I have two applications installed, 1 Is a 3rd party app which uses an msi to install/uninstall and the 2nd is my windows service app and the point of my app is to act as an automatic updater for the 3rd party app.
[Code]...
I'm populating a DGV from a DataSet... all done by code. I have the properties set to allow editing, etc. However, when I make changes to a record, they're not updating back to the Database. I suppose my assumption that by setting the properties to allow editing would automatically write the changes back to the database were wrong. Do I have to write update, delete, etc. commands?
View 3 RepliesIv created a Stock Market program and i need it to automatically download the new prices from the web on a daily basis.
It will be downloading the info from my own website - what server software should i use to manage this - simple machines forum ?? A mysql db will be on the server - how is it best way to get this whole system working ?
i was playing around with the visual basic 2008's project settings. I have 2 goals in mind
[Code]....
I have a datagrid that is loaded from a data source called ManualKanbanDataSet. The Access DB is ManualKanban, the table is "Parts". I've set the column properties of the column I want to change to readonly=false.
I make changes to the data in the datagrid, click my update button and nothing updates. here is the update
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Try
Me.Validate()
[code].....
I'm using a SQL Express 64 database on a separate server virtual machine. I've been developing my app for some time now in VS2008 on XP SP3. Using .Net 3.5 I've just come across a strange problem. If I update a checkbox from unchecked (the default) to checked, it saves OK. If I click to uncheck it, the change does not get saved. I'm using the UpdateAll method. I tried a single Update command as well, just for that table, but it was the same.
[Code]...
I have a datagridview where i add rows using array like this:
Dim srow() As String = {getIDprodus(cmbprodus.Text), cmbprodus.Text, getprodusforma(cmbprodus.Text), txtcantitate.Text}
griddetalii.Rows.Add(srow)
Next, i need to let user to modify the added row. So when user selects a row and press EDIT, a new form is popped out using this code:
Dim i = griddetalii.CurrentRow.Index
frmdetaliiiesire.cmbprodus.Text = griddetalii.Item(0, i).Value
frmdetaliiiesire.txtcantitate.Text = griddetalii.Item(1, i).Value
[Code]....
In textbox1 i have put the index of the current row selected in grid The problem is when i push OK, the applications crashes and i receive an error: INDEX WAS OUT OF RANGE
If the users changes the values from the same form, it's works. But changing them from another form crashes the applications
I'm trying to learn t-sql and my reading material all say to update all the rows at once instead of processing row by row. How would I go about doing that if I'm using object data source? I can see how I would do it if I'm using a dataset/datatable, but if I'm using a List(of object) as my data source for a datagridview, how would I update all the rows in one go?
For example, let's say
Business layer - I have a Person class with generic properties (name, age, gender, occupation, etc.)
Database layer - I have a method that retreive all the rows in my Person table, and return it as a List(Of person) to be used as the data source for my grid view.
I make a bunch of changes that affects multiple records, and instead of having a button on each row in my datagrid that update that specific row, I want an "Update" button that update all the records.
I can do this with a for loop, but I was just curious if an arraylist can be updated using a for each loop. ie
For Each arrItem As String In myArrayList
arrItem = "My Stuff"
Next
If I loop through the arraylist again the values remain unchanged.
i am working on a project that stores records from a windows form to an access datbase.But i am having problems with the update statement.I have a form with the fields bound to datatable called LeedsHubInfo .Dataset called LeedHubInfoDataSet1.
Private Sub cmd_save_Click(ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles cmd_save.Click
' Create a new row.
Dim newJobRow As leedHubInfoDataSet1.LeedsHubInfoRow
newJobRow = Me.LeedHubInfoDataSet1.LeedsHubInfo.NewLeedsHubInfoRow()
[code]....
On the update line i get an exception thrown up "A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll" I thought inserting a record into a database would be easy but i seem to be naking a right pigs ear of it?
I am trying to make changes to parts of an Access table but can not get the database values to change.I am able to get the datasets and things in VS to change, but the database never shows the changes.
I Have:
' Create an instance for the payrolltable
Dim dt As New MsPeachDataSet.PayrollDataTable
[code]......
I'm running some tasks on a BackgroundWorker thread and needed to display the current tasks in a label.Before adding the label, the tasks were completing just fine and the UI was responsive.Once I added the labels, the UI has become unresponsive. The issue, I believe, is the Invoke property.I've declared all my tasks, including the updating, in a sub and am getting the Invoke property of the label each time, in order to set the information.The following is an example of what I'm doing:
VB.NET
Private Sub Test()If lblTask.InvokeRequired = True Then Dim mi As New MethodInvoker(AddressOf Test) lblTask.Invoke(mi)
[code]....
I have a class which I'm binding to a series of textboxes, date pickers and so on. When I change text in the text boxes, the object updates just fine, and when I then save the data, it has the changes. My problem seems to be with the RTB ... if I bind to the .Text property, it works just fine and updates like any normal text box. However... when I bind to the RTF property... changes to the object don't happen unless I first click out of the RTB... quite annoying. If I edit the text or change the formatting, and hit the save button, the changes don't get reflected in my object. I've even tried using debug statements to track when the property is changed, and I'm not getting the results I desire.
View 7 Repliesi m having problem while updating my database... In this code when i delete records then it will deleted but it can't show updated data..for viewing new updated data i hav to again open the form ... so is there any code which i miss??? to update database @ runtime??
[Code]...
I have this code in a timer:
[Code]...