My data in not displaying in my grid
ASSALAM-O-ALIKUM BROTHRS N SISTRER;
ABOUT MY REQUIREMENT:
MY REQUIREMENT IS, I WANT TO GET DATA OF "PATIENT SURGERY" N "SURGERY" IN "MAIN SURGERY TABLE". I AM ALSO SENDING MY TARGET FIGURE FOR UNDERSTANDING OF MY NEEDS. IN THE BELOW, I MENTIONED MY CODE. IN THIS I USED JOIN QUERY . BUT THE PROBLEM IS MY DATA IS NOT DISPLAY IN THE GRID.
public void load_grid()
{ SqlCommand cmd = new SqlCommand("select s.[surgery id],s.[patient surgery id],s.[surgery name],s.[surgery type id],s.[type name],s.[charges],s.[pv id],s.[patient visit charges] from clinicMainsurgery s inner join surg su on su.[surgery id]=s.[surgery id] inner join patientsurgery ps on ps.[patient surgery id]=s.[patient surgery id]");
cmd.Connection = Connection.get();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.SelectCommand = cmd;
da.Fill(ds);
GridView_surgery.DataSource = ds;
GridView_surgery.DataBind();
}
protected void Button_sugeries_Click(object sender, EventArgs e)
{
load_grid();
}