tags:

views:

46

answers:

2
Q: 

Is there any way to access a datasource from one project, in another project?

I have access to a database table that has been added as a datasource in project (A). Is there any way to refer to this database table from project (B) WITHOUT adding it to project (B)'s datasource?

i.e.

ProjB.databasetable.GetDataSetSchema

Any ideas would be really appreciated. Thanks guys!

A: 

The database table is not related to the project A in any way. The project A contains a datasource, probably a DataSet, that is used to access the table.

If you would like to reuse that dataset, just add a reference to ProjectA to ProjectB and ProjectA.MyDataSet will be there for you to use.

Sky Sanders  2010-02-16 08:57:01
Thanks Sky Sanders, i have added that reference previously and have found that it wont let me access the data from the dataset. It only lets me refer to it as a type, and tells me it cannot be used as an expression? Am i missing something blatant here, or just having an off day?!
Craig  2010-02-16 09:07:09
Yea, you are missing something. var ds = new MyDataSet(); then use the tableAdapters to load data. You may have to ensure you have the same connection string element in ProjectB app.config as ProjectA.
Sky Sanders  2010-02-16 09:11:13
Thanks very much. I thought it was something stupid i had missed. Hadnt created a new table adapter! Ta!
Craig  2010-02-16 09:29:56
A: 

The way is to use remote data server and all application will connect to your server.

You can make this with DataAbstract

but you need to rewrite your application.

Hugues Van Landeghem  2010-02-16 09:10:04
dude... really?
Sky Sanders  2010-02-16 09:35:06

related questions

What language do you use for Postgresql triggers and stored procedures?
Are Multiple DataContext classes ever appropriate?
Which tools do people use to create Data Dictionaries?
Any experiences with Protocol Buffers?
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
How do I index a database field
How does database indexing work?
How do I connect to a database and loop over a recordset in C#?
Editing database records by multiple users
Object Oriented vs Relational Databases
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
Embedded Database for .net that can run off a network
Connect PHP to an AS/400
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
.NET Migrations Engine
Is there a version control system for database structure changes?
SQLite and XSD
How do I version my MS SQL database in SVN?
XSD DataSets and ignoring foreign keys
Flat File Databases in PHP
Throw Error In MySQL Trigger
Binary Data in MySQL