Sql查询在Sql Server Management Studio 2014上运行，但在Visual Studio 2013上不起作用
这是查询
在Sql Server Management Studio中
In Sql Server Management Studio
从Speciality，Doctor_Info中选择Speciality_Name，其中Doctor_Info.Speciality_ID = Speciality.Speciality_ID和Doctor_Info.Speciality_ID = 1
select Speciality_Name from Speciality,Doctor_Info where Doctor_Info.Speciality_ID = Speciality.Speciality_ID and Doctor_Info.Speciality_ID = 1
在Visual Studio中
In Visual Studio
"从Speciality，Doctor_Info中选择Speciality_Name，其中Doctor_Info.Speciality_ID = Speciality.Speciality_ID和Doctor_Info.Speciality_ID =' + comboBoxDoctorSSN.Text +''';;
"Select Speciality_Name from Speciality,Doctor_Info where Doctor_Info.Speciality_ID = Speciality.Speciality_ID and Doctor_Info.Speciality_ID = '" + comboBoxDoctorSSN.Text + "'";
任何人都可以解决这个问题吗?
Can anyone please solve the issue?
您需要解释不工作"的含义以及您收到的任何实际错误消息.
You need to explain what you mean by "not working", along with any actual error messages you are getting.
可能还需要一段代码摘录来告诉您您在做什么.
Will probably need a code excerpt as well to tell what you are doing.