Compare values from database

Question

0.00/5 (No votes)

See more:

i am using query like

select * from mew_file where process_id=6

I am getting 5 Rows with five cols

now i want to compare whole 3rd column with one valu lijr

if(reader["stage"]=100)
{
}

hear stage is the 3 rd column in my sql query I how can I compare.

Posted 21-Dec-11 23:56pm

janareddyjanareddy

Updated 22-Dec-11 0:12am

RaviRanjanKr

v2

Add a Solution

3 solutions

Solution 1

Use WHEN - CASE in query, if you have any doubt then don't hesitate.

Posted 22-Dec-11 0:04am

Sarvesh Kumar Gupta

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)

Shobana16 · Accepted Answer · 2011-12-22T00:22:00

C#

ArrayList myarr = new ArrayList();
       for(int i=0;i<ds.tables[0].rows.count;i++)>
       {

        myarr.Add(ds.Tables[0].Rows[i]["Third_ClumnName"].ToString());

       }

Now you have all values in "myarr" array.

Then, you can assign a string what you want to compare.

After that compare that string with each element of Array.

Manish.Insan · Accepted Answer · 2011-12-22T00:25:00

use dataset to fetch data from database, because it is connection less.
and then you can compare in this way :

C#

Dataset ds=new Dataset();
ds= // get data into ds;
for ( int i=0; i<ds.tables[0].rows.count;>{
  if( Convert.ToInt32(ds.Tables[0].Rows[i][2])==100)  // 2 is index of column
   {
     // code here that u want to do;
   }
  else
   {
    // else condition
   }
}

Hope this will surely help you.
Don't forget to mark as answer if it helps. :)

Compare values from database

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0