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();
};
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 RepliesIs 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 RepliesI 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 ?
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()
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 RepliesI 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]....
In ASP.NET,How can i know the Specific details about an exception (like What kind of Exception it is (FileNotFound /Arithmentc etc..) )from a General Exception class object.
View 2 RepliesIs there any way to uniquely identify a particular exception from the general exception class.
i.e any property or method that retrieves a unique identifier that to identify a particular exception.
I have kept some error values and corresponding error texts in an xml file. I want to read that xml file and have to taken the error ids and fix the corresponding texts to a label. in the case of a system exception we have to identify a particular exception.
I am beginner in web applications development. I started one little project and host it on source forge "https://homoco.svn.sourceforge.net/svnroot/homoco". And I started implementing authentication in this application to learn how it works. From my experience people never use out of the box things so I want to implement this stuff alone (like in real world projects). So some questions:
1) Is there any reason to use membership out of the box? To use database table schema, stored procedures etc. that tool generate for developer. I think that this lower control over code and I decided to implement it my self. I don't know if I am right.
2) Is my approach in this demo project good or bad (if someone have time I like to do just a little code review)? I created database based on business rules. Not using database schema that membership provider require. Extend "MembershipProvider" class to satisfy my needs. Implement queries to database myself.
3) Now, this question is a little wired but I have to ask it. If we make custom Membership Provider and do sql queries alone, implement all MembershipProvider class methods ourselves, and in application use Membership.blabla() why is this approach different from not extending MembershipProvider class and putting all this methods in some unique class and call its methods then? I hope that someone understand what I ask here.
I am sorry for three questions, but I really trying to find the best way to implement this feature in my demo project like it is a real world application.
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]...
I have a table with three fields, User, City and Country, where exactly one of the fields must be non-NULL at all times. Can I use an SQL constraint for this or should I rethink what I'm doing?
The scenario is that my database should contain documents that can be attached to users, cities or countries. So a row in this table contains exactly one document for either a user, a city or a country. However, one should be able to search for all documents as well, regardless of what entity it has been "attached" to.
The reason I'm not using three different tables instead is that I want to avoid having to JOIN the three tables when searching for documents in all of the three places. I'm imagining that the kind of denormalization I'm attempting to use here will improve performance.
I'm trying to remove a user from the aspnet_Users table.
[Code]....
I received the following error during my try-catch test:
System.Data.SqlClient.SqlException was caught Message=The DELETE statement conflicted with the REFERENCE constraint "FK_lusHmoob_aspnet_Users". The conflict occurred in database "laujtsov", table
"laujAdmin.lusHmoob", column 'whoInsert'.
The statement has been terminated.
Source=.Net SqlClient Data Provider
ErrorCode=-2146232060
[Code].....
The UPDATE statement conflicted with the FOREIGN KEY constraint "FK__Software__Packag__5165187F". The conflict occurred in database "StudentDB", table "dbo.Package", column 'PackageID'. The statement has been terminated.
what i try to do is run this;
[code]....
let say i have 2 table (PARENT and STUDENT table)
the structure for both table are
STUDENT
PARENT
student_id (PK) parent_id (PK)
student_parent (FK) parent_status (the value is either ACTIVE OR INACTIVE)
- parent_id is refer by STUDENT table as a foreign key
- now i want to inactive the status for parent
- i want my system pop out a message something like "The parent you want to inactive is refer by a student, inactive is not allow"
- is it any constraint in SQL Server 2005 to help me check whether parent it is refer by student table? The concept i want to use is something like delete constraint in SQL Server 2005 mean it is not allow to delete a person who is refer by a student in STUDENT table.
I'd really like to know how to do the same thing in my code as going into sql server management studio, clicking on the design of a table, and then from the file menu scrolling to the relationships and disabling the foreign key constraint by selecting no to the 'enforce foreign key constraint'.
View 2 Repliesi have a bizar situation, i have a SSIS package which imports records from a flatfile.First i get rid of all the double records, so I keep only unique records before I put them into the desired table.I have put a dataviewer on the flow and notice that there are no duplicate records, and though the SSIS package fails with a violoation of a promary key constraint.Hs anyone seen this before? It is really strange.
View 1 RepliesI have a SQL Server 2000 table with 7 columns and would like to add a constraint that prevents a row being added with the same value for both Col2 and Col3.
So, for example, if Col2 = 205 and Col3 = 5, then the constraint should prevent inserting another row with the values for Col2 = 205 and Col3 = 5.
The following is an example of what I would like to prevent:
Col1 Col2 Col3 Col4 Col5 Col6
1 205 5 1 1 1
2 205 5 0 0 0
I need to disable the "Imagebuttons" after the user click on one of them... I've sucessfully updated the table when the user click on a button using the following code on the event of row command of the gridview..
[Code]....
so please how may I disable these buttons after database is updated ?
I try to create one CONSTRAINT in Sql Server 2008 which checked that:
if Frecuencia = 0 then EsPar <> null
I try to do this:
ALTER TABLE [IngresoxConsorcio] WITH NOCHECK
ADD CONSTRAINT CheckBimestral
CHECK(Frecuencia = 2 AND EsPar <> null)
But obviously don't works
I am trying to use a partial class with Data Annotations to validate with the Entity Framework. My partial class looks like:
[Code]....
When i then try to create a product without an entry in Name or Description i get an exception: _Name = StructuralObject.SetValidValue(value, false);
How to get Unique ID of LDAP logged in User? Is GUID is the unique id of each user?
View 1 RepliesI am part of a team that is developing a SharePoint web part. My task is to create a user control which will ultimately be wrapped in another class for presentation in a web part. Because of these requirements, I must fit all of my code in a single user control.To organize my code in the code-behind, I created a few private classes for the different objects which are represented in the database. I want to add some exception handling whereby if some sort of DB exception is thrown I can update a message on the page informing the user of the problem.
My problem is that the page-level controls are inaccessible from the private class where I'm issuing the query, so even if I catch the exception I have no way of directly accessing a Label control to populate the error. I tried to create a baseclass with an EventHandler defined, but when I throw events from the private class I'm not able to catch them for whatever reason. I'm far from an OOP expert Here is a snippet:
ASP Code:
using System;
using System.Collections;
[code]....
Is GUID (globally unique identifier) really unique, or it can be duplicate.
System.Guid.NewGuid().ToString()
How generate the unique no. 1,2,3 and so on .... on button click of each new user ..
the code mentioned below is a readwrite coding in vb.net ...
but the problem is it generate the same id for different users on button click event... but i want the no. of times button clicked the new ids will be generated
[code]....