An example of SqlBulkCopy

1  Public BOOLInsertall (ilist<newstockluopan>list)2         {3DataTable dt =NewDataTable ();4Dt. Columns.Add ("Stockno",typeof(string));5Dt. Columns.Add ("Angel",typeof(int));6Dt. Columns.Add ("Yesterdayamountin",typeof(decimal));7Dt. Columns.Add ("twodayamountintest",typeof(string));8Dt. Columns.Add ("Yesterday10amountin",typeof(decimal));9Dt. Columns.Add ("tendayamountintest",typeof(string));TenDt. Columns.Add ("CreatedDate",typeof(DateTime)); One  A             foreach(varIteminchlist) -             { -DataRow dr =dt. NewRow (); thedr["Stockno"] =item. Stockno; -dr["Angel"] =item. Angel; -dr["Yesterdayamountin"] =item. Yesterdayamountin; -dr["twodayamountintest"] =item. Twodayamountintest; +dr["Yesterday10amountin"] =item. Yesterday10amountin; -dr["tendayamountintest"] =item. Tendayamountintest; +dr["CreatedDate"] =item. CreatedDate; A  at dt. Rows.Add (DR); -             } -  -             using(SqlBulkCopy sqlbc=NewSqlBulkCopy (connstr)) -             { inSqlbc.destinationtablename ="dbo.table"; -SQLBC.COLUMNMAPPINGS.ADD ("Stockno","Stockno"); toSQLBC.COLUMNMAPPINGS.ADD ("Angel","Angel"); +SQLBC.COLUMNMAPPINGS.ADD ("Yesterdayamountin","Yesterdayamountin"); -SQLBC.COLUMNMAPPINGS.ADD ("twodayamountintest","twodayamountintest"); theSQLBC.COLUMNMAPPINGS.ADD ("Yesterday10amountin","Yesterday10amountin"); *SQLBC.COLUMNMAPPINGS.ADD ("tendayamountintest","tendayamountintest"); $SQLBC.COLUMNMAPPINGS.ADD ("CreatedDate","CreatedDate");Panax Notoginseng sqlbc.writetoserver (DT); -             } the             return true; +}

An example of SqlBulkCopy