Click here to Skip to main content
15,888,733 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: ASP.Net website asks user and password continously Pin
idrisgani4-Apr-13 0:07
idrisgani4-Apr-13 0:07 
GeneralRe: ASP.Net website asks user and password continously Pin
Jasmine25014-Apr-13 6:08
Jasmine25014-Apr-13 6:08 
QuestionIntranet Asp.Net application - are there any security prohibitions built in that would prohibit sending an Excel file with macros to a user's desktop?? Pin
Duke Carey3-Apr-13 8:19
professionalDuke Carey3-Apr-13 8:19 
AnswerRe: Intranet Asp.Net application - are there any security prohibitions built in that would prohibit sending an Excel file with macros to a user's desktop?? Pin
R. Giskard Reventlov3-Apr-13 8:47
R. Giskard Reventlov3-Apr-13 8:47 
GeneralRe: Intranet Asp.Net application - are there any security prohibitions built in that would prohibit sending an Excel file with macros to a user's desktop?? Pin
Duke Carey3-Apr-13 9:24
professionalDuke Carey3-Apr-13 9:24 
GeneralRe: Intranet Asp.Net application - are there any security prohibitions built in that would prohibit sending an Excel file with macros to a user's desktop?? Pin
R. Giskard Reventlov3-Apr-13 9:46
R. Giskard Reventlov3-Apr-13 9:46 
GeneralRe: Intranet Asp.Net application - are there any security prohibitions built in that would prohibit sending an Excel file with macros to a user's desktop?? Pin
Jasmine25013-Apr-13 13:18
Jasmine25013-Apr-13 13:18 
AnswerRe: Intranet Asp.Net application - are there any security prohibitions built in that would prohibit sending an Excel file with macros to a user's desktop?? Pin
Jasmine25013-Apr-13 13:17
Jasmine25013-Apr-13 13:17 
That stuff sounds too important to be using Excel for it?

YES, it can be done, but it depends on how the file is being created. If you're inserting data into an Excel sheet that already has the macros and formulas, then it's possible, and actually better to do directly in Excel than to use Office Interop and create the file with ASP then send it to the user. Just create an Excel sheet that downloads its data from the database.

http://office.microsoft.com/en-us/excel-help/connect-to-import-sql-server-data-HA010217956.aspx[^]

Using Office Interop to create the Excel sheet and send it back to the user doesn't have any security problems you can't get around. Users will have to confirm some dialog boxes, which they never read anyway. However, the Office Interop stuff falls into category 4 - it's hard to do to begin with, and very hard to maintain. I'll send you some of my Interop code if you want to see - it's explicit, ugly, verbose, hard-coded stuff. (now, that was a few years ago, so it might be better now, but I doubt it)

To test your security, you might want to just put a file up there that has the features you want, and give some users the link to it. Downloading it from IIS as a file should be almost the same as streaming it back from a page.

Still, this sounds like a horrible way to manage budgets! Teach these folks about accounting software and reporting tools and get them out of your hair!
QuestionHow to create MX Excel file from DataTable? Pin
Tesic Goran2-Apr-13 22:58
professionalTesic Goran2-Apr-13 22:58 
AnswerRe: How to create MX Excel file from DataTable? Pin
AContractor3-Apr-13 1:50
professionalAContractor3-Apr-13 1:50 
AnswerRe: How to create MX Excel file from DataTable? Pin
Jasmine25013-Apr-13 5:50
Jasmine25013-Apr-13 5:50 
GeneralRe: How to create MX Excel file from DataTable? Pin
Tesic Goran3-Apr-13 20:23
professionalTesic Goran3-Apr-13 20:23 
GeneralRe: How to create MX Excel file from DataTable? Pin
AContractor4-Apr-13 1:59
professionalAContractor4-Apr-13 1:59 
GeneralRe: How to create MX Excel file from DataTable? Pin
Jasmine25014-Apr-13 6:10
Jasmine25014-Apr-13 6:10 
QuestionWant to display check boxes in report viewer Pin
VishwaKL2-Apr-13 22:35
VishwaKL2-Apr-13 22:35 
AnswerRe: Want to display check boxes in report viewer Pin
AmitGajjar5-Apr-13 19:13
professionalAmitGajjar5-Apr-13 19:13 
GeneralRe: Want to display check boxes in report viewer Pin
VishwaKL7-Apr-13 16:08
VishwaKL7-Apr-13 16:08 
GeneralRe: Want to display check boxes in report viewer Pin
AmitGajjar7-Apr-13 16:35
professionalAmitGajjar7-Apr-13 16:35 
QuestionReading an HTML file into XmlDocument object Pin
Chinmaya C2-Apr-13 19:33
Chinmaya C2-Apr-13 19:33 
AnswerRe: Reading an HTML file into XmlDocument object Pin
Richard Deeming3-Apr-13 3:42
mveRichard Deeming3-Apr-13 3:42 
QuestionAdding dll in web application which is developing on MVC Framework Pin
Shree.grace1-Apr-13 19:41
Shree.grace1-Apr-13 19:41 
AnswerRe: Adding dll in web application which is developing on MVC Framework Pin
Jasmine25012-Apr-13 18:41
Jasmine25012-Apr-13 18:41 
GeneralRe: Adding dll in web application which is developing on MVC Framework Pin
Shree.grace2-Apr-13 19:02
Shree.grace2-Apr-13 19:02 
GeneralRe: Adding dll in web application which is developing on MVC Framework Pin
Jasmine25013-Apr-13 5:47
Jasmine25013-Apr-13 5:47 
GeneralRe: Adding dll in web application which is developing on MVC Framework Pin
Shree.grace3-Apr-13 18:23
Shree.grace3-Apr-13 18:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.