Click here to Skip to main content
12,956,234 members (66,532 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
Error is In this Line
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...

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 28-Feb-13 1:02am
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
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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:
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:
con = new OleDbConnection(strConnect);
  Permalink  
Comments
nv3 28-Feb-13 7:16am
   
As simple as that :-) 5.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 3

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="); }

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);
           }
  Permalink  

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

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,869
CHill60 3,550
Maciej Los 3,243
ppolymorphe 2,070
Jochen Arndt 1,973


Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 31 Jul 2015
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100