Posted on: 4/25/2011 11:36:11 PM | Views : 294

Why no matter what result CGPA, wheter <2.0 or > 2.0 also get the same Label message???
 
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Dim connectionstring As String = ConfigurationManager.ConnectionStrings("SKTM_AASConnectionString").ToString() Dim sql As String = "SELECT CAST(SUM(b.course_Point * c.course_Credit) / (SELECT SUM(bb.course_Credit) AS Expr1 FROM result_Details AS aa INNER JOIN course AS bb ON aa.course_Code = bb.course_Code INNER JOIN result_Header AS cc ON cc.result_Header_No = aa.result_Header_No WHERE (cc.student_ID = @sutndet_ID) AND (aa.course_Grade NOT IN ('TD')) AND (aa.countForGrand = 1)) AS decimal(12 , 2)) AS 'cgpa' FROM result_Header AS a INNER JOIN result_Details AS b ON a.result_Header_No = b.result_Header_No AND b.countForGrand = 1 INNER JOIN course AS c ON b.course_Code = c.course_Code WHERE (a.student_ID = @student_ID)" Dim SqlDataSource5 As S ...

Go to the complete details ...