How Do I Solve An Exception Like This;

Question

1.00/5 (2 votes)

See more:

when ever run my program i get the below exception.

Exception thrown: 'System.Data.OleDb.OleDbException' in System.Data.dll
at
System.Data.OleDb.OleDbCommand.Execute.ExecuteCommandTextErrorHandling(OleDbHResulthr)
at
System.Data.OleDb.OleDbCommand.Execute.ExecuteCommandTextForSingleResult(tagDBPARAMSdbParams,Object&executeResult)
at
 System.Data.OleDb.OleDbCommand.Execute.ExecuteReade(Command Behavior beehavior,String method)
at
System.Data.OleDb.OleDbCommand.ExecuteReadder(CommandBehavior behavior)
at
line 60
and line 60 =  rdr = cmd.ExecuteReader()

I'm using below code:

VB

con = New OleDbConnection(cs)
            con.Open()
            Dim ct As String = "select Allowances,BasicSalary,CashBenefits,VehicleFuelDriver,VehicleFuel,vehicleOnly,FuelOnly,AccomodationFurnishing,AccomodationOnly,SharedAccomodation,AgeDependency,MarriageResponsibilities,Disabled,OldAge,ChildEducation,TrainingCost,Tier3contribution,NoChildren,LifeInsurance,SSN,NoOfDependents from EmployeeRegistration where EmployeeName=@find"
            cmd = New OleDbCommand(ct)
            cmd.Connection = con
            cmd.Parameters.Add(New OleDbParameter("@find", OleDbType.VarChar, 30, "EmployeeName"))
            cmd.Parameters("@find").Value = Trim(employeenamecmbbx.Text)
            rdr = cmd.ExecuteReader()

Posted 5-Jan-16 21:50pm

Masta Pee

Updated 6-Jan-16 3:54am

Maciej Los

v3

Add a Solution

Comments

dan!sh 6-Jan-16 3:57am

There must be more details in the exception. Message, inner exception etc. Have you checked that?

Masta Pee 6-Jan-16 3:59am

okay i will post the entire exception,

OriginalGriff 6-Jan-16 4:16am

Please do, and include the relevant code fragments so we can see exactly what caused it.

Use the "Improve question" widget to edit your question and provide better information.

Masta Pee 6-Jan-16 7:18am

i have updated the question..

OriginalGriff 6-Jan-16 7:21am

:sigh:
And the code looks like?
Just the one line:
rdr = cmd.ExecuteReader()
tells us nothing - we need to see what the "setup" code fro that is - the command, the connection, the parameters. In isolation, that line tells us nothing except that you are using a DataReader.

Masta Pee 6-Jan-16 7:43am

con = New OleDbConnection(cs)
con.Open()
Dim ct As String = "select Allowances,BasicSalary,CashBenefits,VehicleFuelDriver,VehicleFuel,vehicleOnly,FuelOnly,AccomodationFurnishing,AccomodationOnly,SharedAccomodation,AgeDependency,MarriageResponsibilities,Disabled,OldAge,ChildEducation,TrainingCost,Tier3contribution,NoChildren,LifeInsurance,SSN,NoOfDependents from EmployeeRegistration where EmployeeName=@find"
cmd = New OleDbCommand(ct)
cmd.Connection = con
cmd.Parameters.Add(New OleDbParameter("@find", OleDbType.VarChar, 30, "EmployeeName"))
cmd.Parameters("@find").Value = Trim(employeenamecmbbx.Text)
rdr = cmd.ExecuteReader()

Maciej Los 6-Jan-16 9:55am

Next time, please use Improve question widget.

Masta Pee 6-Jan-16 7:19am

questions is updated

Maciej Los 6-Jan-16 9:56am

What kind of database? What's connection string?

Richard Deeming 6-Jan-16 10:59am

You've posted the stack-trace, but what's the message?

In the exception balloon in Visual Studio, you should have a "Copy exception details to clipboard" option. Click that, and then paste the entire result into the question.

Masta Pee 11-Jan-16 9:02am

System.Data.OleDb.OleDbException was unhandled by user code
ErrorCode=-2147217904
HResult=-2147217904
Message=No value given for one or more required parameters.
Source=Microsoft Access Database Engine
StackTrace:
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at Payroll_Manager.frmpayroll.employeenamecmbbx_SelectedIndexChanged(Object sender, EventArgs e) in C:\Users\P\Desktop\Payroll Manager(MS Access)\frmPayroll.vb:line 59
at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
at System.Windows.Forms.ComboBox.set_SelectedIndex(Int32 value)
at System.Windows.Forms.ComboBox.set_Text(String value)
InnerException:
this is it please

Richard Deeming 11-Jan-16 9:13am

Try adding the parameter using AddWithValue:

cmd.Parameters.AddWithValue("@find", Trim(employeenamecmbbx.Text))

Sergey Alexandrovich Kryukov 6-Jan-16 13:56pm

It is still not the comprehensive exception information.
—SA

Masta Pee 11-Jan-16 9:01am

System.Data.OleDb.OleDbException was unhandled by user code
ErrorCode=-2147217904
HResult=-2147217904
Message=No value given for one or more required parameters.
Source=Microsoft Access Database Engine
StackTrace:
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at Payroll_Manager.frmpayroll.employeenamecmbbx_SelectedIndexChanged(Object sender, EventArgs e) in C:\Users\P\Desktop\Payroll Manager(MS Access)\frmPayroll.vb:line 59
at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
at System.Windows.Forms.ComboBox.set_SelectedIndex(Int32 value)
at System.Windows.Forms.ComboBox.set_Text(String value)
InnerException:

CHill60 7-Jan-16 10:44am

Instead of typing the message in, copy it - all of it - and let us know what the error message is - See Richard Deeming's comment!
Also check the contents of employeenamecmbbx.Text

CHill60 7-Jan-16 10:46am

Also try surrounding "Disabled" with square brackets - i.e. [Disabled]

Masta Pee 11-Jan-16 9:01am

this is the exeption please i need help to save my job;
System.Data.OleDb.OleDbException was unhandled by user code
ErrorCode=-2147217904
HResult=-2147217904
Message=No value given for one or more required parameters.
Source=Microsoft Access Database Engine
StackTrace:
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at Payroll_Manager.frmpayroll.employeenamecmbbx_SelectedIndexChanged(Object sender, EventArgs e) in C:\Users\P\Desktop\Payroll Manager(MS Access)\frmPayroll.vb:line 59
at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
at System.Windows.Forms.ComboBox.set_SelectedIndex(Int32 value)
at System.Windows.Forms.ComboBox.set_Text(String value)
InnerException:

Masta Pee 12-Jan-16 7:51am

i have than all changes and it is not working still please can some1 give me another way of doing this please.. please

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)