在每一行增加相同的内容 如何处理字符串,举例nameopenclose如何变成'name'+'open'+'close'+请提供一小段代码,万分感谢。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 String str = @"aaaaa bbbbbb";str = Regex.Replace(str, "([a-zA-Z0-9]+)", @"'$1'+");之后str="'aaaaa'+ 'bbbbbb'+" string name = "name"; string open = "open"; string close = "close"; Regex regex = new Regex("([a-zA-Z0-9]+)");//定义正则表达式,匹配 任意连续的字母和数字(或二者的组合) string replace = @"'$1'+"; //指定替换的模式为 '被捕获的任意连续的字母或数字'+ ($1表示被捕获的字符组1) name = regex.Replace(name, replace); //把name替换成 'name'+ open = regex.Replace(open, replace); close = regex.Replace(close, replace); 我看明白了,但是我的目的是把 [iPassCardID] [int] NOT NULL, [iECardID] [int] NOT NULL, [iECardType] [tinyint] NOT NULL, [iOwnerID] [tinyint] NOT NULL, [iOwnerNetwork] [smallint] NOT NULL, [iOwnerToll] [numeric](9, 4) NOT NULL, [iPassCardNet] [smallint] NULL, [tmEntryDT] [datetime] NULL, [iEntryShift] [tinyint] NULL, [iEntryST_ID] [int] NULL, [iEntryLane] [smallint] NULL, [iEntryToll_ID] [int] NULL, [tmEntryShiftD] [smalldatetime] NULL, [iEntryStatus] [int] NULL, [iEntryVType] [tinyint] NULL, [iEntryNetwork] [smallint] NULL, [fTotalToll] [numeric](9, 4) NULL, [fRebate] [numeric](9, 2) NULL, [iDeviceStatus] [smallint] NULL, [iRecordType] [int] NULL, [iFlagStation] [int] NULL, [iVehiclelicense] [int] NULL, [szOfficelicense] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL, [iTotalWeight] [int] NULL, [iTotalLimit] [int] NULL, [szTicNo] [char](16) COLLATE Chinese_PRC_CI_AS NULL, [iTicStatus] [tinyint] NULL, [iSpare1] [int] NULL, [iSpare2] [int] NULL, [iSpare3] [int] NULL, [iVerifyCode] [int] NULL, [iTransferFlag] [int] NULL, [iExportFlag] [tinyint] NULL, [szBakField1] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL, [szBakField2] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL, [szBakField3] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,这样一组数据库表结构当作一个SQL串来使用,目的是在每一行的前面加’ 每一行的最后加’+ 如此正则表达式改如何写呢,谢谢帮助,万分感谢。 str = "'" + str + "'+"; string str = @"[iPassCardID] [int] NOT NULL, [iECardID] [int] NOT NULL, [iECardType] [tinyint] NOT NULL, [iOwnerID] [tinyint] NOT NULL, [iOwnerNetwork] [smallint] NOT NULL, [iOwnerToll] [numeric](9, 4) NOT NULL, [iPassCardNet] [smallint] NULL, [tmEntryDT] [datetime] NULL, [iEntryShift] [tinyint] NULL, [iEntryST_ID] [int] NULL, [iEntryLane] [smallint] NULL, [iEntryToll_ID] [int] NULL, [tmEntryShiftD] [smalldatetime] NULL, [iEntryStatus] [int] NULL, [iEntryVType] [tinyint] NULL, [iEntryNetwork] [smallint] NULL, [fTotalToll] [numeric](9, 4) NULL, [fRebate] [numeric](9, 2) NULL, [iDeviceStatus] [smallint] NULL, [iRecordType] [int] NULL, [iFlagStation] [int] NULL, [iVehiclelicense] [int] NULL, [szOfficelicense] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL, [iTotalWeight] [int] NULL, [iTotalLimit] [int] NULL, [szTicNo] [char](16) COLLATE Chinese_PRC_CI_AS NULL, [iTicStatus] [tinyint] NULL, [iSpare1] [int] NULL, [iSpare2] [int] NULL, [iSpare3] [int] NULL, [iVerifyCode] [int] NULL, [iTransferFlag] [int] NULL, [iExportFlag] [tinyint] NULL, [szBakField1] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL, [szBakField2] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL, [szBakField3] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL, ";str = Regex.Replace(str, "([^,]+)", "'$1'+");//匹配任意字符串在遇到","时结束匹配组,将之前的匹配替成 '匹配项'+替换后的字符串是'[iPassCardID] [int] NOT NULL'+,' [iECardID] [int] NOT NULL'+,' [iECardType] [tinyint] NOT NULL'+,' [iOwnerID] [tinyint] NOT NULL'+,' [iOwnerNetwork] [smallint] NOT NULL'+,' [iOwnerToll] [numeric](9'+,' 4) NOT NULL'+,' [iPassCardNet] [smallint] NULL'+,' [tmEntryDT] [datetime] NULL'+,' [iEntryShift] [tinyint] NULL'+,' [iEntryST_ID] [int] NULL'+,' [iEntryLane] [smallint] NULL'+,' [iEntryToll_ID] [int] NULL'+,' [tmEntryShiftD] [smalldatetime] NULL'+,' [iEntryStatus] [int] NULL'+,' [iEntryVType] [tinyint] NULL'+,' [iEntryNetwork] [smallint] NULL'+,' [fTotalToll] [numeric](9'+,' 4) NULL'+,' [fRebate] [numeric](9'+,' 2) NULL'+,' [iDeviceStatus] [smallint] NULL'+,' [iRecordType] [int] NULL'+,' [iFlagStation] [int] NULL'+,' [iVehiclelicense] [int] NULL'+,' [szOfficelicense] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL'+,' [iTotalWeight] [int] NULL'+,' [iTotalLimit] [int] NULL'+,' [szTicNo] [char](16) COLLATE Chinese_PRC_CI_AS NULL'+,' [iTicStatus] [tinyint] NULL'+,' [iSpare1] [int] NULL'+,' [iSpare2] [int] NULL'+,' [iSpare3] [int] NULL'+,' [iVerifyCode] [int] NULL'+,' [iTransferFlag] [int] NULL'+,' [iExportFlag] [tinyint] NULL'+,' [szBakField1] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL'+,' [szBakField2] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL'+,' [szBakField3] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL'+,' '+ 上面代码出现了错误把(9,4)也给替换了请改用下面的代码string str = @"[iPassCardID] [int] NOT NULL, [iECardID] [int] NOT NULL, [iECardType] [tinyint] NOT NULL, [iOwnerID] [tinyint] NOT NULL, [iOwnerNetwork] [smallint] NOT NULL, [iOwnerToll] [numeric](9, 4) NOT NULL, [iPassCardNet] [smallint] NULL, [tmEntryDT] [datetime] NULL, [iEntryShift] [tinyint] NULL, [iEntryST_ID] [int] NULL, [iEntryLane] [smallint] NULL, [iEntryToll_ID] [int] NULL, [tmEntryShiftD] [smalldatetime] NULL, [iEntryStatus] [int] NULL, [iEntryVType] [tinyint] NULL, [iEntryNetwork] [smallint] NULL, [fTotalToll] [numeric](9, 4) NULL, [fRebate] [numeric](9, 2) NULL, [iDeviceStatus] [smallint] NULL, [iRecordType] [int] NULL, [iFlagStation] [int] NULL, [iVehiclelicense] [int] NULL, [szOfficelicense] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL, [iTotalWeight] [int] NULL, [iTotalLimit] [int] NULL, [szTicNo] [char](16) COLLATE Chinese_PRC_CI_AS NULL, [iTicStatus] [tinyint] NULL, [iSpare1] [int] NULL, [iSpare2] [int] NULL, [iSpare3] [int] NULL, [iVerifyCode] [int] NULL, [iTransferFlag] [int] NULL, [iExportFlag] [tinyint] NULL, [szBakField1] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL, [szBakField2] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL, [szBakField3] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL, "; str = Regex.Replace(str, @"([^,]+)", "'$1'+"); str = Regex.Replace(str, @"(\d+)[\s]*'[+],'[\s]*(\d+)", "$1,$2");'[iPassCardID] [int] NOT NULL'+,' [iECardID] [int] NOT NULL'+,' [iECardType] [tinyint] NOT NULL'+,' [iOwnerID] [tinyint] NOT NULL'+,' [iOwnerNetwork] [smallint] NOT NULL'+,' [iOwnerToll] [numeric](9,4) NOT NULL'+,' [iPassCardNet] [smallint] NULL'+,' [tmEntryDT] [datetime] NULL'+,' [iEntryShift] [tinyint] NULL'+,' [iEntryST_ID] [int] NULL'+,' [iEntryLane] [smallint] NULL'+,' [iEntryToll_ID] [int] NULL'+,' [tmEntryShiftD] [smalldatetime] NULL'+,' [iEntryStatus] [int] NULL'+,' [iEntryVType] [tinyint] NULL'+,' [iEntryNetwork] [smallint] NULL'+,' [fTotalToll] [numeric](9,4) NULL'+,' [fRebate] [numeric](9,2) NULL'+,' [iDeviceStatus] [smallint] NULL'+,' [iRecordType] [int] NULL'+,' [iFlagStation] [int] NULL'+,' [iVehiclelicense] [int] NULL'+,' [szOfficelicense] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL'+,' [iTotalWeight] [int] NULL'+,' [iTotalLimit] [int] NULL'+,' [szTicNo] [char](16) COLLATE Chinese_PRC_CI_AS NULL'+,' [iTicStatus] [tinyint] NULL'+,' [iSpare1] [int] NULL'+,' [iSpare2] [int] NULL'+,' [iSpare3] [int] NULL'+,' [iVerifyCode] [int] NULL'+,' [iTransferFlag] [int] NULL'+,' [iExportFlag] [tinyint] NULL'+,' [szBakField1] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL'+,' [szBakField2] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL'+,' [szBakField3] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL'+,' '+ 抱歉给楼主带来了麻烦我理解错了,楼主是要每行替换成''+ 包括结尾的","对吧下面代码真正没有问题了string str = @"[iPassCardID] [int] NOT NULL, [iECardID] [int] NOT NULL, [iECardType] [tinyint] NOT NULL, [iOwnerID] [tinyint] NOT NULL, [iOwnerNetwork] [smallint] NOT NULL, [iOwnerToll] [numeric](9, 4) NOT NULL, [iPassCardNet] [smallint] NULL, [tmEntryDT] [datetime] NULL, [iEntryShift] [tinyint] NULL, [iEntryST_ID] [int] NULL, [iEntryLane] [smallint] NULL, [iEntryToll_ID] [int] NULL, [tmEntryShiftD] [smalldatetime] NULL, [iEntryStatus] [int] NULL, [iEntryVType] [tinyint] NULL, [iEntryNetwork] [smallint] NULL, [fTotalToll] [numeric](9, 4) NULL, [fRebate] [numeric](9, 2) NULL, [iDeviceStatus] [smallint] NULL, [iRecordType] [int] NULL, [iFlagStation] [int] NULL, [iVehiclelicense] [int] NULL, [szOfficelicense] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL, [iTotalWeight] [int] NULL, [iTotalLimit] [int] NULL, [szTicNo] [char](16) COLLATE Chinese_PRC_CI_AS NULL, [iTicStatus] [tinyint] NULL, [iSpare1] [int] NULL, [iSpare2] [int] NULL, [iSpare3] [int] NULL, [iVerifyCode] [int] NULL, [iTransferFlag] [int] NULL, [iExportFlag] [tinyint] NULL, [szBakField1] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL, [szBakField2] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL, [szBakField3] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL, "; str = Regex.Replace(str, @"(.+,)", "'$1'+");'[iPassCardID] [int] NOT NULL,'+ '[iECardID] [int] NOT NULL,'+ '[iECardType] [tinyint] NOT NULL,'+ '[iOwnerID] [tinyint] NOT NULL,'+ '[iOwnerNetwork] [smallint] NOT NULL,'+ '[iOwnerToll] [numeric](9, 4) NOT NULL,'+ '[iPassCardNet] [smallint] NULL,'+ '[tmEntryDT] [datetime] NULL,'+ '[iEntryShift] [tinyint] NULL,'+ '[iEntryST_ID] [int] NULL,'+ '[iEntryLane] [smallint] NULL,'+ '[iEntryToll_ID] [int] NULL,'+ '[tmEntryShiftD] [smalldatetime] NULL,'+ '[iEntryStatus] [int] NULL,'+ '[iEntryVType] [tinyint] NULL,'+ '[iEntryNetwork] [smallint] NULL,'+ '[fTotalToll] [numeric](9, 4) NULL,'+ '[fRebate] [numeric](9, 2) NULL,'+ '[iDeviceStatus] [smallint] NULL,'+ '[iRecordType] [int] NULL,'+ '[iFlagStation] [int] NULL,'+ '[iVehiclelicense] [int] NULL,'+ '[szOfficelicense] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,'+ '[iTotalWeight] [int] NULL,'+ '[iTotalLimit] [int] NULL,'+ '[szTicNo] [char](16) COLLATE Chinese_PRC_CI_AS NULL,'+ '[iTicStatus] [tinyint] NULL,'+ '[iSpare1] [int] NULL,'+ '[iSpare2] [int] NULL,'+ '[iSpare3] [int] NULL,'+ '[iVerifyCode] [int] NULL,'+ '[iTransferFlag] [int] NULL,'+ '[iExportFlag] [tinyint] NULL,'+ '[szBakField1] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,'+ '[szBakField2] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,'+ '[szBakField3] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,'+ [分享]写了一个HttpPost压力测试的小工具 急求高手解答C#数据库同步的问题 加100分 C# 的简单的东东我以掌握了,我想学习更核心的技术,请大侠给小弟指点指点!--在线等待 C#中的父子窗口如何实现阿? IIS应用程序池回收Singleton对象导致空引用异常 求解 [简单问题]字符串的正则表达式 如何让VS2005超快 怎么我回答别人问题得来得分数没有加到我的分数上的? 帮忙看看,为什么XmlTextReader.IsEmptyElement判断不出来? OA网络办公系统文档管理 求一些比较正式的软件启动音乐和效果音
string name = "name";
string open = "open";
string close = "close"; Regex regex = new Regex("([a-zA-Z0-9]+)");//定义正则表达式,匹配 任意连续的字母和数字(或二者的组合)
string replace = @"'$1'+"; //指定替换的模式为 '被捕获的任意连续的字母或数字'+ ($1表示被捕获的字符组1)
name = regex.Replace(name, replace); //把name替换成 'name'+
open = regex.Replace(open, replace);
close = regex.Replace(close, replace);
[iPassCardID] [int] NOT NULL,
[iECardID] [int] NOT NULL,
[iECardType] [tinyint] NOT NULL,
[iOwnerID] [tinyint] NOT NULL,
[iOwnerNetwork] [smallint] NOT NULL,
[iOwnerToll] [numeric](9, 4) NOT NULL,
[iPassCardNet] [smallint] NULL,
[tmEntryDT] [datetime] NULL,
[iEntryShift] [tinyint] NULL,
[iEntryST_ID] [int] NULL,
[iEntryLane] [smallint] NULL,
[iEntryToll_ID] [int] NULL,
[tmEntryShiftD] [smalldatetime] NULL,
[iEntryStatus] [int] NULL,
[iEntryVType] [tinyint] NULL,
[iEntryNetwork] [smallint] NULL,
[fTotalToll] [numeric](9, 4) NULL,
[fRebate] [numeric](9, 2) NULL,
[iDeviceStatus] [smallint] NULL,
[iRecordType] [int] NULL,
[iFlagStation] [int] NULL,
[iVehiclelicense] [int] NULL,
[szOfficelicense] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[iTotalWeight] [int] NULL,
[iTotalLimit] [int] NULL,
[szTicNo] [char](16) COLLATE Chinese_PRC_CI_AS NULL,
[iTicStatus] [tinyint] NULL,
[iSpare1] [int] NULL,
[iSpare2] [int] NULL,
[iSpare3] [int] NULL,
[iVerifyCode] [int] NULL,
[iTransferFlag] [int] NULL,
[iExportFlag] [tinyint] NULL,
[szBakField1] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,
[szBakField2] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,
[szBakField3] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,
这样一组数据库表结构当作一个SQL串来使用,目的是在每一行的前面加’ 每一行的最后加’+
如此正则表达式改如何写呢,谢谢帮助,万分感谢。
string str = @"[iPassCardID] [int] NOT NULL,
[iECardID] [int] NOT NULL,
[iECardType] [tinyint] NOT NULL,
[iOwnerID] [tinyint] NOT NULL,
[iOwnerNetwork] [smallint] NOT NULL,
[iOwnerToll] [numeric](9, 4) NOT NULL,
[iPassCardNet] [smallint] NULL,
[tmEntryDT] [datetime] NULL,
[iEntryShift] [tinyint] NULL,
[iEntryST_ID] [int] NULL,
[iEntryLane] [smallint] NULL,
[iEntryToll_ID] [int] NULL,
[tmEntryShiftD] [smalldatetime] NULL,
[iEntryStatus] [int] NULL,
[iEntryVType] [tinyint] NULL,
[iEntryNetwork] [smallint] NULL,
[fTotalToll] [numeric](9, 4) NULL,
[fRebate] [numeric](9, 2) NULL,
[iDeviceStatus] [smallint] NULL,
[iRecordType] [int] NULL,
[iFlagStation] [int] NULL,
[iVehiclelicense] [int] NULL,
[szOfficelicense] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[iTotalWeight] [int] NULL,
[iTotalLimit] [int] NULL,
[szTicNo] [char](16) COLLATE Chinese_PRC_CI_AS NULL,
[iTicStatus] [tinyint] NULL,
[iSpare1] [int] NULL,
[iSpare2] [int] NULL,
[iSpare3] [int] NULL,
[iVerifyCode] [int] NULL,
[iTransferFlag] [int] NULL,
[iExportFlag] [tinyint] NULL,
[szBakField1] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,
[szBakField2] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,
[szBakField3] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,
";str = Regex.Replace(str, "([^,]+)", "'$1'+");//匹配任意字符串在遇到","时结束匹配组,将之前的匹配替成 '匹配项'+
替换后的字符串是'[iPassCardID] [int] NOT NULL'+,'
[iECardID] [int] NOT NULL'+,'
[iECardType] [tinyint] NOT NULL'+,'
[iOwnerID] [tinyint] NOT NULL'+,'
[iOwnerNetwork] [smallint] NOT NULL'+,'
[iOwnerToll] [numeric](9'+,' 4) NOT NULL'+,'
[iPassCardNet] [smallint] NULL'+,'
[tmEntryDT] [datetime] NULL'+,'
[iEntryShift] [tinyint] NULL'+,'
[iEntryST_ID] [int] NULL'+,'
[iEntryLane] [smallint] NULL'+,'
[iEntryToll_ID] [int] NULL'+,'
[tmEntryShiftD] [smalldatetime] NULL'+,'
[iEntryStatus] [int] NULL'+,'
[iEntryVType] [tinyint] NULL'+,'
[iEntryNetwork] [smallint] NULL'+,'
[fTotalToll] [numeric](9'+,' 4) NULL'+,'
[fRebate] [numeric](9'+,' 2) NULL'+,'
[iDeviceStatus] [smallint] NULL'+,'
[iRecordType] [int] NULL'+,'
[iFlagStation] [int] NULL'+,'
[iVehiclelicense] [int] NULL'+,'
[szOfficelicense] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL'+,'
[iTotalWeight] [int] NULL'+,'
[iTotalLimit] [int] NULL'+,'
[szTicNo] [char](16) COLLATE Chinese_PRC_CI_AS NULL'+,'
[iTicStatus] [tinyint] NULL'+,'
[iSpare1] [int] NULL'+,'
[iSpare2] [int] NULL'+,'
[iSpare3] [int] NULL'+,'
[iVerifyCode] [int] NULL'+,'
[iTransferFlag] [int] NULL'+,'
[iExportFlag] [tinyint] NULL'+,'
[szBakField1] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL'+,'
[szBakField2] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL'+,'
[szBakField3] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL'+,'
'+
string str = @"[iPassCardID] [int] NOT NULL,
[iECardID] [int] NOT NULL,
[iECardType] [tinyint] NOT NULL,
[iOwnerID] [tinyint] NOT NULL,
[iOwnerNetwork] [smallint] NOT NULL,
[iOwnerToll] [numeric](9, 4) NOT NULL,
[iPassCardNet] [smallint] NULL,
[tmEntryDT] [datetime] NULL,
[iEntryShift] [tinyint] NULL,
[iEntryST_ID] [int] NULL,
[iEntryLane] [smallint] NULL,
[iEntryToll_ID] [int] NULL,
[tmEntryShiftD] [smalldatetime] NULL,
[iEntryStatus] [int] NULL,
[iEntryVType] [tinyint] NULL,
[iEntryNetwork] [smallint] NULL,
[fTotalToll] [numeric](9, 4) NULL,
[fRebate] [numeric](9, 2) NULL,
[iDeviceStatus] [smallint] NULL,
[iRecordType] [int] NULL,
[iFlagStation] [int] NULL,
[iVehiclelicense] [int] NULL,
[szOfficelicense] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[iTotalWeight] [int] NULL,
[iTotalLimit] [int] NULL,
[szTicNo] [char](16) COLLATE Chinese_PRC_CI_AS NULL,
[iTicStatus] [tinyint] NULL,
[iSpare1] [int] NULL,
[iSpare2] [int] NULL,
[iSpare3] [int] NULL,
[iVerifyCode] [int] NULL,
[iTransferFlag] [int] NULL,
[iExportFlag] [tinyint] NULL,
[szBakField1] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,
[szBakField2] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,
[szBakField3] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,
"; str = Regex.Replace(str, @"([^,]+)", "'$1'+"); str = Regex.Replace(str, @"(\d+)[\s]*'[+],'[\s]*(\d+)", "$1,$2");
'[iPassCardID] [int] NOT NULL'+,'
[iECardID] [int] NOT NULL'+,'
[iECardType] [tinyint] NOT NULL'+,'
[iOwnerID] [tinyint] NOT NULL'+,'
[iOwnerNetwork] [smallint] NOT NULL'+,'
[iOwnerToll] [numeric](9,4) NOT NULL'+,'
[iPassCardNet] [smallint] NULL'+,'
[tmEntryDT] [datetime] NULL'+,'
[iEntryShift] [tinyint] NULL'+,'
[iEntryST_ID] [int] NULL'+,'
[iEntryLane] [smallint] NULL'+,'
[iEntryToll_ID] [int] NULL'+,'
[tmEntryShiftD] [smalldatetime] NULL'+,'
[iEntryStatus] [int] NULL'+,'
[iEntryVType] [tinyint] NULL'+,'
[iEntryNetwork] [smallint] NULL'+,'
[fTotalToll] [numeric](9,4) NULL'+,'
[fRebate] [numeric](9,2) NULL'+,'
[iDeviceStatus] [smallint] NULL'+,'
[iRecordType] [int] NULL'+,'
[iFlagStation] [int] NULL'+,'
[iVehiclelicense] [int] NULL'+,'
[szOfficelicense] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL'+,'
[iTotalWeight] [int] NULL'+,'
[iTotalLimit] [int] NULL'+,'
[szTicNo] [char](16) COLLATE Chinese_PRC_CI_AS NULL'+,'
[iTicStatus] [tinyint] NULL'+,'
[iSpare1] [int] NULL'+,'
[iSpare2] [int] NULL'+,'
[iSpare3] [int] NULL'+,'
[iVerifyCode] [int] NULL'+,'
[iTransferFlag] [int] NULL'+,'
[iExportFlag] [tinyint] NULL'+,'
[szBakField1] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL'+,'
[szBakField2] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL'+,'
[szBakField3] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL'+,'
'+
我理解错了,楼主是要每行替换成''+
包括结尾的","对吧下面代码真正没有问题了string str = @"[iPassCardID] [int] NOT NULL,
[iECardID] [int] NOT NULL,
[iECardType] [tinyint] NOT NULL,
[iOwnerID] [tinyint] NOT NULL,
[iOwnerNetwork] [smallint] NOT NULL,
[iOwnerToll] [numeric](9, 4) NOT NULL,
[iPassCardNet] [smallint] NULL,
[tmEntryDT] [datetime] NULL,
[iEntryShift] [tinyint] NULL,
[iEntryST_ID] [int] NULL,
[iEntryLane] [smallint] NULL,
[iEntryToll_ID] [int] NULL,
[tmEntryShiftD] [smalldatetime] NULL,
[iEntryStatus] [int] NULL,
[iEntryVType] [tinyint] NULL,
[iEntryNetwork] [smallint] NULL,
[fTotalToll] [numeric](9, 4) NULL,
[fRebate] [numeric](9, 2) NULL,
[iDeviceStatus] [smallint] NULL,
[iRecordType] [int] NULL,
[iFlagStation] [int] NULL,
[iVehiclelicense] [int] NULL,
[szOfficelicense] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[iTotalWeight] [int] NULL,
[iTotalLimit] [int] NULL,
[szTicNo] [char](16) COLLATE Chinese_PRC_CI_AS NULL,
[iTicStatus] [tinyint] NULL,
[iSpare1] [int] NULL,
[iSpare2] [int] NULL,
[iSpare3] [int] NULL,
[iVerifyCode] [int] NULL,
[iTransferFlag] [int] NULL,
[iExportFlag] [tinyint] NULL,
[szBakField1] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,
[szBakField2] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,
[szBakField3] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,
"; str = Regex.Replace(str, @"(.+,)", "'$1'+");
'[iPassCardID] [int] NOT NULL,'+
'[iECardID] [int] NOT NULL,'+
'[iECardType] [tinyint] NOT NULL,'+
'[iOwnerID] [tinyint] NOT NULL,'+
'[iOwnerNetwork] [smallint] NOT NULL,'+
'[iOwnerToll] [numeric](9, 4) NOT NULL,'+
'[iPassCardNet] [smallint] NULL,'+
'[tmEntryDT] [datetime] NULL,'+
'[iEntryShift] [tinyint] NULL,'+
'[iEntryST_ID] [int] NULL,'+
'[iEntryLane] [smallint] NULL,'+
'[iEntryToll_ID] [int] NULL,'+
'[tmEntryShiftD] [smalldatetime] NULL,'+
'[iEntryStatus] [int] NULL,'+
'[iEntryVType] [tinyint] NULL,'+
'[iEntryNetwork] [smallint] NULL,'+
'[fTotalToll] [numeric](9, 4) NULL,'+
'[fRebate] [numeric](9, 2) NULL,'+
'[iDeviceStatus] [smallint] NULL,'+
'[iRecordType] [int] NULL,'+
'[iFlagStation] [int] NULL,'+
'[iVehiclelicense] [int] NULL,'+
'[szOfficelicense] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,'+
'[iTotalWeight] [int] NULL,'+
'[iTotalLimit] [int] NULL,'+
'[szTicNo] [char](16) COLLATE Chinese_PRC_CI_AS NULL,'+
'[iTicStatus] [tinyint] NULL,'+
'[iSpare1] [int] NULL,'+
'[iSpare2] [int] NULL,'+
'[iSpare3] [int] NULL,'+
'[iVerifyCode] [int] NULL,'+
'[iTransferFlag] [int] NULL,'+
'[iExportFlag] [tinyint] NULL,'+
'[szBakField1] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,'+
'[szBakField2] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,'+
'[szBakField3] [varchar](16) COLLATE Chinese_PRC_CI_AS NULL,'+