C#SQL查询输出到Excel,输出中不包括新添加的字段

我有一个小按钮点击代码输出一个SQL查询到Excel。

在我在它所查询的表中添加了一个新字段之前,这个方法工作得很好,现在它仍然输出相同的字段,而不包括新字段。

代码:

 private void button4_Click(object sender, EventArgs e)
        {
            string SQLQuery = "SELECT * FROM Services";
            SqlConnection conn = new SqlConnection("CONNECTION STRING");
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter(SQLQuery, conn);
            da.Fill(ds);
            Microsoft.Office.Interop.Excel.Application ExcelApp = new Microsoft.Office.Interop.Excel.Application();
            Workbook ExcelWorkBook = null;
            Worksheet ExcelWorkSheet = null;
            ExcelApp.Visible = true;
            ExcelApp.WindowState = XlWindowState.xlMinimized;
            ExcelApp.WindowState = XlWindowState.xlMaximized;
            ExcelWorkBook = ExcelApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
            List<string> SheetNames = new List<string>();
            SheetNames.Add("Services Details");
            ExcelApp.ActiveWindow.Activate();
            try
            {
                for (int i = 1; i < ds.Tables.Count; i++)
                    ExcelWorkBook.Worksheets.Add();
                for (int i = 0; i < ds.Tables.Count; i++)
                {
                    int r = 1;
                    ExcelWorkSheet = ExcelWorkBook.Worksheets[i + 1];
                    ExcelWorkSheet.Name = "Services";
                    for (int col = 1; col < ds.Tables[i].Columns.Count; col++)
                        ExcelWorkSheet.Cells[r, col] = ds.Tables[i].Columns[col - 1].ColumnName;
                    r++;
                    for (int row = 0; row < ds.Tables[i].Rows.Count; row++)
                    {
                        for (int col = 1; col < ds.Tables[i].Columns.Count; col++)
                            ExcelWorkSheet.Cells[r, col] = ds.Tables[i].Rows[row][col - 1].ToString();
                        r++;
                    }
                    ExcelWorkSheet.Rows[1].EntireRow.Font.Bold = true;
                    ExcelApp.Columns.AutoFit();
                }
                ExcelApp.Quit();
                Marshal.ReleaseComObject(ExcelWorkSheet);
                Marshal.ReleaseComObject(ExcelWorkBook);
                Marshal.ReleaseComObject(ExcelApp);
            }
            catch (Exception exHandle)
            {
                Console.WriteLine("Exception: " + exHandle.Message);
                Console.ReadLine();
            }
        }

我还尝试显式查询新字段 SELECT ABC FROM Services 什么都不输出。

新字段中有值。

如果我在Azure查询编辑器预览版上运行相同的查询,我会得到正确的结果。

编辑

好的,我把查询改为 SELECT *,1 FROM Services 然后我得到所有字段(除了新的“1”字段)如何更改循环以得到所有字段?

使用EPPlus编辑2解决方案

只是为了让以后看到这个的人更新一下,我用了 NuGet Package Manager ( Project &燃气轮机; Manage NuGet Packages )并已安装 EPPlus

我接着补充说:

using OfficeOpenXml;
using OfficeOpenXml.Style;
using System.Data.SqlClient;
using System.IO;

并在按钮上使用了以下代码:

    private void button4_Click(object sender, EventArgs e)
    {
        string SQLQuery = "SELECT * FROM Services";
        SqlConnection conn = new SqlConnection("CONNECTION STRING");
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(SQLQuery, conn);
        DataTable dt = new DataTable();
        da.Fill(dt);
        using (var p = new ExcelPackage())
        {
            var ws = p.Workbook.Worksheets.Add("Service");
            ws.Cells["A1"].LoadFromDataTable(dt, true);
            int totalRows = ws.Dimension.End.Row;
            int totalCols = ws.Dimension.End.Column;
            var headerCells = ws.Cells[1, 1, 1, totalCols];
            var headerFont = headerCells.Style.Font;
            headerFont.Bold = true;
            var allCells = ws.Cells[1, 1, totalRows, totalCols];
            allCells.AutoFitColumns();
            p.SaveAs(new FileInfo(@"d:\excel\Service" + DateTime.Now.ToFileTime() + ".xlsx"));
        }
    }

这是一个文件的即时输出,感谢@ Caius Jard