Error in my application

Question

hello everyone; can any one solve my problem.

Satyapriya Nayak · Answer

Hi Sumaira May i know Why you are using single quotes in tables. 'clinicMainsurgery' 'patientsurgery' change it to clinicMainsurgery patientsurgery Use the below code SqlCommand cmd = new SqlCommand(select s.[surgery d]s.[patient surgeryid]s.[surgery name]s.[surgery type id]s.[type name]s.[charges]s.[pv id]s.[patient visit charges] from mainsurgery 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]); Thanks

sumaira manzoor hussain khan · Answer

hello sir ; there is no effect after rename table name; here is my code: protected void Page_Load(object sender EventArgs e) { 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(); //if (!IsPostBack) //{ // load_grid(); //} }

Satyapriya Nayak · Answer

Hi sumaira Please the rename the tables as sp_rename 'main surgery' 'mainsurgery' sp_rename 'patient surgery' 'patientsurgery' While creating any tables dont give any space. After renaming change it as SqlCommand cmd = new SqlCommand(select s.[surgery d]s.[patient surgeryid]s.[surgery name]s.[surgery type id]s.[type name]s.[charges]s.[pv id]s.[patient visit charges] from mainsurgery 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]); Thanks

sumaira manzoor hussain khan · Answer

hello sir ; i am sending my complete meal of error application. regards sumaira manzoor

Satyapriya Nayak · Answer

Hi Sumaira Can you send me the code with your database. Thanks