My data in not displaying in my grid

Dec 18 2011 7:34 AM
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();
        }

Attachment: my target figure.rar

Answers (4)