<div>
Hi Kenny; 
 
What line are you getting the error on? 
 
Fernando
</div>

<div>
myMPI.Sex = MyGlobalVars.sex.ToUpper(); 
&nbsp; 
Last line of that code above: 
&nbsp; 
Also, I forgot to state that I initialize the variable at the beginning of my program: 
 
// Global Variables Class 
internal static class MyGlobalVars 
{ 
// ---- Work Variables 
public static int cnvtnpi; 
public static Guid initGuid; 
public static int dupcounter; 
public static int nondupcounter; 
 
// --- eClinical Patient Table --- 
public static string patacctnum; 
// --- eClinical Doctor Table --- 
public static int docnpi; 
public static string printedname; 
 
// --- eClinical User Table --- 
public static string sex; 
public static string lname; 
public static string fname; 
public static string address; 
public static string city; 
public static string state; 
public static string zip; 
public static string email; 
public static string elgibilitystatus; 
public static string elgibilitymessage; 
public static string ssn; 
public static int cvtssn; 
public static string phone; 
public static DateTime dob; 

</div>

<div>
Hi Kenny; 
Could not find find a reason why you are getting that error. Not sure from the code if the value MyGlobalVars.sex is being set because you only posted the end of the code block, not sure if it is a IF block and the condition was not valid. 
 
&nbsp; &nbsp; MyGlobalVars.ssn = myUser.ssn; 
&nbsp; &nbsp; MyGlobalVars.sex = myUser.sex;-----------Object is assigned Data Here --- 
} 
 
Can you post the rest of that code block or place a break point on this line : 
 
myMPI.Sex = MyGlobalVars.sex.ToUpper(); 
 
and make sure that MyGlobalVars.sex has a value. 
 
Fernando
</div>

<div>
Hi Kenny; 
 
The code below is not doing what you think. You define a query and enumerate over it, the variable userrec holds a single instance of the collection from the query but it is never used in the code. Each iteration of the loop writes to the same variable and so they write over the last iteration leaving the variables set to what ever the last value was. If the query only returns one record then that is fine but then you want to use that record, userrec, &nbsp;to set the value with. See the second if statement for what I think it should be. 
 
Going to call it a night, talk to you tomorrow. 
 
Fernando 

<pre><code class="code-10 nolinks" id="code-261996">var filtereduserlist = from patuser in dceClinicalWorks.users
 where patuser.uid == patient.p.pid
 select new { patuser };
 
foreach (var userrec in filtereduserlist)
{
 //=======================================
 // Here you create a new user with initial values of the contained data type
 // myUser is never initialized but you use it as if it were in this code block.
 user myUser = new user();
 
 // myUser is being used without it being initialized.
 string ssn1 = myUser.ssn;
 ssn1 = myUser.ssn.Sanitize();
 MyGlobalVars.ssn = ssn1;
 MyGlobalVars.sex = myUser.sex;
 MyGlobalVars.phone = myUser.upPhone;
 MyGlobalVars.address = myUser.upaddress;
 MyGlobalVars.city = myUser.upcity;
 MyGlobalVars.state = myUser.upstate;
 MyGlobalVars.zip = myUser.zipcode;
 
 //==========================================================
 // This code is just checking if dt is set to min value and will always
 // be true. You need to change the variable dt to the DateTime variable 
 // you want to check if it is set to min value
 DateTime dt = new DateTime();
 
 if (dt.CompareTo(new DateTime()) == 0)
 {
 // Date is set to min, 1/1/0001 12:00:00 AM
 }
 else
 {
 MyGlobalVars.dob = Convert.ToDateTime(myUser.dob);
 }
 //==============================================================
 
 //========================================
 // These two lines are dups in above code
 MyGlobalVars.ssn = myUser.ssn;
 MyGlobalVars.sex = myUser.sex;
}
 
What it should be.
 
