 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / .NET Framework / New Users / July 2006ADO.NET in VB6
May ADO.NET be used in VB6 ? I'm not asking about using it in DLL created in VB.NET or C# and then DLL is used in VB6. I'm asking about direct using. I need some of ADO.NET features, which are not available in a traditional ADO, and I need them in VB6 project. Thank you Al Hello vul, Unfortunately no. You could wrap ADO.NET in a COM wrapper, but that would be a nightmare. WHat features? Perhaps there is an ADO way of doing what you need... Thanks, Shawn Wildermuth Speaker, Author and C# MVP http://adoguy.com > May ADO.NET be used in VB6 ? > I'm not asking about using it in DLL created in VB.NET or C# and then [quoted text clipped - 5 lines] > Thank you > Al I have 10 ADO recordsets in VB6 program. All of them should be edited on Pocket PC, then edited data should be returned into SQL Server. It looks like pretty easy task via : 1. create ADO.Net dataset, containing all those data, 2. save it as a single XML file, 3. sending to Pocket PC user, 4. User makes changes via VB 2005 program and saves them 5. Send updated XML back 6. Populate ado.net dataset by opening XML 7. Save data back to SQL With a standard ADO I do not see such an easy solution. There are some other problems with creating DLL in VB 2005 working with VB 6, but I already almost did that part. Maybe I'll meet some other problems Al > Hello vul, > [quoted text clipped - 16 lines] >> Thank you >> Al I think it would be easier from VB6 to just manipulate the XML document. >I have 10 ADO recordsets in VB6 program. All of them should be edited on >Pocket PC, then edited data should be returned into SQL Server. [quoted text clipped - 33 lines] >>> Thank you >>> Al If you are using SQL Server for the backend, why make the end run around merge replication? Let the server do all the heavy lifting. It takes about a page of code to set up merge on the PocketPC. >I have 10 ADO recordsets in VB6 program. All of them should be edited on >Pocket PC, then edited data should be returned into SQL Server. [quoted text clipped - 33 lines] >>> Thank you >>> Al Al, As you ask the question than the answer is simple "No" Cor > May ADO.NET be used in VB6 ? > I'm not asking about using it in DLL created in VB.NET or C# and then DLL [quoted text clipped - 4 lines] > Thank you > Al > I'm not asking about using it in DLL created in VB.NET or C# and then DLL is > used in VB6. Actually, yes you are. ADO.NET is a DLL called System.Data.dll and a few other dlls. As Cor says, the answer is NO. However, if you want to use ADO.NET, then you would need the .NET framework on the PC, in which case, why not do it all in .NET? Otherwise, just stick to your plan from before, except use VB6 to parse the returned XML and reconstruct it. Or write your own EXE in .NET that accepts the XML, and returns an ADO recordset. Then continue on with your VB6 app.
Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.