show sql query result in label

Hussain Ahmed

string komut = "select SUM(DATEPART(hh, CAST([TimeIn] AS DATETIME))) + ( SUM(DATEPART(MINUTE, CAST([TimeIn] AS DATETIME))) / 60 ) + ( SUM(DATEPART(MINUTE, CAST([TimeIn] AS DATETIME))) % 60 + ( SUM(DATEPART(SECOND, CAST([TimeIn] AS DATETIME))) / 60 ) ) / 60 from hr.Attendance_new A INNER JOIN hr.Employee B ON A.EmployeeNo=B.EmpID where A.EmployeeNo='" + (user.EmployeeID.ToString()) + "' AND Year(A.DateIn) like '%'+'" + DateTime.Now.Year.ToString()+ "'+'%' group by A.EmployeeNo";

how to show this query result in label .this query calculate total hour and work fine but i want to show this query result in label .plz help me

4 Replies

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

Hussain Ahmed12y ago
Thanks to all of u!
Ramesh Maruthi12y ago
string ConnectionString = ConfigurationManager.ConnectionStrings["yourconnection"].ConnectionString;

string komut = "select SUM(DATEPART(hh, CAST([TimeIn] AS DATETIME))) + ( SUM(DATEPART(MINUTE, CAST([TimeIn] AS DATETIME))) / 60 ) + ( SUM(DATEPART(MINUTE, CAST([TimeIn] AS DATETIME))) % 60 + ( SUM(DATEPART(SECOND, CAST([TimeIn] AS DATETIME))) / 60 ) ) / 60 from hr.Attendance_new A INNER JOIN hr.Employee B ON A.EmployeeNo=B.EmpID where A.EmployeeNo='" + (user.EmployeeID.ToString()) + "' AND Year(A.DateIn) like '%'+'" + DateTime.Now.Year.ToString()+ "'+'%' group by A.EmployeeNo";

using (SqlConnection con = new SqlConnection(ConnectionString )) {
using (SqlCommand cmd = new SqlCommand(kmout, con)) {
var result = cmd.ExecuteScalar();
label1.Text = result.ToString();
}
}
Abhishek Kumar12y ago
Hi,

Result can be displayed using label control.

Label1.Text=Lkomut

Abhishek
Vulpes12y ago
If the database is SQL Server, the code will be along the following lines:

var cmd = new SqlCommand(komut, conn); // where 'conn' is SqlConnection object
double result = (double)cmd.ExecuteScalar();
label1.Text = result.ToString();