A表結構
B表結構
DATAGRIDVIEW拼接后出來挺奇怪的現象
下面那幾行應該是在第三列最上面，現在都去下面了。還有幾個奇怪的數字3，請幫忙看看什么原因呢？
namespace 工具
{
public partial class 主程式 : Form
{
public 主程式()
{
InitializeComponent();
}
string filenameurl = null;
private OleDbDataAdapter find_do;
private OleDbDataAdapter find_do1;
private void b_ok_Click(object sender, EventArgs e)
{
this.d_xs.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
this.d_xs.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
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;
d_xs.RowHeadersWidth = 150;
DataTable dataTable = new DataTable();
find_do.Fill(dataTable);
string sql_str1 = "SELECT sum(匯總交易金額) as CC FROM 店鋪品牌銷售匯總 WHERE 匯總業種='名品靴鞋業種'" +
"UNION ALL SELECT sum(匯總交易金額) as CC FROM 店鋪品牌銷售匯總 WHERE 匯總業種='淑女裝業種'" +
"UNION ALL SELECT sum(匯總交易金額) as CC FROM 店鋪品牌銷售匯總 WHERE 匯總業種='少女裝業種'" +
"UNION ALL SELECT sum(匯總交易金額) as CC FROM 店鋪品牌銷售匯總 WHERE 匯總業種='男裝童玩業種'" +
"UNION ALL SELECT sum(匯總交易金額) as CC FROM 店鋪品牌銷售匯總 WHERE 匯總業種='運動休閑業種'" +
"UNION ALL SELECT sum(匯總交易金額) as CC FROM 店鋪品牌銷售匯總 WHERE 匯總業種='家居生活業種'";
OleDbConnection conn1 = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Data_tg.mdb");
OleDbCommand cmd1 = new OleDbCommand(sql_str1, conn);
find_do1 = new OleDbDataAdapter();
find_do1.SelectCommand = cmd1;
DataTable dataTable1 = new DataTable();
find_do1.Fill(dataTable1);
dataTable.Merge(dataTable1);
DataRow dataRows;
dataRows = dataTable.NewRow();
dataRows[0] = dataTable.Compute("Sum(AA)", "true");
dataRows[1] = dataTable.Compute("Sum(BB)", "true");
dataRows[2] = dataTable.Compute("Sum(CC)", "true");
dataTable.Rows.Add(dataRows);
this.d_xs.DataSource = dataTable;
uj5u.com熱心網友回復：
這代碼寫的 稀碎uj5u.com熱心網友回復：
就是試試這個拼接方法而已轉載請註明出處，本文鏈接：https://www.uj5u.com/net/225224.html
標籤：C#
上一篇：vs2019 版本16.8 .net core 應用，專案生成之后，部分檔案不復制到Debug目錄問題？
下一篇：Grid++Report報表設計