I have a formview with insert function into "table1". In that formview i also have a dropdownlist listed with records from "table2". (This dropdown is of course instead of a textbox). get "table1" inserted when one of the field is from a different table?
View 1 RepliesI am trying to change the textboxes in the FormView insert template to dropdownlists but they keep setting the parameters to null. Here's what I have:
[Code]....
In Page_Load
CType(frmSurvey.FindControl("ddlYearOfQualification"), DropDownList).Items.Add(New ListItem("2010", "2010"))
CType(frmSurvey.FindControl("ddlYearOfQualification"), DropDownList).Items.Add(New ListItem("2009", "2009"))
and in the SqlDataSource
InsertCommand="INSERT INTO [tblSurvey] (... [YearOfQualification] ...) VALUES ( ... @YearOfQualification ... )
And in insert parameters:
<asp:Parameter Name="YearOfQualification" Type="Int16" />
And the insert fails with YearOfQualification as null. If I sue the standard textbox:
<asp:TextBox ID="YearOfQualificationTextBox" runat="server"
Text='<%# Bind("YearOfQualification") %>' />
I created a formview that I am using for data input (DefaultMode=Insert)
One of the objects I have is a text box (see below)
[code]....
When I click submit I get a message that I cannot insert a Null into the field IntershipNumAvailable. This makes sense since I made this field a required field in the database.
How do I get the form to recognize that the user selected item is the one I want to write to the database?
What changes do I need to make here? Do I need to make changes to my parameter list?
I have a formview on a web page, set to insert mode as default. The form view is bound to a SQLDatasource. This datasource has a custom query written to select the details for this formview. The query joins two tables to provide relevant detail and not just an ID for one of the elements on the form view.
The first tabe contains information regarding projects and the second table contains detail regarding Resources. First table has the following definition:
[Code]....
I have a dropdownlist that pulls from a datasource. When a name is selected all information drops down to a formview. Once there 3 fields get populated from the dropdownlist and then there is 2 other fields that need user input. Once they hit submit, it should write to a different table in the same DB. I cannot get the fields to populate and write to the DB. Here is my code:
[code]...
I use GridView & FormView to update a record. but when I click the "save" button, throw an except : FormView must be in the insert mode to insert a record. The record has been updated success, and I didn't change the mode of the FormView, how this error comes?
View 3 RepliesI am using the query builder to frame an Insert query that I am using for a FormsView control on a web page. The problem is there are more than 50 fields that need to be inserted and I am wondering if there is any better way to do this... than manually typing in IdNames of controls on the web page in the VALUES (,,,,,,,,,,.......) section of the SQL statement.
View 3 RepliesHow to insert picture into DB from formview?
What control I have to use to locate picture and what technique to adopt.
My working enviornment is 2.0.
In database the table is already created with Binaryfield to store pictures.
Formview1 datasource ID is SQLTest. When I click New on the form and go into insertmode, is there an easy way to auto file textboxID to the value of the NextIDNumber field ( field 9) from SQLTest datasource?
View 3 RepliesI have a FormView with default mode set to "Edit". When I click the Update after making changes the form reopens in the Insert mode.
<asp:FormView
ID="FormView2"
runat="server"
CellPadding="4"
DataKeyNames="ID"
DataSourceID="SqlDataSource3"
DefaultMode="Edit"
EnableModelValidation="True"
Font-Names="Calibri"
Font-Size="9pt"
ForeColor="#FFFFFF"
Height="600px"
Width="1000px"
onitemupdated="FormView2_ItemUpdated"> What am I doing wrong
I have a page with an EntityDataSource and I want to insert a new item using a FormView. However, the SQL database has a varbinary field which I need to insert an image into.
So far, I have all the rest of the FormView correct and it saves no problem. I can also use the asp:FileUpload to correctly obtain the data. I am assumin that I need to add some C# code to the FormView1_ItemInserting Event Handler, but that is where I am stuck. So far, this is what I have:
[Code]....
Would somebody be so kind as to point me in the right direction with the correct code to add this item to the data I am saving.
How do I clear my formview after a record has been inserted or deleted? At the moment it just sits in the previous state with the same details in the fields, still with the Insert button. Either it would be good to drop the formview altogether (I have a grid view on the same page) or move into the edit mode for the just inserted record.
Also the same with the delete - the formview stays on screen with the deleted record details and the delete button still available - I know it has fired though as my gridview is updated.
I have a formview tied to a gridview. The formview shows the data for the row selected in the gridview. The formview is invisible by default , default mode is readonly and becomes visible only on Selecting a row in the gridview. I make it visible in the SelectedIndexchanged event of the gridview. There are Insert and update buttons present outside the formview which perform the insert and update using code-behind. The code is below.
AFter an insert or update, the formview makes invisible again. I want to show the formview with the newly inserted or updated row in Read-only mode. How do I do this?
protected
void gvEvent_SelectedIndexChanged(object
sender, EventArgs
e)
{
if (gvEvent.SelectedIndex
[Code]....
I have a Formview that allows applications to be inserted into a database. Text boxes such as Name, Address, etc. are bound to the database. I'd like to have the text fields checked for proper case and changed if necessary before writing to the database.
I don't care about notifications, or specialities (such as handling McK..). Looks like the strconv() would work, but I'm not sure how to use it - Still pretty new to using this!
I have a stored procedure and a function. I am connecting my FormView to the function and I am trying to insert a new record. I am not sure if the problem is the stored procedure, the fucntion or the FormView.
Stored Procedure:
[Code]....
Function:
[Code]....
FormView:
[Code]....
I am working on a web app for an online photo album. It is the last project in Scott Mitchell's book: "ASP.Net 2.0 in 24 hours".
I am creating a page where users can enter new photo images. The functionality for uploading an image will come later. I am working on just inserting a new row into the Pictures table with an optional category, a required title and a required description.
I am getting an error when I try to insert a new row.
Here is a screenshot of the page with a shot of the dropdown list.
The Categories are user-specific. I am getting the correct values retrieved.
[URL]
There are two pretty simple database tables involved here.
NOTE: The CategoryID and PIctureID are both autoincrement integer columns.
[URL]
The page uses a DetailsView that uses a SqlDataSource that uses the Pictures table. (The DetailsView's Default Mode property is set to "Insert". The "Enable Inserting" checkbox is also checked.)
The dropdown list uses a dropdown control that uses a SqlDataSource that uses the Categories table.
When the "Insert" button is clicked the CategoryID value associated with selected (Category) Name on the dropdown list will be used along with the Title and Description values to insert a row in to the Pictures table. (If no Category value is selected, then a null value will be used for the CategoryID. This is OK because the CategoryID column in the Pictures table allows nulls.)
My problem is that I am getting this error:
Cannot insert explicit value for identity column in table 'Pictures' when IDENTITY_INSERT is set to OFF.
(FYI: I have the full version of both Visual Studio and SQL Server.)
Here is my source code for the page:
[Code]....
Am not sure how to go about this... but i have two ddls on a formview which are not related but just insert and update into each other... Both are binded to the objectdata source....
Am issue just came up and i am looking for the simplest way on code behind that would automatically post a constant value (selecteditem) once the first ddl clicks on 1 or 2....
Example is
lst DDL Second ddl
ABC bko
DWC loct
qwe jjjj
Now when ABC is clicked... it should automatically bring out JJJ on the second ddl.... I just want something i can do on code behind.
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 am *VERY* new to ASP.net. This may seem simple to you all, but I'm really lost. I have a small sized page with three text boxes (part of the InsertItemTemplate) of a formview, and a slightly modified link the system generated to submit the data to be inserted in the database:
[Code]....
If this page is run, it inserts the data into the database fine, clears the form and sits there. I want it to return a simple "Thank you" page in a window of the same size, with a Close Window buttom at the bottom to close the window:
[Code]....
When I set the postbackurl property on the first page, everything appears to work, except the write is never done to the database. If I remove the postback, it works as it did previously.
I have a formview bound to a sqldatasource control. I want to set one of the insert parameters when I click on one of several buttons (outside the formview).
In my sqlDS I have:
<InsertParameters>
<asp:Parameter
Name="benType"
Type="byte"
/>
<asp:Parameter
Name="benName"
Type="String"
/>
<asp:Parameter
Name="benDesc"
Type="String"
/>
</InsertParameters>
I want to set the "benType" depending on which button I've pressed (I don't want/need it to be visible in the InsertTemplate). I tried adding this line to the codebehind for the button click:
formview1.ChangeMode(FormViewMode.Insert)
formview1_datasource.InsertParameters(0).DefaultValue = 2
This doesn't work...what is the best way to set the insertParameter from outside the formview?
So, I'm trying to use form view in insert mode on a dedicated aspx page. So when a user clicks "Add New" from the main GridView page, it will take the user to an Insert.aspx page that will be in Insert mode ready to collect information.
Here's what I have so far, and all I get is a blank page when I try to run it.
[code]....
I have a FormView at the very bottom of the page in insert/edit mode. When I click insert/update button, the whole page reload and the pointer does not keep within the Formview but go to the very top of the page far away from the desired FormView.
What can I do here to prevent cursor going outside the Formview ? Is it I can use update panel ? What and where I should use the tags ? Or there are other better way ?
I'm using this:
[Code]....
Is there a better way to do it?
I have a page that is using the value from a textbox on a previous page to populate a formview. When I generate the Insert, Update and Delete Statements in Web Developer the edit brings up a blank page and the insert and delete don't work. It works if I just create the formview on a page and hardcode the value in the select statement then the Edit/Delete and Insert works.
View 3 RepliesIs there a way to create only the InsertItemTemplate in the FormView and then assign it to EditItemTemplate. Something like
Page_Load
{
FormView.EditItemTemplate = FormView.InsertItemTemplate;
}