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 RajaPosted Oct 5, 2011, 2:26 AM
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 RajaPosted Oct 5, 2011, 2:30 AM
cmd.Parameters.Add("@pemail", txtEmail.Text);
reader = cmd.ExecuteReader();
while(reader.Read())
{
string str = Convert.ToString(reader.Read())
}
Response.Write(str);
Thank You