DataSource Controls :: Inserting Foreign Key Value If It Doesn't Exist?
Sep 2, 2010
I am inserting a record and want to set the value for a foreign key but I am getting an error - I initally thought that it would insert it if it didn't exist but I must be wrong and want to confirm that I need to check all values and make a record for them if they don't exist... here's what I am trying to do - does his make sense?
var newAllPart = new Part();
newAllPart.PartNumber = partNumber;
newAllPart.Manufacturer.ManufacturerName = partManufacturer; // error here if the Manufacturer doesn't exists already
newAllPart.PartType.PartTypeName = partType;
newAllPart.Category.CategoryName = partCategory;
newAllPart.DateCreated = DateTime.Now;
newAllPart.UserCreated = userCreated;
newAllPart.Package.PackageName = partPackage;
newAllPart.Statuse.StatusName = partStatus;
localDB.Parts.InsertOnSubmit(newAllPart);
localDB.SubmitChanges();
On our company we have a intranet site which uses ASP classic to authenticate users before accesing the site. This site was working before but suddenly i throws an error which limits the users in accessing the intranet site. I made a debugger page in order to know the error of the application and it showed me this error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. On my local machine the page is accessible on my (IIS server) the connectionstring in the web server and in my localhost are the same. I just can't figure out what's causing this problem.
1) on a button click, new web page(New.aspx) should open and this new web page is populating data from an xml file and if this xml file doesnot find then it should redirect to another webpage ErrorPage.aspx.
I am trying to insert a foreign key into detailsview so that user didn't have to enter value every time. I am using the following code to do this but it is failing. I am not sure what needs to be done now.
Protected Sub LinqDataSource1_Inserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.LinqDataSourceInsertEventArgs) Handles LinqDataSource1.Inserting LinqDataSource1.InsertParameters("Company").DefaultValue = Session("Company_new").ToString() End Sub Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim company As String = Request.QueryString("Company") Session("Company_new") = company End Sub End Class
I need to populate the foreign key coloum in the table.
i have three tables PATIENT DETAILS ptID firstName lastName address IMPLANT DETAILS impID ptID productID productSerialNo PRODUCT productID productName
I am instering data in PATIENT DETAILS and IMPLANT DETAILS table on the same page from single button click .
I have a foreign key on the table IMPLANT DETAIL (productID) which i populate through the value on the dropdownlist .
What my problem is how will i populate foreign key (ptID) in IMPLANT DETAIL table. When ptID (PATIENT DETAIL) will also be generated from the same button click at almost of the same time.
There is this error troubling me whenever i tried to do something to the ShopCart such as add to cart.
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ShopCart_Shopper". The conflict occurred in database "DIYERA", table "dbo.Shopper", column 'ShopperID'. The statement has been terminated.
I checked the database and the foreign key, ShopperID, was set correctly.
This is the first time I have been working on databases and I am trying to insert data using an object datasource but no data is being inserted and no exception is thrown. I'm not sure where I am going to wrong. I am putting user data into session variables and inserting the session variables into the dataacess class layer and have a try and exception but nothing being thrown. Any help would be really appreciated because I don't know even where to start looking with this or how I can get the error to be thrown. Please see some of my code below to give an idea of what I am doing
Object Access Class public void InsertCarPolicyHolder(PolicyHolderClass ph, CarInsuranceOptions options) {
I am trying to create a stored procedure where I can insert null values in columns that have a foreign key constraint and allow nulls. The columns I am trying to insert nulls into are commentid and imageid. I have created an Insert statement in a stored procedure and I get the foreign key constraint error. Can you tell me how to allow inserting data in the other columns without having to insert anything in the commendid and the imageid?
Here is my exec of the stored procedure that is not working:
i am currently working on an asp.net mvc 2 web app using LinqToSQL. I would like to handle a scenario where a user comes form a country and for this i have set the users - countries db relationship and in my user model i have a CountryId property.
I would like to display the country name on my users display view, so i tried fetching the country name like this: User.Country.Name, but an exception occurs that i cannot access a disposed object. I understand that this is caused by the way i handle my users repository and service.
This the repository users code:
[Code]....
This is the service users code (the repository is not class level property, but a local one that gets dipsosed immediately after calling it):
[Code]....
So, how could i handle such a scenario, where i would like the Country model to be also fetched in order to use it later? Should i convert the repository model a class level proprty in order not to get disposed?
how can i retrieve the all foreign keys against a single primary key. i mean to say that if a table contain a primary key then it becomes as foreign keys in which tables.
i want to take that nam of that tables and on the base of that tables then i am to delete from all the entries. e.g: if a primary key's column entry deleted then all foreing key entries should also be deleted.
there are 988 tables in a single database. it can't be possible to go for each table to setup foreign key to ON DELETE CASCADE.
.can it have any way to delete against foreign key priority wise? mean to say that parent table contain primary key, child table contain foreign key , now there is another child table which dependent previous child table. then how can i delete all record against it?
i want to do it from programatically. i am using sql server 2005
i have completed this till to that , it retrieves all foreign keys but how to delete now on the base of priority.
I have a stored procedure to insert data into Table B, but when I tried to insert a null value into column ID of table B, this error came up:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tableB_tableA". The conflict occurred in database "database name", table "table A", column 'ID'.
I am guessing adding nothing to the null value column is the problem, but i don't know how to fix it... The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tableB_tableA". The conflict occurred in database "database name", table "table A", column 'ID'.
I get this error: Description: An error occurred during the compilation of a resource required to service this request. review the following specific error details and modify your source code appropriately. Compiler Error Message: CS0234: The type or namespace name 'Xml' does not exist in the namespace 'System' (are you missing an assembly reference?) Source Error:
[Code]....
Line 15: using System.Web.Services.Protocols; Line 16: using System.ComponentModel; Line 17: using System.Xml.Serialization; Line 18: Line 19:
Source File: c:WindowsMicrosoft.NETFrameworkv4.0.30319Temporary ASP.NET Files oot4db438488b8d9090App_WebReferences.j5ljvr6f.0.cs Line: 17
I have this in my web.config: <compilation debug="true" strict="false" explicit="true" ><!--targetFramework="4.0"--> <assemblies> <clear /> <add assembly="System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/> <add assembly="System.Web.Services, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/> <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/> <add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/> <add assembly="System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> <add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> </assemblies> </compilation> <pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID">
my application in vs2005 / 2.0 framework , right now i change it with VSD08 /3.5 framework according when i change it open it with 08 at first time it get ask me ( you want to convert the application framework 2.0 to 3.5 ) i said yes , after that i was trying to run the application it get works on that machine means on ( locahost) but not able to access that on netowork its shows an error:
The name 'xxx' does not exist in the current context ( if i try to run any function within app_code ) then it shows me shuch error i wan also rebuild my appliciton , but noting get happen shall i create a new project and then copy my old code?
i have uploaded all of my release mode published dll's and aspx to the server, but when i access the site from local machine its giving error as
Parser Error
Description: An error occurred during the parsing of a resource required to service this request. review the following specific parse error details and modify your source file appropriately.
Parser Error Message: The file '/ProjectName/Index.aspx.cs' does not exist.
I created a PageLoad event, so when the page opens it fills all the fields from a DataSource control. However, the problem is that if the DataSource control is empty (the row does not exist yet) it gives me an error. How do I check that if DataSource Control has a row of data or not?
i am bulding something for myself in asp.net and SQL but am having a few problems. I will list them below and see what happens :)Please note that i have a lbl control permantly on my pages which is set in the master page, this is what displays my messages.example = message.text = "Please insert your name"1. I have a data table that calls a table with its values. its basicly 4 ddl's(day, month, date & year) select what date then search. Mon Mar 21 2010 SEARCH(btn)
" SqlExeption was unhandled by user code "
this is basicly because the table doesnt exist. How do i tell asp to return a message if the the table doesnt exist in sql server.
I'm trying to insert a new EF object containing a reference to a related table via foreign key, and cannot get the reference stored in the new object. I have two tables in a SQL Server 2008 Database:
Component Templates PartGroups
with a Foreign Key linking them thus: ComponentTemplates:ID [0..1<->*] PartGroups:ComponentTemplateID
I have imported these tables into a .NET web application project .edmx file (using a new ADO.NET Entity Data Model), and then created a Data Service which I then reference in a Silverlight 3.0 project. The objects are available as expected in the data context called by my Silverlight app and load correctly. Now, when I try to save a reference of ComponentTemplate into a newly created PartGroup, the PartGroup object is created in the database, but the value of ComponentTemplateID in the newly created table record is NULL.
[Code]....
(Note that _ctCtrl.ComponentTemplate is a confirmed non-NULL object reference to the parent object on which PartGroup is a child)
I am creating a project in which i want to display my web page in full screen & Does not allow the end user to ext the full screen until he/she press the button. I google/bing but i dint get any help full material. Even i use this code