I'm trying to export data from my database to an excel spreadsheet using bulkcopy.when i run my code it throws "Format of the initialization string does not conform to specification starting at index 0." when it gets to the source connectionString.What am i missing or what am i doing wrong plz help.here is my code
{
_sourceConnectionString = sourceConnectionString;
_destinationConnectionString = destinationConnectionString;
}
source.Open();
copy.DestinationTableName = StudentModule;
copy.WriteToServer(dr);
i call this class under button export.