Questions

How to use 1 objectvariable for more than 1 class in vb.net 2008

Tags:
+
0 Votes
Locked

How to use 1 objectvariable for more than 1 class in vb.net 2008

pancras
In a program i have a class that does the database interaction (clsSQLs). So if i want to write to a table i call the method:

public MyInst as clsSQLs
sub main
myinst=new clsSQLs
.
.
sub inLotsOfOtherSubs
MyInst.WriteCustomer("ANATR",etc.)

This class is written to communicate with sqlserver through calling stored procedures.
I want to extend the program to use
textFiles and Access in a such a way that through a switch i can let the program talk to SQLServer, Access or textFiles.
I could create 2 extra classes clsText and clsACCESS with the same interface as clsSQLs but with text and Access specific handling.
And then do something like
select case Switch
case "sqlServer"
myinst=new clsSQLs
case "Text"
myinst=new clsText
case "access"
myinst=new clsAcces

How to go about that without losing intellisense?
('public MyInst as object' will probably work, i have not tested that)
Thanks in advance