×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

@Florida

请大家帮帮忙，先谢了！ 新上手 ASP.NET/C# ，不熟, 下周五要交差，tasks见内。

study_work(study_work)
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)

谢谢各位指教！
(#4515681@0)
Last Updated: 2008-6-21
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / 学科技术讨论 / 请大家帮帮忙，先谢了！ 新上手 ASP.NET/C# ，不熟, 下周五要交差，tasks见内。 -study_work(study_work); 2008-6-21 {534} (#4515681@0)
    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)

    谢谢各位指教！
    • Not sure what you mean 'Office Web Components'. -deep_blue(BLUE); 2008-6-22 {597} (#4516299@0)
      If you mean MS office automation, it’s better not to use. There are Considerations for server-side Automation of Office (URL http://support.microsoft.com/kb/257757).

      If your excel file will be used for client-side, you can pull data from database and put data to a GridView. Then use GridView.RenderControl to get a grid string (By google Export GridView to Excel, you can get many codes).

      Or on server-side, you can use OleDb to deal with Excel file as database. From following URL you can have Connection String for excel:
      http://www.connectionstrings.com/?carrier=excel
      • OWC can do that. -giss(rr); 2008-6-22 (#4516662@0)
        • LZ asked to put query results to a Excel sheet rather than publishing spreadsheets to the Web. -deep_blue(BLUE); 2008-6-23 (#4517229@0)
          • you are right, I need to put the query result to Excel sheet directly and mail the file as a attachment. -study_work(study_work); 2008-6-23 (#4518949@0)
            • In addtion to approaches I mentioned before, You can also 'write' data rows to execl by using XML format excel. -deep_blue(BLUE); 2008-6-24 (#4519435@0)
    • I guess you should not finish it in time without help. -giss(rr); 2008-6-22 (#4516663@0)
      • 是不是我要对manager说我需要多一点的时间？我不知道我能不能得到其他的帮助，因为我刚去这家公司上班。 -study_work(study_work); 2008-6-22 (#4516906@0)
        • 想问问面试技巧，不熟怎么能通过面试的。请PM，谢谢！我也在找工作中。 -zgzdr( 找工作的人); 2008-6-23 (#4518401@0)
          • 申请时不是ASP.NET /C#position,去了之后让做ASP.NET /C#就答应了，以前自己看过一点但没有hands-on 经验。面试时问了我以前的工作经验加考试。 -study_work(study_work); 2008-6-23 (#4518827@0)
    • 谢谢大家的的回复。 -study_work(study_work); 2008-6-22 (#4516890@0)
    • do you have to use ASP.NET? need to input some query parameter from web page? if not you can just use c# to write some program to generate a EXE and called from windows CRON job. -thunderbolt(孙悟空); 2008-6-23 (#4517980@0)
      • i have found a way to do it, thanks a lot. -study_work(study_work); 2008-6-23 (#4518837@0)
    • with SSRS, it should be piece of cake? -mfcguy(); 2008-6-27 (#4525681@0)
    • 再次感谢大家的指导和回复！ -study_work(study_work); 2008-6-27 {122} (#4525723@0)
      不好意思，2～3年没写code了，不过我想过几个月就会慢慢熟悉coding了，我已在周四晚上完成了这个task，再次感谢大家的指导和回复！

More Topics

  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
  • 请问web developer和software developer技术上有什么区别？
  • Elon Musk 带着川普总统奔向火星了。
  • 扔硬币的实验研究
    • 枫下论坛主坛 /  工作学习 /  学科技术讨论