Problems in VB.net

Question

10/March/2005 Hariom (a word to wish) all I do have some quries. Please help if anyone can > 1) How can i create my own ActiveX control in vb.net? i.e. Navigation control where Fist Record Previous Record Next Record and Last Record buttons are created respectively in a single control. 2) How can i export my database from MS-SQL Server into Oracle 8 or upper ver? 3) How can i compare the database field's value say password with the textbox control in my form? If both are same then only my next form must be ecxecuted otherwise generate the error message as well. Hope for a soon reply. Thanx in advance. Abhishek Maitrey

mibuyt · Answer

Hi You can host ActiveX components on windows form but so sure about creating it. Look at here. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpqstart/html/cpsmpnetsamples-windowsformsactivexhosting.asp But i really can't help much as I has less knowledge on this area. Hope it helps. Cheers.

MythicalMe · Answer

Your first question is easy... you can't create an ActiveX (com) control in the .Net framework. The .Net framework uses CLR (Common Language Runtime) which is a relatively new concept. Microsoft is abandoning ActiveX in favor of CLR because it supports all languages and theoretically any platform (including Linux and Macs). I say theoretically because the .Net framework as far as I know is not officially available on those platforms. I have heard however that a version is being sold that works with the Mac. You can use com controls in VB.Net but it is not really efficient and is only recommended as a last resort. Finally CLR libraries can be registered. Someone else answered your second question so I will answer the third. I can't vouch for Oracle but the best method in SQL Server IMHO is to send the encoded password to a stored procedure that compares the password to a previously encrypted password in the database. For that however you'll need to consult with some heavy duty .Net manuals on how to construct your database adapters etc. (beyond the scope of this forum). However if you're going to use ASP.Net then I would suggest that you tool on over to www.ASP.net and use the tutorials located there. I spent about 6 hours and had all the tutorials completed and a good appreciation for the .Net security structure.

mibuyt · Answer

Hi Regarding your second question. Look into SQL Server 2000 DTS import and export utility! http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_dtswiz_33ll.asp http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_tools_wiz_9e5g.asp Hope it helps.