请教下dataset内主从表的排序问题
Private Sub frmInventoryBalance_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
FormInit()
ds = New DataSet
dtM = New DataTable
dtM.Columns.Add("PurchaseOrder")
dtM.Columns.Add("Supplier")
dtM.Columns.Add("Name")
dtM.Columns.Add("ShortName")
dtM.Columns.Add("OrderDate")
dtM.Columns.Add("DueDate")
dtM.Columns.Add("Customer")
dtM.TableName = "dtM"
ds.Tables.Add(dtM)
dtS = New DataTable
dtS.Columns.Add("PurchaseOrder")
dtS.Columns.Add("Line", System.Type.GetType("System.Double"))
dtS.Columns.Add("StockCode")
dtS.Columns.Add("BrandCode")
dtS.Columns.Add("Description")
dtS.Columns.Add("OrderDate")
dtS.Columns.Add("OrderQty", System.Type.GetType("System.Double"))
dtS.Columns.Add("ReceivedQty", System.Type.GetType("System.Double"))
dtS.Columns.Add("Price")
dtS.Columns.Add("TaxValue", System.Type.GetType("System.Double"))
dtS.Columns.Add("TotalValue", System.Type.GetType("System.Double"))
dtS.Columns.Add("Currency")
dtS.TableName = "dtS"
ds.Tables.Add(dtS)
ds.Relations.Add("Details", dtM.Columns("PurchaseOrder"), dtS.Columns("PurchaseOrder"))
dvm = New DataViewManager(ds)
dv = dvm.CreateDataView(dtM)
GridControl4.DataSource = dv
BestFitGridControlAllViews(GridControl4)
End Sub
请问我现在想对dtM按照purchaseorder、supplier、orderdate排序,请问怎么改变dtm的排序?
数据是在LIST的时候从数据库取的,有些的列是可以编辑的。
dataset vb
[解决办法]
dtM.DefaultView.Sort = "PurchaseOrder desc"
[解决办法]
dtM.DefaultView.Sort = "PurchaseOrder desc"
dtM.DefaultView.Sort = "supplier desc"
dtM.DefaultView.Sort = "Porderdate desc"
参考下 vb2008 入门经典