Hi Sendil, Thanks for your quick reply. The application is similar like - http://www.software.net/[^] Can you please tell me is there any possibility in using web services in similar application scenario :(. While going through some resources i got an info that we can use web services in a scenario where user enters his pin and the system will look into shipping company databases online (databases of shipping companies for various rates for shipping) and then calculate the shipping charge. I don't know how to go ahead with this. But just wanted to share with you. Please let me know your comments.

I am a newbie in .Net, interested in web services application. I am planning to develop an e-commerce solution. The application will have a storefront which will display software products (different categories such as desktop solutions, utilities, editors etc) and users can buy the software product of his choice. I would like to use webservice in my above application. Can anybody help me out how webservices will help in my application? What are the possible scenarios or contexts where webservices can be used in the above application. Really helpful if somebody can provide me an answer in detail. If you require the details of functionalities of the application, i can post it. sunil

fn and ln are declared outside and the values are properly getting passed to those variables. The code executes when i=1 and when the value of i becomes 2 the error occurs. There is no problem with connection string also. only when the code executes to the commandtext line it shows the error. that too i am getting one record successfully(when i = 1). hope this helps

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(); } ===========================================