Working with datagrids and datasets etc.How do i create a new record which will insert the employeeid automatically into the employee filed on creation of the new record.The employeeid is a globalvariable (guserid)
View 1 RepliesI 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]...
I am inserting new record in ms access database by using VB.NET but when i insert new record it replaces the existing fisrt record the code i am using as follows
Coding:
Dim cnString As String
cnString = ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\PaymentSystem\PaymentSystem\bin\Debug\Payment.mdb;")
[Code].....
Here's the code that fails on update with a fail on Insert Into syntax message:
SQLConnect = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:TechTest-NDT.accdb"
' SQLConnect = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:TechTestDatabaseNDTQA.mdb"
[Code]....
I am using VB.NET and below code on button click event.
Protected Sub ibtnSendInvites_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ibtnSendInvites.Click
Try
Dim emailList As New List(Of String)
[Code] .....
I want to throw exception if user tries to insert same record having same CourseID and CPUserID.
i've added new item called service- based database. after that, i've created doctor table, course table, exam table, and an empty table called exam_report to allow program selects randomly from the other tables.
how it works: first the user will get a form with many buttons: courses, doctors, exams, and exam report. second if the user click over exam report, a new form will appear with many columns. this form should has exam course - exam day - exam time - 3 doctors name who will observe the students.
behind code: the doctors shouldn't be the instructors of the course - the doctor has no appoinment in this day - the doctor has no hloiday and so on..
okay my code is the following :
Public Class Form6
Dim j, a As Integer
Dim d, f, h As Integer
[Code].....
I am trying to insert a new record into msaccess2003 mdb file my version is VB.net 2005, it doesnt show any error and also when i open my access db file, there is no record inserted, And also how can i format the date field it is giving me error, how can i convert the txtdate.text to date compatible with ms acess.[code]
View 1 Repliescan i ask how do i insert my records from my textbox to specific column name of my table
IsConnected("Insert into products values(" & _
Me.TextBox1.Text & ",'" & _
Me.TextBox3.Text & "','" & _
[code].....
the next code is working but when I try to insert an existing record, it gives me an error and I want to add a msgbox to let people now that the username is already taken.Only the username cannot repeat on the database because it's the primary key.. the rest of the table rows can repeat.
Dim cn As New OleDbConnection
cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Fabio\Desktop\Telemoveis\Telemoveis\Db_Tel.accdb"
[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'm having a problem inserting a new record into an Access 2003 table.The error occures at the line near the bottom with "ExecuteNonQuery()".scroll down in the second block of code.
Within the Incident Information Table
IncidentID is Text
InvStartDate is Short Date
IncidentDate is Short Date
Here is the code.
Public Class NewGeneralIncidentForm
Dim conn As New OleDbConnection
Dim incIdString As String = "0"[code]....
In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.
I am creating some basic software for our manufacturing department. I am using Visual Studio 2008 using Visual Basic.The software has a user log in. There is a form in which the choose the worker name, the item they were making, how many were made, damaged, or received damaged from the supplierHowever when they click on the "Update" button to insert the record..i get my custom message that it failed and the record is not inserted. I put a TRY...Catch... around the insert query and it didn't generate an error message.I have been following the code in the OLEDB BASICS tutorial so I am not sure what the problem is at this time.
<add name="MFCTData"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\Data.mdb;Persist Security Info=True"
[code]....
how to validate the Duplicate record before Inserting and Updating Command is Trigered from VB.Net Form. I am new to VB.
View 2 RepliesI am using sql server 2008 as database server. I have created "AddTest" stored Procedure and using it in my app,
Dim cn As new SqlConnection(connStr)
Dim da As New SqlDataAdapter("Select * from dbo.Subjects", cn)
Dim ds As DataSet
[code]....
<div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Partial Class _Default</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x:
[code]....
[code] When insCommand.ExecuteNonQuery is executed, an exception with Error # -2147217900 is thrown, with the detail of "In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user." At the time the error is thrown, this is what resides in strInsert: "Insert Into ScoutInfo (ScoutID, YearID, GSUSAID, FName, LName, DoB, Grade, Level, School, YearsIn, CurrentYear) Values (10000, 20092010, 123456, 'Jacobina', 'Lowe', '11/30/2009', 'K', 'Daisy', 'Thisone', 0, '20092010')" I've already verified that the Insert statement and datatypes of the columns match.
View 2 RepliesI'm trying to get the AutoID after inserting a record in to a DB. Does this code look right as Mydata is blank afterwards?
[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].....
how can i insert record in specific column name..i've used this code it works but how can i insert my record in a specific column name?? here is my code in my btnAddRecord :
If frUpdate = False Then
IsConnected("Insert into products values(" & _
Me.TextBox1.Text & ",'" & _
Me.TextBox2.Text & "','" & _
[code]....
I am new to VB. I was trying to insert a record into access database with data reader. I was getting OVERFLOW error at runtime. My understanding is that overflow error occurs when we assign values that to variables that exceeds the maximum size of the data type.
Following is my code
Private Sub InsertRecord(ByVal CustomerID As Integer)
Dim RowArray() As String = Split(Me.lblRow.Text)
Dim intPrice As Integer
Dim decTotalPrice As Decimal
Dim mySQL As String
[Code] .....
I am using the following code to insert record into my database but I keep getting the "Error while inserting record on table...Invalid column name 'xxx'." but when I tried to issue the command in SQL server: INSERT Movie_Table VALUES(100, 'Avatar');
Private Sub store_Data()
Dim con As New SqlConnection
Dim cmd As New SqlCommand
Dim iCounter As Integer
[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 RepliesBasically i am making a software that will be interacting with a database (sql).Now what i wanted is a loop which after every 30 minutes, connects to the database finds some info and executes a bunch of statements.For the sake of testing i have made the timer tick at 1 second, and display a record in a database in a label continuously just to see if it works (i will later make the tick 30 min)Now this is what i have tried till now , it prints the record in database perfectly after 5 seconds, but after that just fails.[code]I want to infinitely make a loop in which after every 30 minutes has passed it would connect to the database get a record and then use the value of that record to perform some operations. And this has to be done in the background.
View 2 RepliesI'm trying to add a new record to my database but i keep getting the message - "conversion from type DBnull to type string is not valid". I think its something to do with the Employee ID when VB attempts to save it to the database my code is below
Imports System.Data.OleDb
Public Class Add
Private Sub DisplayRow()
[Code]....
Actualy when i do click to insert button in my form i get this error:
the strange is when i close this window and i do click again the insert button the record is successfully added the the database :( here my insert code (the necessary because it`s so long):
Try
'build sql requests
Dim sqlQRY1 As String = "INSERT INTO AUDIO Values ('" + nomAudio + "')"
[Code]....
i would ask why in first click he show me error but in the second it worked although it`s the same operation, the same form without changing anything in his components and fields .
i have some sample code on inserting a record from one table to another new table? Making the record on the first table to be deleted and been transfered to another table ..
View 7 RepliesI 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 try to inser a record in my db but ii doesnt work,i try many solutions but only thedataset were updated , never the table in dbthese are my buttons with all my attempts:
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code].....
I have a form which has has a bound data source (generated automatically by VB - table adapter, binding source etc).How do I use the Form.Show method to open the form ready to enter a new record. Is there a simple way of doing this?
View 4 RepliesGood Day. Kinda banging my head against the wall on this one. I have a Mdi application with the start form(mdiparent) and form1(mdichild). On the start form, there is a textbox and a button. Heres how I want it to work:
1. value is entered into textbox and button is clicked
2. if form1 is open with that value, Bring it to the front if not, create a new instance of form1
If Not IsNothing(frmForm) Then 'If it is something
If Not frmForm.IsDisposed Then 'it's not disposed
'loop through the open form1s and compare the form1s property to the startform textbox
'if its the same, bring the form1 to the front
[code]....