refLateChargesTableAdapterI am very new to VB .NET and I am having some
trouble. I want to create a DLL file that will house functions that other
systems can call. My major problem is that these functions need to use
tables to do their processing and I want the tables to be in the dll so that
I can distribute the dll to the various networks that are in my company. I
read that DLL files can contain tables as well as code and I have
successfully put tables in the dll project I created but I have no ideal how
to connect to these tables from my functions.

The tables are in a dataset called 'Dataset1'. The first table I am trying
to access is called 'refLateChargesTable'. I don't know what a
connectionstring would look like for these tables.

Any help would be appreciated.

Thanks,

I'm trying to understand what exactly you're trying to do. So far I think
you're trying to use a dataset as a dynamic resource inside a DLL. This I
think isn't possible, although I don't have much experience doing that but I
believe that once a DLL is compiled it is really no longer changeable without
a recompile. So unless you're storing static data, you might need to
reconsider your approach to maybe accessing an XML file or a similar resource
type that is detached from the DLL itself.

You can however add the XML file (or the like) to your setup project to be
deployed alongside your DLL. This way it is guaranteed to be there, next to
your DLL in production.

In case your have a DataSet called MyDataSet here is code you'll need to
write to extract data out of your table.

This example select all rows with a charge over 50 dollars and sorts them by
the charge value descendingly.

Dim MySelectResults As DataRow()
MySelectResults = MyDataSet.Tables("refLateChargesTable").Select("Charge >
50","Charge Desc")

For Each oRow As DataRow In MySelectResults
MsgBox(oRow.Item("ID"))
Next

Also check http://msdn2.microsoft.com/en-us/library/way3dy9w.aspx for
additional examples.

Hope that helps.

--
Mohamad Elarabi
Lead Developer. MCTS, MCPD.


[quoted text, click to view]