John Mekubo

John Mekubo

  • NA
  • 11
  • 2.3k

SQLBulkCopy with FireTrigger Error

Apr 6 2016 9:49 AM
Hi guys. Kindly help fix this issue.
I get the following error while trying to fire sql trigger from asp.net webpage
Format of the initialization string does not conform to specification starting at index 0.
My code is as below: The error is on the last line.
SqlConnection con = new
SqlConnection(ConfigurationManager.ConnectionStrings["warehousedbCon"].ToString());
DataTable dtDispac = (DataTable)ViewState["Dispatches"];
connection();
//creating object of SqlBulkCopy
using (SqlBulkCopy objbulk = new SqlBulkCopy("con", SqlBulkCopyOptions.FireTriggers))

Answers (1)