Private Sub frm_getObjectivescore() con.Open() cmd = New SqlClient.SqlCommand("select sum(Value) as T_Count from View_EmployeeApraisalDetails2 Where Apr_No=" & Request("Apr_No") & "", con) dr = cmd.ExecuteReader() If dr.HasRows Then While dr.Read TextBox1.Text = Math.Round(dr("T_Count") * 0.4, 2) End While End If con.Close() End Sub
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)