Click here to Skip to main content
13,195,379 members (58,358 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Error Object Refference Null :- I use This Connection
con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\MIS SYSTEM\AniPharmic\AniPharmic\MedicalDb.accdb;Jet OLEDB:Database Password=");



               str = "select *from DatabaseLogin where user_id='" + textBox2.Text + "'";
               com = new OleDbCommand(str, con);
               OleDbDataReader reader = com.ExecuteReader();
               while (reader.Read())

           catch (Exception ex)
               MessageBox.Show(" " + ex);

Posted 26-Feb-13 13:51pm
ryanb31 26-Feb-13 19:53pm
What's the exact error and which line of code is it?
Jibesh 26-Feb-13 20:16pm
Null reference error are easy to catch. run your application and debug mode and put a break point at the code where you find causing the exception thats all. you find the reason for the exception.

If you still have no clue paste the complete exception stack.
Sergey Alexandrovich Kryukov 26-Feb-13 20:27pm
In what line?
Hrushikesh_phapale 27-Feb-13 11:05am
What is the error.?
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You did not show where the exception with the message "Object reference not set to an instance of an object" is thrown.

Not to worry. This is one of the very easiest cases to detect and fix. It simply means that some member/variable of some reference type is dereferenced by using and of its instance (non-static) members, which requires this member/variable to be non-null, but in fact it appears to be null. Simply execute it under debugger, it will stop the execution where the exception is thrown. Put a break point on that line, restart the application and come to this point again. Evaluate all references involved in next line and see which one is null while it needs to be not null. After you figure this out, fix the code: wither make sure the member/variable is properly initialized to a non-null reference, or check it for null and, in case of null, do something else.

Please see also: want to display next record on button click. but got an error in if condition of next record function "object reference not set to an instance of an object"[^].

Good luck,
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

Error is In this Line

4- 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...

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

Advertise | Privacy |
Web03 | 2.8.171019.1 | Last Updated 27 Feb 2013
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