Error in my application

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

hello sir ;

there is no effect after rename table name; here is my code:

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

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

regards
sumaira manzoor

Hi Sumaira,


Can you send me the code with your database.



Thanks