his實驗把sql server數(shù)據(jù)導出到excel中去

1、HIS實驗把SQL Server數(shù)據(jù)導出到Excel中去蔡1：實驗要求：2：實驗?zāi)康模?：實驗主要步驟：一：打開 VS.NET 2005構(gòu)建好一個程序，界面如下：（注：里面就放了一個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); /填充數(shù)據(jù) sqlAdapter.Fill(ds, Excel); con.Close(); / 創(chuàng)建Excel對象 Excel.Application xlApp = new Excel.Application(); Workbook wb = xlApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet); Worksheet ws = (Wor

5、ksheet)wb.Worksheets1; / 設(shè)置標題 xlApp.Cells1, 1 = 會員姓名; xlApp.Cells1, 2 = 性別; xlApp.Cells1, 3 = 籍貫; xlApp.Cells1, 4 = 電子郵件; / 設(shè)置格式 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; / 填充數(shù)據(jù) 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 =