SqlDataReader dr;
SqlConnection con;
SqlCommand cmd;
public void ShowData()
{
if(dr.Read())
{
TextBox1.Text = dr.GetValue(0).ToString();
TextBox2.Text = dr.GetValue(1).ToString();
TextBox3.Text = dr.GetValue(2).ToString();
TextBox4.Text = dr.GetValue(3).ToString();
}
else
Label7.Text = "Last record of the table............";
}
protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection(@"");
cmd = new SqlCommand("Select * from CUSTOMER", con);
con.Open();
dr=cmd.ExecuteReader();
Label3.Text = dr.GetName(0);
Label4.Text = dr.GetName(1);
Label5.Text = dr.GetName(2);
La ...
Go to the complete details ...