I have developed a web application in asp.net 2.0 with
Access as back end i am trying to gereate report/export
data in excel. After hosting the site i am not getting any
error or such exported excel file. but using the source
code from my system it works fine.
Could any one tell me why it is happening and what is its
solution.
Answers were Sorted based on User's Feedback
Answer / shrikant
Could you please let me know what error you are facing?
The most possible error while exporting data thru asp.net
is COM exception.
Use reflection to achieve this, whenever we use Microsoft
com component line MS-Excel we do code for any particular
version instead use generalize way for handling excel or
any other MS component.
Please refer:
http://www.codeproject.com/KB/cs/Simple_Excel_Automation.asp
x
http://www.c-sharpcorner.com/Forums/ShowMessages.aspx?
ThreadID=49886
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / chetan singh
this problem is related to permission.just note you are
uploading excel file in Inetpub folder and which will not
allow you.So to solve this you need to give access
permission.If you are using XP then give permission to
ASPNET user and for windows 2000/2003 give permission to
Network services.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is %20 in a url?
I have been asked in an interview What is your LOC(Line of Code)What will be the probable answer for that
1 Answers HCL, Infosys, Mantec Consultants,
What is DataGrid wheater its a Server Control or something else ?
Explain the use of errorprovider control in .net?
What are the asp.net server side objects?
Is There any Third party tools are using in .Net Technologies? Can u Explain?
In a Repeater control how one can provide an alternating color scheme ?
What is content place holder?
Error : The operation couldn’t be performed because ole db provider sqlncli10 for linked server was unable to begin a distributed transaction.00000110 oledb provider for linked server returned message the partner transaction manager has disabled its support for remote/network transactions. I can able to execute the stored procedure in sql server but when i run the web page getting error like above. I did all the configuration. what is the solution?
What is base class of .net?
What is server components?
What is a swagger in web api?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)