have made an sql database and connected it succesfuly in vb 2008. database table name: contacts fields: id, firstName, lastName
i tried to insert the example values : 3, testFN, testLN but i get an error : error while inserting the name testFN is not permitted source code :
Imports System.Data.SqlClient
Imports System.Data
Public Class Form1
[Code].....
I have 1 process that acts as a server (TcpListener) and one or more processes that act as clients (TcpClient). The clients are sending Tcp requests to the server every 1-2 seconds to which the server responds with a result message.
In normal conditions the server will use TcpListener.Stop when it closes, but sometimes the server will crash (for whatever reason) and then this is not done. If I then try to restart then I get the following error:
"Only one usage of each socket address (protocol/network address/port) is normally permitted"
I only get this error when there are clients running who keep trying to connect despite the TcpListener is not there anymore (crashed).I don't get this error when I first manually close/kill all clients before restarting the server/TcpListener.I'm looking for an automatic recovery procedure that deals with this error/problem. How can this be done?Below you'll find code examples of the server and the client.BTW: Although the codes examples are in VB.NET, I can also handle C# code. That's why I tagged this question with both VB and C#.Code example for server/TcpListener:
Public Shared Sub Thread_TcpListener_GUI()
While True
Dim tcpClient As TcpClient = Nothing
Dim tcpListener As TcpListener = Nothing
[code]....
I am calling this function when a button is CLICKED and received the error; The name "The" is not permitted in this context. Valid expression are constants, constants expression, and (in some contexts) variables. Column names are not permitted.Unclosed quotation mark after the character string 'True)'.
The function is as follows;
Code:
Private Sub Save()
Dim conn As SqlConnection = GetDbConnection()
Dim query As String
[code]....
The name "Debit" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.
View 5 RepliesI'm just trying to add a simple function to the textbox for security that if i only allow 0 - 9 Numbers and i try to put a letter it wont let me
View 5 RepliesHere'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 trying to add a new row into a gridview but for some reason i'm having a problem in the for loop.Directly goes to dtCurrentTable.Rows.Add(drCurrentRow) and of course, have an error "'row' argument cannot be null.Parameter name: row", because the tcurrentTable.NewRow was not executed.
Why is this happening?
Private Sub AddNewRowToGrid()
Dim rowIndex As Integer = 0
[code].....
debug this code(especially on the highlighted one, it is where the bug occur)
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
Dim myConnection As SqlConnection
Dim myCommand As New SqlCommand
Dim ra As String
[code].....
I've got this code. But I keep getting an INSERT INTO error when I try to insert a new field into the database
Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
Dim recordsadded As Integer
Dim strSQLString1, strSQLString2, strSQLString As String
strSQLString1 = "INSERT INTO tblParts (PartName, PartPrice, Part Supplier) "
[Code] .....
My 3 datatypes are text values, and I have another form adding entries to my database in another table, which are all text values.
I am using 6 textboxes and three button one for insert data second for update and third for delete the data while inserting and updating the record it generate an error i.e. "Data type mismatch in criteria expression" in the backend i.e in MS Access I am using this column[code]...
View 2 RepliesI have a SqlDataSource and a GridView.
What I want to do is, while the query is executed (i.e. for inserting a data), then after the data has inserted successfully, it should appear a message sounds: "The data deleted successfully". I've solved it by using GridView1_RowDeleted method.
Now the problem is, I want to catch the error while the query is failed to executed. If the query has failed to execute, then it should appear a message: "The data failed to insert."
I'm using the following code to insert the data in a table and i am getting the error at cmd.executenonquery()....The exception is labelled as SQL exception and the underlying message says "String or binary data would be truncated. The statement has been terminated." [code]
View 2 RepliesI am trying to insert data into my database but because i have relationships in the database, i can't enter data into one unless the other has been entered but i can't also do all that at the same time.This is the error i get: You cannot change values of this column because it is related to another table, what do i do and what is the next best option if i don't want to use "autonumber" but want to make sure i don't repeat numbers. How do i implement that?
View 1 Repliesi'm new to vb.net. i'm using visual studio 2005 windows application vb.net language. i'm doing a company project and using MS access database. i want the user to add data about the new customer and save it to the database.i used the followinf
[Code]...
i having a syntax error when im inserting data to two table.i check all the spelling and also i put [] in my reserved word.. by the way here's the code..[code]
View 6 RepliesI'm working on a form that allows to add new users to a users table in my Access database. The table only has 3 fields: user (string), password (string) and admin (boolean). user is the primary key. But when I run it and try to add, I get an error when casting the query to Double (?). I don't have any double variables or table fields, and I'm not trying to cast anything from or to double. So I have no clue about how to fix this. The code I'm using to insert (and it's working correctly on other forms and tables I have) is:
[Code]...
I keep getting the following error when inserting in to my Access DB using VB.
THe code I use is:
Code:
Dim code As String = "INSERT INTO tblUser(Username, Password, Forename, Surname) VALUES('" + txtrEmail.Text.Trim + "','" + "dfd" + "','" + txtrForename.Value.Trim + "','" + txtrSurname.Value.Trim + "');"
[Code].....
I got the sql code to write in a text box and executed i manually in to Access DB and it works perfectly.
I have a form showing a datagrid that is filled with info from an Access database table. The table only has 3 fields: two of them are string type and the third one is boolean. The first String type field is also the primary key (this field is called "clave"). This datagrid is supposed to let the user select one of the rows and then click on a button to delete that row. I'm trying to do that with the following code:
[Code]...
I have a form showing a datagrid that is filled with info from an Access database table. The table only has 3 fields: two of them are string type and the third one is boolean. The first String type field is also the primary key (this field is called "clave").This datagrid is supposed to let the user select one of the rows and then click on a button to delete that row. I'm trying to do that with the following code:
[code]...
I 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]....
[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 am trying to insert into a access db and the PK is an autonumber that is generated by the DB. I am getting a syntax error for the insert statement and dont know why. If possible I would like to return the autonumber value in the same statement.
[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]....
So I'm opening a TCPListener on socket 8000. Debugging code, finding bugs, stopping the app and debugging again. Somehow I'm causing a problem such that it's not closing the TCP port, and it's causing a major problem such that even after I stop my program and restart it the code to open the TCP port the app is still throwing an exception, and it keeps happening until I reboot.It's going to be real hard to find the bug when I have to reboot each time to debug the app
View 6 RepliesSocketException was Unhandled: Only one usage of each socket address (protocol/network address/port) is normally permitted I get this error every time i click collect a second time.
[Code]...
The code that I will be posting here in this thread is about inserting image into MS Access database. I have a problem indicating an error saying "Parameter is not valid".
[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 am attempting inserting into an Access database, and the insert is successful (when I open the database the data is there), but I'm getting an error: "The 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."
This is really confusing me. No matter what I insert, it still gives me the same error. And I don't understand why it's giving me an error even though it's working. Here's my codebehind:
Protected Sub Wizard1_FinishButtonClick(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.WizardNavigationEventArgs) Handles Wizard1.FinishButtonClick
[Code]....
I am attempting inserting into an Access database, and the insert is successful (when I open the database the data is there), but I'm getting an error: "The 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
View 7 Replies