Newbie Question - DataSet/DataView (DataGrid?)

  • Thread starter Thread starter e_malinger
  • Start date Start date
E

e_malinger

Hello , a newbie question :

Background - I am building a simple application, and since I don't have a
database server I am using XML to store the data and the DataSet.readXml()
to load and save the date. Thus I can't as far as I know use SQL commands.
(If anybody has an idea of a better way to do it , I would be VERY VERY
thankfull!!).

Question - I want to display to the user , a result query from two tables
like :

SELECT Employees.Name Bosses.ID FROM Employees, Bosses WHERE ...

But with DataView.Select() I don't know how to get data from two tables ,
and in DataGrid I also don't know how to display in the same datagrid
data from two tables...
The tables are related child->parent.
Any suggestion how can I do it?
Thanks.
 
The problem with MSDE is that is licensed for development only...
That is why I am opting for XML.
 
As I understand it if you own and use a Microsoft development platform, e.g.
the Office Developers kit, Visual Studio, etc, then you have the right to
redistribute MSDE.

If your doing a shrink rap application the install can be a bit tricky. Also
you could use ADO (oleDb) and MS Access or something like that, unless you
need it to scale to over 20 users it works OK. Then if they have 98SE or
above you don't need to install anything but your program.
 
Back
Top