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

Error in my application

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (5)