使用C＃从sql Server检索数据

本文介绍了使用C＃从sql Server检索数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

大家好， 我需要帮助！我正在编写一个从两个不同的表中选择它的编程，但它总是在我运行时显示此错误：''@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.