compare database value with string value

Question

hi i was compare database value with string value but not working

here is a code

string value=dr["value"].ToString();
if(value=="valid")
{

// statement
}
else
{
// statement
}

here database value also valid
but the code jump to else part...

need solution.. thank you.

Neha Sharma · Answer

HI Please elaborate more your problem like from where you want to compare and with whom?

anji marothu · Answer

thanks parveen sir its working

Pankaj Pandey · Answer

hello mark as answered if it really helped. thanx

anji marothu · Answer

Thank you sir

Jay Parekh · Answer

try this string value=dr[value].ToString(); if(value.Equals( valid  StringComparison.CurrentCultureIgnoreCase)) { // statement } else { // statement }

Pankaj Pandey · Answer

try this dr.Read(); string value=dr[0][value].ToString(); if(value==valid) { // statement } else { // statement } if it works then mark as answered if not then please share youw query and row resulted from database.

Parveen Siwach · Answer

You can try this way: string value= Convert.ToString(dr[value]).Trim().ToUpper(); if(value==VALID) { // statement } else { // statement }