I have two tables which is doctor and medicalhistory which have relationship with each other. I use outer join to display the doctorname in doctor table instead of the doctorID. Now what I want is to display the Doctor name which have the most record
in a label. See the first image, since Jack have 3 record and John only have 1 record, I would like to display Jack in the label. So the output will be GP: Jack. The label name is called lblGP.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
public partial class member_viewmedicalhistory : System.Web.UI ...
Go to the complete details ...