Way To Capture Unique Constraint Exception And Provide User-friendly Message
May 4, 2010
Using vb.net/asp.net 2005 and SQL Server 2005:I have a unique constraint setup to prevent users from entering duplicate email addresses in my online system.When a user tries to edit an existing email to one that already exists (add a duplicate) it shows the following<ERROR>Cannot insert duplicate key row in ojbect "dbo.someTableName" with unique index.....The statement has been terminated This prevents the user from adding duplicates which is good but I would like to provide a more user friendly exception message and I do not want to show the table and field names to the user.
View 4 Replies
Similar Messages:
Feb 15, 2011
When I get an exception message like this I want an Exception Class name to compare.Not wantto compare a string to match with substring.when I get an unique constraint error like this below how can I control if error exception type is exactly sqlserver unique constraint error ?:
catch (Exception ex)
{ if (ex.class==SQLUniqueException) blahblah();
};
View 2 Replies
Aug 25, 2010
Is it possible to allow repeated nulls on a column with a unique constraint? This column will won't always be populated with data upon insert, a condition must be met before the value is update. Once updated, it needs to be unique. Do I need to assign a temporary, random value or
View 1 Replies
Feb 24, 2011
When i try to delete a record, and the record is link to another table, so i will get the following error:
View 3 Replies
Mar 6, 2011
I have tables:
MAILBOX
MailboxId int PK
MailboxTypeId int FK
MAILBOXTYPES
MailboxTypeId int PK
I can't make relationship between MailboxTypeId in table MAILBOXTYPES and MailboxTypeId in table MAILBOX why ?
View 2 Replies
Apr 27, 2010
I'm new to asp.net and I'm building a project in which I send data to a database MSSQL, I've set a constraintname on some fields that I wantto be unique, now how do I catch that error when people insert a duble and handle it with a redirectionto custom error pagehere the code just in case you need it
Dim con As New System.Data.SqlClient.SqlConnection
con.ConnectionString = "Data Source=localhost;Initial Catalog=Database1;User ID=user;Password=password;TrustServerCertificate=True"
Dim myCommand As New System.Data.SqlClient.SqlCommand
myCommand.CommandText = "INSERT INTO serves(CategoryID,UserId,vote, Img, link, Description) VALUES('" & DropDownList1.SelectedValue & "','" & UId.Text & " ' ,1,'" & TextBox1.Text & "','" & "<a href=" + TextBox2.Text + ">" + TextBox4.Text + "</a>" &
"','" & TextBox3.Text & "')"
myCommand.Connection = con
con.Open()
myCommand.ExecuteNonQuery()
View 5 Replies
Nov 17, 2010
I have a weird situation.I have unchecked friendly IE errorpages. I have no customerrors in my web.configbut I do get a dns 'cannot display this page' errorpage in IE, firefox works fine.There is no exception in my global.asax and no logging. How can I see more information about this error?
View 7 Replies
Mar 23, 2011
had a data table in which i made one column as primary key..the data table is binded to stored proc output..now the datatable is not allowing same values for primary key column,functionality is fine..but the exception is not raised ..simply row is not getting added to grid view..but i want an exception to be raised..how to do that??
View 1 Replies
Nov 23, 2010
How to get Unique ID of LDAP logged in User? Is GUID is the unique id of each user?
View 1 Replies
Oct 6, 2010
I want to show implement Friendly HTTP Error Message feature on server side. Anybody provide appropriate sample to show the custorm error page.
View 1 Replies
Aug 9, 2010
I developed a site for a client a couple of years ago. It uses the the standard ASP.NET Membership, authentication, etc. I just added the profile section with (2) fields: CustID AgntID. Now whenever I load the page with any Profile code in it I receive this error: Violation of UNIQUE KEY constraint 'IX_aspnet_Users'. Cannot insert duplicate key in object 'dbo.aspnet_Users'. The INSERT statement conflicted with the FOREIGN KEY constraint "FK__aspnet_Pr__UserI__3CA9F2BB". The conflict occurred in database "broo001", table "dbo.aspnet_Users", column 'UserId'. The statement has been terminated. The statement has been terminated. 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.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_aspnet_Users'. Cannot insert duplicate key in object 'dbo.aspnet_Users'. The INSERT statement conflicted with the FOREIGN KEY constraint "FK__aspnet_Pr__UserI__3CA9F2BB". The conflict occurred in database "broo001", table "dbo.aspnet_Users", column 'UserId'. The statement has been terminated. The statement has been terminated. Source Error:
[Code]....
Stack Trace:
[Code]....
Here is the code from my web.config:
[Code]....
Here is some of my page code:
[Code]....
View 3 Replies
Mar 18, 2011
How can I get unique session ID for every unique user who logs in ?? I'm using asp.net/c#
View 1 Replies
Mar 31, 2010
I've tried to implement two different solutions that use either and HttpModule or and HttpHandler to do URLRewriting for me. These work great on IIS 7 within my local development environment in Integrated and Classic modes. Currently the production server is running IIS 6.0 on a shared hosting environment. It appears that the request at least hits both the Module and Handler as the URL above redirect to the particular friendly url, but it doesn't redirect and hit hte Module or Handler again. Instead I get a 404 error for the friendly URL.
View 2 Replies
May 12, 2010
for example, the following url is generated
[URL]
based on the title: How to Install a Copy of Windows XP on a MacBook With Boot Camp.
Is there any .NET code generating the user friendly url out of user input?
View 9 Replies
Jan 30, 2010
May I know which is the best and user friendly CMS for C# asp.net which is free and a link to it..
View 4 Replies
Dec 30, 2010
I have an asp.net web application that queries a database with a SELECT query in a stored procedure. If the server returns an error, I want to display a friendly "sorry, there was a problem with your search" type message.
Should I handle this with a custom error page, and a redirect to that page in web.config? Or can put some text in a Label Control and set its property to visible if there are errors? I've seen the latter done with a Try/Catch arrangement in the code behind, but not sure if I can do that here. What would you recommend?
My code behind is below for the page that displays the search results:
[Code]....
View 1 Replies
Mar 8, 2011
All the examples and websites i have looked at redirect a user to the error.aspx page when an error occurs. How do you just display a friendly error message on the page the user is viewing saying something like "Sorry unable to do whatever" I've tried using a try catch block on my class that executes a stored procedure and put another try catch on the controller, but this does not work and i still get the default error message (System.InvalidOperationException was unhandled by user code) My code is below:
[Code]....
So how can i just return ViewData["SqlError"] message in page.
View 7 Replies
May 5, 2010
using vb.net/asp.net 2005 and SQL Server 2005.I had similar issue yesterday: I created a unique index on a table to prevent duplicates when user tries to edit existing records in a gridview.This works fine and I am seeing the "cannot insert duplicate key row message...." however I need to catch the exception because I do not want to display the table and column names.I have this set up but its not catching the exception, the exception is displaying but not my version, does anyone know in what gridview event and how I can catch and customize this exception? what i have now (but not working ) is:
[Code]...
View 2 Replies
Jan 4, 2010
I am interested in the architecture of a CMS where i can pass a full URL instead of a query string. I would like to make a site that could handle a request to any page... Say'http://www.my-domain.com/directory/page.aspx'and have the resulting response deliver a generic page/file.I would like the request to be passed through an XML document where i could store page names and the corresponding file to render content...
View 1 Replies
Jan 6, 2011
I want to add a search field and have search results display in a user-friendly format on an employee intranet. Does anyone know what component(s) I can drag over from the toolbox to create these two items?
View 4 Replies
Dec 21, 2010
I've procedure that does the below task.1. Create a #table from an existing table2. Insert data into the temp table, this copies few duplicate records into my temp table3. After insert, I'm creating a cluster index for the temp table to enhance my search option later.While creating the Index, I get the below message.[CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 1. Most significant primary key is 'type ad, len 16'.
View 1 Replies
Dec 22, 2010
How to create Rich user friendly and look and feel application in ASP.NET. I am going to create the web application but after the development our aim is zero support that's why we desired to develop the application as user friendly and look and feel. what are all the new features in asp.net to develop the application as user friendly and look and feel.
View 6 Replies
Aug 19, 2010
I am new to asp.net programming. While working with windows form(windows application) i have created a window for editing purpose(just like popup window ) which contains three bounded dropdown list a button and a gridview. After making selections from the drop down when we press button the corresponding result should display in a grid.After that when you click on the grid row it will load the corresponding datas in my form. i want to create such control in asp.net . i have to use jquery or ajax. And this pop up window i have to use more than twenty times in my application.am using VS2008 ASP.NET and C# 3.5.
View 3 Replies
Aug 3, 2010
I am working on a 3-tier asp.net application. Currently I'm stuck up in a situation where I need to handle a specific type of exception (User Defined) in DAL and Show alert to the user if that exception occurs in DAL.
I tried following things:
1) I raised that exception from the DAL and catch it in BLL and throw a new BLL exception to for that DAL exception and finally catch it in the UI layer to show the alert to the user. I've successfully implement this in my project. But there are some issues in this approach. First of all I feel this is not right way to do this as it may lead to performance related issues. Secondly, the application contains more than 500 pages and classes. so I need to attach additional catch block in every method to catch the BLL exception. which is the last option i'd like to take.
2) in second approach I logged the the DAL exception into a text file. but problem in this approach is that how could the UI layer know that exception has occurred and show the alert to the user. Is there any event in asp.net where i could handle all this activities?
my question is what is the best approach to handle this type of situation? Will Exception handling block help me in this?
I've tried reading many articles on this but i couldn't get an answer for my question? I might not be using right keywords for my search.
View 4 Replies
Apr 19, 2010
I have a folder on my web server that has hundreds of mp3 files in it. I would like to provide the option for a user to download a zipped archive of every mp3 in the directory from a web page.
I want to compress the files programmatically only when needed. Because the zip file will be quite large, I am thinking that I will need to send the zip file to the response stream as it is being zipped, for performance reasons.
View 3 Replies
