Sql command miss first element to select

Question

0.00/5 (No votes)

See more:

I am using the following SQL select command to select some row,

C#

cmd = new SqlCommand("SELECT question FROM examQuestionWritten WHERE tchId = '" + getTchId   + "' and session = '" + getSession + "' and dept = '" + getDept + "' and subject = '" + getSubject + "' and quizNum = '" + getQuizNum  + "' ORDER BY questionNum ASC ", vcon);

It work fine but it fails to select the first element that it should be. Example, if it have 4 row to select, it always ignore 1st row and select the other (2,3 and 4th row). I don't know what is the problem, please help me.

Posted 2-Sep-13 20:11pm

sazzad37

Add a Solution

Comments

Thomas ktg 3-Sep-13 2:16am

Check the conditions you provide in the where clause matches the first row to be selected if it does not probably it will not return the first row.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 3-Sep-13 2:19am

Some condition is not matching for that row. Take a closer look, you may see what is the issue.

P_Dash 3-Sep-13 2:22am

Parameter used in Order By clause should be present in Select statement.
Otherwise it might give you weird values.

OriginalGriff 3-Sep-13 2:54am

Show us the code that uses that SQL command - I suspect the problem is there, rather than related to the actual SELECT statement.

2 solutions

Solution 2

Hi,

In your query you are using AND operator for condition. When all condition meets based on this it will retieve data.

Note :
Check for empty space in your values.

Posted 3-Sep-13 0:34am

NAGARAJ N MACHAKNUR

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)

M.R.A. · Accepted Answer · 2013-09-03T00:24:00

Solution 1

i think condition is not satisfying.Plz check the code properly.

Posted 3-Sep-13 0:24am

M.R.A.