Update error : length cannot be less than zero. parameter name: length

Question

0.00/5 (No votes)

See more:

Hello I am Emmanuel and I have developed, compiled and installed an application. Everything works perfectly until I make an update. I get the error: "length cannot be less than zero. parameter name: length". Can someone help me out. Thanks

Posted 18-Oct-12 23:28pm

Member 4146005

Updated 18-Oct-12 23:30pm

v2

Add a Solution

Comments

Ambesha 19-Oct-12 5:35am

please share your code

[no name] 19-Oct-12 6:08am

You need to make the length parameter greater then zero when calling the function where you are getting the error.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ambesha · Answer 1 · 2012-10-18T23:37:00

Solution 1

or till you can browse the same, it might solve ur issue:

www.justskins.com/forums/length-cannot-be-less-130219.html[^]
http://www.dotnetspider.com/forum/300060-Length-cannot-be-less-than-zero-parameter-name-length-Error.aspx[^]

Thanks,
Amebsha

Posted 18-Oct-12 23:37pm

Ambesha

Comments

Member 4146005 19-Oct-12 5:48am

Thanks Ambesha for the help.
The issue still exists. will try again.

Ambesha 19-Oct-12 5:51am

Better share ur cods part here..

Member 4146005 19-Oct-12 6:12am

Ok. here is it.

On click of the save button, i check if the item being saved already exist in the database.

Public Function save() As String
Try
''RegDate = Today.Date

'If Not ConnectionState.Closed Then _con.Close()
'Connect()
blnResult = CheckExist(ClientNumber)
If blnResult = True Then
'Begin the Transaction
_trans = _con.BeginTransaction(IsolationLevel.ReadCommitted)
'_com.Transaction = _trans

'Update Client
query = "Update tblClients Set fldFirstName = '" & Replace(FirstName, "'", "''") & "', fldLastName = '" & Replace(LastName, "'", "''") & "', " & _
"fldTitle = '" & Replace(Title, "'", "''") & "',fldFullName = '" & Replace(FullName, "'", "''") & "', " & _
"fldGender = '" & Replace(Gender, "'", "''") & "', fldBirthDate = '" & Replace(BirthDate, "'", "") & "', " & _
"fldAddress = '" & Replace(Address, "'", "''") & "', fldPhone1 = '" & Replace(PhoneNumber1, "'", "") & "', " & _
"fldPhone2 = '" & Replace(PhoneNumber2, "'", "") & "', fldHomeTown = '" & Replace(HomeTown, "'", "''") & "', " & _
"fldMaritalStatus = '" & Replace(MaritalStatus, "'", "''") & "', " & _
"fldSpouse = '" & Replace(SpouseName, "'", "''") & "', fldSpousePhone = '" & Replace(SpousePhone, "'", "") & "', " & _
"fldNextOfKin = '" & Replace(NextOfKin, "'", "''") & "', " & _
"fldPhoto = '" & Replace(PictureName, "'", "''") & "', fldDate = '" & Replace(RegDate, "'", "") & "' Where fldClientNo = '" & Replace(ClientNumber, "'", "") & "'"
'_con.Open()
_com = New OleDb.OleDbCommand(query, _con)
_com.Transaction = _trans
ctr = _com.ExecuteNonQuery()

'ContextUtil.SetComplete()
'Commit the transaction
_trans.Commit()
blnSuccess = True

'_con.Close()
MessageBox.Show("New Client saved", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information)
End If
Catch nullEx As NullReferenceException
MessageBox.Show(nullEx.Message)
'Rollback the transaction
'ContextUtil.SetAbort()
_trans.Rollback()
blnSuccess = False
Catch ex As Exception
MessageBox.Show(ex.Message)
'Rollback the transaction
'ContextUtil.SetAbort()
_trans.Rollback()
blnSuccess = False
'_con.Close()
End Try
Return blnSuccess
End Function