Create multiple interface class to read data from different file

See more:

VB

.NET

Hello,

I want to create a structure where in I have a source class which has got 2 funtions: GetData() As Datatable and GetSchema() As Datatable. When this functions are called it should accordingly go to one of the interface depending on the type of file selected i.e If CSV selected then go to CSV interface class and get the data and schema reading from the selected CSV file else if ExcelFile is selected then the call to SourceClass.GetData() should go and fetch the data from the Excel Interface class.

All in all what I want to achieve is that a call to SourceClass.GetData would go and fetch the datatable by reading the appropriate file using the appropriate interface class and I dont have to pass any values into it like FileName, FilePath, FileType, HasHeaderRow, Connection String etc... as the interface class would already have all that information to get the data from...

I am quite new and thick to this and would therefore appreciate some kind of example to explain how can I achieve this....

Many Thanks.