check column values in a table using C# in ASP.Net

Question

0.00/5 (No votes)

See more:

I want to check if certain values exist in a table based on ID in the DetailView. For instance, i have 4 fields in the backend table:

ID Approved1 Approved2 Approved3

A) First i want to check if Approved1, Approved2, Approved3 fields are not null, meaning the values are either Yes or No for all the 3 fields. If anyone of them is null or blank then i want to quit the function

B) If all Approved(*) fields have a value of "YES" based on the selected ID in the DetailView then i want to call some function;
C) If one of the Approved fields is "NO" then i want to call some other function. can someone help and show me some example? thanks

this is what i have so far:

C#

private void CheckData()
    {

        
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);
        SqlDataAdapter da = new SqlDataAdapter("SELECT ID, Approved1, Approved2, Approved3", con);
        DataTable dt = new DataTable();
        da.Fill(dt);
        
    }

Posted 29-Oct-12 14:21pm

moe_57

Add a Solution

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)

S.Chhetri · Answer 1 · 2012-10-30T17:12:00

You can do something like below:

C#

foreach(var row in dt.Rows){
    string id = row["id"];
    string app1 = row["Approved1"];
    string app2 = row["Approved2"];
    string app3 = row["Approved3"];

    if(string.IsNullOrEmpty(app1) || string.IsNullOrEmpty(app2) || string.IsNullOrEmpty(app3))
        return;
    
    if(app1.ToLower()=="yes" && app2.ToLower()=="yes" && app3.ToLower()=="yes")
        YesFunction();
    else
        NoFunction();
}

Haven't tested the code.. so, you might have to make some changes... Hope this helps..