sumit21 wrote: plz help me. i had made con (oledbconnection) public I tried to help you. To reiterate: your design is awful. When you create a NEW instance of Form1, it's not going to contain any data entered into the instance of Form1 that was on the screen, how can it ? you need to move data access into a seperate class, and if you need data from Form1, you need to store that somewhere, or at least pass it to Form2 on initialisation ( or give Form2 a copy of Form1, if you must, assuming it still exists ). sumit21 wrote: for this i want to use the same connection i had made in form1. This is one more good reason to create a class for database connections, and have it contain a static connection object. Christian I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer