I am fairly new to the asp.net scene. Having build a dashboard gathering info on my OLAP system's health status, I can't seem to figure out how to make sure that I catch the no connection exception.use the following statements on the datagrid:a) want to change the color of ssas2 button to red if an exception is thrown
View 5 RepliesI am fairly new to the asp.net scene. Having build a dashboard gathering info on my OLAP system's health status, I can't seem to figure out how to make sure that I catch the no connection exception.I use the following statements on the datagrid:a) want to change the color of ssas2 button to red if an exception is throw
MyDBConn.ConnectionString =
"Provider=MSOLAP.4;Data Source=core-ssas2;Integrated Security=SSPI;Initial Catalog=Financials;Connect Timeout=6000"
MyDBConn.Open()
MyDBConn.CreateCommand.CommandTimeout = 120
RemoteOnly" defaultRedirect="~/Errors.aspx">
<error statusCode="404" redirect="~/Error.aspx?code=404"/>
</customErrors>
hrow new HttpException(404, "404 Not Found");
If I am just logging exception details in my web app, do I really need to put in exception handling logic for each tier? Why not just let them all bubble up the stack trace to the global.asax and log them there?
View 5 RepliesI'm trying to improve my password change function in my app that allows members to change their passwords. I do have some password rules e.g. min 7 characters, etc.
There's a nice MembershipCreateStatus enumeration in the framework for creating new members. Is there a similar tool for catching password exceptions where the user's newly selected password doesn't match the rules?
I was wondering what will be the method to catch any exception at server end and to show the error message in a div with error icon on top of the page using jquery. All the examples I have browsed show how to display the div on click of some button or link but in my case the scenerio is different. I want to use it for displaying messages to user and make use of Jquery's animations as well.
View 7 RepliesI have a couple of questions on exception handling in .net: 1- Why do we have to catch specific exceptions other than the reason of displaying a particular error to the user? What if we wanted to always display a generic error to the user and not give him much details, would it be okay to catch only generic xceptions?
2- Is throwing exceptions from the data access layer to the UI layer best practice, or is it recommended to return a string or perhaps a boolean values from the data access layer to the UI layer?
Looking for best practice focused answers here with explanations.
Should the presentation layer of an ASP.Net app catch and handle exceptions thrown from the business layer, or should these be allowed to bubble out, where they can all be logged and handled uniformly in the Global.ascx's Application_Error handler?
[code]....
I am able to dynamily bind my grid to the cube based off the facillity I have selected. Now, if a facility has multiple cubes, I want the users to switch between the two cubes dynamicly, so I have created a drop down list showing their cubes and the ones that they can select. Currently I'm been trying several things in order to "rebind" the data but they don't seem to be working, so I figured I would attach my code to see if anyone Had a good idea.
If I make the cube change then switch back over to change facility and then back to the page, the new cube will load. So I have to find a way to do it in the one step rather then have them navigate to another page and then back again. Perhaps auto navigate them to a page and have that page send them back etc... Anyway here is the code: I first bind the data via the page_prerender call
[Code]....
Then the code drops down into the LoadCube(FacilityID) sub routine
[Code]....
Then here is the setup for the subroutine that will call the page load/ should change the cube to the correct cube.
[Code]....
how to present a .cube created in BI Development Studio as part of a .aspx page? Windows Server 2008 hosting the site using IIS 7. The SQL server and the management studio and the BI Development Studio used to create the .cube are on the same windows server. Am using Visual Studio 2010 Premium to develop for .NET Framework Verison 4. Using an impersonation account to control access to the db.
View 1 RepliesI have designed a gridview one of the fields of which I want to send the user to an URL onclick. After browsing the net for a while, I opted for converting the BoundField to a TemplateField. The same OLAP metric ([Measures].[GP]) works fine in the bound field yet produces an error in the Template:
<asp:TemplateField
HeaderText="GP Var">
<HeaderStyle
Font-Names="Verdana"
Font-Size="Smaller"
HorizontalAlign="Center"
[code]...
Here is the code copied from [URL] In asp.net code behind, I use try-catch try to catch any error but never catch it. In SQL database, if I rename Employees to Employeesx or change column DepartmentID to DepartmentIDx, record will not be deleted (it is right) without any error (it is wrong, suppose catch an error).
CREATE PROCEDURE DeleteDepartment
(
@DepartmentID int
)
AS
BEGIN TRANSACTION
DELETE FROM Employees
WHERE DepartmentID = @DepartmentID
IF @@ERROR <> 0
BEGIN
ROLLBACK
RAISERROR ('Error', 16, 1)
RETURN
END
DELETE FROM Departments
WHERE DepartmentID = @DepartmentID
IF @@ERROR <> 0
BEGIN
ROLLBACK
RAISERROR ('Error', 16, 1)
RETURN
END
OMMIT
I have been experiencing instances where a FormView update or insert event fails and should throw an exception, but doesn't. This seems top be related to my switch to Visual Studio 2010 Ultimate and .Net 4.0. Since the switch I have seen this problem several times. Is there something new in .Net or VS that I need to do or set to get the exceptions thrown? Other exceptions seem to work fine...it's just with FormView and SQLDataSource that I don't see them.The specific errors I don't see reported include misspelling a field name in the Select, Insert or Update commands in the SqlDataSource.
View 2 RepliesTrying to use a dropdownlist to query a database so that it will return all values except 1 (or more in future versions).
For example, assume you had a simple table name "MYFRIENDS" which has two fields named "GROUP" and "NAME" with the following records:
Group
Name
A
John
B
Jane
C
Tony
D
Sue
What I want to do is create a DropDownList that has only 2 list items related to the "GROUP" field. The first list item should return records from the database related to Group A only. Then, the second list item should return all other records EXCLUDING those belonging to Group A.
The drop down list should look something like this (I've put a question mark where I don't know what to do):
[Code]....
After the selection is chosen in the above drop down list, it should query the database and return the desired result. I'm using an AccessDataSource with select parameters. Here's a sample of what that looks like:
[Code]....
Things I've tried that didn't work:
I tried using "Not A" as the the 2nd list item's value. I was thinking p1 would be replaced with the value "Not A" and the query would read "WHERE GROUP LIKE Not A". But, the query syntax "Like Not" is technically wrong. I tried changing the Where Clause to "WHERE GROUP p1" and then replaced the list item's value to "LIKE A" and the second to "NOT LIKE A". Again, I was thinking p1 would be replaced to read "WHERE GROUP LIKE A" and "WHERE GROUP NOT LIKE A". I also tried changing the "SelectCommand" itself so that after the dropdownlist changed, it would first change the selectcommand first and then run the query.
Why the first 2 items didn't work became somewhat obvious to me after thinking about it for a little while. However, I would think the 3rd one would/should work... as long as you have the sequence of events correct which up to this point I haven't been able to figure out.
I'm building the standard 3-tier ASP.NET web application but I'm struggling as to where to do certain things - specifically handling exceptions.
I've tried to have a look around on the web for some examples but can't find any which go as far as a whole project showing how everything links together.
In my data-tier I'm connecting to SQL Server and doing some stuff. I know I need to catch exceptions that could be raised as a result but I'm not sure where to do it.
From what I've read I should be doing it in the UI tier but in that case I'm not sure how to ensure that the connection to the database is closed. Is anyone able to clarify how to do this? Also if anyone knows as to where I could find an example 3-tier web application that follows best practices that would be great too.
i am binding onject in fromview from other webserivice gatewayhow to i catch if the object is not set?
<%# (gw.gatewayobject)gw.gwObject %>
I want to catch the session if is null how can I do this. My session is:
Session["kullanici_name"].ToString();
if it is null
Response.Redirect("kulanicigiris.aspx");
And I want to make a logout button. If he /she press the button session=null then page load and check if the session null going to home page.
We have a asp.net application and want to implement logging. The first idea was to use the Application_Error method in the global.asax file.
The problem is that ASP.NET very often seem to throw exceptions internally that are not caused by the application and which seem not to interfer with the users normal workflow. For example we often get HTTPExceptions, UnauthorizedAccessExceptions and others caught in this method, although there is no real error in the application.
it will be very interesting that controls for input in forms have another property ie semanticid semanticname so semantically can be relationate i.e textboxes content if then we retrieve the data using linq having olap cubes we could have a lot of diferent views comunicating diferent controls of diferent webparts that shares the same semantically set or point to same ontology for the several dates or same localization from different input forms collection data,etc.
View 3 RepliesI get this error in the browser:
Code:
Thread was being aborted.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Threading.ThreadAbortException: Thread was being aborted.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[ThreadAbortException: Thread was being aborted.]
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +486
System.Web.ApplicationStepManager.ResumeSteps(Exception error) +501
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) +123
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +379
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
I have try{}catch(Exception ex){} in the right place:
Code:
protected void Button1_Click(object sender, EventArgs e)
{
try
{
// all processing occurs inside here
}
catch(Exception ex)
{
}
}
I even created a global.asax file and on the Application_Error event, I wrote a code that would email me the error (and i'm not getting an email regarding that error when I get the error shown above). I know for a fact that the thread is going inside the "try" statement because I send emails to myself whenever it finishes certain codes inside of it. So how come I'm getting that error in my browser instead of it being handled in my "catch" statement? I have two problems here, one, why is the exception not going to my "catch" statement, and two, why am I getting that error in the first place.
Note: my web app calls a webservice.
I have a live working website (ASP.NET 3.5) that pulls data from an OLAP cube on a remote server without any problems. However I now need to move the website to a different web server, and for reasons unknown I cannot get the OLAP queries to work in the new location.
I have installed the same versions of .NET Framework (3.5) and ADOMD.NET (8.0) on both servers, and the website pages were copied across servers with no changes made, so this can't be a coding issue. However I get errors like the following when the new site tries to query the OLAP cube:
[Code]....
(Note: run_olap_query is my method that attempts to run the query). The error would there is a mistake in the syntax of the MDX query, however that is definitively not the case. I have retrieved the MDX that the page attempted to run at the error reporting stage and have run it manually in Analysis Services - it returns results with no complaints. The same MDX queries are also still running quite happily on the original website.The only notable difference I can spot between the servers is that the original server has SQL Server 2000 installed and the new server has no version of SQL Server, but I would not expect the site to need SQL Server on the local machine to run these queries. Does anyone know if this is the case? I'm somewhat stumped as to what the cause of the issue is here, and am completely out of ideas as to where to look.
P.S. Here is my code, though I do not think it will be relevant:
[Code]....
I've got a master page where I've created two content place holders ('menu content place holder' and 'main body content place holder'). I've placed several controls (drop down lists and a calendar) in one of these content place holders (the 'menu content place holder'). In my content page I've set the 'menu content place holder' to 'Default to Master page content'. In my 'main body content place holder' I've included several controls (table, labels) which depend on the user selected items in the 'menu content place holder'.
After including a reference in all the necessary places- like this:
DropDownList ddlList1 = Master.FindControl("ddlList1")
as
DropDownList;
I still get the following exception (this exception occurs in my content page):
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details:System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
[Code]....
I have a GridView tied to an XmlDataSource to take advantage of the edit/update/delete capabilities GridView inherently offers. XmlDataSource offers no update event handling so that must be performed manually. I have no problem with this. My problem is how/where can I catch this update event to perform my custom handling.
View 1 RepliesI would like to duplicate a table record but not all the columns.For example, Select from "TableA" Where recordid='1' AND insert into "TableA" All values except "col2" , "col3". I hope you got the idea. Could you please advise me what is the cleanest approach to get this done.
View 9 RepliesDoes a DB transaction get automatically rolled back during exception or we should explicitily write transaction .Rollback inside the catch block to rollback a transaction...
View 3 Replies