I want to count Attendance column and display on textbox

ashwini bhingole

hi,

i want to count Attendancecolumn and display on textbox.i have the following code but it gives error.give me proper code as soon as possible.

public void countattedence()
{
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\SJPDbase.mdb");
con.Open();
OleDbCommand cmd = new OleDbCommand("select count(Attendance) from dbo_Attandances where Emp_Name='" + cmbName.SelectedItem + "'", con);
//SqlDataReader dr;
OleDbDataReader dr;
dr = cmd.ExecuteReader();
while(dr.Read())
{
//int c = Convert.ToInt32( dr["Attendance"]);
txtprd.Text = dr["Attendance"].ToString();
}
con.Close();
}

3 Replies

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

Abdullah Munshi14y ago
Accepted answer
Remove the DataReader code instead try, txtprd.Text= Convert.ToString( cmd.ExecuteScalar());
Jignesh Trivedi14y ago
hi,

change your query to.
select count(Attendance) as Attendance from dbo_Attandances where Emp_Name='name'
and also,

if count is single column record then use executescalar method.

hope this help.
Dhaval Patel14y ago
Dear ashwini

use your change code for count attandance

public void countattedence()
{
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\SJPDbase.mdb");
con.Open();
OleDbCommand cmd = new OleDbCommand("select count(Attendance) as Attendance from dbo_Attandances where Emp_Name='" + cmbName.SelectedItem + "'", con);
//SqlDataReader dr;
OleDbDataReader dr;
dr = cmd.ExecuteReader();
while(dr.Read())
{
//int c = Convert.ToInt32( dr["Attendance"]);
txtprd.Text = dr["Attendance"].ToString();
}
con.Close();
}

change sql query for given allias
but try to use executescalar for that because scalar is better than datareader for single value .

Thanks & regards
Dhaval Patel

This post help you than Mark As Accepted Answer