Erm I am still a freshman who still learning Visual Basic and I'm currently facing a problem regarding adding a new record and updating my database records in the form, or the whole project.
If MessageBox.Show("Do you want to save the data?", "", MessageBoxButtons.YesNo) = DialogResult.Yes Then
Me.ArtistsBindingSource.AddNew()
[code].....
I can retrieve records from my Database fine, but I'm having trouble updating records. I am getting a syntax error on [code] I get this error when I change the Last Name (Row 0, Column 1). [code]
View 4 RepliesAs part of the application I'm writing in Visual Basic, I have written code to display records in text boxes and cycle through each of them one record at a time. I'm having trouble getting the code I've written to update records to work however. I am new to this however, so I'm sure I've made an obviously glaring error that you more experienced people can point out for me:
Public Class frmRecords
' VARIABLES TO AID NAVIGATION THROUGH RECORDS
Dim moverow As Integer
[code]....
i have made a database windows forms application, i can add records, when i add a record , fill out a few fields then save it saves OK but if i then change some fields data then try to re-save i get a error: object reference not set to an instance of an object.
the code that is highlighted is:
Private Function GetRowData(ByVal custRow As calllogDataSet.CALLLOGRow,
ByVal RowVersion As Data.DataRowVersion) As String
Dim rowData As String = ""
[Code]....
All i'm tring to do is connect to my MysQL database on my Local host and update a record in my "customers" Table. The Error i've been getting is under Public Sub DeactivateAccount,the MyCommand.ExecuteNonQuery() line of the code. The error is saying there is "no database selected". Below is the code i have.
Imports MySql.Data.MySqlClient
Public Class FinalFailedPinNumberAttempt
Dim connectionstring As String = "Server=localhost;user id=root;Password=;
[Code].....
I want to use a progressbar to show that I'm retrieving the records from the database so that the user wont be confuse if the program is still running or not. Here's my code.
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
cs = "Initial Catalog = KRADB; Data Source = .; User id = lab; Password = 'clrscr2010'"
sqlcon = New SqlConnection(cs)
sqlcon.Open()
[code]....
I was trying to edit and update an existing record in my database. I am getting an error, my code is here:
Editing Records
Private Sub btnEdit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEdit.Click
Dim qry As String
[code]....
how to seek a record in access (.accdb) file and update.
i have posted a question in below thread how to work with (i mean connect to a access database)....
[URL]
I could able to navigate through records but, i want to seek a particular record and update accordingly.....
when i used find method i am getting an error as below
"Table doesn't have a primary key."
But my database has a primary key.
I have a form in which I am updating records to table Users in database China.accb. The btnClick sub successfully updates the Dataset. However, the actual table Users never gets the update. What am I doing wrong? The code is below.
[Code]...
I am trying to update a link table with values from multiple datagrids, the field types in the link table are numbers and the value selected from the datagrids are also numbers.
I am getting the following error:
The OleDbParameterCollection only accepts non-null OleDbParameter type objects, not String objects.
In line : cmdCompany.Parameters.Add("@COMPANY_ID")
[Code].....
I have ALWAYS used the SQLDataSource to update my records in my SQL Server 2005 database, so i am not really sure how this would be done in normal code. I am using VB.NET but if you are a C# developer and want to show me some code that is more than welcome as well.
I am using ASP.NET 3.5.My user will see a page with 5 Text boxes with their contact details in. Those details I will get from a SQL Server DB and when they go and change the text in the text box and click submit, it must then save the changes.
This is very easy with the SQLDataSource but how can i code this myself?
I am getting the attached error while updating or deleting the records. [code]...
View 9 RepliesI am trying to update a databse using a grid control, I've enetered multiple rows in the row and tried to save the data, unfortunately I'm only saving the last row entered, is there a way to save all the rows entered using this approach?
Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|aop29.mdb"
Dim objConnection As New OleDb.OleDbConnection(ConnectionString)
Dim sql As String = "Select * from Customer"
Dim daaop5 As New OleDb.OleDbDataAdapter(sql, objConnection)
Dim ds As New DataSet()
[Code] .....
I am trying to update a databse using a grid control, I've entered multiple rows in the row and tried to save the data, unfortunately I'm only saving the last row entered, is there a way to save all the rows entered using this approach?
Code:
Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/DataDirectory/aop29.mdb" Dim objConnection As New
[code]......
how to get records into oracle database delete from db & update the records i have successfully connected my vb 2008 win form with oracle 10g.
View 1 Repliesin my windows application i am retrieving the recently modified data from warehouse database server using static ip suppose two columns empno,designation from emp table in this i am retrieving the recently designation modified employees and in my local server database also i have emp table with all employee details which are in warehouse database now i have the designation modified emp details using this i want to update that designation details in the local emp table to that related employees only not all employees designation actually the records may be more than lakhs records some times i have to update 100 record some times thousands records if i am using loop it takes more time?
View 3 RepliesI know that when I add a record to a table through a binding source using a binding navigator - it completely handles the IDENTITY PK (it's bound to a textbox and you can see it immediately).
Now I'm trying to do this differently in another part of the program - here I only have a BINDING SOURCE - that's bound to a DATAGRIDVIEW.
I put a new record into the DGV like this
Private Sub vendorfilesDGV_DragDrop(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles vendorfilesDGV.DragDrop
If e.Data.GetDataPresent(DataFormats.FileDrop) Then
[Code]....
I am new to VB.net and want to know how I can execute SQL queries from within VB.net code. Example: I want to update some records in a table using SQL query on the Form Load event.
View 2 RepliesI'm writing a time entry program to record when an employee checks in and when they check out.I'm struggling on the part where I need to calculate a time span (time out / time in). I am selecting the In Time, Out Time, and Total columns.I want it to take the Out Time subtract it from the In Time and place that value in the Total column.I have so far and have tried several variations of different updates but have had no luck.[code]I keep getting a syntax error in the UPDATE statment.I'm not very fluent with OleDB yet and I'm not sure if I'm doing the update correctly.I have no problem with OleDB and single UPDATES or single field updates but when I am updating multiple rows with different values.
View 16 RepliesThere is something wrong with my codes. I don't know why it isn't updating the records.If I activated the line dt.Rows.Add(newrow) it will just create an error on da.update(dt) line QuoteThe changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.But if I deactivate that line, no errors will be occurred but the record won't update.
Here is my code
Dim dt As New DataTable
Dim ds As New DataSet
ds.Tables.Add(dt)
Dim da As New OleDbDataAdapter
[code]....
Whenever I try to update a row in my database, it works, but as soon as I restart the application, the changed information resets.[code]....
View 10 RepliesI have the following sql query that on debugging contains what looks like the right thing however the database is not being updated, but the code runs fine:
con.Open()
For i = 8 To ds.Tables("AddressBook").Columns.Count - 1 'Counts the amount of columns in the database
[Code]....
i am haveing problems updateing my customer details i was wondering if i could use the code i have for add and change it to update maby insted of useing the INSERT I could use a UPDATE or something anyway
Public Sub updateWithNewOrders(ByVal aOrder As Order)
Dim cmd4 As New OleDbCommand("INSERT INTO ORDER
(OrderID,CustomerID,OrderTotal,ODate,EmployeeId) VALUES (?, ?,?,?,?)", con)
[Code].....
I have an field which i have to update based on the selection of listbox.When i select listbox based on that when i update my fiels it should be updated
Dim cnstring As String
cnString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=AirLine.mdb"
Dim sqlQ As String = "SELECT NoofCoachseatsAvailable,NoofCoachSeatssold FROM FlightDetails WHERE flightname='" & s & "' "
'Create connection
[Code]...
Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information. Is my selection (Based on Listbox selection) is the wrong part here.
the problem is when I click the 'save button' and then exit. Then open again, the total records still unchanged
the code used
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Validate()
Supplier_s_informationBindingSource.EndEdit()
Supplier_s_informationTableAdapter.Update(Bookster_databaseDataSet1._Supplier_s_information)
End Sub
then I try to put Me.
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Validate()
Supplier_s_informationBindingSource.EndEdit()
Me.Supplier_s_informationTableAdapter.Update(Me.Bookster_databaseDataSet1._Supplier_s_information)
End Sub
I don't know if make a difference but how to update the database also, what code should I put?
Im using VB.NET 2005 i want to sum two records in database. So when i retreive them to display in my textbox they already sum. the numbers are in text.
this is my code.
con.Open()
cmd = New OleDbCommand("select * from ChargedItems where name ='" & Me.cmbfnameEarnings.Text & "'", con)
[Code]......
i have published my website...its a dynamic site..so i have database connectivity..now i want to make an application in VB to update my database using my application..i mean i do not want to login to the site and update my database rather update it using my application..i want to connect my application to the database of the published site and update it from anywhere i want using the application...is it possible??
How can i do it??Please point me to the right direction...its urgent.
I've seen similar problems posted on this and other boards, typically with a bunch of code checking before its realised that that database itself is being copied to another directory and run from there. Apparently this is managed via the database properties, copy to output directory settings. In my case I have tried all three options, with no change in result. After "saving", inspection of the actual database via the server explorer shows no changes have actually been committed.
I am getting to a point where I need to start entering large amounts of data into the app and have at actually save to the db for deeper testing.
I noticed this behavious first when using an .accdb and it has persisted through my exploration of SQL(.mdf)
db Output Option Selected / Result
always copy... data changes do not persist between debug runs and is not entered into actual database
copy if newer... data changes do persist between debug runs but is not entered into actual database (checked via server explorer)
Do Not Copy... generates the below Error on execution
System.Data.SqlClient.SqlException was unhandled
Message=An attempt to attach an auto-named database for file C:UsersXXXDesktopVisual Basic ProjectsSQLtestWindowsApplication4 - CopyWindowsApplication4inDebugMyDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I am a newbee to the programming. So please guide me if i am wrong. up to binding of the datasource my programe working perfect but during save button it gives error.(Value can not be null. Parameter name : daatTable)
[Code]...
I'm having a database, using GridView I retrieve the data into my WEB application.Then I set the rows to editable (not sure if it is fully completed) and when I edit some cells I want to update the GridView AND the database behind.When I click on 'edit' then the button is changed to update. I get some unhandled exception. I don't expect anything else since I didn't put any code in the update methods like RowCommand, RowUpdating, RowUpdated, RowDataBound.
View 4 Replies