I am getting the following error when I try to run a basic data watching program.
Unhandled Exception: System.ArgumentNullException: Value cannot be null.
Parameter name: connectionString
at System.Data.SqlClient.SqlDependency.Start(String connectionString, String queue, Boolean useDefaults)
at SqlDependencyTest.Program.Main(String[] args)
Main code
static void Main()
{
Console.WriteLine("Starting Software");//For debug only
SqlDependency.Start(GlobalVars.RS2Events);
Console.WriteLine("Depend Started";);//for debug only
// Registering for changes...
ConnectForChanges();
Console.WriteLine("Registered");//Delete in end
// Only for testing
Console.WriteLine("Make some changes to the Events table.");
Console.WriteLine("Every time a change happens in this ");
Console.WriteLine("program should be notified.\n");
Console.WriteLine("Hit enter to quit this program.");
Console.ReadLine();
// Quitting...
SqlDependency.Stop(GlobalVars.RS2Events);
}
The key in the app.config file
The variable in GlobalVars
public static string RS2Events = ConfigurationManager.AppSettings.Get("RS2EDB");
NEED HELP PLEASE
解决方案Have you stepped through the debugger ? It''s clear from the error that RS2Events is null, so what have you done to either prove the error is wrong, or to confirm that it is the issue and try to solve it ?