Click here to Skip to main content
15,867,568 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Error is In this Line
VB
con.Open();

Error is :- Cannot open Connection:System.NullReferenceException:Object Reference Not
set to an instance of an object.

its not problem in other form its only prroblem in this code...

C#
try
{
    con.Open();
    str = "select *from DatabaseLogin where user_id='" + textBox2.Text + "'";
    com = new OleDbCommand(str, con);
    OleDbDataReader reader = com.ExecuteReader();
    while (reader.Read())
    {
        checkedListBox1.Items.Add(reader["stckdemge"]);
    }
}
catch (Exception ex)
{
    MessageBox.Show(" " + ex);
}
Posted
Updated 28-Feb-13 1:10am
v2
Comments
S.P.Tiwari 28-Feb-13 7:08am    
where u created connection object? and assign the connection string. give more details..
kashifjaat 28-Feb-13 21:38pm    
OleDbConnection cn;
public ExpireProduct()
{
InitializeComponent();

cn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\MIS SYSTEM\AniPharmic\AniPharmic\MedicalDb.accdb;Jet OLEDB:Database Password=");

}

this connection string I use ....But my problem not solve

The error message is pretty clear:
Object Reference Not set to an instance of an object.

Since it occurs on a line as simple as this:
C#
con.Open();
it can only be one thing: the variable con has been declared, but you have not assigned a value to it - hence, it is null

At some point before this code, you need to execute something like:
C#
con = new OleDbConnection(strConnect);
 
Share this answer
 
Comments
nv3 28-Feb-13 7:16am    
As simple as that :-) 5.
you had made "cn" as connection object
and you use "con", how would it works.

You should write..

OleDbConnection con;
public ExpireProduct() { InitializeComponent();
con= new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\MIS SYSTEM\AniPharmic\AniPharmic\MedicalDb.accdb;Jet OLEDB:Database Password="); }

C#
try
           {
               con.Open();
               str = "select *from DatabaseLogin where user_id='" + textBox2.Text + "'";
               com = new OleDbCommand(str, con);
               OleDbDataReader reader = com.ExecuteReader();
               while (reader.Read())
               {
                   checkedListBox1.Items.Add(reader["stckdemge"]);
               }
con.Close();
           }
           catch (Exception ex)
           {
               MessageBox.Show(" " + ex);
           }
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900