foreach (var userrec in filtereduserlist)
{
 string ssn1 = userrec.ssn;
 ssn1 = userrec.ssn.Sanitize();
 MyGlobalVars.ssn = ssn1;
 MyGlobalVars.sex = userrec.sex;
 MyGlobalVars.phone = userrec.upPhone;
 MyGlobalVars.address = userrec.upaddress;
 MyGlobalVars.city = userrec.upcity;
 MyGlobalVars.state = userrec.upstate;
 MyGlobalVars.zip = userrec.zipcode;
 
 //==========================================================
 // This code is just checking if dt is set to min value and will always
 // be true. You need to change the variable dt to the DateTime variable 
 // you want to check if it is set to min value
 DateTime dt = new DateTime();
 
 if (dt.CompareTo(new DateTime()) == 0)
 {
 // Date is set to min, 1/1/0001 12:00:00 AM
 }
 else
 {
 MyGlobalVars.dob = Convert.ToDateTime(userrec.dob);
 }
 //==============================================================
}
</code></pre>
</div>

<div>
break the code on the line where you assign the value and check to see if 
myUser.sex is null 

</div>

<div>
praveenvenu, 
Yes, it is. 

</div>

<div>
Fernando, 
I understand what you are saying but I am still not totally understanding the problem. &nbsp;I thought I created a query and then was pulling the data from the fields in the query to then initiliaze my global variables with the contents of those fields. &nbsp;I assumed that the record that was found in the query did not have a value in the field for sex. &nbsp;Am I misinterpreting what I thought my code was doing? &nbsp;Am I instatiating the wrong table? &nbsp;I tried using patuser.sex but know fields come up in intelliesense for patuser when I typed patuser.. 
Thanks 
Kenny 
&nbsp; 
 

