SqlBulkCopy bcp = new SqlBulkCopy(SqlConnectionString); bcp.ColumnMappings.Add("LineUp", "LineupID"); bcp.ColumnMappings.Add("ChannelName", "ChannelName"); bcp.ColumnMappings.Add("ChannelNumber", "ChannelID"); bcp.ColumnMappings.Add("ItemID", "ItemID"); bcp.ColumnMappings.Add("CLUIId", "CLUIId"); bcp.DestinationTableName = "_ChannelLineUp"; bcp.WriteToServer(dv.Table);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)