Error in OleDBConnection : Object reference not set to an instance of an object

[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();

}

===========================================

[PlausiblyDamp]

Usually the array items are numbered starting from 0, this means if your array has 2 items then they will be 0 and 1. The .Length property returns the number of items (2 in this case). Try changing the loop start to

for (int i=0; i <= objFolder.Items.Count - 1; i++)