his实验把sql server数据导出到excel中去

1、HIS实验把SQL Server数据导出到Excel中去蔡1：实验要求：2：实验目的：3：实验主要步骤：一：打开 VS.NET 2005构建好一个程序，界面如下：（注：里面就放了一个datagridview和一个BUTTON按钮）二：添加一个DB类：代码如下：using System;using System.Collections.Generic;using System.Text;using System.Data.SqlClient;namespace SqlToExcel class DB public static SqlConnection createCon() return n

2、ew SqlConnection(server=.;database=northwind;uid=sa;pwd=;); 三：在PAGE_LOAD事件里面写代码：参考代码如下：SqlConnection con=DB.createCon(); SqlDataAdapter sda=new SqlDataAdapter(); sda.SelectCommand=new SqlCommand(select * from employees,con); DataSet ds=new DataSet(); sda.Fill(ds,employees); this.dataGridView1.DataSo

3、urce=ds.Tablesemployees; this.dataGridView1.DataBindings;四：单击button按钮代码如下：SqlConnection con = DB.createCon(); SqlCommand sqlCommand=new SqlCommand(select Lastname,firstname,title,address from employees,con); DataSet ds = new DataSet(); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = n

4、ew SqlCommand(select * from employees, con); SqlDataAdapter sqlAdapter = new SqlDataAdapter(sqlCommand); /填充数据 sqlAdapter.Fill(ds, Excel); con.Close(); / 创建Excel对象 Excel.Application xlApp = new Excel.Application(); Workbook wb = xlApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet); Worksheet ws = (Wor

5、ksheet)wb.Worksheets1; / 设置标题 xlApp.Cells1, 1 = 会员姓名; xlApp.Cells1, 2 = 性别; xlApp.Cells1, 3 = 籍贯; xlApp.Cells1, 4 = 电子邮件; / 设置格式 int iMaxRow = ds.TablesExcel.Rows.Count; int iMaxCol = ds.TablesExcel.Columns.Count; ws.get_Range(ws.Cells1, 1, ws.Cells1, iMaxCol).Font.Name = 黑体; ws.get_Range(ws.Cells1,

6、 1, ws.Cells1, iMaxCol).Font.Bold = true; ws.get_Range(ws.Cells1, 1, ws.CellsiMaxRow + 1, iMaxCol).Borders.LineStyle = 1; / 填充数据 for (int iRow = 0; iRow iMaxRow; iRow+) for (int iCol = 0; iCol iMaxCol; iCol+) xlApp.CellsiRow + 2, iCol + 1 = ds.TablesExcel.RowsiRowiCol.ToString(); / 保存Excel xlApp.Save(H:sheet1.xls); / 打开Excel xlApp.Visible =