C# - .net MVC 3 - DropDownList Not Updating During Edit?
Feb 25, 2011
I have two tables - one called Contract, one called Sow. Contract has a foreign key that points to SOW. What I'd like to do is to be able to edit the Contract details and provide a drop down list of different SOW records to choose from. The current code:
In my Contract Controller:
public ActionResult Edit(int id)
{
Contract contract = contractRepository.GetContract(id); [code]...
The list populates with values, but when I change them and update, the foreign key does not change.
View 2 Replies
Similar Messages:
May 21, 2010
I have an edit action that is not updating. The code is below. When i debug the code , i see my udated field but it doesnt seem to get saved into the database.
[Code]....
View 2 Replies
Jan 11, 2011
I'm trying to build something like the MVC music store for learning purposes,
creating and deleting entries works great, but updating does not work -
for some reasoen after clicking the update button, i go back to the index page but no changes are saved.
I'v put a break point right before the SaveChanges(), i see that the form colection shows the new data, but it's not geting into the db?
View 12 Replies
Nov 29, 2010
I am using a gridview to display data and want to implement Edit, Update and Cancel in the GridView. Edit and Cancel are working fine but on update the Gridview isn't exiting out of the edit mode. I am using the gridview inside an UpdatePanel.
[Code]....
View 9 Replies
Jun 23, 2010
I have a detailsview control linked to a SQL DB. I have created a template field with various controls within. When I click on edit and change the values and press update. The detailsview control changes back to read only and displays the original values. I have attached the code for the control and datasource below.
[Code]....
SQL DATA Source
[Code]....
View 2 Replies
Sep 20, 2010
where I have gone wrong? changing from VS2003 DataGrid to VS2010 GridView; still on SQL Server 2000 so the wizards for autogenerating the code are not compatible.
Delete works, RowUpdating does not. I get an ArgumentOutOfRangeException on "rowToUpdate("QuoteDQty")
= Me.dgQuoteList.Rows(e.NewValues.Item(1).ToString)"
Private
Sub dgQuoteList_RowUpdating(ByVal sender
As Object,
ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs)
Handles dgQuoteList.RowUpdating
[code]...
View 2 Replies
Mar 24, 2011
I am using the following code to update the data in my datagrid.
But when I click update the value is updated in the database but it still shows old value in datagrid.
If I refresh the page after that then datagrid shows the updated value.
Code On Update Command:
protected void MySQLDataGrid2_UpdateCommand(object source, DataGridCommandEventArgs e)
{
string newData;
TextBox aTextBox;
aTextBox = (TextBox)(e.Item.Cells[0].Controls[0]);
newData = aTextBox.Text;
decimal comm = Convert.ToDecimal(newData);
string UpdateHiveCommission = "Update tbl_HiveCommission set Commission = '" + Convert.ToDecimal(newData) + "'";
MySqlConnection objMyCon3 = new MySqlConnection(strProvider);
objMyCon3.Open();
MySqlCommand cmd3 = new MySqlCommand(UpdateHiveCommission, objMyCon3);
cmd3.ExecuteNonQuery();
objMyCon3.Close();
MySQLDataGrid2.EditItemIndex = -1;
MySQLDataGrid2.DataBind();
}
View 3 Replies
Jun 29, 2010
Is there a way to update a value in a gridview, by pressing a button that shows within the cell? For example, i have a really simple gridview showing supply levels, I havr the following SQL table:
ID = Int
PartNumber = varchar
Quantity = Int
I would like to be able to press a "Plus" or "Minus" button on the gridview next to the Quantity (in stock) value which updates the database and re binds the data to the gridview, but without going into edit mode.
View 9 Replies
Jun 21, 2010
I have a gridview and detailview in an updatepanel. My detailview is setup to display the details of a record that is selected in the gridview. When I edit the values in the detailview and click update it does not update the gridview. If I check my database the values have been changed it just haven't been updated in my gridview. Below is my code for the two objects and their datasources.
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AutoGenerateColumns="False" DataSourceID="RCR_DSM" AllowSorting="True"
DataKeyNames="PartNumber" AutoGenerateSelectButton="True">
<Columns>
[Code]....
View 2 Replies
Nov 27, 2013
I have a gridView that is populated with a dataset from an Oracle Database.
When I click on the EDIT button, it will redisplay my gridView with textboxes so I may make some changes.
Let's say one row is currently:
OPEN_TIME = 1 CLOSE_TIME = 2
When I click EDIT, 1 and 2 are in a textbox. If I change both values to 5 and click UPDATE, it will fire a RowUpdating..
Here is the code from my APP:
Private Sub gvBusinessHours_RowUpdating(sender As Object, e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles gvBusinessHours.RowUpdating
Dim strOpenTime As String = DirectCast(gvBusinessHours.Rows(e.RowIndex).FindControl("txtOpenTime"), TextBox).Text
Dim strCloseTime As String = DirectCast(gvBusinessHours.Rows(e.RowIndex).FindControl("txtCloseTime"), TextBox).Text
End Sub
The problem is the values I am getting are the OLD ones and not the new ones... I am getting 1 and 2 and not 5 AND 5...
what I am doing wrong ?
View 5 Replies
Jun 26, 2010
I'm using a formatting expression with a template field. When the details view goes into edit mode the formatting is applied. It looks great because it applies the currency formatting. It shows up as "$60,000.00" instead of "60,000.0000". But then when I do the update it gets rejected because of the $. Is there a way to keep the formatting for the user to see in edit mode but remove the $ when doing the update so I don't get the error?
The error: Exception Details: System.FormatException: Input string was not in a correct format.
template field:
[Code]....
View 5 Replies
Apr 10, 2010
I'm new to asp.net 3.5 and I have been working through the tutorials using a real access database to learn how to use the new controls. I have an extremely simplistic page setup with a master-details view, the master using the gridview, and the detail using the detailsview controls. Everything seemingly functions correctly, except when I try to update the data in the details view. I make changes to the record, click update and the page posts back but nothing is updated in the database. No errors are given either.
View 10 Replies
Mar 4, 2010
i am updating data using editcommand by listview.. i got data max 50 depends on customers sometimes it has a few in the database. i am using listview and sqldatasource. when i update using editcommand in listview. it doesnt update relevant rows. it update to all data in database. why.. i have provided datasoure and list view.
<asp:ListView runat="server" ID="photosListView" DataSourceID="SqlDataSource1"
DataKeyNames="PhotoAlbumID" onitemediting="photosListView_ItemEditing" >
<LayoutTemplate>
<asp:PlaceHolder ID="itemPlaceHolder" runat="server"></asp:PlaceHolder>
</LayoutTemplate>
<ItemTemplate>
<div>
<div>
<div>
<asp:Image runat="server" ID="capImage"
ImageUrl="~/AsianaPortals/StudentUnion/Image/PhotoGallery/newadmin/caption.png" />
</div>
<div>
<asp:TextBox runat="server" ID="photodescriptionTextBox" Width="263px" Height="95" TextMode="MultiLine"
Text='<%# Bind("PhotoDescription") %>'/>
</div>.....................................
View 3 Replies
Nov 22, 2010
I have used this before with no issues. Now I get to the page with the detailsview using parms I pass with the key to the row. When the page opens the row I want to update is displayed.
I am having 2 issues. One when I change any of the fields and hit Update (the Edit button),
all rows are updating not just the row displayed. The second problem is I have an update_date and an Updated_by field with code in code behind in the Onitemupdating event and they are not updating at all. (This bit of code works fine in another page I have to updated similar fields on an insert).
View 5 Replies
May 21, 2010
I have a strange issue with the FormView. After working through some issues getting the update to work (as this is my first experience with FormViews) I now have a new issue. After I perform an update, and the FormView updates and returns to read mode, if I hit F5 (refresh) the FormView performs another update to the datasource, despite the fact it is read-only mode and none of the fields on the screen are editable.
I would think that a refresh in read mode for the FormView after an edit would simply refresh the data from the database, not perform another update. Again, the FormView is in Read Only Mode, but a refresh is creating another Update event (which I can debug and see if I break in the ItemUpdating event). This only happens after I perform an edit, not when the page initially loads.
View 2 Replies
Dec 8, 2010
I have a grid view and have five dropdownlist on it. I have edit update and cancel edit buttons on each row.
Drop down list is updating the database, but only first value in the dropdownlist even when user select second, third or any other value from the dropdownlist.
What could possible be the reason for this. Here is my row Edit/ CancelEdit and Updating Events.
[code]....
View 2 Replies
Mar 3, 2011
I have a Dropdownlist in my form as an example as below.
The Dropdownlist items are pulled out from the database table.
When a user Clicks 'Save Template', A new row is created in the database, BUT the dropdownlist items
remains the same :( I want the list to be dynamic so that the user doesn't have to press F5 for updating the list.
View 4 Replies
May 17, 2010
I have a DataGrid with a TemplateColumn containing an asp:DropDownList and a BoundColumn. I'd like to have a VB.NET handler for when the selected item in the DropDownList changes. I'd like this handler to also update the value in the BoundColumn with the value of the newly selected item in the DropDownList.
Can someone point me to some resources I can examine to learn how to do this?
If the handler for the selection changing can give me the value of the NEWLY selected item, it should just be a matter of accessing the cell for my BoundColumn in the same row and writing to it. I do not know the syntax to achieve this.
View 3 Replies
Feb 23, 2010
I was used TextBox in the GridView Then I Replace this textBox with Dropdownlist
and i fetched all the data from the database using DataSource in Editing Mode
But The problem is when i choose item from the dropdownlist to update it,it returns to Empty
(with No values) in the DropDownList??whats the problem?
[code]....
View 5 Replies
May 3, 2010
i have a DropDownlist in my GridView that is bind to another DataSource than the GridView.
For the display it is working well but when I want to update datas I m stuck. Something is wrong and I don't know why.
[Code]....
I am stocking in the Database the value of the dsDroit but when I want to update the field I just know how to get the text not the value.
View 9 Replies
Oct 15, 2010
I have a gridview that holds 4 columns. in the fourth column there is a DropDownlist that holds three items.
I want my users to select one of the values and when they do the auto post back (which is set to true) should execute a method that updates the database selected row. But do i use the selectedindexchanged of the DDL or the Gridview? My head is totally thrashed so i imagine its really simple and im just over thinking it.
[Code]....
View 3 Replies
Oct 15, 2010
[Code]....
Dropdownlist is not updating the table
View 3 Replies
Mar 26, 2010
One of the fields on my formview is a dropdownlist. When I go into edit mode the dropdownlist gets set to the correct value and works fine up to this point. Problem is I just can't see how to get the newly selected value of the dropdownlist to persist to the database when update is clicked. The DDL is a category list and I want to allow changing of the category for each record. Like I said I have it working so it displays the correct category for the record but if I change the DDL (change category) the new selected value doesn't get updated in the database. It just keeps using the binded value that was originally assigned to the selected value of the DDL. see code snippit
[Code]....
The above snippet is how I am binding the DDL. Now to not bore you with a ton of code paste I use various events of the formview to make sure the value displayed in the DDL is correct for the record that I am viewing at the time. All that works just fine. Where I need some pointers is the when I enter edit mode and change the DDL from say fire to ice it isn't getting persited to the database, all other info in the record gets updated just fine but the DDL never changes. I have tried several angles to getting this working and TBH my brain is yelling BREAK TIME.
View 2 Replies
Mar 24, 2010
I am trying to create a Gridview in which I can update the Project Officer name in the Gridview from a DropDownList.
The Project Officer DDL comes from a seperate query (SqlProjectOfficerName) as the other information (SqlDataSource1)... as you can see below.
When I select EDIT, the DDL appears and I can select from the list of Project Officers, but when I select UPDATE, the name of the Project Officer doesnot change.
review the code below and assist as appropriate to write the Project Officer's name back to the table.
[Code]....
View 13 Replies
Nov 14, 2010
I have Gridview like that:
[Code]....
I bind data to GV in this way:
[Code]....
No problem with that. Now, I´d like to update the database with the dropdownlist in gridview, I wrote a method in this way:
[Code]....
The problem is when I click on the edit button there is nothing in the dropdownlist, it´s empty
View 6 Replies
