how to make auto refresh label?

honar abubakr

hi friends ... i want to make an auto refresh label to display a row count and auto refresh her self every some seconds? for example i have a table caled student_info it have column caled student_id i ... every student have a student_id ... i want to count number of student_ids in the table (number of students) and display it by a label in the form and every i insert new student the refresh her self and increment the number of students?

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
honar,

You have to add the code I posted to whatever code you're currently using to insert or delete a student from the database. The count shown in the label will then be adjusted without the need to keep getting this from the database.

However, if you'd prefer to get it from the database after each change, then call Sanjeeb's method instead.
Sanjeeb Lenka13y ago
private void GetCount()
{
   string connString = "Your connection string";
     string sql = "SELECT COUNT(student_id) FROM student_info";

   using (SqlConnection conn = new SqlConnection(connString))
   {
      SqlCommand cmd = new SqlCommand(sql, conn);
      try
      {
         conn.Open();
         count = (int)cmd.ExecuteScalar();
      }
      catch (Exception ex)
      {
         MessageBox.Show(ex.Message);
      }
   }

   label1.Text = count.ToString();
}

call this method in Form load, Within Insert new student button click if successfully inserted,

Within Delete student button click if successfully deleted
honar abubakr13y ago
thank you for your answer ... but here the label can not refresh automatically if label = 5 and i delete one student from the table label it is not decrement to 4 automatically??
Vulpes13y ago
If it's Windows Forms, try something like this:

private void Form1_Load(object sender, EventArgs e)
{
string connString = "whatever it is";
int count = 0;
string sql = "SELECT COUNT(student_id) FROM student_info";

using (SqlConnection conn = new SqlConnection(connString))
{
SqlCommand cmd = new SqlCommand(sql, conn);
try
{
conn.Open();
count = (int)cmd.ExecuteScalar();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}

label1.Text = count.ToString();
}

// when you insert a new record use this code:

label1.Text = (int.Parse(label1.Text) + 1).ToString();

// when you delete an existing record use this code:

label1.Text = (int.Parse(label1.Text) - 1).ToString();
honar abubakr13y ago
no i want it in c#?
Iftikar Hussain13y ago
Hi,
Are you looking for in ASP.NET?

Regards,
Iftikar