想在需要做将数据库的数据导入导出,不知道怎么做了,开始的时候打算用excel做的,做到最后了突然发现表里面有二进制文件,弄不成了 求救啊
     下面是我弄的代码
                     string Sqlconection = @"server=(local)\SQLEXPRESS;database=GeneralSurveySystemDB;Trusted_Connection=True";
            SqlConnection objConnection = new SqlConnection(Sqlconection);
            SqlCommand cmd = new SqlCommand("Select * from VenuesCheckTable", objConnection);
            DataSet objDataset = new System.Data.DataSet();
            SqlDataAdapter objAdapter = new SqlDataAdapter(cmd);
            objConnection.Open();
            objAdapter.Fill(objDataset, "Excel");
            objConnection.Close();
            Microsoft.Office.Interop.Excel.Application xlsApp = new Microsoft.Office.Interop.Excel.Application();
            if (xlsApp == null)
            {   
                MessageBox.Show("请确认你的电脑上安装有OFFICE软件");
                return;
            }
            Workbook workbook = xlsApp.Workbooks.Open(@"D:\xxx.xls", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            Worksheet mySheet = workbook.Sheets[1] as Worksheet;
            int iMaxRow = objDataset.Tables["Excel"].Rows.Count;
            int iMaxCol = objDataset.Tables["Excel"].Columns.Count;
            for (int iRow = 0; iRow < iMaxRow; iRow++)
            {
                for (int iCol = 0; iCol < iMaxCol; iCol++)
                {
                    xlsApp.Cells[iRow + 2, iCol + 1] = objDataset.Tables["Excel"].Rows[iRow][iCol].ToString();
                }
            }
            if (File.Exists(@"C:\xxx.xls") == true)
            {
                File.Delete(@"C:\xxx.xls");
            }
            object missing = System.Reflection.Missing.Value;
            workbook.Saved = true;
            workbook.SaveCopyAs(@"C:\xxx.xls");
            workbook.Close(true, Type.Missing, Type.Missing);
            workbook = null;
            xlsApp.Quit();
            xlsApp = null;
            MessageBox.Show("成功");