How to handle label as a variable populated with sql query

Question

I might be asking this all wrong and I will try my best to explain my question here. I have a query that populates a number of different GUI features. One of them being a label.

foreach (DataRow row in dt.Rows)
{
    if (row["NT"].ToString() == "C")
    {
        conSpell.Text = row["full_name_nd_ro"].ToString();
    }
}

I am able to get the value from the query into the label...Except, when there is no value in the query, the label remains populated with the old value on multiple executions.

I'm not really sure how to approach this. Any help is greatly appreciated!

Cheers Chris

Dmitriy Khaykin · Accepted Answer · 2014-02-13 19:19:51Z

1

You don't have any logic that clears the label out.

Just add this code to clear the label:

if (dt.Rows.Count == 0)
    conSpell.Text = string.Empty;

foreach( ... your code )

answered Feb 13, 2014 at 19:19

Dmitriy Khaykin

5,2581 gold badge22 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to handle label as a variable populated with sql query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related