am sending code please check it once.
Default.aspx Page:-
My Connection string from Web.config File:-
string conn = ConfigurationManager.ConnectionStrings["SqlConn1"].ToString();
In PageLoad:-
DataTable dt = getData();
lblUserId.Text = dt.Rows[0]["UserId"].ToString();
int count = 0;
Session["dt"] = dt;
Session["count"] = count;
Method:-
public DataTable getData()
{
SqlConnection con = new SqlConnection(conn);
con.Open();
SqlCommand cmd = new SqlCommand("Select * from registration", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
return dt;
}
Next ButtonClick:-
protected void btnNext_Click1(object sender, EventArgs e)
{
if (Session["dt"] != null)
{
DataTable dt = (DataTable)Session["dt"];
int count = (int)Session["count"];
count = count + 1;
lblUserId.Text = dt.Rows[count]["UserId"].ToString();
}
}
Madhu KPosted Nov 25, 2010, 8:56 AM
protected void btnNext_Click1(object sender, EventArgs e)
{
if (Session["dt"] != null)
{
DataTable dt = (DataTable)Session["dt"];
int count = (int)Session["count"];
count = count + 1;
Session["count"] = count;
lblUserId.Text = dt.Rows[count]["UserId"].ToString();
}
}
Guest UserPosted Nov 25, 2010, 8:29 AM
thanks in advance
Madhu KPosted Nov 25, 2010, 8:18 AM
Next ButtonClick:-
protected void btnNext_Click1(object sender, EventArgs e)
{
if (Session["dt"] != null)
{
DataTable dt = (DataTable)Session["dt"];
int count = (int)Session["count"];
count = count + 1;
Session["count"] = count;
lblUserId.Text = dt.Rows[count]["UserId"].ToString();
}
}
Mark as answer if it helped you.