<pre><code class="code-10 nolinks" id="code-262484">//--------- Lookup Information from User Table ---------
 var filtereduserlist = from patuser in dceClinicalWorks.users
 where patuser.uid == patient.p.pid
 select new { patuser };
 
 foreach (var userrec in filtereduserlist)
 {
 user myUser = new user();
 
 
 
 string ssn1 = myUser.ssn;
 ssn1 = myUser.ssn.Sanitize();
 MyGlobalVars.ssn = ssn1;
 MyGlobalVars.sex = myUser.sex;
 MyGlobalVars.phone = myUser.upPhone;
</code></pre>
</div>

<div>
Fernando, 
You were right. &nbsp;I did not realize I was initialize the variable incorrectly. &nbsp;Here was the correct method. 
 
&nbsp;//--------- Lookup Information from User Table &nbsp;--------- 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var filtereduserlist = from patuser in dceClinicalWorks.users 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;where patuser.uid == patient.p.pid 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;select new { patuser }; 
 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach (var userrec in filtereduserlist) 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; { 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string ssn1 = userrec.patuser.ssn; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ssn1 = userrec.patuser.ssn.Sanitize(); 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MyGlobalVars.ssn = ssn1; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MyGlobalVars.sex = userrec.patuser.sex; 
Thanks 
Kenny 

</div>

<div>
Hi Kenny; 
 
Not sure what you are misunderstanding but let me explain the code you have posted in your last post. 
 
Lines 1 - 3 Is a Linq to SQL query. All Linq queries no matter what technologu, Linq to Object, Linq to SQL, Linq to XML, ... is what is known as deferred query execution, meaning that when the run-time executes lines 1 - 3 nothing happens except that the query is created but NOT executed. The query gets executed when the run-time enumerates through the created query and in this sample code that begins on line 4 in the foreach loop. The first parameter in the foreach loop, userrec, will be the current single instance from the collection of items in the filtereduserlist collection. In each iteration of the foreach loop userrec will become the next record in the collection of filtereduserlist. Line 6 is where the problem comes in. You create a new instance of a class called user which is most likely a single instrance of a row in the user table. In Line 6 the system instantiates a object of user with all it fields set to default values. A default value for a reference type such as String is null a default for an integer is 0. Then you do nothing else with the object user except load the variables in the class MyGlobalVars with those default values. In each iteration of the foreach loop the variable patuser holds an instance of a users record from the DB and because of the Where clause in line 2 the query most likely returns one record, but nothing is done with the return values. That is why in my last post I told you to use userrec in place of user and remove user altogether from the foreach loop. 
 
01 var filtereduserlist = from patuser in dceClinicalWorks.users 
02 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;where patuser.uid == patient.p.pid 
03 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;select new { patuser }; 
 
04 foreach (var userrec in filtereduserlist) 
05 { 
06 &nbsp; &nbsp; user myUser = new user(); 
07 
08 &nbsp; 
08 
09 &nbsp; &nbsp; string ssn1 = myUser.ssn; 
10 &nbsp; &nbsp; ssn1 = myUser.ssn.Sanitize(); 
11 &nbsp; &nbsp; MyGlobalVars.ssn = ssn1; 
12 &nbsp; &nbsp; MyGlobalVars.sex = myUser.sex; 
13 &nbsp; &nbsp; MyGlobalVars.phone = myUser.upPhone; 
 
I hope that make some sense; 
 
Fernando
</div>

<div>
<div class="content wysiwyg-content">
I am trying to assign a field in a table a value. &nbsp;I keep getting this error message even when I have assigned the object a variable. &nbsp;What am I missing? 
 
 

<pre><code class="code-10 nolinks" id="code-261954">MyGlobalVars.ssn = myUser.ssn;
 MyGlobalVars.sex = myUser.sex;-----------Object is assigned Data Here ---
 }
 //------------- Got dob, ssn, and sex --------------------
 
 
 //--------- Lookup Information from PatientInfo Table ---------
 var filteredpatinfolist = from patinfo in dceClinicalWorks.patientinfos
 where patinfo.pid == patient.p.pid
 select new { patinfo };
 
 foreach (var patinforec in filteredpatinfolist)
 {
 patientinfo myPatinfo = new patientinfo();
 // Put variables here
 
 }
 //---
 
 
 
 Console.WriteLine(String.Format(&quot;{0},{1},{2}&quot;, patient.p.pid, patient.p.ControlNo, patient.p.employername));
 Console.ReadLine();
 
 
 
 // ------- Instantiate Chart Relay Tables to Write To
 MPI myMPI = new MPI();
 PATIENT myCRpatient = new PATIENT();
 PATIENT_PHONE_NUMBER myPatPhones = new PATIENT_PHONE_NUMBER();
 Patient_Address myPatAddresses = new Patient_Address();
 PATIENTS_ATTENDED_BY_DOCTOR myPatAttByDoc = new PATIENTS_ATTENDED_BY_DOCTOR();
 PATIENT_IN myPatIns = new PATIENT_IN();
 EMPLOYER myPatEmployers = new EMPLOYER();
 BillingAlert myPatBillAlerts = new BillingAlert();
 EligibilityStatus myPatElgStatus = new EligibilityStatus();
 
 
 
 
 
 // =================== Collect MPI Table Information ===================
 //
 //
 MyGlobalVars.initGuid = Guid.NewGuid();
 myMPI.MPI1 = MyGlobalVars.initGuid;
 myMPI.NPI = MyGlobalVars.docnpi;
 myMPI.ModifiedDate = DateTime.Today;
 
 int myPatAcctNum;
 if (Int32.TryParse(patient.p.pid.ToString(), out myPatAcctNum))
 {
 // Success! myInt now contains the numeric value of myString
 myMPI.EntitySystemAcctNum = myPatAcctNum.ToString();
 MyGlobalVars.patacctnum = myPatAcctNum.ToString();
 }
 else
 {
 // Failed! MyInt is not defined.
 }
 
 myMPI.EntitySystemModifiedDate = DateTime.Today;
 myMPI.SYSTEM_TYPE = &quot;eClinicalWorks&quot;;
 myMPI.DOB = MyGlobalVars.dob;
 myMPI.SSN = MyGlobalVars.ssn;
 myMPI.Sex = MyGlobalVars.sex.ToUpper(); ---------- Error Occurs Here ------
</code></pre>
</div>
</div>

I am trying to assign a field in a table a value.  I keep getting this error message even when I have assigned the object a variable.  What am I missing?



Object reference not set to an instance of an object.

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,