以下是查询时的语句:
sqlSelect = @"select StoreCode,TerminalID,SequenceNo from HTPOrderTransaction"
+ " where StoreCode = " + storeCode
+ " and TerminalID = '" + terminalID
+ "' and SequenceNo = " + sequenceNo;
以下是插入时的语句:
sqlInsert = @"insert into HTPOrderTransaction values("
+ "'" + storeCode + "'" + ","
+ "'" + terminalID + "'" + ","
+ "'" + sequenceNo + "'" + ","
+ "'" + employeeCode + "'" + ","
+ "'" + scheduleDate + "'" + ","
+ "'" + barCode + "'" + ","
+ "'" + quantity + "'" + ","
+ "'" + entryDate + "'" + ","
+ "'" + createDate + "'" + ","
+ "'" + amendDate + "'" + ")";
问:
我看不大懂上边的语句格式,请教高手给指点一下,其中的单引号和双引号的作用希望给解释一下!多谢了!!!
sqlSelect = @"select StoreCode,TerminalID,SequenceNo from HTPOrderTransaction"
+ " where StoreCode = " + storeCode
+ " and TerminalID = '" + terminalID
+ "' and SequenceNo = " + sequenceNo;
以下是插入时的语句:
sqlInsert = @"insert into HTPOrderTransaction values("
+ "'" + storeCode + "'" + ","
+ "'" + terminalID + "'" + ","
+ "'" + sequenceNo + "'" + ","
+ "'" + employeeCode + "'" + ","
+ "'" + scheduleDate + "'" + ","
+ "'" + barCode + "'" + ","
+ "'" + quantity + "'" + ","
+ "'" + entryDate + "'" + ","
+ "'" + createDate + "'" + ","
+ "'" + amendDate + "'" + ")";
问:
我看不大懂上边的语句格式,请教高手给指点一下,其中的单引号和双引号的作用希望给解释一下!多谢了!!!
解决方案 »
- C# 调用excel中的宏
- 关于调用 AJAX.dll 的问题?
- 一个入门级问题.60分在线等(VSTO)
- 将CS文件编译成DLL文件出错
- RichTextBox的ContexMenu属性在哪设置
- 看不懂一个奇怪的正则表达式:"/favorite\/(\d|\w|\s)+\.aspx/rss$"
- 请各位大虾进来帮忙看怎么在.net中实现FTPS文件上传
- winform 我把SWF文件通过"添加现有项"--嵌入式文件,如何播放FLASH?
- 面试的时候遇到的问题
- VS2010开发的C#项目,如何新建一个工程
- 超级难题! RTF可以分栏吗?
- 请问到哪里能下到O/RMapping框架,还有自动生成代码工具,要免费的免注册的?
双引号是c#中来区分字符串的
另外,双引号是用来连接字符串的,
单引号:SQL语句中的对字符型数据必须使用单引号括起来。
其中,你的Values段中,有几个数字型字段,是可以不使用单引号括起来的。
string sqlSelect = string.Format("select StoreCode,TerminalID,SequenceNo from TPOrderTransaction where StoreCode = '{0}'and TerminalID = '{1}'and SequenceNo = '{2}'",storeCode,terminalID,sequenceNo);