C#中的语句格式问题

[gpz_dalian]

如果想将如下语句：
string sqlInsert = @"insert into HTPOrderTransaction values("
+ "'" + storeCode + "'" + ","
+ "'" + terminalID + "'" + ","
+ "'" + sequenceNo + "'" + ","
+ "'" + employeeCode + "'" + ","
+ "'" + scheduleDate + "'" + ","
+ "'" + barCode + "'" + ","
+ "'" + quantity + "'" + ","
+ "'" + entryDate + "'" + ","
+ "'" + createDate + "'" + ","
+ "'" + amendDate + "'" + ")";
改写成如下格式：
string sqlSelect = string.Format(@"select StoreCode,TerminalID,SequenceNo from
HTPOrderTransaction where StoreCode = {0}
and TerminalID = '{1}' and SequenceNo = {2}",storeCode,terminalID,sequenceNo);
请教：应该怎么写呢？

[Robert_Wang1983]

string sqlInsert = string.Format("insert into HTPOrderTransaction values('{0}','{1}')",storeID,terminalID);

[icehawk]

string sqlInsert = string.Format("insert into HTPOrderTransaction values('{0}','{1}','{2}','{3}','{4}','5}','{6}','{7}','{8}','{9}')",storeID,terminalID,sequenceNo,employeeCode,scheduleDate ,barCode ,quantity ,entryDate ,createDate , amendDate );

[gpz_dalian]

多谢了！很好用啊

[早起晚睡]

收藏

[kaoziji]

我觉得使用 parameter.add 设置SQL中的参数，可以提高数据库端的效率