Hello,
It looks like the SQL statement is not correct, and the code is not correct too...
You wrote:
Textname.Text = dr["FirstName"].ToString();
TextLastName.Text = dr["LastName"].ToString();
TextAge.Text = dr[8].ToString();
TextEmailId.Text = dr["EmailId"].ToString();
TextLastName.Text = dr["LastName"].ToString();
This means that the columns FirstName, LastName, EmailId must be fields present in your SQL statement.
And dr[8] means that there are at least 9 elements in your SQL select.
As you wrote "select FirstName from Newuser... " that means there is only 1 element in your SQL statement and it won't work as there are plenty of missing data.
so a way to solve it is to rework your statement:
Select FirstName, LastName, Age, EmailId From Newuser where FirstName ='" + Label1.Text + "'"
and replace
TextAge.Text = dr[8].ToString();
with
TextAge.Text = dr["Age"].ToString();
Assuming there is a column called "Age".
Valery.