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 Replies
As 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]....
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].....
Here is what I'm working with:
Dim connstr = "data source=mydatasource;initial catalog=gcs_dw;persist security info=True;user id=myuser;password=mypassword;Asynchronous Processing=True"
Dim sqlquery = "SELECT * FROM Customer WHERE CITY = 'Anytown'"
Dim connection As SqlConnection = New SqlConnection(connstr)
connection.Open()
[Code] .....
As you can see, I'm attempting to display the results of the query to the commandline and currently all it is displaying is "System.Data.SqlClient.SqlDataReader". Where are the results of my sql query going and why can't I retrieve them?
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]....
I tried using the following codes but it's not working,
Dim Con As oledbconnection = new oledbconnection()
con.connectionstring = "Provider = Microsof.jet.OLEDB.4.0; Source=c:\program file\database.mdb"
dim sqlcmd as oledbcommand = new system.data.oledb.oledbcommand()
sqlcmd.commandtype=commandtype.storedprocedure
sqlcmd.commandtext = "query"
[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]...
So I've been playing around with SQL strings in VB 2008, and trying to retrieve records from a database and display them in a data grid view. This is the part of the code that gets the fields and displays them in the data grid view:
[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 RepliesI'm using vb.net. Usually I used the SQL Server SQLComamnd but here I need to use an ADO. I have this but I'm stuck at the end of it how to get the data? [code] How do I actually retrieve this record?Is there something akin to the SQLCommand that has Reader?
View 1 RepliesI wish to retrieve all records for a particular day. The user can choose a date from a calendar and once click on ENTER,all the records for that day will be display out. I am able to choose the date using MonthCalendar and display it onto a label. But the sql statement of displaying it onto a datagridview shows no result.
This is my sql statement:
HTML
MyCommand = New OleDbCommand("SELECT * FROM cable WHERE 'Date_Time' = "& Label6.Text,MyConnection)
My records in MS Access is in this format:
mm/dd/yyyy xx:xx:xx AM/PM
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 would like to do like this...When I click a button, it will capture the times the button had been click retrieve 10 records at one time...For example, when the button being click for first time, it will retrieve the first 10 records and put into 10 textbox. Then if the the button being click for second time, it will retrieve the records from 11 to 20 and put into 10 textbox and so on. I had the following codes:
[Code]....
Okay, So I am trying to get my vb.NET Application to retrieve all the data in the database. My connection to mySQL is working and i have been able to fill a DataGrid with data from the database a function[code]...
View 13 RepliesI 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]......
theyI had a asp.net (vb) web application to store work overtime (OT) records. In SQL server, the OT table likes this, e.g.:
[Code]...
As user will input previous date OT records, so the records in db will not be in sequence. the date of records#14 is before records#13. if user want to know which OT records cover the last 2 hours, the system should retrieve record #15 (90mins) & #13 (30mins) because they covers the final 2 hours. How to write the SQL statement to retrieve the records?
Is it possible to have a quick and easy way of retrieving the last 10 records from a table?
Currently what I have been doing is retrieving all the records then one-by-one cylcing through each record until I have the last 10. To me this seems to have a lot of over-head reading each record. I just wondered if there was a quicker way of doing it.
Like we can retreive all the records from a table using this method:
While (Not rst.EOF)
....
End While
How to retrieve all the records when using OleDbConnection?
Dim cmd2 As New OleDbCommand("SELECT Product_name FROM Products WHERE Quantity <= 5 ", cn)[code]..
This code outputs all the products in a list box which are below a quantity of 5, however for those products i wud also like to retrieve the maximum stock level which was assigned to all of them so i can calculate how much more is needed to fulfill the maximum stock level
I 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]...
in 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 know how to loop through a GridView and extract each row using the for each loop as below, but I was looking for a easy way to loop through the datagrid and say extract the last 20 rows? Is it possible to go through in reverse order in vb.net?
For Each row As GridViewRow In InventHistoryGridView.Rows
