Re: disconnected typed dataset

Thanks Alex

I have had a look into the datagrid, but it only seems to display one table
at a time. In order to display fields from multiple tables on the same row a
new query needs to be performed which combines the tables. This would be OK
for a connected recordset, but for a disconnected dataset this cannot be
achieved since another trip to the database is not possible. I therefore need
some way to get the data out of 2 tables in the dataset into the same row in
the datagrid. Any ideas?

"Alex Passos" wrote:

> Hi Terry, look into using a DataGrid, it has exactly everything you need.
> Just attach the data set to the DataGrid.DataSource member and go from
> there.
>
> Alex
>
> "TLWood" <volvo340@xxxxxxxxxxxxxxxx> wrote in message
> news:3643D60B-9D07-4068-ACA1-D8965BD5E464@xxxxxxxxxxxxxxxx
> > Hi
> >
> > I am creating a multi-user db app in VB.NET 2003 which accesses a remote
> > SQL
> > Server. The db has many tables related hierarchically. At the start of a
> > session I want to get a selected set of data into a dataset, work with it
> > extensively and put it back dealing with any conflicts at this time.
> >
> > My question is, how do I manupulate the data from the dataset to display
> > it?
> > What I really want to do is create a multi-table view of some of the data
> > in
> > the dataset and display it in a datagrid or similar. The normal
> > hierarchical
> > view of data in the datagrid is not user friendly enough - I need to
> > display
> > read-only rows of Customers each having several Addresses (related via IDs
> > from a different table) each in a separate row allowing the user to select
> > a
> > row (Customer/Address pair) and edit it elsewhere.
> >
> > Any help or pointers would be much appreciated.
> >
> > --
> > Many Thanks
> > Terry
>
>
>
.

Relevant Pages

  • disconnected typed dataset
    ... I am creating a multi-user db app in VB.NET 2003 which accesses a remote SQL ... how do I manupulate the data from the dataset to display it? ... the dataset and display it in a datagrid or similar. ... row (Customer/Address pair) and edit it elsewhere. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Extracting subsets of a DataSet
    ... Try it first with that sort on the model column commented out and see what is displayed in your datagrid. ... Regarding the application I am making, it is a Web Form, not a Windows Form. ... I have abandon the DataView idea because what I have read about DataView does not seem to be what I want. ... My goal is to display only, not modify, a subset of those rows based on user input. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Performance issue
    ... I have two queries to make and two data to display in a datagrid. ... first query and first data to display: ... a)query: the user enters some characters, the query selects the rows from ...
    (microsoft.public.sqlserver.ce)
  • Re: Problem with ComboBox
    ... Cor Ligthert [MVP] wrote: ... record from the list) the detail and datagrid will display me the ... I choose them the number on the combobox changes to a number that I ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Problem with ComboBox
    ... What VB version are you using and what complex data control, ... record from the list) the detail and datagrid will display me the ... I choose them the number on the combobox changes to a number that I ...
    (microsoft.public.dotnet.languages.vb)