Hi, I am implementing error handling in my website developed in ASP.Net MVC & C#. To do this, I have set CustomErrors attribute in my web.config file as below customErrors mode="On" defaultRedirect="Error.aspx" This should ideally redirect user to default error page which is present in Views/Shared/Error.aspx. This bebavior was working perfetly untill I changed the base class of my controller classes. Earlier, the base class was "Controller" but for some internal logic, I changed it to ControllerBase and my ControllerBase is now inherited from Controller class. For example HomeController : ControllerBase { ... ... } ControllerBase : Controller { ... ... } But now when I run the application and some unhandled error occurs, the user is not redirected to Error.aspx any more. Instead it gives error page as below. Even if I set custom errors mode to "On". ---------------------------------------------------------------------- Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's configuration tag to point to a custom error page URL. ---------------------------------------------------------------------- Any help will be appreciated... Thanks Anil

Thanks for the link. It works perfect with Database Trace Listener. The data is being saved in "Log" table through "WriteLog" procedure. But if I want my onw custom data to be inserted in my custom table, then how to configure this? Say I want to log the data in my table "ErrorLog" ErrorLog table: ------------------- ErrorID INT ErrorMessage VARCHAR(1500) And my procedure may be say "pr_LogErrors" which accespts one parameter say "@ErrorMessage"? I tried changing the proc name in listener property "writeLogStoredProcName" but this does not work and gives error like the stored proc has too many arguments. any idea? Thanks.

Hi, Can anybody please give me links or matarial which can explain step by step how to log errors into database table with Enterprise library 4.1 Logging Application Block? Also where to find the required definitions of table "Log" and SP "WriteLog"? Here is the scenario: - I am creating a web application in ASP.NET MVC project with Visual Studio 2008 - I have included reference to following 2 Microsoft Enterprise Library 4.1 dlls Microsoft.Practices.EnterpriseLibrary.Logging Microsoft.Practices.EnterpriseLibrary.Logging.Database Thanks in advance

Hi, Is there any way to find all stored procedures which are being called inside the main procedure? This can go deeper at last level inside the main one. I have tried the available option for "right click" > "View Dependancies" but it does not show the procedures called by EXEC statement. Please correct me if I am wrong here. My problem is - I have a procedure which calls multiple other procedures inside it. Also these called procedures again might have called other procedures inside them. Now I need to find a list of all such dependent procedures for my main procedure. Thanks in advance for your inputs! Anil

