I am getting row not found at position 0 exception when I try to execute the follwing:

Question

0.00/5 (No votes)

See more:

Dim Command As New SqlCommand("[---].[usp_-----]", pcnn)

With Command.Parameters
.AddWithValue("@nQID", pnID)
End With

Dim dt As DataTable = FillDataTable(Command)
Return dt.Rows(0).Item("dCr")

Note: stored procedure inputs were there please ignore ----'s.
Thank You!

What I have tried:

I debugged the above lines of code , there was nothing inside.

Posted 14-Dec-21 2:59am

RandalKeith

Updated 14-Dec-21 3:21am

Add a Solution

2 solutions

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)

OriginalGriff · Answer 1 · 2021-12-14T03:17:00

We can't help you - there just isn't enough information there. Heck, there isn;t any information there!

So start by using the debugger to look at exactly what your command string is: then check that against your actual db and it's stored procedures. And check the value in pnID at the same time.

If that all looks right, look at the actual stored procedure and see what it does.

Then use SSMS to run the code from the SP as a query - with the pnID value you checked earlier - and see what it returns.
If it's no rows, look at your DB table data and find out why no rows match.

Hopefully, something there will lead you to the problem, and from there it's probably a small step to a solution.

But we can't do any of that for you: we have no access to your code while it is running, or your DB at all!

CHill60 · Answer 2 · 2021-12-14T03:21:00

Solution 2

The problem is in the method FillDataTable() - you have not shared the code for that method so we cannot be more explicit.

FillDataTable is returning an empty table so dt.Rows(0) does not exist

Posted 14-Dec-21 3:21am

CHill60

Comments

RandalKeith 14-Dec-21 9:45am

Thank You for the quick response I will check and get back to you!

CHill60 14-Dec-21 12:47pm

Looking at your code I would say it's the SQL that you are passing into FillDataTable - first thing to check. See Solution 1