Line 1: Incorrect syntax near 'clinicMainsurgery'. (exception occur)

hello sir;

sir, i am sending my database file, my code file , my erd and i am also sending my actual requirement in the form of diagram. please see this and tell me  i am using right approach or not .

hi Sumaira,
can u send back up of ur database?
So that i can help u more.

hello sir;
i remove all single quotes . but there is no data display in my grid and another thing is , there is no exception occur in my code. this is my code after changes. now , i am sending my target diagram. i think , you can better understand what is my needs.

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();
        }

 please help me brothers n sisters

hi,
i have remove single quotes from ur querry.
Plz remove single quotes & check.

Hi,

Replace ur query with foll one:

            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]");