Forms Data Controls :: DetailsView BoundFields Auto Binding Not Updating Business Object On Update
Feb 18, 2010
I have a DetailsView (DV) control, an ObjectDataSource (ODS) control, and a button on a page. I have 2 classes in the App_Code directory (Customer and CustomerDAO). The DAO class provides static methods for the ODS control and simply hack values in (ie...no real database selects/updates). The Customer class has 2 properties (Id and Name) and a default constructor. The page takes an ID on the querystring and determines if the DV control is in insert or edit mode. If in edit mode, it sets the SelectParameter on the ODS (id field), calls ODS.Select(), and then calls DV.DataBind(). The existing (although fake) customer is loaded and display properly when this happens. I then change the name of the Customer in the DV and click the Button to save the new data.
Everything seems to be wired up correctly as the UpdateMethod that is specified in the ODS control is called and succeeds (even in my real example with my database). The problem is that the BoundFields in the DV control have not been updated with the new values and therefore the existing values are updated in the database and my changes are lost. I have handled the OnUpdating event of the ODS and the values are still the old values. I have also handled the OnItemUpdating event of the DV control and the NewValues IOrderedDictionary still has the old values in it also. In looking at the MSDN article for the UpdateMethod, it states the following:
Parameter Merging
Parameters are added to the UpdateParameters collection from three sources:
From the data-bound control, at run time.
From the UpdateParameters element, declaratively.
From the Updating event handler, programmatically.
I am using the BoundField classes in my DV control so I would have assumed that the first bullet above would have handled the updating of values, but it doesn't appear to work with the way I am doing it. If I set the values explicitly in the OnUpdating event that is fired by the ODS control (the 3rd bullet) the right values are updated (again...even in my real database situation). It seems like my only issue is that the automatic binding that I expect from the DV control isn't working as I would expect it to. Here is the code that I have in my fake example:
I'm using a DetailsView object to present a record from a database in table format. I'm actually using and ObjectSource object as the data source for the details view. In the object I am using as the source for the ObjectSource, I have paired properties that hold decimals. This is, I have a property called Year1 and another property called Year1Change. This for years 1 to six. The values from the Year1 properties are in a cell, whereas the change values are bound to texboxes. The code for the frontend is the following:
[Code]....
Now, as you can see in the tbYr2RtCh textbox, I have an OnTextChanged property to call an event handler. This is because I want to do two things when the text changes. The first one is to make the font in the textbox bold if the value it holds is different from the Year2 property. The second one is to change the text on tbYr2RevCh to adjust the revenue for the percentage increase in the rate. The problem I have is that I cannot access the object that is the source for the data and make those changes directly in the object, instead of having to update the database. I don't want to update the database until the client says so, but the changes should be calculated immediately. I thought about creating an method in the object that I could specify in the ObjectDataSource as the update method, but I'm still not sure how to go about it.
I have a bound field in a DetailsView that I want updated with the contents of TextBox2.Text when I update. I have TextBox2 set AutoPostBack True. Cannot remember how to move the contents on update. I tried converting the "Description_Update" to a template field without success.
I can copy and paste the contents of TextBox2 into the DetailsView and it does update as do the other DataFields.
Is it possible to bind a rdlc report to a business object (.NET 4/VS 2010)In my report I have TextBoxes called Name and Email.Say I have an object Person with properties Name and Email.Can I bind the .rdlc with an object Person at runtime?
Again, I am new to the ASP.NET world, and I come from a Windows Forms background. I'm working with an ObjectDataSource that retrieves a collection of business objects. With the collection, I am going to be binding it to a CheckBoxList and other various controls. The business object that I am using is an Employee.
To get all of the employees, I create an ObjectDataSource and set the "Select" method. I then set the DataSourceID of the CheckBoxList to be that of the ObjectDataSource. When I load the page for the first time, I see all of the employees. Now, the user goes through this page and selects all the employees they want to see information about (by checking the box next to the employee name). Finally, the user hits the button called "Display." Upon postback how do I get a list of those employees? I've tried the following solution, but I'm not sure if it's the best practice in obtaining all those employees again. Here's my solution...
In the CheckBoxList, I set the DataTextField to the Employee's name. I also set the CheckBoxList's DataValueField. This property is a little different. I set this to be a UNIQUE IDENTIFIER, which can distinguish this employee from other employees. Now, when the user hits the button "Display" I use my ObjectDataSource again and MANUALLY call ObjectDataSource.Select(). I cast the returned value as a List<Employee>. Finally, I iterate through all list items in the CheckBoxList...
[Code]....
If the item is selected, I parse through my list of employees that was returned from the bjectDataSource.Select(). I use the item.Value and compare it to each employee's "key." If the key is found, I know that the employee is selected. I put this employee in another list called EmployeesSelected.
Finally, I take EmployeesSelected (which is a List) and set my GridView's .DataSource and call .DataBind() on the GridView.
Is this the "best practice" of re-obtaining the Employees that are selected on my page, or am I making this too complicated?
Codebehind: creating dataset, getting data from sql with adaptor and filling into dataset object, then setting detailsview's datasource. I add 2 button to above template to able to edit data at asp page, and added event handlers:buttons:
[Code]....
My question is, what to do inside the detailsview update event function to able to edit and update data. My method can be wrong too.
After hitting the insert button the insert stored proc is run. if the record already exists then stored proc returns a specific value.I need to refill the details view textboxes with the values the user typed in.I am using the ItemInserted event handler.I seem to reference the control okay but the text doesn't change...even when I replace the command.parameter to just a literal text like "test".
TextBox tNPA = DetailsView1.FindControl("InsertName") as TextBox; tNPA.Text = command.Parameters[0].Value.ToString();
So what am I missing. I also tried a detailsview1.databind() before and then tried after the above line and still no luck.
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.
I am having issues with this.. If you could help that would be great. I am not a coding expert, but I am trying to learn as I go. I am having problems taking the value from my dropdown list (tabl1) and updating table2 with the selected value.I have my grid / form showing my table2 data, I have 1 of the dropdown fields being populated from table1, when I change the specified dropdown box and click update, the data in table2 stays the same.
I am in a situation where I have to perform a transaction master detail record (Drop prev details, insert new details, Update Master status) Master Business Object has 20 fields Details Business Object has 4 fields only. Now I have to update only 1 field in master table and 4 fields in details table for insert.
If I initialize a new master object, 19 fields are being wasted for a simple update. What do I do to efficiently handle this situation? Can I make a new object and inherit only one field from my master business object?
Here is the scenerio:I have a radtabstrip (with 2 tabs) at the top of my page followed by radMultiPage control Tab 1 displays pageview 1 which has a gridview showing data from our database and allows for selection or deletion of data tab 2 displays a detailsview when gridview_selectedindexchanged(from tab 1) is fired.Problem... If you select an entry in the gridview it switech the page and the detailsview into editmode (works fine) but if you then click on tab 1 without clicking update or cancel in the detailsview, the data is updated. This is what i don't want as the user has basically abandoned the changes.So what i need is a what to say ... if the detailsview is in edit or insert when the tabstrip is clicked then cancel the insert or update. I tried switching it back to readonly mode but that did not seem to work.
I have a master/detail page using a gridview as the master, and a detailsview as the details. The gridview is set to select a record, and the detailsview picks up the ID and you can either edit that record, or add a new one.The detailsview is set up with various template fields, and if everything on the page is visible, it works OK.However, I wanted to hide the Gridview when the user in working with the detailsview. But if I do that, the detailsview doesn't update the record.
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).
I have a gridview and when i click on the edit button i will get the modalpopup window which is having a popup window i want to update the data in that details view and refresh the data into gridview also.
I'm trying to bind both GridView and DetailsView to a single ObjectDataSource declaratively (in markup). I'm getting the error read as below when I tried to run it.
"The DataSourceID of 'DetailsView1' must be the ID of a control of type IDataSource. A control with ID 'ReservationsDataSource' could not be found."
It works when I bind GridView and DetailsView each seperately to my ObjectDataSource. Is it I can't bind two pagable data web controls to a single datasource?? or there is a trick needed to be done for this to work.
FYI, I'm trying to create a Master/DetailsView of my data. DetailsView of my application should show the record selected in GridView and it should be editable.
I am currently binding my Detailsview and Gridview together by a "ID" field selectedvalue "1". Which works great except for the fact that I don't want the user to have to go down to the gridview and select the page and then the record to view it in the detailsview.
I have 1 sqldatasource for detailsview and another sqldatasoure for the gridview. Both have the exact same select statement.
I want the gridview and detailsview to automatically display the last record inserted not the first record in the table.
have two detailsview controls on the same page, one showing pictures, one showing the comment on the current picture. I separated them because they are in different parts of the page (just in case someone was wondering why). They both bind on the same objectdatasource. The issue is that since I use paging to navigate the pictures and i dont know how to also update the comment detailsview control to the same page as the picture.
I have a details view in asp.net which I am dynamically replacing some of the controls using code behind (e.g. converting some text boxes to dropdowns). My problem is that I am unsure how to bind these to the field from the database on postback. I.e. I am trying to find the code behind equivalent bind('currency');
I can populate the dropdown with the current value from the database but cannot find how to save a new value on updating the detailsview.
All fields are BoundFields (except radiobuttons). They can't be converted to templates, I am using boundfields for row-level displaying in RowDataBound.Each row has a radiobutton and only one radio button should be selected per subquestion (SQ).How I can ensure only one answer is selected per subquestion? On radiobutton click or on submit?
I'm doing research on framework development for my company. SInce I will be developing a framework I can not simply declaire all my control in the code in front. Receiently I've been having trouble binding the controls from my ListView to my ObjectData Source. Basicly the properties in my DataObjectTypeName are not populated when the ObjectDataSource "Update" command is thrown. I recieve no error, I just get null values. All I need is an equivalent to this statement for code-behind ...
<%# Bind("AbstractText") %>This would solve all my issues. Ofcouse I will most likely need to bind the control's ID somewhere but that is not an issue. How do I Bind a control to a property in my DataObjectTypeName from the code-behind?
