Click here to Skip to main content
15,358,707 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);
   
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);
           }
   

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