what does it mean when they say that the retrieved data from sql server has to be treated in sql sever first

I had an interview, they said the data should be published on the web. But first the data should be trated on SQL server side first, befre being published on the web. Do you know what they mean by that pls

2/ also they spoke about excel sheets, i think kind of transfering the treated data to excel and so on. Can you also explain this second requirement for me pls

Thanks.

.NET Development4

Hi,

1) Web application usually have 3 tiers: Database, Business, Client.
Data processing can be done in the database tier or the business tier. On the database tier it means that custom views and stored procedures are created in the database to do the work required (T-SQL or embedded .net code). The same thing can be done on the Business tier which is the asp.net application. Some developers prefer to do as much as possible on the database tier for performance reasons while other do the work on the Business tier for maximum flexibility.
The actual processing that needs to be done depends on the application.

2) There are multiple possibilities here. If the website needs to create an excel file with the data for the user to open in Excel, the easiest way to proceed is to create an aspx page that outputs an CSV file which is associated with excel by default. There are also more advanced solution to embed an Excel sheet in the web browser.

Charles

Hi,
If the website needs to create an excel file with the data for the user to open in Excel, the easiest way to proceed is to create an aspx page that outputs an CSV file which is associated with excel by default. There are also more advanced solution to embed an Excel sheet in the web browser.

Charles

Can you elaborate these last 2 possibilities or provide me with some links if you know them pls

Thanks

The first possibility is to use the spreadsheet in Office Web Components:
http://msdn2.microsoft.com/en-gb/library/aa155782(office.10).aspx (intro)
http://www.excelkb.com/article.aspx id=10146&cNode=1U5J4S (tutorial)

To export an csv or xls file, look at this sample:
http://www.codeproject.com/aspnet/Excel_CSV_export_button.asp

Charles