if( conn.State == ConnectionState.Open)
conn.Close();
ConnectionString ="Integrated Security=SSPI;" + "Initial Catalog=mydb;" +"Data Source=localhost;";
conn.ConnectionString = ConnectionString;
conn.Open();
// 创建数据适配器
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM myTable", conn);
// 创建一个数据集对象并填充数据,然后将数据显示在DataGrid控件中
DataSet ds = new DataSet("myTable");
da.Fill(ds, "myTable");
int i=0;
int j=0;
DataTable myTable=new DataTable();
myTable=ds.Tables["myTable"];
int k,p;
k=1;p=0;
Excel.Application excel = new Excel.Application ( ) ;
excel.Application.Workbooks.Add ( true ) ;
try
{
foreach(DataRow myRow in myTable.Rows)
{
k++;
p=0;
foreach(DataColumn myColumn in myTable.Columns)
{
p++;
excel.Cells[ k ,p] =myRow[myColumn].ToString();
}
}
}
catch (Exception err2)
{
MessageBox.Show("无法放入到EXCEL的CELLS中!");
}
excel.Visible = true ;
conn.Close();
ConnectionString ="Integrated Security=SSPI;" + "Initial Catalog=mydb;" +"Data Source=localhost;";
conn.ConnectionString = ConnectionString;
conn.Open();
// 创建数据适配器
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM myTable", conn);
// 创建一个数据集对象并填充数据,然后将数据显示在DataGrid控件中
DataSet ds = new DataSet("myTable");
da.Fill(ds, "myTable");
int i=0;
int j=0;
DataTable myTable=new DataTable();
myTable=ds.Tables["myTable"];
int k,p;
k=1;p=0;
Excel.Application excel = new Excel.Application ( ) ;
excel.Application.Workbooks.Add ( true ) ;
try
{
foreach(DataRow myRow in myTable.Rows)
{
k++;
p=0;
foreach(DataColumn myColumn in myTable.Columns)
{
p++;
excel.Cells[ k ,p] =myRow[myColumn].ToString();
}
}
}
catch (Exception err2)
{
MessageBox.Show("无法放入到EXCEL的CELLS中!");
}
excel.Visible = true ;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货