Hi,
   I am designing a 3 tier application in VB.NET using a DLL in the
business logic layer for actual database connectivity and data transfer.

I would like the DLL to take the call for establishing the connectivity from the solution file and after successfull connection, return a dataset of the actual query specified in the DLL.

The controls on the project solution file just need to set
the datasource to the returned dataset (most preferably via XML file).

So how do i do this.
You can just brief me in short abt the process with short code
bytes for clarification.

Thanks and waiting for ur reply.

OMKAR GHAISAS.

You seem to have a pretty good understanding of what you'd like to do... what part of it specifically are you having a problem with? If it's general information you are after, there are numerous resources available online that can provide you with the basic understanding of querying a database and returning the data as you would like it.

Hi,
   I mean to say U may just list the steps that I shld follow.

like first create a class, then so and so method for actually receiving data and so on.

If u can jsu brief me abt the whole process i will be highly thankful.

Waiting for ur constructive reply.
Thanks and best regards.

Omkar Ghaisas