I'm trying to add a new record to my database, below is the code i have but it doesnt seem to be working. I dont even get the message box saying new record added.
''BEGIN DATABASE CONNECTION
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = W:Textvertisingdatabase.mdb"
[Code]....
I am trying to check a record in database before inerting a new record here is my code but problem is when i enter a names first alphabet it imediatly populate massage. i want to check it after entering whole name
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
Try
Dim cnString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
[CODE]...
Having problem in updating an existing record. An error occurs "Data Type Mismatch in Criteria Expression"
Private Sub ToolStripButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolStripButton1.Click
Dim myBuilder As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(dataAdapter)
[code].....
[code]There's my code to add, was working, not sure if I accidently changed something but it doesn't work now
View 3 Replieswhat happens is i have a weekly salary table and once a week an administrator computes the salaries and it will be saved there, i want the delete code to delete the already saved record with the same Emp_ID as what i'm trying to save. my problem is i don't think the code i put deletes the record because it will still tell me that there is already an Emp_ID the same with what i'm trying to save..
so far this is my code..
Dim cnn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source = C:UsersFlorieDocumentsVisual Studio 2008ProjectsPayroll SystemPayroll Systemobjx86DebugPayroll_MaryRoseAn.accdb")
Dim cmd As New OleDbCommand
[Code].....
I have text box and button when i clik tht button it has to display all the data if it is relevent to the data else it has to say no data . my project is about track cd. name textbox that i want to search is txtTitle.
i want something like search forum in this website when u clik on search it will get the data same way i need the solution either it is from database or index service
I need to be able to have a loop which checks records in the database and if it matches up then do something. I need to check that zone = currentZone and if it does then to submit my update query.
View 7 RepliesI have a problem with my program, and it's really bad because I need to burn it to disk within 12 hours and I can't get it to work: If I create a record, add information to it and click on Next Record, the ID, Status and Notes boxes content will change but the rest of the controls contents are carried over to the next record and I don't know why or how. It was working perfectly but now it stopped and I never done anything.
View 8 RepliesI'm following the sops from msdn on how to create a database from scratch. I would now like to programmatically add a single record via a command button?
View 3 RepliesModule Code
Imports System.Data.OleDb
Module modConnections
Public myConn As New OleDbConnection
Public myCmd As New OleDbCommand
Public MyDr As OleDbDataReader
[Code]...
Module Code
Imports System.Data.OleDb
Module modConnections
Public myConn As New OleDbConnection
Public myCmd As New OleDbCommand
Public MyDr As OleDbDataReader
[code]....
For some reason my code is executing the INSERT query twice and putting duplicate records in my table. If I put a primary key on one of the fields I get a runtime error and it complains about the fact it can't add the record twice.
The part of the code that INSERTs is near the bottom, bolded and italicized. I put the entire IF statement of code incase my logic is wrong.
This is what's being executed when a user clicks a button
If listOfCompanies.Contains(cbx_Company.Text) Then
'If the list contains the company, UPDATE the record
If LaborChecked Then
[Code].....
I have records in a database. Each record has a Picture path in it eg. "C:\Pics\Image1.jpg". I would like to display a record from my database and also the picture for that record, in a .rdlc report in vb .net 2008. i have succeded in displaying the record but just can't get the picture to show. I am using an Imagebox in the report.
View 2 RepliesI have a access database with these columns. USER_ID,COUNT,TIMES
Let say the current record is this:
USER_ID,COUNT,TIMES
STEVE20,24,1.5
Now I want to updated the current count record and times, but before updating I want the old record to be added to the new record. What should be my query?
delete a record in a database table in crystal report, after the report had been view from the new page and when the page is close.
the report is done in vs2008 c#.
I`m a beginning programmer, and I`m trying to build my first 100% object. The object would be a USER object, representing rekords from users table in database. The table in the database has 5 columns ->
[Code]...
i need some function like adodb.recordset on vb6.0 on vb.net but seem i cant manipulate it like recordset because i want to manipulate in retrieving,inserting and updating my record on just only how call on the database im using mysql database..
View 4 Replieshow to view the next record and previous record in the database.? just like in the picture below.? what condition should we use.?
View 8 Repliesi seem to have a problem when i try to update a certain record in an Access 2007 Database. I have a small Access 2007 database with 1 table which has 3 Columns and several records. The 3 columns are RecordNumber (Primary Key and it is autonumber), FirstName(text) and LastName(text). What i am trying to do in VB 2008 is implement a search form which when you find a record you can update it. I do not have any problems with the search, but i cannot seem to edit any other record than the first one. For example i search for John which exists, if that record is the 3rd record when i try to edit it whatever changes i make (for example change that to James), the changes i make are made to the first record and not the current one. I tried a lot of things but nothing works, here is my code:
[code]...
When I'm trying to update or remove record from database I'm getting this error:
Syntax error (comma) in query expression 'Ime='Blagojce', Prezime='', Adresa='', Grad='', Telefonski_br='( ) -', Fax='( ) -', e_mail='''
Here is my connection string:
command.CommandText = "DELETE * FROM podatoci WHERE Ime='" & ime & "', Prezime='" & prezime & "', Adresa='" & adresa & "', Grad='" & grad & "', Telefonski_br='" & broj & "', Fax='" & fax & "', e_mail='" & email & "'"
where ime, prezime and so on are ListView selected items.
This code i had use for create a field in DB Access 2003:
SQL = "ALTER TABLE plano_contas ADD declperiodica06A char(40) WITH COMPRESSION NULL)"
Dim command1 As New OleDb.OleDbCommand(SQL, con1)
con1.Open()
command1.ExecuteNonQuery()
con1.Close()
like you see the code create a Text field with 40 lenght...Well the problem is:When i save a new record the record it's save in this mode: "100......... .........................." - the points means spaces and should be:"100"After try a lot of things i'm without more solutions in find why this happen!
I hav a web service which pull records from a database and I am hosting these services in IIS which works fine but I am trying to retrieve the record and display the record in a listbox displaying the time field as the text for that record.I have created the following function
public sub get_data()
dim dt as new data.dataTable
dim service as ws webservice.webservice
[code]...
I am trying to add a new record to a database using VB.net. I have used code for one table in the database which worked and then copied and pasted it and changed the column names to the ones in the other table and then I got an error saying that the insert into statement was wrong even though I am using a comand builder. [code]
View 4 RepliesI currently have a Microsoft Access database which is being accessed through an ASP .NET front end. I am trying to add a row to a table, but this doesn't appear to be working, the code I am using is shown below.[code]....
View 1 RepliesI've been trying to add a record to an MDB Database, but for some reason all my code runs fine, but when I check my database no records have been added, I'm doing it on on gotfocus event to make data entry easier with a bar code scanner?
Public Class Form1
Dim con As New OleDb.OleDbConnection
Dim dbProvider As String
Dim dbSource As String
[code].....
There are 12 columns in the table, and I need to update only 3-4 of them, the rest are autokeys I guess, or I need to update them at a later stage in my program...
"Stock, Date, GP, Scratch & UV" TextBox's
These contain the data which need to be added to the columns #4 - #8[code]...
I have problem that my code doesn't add record into the database i don't know why
View 1 RepliesI'm trying to get the last records in the database
my code doesn't give an error but also doesn't do what it supposed to[code]...
I want to get some value from some table in access database
View 3 RepliesGet the last record from a Microsoft SQL database table using ASP.net (VB) onto a web form.
View 2 Replies