I have tables two tables, the "book" and the "author", a book can have many authors and vice versa, so there is an intermediate table called "book_author" with two columns as foreign key for those two primary keys
book_author
book_id
author_id
I'm trying to edit the book details and also its author using the entity date model, The controller class method
[Code]....
The HTML edit form
[Code]....
I can only update the book table, but not author that the book has or the book_author, I'm new to asp.net, I can't easily find a tutorial on this issue, I think the logic is to delete the author of the book first and then add the author for that book, but I don't know exactly about that linq and C# code. Can show me? I can only update the book table, but not author that the book has or the book_author, I'm new to asp.net, I can't easily find a tutorial on this issue, I think the logic is to delete the author of the book first and then add the author for that book, but I don't know exactly about that linq and C# code.
how i call a image field from another table? the image field in the same table is working fine but the one on the other table is not. I have created the foreign key and made the connection... What else do i need to do to call that field? Page Load:
I have 2 Tables , OrderDetails and Requests In my LINQ to SQL dbml file. OrderDetailsID is a foreign key in Requests Table. I want to write the query to get the sum of UnitCost from OrderDetails based on OrderId. And If there is a row in Requests Table for each OrderDetailsID, and the Requests.Last.RequestType="Refund" I want to reduce the total refund amount from the main sum otherwise If there is no row based on OrderDetailsID, add to sum. Here is the way I implement that. I am looking to prevent using "For each".
iRefund = (From od1 In dc.OrderDetails _ Where od1.OrderID =1 _ Select od1.UnitCost).Sum Dim objOrderDetails = (From od1 In dc.OrderDetails _ Where od1.OrderID =1 _ Select od1) For Each OrderDetail As ORM.Entities.OrderDetail In objOrderDetails If Not OrderDetail.Requests Is Nothing Then IF OrderDetail.Requests.Last.RequestType="Refund" Then iRefund -= OrderDetail.UnitCost End If End If Next
I have to find the best way to do this using LINQ. I need to summarize an amount in a iTransaction table by
Account (e.g. 12345) and add that amount to an same Account ( e.g12345) if it exists in a iAccount table . Here is the code which syntax checks ok and tested ok up to the .submitChanges statement (i.e. I stopped and didn't allow the submit.
Following is the LINQ code. (1) Is that a good way to do this. OR should I try the INTERCEPT.
(2) How is the best way to insert a new record/row in the iAccounts table if it DOES NOT exist in the iAccount Table.
But the UpdateUser field does not update - it remains at NULL. No errors occur. I can use similar code to update table fields in other dbmls successfully.
i am working on Linq,as we know to use any table in linq we have to drag and drop it on our datacontext's Designer File,and at run time we got its value,till here no any problem,main point is if any changes in respective data source's schema has made ,then on datacontext we will not get that changes,for it we have to change this datacontext manually by by again drag and drop,it will not happen implicitly when this changes has been made on the data source. how i solve this problem so that datacontext change implicitly without any over head using .net 3.5.
I am trying to update my table ARTICLES and it has a field COUNTER, Everytime a user enter this ARTICLES, the page_load event runs a LINQ to SQL query taking the QueryString as parameter, increasing the COUNTER field in 1.
I have two tables with a foreign key constraint how can I delete rows from both of them in one transaction? linq to SQL seems to call my deletes in the wrong order. Is there somewhere I can check and make sure the constraint is recognized properly by linq to SQL??
I am trying to build the MVC Music Store from ASP.Net, my only problem is that the tutorial is made for asp.net 4.0 C# and mvc2 an i am creating it with asp.net 3.5 VB mvc 1. For now i found out a lot of thing wich will work much better in the new frameworks, but my webhost still doesnt support it, because they have some problemms with PLESK.
Now i have a problem i cant figure out, i cant update data from a dropdown list, in the database using the updatemodel, that are foreign keys. Just all other data wich are not foreign keys and primary keys are updateable. These are automaticly created in the sql entity model.
I have a app that records some jobs and those jobs can have notes attached therefore i connected the table with a foreign key, my notes to a Job.
in the details view of the job i allow the user to view the jobs by sending the id and fulling all the notes that match the id in the index view for the notes table. in the list of notes i have a action link to create a new note, here i sent also the id of the job to the create action of the control and try to insert that intot he note JobId to make the reference. I get this error and the note is not created. the note creats from code but not via the note controller creat action.
i get this - An error occurred while updating the entries. See the inner exception for details. below is the create action in the note controller
public ActionResult Create(int id)
{ // var newnote = db.Jobs.Include("StatusNotes").Single(j => j.JobId == id);[code]...
I have set up a ASP.net MVC application which uses the default forms authentication. It uses the ASPNETDB.mdf like shown here:
I then set up another database connection which is similar to the NerdDinner.mdf file above.
I have a post that belongs to a user. It has a UserId value which needs to be a foreign key to the information in ASPNETDB.mdf. When I go to add a foreign key, I can only see information with regards to the table I made. How do I go about doing this?
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.
i am using sql server 2005 as backend for developing webforms with asp.net using C#.i have two tables table1 and table2.
table1 has user_id(primary key,not null),user_name. and table2 has dept_id(primary key,not null),user_id(foreign key,not null),dept_location.
Firstly i created table1 and insert data in it.. later i created table2 with foreign key relationship with table1..In the add form design of table2 for entering data and insert into table2,i placed a dropdownlist which is binded with user_id from table1...dropdownlist's.datatextfield is equal to "user_name" and datavaluefield is equal to "user_id"..i have to select user_name from dropdownlist.... what i have to do is to insert data into table2... i used the simple sql insert statement as follows..
insert into table2 values(......); but it shows error :insert statement conflicted with the foreign key.
the 1st: PAR_TipiDocumento with idTipoDocumento PK idClasseDocumento [...]
the 2nd: PAR_ClassiDocumento with idClasseDocumento PK [...]
and a foreing key FK_PAR_TipiDocumento_PAR_ClassiDocumento from PAR_TipiDocumento.idClasseDocumentoto PAR_ClassiDocumento.idClasseDocumento.
This is my .cs code for the metadata:
[MetadataType(typeof(PAR_TipiDocumento_Metadata))] [DisplayName("Tipi Documento")] public partial class PAR_TipiDocumento[code]....
The problem is that in the Dynamic Data generated pages I correctly see all the display names "Tipi Documento" except for the header row of the PAR_ClassiDocumento table where I have "PAR_TipiDocumentos" (the plural generated by LINQ to SQL). The values under this column are correctly rendered as links to the PAR_TipiDocumento table with the right display name ("View Tipi Documento").
How can I change the Display Name of that "PAR_TipiDocumentos"?
I want to insert AccountID a foreign key of HappyLand Table. I want AccountID of Happyland to be the same as the AccountInfoID of AccountInfo. I created a relationship between tables, but I still can't get it to insert the AccountID. I am inserting Data SQLDatasource3.Insert()
TABLE HapplyLand TABLE AccountInfo ID INT primary key AcountID INT primarykey AccountID INT foreign key email varchar(50) Age varchar(50) LastName varchar(50) Phone varchar(50)
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.
I have a patient entry table, which has patientID as primary key. if I want to retrieve tests information about a particular test then I have to add a pid as foreign key??
do i have to add a test_ID kinda field in all four tests tables????
I have set up Membership and Roles and can create users and login using the ASp Login control. However I need to associate users with customers (in a Customers table in the database) and display content according to the customer that the user belongs to. Is the best way of doing this to create a foreign key field in the aspnet_Users table relating back to Customers table which would have to be updated manually after creating the user or is there a better way?
I am using SQL Server2005 with asp.net. I want validation at server side to restrict duplicate entries, Here i am using two tables companies and Branches. In Branches Table i had maintain a foreign key of CompanyId. In Branches the BranchName can be duplicate but not for the Particular CompanyId
Perhaps this is a simpler VS9 question, but I want to link a SQLServer table with additional user data to the standard SQLServer membership table using the GUID userID as a foreign key. I go into design mode of my table, right-click on relationships, and click add in the dialog. but the left hand column shows me only the tables in my database. How do I get it to show the tables in the ASPNETDB.MDF database? I went through the tutorial (http://www.asp.net/learn/security/tutorial-08-cs.aspx), but it seems to magically appear in there without explanation.
