mssql 数据库通过软件输出行转列到excel

实现功能，部分行转列，并实现多行汇总、排序等

代码很简答，主要是两层循环

  foreach (DataRow myRow in dt.Rows)
                    {
                        DataRow row = exceldt.NewRow();
                        string wheresql = "select "
                            + textBox6.Text.Trim() + " from "
                            + richTextBox1.Text.Trim() + " where ";

                        int n = 0;
                        for (int i = 0; i < str1s.Length; i++, n++)
                        {
                            row[n] = myRow[n].ToString();
                            if (i == 0)
                                wheresql = wheresql + "isnull("+str1s[i] + ",'')='" + myRow[str1s[i]].ToString() + "'";
                            else
                                wheresql = wheresql + " and isnull(" + str1s[i] + ",'')='" + myRow[str1s[i]].ToString() + "'";
                        }
                        wheresql = wheresql + " order by " + textBox8.Text.Trim();
                        SqlDataAdapter myda2 = new SqlDataAdapter(wheresql, conn); // 实例化适配器
                        DataTable dt2 = new DataTable(); // 实例化数据表
                        myda2.Fill(dt2); // 保存数据
                        //ExcelHelper.GetExcelByDataTable(dt2, comboBox1.Text.Trim());
                        foreach (DataRow myRow2 in dt2.Rows)
                        {
                            for (int i = 0; i < str2s.Length; i++, n++)
                            {
                                row[n] = myRow2[str2s[i]].ToString();
                            }
                        }
                        exceldt.Rows.Add(row);
                        num = num + 1;
                        progressBar1.Value = num;
                    }
                    ExcelHelper.GetExcelByDataTable(exceldt, comboBox1.Text.Trim());
                    conn.Close(); // 关闭数据库连接
                    MessageBox.Show("ok!ok!");
                    button2.Enabled = true;
                }

链接：https://pan.baidu.com/s/1-fsq4CvS6CRAK01sa3gHdw    提取码：u8vl