使用C＃从sql Server检索数据 [英] Retrieve Data from sql Server Using C#

问题描述

大家好，



我需要帮助！我正在编写一个从两个不同的表中选择它的编程，但它总是在我运行时显示此错误：''@PayrollNumber'附近的语法不正确......这是我的代码：

Hi everyone,

I need a help ! I am writing a programming that select that from two different tables, but it always show this error when ever i run it: Incorrect syntax near ''@PayrollNumber''....This is my code:

cmd.CommandText = "SELECT PersonalDetails.FirstName, PersonalDetails.MiddleName, PersonalDetails.LastName, offices.Id, offices.Name   FROM PersonalDetail INNER JOIN offices ON (PersonalDetails.@PayrollNumber = offices.PayrollNumber) WHERE (FirstName =  ''" + TextBox6.Text + "'') and (MiddleNam<e = ''" + TextBox7.Text + "'') AND (LastName = ''" + TextBox8.Text + "'')";

推荐答案

您的代码至少包含两个语法错误 - @PayrollNumber和MiddleNam< e 。

对于用户输入，请使用命令参数 [ ^ ]而不是字符串连接。

Your code contains at least two syntactic errors - "@PayrollNumber" and "MiddleNam<e".
For user inputs use Command parameters[^] instead of string concatenation.

这篇关于使用C＃从sql Server检索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！