Search Record Display in DetailsView1

Question

SqlDataAdapter sda = new SqlDataAdapter("select * from student_login", con);

DataTable dt = new DataTable();
sda.Fill(dt);
int c = dt.Rows.Count;

if (dt.Rows[0][4].ToString() == TextBox1.Text)
{
DataTable dt = new DataTable();
sda.Fill(dt);
DetailsView1.DataSource = dt;
DetailsView1.DataBind();

}

when recrod found its show

only 1St record show of the Table.

please help to show column 2 and 3 4 .....ext...

and how to use ISPOSTBACK option.... of this page...

Manas Mohapatra · Answer

Firstly you are creating a DataTable object named dt and again you are creating same DataTable object dt. I am not sure why you are creating two objects with same name and two times. Both dt objects same data. Secondly use IsPostBack like below code: protected void Page_Load(object sender EventArgs e) { if (Page.IsPostBack) { // It will hit when any action happens in page. Implement your logic } else { // It will hit when page loads first time.. Implement your logic } }