I'm trying to get the Affected Records but it always give me -1Here is my code:
cmd.CommandText = "SELECT * FROM persons"
Dim lrd As SqlDataReader = cmd.ExecuteReader()
MessageBox.Show(lrd.RecordsAffected)
[code].....
i have this delete code
My search
Public Sub mnamesearchdata()
'search data
Dim blnfound As Boolean
blnfound = False
[code]....
My Database In case. Having weird issues also were my database will be wiped out. Having 0 record.
[URL]
I've got a simple mdb database set up in Visual Basic Express Edition (winforms) and I'm trying to update data from a datagridview to a database. I've databinded the textboxes to the columns I want in the datagridview and this works great. After some struggling, I've finally managed to have the values updated in every row of the database. But, trying to modify a newly created record throws this error:
"Concurrency violation: the UpdateCommand affected 0 of the expected 1 records"
I mean, it seems as though the error only happens with newly created rows. Because closing the application and reopening it immediatly, I'm allowed to update the values of the cells.
I also noticed that the ID of the row is set to "-1" when I've just created a new row. The other rows don't have a negative number for ID. Could this be the cause? Seems as though the row isn't really updated to the database.
So this is the code for the AddRow button
Dim newRow As MusicDBDataSet.SongsRow
newRow = MusicDBDataSet.Songs.NewSongsRow()
newRow.Name = txtBoxNewName.Text
newRow.Genre = txtBoxNewGenre.Text
newRow.Rhytm = txtBoxNewRhytm.Text
[Code] .....
But thinking about it, the textboxes used to update the values of the newly created row are databinded to the database or tableadapter itself right? Could it be that the UpdateCommand fails because the row hasn't really been created properly yet?
I have created an application which ticks and unticks a routing sequence. But whenever I click on my save button after tickin the required, I get an exception thrown at me stating "Concurrency violation: the UpdateCommand affected 0 of the expected 1 records". My code is as follows:Private Sub OKButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OKButton.Click
'Displaying the rows in the dataGridView.Me.myadapter.SelectCommand.CommandText = "SELECT dbo.WR010130.RTSEQNUM_I, " _& "RTSEQDES_I, SCHEDULESTARTDATE_I, DONECB_I, " _& "CLOSEDBY_I, DATECLOSED_I, TIMECLOSED_I, SCHEDULESTARTDATE_I, WCID_I " _& "FROM dbo.WR010130 JOIN WO010032 ON dbo.WR010130.MANUFACTUREORDER_I = dbo.WO010032.MANUFACTUREORDER_I " _& "WHERE dbo.WR010130.MANUFACTUREORDER_I = '" & MoNoComboBox.Text & "' AND (dbo.WO010032.MANUFACTUREORDERST_I = 3 OR dbo.WO010032.MANUFACTUREORDERST_I = 7)"
[Code]...
When I run the following code I get the error "Concurrency violation: the DeleteCommand affected 0 of the expected 1 records.", I know that this happens when the data is changed in between pulling it from the database and sending it back but, the database is not being edited.
View 6 RepliesNone of the "answers" that I have been able to find, address the problem. I am using oledb to read and update a MS Access DB in an ASP.NET application.I read the member dataset and fill it using the data adapter.I modify the row of data in the dataset.I then use the data adapter to update the row and get the error shown in the subject.
I am an experienced developer using ado.net on sql server windows application via the data adapter, so am familiar with how this should work.
I have searched everywhere and am hoping that someone here at Microsoft might have the answer.
I keep getting the above error when trying to update a record from a SQL Server DB TableWhat exactly does this Error Message mean?
View 3 RepliesMy client recently got this error but I can't reproduce it on my pc. Any Idea what the problem could be. I have a master/detail scenario. So I have a grandparent/parent relationship, so when I select a product from my product combobox it displays the relevant results from the Result_Header table in my first datagridview.
Then I have a parent/child relationship so that when I select a result_header item from my first datagridview it displays the child records from the Result_detail table. If i'm adding a new Result_Header and then click save, I search for existing tests for the chosen product and insert them as new datarows into the Result_detail table. then I can update the child rows and click the second save button and it saves what I edit. Quite complicated.
Dim data As DataSet
Private dbpath As String = My.Settings.dbpath
Private con As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;" _
& "Data Source=" & dbpath & ";Persist Security Info=False;")
[code]....
I am working on a program whereby insert, update and delete of database is required, i have been able to do so successfully but the above error occurs when i tried to insert a new row of data into the database and tried to edit it and update it to the database. The database platform i used is SQL server 2005 and i am using datagridview to display my data, my primary key is "s/n" which is an auto number, however, whenever after i insert data into the database, the newly added row has the "s/n" column blank shown in the datagridview and after i edited that row and tried to update it, the error occurs.
Imports System.Data
Imports System.Data.SqlClient
Imports System.Threading
Imports System.Text.RegularExpressions
[code]....
[Code]...
I have been looking at the ADO tutorial on this site and am trying to apply it to my own DB. When I run the code above I get this error Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.
I'm trying to update a Access database. I'm new to this and I've reviewed an Ado tutorial early today. I'm trying to apply what is taught but I'm getting an error message and I can't seem to get passed it.
In my code I have an Add, Update, and Delete process. The Add and Delete processes work just fine. It is only when I go to update the database that I get the following message."Concurrency violation: the UpdateCommand affected 0 of the expected 1 records."
[Code]...
I have a database with 3 tables: Student, Unavailability and Duty.The fields for Student are entered in a form I have. One of the fields in Unavailability is filled by a form, the other fields are an autonumber and a foreign key to the Student table.ow I want records in the Duty table to be created and automatically filled in depending on what the values of the fields are in the Student table.For example, If the Boarder field in the Student table is 'yes' then I want the Duty Number field in the Duty table to be '1', '3' and '4'. If it is 'no' then I want the value to be '2' and '5'. I recognize it will have to create several different records to incorporate the different duty numbers for each StudentID. Obviously this will require an if statement, however this is my first time implementing a database with my limited experience with programming and Visual Basic, so I don't know how to refer to the specific fields in a table and set the value of other fields depending on the data in other fields.
View 6 RepliesThis code used to work but for some reason it doesn't anymore. I get the error "Concurrency violation: the DeleteCommand affected 0 of the expected 1 records." I checked to see if the values were in the db and they were, by the way I'm using Access 03. I commented out the try/catch block and got the error when trying to update the ds.
[Code]...
im using a sqldataadapter, dataset and bindingsource to connect to a table. i retrieve all records from the database and i change the data on a field then update changes to database. when i try to change back to original value i get a Concurrency violation error (concurrency violation: The updatecommand affected 0 of the expected 1). this is the
Try
Me.Validate()
Me.sqlBindingSource.EndEdit()
Dim slqCmdBuilder As New SqlCommandBuilder(sqlAdapter)
[Code].....
Basically I'm retrieving all the data in my program through runtime, I was wondering how will I retrieve the number of rows affected after an update so I could prompt the user about it through VB.NET
What I'm actually doing is, after an update, if there are no other rows updated then the user can no longer click on the button
I created a VB application in VS2010 using Win7 x64 that performs numerous integer type calculations and displays various results to the user. I have discovered that users running Windows with a different language pack than I developed the App in have problems with how some numbers are displayed and with some of the calculations. Can someone point me to suggestions I can take to ensure the calculations work and numbers display properly regardless of the Windows UI language of the user?
View 3 Replieshow do i set my vb2008 form in such away that the form size aint affected by screen resolution settings
View 3 RepliesHow can i search a database with multiple search criteria. e.g. search where ata=26/11/2001;department=Security;Payment Type=Expense.I would also like to display this data in datagridview when i click on search button. Or if possible, using crystal reports to view the result so that it can be printed
View 18 RepliesI have come up with this 2 methods of reading all records on a database table. Both work nice but I would like your expert opinion on which delivers best performance and why.We are reading table "DATA" and filling an array called lstData with the contents of the "Data" field.
1) Method one is using the bindingsourse to go through all the records.
[code]...
My guess is that the first method, while simpler to the eye could use more overhead. What I really would like to know is if the second method really delivers better performance and if it is worth doing all the manual SQL queries.
I am making a program that takes Access records and moves them into MySQL then checks to be sure everything is right and deletes the moved records. But, for some reason my delete command isnt working....
Here is the
Dim deleteCommandF As New OleDbCommand
Dim deleteCommandE As New OleDbCommand
Dim deleteCommandO As New OleDbCommand
[code]....
Running the program now to get the exact error message, shouldnt be more than 5 minutes and I'll post it.It says my paremeters are wrong? deleteCommandE.ExecuteNonQuery()
I am using VS 2010 and Access 2010 and in a table I have a Primary Key called Counter which is an Autonumber.When I save a record I need to be able to access the value of the counter field for the new record. When I try and access the field I get a value of zero.I can see the value in Access but I cannot set it in Vb.Net. I have set the fields and then
[Code]...
adding the records to Access table which has been entered in the form in vs2010.
When the user fills in the forms the data should be saved in Access table.For eg if the user enters name,age,address in form the same should be saved in access table which has name,age,address fields.
I am new to this forum and I state that I am a beginner in visual basic. I need help with a program I'm doing for personal use. I have an Access database connected via wizard to visual basic 2010, from wizards automatically as I dataset and TableAdapter bindingsouce, a datagrid on the form and text, and buttons for various rescues etc.. My problem is that I need to do a count of duplicate data, I have a table Inserimento_veicoli (Ex. count model vehicles like the Fiat Punto) and I managed to find the right code
[Code]....
I am displaying Access database records on my form and need to be able to printpreview only the first 3 records of the database and have no idea how to code this at all. Also the printpreview is has to be on a separate form than the displayed records.
View 1 RepliesI know this is basic, but my mind is totally blanc. I'm trying to retrieve all records from a table with a specific code.
Dim cmd As New MySqlCommand("SELECT myValueRow FROM myTable WHERE searchRow = 'test'", myconnection)
myreader = cm.executereader
[Code]...
Using Microsoft SQL Server I connect to tblTransactions. Within there is transDate. I have a from and to date selecter tool in vb.net. In my select statement how do set it to select only records greater than datefrom but less than dateto...?
I tried SELECT * from tblTransactions where date >- ...
how to connect to databse from vb and insert records ?
View 4 RepliesI have a database (SQL Server 2008) with multiple tables and records. 1 Table contains all kinds of invoice items, which have a unique id, Client ID and invoice number.
My goals is as following:
- I want to show the invoice items in an datagrid, all merged as 1 invoice item (showing date, total without VAT, total with VAT, VAT percentage, VAT value and if the invoice has been paid or not.)
- The datagrid should only contain the invoices for a specific client.
- Should add up totals (Amount paid, Amount not paid, Amount Overdue, Total Amount)
- Should be withing specific date range.
Everything in this table has been saved as varchar except invoice id and unique.
I have records in my datagridview (from database(ms sql server 2008 r2)). What i want to do is to insert the records selected by my datagridview checkboxcolumn and IF POSSIBLE automatically delete a record if the records to be inserted are equal to the records inside the database. (Hoping you got what I want to say.) For example. I have an A,B,C(child) that is under XXX(parent) in my database and I'll be inserting the A,B(child) again but it will be under YYY(parent). The old record in XXX will be deleted except C. I just want a possible DELETE STATEMENT These are what I've done so Far :
Insertion of record to database
Try
connectionString = "Data Source=***;"
sql_connection = New SqlConnection(connectionString)
[code].....
I have a program that backs-up remote locations to a centralized FTP server. Upon successful completion, a record is written to a SQL database with the following information:
GUID (uniqueidentifier)
StoreID (varchar(5))
DateStamp (sqldatetime)
ProgramAndVersion(varchar(50))
I am currently managing the program by running a report on who has written a record to the database. If the record is not written, I manually go in and backup the necessary files.The problem with this, is that it can take up to 30 minutes/day to do this task. While that's not a long time, it's getting somebody to be dedicated when I'm off and that has proven to be difficult.
I want the program to automatically search for missing records, but I'm not sure how to do this. I was thinking about bringing in the last 30 days with a SELECT statement and then comparing the information that I have in the SQL database versus a calendar control (or something). I need to make this process completely automated and not very intensive on the SQL server. I only have the following
2010
Sub FindMissingBackups(ByVal DaysToCheck As Integer, ByVal StoreNumber As String)
Dim TodaysDate As SqlDateTime = Now()
Dim PastDate As SqlDateTime = DateAdd(DateInterval.Day, -DaysToCheck, Now())
[code]....