sql = "select * from v_" + from.Name.Substring(1, from.Name.Length - 1) + " order by " + from.Name.Substring(1, from.Name.Length - 1) + "ID";
sqlItem= "select * from v_" + from.Name.Substring(1, from.Name.Length - 1) + "Item" + " order by " + from.Name.Substring(1, from.Name.Length - 1) + "ItemID";
DataGridView dv = from.Controls.Find("dataGridView", true)[0] as DataGridView;
DataGridView dvi = from.Controls.Find("dataGridViewItem", true)[0] as DataGridView;
dv.AutoGenerateColumns = false;
dvi.AutoGenerateColumns = false;
DataSet ds = new DataSet();
SqlDataAdapter masterda = new SqlDataAdapter(sql, mydate.Conn);
masterda.Fill(ds, "v_" + from.Name.Substring(1, from.Name.Length - 1));
SqlDataAdapter detailsda = new SqlDataAdapter(sqlItem, mydate.Conn);
detailsda.Fill(ds, "v_" + from.Name.Substring(1, from.Name.Length - 1)+"Item");
DataRelation relation = new DataRelation("ZC",
ds.Tables["v_" + from.Name.Substring(1, from.Name.Length - 1)].Columns[from.Name.Substring(1, from.Name.Length - 1)+"ID"],
ds.Tables["v_" + from.Name.Substring(1, from.Name.Length - 1) + "Item"].Columns[from.Name.Substring(1, from.Name.Length - 1)+"ID"]);
ds.Relations.Add(relation);
dv.DataSource = ds;
dv.DataMember = "v_" + from.Name.Substring(1, from.Name.Length - 1);//設定系結的主表名稱
dvi.DataSource = dv;//設定從表資料源
dvi.DataMember = "ZC";//設定系結的主從表關系名稱
運行提示無法創建欄位 ZC 的子串列
網上找的一個例子復制過來的
uj5u.com熱心網友回復：
我是VS2019 案例好像是2008的怎么修改uj5u.com熱心網友回復：
我都不想看，裹腳布代碼。你應該學習點新的框架技術，別用這種過時的東西。會搞的你腦殼疼
uj5u.com熱心網友回復：
兩層架構，不用寫那么深奧，按照我以前寫DELPHI的邏輯來的，CS模式的 沒那么多要求只要處理資料速度快就可以了
uj5u.com熱心網友回復：
from.Name.Substring(1, from.Name.Length - 1) 等會 我改個通俗易懂的
sql = "select * from v_Order order by OrderID";
sqlItem= "select * from v_OrderItem order by OrderItemID";
DataGridView dv = from.Controls.Find("dataGridView", true)[0] as DataGridView;
DataGridView dvi = from.Controls.Find("dataGridViewItem", true)[0] as DataGridView;
dv.AutoGenerateColumns = false;
dvi.AutoGenerateColumns = false;
DataSet ds = new DataSet();
SqlDataAdapter masterda = new SqlDataAdapter(sql, mydate.Conn);
masterda.Fill(ds, "v_Order");
SqlDataAdapter detailsda = new SqlDataAdapter(sqlItem, mydate.Conn);
detailsda.Fill(ds, "v_OrderItem");
DataRelation relation = new DataRelation("ZC",
ds.Tables["v_Order" ].Columns["OrderID"],
ds.Tables["v_OrderItem"].Columns["OrderID"]);
ds.Relations.Add(relation);
dv.DataSource = ds;
dv.DataMember = "v_Order";//設定系結的主表名稱
dvi.DataSource = dv;//設定從表資料源
dvi.DataMember = "ZC";//設定系結的主從表關系名稱
uj5u.com熱心網友回復：
你把主從表體結構，還有資料呈現的要求，提供詳細一點出來。我給你重新寫一個實作類的方法，如果是雙視圖呈現。其實可以直接用GridControl，而不是調兩個DataGridView。
把需求和呈現結果，要和無明確清楚。這樣思路才清晰
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/283624.html
標籤：C#
上一篇：求大神賜教.net Core開發應用程式的教程和開發實體
下一篇：Orleans框架GetGrain失敗Cannot find an implementation class for grain interface