How can we convert sqldataReader to String

Question

hello guys how r u ?

my question is that, i have to convert sqldataReader to string and i tried this code...

cmd.CommandText = "select ppassword from Registration where pemail=@pemail";

cmd.Parameters.Add("@pemail", txtEmail.Text);

reader = cmd.ExecuteReader();

string str = reader.ToString();

Response.Write(str);

but it could not be possible so please guide me and tell me the solution for this.

Thanks.

Reply Soon...

Prabhu Raja · Answer

Hi cmd.CommandText = select ppassword from Registration where pemail=@pemail ; cmd.Parameters.Add( @pemail  txtEmail.Text); reader = cmd.ExecuteReader(); while(reader.Read()) { string str = reader[0].ToString(); //get Value of ppassword Column } Response.Write(str); 0r cmd.CommandText = select ppassword from Registration where pemail=@pemail ; cmd.Parameters.Add( @pemail  txtEmail.Text); reader = cmd.ExecuteReader(); while(reader.Read()) { string str = Convert.ToString(reader.Read()) } Response.Write(str);

Prabhu Raja · Answer

cmd.CommandText = select ppassword from Registration where pemail=@pemail ; cmd.Parameters.Add( @pemail  txtEmail.Text); reader = cmd.ExecuteReader(); while(reader.Read()) { string str = Convert.ToString(reader.Read()) } Response.Write(str); Thank You