show sql query result in label

Question

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

Ramesh Maruthi · Answer

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(); } }

Vulpes · Answer

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();

Hussain Ahmed · Answer

Thanks to all of u!

Abhishek Singh · Answer

Hi Result can be displayed using label control. Label1.Text=Lkomut Abhishek