DataGrid that shows relational column value?

  • Thread starter Thread starter Paul W
  • Start date Start date
P

Paul W

I have 2 tables in a DataSet, tlbProducts and tblOrders. The tables are
related using prodID fields. I want to show tblOrders in a DataGrid and
replace the prodID value that is displayed in the grid with the prodDesc
value from tblProducts. My current solution is to create a new field in
tblOrders and use an Expression (dtOrders.Columns("product").Expression() =
"Parent.prodDesc") to get the value. What I don't like is when I use
ds.WriteXml to persist the dataset, the new expression field is included in
the xml file. Another note to point out is that I am using a DataView as
the source for the DataGrid so it reflect any changes made to the data.
Here is some sample code showing what I am currently doing. Is there a
better/easier way?
'build Products table
dtProd = New DataTable("tblProducts")
dtProd.Columns.Add("prodID", GetType(Integer))
'set primary key
dtProd.Columns("prodID").Unique = True
dtProd.PrimaryKey = New DataColumn() {dtProd.Columns("prodID")}
dtProd.Columns("prodID").AutoIncrement = True
dtProd.Columns("prodID").AutoIncrementSeed = 1
dtProd.Columns("prodID").AutoIncrementStep = 1

dtProd.Columns.Add("prodDesc", GetType(String))
dtProd.Columns.Add("listPrice", GetType(Decimal))
ds.Tables.Add(dtProd)

'build orders table
dt1 = New DataTable("tblOrders")
dt1.Columns.Add("orderID", GetType(Int32))
' Set PrimaryKey
dtOrders.Columns("orderID").Unique = True
dtOrders.PrimaryKey = New DataColumn() {dtOrders.Columns("orderID")}
dtOrders.Columns("orderID").AutoIncrement = True
dtOrders.Columns("orderID").AutoIncrementSeed = 1
dtOrders.Columns("orderID").AutoIncrementStep = 1

dtOrders.Columns.Add("custID", GetType(Integer))
dtOrders.Columns.Add("prodID", GetType(Integer))
dtOrders.Columns.Add("soldPrice", GetType(Decimal))
dtOrders.Columns.Add("soldDate", GetType(Date))
'add table to ds dataset
ds.Tables.Add(dtOrders)

'build relationships
ds.Relations.Add("fkProdOrder", ds.Tables("tblProducts").Columns("prodID"),
ds.Tables("tblOrders").Columns("prodID"))
ds.Relations("logVehicles").Nested = False
'add the column name to the table to show the actual product description
dtOrders.Columns.Add("product", GetType(String))
dtOrders.Columns("product").Expression() = "Parent.prodDesc"
 
Paul,

If you do not want particular column to be saved to XML, just set
ColumnMapping property of this column to MappingType.Hidden.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
 
Thanks for the simple answer!

"Ilya Tumanov [MS]" said:
Paul,

If you do not want particular column to be saved to XML, just set
ColumnMapping property of this column to MappingType.Hidden.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
From: "Paul W" <[email protected]>
Newsgroups: microsoft.public.dotnet.framework.compactframework
Subject: DataGrid that shows relational column value?
Lines: 51
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <1Yb%[email protected]>
NNTP-Posting-Host: 12.253.93.209
X-Complaints-To: (e-mail address removed)
X-Trace: rwcrnsc52.ops.asp.att.net 1060981629 12.253.93.209 (Fri, 15 Aug 2003 21:07:09 GMT)
NNTP-Posting-Date: Fri, 15 Aug 2003 21:07:09 GMT
Organization: Comcast Online
Date: Fri, 15 Aug 2003 21:07:09 GMT
Path:
Click to expand...
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!news-out.cwix.com!newsfeed.cwix.com!news.maxwell.syr.edu!wn14feed!worldnet.att.net!204.127.198.203!attbi_feed3
!attbi_feed4!attbi.com!rwcrnsc52.ops.asp.att.net.POSTED!not-for-mail
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.compactframework:31076
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

I have 2 tables in a DataSet, tlbProducts and tblOrders. The tables are
related using prodID fields. I want to show tblOrders in a DataGrid and
replace the prodID value that is displayed in the grid with the prodDesc
value from tblProducts. My current solution is to create a new field in
tblOrders and use an Expression (dtOrders.Columns("product").Expression() =
"Parent.prodDesc") to get the value. What I don't like is when I use
ds.WriteXml to persist the dataset, the new expression field is included in
the xml file. Another note to point out is that I am using a DataView as
the source for the DataGrid so it reflect any changes made to the data.
Here is some sample code showing what I am currently doing. Is there a
better/easier way?
'build Products table
dtProd = New DataTable("tblProducts")
dtProd.Columns.Add("prodID", GetType(Integer))
'set primary key
dtProd.Columns("prodID").Unique = True
dtProd.PrimaryKey = New DataColumn() {dtProd.Columns("prodID")}
dtProd.Columns("prodID").AutoIncrement = True
dtProd.Columns("prodID").AutoIncrementSeed = 1
dtProd.Columns("prodID").AutoIncrementStep = 1

dtProd.Columns.Add("prodDesc", GetType(String))
dtProd.Columns.Add("listPrice", GetType(Decimal))
ds.Tables.Add(dtProd)

'build orders table
dt1 = New DataTable("tblOrders")
dt1.Columns.Add("orderID", GetType(Int32))
' Set PrimaryKey
dtOrders.Columns("orderID").Unique = True
dtOrders.PrimaryKey = New DataColumn() {dtOrders.Columns("orderID")}
dtOrders.Columns("orderID").AutoIncrement = True
dtOrders.Columns("orderID").AutoIncrementSeed = 1
dtOrders.Columns("orderID").AutoIncrementStep = 1

dtOrders.Columns.Add("custID", GetType(Integer))
dtOrders.Columns.Add("prodID", GetType(Integer))
dtOrders.Columns.Add("soldPrice", GetType(Decimal))
dtOrders.Columns.Add("soldDate", GetType(Date))
'add table to ds dataset
ds.Tables.Add(dtOrders)

'build relationships
ds.Relations.Add("fkProdOrder", ds.Tables("tblProducts").Columns("prodID"),
ds.Tables("tblOrders").Columns("prodID"))
ds.Relations("logVehicles").Nested = False
'add the column name to the table to show the actual product description
dtOrders.Columns.Add("product", GetType(String))
dtOrders.Columns("product").Expression() = "Parent.prodDesc"
Click to expand...
Click to expand...
 
Back
Top