用ASP.net从SQL表生成EXEL文件

[liuyan712]

如何用ASP.net从SQL表生成（操作）EXEL文件，请帮助

[xiaohutushen]

/* 导出到excel
EXEC master..xp_cmdshell bcp SettleDB.dbo.shanghu out c:temp1.xls -c
-q -SGNETDATA/GNETDATA -Usa -P




/* 导入Excel
SELECT *
FROM OpenDataSource( Microsoft.Jet.OLEDB.4.0,
Data Source=c:test.xls;User ID=Admin;Password=;Extended
properties=Excel 5.0)...xactions








/*动态文件名
declare @fn varchar(20),@s varchar(1000)
set @fn = c:test.xls
set @s =Microsoft.Jet.OLEDB.4.0,
Data Source= ID=Admin;Password=;Extended properties=Excel 5.0
set @s = SELECT * FROM OpenDataSource (
exec(@s)
*/




SELECT cast(cast(科目编号 as numeric(10,2)) as nvarchar(255)) 　 转换后的别名
FROM OpenDataSource( Microsoft.Jet.OLEDB.4.0,
Data Source=c:test.xls;User ID=Admin;Password=;Extended
properties=Excel 5.0)...xactions




/********************** EXCEL导到远程SQL
insert OPENDATASOURCE(
SQLOLEDB,
Data Source=远程ip;User ID=sa;Password=密码
).库名.dbo.表名 (列名1,列名2)
SELECT 列名1,列名2
FROM OpenDataSource( Microsoft.Jet.OLEDB.4.0,
Data Source=c:test.xls;User ID=Admin;Password=;Extended
properties=Excel 5.0)...xactions





/** 导入文本文件
EXEC master..xp_cmdshell bcp dbname..tablename in c:DT.txt -c
-Sservername -Usa -Ppassword

[liuyan712]

EXEC master..xp_cmdshell bcp SettleDB.dbo.shanghu out c:temp1.xls -c
-q -SGNETDATA/GNETDATA -Usa -P

能不能解释一下

[孟子E章]

http://dotnet.aspx.cc/ShowDetail.aspx?id=8A4CBF47-B888-4832-3389-ED3A3A3C8AAB

[孟子E章]

http://dotnet.aspx.cc/ShowDetail.aspx?id=BF0A54F9-C7C7-4200-BD9A-802AC1F5DE50

[孟子E章]

http://dotnet.aspx.cc/ShowDetail.aspx?id=BF0A54F9-C7C7-4200-BD9A-802AC1F5DE50

[cocoguo]

bConnection.Open();
SqlCommand bCommand=new SqlCommand();
bCommand.Connection=bConnection;
string strSelect="EXECUTE master..xp_cmdshell 'bcp threetdatabase..table1 out k:\\abc.xls -c'";
bCommand.CommandText=strSelect;
try
{
bCommand.ExecuteNonQuery();
}
catch(Exception xx)
{
MessageBox.Show(xx.ToString());
bConnection.Close();
return;
}
bConnection.Close();
MessageBox.Show("OK");