If loop of datareader

[Parul Vinod]

Even though the condition of if loop is true its not going inside if.

int i=0;
str1="select uname from detail";
SqlCommnad cmd=new SqlCommand(str1,cn);
SqlDataReader rd;
rd=cmd.ExecuteReader();
string hold;
hold=UserName.text;//UserName is name of a text box.
while(rd.Read())
{
    if(hold==rd.GetString(i))
    {
         present=true;//Its not coming inside even when 2 values are same
    }
}
 

[Dody]

hi parul,

you may need to trim string variables when you comparing thim

try this

      if(hold.Trim  == rd.GetString(0).Trim)
         {
         present=true;
         }
 

[Parul Vinod]

There were some spaces in case of rd.GetString(i), trim was not working..:(
So i added space in hold and then did the comaprison.
It's working by this way.

[Dody]

good,but the main function of Trim()

is to remove this spaces

sorry i forget to set '()' :( but i expected you get it

try this again :)

      if(hold.Trim() == rd.GetString(0).Trim())
         {
         present=true;
         }
 

i try this example and work

 
            string x="asd         ";
            string y="asd ";
            if(x.Trim() ==y.Trim())
            {
                MessageBox.Show("hiiiiiiiiiii");
            }