Well, not to mention what has already been said, but when I first started learning, I would just download OPEN SOURCE projects i could find on the internet, and just read their code. See how they figured things out and how they handled certain things throughout their application. After doing this to as many as 20 - 30 projects, I really started to get the feel of what is COMMON PLACE and what is not. AS far as your question, i think you answered it yourself:

Tridip Bhattacharjee wrote:

i use those code in try {} catch {} block and show exception related message

As that is what those are meant to be used for. The bigger question is "when should you use them?":confused:

I Fart Ideas every day! It's just only once in a while one does not stink! :)

So, yesterday I got on the elevator on the way to work, when I noticed a young bubbly blond running up just as the doors started to close. I quickly pushed the "Open Doors" button and opened the doors just in time. Smiling from ear to ear as she walked in, she said in her Valley-Girl voice "T-G-I-F". Well, politely, I turned to her and smiled as I replied, "S-H-I-T". Her jaw dropped as she huffed, and then replied "No, it's T-G-I-F". Again, I smiled back and said, "No, S-H-I-T". Now, loosing that bubbly valley girl voice, she intensely looks at me as she says, "No dunbass, it's T-G-I-F, Thank God It's Friday!" as she stomped her foot! Just then the elevator stopped at my floor and the doors opened. I started to get off, as I turned and held the doors with my hand and said to her, "Look Bitch, it's S-H-I-T, Sorry Honey It's Thursday"! TGIF - Have A GREAT WEEKEND!

I'm sorry, I just realized it is a label, not a textbox. Not sure but this may work:

while (i < value)
{
lblCount.Text = lblCount.Text + i.ToString() + "<br/>";
i++;
}

The following code only updates the text with the current value of i through each step of the While Loop. So once the While loop is done, the text will of course be only the LAST value.

while (i < value)
{
lblCount.Text = i.ToString();
lblCount.Show();
i++;
}

If you are wanting the textbox to show each step through the While Loop, then try this:

lblCount.Text.Clear();
while (i < value)
{
lblCount.AppendText = i.ToString() + "\r\n";
i++;
}

If I understand correctly, your issue is that your database only has a DATE value (01/01/2015) But when you try to query the database, the matching variable has the time included (01/01/2015 12:00:00 AM) so the query never finds any matches??? Try this:

DateTime dt1 = Convert.ToDateTime("01/01/2012");
var query = db.Orders.Where(c => c.dt.ToString() == dt1.ToString("d"));