using (SqlConnection con = new SqlConnection(consString))
{
using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))
{
//Set the database table name
sqlBulkCopy.DestinationTableName = "PLQualifications";
//[OPTIONAL]: Map the DataTable columns with that of the database table
sqlBulkCopy.ColumnMappings.Add("QualificationId", "QualificationId");
sqlBulkCopy.ColumnMappings.Add("PLQuestionCode", "PLQuestionCode");
sqlBulkCopy.ColumnMappings.Add("LanguageId", "LanguageId");
con.Open();
sqlBulkCopy.WriteToServer(distinctQualifications);
con.Close();
}
}
{
using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))
{
//Set the database table name
sqlBulkCopy.DestinationTableName = "PLQualifications";
//[OPTIONAL]: Map the DataTable columns with that of the database table
sqlBulkCopy.ColumnMappings.Add("QualificationId", "QualificationId");
sqlBulkCopy.ColumnMappings.Add("PLQuestionCode", "PLQuestionCode");
sqlBulkCopy.ColumnMappings.Add("LanguageId", "LanguageId");
con.Open();
sqlBulkCopy.WriteToServer(distinctQualifications);
con.Close();
}
}
No comments:
Post a Comment