"Mike Wilson" <none> wrote in message
news:eYwZc3MEGHA.2080@TK2MSFTNGP10.phx.gbl...
> Dear Group,
>
> I have a heirarchical set of database tables, say - "order" and
"order_type"
> and want to display a series of orders in a grid control, and in place of
> the order_type foreign key identifier, I would like a dropdown combo box
> (lookup from the "order_type" table) to change the type of the order. I
also
> need an update command button, a delete row button and also an insert new
> row button.
>
> I'm sure this is a very common design pattern, although I can't find any
> good tutorials anywhere. Can someone point me in the right direction, as I
> want to get the design pattern right from the very beginning.
>
> Also a couple of specific questions:
>
> 1) If I use a typed dataset with a SQL query to return the rows, and
> databind this to the grid control - how can I override/load the order_type
> column to load a combobox lookup dropdown?
>
> 2) If I use a typed dataset with a SQL query and the relations set, bound
to
> the grid control - how can I change the WHERE clause dynamically at
runtime?
> Since I'm building the dataset at designtime, I can't see how I can
restrict
> the amount of data queried in memory (example: WHERE customer_name =
"bob").
>
> I can do all of the above in ADODc, and with careful use of recordsets;
but
> I'm sure ADO.NET would be faster for this job!
>
> I'm using ADO.NET 2.0, VB2005 (Professional Edtn) and SQL Server Express.
>
> Many thanks for your help!
>
> Mike
>
>

"Mike Wilson" <none> wrote in message
news:O1TD3QSEGHA.3200@tk2msftngp13.phx.gbl...
> "Brad Rogers" <bradz1234.nspam@yahoo.com> wrote in message
> news:48Iuf.3078$Uf7.162@trnddc01...
> > Have you tried the Add New Item and DataForm wizard?
> >
> > So you have a project in vb.net then click File then Add New Item then
> > pick
> > data form wizard.  it will do most of the work for you?
>
> Not yet (didn't realise it was an option) - I will try this..
>
> > Its very easy to connect a datagrid once you have the logical data
sources
> > identified.  You can draw the grid and did you want the drop down list
> > inside grid elements?  Or a separate drop down list?
>
> But I thought that a dataset (a typed one anyway) contains multiple tables
> as seperate objects and their rows as seperate objects - I want a literal
> SET or view which comprises of a whole series of tables (there are about
13
> in all). I'm fairly sure that I can manage to put together something that
> works using a read only view, but I want to be able to "add row" and
"update
> row" - which of course needs to handle referential integrity and work with
> the database contraints.
>
> I want the drop down list inside the grid elements - such that one of the
> columns always displays a drop down list.
>
> Thanks for your help :)
>
> Cheers!
>
> Mike
>
>

> A typed dataset allows you to reference tables and fields directly, by
> name,
> without having to reference the underlying collection.  Typed datasets are
> a
> custom DataSet that derive from the System.Data.DataSet class.
>
> Imports System.Data
> 'statements
> Public Class dsUtility
>          Inherits DataSet
>          'statements
> End Class
>
> But now youre defining your tables in Access?  If you used the Wizard to