im using try catch to handle this error uponm deletion of record that is foreign key to other table but it seems that my try catch is not working. im using asp.net (VB). can anyone help me???' i want to display an error message in my page.
View 1 Replies
myCommand = New SqlCommand(
"INSERT INTO tblBook(BookCode, BookTitle, Author, PublishingYear,
Price, EnterDate, CatID, RackID, Amount)
VALUES('" & txtBookCode.Text & "','" &
txtTitle.Text & "','" &
[Code]...
The INSERT statement conflicted with the FOREING KEY constraint "FK_tblBook_tblCategory". The conflict occurred in database "CIEDC", table "dbo.tblCategory", column 'CatID'. The statement has been terminated.
Was that because of my database's relationships?
I am new to VB.net and have created a simple master detail windows form. I created a two table data set and then dropped the master table on the form as a continues form or a detail form with several text boxes to enter data. The child form is a data grid and was simple drag and drop from the data-set. All of this was done with drag and drop and I have added nor changed any code.test data that I have added directly to the database shows up with the proper parent child relationships on the form. I can also enter new records into the database using the parent only portion of my form. I can also update a child record.When I attempt to enter a complete record with data in both the parent form and the child data grid I get this error.
The INSERT statement conflicted with the FOREIGN KEY constraint FK_tblComplainant_tblUseOfForce. The conflict occurred in database "C:\SQLFILES\CCTS_2.MDF", table "dbo.tblUseOfForce", column 'UOFID'. The statement has
[code].....
I'm creating a program that uses sql statments to input data into a data base, but I'm having a problem with this error:The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Job_ProductCode". The conflict occurred in database "FabList.mdf", table "dbo.ProductCode", column 'ProductID'. The statement has been terminated.
[Code]...
This happens occasionally in my app. How can I prevent this:INSERT statement conflicted with the FOREIGN KEY.[code]
View 1 RepliesI have a datagridview in which the user can add new rows. The datasource is a datatable who has a unique-constraint for the column "Position". Thus, if the user enters a position already existing, an exception is thrown. To avoid the ugly standard error message, I simply handle the dataerror-event and set e.cancel = true. This works. But if the user presses escape, the row_validated-event is triggered. I use this event to format the rows containing new data by changing the font color to red. Here another exception is thrown (SystemOutOfRange-Exception) telling me that the index xxx has no value. How can I achieve row-formatting for new/modified entries without getting this error?
Here is my code:
''' <summary>
''' Catch exception and cancel illegal action.
''' </summary>
''' <param name="sender"></param>
''' <param name="e"></param>
[Code] .....
I just watched a video from Beth Messi about setting up a primary key and foreign key on a table.
I created two tables, one called customer and the other one called orders CustomerID is the primary key to the customer table OrderID is the primary ket to the orders table and CustomerID is foreign key to the orders table
Beth Messi said that this would maintain the integrity of the tables and she also mentioned something about setting up a cascade delete so that when we delete a record in the customer table, the customer's order in order table will get deleted as well.
how I can set up the cascade delete, Meanwhile, I tried deleting a customer record in customer table - a customer with orders, and I got the following error when I clicked save.
The DELETE statement conflicted with the REFERENCE constraint "FK_Orders_Customer". The conflict occurred in database "C:DOCUMENTS AND SETTINGSLOUISLOCAL SETTINGSAPPLICATION DATATEMPORARY PROJECTSWBINDEBUGTEST.MDF", table "dbo.Orders", column 'CustomerID'. The statement has been terminated.
Shall I use try catch to warn the user that the record that I tried to delete has an order? They can't delete the customer unless the orders table's record is deleted first?
I have a form with comboboxes, if the user doesnt select a value in the box I want a null to be sent to the database. The insert works fine, i look at the record in the db and see the null. The update doesnt work. gives me a n "Update statement conflicted with foreign key constaint....."
Public Sub Update()
TableAdapterCreate().Update(ID1, ID2, CType(cbox1.SelectedValue, Integer), CType(cbox2.SelectedValue, Integer), CType(cbox3.SelectedValue, Integer), CType(cbox4.SelectedValue, Integer),
[CODE]...
As I step through the selected value of the cbox 5 is shown as nothing (which it should be because the user didnt select a value for this combobox). I assume this needs to be a null instead of nothing to get written to the database. the combox boxes need to match a primary key in another table so sending a 0 would also result in the forieign key error since the related table does not have a 0 ID field.
I'm converting a pretty large chunk of code into a Class so that it can be re-used more easily, but am having a problem with one of the Methods. I have a method that uses the following line:'GET HANDLE OF ANY POPUP WINDOW ASSOCIATED WITH MAIN FORM [code]The "Me.Handle" part won't work, but I don't know what to replace it with so that it knows to use the handle of the main application's form that is using the Class.Do I need to get all Process that match my application's and store the Process' handle?
View 7 RepliesI am using KeyPressEventArgs to restrict several text boxes to numeric entries only. Rather than repeat the code, I thought I would make a "RestrictToNumeric" subroutine and call it from each "KeyPress" event. Like So:
Private Sub txt1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txt1.KeyPress
RestrictToNumeric()
End Sub
[code].....
The problem I am encountering is that the variable 'e' is used before it has been assigned a value, causing a null reference at runtime.
So I tried to add Dim e As System.Windows.Forms.KeyPressEventArgs As?to the RestrictToNumeric sub.I cannot figure out what I need to "Dim" it as...
I wonder how to use statement handles exceptions?Do I need to wrap the using statements with a Try/Cath/Finally clause in order to be sure that the SqlConnection object is closed and disposed even if the containing code throws an exception? [code]
View 3 RepliesIf I have an ObjectDataSource setup like:
<asp:ObjectDataSource
ID="ObjectDataSource1"
runat="server" [code].....
How do I get the objectdatasource to use the Delete method with the parameter that is not an Employee object? what is the recommended alternative architecture?
Edit:
To clarify, I want to use the method signature on my data/business object as shown above, however if I try to allow an Employee object to be passed into some of the methods using DataObjectTypeName, then I seemingly lose the ability to have some methods take just an integer id for instance.If I do not use the DataObjectTypeName, then I have to place all the method parameters in the ObjectDataSource and change the methods on the data/business object to match, this seems like a bad design choice because as the Employee object changes I will have to update each of these methods.
This is my code and it's not working it doesnt delete any records in my listview and my database. What's wrong with this code?[code]....
View 15 Replieshow to delete a project reference set. i have had mysql connector 6.xx.0 but due to bug i uninstalled it & reinstalled 5.x.x now i am unable reset the project reference
View 3 RepliesI am trying to work programmatically with a dataset. The tableAdapter was created by dragging and dropping the dataset on my form, and then deleting the binding navigator and dataviewgrid. The problem I am having is when I am trying to delete a record that is DBNull. The dataset.delete( ) call creates fields for each of the fields, along with their data type (say Description as String). but I get an error whenever the field has a DBNull value.
CourseTableAdapter.Delete(DBDataSet.Course.Item(1).CourseID, DBDataSet.Course.Item(1).CourseDescription)
The error is Throw New Global.System.Data.StrongTypingException("The value for column 'Description' in table 'Course' is DBNull."I do have Option Strict On, but the problem exists even if I turn it off.
We have inherited a vb.net 2003 web project, it seems to reference another web site. I am not sure how this was done. I cannot delete the reference (there is no properties and will not respond to pressing the delete key). The reference looks like a folder with a pic of the world on it. Any ideas how to get rid of it?
View 2 RepliesI am currently teaching myself the caveman code of Visual Basic (VB.net). Apparently I fail at If-statements or something, because I cannot get this to work...
[Code]...
I build some dlls to be used in a big application, and have a team working in the dlls heart of the application and another team working in the GUI, but I am having a problems in the deployment of the dll's when a change is done, because the GUI team needs or copy the new dll to the project folder, or delete the old reference and add the new one. I am using Visual Studio 2008 and developing in VB and C#
View 1 RepliesI have a GridView and on a row being deleted I trigger the GridView1_RowDeleting sub, but I receive an error "LINQ to Entities does not recognize the method 'System.Web.UI.WebControls.TableCell get_Item(Int32)' method, and this method cannot be translated into a store expression." Code is:
Private Sub GridView1_RowDeleting(sender As Object, e As System.Web.UI.WebControls.GridViewDeleteEventArgs) Handles GridView1.RowDeleting
' The deletion of the individual row is automatically handled by the GridView.
Dim dbDelete As New pbu_housingEntities
' Remove individual from the bed.
[code]....
The specific line erroring out is:
remove_bed.First.occupant = ""
I have an XML file that looks like
[Code]....
I am trying to delete the song node from the xml file but i can't figure out the cause of the error I'm getting. I'm still learning visual basics. Error: Object reference not set to an instance of an object. This is my code
[Code]....
I have the following Stored Procedures create or replace PROCEDURE WEB_AC
[Code]...
First one: At some point in the application I have the valor parameter (of the visual Basic Function) as a string with spaces that is something like "some string with spaces". When this happens, the stored procedure don't update the table. If I execute the SP directly in the DB (with SQL Developer) all works fine. I know it has something to do with the string missing some quotes(') but I haven't make it work yet. Some ideas on this?
Second problem: Sometimes, when debuging the application, if I interrupt the execution, I start getting the ORA-24338 'statement handle not executed' error for hours every time I try to execute it again. I believe it has something to do with an open transaction. But honestly, as I'm new in working with Oracle, I really have no idea what the problem could be.
[Code]...
How do you insert/update in a datagridview which is 2 table is bound into it (inner join statement)Best Regards,Iannoob vb programmer
View 1 RepliesIs there any way to get reference of an object by its handle that obtained through FindWindowEx API?
this object is a user control written in .net.
I am using asp.net with vb for my scripts.I want to use an array of a Structure to store data parsed from an xml file.[code]All appears to work fine until I add the code that is in bold, I then get the Object reference not set to an instance of an object.
View 6 RepliesHow can be find out which file is going to delete when, user provides command like DELETE or SHIFT + DELETE or by programmatically gives DELETE command. Well I know about FileSystemWatcher Class, but this class doesn't provide information before delete...
View 1 Repliesi am trying to write a code in which i need to perform a update but on primary keys how do i achieve it
i have written the following code: kindly look at it let me know where m wrong
[Code]...
i am trying to write a code in which i need to perform a update but on primary keys how do i achieve iti have written the following code:
Protected Sub rgKMSLoc_UpdateCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles rgKMSLoc.UpdateCommand
Try
KAYAReqConn.Open()
[code]....
I'm developing an app in VB.Net (Visual Studio Express 2008, on Windows Vista) that connects to an Access relational database. The database has 3 related tables (TextSections, LineItems, Cycles) that I'm loading into my dataset. I've set up two foreign key constraints and want all changes to cascade through the related records in the child tables. I cannot get the cascades to reflect through.
For example, when I delete the parent record, the children records remain (in the database - they are removed from the dataset). Also, when I modify the parent record (change the Description field for example), the change is not reflected in the dataset datatable that holds the children records - unless I go through and ReLoad all of the data from the database and re-Set the constraints. I have set the .AcceptChanges, .UpdateRule, and .DeleteRule to cascade, and have also set EnforceConstraints on the dataset. Why aren't the changes cascading through the children?
Below I've pasted (1) the Load Routines for my datatables TextSections (parent), LineItems (child), and Cycles (child of LineItems); (2) the method that creates the constraints in the dataset, and (3) The Save routine for TextSections.
Friend Sub LoadTSTable()
Dim key(1) As DataColumn
Dim newCol As New DataColumn
[code].....
I'm experiencing some weird behavior when trying to modify some DataTable objects. Upon the second call to the subroutine, I get the following error when I to copy the source DataTable to a working set:
System.Data.ConstraintException was
caught Message="Column 'pk' is
constrained to be unique. Value
[code].....
I have a problem running a simple query: "select distinct payee from table". This query is set up in the dataset and is called GetAllPayee.My code goes something like:
Dim dtSources as new Datatable
dtSources =
Me.TblExpenseRecordsTableAdapter.GetAllPayee
Upon running I get the error:Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.The problem is, I haven't set ANY constraints on either the new datatable, or the dataset table (tblExpenseRecords). i.e. there is no primary key etc.
Can someone please help me out with this problem?I have no problems running the query through the wizard where I can view the results successfully.
