I must have made some mistake in reading as i could not locate the page again but they have suggested some way to handle it through linking excel table in ms-access but forget it this is the simplest way.
And also will increase by class utility, Thanks A LOT
I am not using Sql Client as i want to connect to MS Excel
Are you serious as even on MSDN Site they clearly said that it is not possible to connect to MS Excel using ADO.NET
Presently I am using Connection string that i used to connect with my MS Access files that is through JET 4.0 and...
Can i create update kind of thing when i change my program, Presently I have unistall my earlier version and install new one or other way is mannually coping new file and overwriting existing ones like old Dlls. Please suggest best way out of this.
Thank you to both of you for providing much useful help and support, i know this is very late i am saying this but in between i was too busy as i had to meet 30/9 deadline for 2 projects.
I have worked out the problem as suggested by kulrom
Now i am using datareader for all my dropdown combos...
I Can Not accept the sugession of TechGnome as i can not install altogether new database or ask company to install it so i have to work with MS Access itself.
I feel the slow retriving of data may result because of diconnected architecture of ADO.NET. Where as it is not so with ADODB in VB6
I have made one program just to record timings of workers where i have given them user id and password.
when they sign in teh system the system time gets recorded in to database and same when they sign out.
This program is running on LAN and working properly with VB 6.
When i made use of...