Sql查询在Sql Server Management Studio 2014上运行，但在Visual Studio 2013上不起作用 [英] The Sql query runs on Sql Server Management Studio 2014 but not working on 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.

这篇关于Sql查询在Sql Server Management Studio 2014上运行，但在Visual Studio 2013上不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！