Forms Data Controls :: VS 2008 Cannot Insert Foreign Key Value In Form View?
Jul 26, 2010
I have a database with a 1 to many relationship in SQL Server 2008. I have created a formview in VS2008 to insert records into the child table. However I can't set the foreign key to automatically insert this value. If I manually type in a value the insert works but I need it to pick up the fk ID automatically from the master table. How can I do this?
The master table: tblTopic has ID int auto increment primary key and the child table has ID int auto increment primary key and TopicID int allow duplicates no nulls, foreign key. I have set updates to cascade in the relationship.
My insert statement is INSERT INTO tblTopic (TopicID, Comment, SubmittedBy) VALUES (@TopicID, @Comment,@SubmittedBy). The TopicID keeps throwing the error, this is the foreign key.
This is the first time I have tried to do this, so apologies if it's really obvious but I'm on a bit of learning curve.
Are they any special Insert Paramters I shoud/need to use on a formView. I currently have the below datasource but when submitted it only inserts <NULLS> intot he required table.
[Code]....
The fields that aren't being inserted are already pre-populated via the following used FormViews:
I have a search button ..The result will be displayed in grid view if the button is pressed .. i am able to do it
But now i want to do like this ..that is my grid view is only displaying the ResultId .. I want to display the ResultName rather than resultID in the table
I am using Visual studio 2010 express and I have a details view databinded to an sql database table. When I use the Insert option on the view it causes an error due to it trying to insert a null into the primary key field. If the Insert function does not create a new primary key entry how is it created?
I cannot get the value from the drop down list and I not sure what's wrong with the declaration and the code.
Dim selectedIntake As String = intakeDropDownList.SelectedItem.Text() Dim selectedSupervisor As String = supervisorDropDownList.SelectedItem.Text() .supervisor_ID = selectedSupervisor(0), _ .semester_No = selectedIntake(0) _
[Code]....
This is the error message I get :
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_student_Details_lecturer_Details". The conflict occurred in database "SKTM-AAS", table "dbo.lecturer_Details", column 'supervisor_ID'. The statement has been terminated.
I am having trouble with foreign keys Dynamic Data and entity framework 4.0. It feels like there is a problem with the entity association but I am not sure. I have multiple fields representing the foreign key on the insert page.
When I try and insert data I get an error A dependent property in a ReferentialConstraint is mapped to a store-generated column.
Column: 'CommentId'
My data is a very basic one to many relationship, the foreign key in question is BookId in the Comment Table.
[code]...
When I let the scaffolding do its thing, I get multiple fields representing the foreign key.
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
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.
I am writing an insert form (like a survey/questionaire) for a web site to collection data that will call for interactively displaying data from one table after the user enters data for the form; I think it would be like a lookup in standadrd db design, however based on the using it on the web I get stuck on the exact coding requirements.I am currently using Visual Web Designer 2008 Express with the smartdbforms.net tool loaded to create insert, edit & update data to a MSSQL2008 db.
Example:
A Customer logs in to the website and chooses the link to enter data to the database. I have a blank insert mode form for them to fill in the answers to 12 questions (using a smartdbforms.net insert form). The first box is for them to enter their ID#. What I would like is for the first and last name of the user to be displayed on the form (next to the entry box)based on a lookup of the ID# they entered and have it display after they enter it. That data is stored in a differnet table in the SQL2008 db.The db is setup with a insert form data table (empty), and various data info tables that are prefilled to use for validation and edit. I am a windows db designer who is new to the ASP.Net web interfacing commands.
I need to create a form that inserts data into a sql database. I need only a few textboxes but i need the user to select a name from a dropwnlist and it autopopulate the rest of the form with data from the database. Users can update this data and insertthe new data as a new record in the database. I'm not sure how to go about autopopulating the fields tho? I'm using Visual Studio 2010 C#, i'm new to C#.
I have a formview that I want to prepopulate some values based on some dropdowns that the end user chooses.
The formview is in insert mode tied to a datasource so the insert will be easy because it is tied to a dataset.
Just thinking of best way to prepopulate these fields. I am going for a best practice these days.
The one way I planned on doing it, was after they selected the dropdowns I will grab the values from the datasource and do a findcontrol on the formview to populate them.
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 have a grid view and a form view on one page. Using the form view to add data to a table that is presented by the grid view.
My problem is that when you hit insert the grid view does not refresh to show the new data. However it does do this on one computer in my company out of 150 total computers.
why it doesn't work on most all computers, or why it works on this one computer.
I have checked all the settings of this computer and ran reports, there are identical computers in the office that this feature does not work on.
I'm using a formview in Insert mode with an AccessDataSource. I want to switch to readonly mode upon insertion to let the user confirm the input worked, then give them the option to insert a new record. If I set the DefaultMode to Insert, then after the first record is inserted, I get a new blank insertion form (no confirmation). If I set the DefaultMode to ReadOnly, after insertion, I get a blank form (presumably because I am not on the record just inserted).
How do I get the just inserted record to display? If I need to set the ID of the formview to the just inserted record OnInserted, how do I get that given I'm using an AccessDataSource?
I have a DetailsView for inserting values and currently the columns are center aligned. What I want is to have my "label" right aligned and my "text box/dropdown box" left aligned.
Something like:
Name: _______________
Address: __________________________
Phone: __________
Insert Cancel
If I change the alignment to left for both, the Insert and Cancel buttons on the bottom of the control also shift to the left, and I'd like them to stay centered.
My View has to present a form that shows Tenant Desc and Contact related fields. The index view works fine and shows the desired values.
But, the create view isn't working out. In the create view, i am planning to do -
1. creating a new contact entity instance and saving it in db
2. Then creating a new tenant entity instance using the new contact_id and save it to the DB.
However, the code doesn't seem to be inserting any value inside Contacts table. It inserts null value.Below is the code snippet of my Create Controller -
[HttpPost] public ActionResult Create(FormCollection collection) { var newContact = new Contact();[code]....
im having difficulty with a project I'm working on. The project has many data tables however it's three that im concerned with. The tables are applicants, position applied for and positions. In one part of the project I have created a formview which inserts users to our applicants table. This is working fine however now I want the option within the formview for users to be able to select from a checkbox list the positions that they are applying for. I want to pull data from the positions table and the current formview and insert that information to the position applied for table. The primary key for "Applicants" is CSVC, PK for "Positions" Table is PositionID, Key for "Position applied for" is CSVC and PositionID.
