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 had this - in the CURRENTCHANGED event of my BINDING SOURCE.
Private Sub vendorBS_CurrentChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles vendorBS.CurrentChanged
If Me.CMCStarting Then Exit Sub
vendorBAL_C.vendorUpdate()
End Sub
This calls a sub in the class vendorBAL_C that does this
Private Sub SaveData()
_adapter.Update(_vendortable)
[code]....
The vendorUpdate sub calls two .Update's on my SQL Data Adapter.Only the first one is getting saved._vendortable gets saved - changes to _vendorcapabilitiestable does not.Those two DATATABLES are getting created by
_adapter.Fill(_vendorSet)
_vendortable = _vendorSet.Tables(0)
_vendorcapabilitiestable = _vendorSet.Tables(1)
To add just a tad complexity to all this I'm making changes to _vendorcapabilitiestable through a filtered binding source in the UI.
capabiltiesBS.DataSource = vendorBAL_C.capabilitiesTable
.
.
.
Private Sub CapabiltiesTreeView_AfterSelect(ByVal sender As Object, ByVal e As System.Windows.Forms.TreeViewEventArgs) Handles
[code]....
I tried calling .EndEdit's on my binding source - no change.Changes to the second table are not being saved.
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]...
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 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
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 Repliesi 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 DataTable that's constantly being updated with new data from my database via a timer. That data is eventually reformatted and displayed in a DataGridView control.In an effort to prevent the DataGridView from completely refreshing from re-databinding (thus, clearing out selections, resetting scrollbars, defaulting sorting settings, and making the gridview flash as it reupdates), I'm simply removing old rows from the datagrid that no longer exist in the DataTable, and adding new rows to the datagrid that appear in the DataTable since the last update.
For the sake of simplicity, we'll call DataGridView the LEFT table, and DataTable the RIGHT table I'm looking for a way to go through both tables (LEFT and RIGHT), and remove old rows that are no longer in RIGHT and delete them from LEFT. And look for new items in RIGHT and add them to LEFT. Each table has a column called "RecID" containing a unique id for each entry that can be used for comparison. is there a way to do this all in one loop? What I'm looking for, in pseudo code:
<loop through everything>
if RecID does not exist in LEFT but exists in RIGHT
add new item to LEFT
if RecID does exist in LEFT but does not exist in RIGHT
[code]....
currently i had a program which working fine when its running in the solution explorer,but after published,problem comes.my datagridview cant show updated data while my database access already update...my datagridview only show existed data.could it be my datagrid problem?i get my data programmatically or is my INSERT command doesn't update the dataset?but in the solution explorer does show the dataset was updated. [code]
View 3 RepliesI have an Access database that is updated directly in Access. I'm trying to write a program to 'monitor' the database, and have a DataGridView control showing the contents. When the program is first started, it shows the current data in the DB fine, however, I've been unable to get it to refresh with any updated data from the mdb file. I have a timer running on 5 second intervals, and if i clear the dataset, the DataGridView refreshes to empty.
[Code]...
I am getting an incorrect repsonse after an update to a table. In my RowUpdating event I have the following code which builds an Update Parameter to call an SP to update a table. I must be doing something wrong but everything runs fine. My rowsAffected variable reports 1 after the update, but the table never gets the data.[code]I found a solution that is working. On the original DataSource for the update command I needed to add the following.[code]This in essence allows the original data source to call the SP. Note: that the command type needs to stay as TEXT not Stored Procedure as one might think.
View 3 RepliesI want to work on a project I have in mind and this envolves saving data which would need to be updated every time the user exits the program. I suppose I need to know how to save a file to a blank text document, and how to get the application to read the information when it is called for. I believe I need to set delimiters or such, the helpfile is useful, but limited and some information is not listed at all.
View 7 Repliessince I still use VB6 and the code is in VB8, I can't find the solution.The sub below is executed in a button's click event, and is supposed to save data to his database. It seems to work fine : you can add persons (in a separate form), and see them appear in the datagrid. You can stop the program, go back to the VB editor, and run it again (without rebuild), and the previously added persons will still be visible in the datagrid. But...If you add some persons, then go to the editor and force a rebuild (for example by adding more code), and than run the code again, the the previously added persons are gone (nomore visible in datagrid)!To me, it seems that the problem is to effectively update the database. I have searched on the internet about this topic, and I read that you must "set" the UpdateCommand.
[Code]....
I load a DataGridView (VB.Net, VS2005) using the code below. The save logic works fine for manual edits oh the cells.However, I run some code that updates a Status column in every row then I call the same Save logic. All rows execpt the first row are updated! I am updating the Datasource (dvCerts)Ah.... I just tried changing the CurrentCell to 1,0 instead of 0,0 and now the data saves OK.
Load_...
daCerts.SelectCommand = New SqlCommand("SELECT * FROM PERP_ARB_Certificates", conPERP)
Dim cmdBldr As New SqlCommandBuilder(daCerts) ' used for grid save
[code].....
as os are being updated does windows updates the api also ?is yes what are the new windows api provided by microsoft and their documentation for windows 7
View 6 RepliesI have a picturebox that is supposed to grab an image from the clipboard, which contains the latest image captured from a webcam. Portion of the codes are as follows:[code]...
View 8 Replies[Code]...
The table is not getting updated.
I'm trying to write my first application which connects to an Access db. It took me hours to understand this, but I figured out that, if during the creation of the connection I chose to copy the mdb file in my project directory (VB asks this), I get that the database is not updated. Everything works, except the save button which saves new rows in the db. If I answer no, and the original mdb file is used, the database is correctly updated as expected. Is there a reason for this? Why is this happening? Shouldn't the database bu updated anyway?
View 2 Repliesi'm having a gridview which is binded to a dataview, OnPageLoad i'm populating gridview records. and i have a textbox and a button, So now i want to add more Records to GridView but this records should not be get added into DB, they just added to the page and of course the default records which are coming from db stay.
<asp:GridView id="gvItems" runat="server">
<Columns>
<asp:TemplateField HeaderText="Item Code" SortExpression="ItemCode">[code]....
Basically at first Data From DB comes to page then after that Textbox data should get appended to the Gridview but Db should not get updated. i tried to do it by keeping DataView in ViewState or Session variable but later i came to know am going in a wrong way and that this won't work since Dataview can't be Serialized. i just need an idea or right path to do this, is this possible what am doing? [my alternative option ]: create a temp db table and save it... but i don't want to use this option..
i implemented a RSS for big company on loacal area network attached with sql database to feed internal news.everything working fine.but i faced a small problem when the database changed the RSS doesn't take the update unless the user close the RSS and start it again.how can autorefresh the rss without closing it when the database changed.
View 1 RepliesIn my inventory mobile application , i use RDA.using the mobile device ,i update only the Barcode of a particular Item which is in the Item Master(.sdf file). then I push the tables to the SQL Server.there is a web application handles all the other functionality , including Item Master Changes.for and eg.
(1) I pull the Item master to the Mobile Device.
(2)change the Item Name from the Web application.(NOT FROM DEVICE)
(3)Update Bar code from the Device
(4)push table from mobile Device to SQL Server.
In this situation Old Item Name is replaced.My need is only to update the Barcode.
Using this code i cannot insert data in the database . it gives no error but no row is created in the data base
Imports System.Data.SqlClient Publi ClassForm1 SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=
[code].....
Ive never done a database before and i found this in one of my books... I think it should work. The part of the program that is in bold is the issue i get an error that says "Update unable to find TableMapping['Table'] or DataTable 'Table'." From the da.Update(ds).. ive been trying to figure this out for hours!
Public Class retailForm
Dim tempPrice As Double
Dim dbProvider As String
[code].....