Thanks all for your inputs.. I ended up using an OBJECT tag with data attribute pointing to the desired URL. This works smoothly in all browsers except IE :( Right now searching for fixing this for IE.

Hi, I am using iFrame to display output of HTML code. For this I have set URL attribute of iFrame to "http:/somesite/default.aspx". This URL returns a text which gets displyed in iFrame. But, my client is not happy with using iFrame due to its disadvantages and security problems. Is there any other control which I can use to catch the output of my URL and display on a web page? I tried tag with "data" attribute. but it does not work. One thing to note here: I cannot use AJAX or Javascript because of business logic constraints. The desired code will be given to end user and he will paste it in his own web site page to see the output returned by URL. Just like ad banner. Thanks in advance.

Hi, Today I opened the definition of Excel.ApplicationClass and I observed that it implements two interfaces called application and _application. Interface _application contains lot of members but interface application is empty and only implements interface _application. So the hierarchy is like this; interface _application (interface with members in it) interface application (empty interface) : _application ApplicationClass (class) : _application, application So the class ApplicationClass provides definitions to all members in topmost interface _application. My question is that why does this class need to implement the interface _application if it is already implemented by interface application? Thanks in advance for all the answers by you. Anil

Thanks for your suggessions karkster. Unfortunately it's not working. I came to know that the code is not working because my local machine does not have SMTP server installed on it. So I need to run the code on a machine where it is installed already. Will try for this.

I am trying to send a mail through my console application which is in .Net 2.0 with C# language. I am using the class System.Net.Mail.SmtpClient to send a mail. This was decided because the older version of this class System.Web.Mail.SmtpMail is now totally obsolete. But I get an error message as "Failure sending mail." when I run my code. I tried to resolve this by following: 1. Tried pinging the address from command prompt. It shows reply. 2. Assigned port number as number 25. Doesn't work. Gives same error. Following is my code FromEmail = "anil.soman@xyz.com"; strEmailAddre = "somebody@xyz.com"; strSubject = "some subject"; strBody = "some text for body"; System.Net.Mail.SmtpClient SMTPClient = new System.Net.Mail.SmtpClient(); SMTPClient.Host = "smtpservername"; SMTPClient.Port = 25; SMTPClient.Send(FromEmail, strEmailAddre, strSubject, strBody); What could be the reason for this? Any suggessions? Thanks in advance. Regards, Anil

hi, I want to update the data part of a chart which is already there in my word docuement. I am working in C# 2.0 console application. I am using a word template which has a graph in it. I have a dataset and I want to update the data source of the graph at runtime. Is there any way to do this? I tried reflection but it does not work.

Does that mean, when we include say System.Data.SQLClient namespace on the top of our class, it copies all the classes inside this namespace at runtime and allocates memory accordingly even if we don't use anything in it? Regards, Anil

I have a very basic question. If I declare some variables in my class and just run my C#.Net program, without any work done in it, will it allocate a memory for these variables? For Example, Class abc { public int a; public double b; } Regards, Anil

Thanks man! it was helpful.

Thanks!

Hi, Does anybody know a good reference documentation/tutorial/code where we can learn how to manipulate excel sheets using C#/VB.Net? Like filling cells with values, cut, copy paste rows/columns, formatting cells, adding charts to the excel sheet, etc. Thanks Anil

Joe, Thanks! That was a nice article. That solved my Worksheet("abc") problem. Regards, Anil

I have a VB 6 code with me. The code is playing with excel. It generates worksheets and adds templates to them, sets cell values, etc. I want to rewrite the entire code into C#.Net. For that I have used Microsoft Excel 11.0 COM reference. (This is same in VB6). The problem is that I cannot find code in C#.Net equivalent to VB6 counterpart. Examples are given below: oBook.Worksheets("General") or this oSheet.Rows(2).Copy oSheet.Rows(i) There are many examples like this. Either I don't know how to write this in .Net or there is no equivalent. Does anybody know, where I can learn how to use Excel in .Net 2003 in good amount of depth so that I can convert any code in VB6 to .Net 2003? Regards Anil

Hi, When I create a new website using visual studio -2005, the project files and sln files stored in different location. But default sln files goes to "C:\Documents and Settings\username\My Documents\Visual Studio 2005\Projects" as it is set in Tools->Options-> Project and Solution setting. My requirement is whenever I create a new website then project files and sln should go the same place where my project folder is created. How to do this? Anil

Additional information: Web application is installed on different server. SharePoint is on different server. When the user open the SharePoint Portal page first time, an authentication popup comes. Here the user enters usre id and the password to log in into the sharepoint. After that when the user clicks on my application's link, again the authentication popup comes as the application is on different server. But after changing the User from Sharepoint, no authentication popup is displayed for the application and the application shows the old user id only. this may help you to understand the scenario better. anil

Hi, I have a problem with reading the user information sent by SharePoint Portal link. I have a SharePoint Server where we have designed a home page with links to in house applications. One of these links points to an ASP.NET web site application developed in ASP.NET 2003. I used the Navigation control present on the SharePoint Home Page (I believe this is an inbuilt webpart provided by SharePoint). On clicking of one menu item in this Navigation control, the ASP.NET web application opens in the same page below inside a web page webpart control. I want to display the logged in user;s ID with a message Welcome UserID on ASP.NET application's home page. This thing works for the very first time and shows the correct user name in the message. But when the user loggs into the SharePoint Portal with different UserID (by using "Sign in with different user link), then the changed UserID does not get reflected on the ASP.NET application's home page. It shows the old user id only. I am using folloing code to read the user id on home page. string strUser = this.Context.User.Identity.Name; lblUserName.Text="Welcome " + strUser; I also tried Request server collection variables like "LOGON_USER", "AUTH_USER", etc. but they didn't work. How to get the correct user information on ASP.NET application's home page so that it will reflect the changed user id on sharepoint? Thsnks in advance. Anil