Website 是一个交易平台,
database : MS SQL Server
- using Microsoft.Practices.EnterpriseLibrary.Data with stored procedure to query (existing code,maybe i can change it...)
- put query results to a Excel sheet (怎样在 EnterpriseLibrary.Data 中把 query results 放到 Excel file 里去?能不能用 Office Web Components ?)
- mail this Excel file to users weekly (how to schedule a task on the server side for this requirment? which technology should I use? Better not use a new apps for the scheduling)
谢谢各位指教!
database : MS SQL Server
- using Microsoft.Practices.EnterpriseLibrary.Data with stored procedure to query (existing code,maybe i can change it...)
- put query results to a Excel sheet (怎样在 EnterpriseLibrary.Data 中把 query results 放到 Excel file 里去?能不能用 Office Web Components ?)
- mail this Excel file to users weekly (how to schedule a task on the server side for this requirment? which technology should I use? Better not use a new apps for the scheduling)
谢谢各位指教!