I've set up a simple database connection using visual basic 2010 express. I have set up a table and dragged the fields onto the form, where a navigation bar appears. I am able to enter and save data when I debug the programme; however when I stop debugging and make some changes, then start debugging again, the records are reset to 0.
View 2 RepliesI have 2 forms, FormA and FormB
How to reload the listview of FormA if I fire FormB form_closed event?
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 Replieshow 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 RepliesThis syntax error keeps coming up whenever i click the "commit button" to add a new record to my ms access database. The error is, "Syntax error in INSERT INTO statement."I got help to write a code to accept alphanumeric (e.g SC0001, SC0002...) in my order id textbox and it works fine whenever i click the "add button", but when i click the "commit button" to save the new record into the database, it brings up that error and i have tried to figure it out but still doesn't work.The codes i have written for both the "add and commit" buttons are here below:
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
txtStudID.Clear()
[code].....
This syntax error keeps coming up whenever i click the "commit button" to add a new record to my ms access database. The error is, "Syntax error in INSERT INTO statement."I got help to write a code to accept alphanumeric (e.g SC0001, SC0002...) in my order id textbox and it works fine whenever i click the "add button", but when i clickthe "commit button" to save the new record into the database, it brings up that error and i have tried to figure it out but still doesn't work.
The codes i have written for both the "add and commit" buttons are here below:
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
[code]....
I got on my form textboxes, checboxes but also a groupbox which holds texboxes.
The idea is to be able to clear and reset all of these by clicking a reset button.
At the moment i got this
Private Sub ClearFields()
Dim ctrl As Control
[Code].....
But ofc Me.controls isn't gonna get involved with the stuff in the groupbox.
Ok, so I am building my own program to control a video player I have through telnet, I have everything else working except one thing.I have a reset button to reset the player, when I press it, it sends the string "Reset" and the unit resets without a problem.But when I add a code to close the winsock connection upon reset, it doesn't send the string to the unit. I am sure what is happening is the winsock is getting closed at the exact same time it is trying to send the string and so it fails to send, how do I make it close winsock AFTER the string has been sent? [code]
View 1 RepliesI've created an application in <acronym title="Visual Basic">VB</acronym> .net to allow me to modify my student database, the problem being that it only updates the copy of the database in the debug folder. How can I make the program update the real database instead? I'm using Visual Studio - <acronym title="Visual Basic">VB</acronym> .Net - 2010
View 5 RepliesSimple question that does not seem to be covered: If I use a lot of Debug.WriteLine statements in my code, will they be completely absent in my production version?
I mean: Is the compiler smart enough to not emit any code for those calls? Or would I have to surround them by #if DEBUG..#end if directives?
I'm using vb2008 and database ms access.
I want to know if exist in the Debug folder in my project Database access
what is the connection string when the database copy paste in debug folder?I have a code connection string it's work but when i try to other computer cannot connect in to the database.
Try
If sqlconn.State = ConnectionState.Open Then
sqlconn.Close()
End If
[code]....
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 the code below which does work, but I need to add further functionality to it. The functionality I want to add to it is the text I have commented in the code below.
Dim objSQLConnection As SqlConnection
Dim objSQLCommand As SqlCommand
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code]....
Before the if statement, I want to find out if the database already has records with the username in the strUser variable.
i have some difficulty in displaying records from database to my combobox here is my code in the form_load
Private Sub Form5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim con As New SqlConnection
con.ConnectionString = "Data Source=.SQLEXPRESS;AttachDbFilename=C:UserslitoDocumentsQMP_DB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
[code]....
I'm very new to using VB.Net so I found it quite difficult to understand other answers that I searched for.
Basically, I have an project to develop where a user can create an account, and log in with it.
So far I have :
Created a database in ms access with the relevant fields (2003 edition)[code]...
I need help with adding a record to a database.I have a database with multiple tables. How do I add a new record to one of the tables without using the BindingNavigator.Lets say the table's name is tblDetails and the fields are:NameSurnameCellAddressI have a number of text boxes on my form:txtNametxtSurnametxtCelltxtAddressI want to add the details from the text files to the table and a new record.
View 5 RepliesIm practicing a database and I have a 3-column table. Im using binary formatting to save/open the file. I cant see what is wrong with my code“
I can display records ok when I press the save button
I can also save the records ok when the save/close button is pressed.
When I reopen the programme and press the reload button to reload the dataset, additional records will not be displayed nor saved though original records will be showing.[code]...
I have 3 combo boxes full of data. I have an access database with a table and 3 fields. I am using the following code to insert the data from the combo boces into each field of the database. The program runs and I get no errors but the data is not going into the table.
Dim DrawCount As Integer = 0
Dim DateStr As String = ""
Dim TimeStr As String = ""
[Code].....
now i got a problem deleting records in the database
this is my code
Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
[code].....
I have a table in an access database that binds to a datagridview with a binding source. The table is named Charges and contains all the charges to a lot of accounts. Let's say I only want to display the charges that are associated with Account ID = 1.
View 1 RepliesI Have made a database and connected it using VB.net 2005. I try to enter new records into the database and i can update the dataset but not the database itself, i write the code to update the database and i get an error saying[code...]
Here is the code for the whole thing, I click btnNext to display the next recrod and want to change it by clicking the update button but this is when the error comes up'[code...]
i have this problem on retrieve 3 records from database.i did it in a way that i have a few button.when i press on one of the button which have a value of bee then it will go into the database and search for bee.it will return me the result on bee at the same time it will also return both top and bottom record of bee.
How do i do that in SQL or VB.NET
How can I create a search box to search records in a sql database? I plan to use the search-box in the same Form where I have a details view interface to the database table.
View 2 RepliesI typically dont use a dataset in a case of new data insertion to the database. But then again, I will run in a problem the weather the inserting data already exsit in the database. Therefore i need to perform a search first. However, if i follow this it will take slow down the application (if the table has 1 million records). One way i could optmimize this is to load the whole table in to a dataset then the application doesnt have to go to a back end trip nwo it can search inthe dataset. Is this the standard way for inserting records?
View 3 Replieshaving a bit of trouble with inserting records into my database. I have the following code:
Dim mypath As String = Application.StartupPath & "\Data\Contacts.mdb"
Dim mypassword As String = ""
Dim inc As Integer
[Code]......
I have a very annoying problem with adding new records to my Access Database, I'm not getting any syntax errors but there's obviously a symantic error of some kind causing this headache. I've been developing an RFID system for two months now and spent the last four weeks trying to fix this one issue, if anyone can see wher
Private Sub m_btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles m_btnSave.Click
Dim da As New OleDb.OleDbDataAdapter
[code].....
when using the ExecuteReader() command with an SQL database, with an example as follows:
DUReader01 = DUCommand01.ExecuteReader()
DUReader01.Read()
DUCounter01 = DUReader01.Item("Counter")
I am looking for a simple code example that will test to determine if the database first is empty before attempting the Item()
command.With the above example, the Item() line produces the error "Conversion from type 'DBNull' to type 'Integer' is not valid." for an empty database.
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].....