You may also want to checkout the SqlBulkCopy[^]class if you're using the .NET Framework 2.0 or above. Check to see if it'll fit your requirements first. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Thanks for the reply. I had just reached that conclusion myself, so your reply confirmed my suspicions. I also normally used stored procs so this one off was a new venture!! David Loring !! Keep Music Live !!

You just need to RESEED[^] it. Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... * Reading: Developer Day 5 Ready to Give up - Your help will be much appreciated. My website

Thanks Dave Maybe they get there when VS2005 crashes, as it has done several times, but they just appear to contain a configuration file the contents o which is: They are all itentical. David Loring !! Keep Music Live !!

No problem! It happens to the best of us! :-D Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Thanks very much for your help Dave. David Loring !! Keep Music Live !!

I will have a read. Thanks Ben David Loring !! Keep Music Live !!

Thanks very much Dave. I'll give that a whirl! David Loring !! Keep Music Live !!

Thanks for that. Actually I use Visual Studio 2005, but I have several legacy programs that need to be maintained and occasionally just for some things VB6 is easier.:-D David Loring !! Keep Music Live !!

OK, Thanks Dave. I had thought the re-set bindings did that. I will have another go at it.:) David Loring !! Keep Music Live !!

Dear Its Actually refreshing the whole combobox and this snippet sub works as complete redraw of combobox .Better go for regular properties rather than overriding the class properties. For such if you really want to get proptected properties trhen you are welcome for such query till then try regular properties to get work done like clearing combo :rose: sdfu asgdfsgdfhagsdfhgajsdgfgasd hfasvcjbsvjvhgasjd jgsdfjas bdjfasdhfjavbs jvdfhasgdfhgbashdgfgajs fhgsdhgfjassdfu asgdfsgdfhagsdfhgajsdgfgasd hfasvcjbsvjvhgasjd jgsdfjas bdjfasdhfjavbs jvdfhasgdfhgbashdgfgajs fhgsdhgfjassdfhkjadfhjhjksdhfkjahskjdf hkjahsjkdfhkjashkfakshkhaskghkhagkhadkhgkhgkhaskhsdfu asgdfsgdfhagsdfhgajsdgfgasd hfasvcjbsvjvhgasjd jgsdfjas bdjfasdhfjavbs jvdfhasgdfhgbashdgfgajs fhgsdhgfjassdfu asgdfsgdfhagsdfhgajsdgfgasd hfasvcjbsvjvhgasjd jgsdfjas bdjfasdhfjavbs jvdfhasgdfhgba