兩張沒有關聯的資料A,B。想把查詢結果硬性的拼接在一下，A表3列資料，B表資料作為第四列顯示；下面這個效果
應該怎么做呢？c#代碼
this.d_xs.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
this.d_xs.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//表格A資料
string sql_str = "SELECT sum(總聯帶金額) as AA,sum(訂單聯帶筆數) as BB FROM 聯帶銷售統計表 WHERE 業種='名品靴鞋業種'" +
"UNION ALL SELECT sum(總聯帶金額) as AA, sum(訂單聯帶筆數) as BB FROM 聯帶銷售統計表 WHERE 業種='淑女裝業種'" +
"UNION ALL SELECT sum(總聯帶金額) as AA, sum(訂單聯帶筆數) as BB FROM 聯帶銷售統計表 WHERE 業種='少女裝業種'" +
"UNION ALL SELECT sum(總聯帶金額) as AA, sum(訂單聯帶筆數) as BB FROM 聯帶銷售統計表 WHERE 業種='男裝童玩業種'" +
"UNION ALL SELECT sum(總聯帶金額) as AA, sum(訂單聯帶筆數) as BB FROM 聯帶銷售統計表 WHERE 業種='運動休閑業種'" +
"UNION ALL SELECT sum(總聯帶金額) as AA, sum(訂單聯帶筆數) as BB FROM 聯帶銷售統計表 WHERE 業種='家居生活業種'";
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Data_tg.mdb");
OleDbCommand cmd = new OleDbCommand(sql_str, conn);
conn.Open();
find_do = new OleDbDataAdapter();
find_do.SelectCommand = cmd;
ds = new DataSet();
find_do.Fill(ds, "rs");
//this.d_xs.DataMember = "rs";
d_xs.RowHeadersWidth = 150;
DataTable dataTable = ds.Tables["rs"];
DataRow dataRows;
dataRows = dataTable.NewRow();
dataRows[0] = dataTable.Compute("Sum(AA)", "true");
dataRows[1] = dataTable.Compute("Sum(BB)", "true");
dataTable.Rows.Add(dataRows);
this.d_xs.DataSource = dataTable;
d_xs.TopLeftHeaderCell.Value = "業種名稱";
d_xs.Rows[0].HeaderCell.Value = "名品靴鞋業種";
d_xs.Rows[1].HeaderCell.Value = "淑女裝業種";
d_xs.Rows[2].HeaderCell.Value = "少女裝業種";
d_xs.Rows[3].HeaderCell.Value = "男裝童玩業種";
d_xs.Rows[4].HeaderCell.Value = "運動休閑業種";
d_xs.Rows[5].HeaderCell.Value = "家居生活業種";
d_xs.Rows[6].HeaderCell.Value = "合計";
d_xs.Columns[0].HeaderText = "總聯帶金額";
d_xs.Columns[1].HeaderText = "訂單聯帶筆數";
for (int i = 0; i < this.d_xs.Columns.Count; i++)
{
this.d_xs.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
}
conn.Close();
uj5u.com熱心網友回復：
共同的列是樓層嗎，根據樓層關聯uj5u.com熱心網友回復：
是用SQL聯合查詢嗎？
SELECT sum(聯帶銷售統計表.總聯帶金額) AS AA, sum(聯帶銷售統計表.訂單聯帶筆數) AS BB, sum(店鋪品牌銷售匯總.匯總交易金額) AS CC
FROM 聯帶銷售統計表 INNER JOIN 店鋪品牌銷售匯總 ON 聯帶銷售統計表.業種=店鋪品牌銷售匯總.匯總業種
WHERE 聯帶銷售統計表.業種='名品靴鞋業種';
這樣出來的結果就很詭異，店鋪品牌銷售匯總.匯總交易金額的 值明明就是100 現在顯示是9500 也不知道是哪里來的？
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/225217.html
標籤：C#