MVC :: Submitting Multiple Data Entries?
May 24, 2010
I am wondering how to handle and setup a means to submit multiple data entries via ASP.NET MVC.
Suppose I have a product database table such as: ProductId, ProductTitle, Price.
From the view, I was thinking to code the HTML form as:
<form ... >
<table>
<tr>
<th>ProductId</th>
<th>ProductTitle</th>.......
Suppose the form is to be submitted to Controller: Product, Action: Add. What sort of coding techniques can I use to handle this dynamic form, such that I follow good or best practice, and if possible also be elegant.
The solution I see so far is to test the Request.Form (or Formcollection) indexer/dictionary for existence for the dynamic input fields. E.g.
public ActionResult Add(Formcollection form)
{
int productEntry = 1;
string productPrefix = "Product";
while(true)
{........
View 1 Replies
Similar Messages:
Aug 6, 2010
I have some data displayed in GridView and there are multiple (repeat) entires.
There are about 20 rows of the same data, but I only want to display 1 row.
I know can amend PageSize="1" but then it shows multiple pages which I also don't want.
The multiple rows - are all of the exact same data - but it should only appear once!
View 2 Replies
Apr 8, 2010
I'm using Visual Studio 2008 with SQL Server Express databases in my .net 3.5 website
I have three tables I'd like to make entries to when the user completes a wizrd i've setup on a web form.
The First Step - The user enters basic information about their "Case". The table looks like so:
db_Cases - CaseId PK auto int, CustomerId, etc fields
The Second Step - The user enters information about the "Debtors" that are related to this "Case". Think of this as being products....The only difference is these records wont be used over and over again like a product would. The user may need to enter data about several "Debtors", just like if you needed to show several different products on an invoice. For example the user may need to enter information about a husband and wife. This means two entries in the "Debtors" table. The table looks like so:
db_Debtors - DebtorId PK auto int, etc fields
The Third Step - Here's my problem. This step needs to make entries into a third table called "CaseDetails". Again, this is just like if you were creating an invoice with several different products on it, where you would want to get a subtotal of each product's cost. The table looks like so:
db_CaseDetails - CaseDeatailId PK auto int, CaseId int, DebtorId, int
* When this table is later viewed, It will reflect all "Debtors" attached to the specific "Case" being viewed.
The first two steps aren't a problem, I pretty well have that handled in the wizard. BUT How do I create the entries in the "CaseDetails" table when the user finishes?
My idea right now is..... Considering the "Debtors" will be re-used but only on rare occations, I'm thinking I should just add the "CaseId" that was created in step one, to the "Debtors" table at the same time the "Debtor" is created. So the table would look like so.
db_Debtors - DebtorId PK auto int, CaseId int, Name, Address, etc
View 1 Replies
Jul 7, 2010
I have a Company model and an Employee model and I want to create a Company and then create multiple employees for the company in one view.
How should I do this in the view?
And what should I do in the Create POST method to support this multi-entry view?
View 4 Replies
Feb 26, 2010
how am I be able to validate multiple entries (textbox control). It seems that using custom validate is not possible because each validator has one control to validate. In my case, I have to determine if at least one entry was filled with data.
View 4 Replies
Nov 25, 2010
I'm creating a shopping basket in ASP.NET using session variables to pass the data from a shopping.aspx page to basket.aspx, currently I have the pages passing the primary key of the product with a gridview on the basket.aspx used to display the data from the database.However this only works for one item at a time, how can I extended the session variable so multiple products can be added, as well as quantities etc?
View 4 Replies
Mar 24, 2010
An option to add a range of computers based on tag numbers, for instance, user input 800101 and 800110 would add computers SYS800101, SYS800102, SYS800103, SYS 800104, SYS800105, SYS800106, SYS800107, SYS800108, SYS800109, and SYS800110. Currently the app adds a single computer at a time.
Here I am using ASP.NET using C# and my backend in active directory.
View 12 Replies
Jan 12, 2010
I am creating a web service that returns the list of states. How do I create an object in C# in the web service that will return multiple values (of properties of an object). Currently, the way I am doing it, it only returns the last value pulled from the database. Do I need store an array of properties?
[code]....
View 5 Replies
Aug 1, 2010
I am trying to get the drop down list to only include table1 entries where table3.int1 is the current selection in another drop down list (table2.id). Example:
Table1: id, string1, int
Table2: id, string1, string2, dec
Table3: id, int1 (ref table2.id), int2 (ref table1.id)
Both drop down lists are inside of a FormView object for a asp.net page. My current select command(s) are having the DropDownList for Table1 display all Table3 entries, instead of just the ones Tied to Table2 id from the other DropDownList.
View 8 Replies
Jan 25, 2011
what is difference between server side submitting and client side submitting a form.
Can any one explain with an example.
View 2 Replies
Aug 18, 2010
if i enter the value in the textbox based on the textbox value it should go to that page.for eg: i've one textbox,one buttonand three forms namely plant.aspx,green,aspx,companies.aspxif i enter the text as "what is plant" into textbox and click the button the it should search the word plant and redirect it to plant.aspx form.if i enter the text as "what actually green is" into textbox and click the button the it should search green and redirect to green.aspx form.
View 2 Replies
Dec 4, 2010
I'm quite confused about how to implement a many-to-many relationship and my domain model. Let's say I'm creating a recipe box web application and I have three tables called Category (categoryID, categoryName), RecipeCategory (categoryID, recipeID), and Recipes (recipeID, recipeName, recipeDescription). If I were to present this information as an ASP.NET application and wanted to insert a new recipe and category, am I responsible for writing the logic to insert the information in the RecipeCategory table OR is it possible to set RecipeCategory.categoryID and RecipeCategory.recipeID automatically with default values based on newly inserted records in the related tables? If I'm responsible for writing the logic to insert values in RecipeCategory.categoryID and RecipeCategory.recipeID is that a trigger? What's the best way of implementing this?
View 2 Replies
Jun 3, 2010
I have used Expression Web to create a website with a standard .ASP form that saves data into an Access database using standard HTML controls. This works fine except there is no validation of the fields. A user can enter anything to get past the form.
I want to use ASP.NET to validate all of the fields in the form and then save to the same Access database. When I rename the webpage from .ASP to .ASPX, I am able to get the validation controls working properly by changing HTML controls to ASP.NET controls.
However, I cannot figure out how to get the form data submitted into the Access database because the code to connect to the database was removed when I inserted the first ASP.NET control.
What am I missing? It seems like a simple task but I haven't been able to figure it out. I have a couple books and they don't answer the question. Can someone guide me in the right direction?
View 3 Replies
May 5, 2010
I want to show processing .gif image while submitting data or fetching data?
For example,When we search for hotels in any city after clicking search we have a model popup which ask you to wait and shows processing image.
View 3 Replies
Feb 24, 2011
I'm using a listview control to do a survey stuff. Everything is working perfect to present the data questions, to be answered text with the different type of controls radiobuttonlists, checkboxlists, dropdownlists, etc. The admin can modify, create, change questions, answers, etc. on the survey.When it's select, edit, or insert it's easy to find the control inside a listview.However, I'm wondering how to post user's answers back to DB. How to find controls inside the listview to grab the entered data/responses from there using let's say the submit button that is outside of the listview.I believe there should be a way to do it as otherwise why we put radiobuttonlist on a listview that somebody could click it and then we should be able to get that entries. Or I'm too optimistic on this control?
View 2 Replies
Mar 2, 2010
On my web pages I display the data as mm/dd/yyyy and that is how the user will enter the dates as well. But when I pass the textbox control that has the date in it as a parameter to the SQLDataSource control, I need it to be sent in the YYYY-MM-DD format for the AS400. Is there a way it can be changed in between?
View 7 Replies
Oct 20, 2010
I am trying to create a website that takes input from users and then updates a table in MS Access db. I have a plain html form that takes the imput and in the action I entered the asp file name. Once a user clicks on submit on the html page I get the 500 internal server error. I properly uploaded the files on the server,
I have created a DSN on the server, but cannot see the DSN under the "Select ODBC DSN" when I try to create a connection from DreamWeaver. I am using a 64 bit machine so nto sure if that might be causing the problem. Here is code form asp file :
<% @ Language="VBScript" %>
<% Option Explicit %>
<html>
<head>
<title>Form to database</title>
</head>
<body>
<%
'declare your variables
Dim name, email, comments
Dim sConnString, connection, sSQL
' Receiving values from Form, assign the values entered to variables
name = Request.Form("name")
email = Request.Form("email")
comments =Request.Form("comments")
'declare SQL statement that will query the database
sSQL = "INSERT into users_tbl (name, email, comments) values ('" & _
name & "', '" & email & "', '" & comments & "')"
'define the connection string, specify database
'driver and the location of database
sConnString=("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='d:/hosting/6859771/html/access_db/Users.mdb';User Id=;Password=")
'create an ADO connection object
Set connection = Server.CreateObject("ADODB.Connection")
'Open the connection to the database
connection.Open(sConnString)
'execute the SQL
connection.execute(sSQL)
' Done. Close the connection object
connection.Close
Set connection = Nothing
response.write "The form information was inserted successfully."
%>
</body>
</html>
View 1 Replies
Jun 11, 2010
I have a SqlDataSet connected to a FormView with a stored procedure for the InsertQuery. The SP has an InputOutput parameter and about 8 other standard input parameters.I referesh the parameters etc., and when I run the app and post the insert NOTHING happens. Well actually all of the insert events fire and the FormView goes to ReadOnly mode like its supposed to, but nothing is sent to the SQL server.
I'm running SQL Profiler and can see that literlaly nothing is happening.However, if I change the SP to just a regular query and just put some random query (like SELECT * FROM TEST), then when I do the insert the query does get passed to the server, along with parameters for all of the fields (even though I haven't created any parameters, due to the fact that I'm using bound controls I assume).
One thing about the SP I'm trying to use is that the names of the parameters are the same as the column names for the fields to be passed to them, I'm wondering if this is an issue, i.e. spAddUser @name = @name, @email= @email, etc?I wonder this because I've also tried just using the SP as a Query, instead of an SP, doing EXEC spExample @param1 = @param1, etc, and that doens't work either. In that case it also sends nothing to the server as well.
View 1 Replies
Dec 13, 2010
Here is what am trying to accomplish...I want to have a DropDownList that is populated by a field from a table. Then once a user selects one of the enteries, he/she then enters a value for that selection in a textbox, then clicks enter or add....now upon doing this, I want to have a GridView that tabulates all the entries the user adds, and keep a total of all entries as the bottomline in the GridView. I can't seem to wrap my head around how to get it done.Does anyone know how I can get this done, or are there examples out there that my searches have missed cause I haven't really seen any examples I could look at. I would think this should be a common solution that is used all over
View 4 Replies
Mar 28, 2011
there is a textbox and button control. On button click event content of textbox is submitted to database and javascript alert is displayed. Now the problem is- If I am refreshing the page using F5 then same value of textbox is being submitted into database and javascript alert is coming again.
View 3 Replies
Jul 29, 2010
I have a bulk editable gridview. I want to find a way of keeping a running total up to 100 in each row when the user is entering values into the editable columns. I then want to save this data.
The running total column (Total) is a bound column and not editable by the user.
View 6 Replies
Mar 30, 2010
I am using Visual Studio 10/ASP4 but I am sure this problem is me. I created a program and got it all working. GridView and DetailsView, edit, insert and delete all works. :-)... I have spent 4 solid days attempting to have a simple DropDownList with three items on it EDIT a record. Lots of GOOGLeing for suggestions. It just will not work. The insert dropdown works fine(thats how I created the record). I wrote a new simplified program with just the detailsview and the edititem dropdownlist. Still can't get it to work. The detailsview data has a record and the "mode" field (char(20)) has three letters "FTP" in it. The letters display on the Detailsview. I can edit fine but when I add the following drop down list the page aborted with a
"'DropmodeEdit' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value"
Yet there is only one record and it HAS "FTP" in it! The list has FTP in it? I just don't get it, why?
I added an ondatabinding routine and breakpointed it in the try/catch and found the selectedindex pointed to the correct entry and the items list had the correct entry with no spurious data or spaces. The data being passed displayed good in the detailsview, Am I correct in assuming that is bound to the dropdownlist automatically? or is there some majic that I did not get from Rob Burke?
<asp:TemplateField HeaderText="mode" SortExpression="mode" >
<EditItemTemplate>
<asp:DropDownList DataValueField="mode" DataTextField="mode" ID="DropmodeEdit" Runat="server"
OnDataBinding="mode_OnDataBinding" AppendDataBoundItems="True"
[Code]....
I have used a dropdownlist once before with a datasource instead of listitems, this should be easier?
View 7 Replies
Mar 10, 2011
I am experiencing a problem on my aspx page.
I have a web form on which the user fills in a basic data: date (with drop down lists), an asset class (with a radioButtonList that is bound with en Enum) and other simple controls... The, when the form is submitted, I make a query on the database to retrieve my data and bind these data into a gridView.
Here are some bit of codes
protected void Page_Load(object sender, EventArgs e)
{
foreach (int assetclassVal in Enum.GetValues(typeof(AssetClass)))
{
[Code]....
The 1st time I submit the form everything is working well, the second time even if I change nothing in in the web form, the GridView1_RowCreated fires an exception when the property AssetClass is called. The error message is
Must specify valid information for parsing in the string.
This is because rblAssetClass.SelectedValue is empty, but I don't understand why.
View 1 Replies
Nov 24, 2010
i have a grid view and check box in it. and there are 5 columns in it. user name, first name, lastname city and ph no. and 5 text boxes... and a edit button NOW when i check any checkbox and press EDIT button i want the entries in grid view show be entered into text boxes.
View 10 Replies
Jan 18, 2011
I want to validate on client side if a GridView has entries (count ==0). If it doesn't, I want to show on my Validation Summary.
View 2 Replies