Hi ,
Try this .
static int n = 0;
DataTable dt ;
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
dt = Bind();
ViewState.Add("dtBind", dt);
Navigate();
}
}
DataTable Bind()
{
SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=test;Integrated Security=True");
string query = "select Item_name from Items where Item_name like '" + TextBox2.Text + "%'";
SqlDataAdapter da = new SqlDataAdapter(query, con);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
private void Navigate()
{
try
{
DataRow dRow = dt.Rows[n];
TextBox2.Text = dRow[0].ToString();
}
catch
{
return;
}
}
protected void NextButton1_Click(object sender, EventArgs e)
{
dt = (DataTable)ViewState["dtBind"];
n = n + 1;
if (n > dt.Rows.Count - 1)
{
return;
}
else
{
Navigate();
}
}
protected void PrevButton2_Click(object sender, EventArgs e)
{
dt = (DataTable)ViewState["dtBind"];
n = n - 1;
if (n == -1)
{
return;
}
Navigate();
}
protected void LastButton3_Click(object sender, EventArgs e)
{
dt = (DataTable)ViewState["dtBind"];
n = dt.Rows.Count - 1;
Navigate();
}
protected void FirstButton4_Click(object sender, EventArgs e)
{
dt = (DataTable)ViewState["dtBind"];
n = 0;
Navigate();
}
Best Regards
M.Mitwalli