Binding to a related column

From: Oleg Ogurok (oleg_at_ogurok.com.ihatespammers.ireallydo.co)
Date: 12/16/04

  • Next message: Colin R. R. Johnson: "Re: Autoincrement value.. Why in new row? How do I get the next value?" 
    Date: Wed, 15 Dec 2004 23:39:14 -0500

    Hi all,

    I have a strongly typed dataset with tables:
    Users: ID, First Name, LastName
    Orders: ID, Quantity, UserID

    UserID is related to Users' ID column via a DataRelation.

    I'm binding Orders table to a DataGrid, and one of the columns I need to be
    the First+Last name of the corresponding user.
    How can I accomplish it?

    I tried adding a DataGridColumnStyle and setting MappingProperty to bunch of
    different values but none worked.

    Also, any tutorials on DataGrid are gladly appreciated.
    Thanks.
    -Oleg.

  • Next message: Colin R. R. Johnson: "Re: Autoincrement value.. Why in new row? How do I get the next value?"

    Relevant Pages

    • Related column values
      ... UserID is related to Users' ID column via a DataRelation. ... I'm binding Orders table to a DataGrid, and one of the columns I need to be ... Also, any examples, tutorials on DataGrid are gladly appreciated. ...
      (microsoft.public.dotnet.framework.windowsforms.controls)
    • Re: Related column values
      ... Don't forget to include the "Parent." ... referring a parent table from its child, to refer a child from its parent ... > UserID is related to Users' ID column via a DataRelation. ... > Also, any examples, tutorials on DataGrid are gladly appreciated. ...
      (microsoft.public.dotnet.framework.windowsforms.controls)
    • Re: Changing databound gridview field to hyperlink- need 2 more params
      ... Then in the .vb to get the userID for the sProc rather than ... I am trying to make a databound field in a datagrid link to another page ... and the other is in the datasource and should pass ... Is there a way to reference the URL parameters in the ...
      (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
    • Re: Need to update dataadapter from datagrid that doesnt contain field
      ... Adding a row to the DataGrid ... > populated from a parameterized query. ... > records related to the name (via a userid key field). ... > record to the datagrid and I want to update the database via a dataadapter ...
      (microsoft.public.dotnet.languages.vb)
    • Re: Datagrid question about columns
      ... "Bob Taylor" wrote in message ... I have a datagrid and I have set the datasource property to equal a dataset. ... how do I hide the columns price and userID so that my grid only displays? ...
      (microsoft.public.dotnet.languages.vb)
    Loading