Hi Everyone,

I am desperate and need assistance, which I would appreciate very much.

I have the following code, which return the message:

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll, and when I place the cursor on the highlighted green section I find this:

This code has called into another function. When that function is finished, this is the next statement that will be executed.

The code is:
<Private Sub ProjectFeed_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim ProjectConnectionString As String = "Persist Security Info=False;Integrated Security=SSPI;database=Project;server=mySQLServer"
Dim ProjectConnection As New SqlConnection(ProjectconnectionString)
Dim ProjectCommand As SqlCommand = New SqlCommand
ProjectCommand.Connection = ProjectConnection
ProjectCommand.CommandText = "Insert into projects " & "(Project No,Client,Rate Type,Description,Starting date,Ending date, Location,Status,Comment,Manager)" & _
"values(@project No,@client,@Rate Type,@description,@starting date,@ending date, location,@status,@Comment,@Manager)"
ProjectCommand.Parameters.Add("Project No", txtProjectNo.Text)
ProjectCommand.Parameters.Add("Client", txtClient.Text)
ProjectCommand.Parameters.Add("Rate Type", cmbRate.Text)
ProjectCommand.Parameters.Add("Starting date", txtStart.Text)
ProjectCommand.Parameters.Add("Location", txtLocation.Text)
ProjectCommand.Parameters.Add("Status", cmbStatus.Text)
ProjectCommand.Parameters.Add("Comment", txtComments.Text)
ProjectCommand.Parameters.Add("Manager", txtManager.Text)
ProjectConnection.Open()
ProjectCommand.ExecuteNonQuery()
ProjectConnection.Close()

End Sub/>

Can someone please help.

Thanks
Khalil

You have two column names with blanks. I believe these require square brackets around them to get valid SQL. That is Project No should be [Project No].

You also have parameter names with blanks, and I don't think those are allowed at all. See Microsoft's documentation for details:

http://msdn.microsoft.com/en-us/libr...2(SQL.80).aspx

Thank you very much for your help but am still unable to make it work.

I removed the spaces but still have the same issue. My understanding is whether I have spaces or not this is to do with executing the query, which is the stage that I haven't reached yet. My problem is to connect the database first.

I've tried a lot of things but no luck. It is a puzzle.

Thanks again
Khalil

It sound like some data format in table is defined differently may be text or number issue
I will use try and catch method to find the exact problem. If it doesnt work or you need more explaination on how to use try and catch method let me know

__________________
yvk

Hi Yasho,

You are right; it was a formatting problem and I've been able to resolve it.

Thank you very much

Regards
Khalil