An unhandled exception of type 'System.NullReferenceException' occurred in my_deepot_common.dll

P

Pedro Dinis

i have this class library that connects to the database(see appconfig below)

compiling 0 errors but when its running i amhaving this error

An unhandled exception of type 'System.NullReferenceException' occurred in
my_deepot_common.dll Object reference not set to an instance of an obj

int this line

public System.Data.SqlClient.SqlConnection user_connection = new
System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["my_deepot_common.Properties.Settings.utilizadoresConnectionString"].ConnectionString);

thanks



using System;

using System.Collections.Generic;

using System.Text;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;



namespace my_deepot_common

{

public class DB_Connection

{


public System.Data.SqlClient.SqlConnection user_connection = new
System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["my_deepot_common.Properties.Settings.utilizadoresConnectionString"].ConnectionString);

public System.Data.SqlClient.SqlConnection lang_connection = new
System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["my_deepot_common.Properties.Settings.linguagemConnectionString"].ConnectionString);

public DB_Connection()

{


}




}

}





APP_CONFIG

<connectionStrings>
<add
name="my_deepot_common.Properties.Settings.linguagemConnectionString"
connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=E:\my_deepot\my_deepot_common\Data\linguagem.mdf;Integrated
Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
<add
name="my_deepot_common.Properties.Settings.utilizadoresConnectionString"
connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=E:\my_deepot\my_deepot_common\Data\utilizadores.mdf;Integrated
Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
 
P

Pedro Dinis

the connection string was malformed

public System.Data.SqlClient.SqlConnection user_connection = new
System.Data.SqlClient.SqlConnection("Data
Source=.\\SQLEXPRESS;AttachDbFilename=E:\\my_deepot\\comum\\Data\\utilizadores.mdf;Integrated
Security=True;User Instance=True");
public System.Data.SqlClient.SqlConnection lang_connection = new
System.Data.SqlClient.SqlConnection("Data
Source=.\\SQLEXPRESS;AttachDbFilename=E:\\my_deepot\\comum\\Data\\linguagem.mdf;Integrated
Security=True;User Instance=True");

//public System.Data.SqlClient.SqlConnection user_connection = new
System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["comum.Properties.Settings.utilizadoresConnectionString"].ConnectionString);
//public System.Data.SqlClient.SqlConnection lang_connection = new
System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["comum.Properties.Settings.linguagemConnectionString"].ConnectionString);


Pedro Dinis said:
i have this class library that connects to the database(see appconfig
below)

compiling 0 errors but when its running i amhaving this error

An unhandled exception of type 'System.NullReferenceException' occurred in
my_deepot_common.dll Object reference not set to an instance of an obj

int this line

public System.Data.SqlClient.SqlConnection user_connection = new
System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["my_deepot_common.Properties.Settings.utilizadoresConnectionString"].ConnectionString);

thanks



using System;

using System.Collections.Generic;

using System.Text;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;



namespace my_deepot_common

{

public class DB_Connection

{


public System.Data.SqlClient.SqlConnection user_connection = new
System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["my_deepot_common.Properties.Settings.utilizadoresConnectionString"].ConnectionString);

public System.Data.SqlClient.SqlConnection lang_connection = new
System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["my_deepot_common.Properties.Settings.linguagemConnectionString"].ConnectionString);

public DB_Connection()

{


}




}

}





APP_CONFIG

<connectionStrings>
<add
name="my_deepot_common.Properties.Settings.linguagemConnectionString"
connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=E:\my_deepot\my_deepot_common\Data\linguagem.mdf;Integrated
Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
<add
name="my_deepot_common.Properties.Settings.utilizadoresConnectionString"
connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=E:\my_deepot\my_deepot_common\Data\utilizadores.mdf;Integrated
Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

An unhandled exception of type 'System.NullReferenceException' occurred 3
ResetPassword Requiring passwordAnswer 3
sql server express connection 2
Weird problem with connection strings 3
How change Connection name for Dataset 2
An unhandled exception of type 'System.Messaging.MessageQueueException' occurred 2
The user instance login flag is not supported on this version of S 4
An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in 0

Top