Thanks
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.
I have similar query?
I have around 50 Workstations located at different places in Buldg. Is there any way by which my program can automatically takes the updates
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
So...
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...
jmcilhinney No No Not at all,
I am not saying that u should not write any user defined functions, U have too but whereever possible u should use the simple ways that .NET offers...
jmcilhinney Wow thats realy reduce the above code, i think it is much better to use the functions that VB.Net itself offers to u instaed of adding new userdefined one.
great
I have a query i want to provide facility to the user of exporting data from my app to Excel. Is there any way by which i can transfer data from datagrid to Excel or even word.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.