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:
[Code]....
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.
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?
View 9 RepliesI am using a from view for data entry. I need to verify that a check box is true or false after editing a record.
I have been accessing label text using the following|
CType(FormView1.FindControl("RespDeptLabel"), Label).Text
How can I access the state of a checkbox in the form view to determine if it is true or false
am having to difficult inserting into a data base using a form, still having some errors.
View 1 RepliesI 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#.
View 2 RepliesI want to insert data in grid or table form in sql server2005. Which control is better to use?
gridview or repeater
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.
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.
View 5 Repliesi have create a simple form using form view...
in my form i have use DropDownList..(Id = DropDownList1)
when am trying use that dropdownlist in my cs page i can't get id..
I have a form view with a couple of text boxes on them. I want to make the text values available elsewhere on the form I have been trying
The following works fine and is how I expect:
[Code]....
[Code]....
I want to add a formview on the page using C# code.
View 1 RepliesI am trying to use this query in a form view "Select * from actions where emp_id = " & session("emp_id") for the select command. This is the format I am used to in classic asp. How can I acheive the same results in asp.net.
View 2 RepliesI have 2 dropdownlist in my detailsview that second dropdownlist get thier data based first dropdownlist selecet value;
following error arised:
Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control
I solve it by this solution:
[Code]....
current problem:
when I want to insert new item ( detailsview insert mode), default value of my DropdownList sent to parmlist
I am using a "Detail View" to edit the data in my "Customer" table. The fields are "CompanyName", "ContactPerson", "StreetAddress", and "City". If I type data into the first field ("CompanyName") and then press the "tab" key, control moves to the second field "ContactPerson". However, if I type data into the first field ("CompanyName") and then press the "Enter" key, instead of control moving to the second field ("ContactPerson") the program closes the form.
Is there someway that I can control the action of the "Enter" key so that this will not happen?
Also, is there any way that I can have control move from the first field ("CompanyName") to a field other than the seconc field ("ContactPerson") if the content of the "CompanyName" field contains the value "Internal"?
I have a form that shows simple table and let the user select a row. when user select a row the record shows in a formview below the gridview. After I update the formview changes take place in database but shows in gridview ONLY the next time I load the page.
[Code]....
I have a formview that runs of an SQLDS, very simple stuff. Inside that form i have various fields, one of them is a credit field, one of them is a debit field. Now i have put a radio button list with two radio buttons (credit and debit). What i want to do is when the "credit" radio button is enabled i want the "credit" text box to be enabled and visa versa.
I know how to reference an object inside a formview, but i am confused, do i reference the radio button list and then the list items inside it or?
Once again something for a new bee... I have 3 questions -
1. I wanted to add a drop down list instead of a text box to my grid control (which should come up on clicking editing)
2. Similar control for form view
3. On click "select" in a grid view, I want to open a new web page which will show a form view attached with the same "select" index.
I need to do a custom update for a form view (I think/know), as some of the parameters that are required for updating values should not be updated by the users, such as userid of the person performing the action which is passed back to the database for auditing purposes.
Additionally, there are some fields, such as LastUpdatedBy, LastUpdatedDate that need to be seen, but not edited. The stored procedure on the backend takes care of this, and these are not parameters for the Update method. The FormView by default is trying to pass all these values back to the database.
Lasty, the select query of the object datasource is a stored procedure that performs several joins based on PF/FK relationships to bring back more meaningful information than just a FK, so some columns are just the joined value, and can not be updated directly. Again, formview is trying to pass these parameters
So given that, I have defined the following even handler for a simple form view:
(not sure if this is the way to proceed given the above, but...)
protected void FormView1_ItemUpdating(object sender, FormViewUpdateEventArgs e)
{
ProjectDetailsDataSource.UpdateParameters.Clear();
ProjectDetailsDataSource.UpdateParameters.Add("projectID", ((Guid)e.Keys["ProjectID"]).ToString());
ProjectDetailsDataSource.UpdateParameters.Add("projectName", (string)e.NewValues["ProjectName"]);
ProjectDetailsDataSource.UpdateParameters.Add("description", (string)e.NewValues["Description"]);
ProjectDetailsDataSource.UpdateParameters.Add("projectTypeID", "1");
ProjectDetailsDataSource.UpdateParameters.Add("statusID", "1");
ProjectDetailsDataSource.UpdateParameters.Add("productID", null);
ProjectDetailsDataSource.UpdateParameters.Add("isComplete", ((bool)e.NewValues["IsComplete"]).ToString());
ProjectDetailsDataSource.UpdateParameters.Add("isActive", ((bool)e.NewValues["IsActive"]).ToString());
ProjectDetailsDataSource.UpdateParameters.Add("userid", Membership.GetUser().ProviderUserKey.ToString());
ProjectDetailsDataSource.Update();
FormView1.ChangeMode(FormViewMode.ReadOnly);
e.Cancel = true;
}
My questions are as follows:
1) Is this the right approach?
2) Is so, when I cancel the edit (because I did the update myself), and change mode, the FormView returns to read only mode as inteneded (good so far). However, when I hit F5 (refresh), the ItemUpdating method is called again, and updates the database.
how to call AJax rating control in Form view ?
I have 1 rating control in fromview in code behid page i wan to call Ajax rating contrl in formview for determine event and property .
I am new to working with the Form View control so I am not quite sure how to do this.
I want my users to be able to enter search criteria into text boxes at the bottom of my FV just beneath a table and then click a button to initiate a DB search and rebind of the form.
Where do I create/ access the button's event handler to make this happen ?
I would like to have buttons in the Item template and possibly the edit template sections of the FV.
So I have created my buttons and now I want to access their button click events.
Here is my meager start this is located in the Formview databound event:
[Code]....