[pvsunil]

I am running the following code. It executes when the value of variable i is 1 and when the loop continues and value of i becomes 2 i am getting error "Object reference not set to an instance of an object" in the cmdSearch.CommandText line in the code. . There is no problem with connection string. It successfully retrieves when i = 1. Can anybody help me out what is the problem. Please post with corrected code if anybody can help.
===========================================
for (int i=1; i <= objFolder.Items.Count; i++)
{
System.Data.OleDb.OleDbConnection odbSearch = new System.Data.OleDb.OleDbConnection();
System.Data.OleDb.OleDbCommand cmdSearch = new System.Data.OleDb.OleDbCommand();
odbSearch.ConnectionString = strConn;
cmdSearch.Connection = odbSearch;
item = (Outlook.ContactItem) objFolder.Items.Item(i);
string em = item.Email1Address;
cmdSearch.CommandText = "select * from Outlook_Contacts where FirstName='"+fn.ToString().Trim()+"' and LastName='"+ln.ToString().Trim()+"'";
odbSearch.Open();
OleDbDataReader rdrSearch = cmdSearch.ExecuteReader();
while( rdrSearch.Read())
{
RecordFlag = true;
}
odbSearch.Close();
}
===========================================

[ben_]

This error typically means you're trying to access a control that doesn't exist.

What you need to do when you come across this error is go through your code to find what you're referencing that you haven't added to your web/windows form.

In this case I would suggest you look at item andRecordFlag to make sure they're declared somewhere, particularly item.Email1Address.

Also - make sure you close your datareader when you finish as well. Garbage collection will pick it up anyway, but if you re-use the datareader object later in a page/script garbage collection won't get it until it reaches the end of the processing.

rdrSearch.Close();

Ben