francyy的专栏

@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""" "HDR=Yes;" indicates that the first row contains columnnames, not data"IMEX=1;

需要先定义，再使用：                                   string testCase = rdr[0].ToString().Replace(prefix1, "").Replace(prefix2, "").Trim();                                    string target = rdr[1].ToStrin

数据库里的unique字段生成唯一码，用newid() 即可。string SQL_InsertPMTestcases = "INSERT INTO [NTC].[dbo].[PMTestCase]([TestCaseID],[Name],[ID],[Target], [Device]) values"                                           +