回车应该怎么转义呢?比如我有两句select 语句
select 1 from POSTLIST;
select 2 from POSTLIST
执行可以返回2个表
但是
select 1 from POSTLIST;select 2 from POSTLIST
就会出错,在c#中发送sql语句的时候应该如何转义?
select 1 from POSTLIST;
select 2 from POSTLIST
执行可以返回2个表
但是
select 1 from POSTLIST;select 2 from POSTLIST
就会出错,在c#中发送sql语句的时候应该如何转义?
LZ看看这吧
http://www.cnblogs.com/Snowfun/archive/2010/09/27/1836400.html
2楼,你\n的问题似乎不能解决问题哦.
这样试一下
上面错了,
select 1 from POSTLIST;chr(10)||chr(13) select 2 from POSTLIST
/// 一次性执行多条语句
/// </summary>
/// <param name="sqlComms">语句的集合</param>
/// <returns>true :成功</returns>
public bool ExecuteMultipleCmd(List<string> sqlComms)
{
Command cmd = this.CreateCommand("", CommandType.Text, null); this.OpenConnection(); bool flag = false;
int row = 0; IDbTransaction tran = conn.BeginTransaction();
cmd.Transaction = tran; try
{
for (int index = 0; index < sqlComms.Count; index++)
{
cmd.CommandText = sqlComms[index]; row += cmd.ExecuteNonQuery();
} tran.Commit();
flag = true;
}
catch (Exception exp)
{
tran.Rollback(); throw exp;
}
finally
{
this.CloseConnection();
} //return ((row == sqlComms.Count) ? true : false); return flag;
}