how to make auto refresh label?

Question

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?

Vulpes · Answer

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 Lenka · Answer

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 abubakr · Answer

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??

Vulpes · Answer

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 abubakr · Answer

no i want it in c#?

Iftikar Hussain · Answer

Hi Are you looking for in ASP.NET? Regards Iftikar