I have a data bound control (using <%# Bind %>). I am trying to change the value of it before it gets udpated.
I use:
[Code]....
But the value is not changed to 1.
Also, e.Keys, OldValues and NewValues are all empty for whatever reason.
I use ObjectDataSource and DetailsView for Updating records . my Bll input parameter method is an Object instead of regular parameter . So i though i could make my own ObjectParameter in ItemUpdating event of DetailsView and i need some modifiation on the data that user input on boudfield in detailsView . I don't know how to access BoundFiled data from ItemUpdating Method of DetailsView.
View 1 RepliesHow to use RadioButton in FormView in EditTemplate to get information on the field, for example:
in the template:
<Asp: FormView ID = "FormView1" runat = "server" DataSourceID = "SqlDataSource1"
Width = "907px" onitemupdating = "FormView1_ItemUpdating" DefaultMode = "Edit">
<EditItemTemplate>
<table cellpadding="4" cellspacing="4" border="0" style="width:100%;margin-top:20px">
<tr>
<td> <strong> Type Person: </ strong> </ td>
<td>
<Asp: RadioButton ID = "CHR_TIPOPESSOAFISISCARadioButton" Text = "F" runat = "server" Checked ='<%# Convert.ToBoolean (Eval ("CHR_TIPOPESSOA"). ToString (). Trim (). Equals ("F")
"true": "false")%> 'GroupName = "RadioButtonTipoPessoa" />
<Asp: RadioButton ID = "CHR_TIPOPESSOAJURIDICARadioButton" Text = "J" runat = "server" Checked ='<%# Convert.ToBoolean (Eval ("CHR_TIPOPESSOA"). ToString (). Trim (). Equals (J)
? "true": "false")%> 'GroupName = "RadioButtonTipoPessoa" />
</ Td>
</ Tr>
</ Table>
<Asp: LinkButton ID = "UpdateButton" runat = "server" CausesValidation = "True"
CommandName = "Update" Text = "Update" />
</ EditItemTemplate
So, to sum is up, I have a FormView:
[Code]....
And the relevant code:
[Code]....
What does work: I do see the right info if the formview is shown but when I click on the Update button it just doesnt fire the corresponding itemupdating event.
Can someone see what is wrong or missing?
What do I want to archieve: Just update the subscription's credits and its type: Upgrade, Prolong.
-edit-
New finding: I added 'onitemcommand="fvSubscriptionEdit_ItemCommand"' to the formview and a corresponding event method with a simple code that throw a exception(just testing) but it doesnt enter the method but does whine when the method is missing. So why does it whine if the method is not there but doesnt enter the method if it does exist? I presume that this is the same problem.
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.
I have a detailsview that is a mix of textboxes and dropdown lists. Upon clicking update - i want to examine all of the fields that have changed and do a custom update. I am trying to capture the data using the ItemUpdating method, capturing 'e' as detailsViewUpdateEventArgs. If i specify DataKeyNames in the ASP:DetailsView and only use one key (the primarykey) then i can step through the e.oldvalues and e.newvalues examining the data - but i don't have access to the field names (except for the single key i entered).
If i use all fields from the DetailsView in the DataKeyNames parameter - then i have access to all the fieldnames via e.keys(n) - but at that point i don't have access to the e.oldvalues (count=0) I am greedy - i want the keynames, the oldvalues and the newvalues.
I have a simple problem. What i wish to do is to read the data bound item [Code]....
and if the output = 0 then rather than display the 0 I would like to display a message such as Not Available.
Can anyone provide a solution?
Index outof range?GridView2.Columns[6] as BoundField I use Auto-generate field .
How to manipulate GridView2.Columns as BoundField with auto-generate field?
[code]....
I have an image file to be uploaded and to be updated in my database. I've already write the C# code based in a VB code.
However, I have some trouble to pass a data to be updated through DetailsView Control, by using
DetailsViewUpdateEventArgs e
The column in database is "ImageData"...
In VB the Code is:
e.Values(
"ImageData"
) = imageBytes
ImageBytes is an array of bytes..
Can you direct me how can i access input data of DetailsView in ItemUpdating event? I want do some modification on data that user input to Detailsview.
View 2 RepliesI have a GridView, and its GridView_RowUpdating() method is called, and NewValues are set correctly... but at the end the database is not updated.
[Code]....
[Code]....
i want to compare my database value with my new updated value. what should i do ? e.g : on page load i am excuting one procedure which bring 10 columns and fill it against the 10 fields using for loop on the page. then i am changing value of two columns. ok. when i press update button then there is one more procedure which updates all the new and old columns into database. Its working fine. just i want to know that, should i update only two columns(which are modified) insted of updating all 10 columns ? Is there any csharp code that brings my page load columns into array and then compare it with new ones and updates only those columns which are mismatch with array. i am not sure but there is some way to do this.
View 4 RepliesI have a gridview bind to an object datasource Now there is an edit button to edit the entriesUser selects new entries and clicks update Gridview gets updated (all previous entries replaced)Now the new records dont contain the table id of the previously added rowsOn form update, how do I know which entries to drop from database and which entries to insert as the previous rows are all gone?the results are in form of collections of objects returned by object datasource.
View 6 RepliesI want to populate an html label based on user information. I know how to read the data from html to c#, and how to manipulate the data. I just dont know how to return the data from c# to the html label.
<asp:Label ID="UserNameLabel" runat="server" AssociatedControlID="LoginUserName">Username:</asp:Label>
<asp:TextBox ID="LoginUserName" runat="server" CssClass="textEntry"></asp:TextBox>
<asp:Label ID="PasswordLabel" runat="server" AssociatedControlID="LoginPassword">Password:</asp:Label>
<asp:TextBox ID="LoginPassword" runat="server" CssClass="passwordEntry" TextMode="Password"></asp:TextBox>
[code]...
On one (aspx) page I have a GridView (GridView has multiple pages). After a user selects a row/record and clicks "edit" he's redirected to another (.aspx) page where he edits the selected record via DetailsView. fter clicking update on DetailsView he's redirected back to the page containing the GridView.What is the simplest/shortest way that the updated record is automatically selected on the Gridview (e.g. at Page_Load event)?
View 7 Replieshow to reflects the updated values to the database when i changed values in the Grid view in asp...
View 3 RepliesI have a simple grid with 5 columns. The first 4 are numeric values I have formatted with templates. The last column is a total and I've added the Update button on the end. When the Update button is pressed, I have it updating the table with the new values and calculating the Total column. My goal is to have the Total column calculated after each cell is updated and not when the Update button is pressed.
I've added CommandName="myUpdateRowTotal" to
my templates.
<ItemTemplate>
<asp:TextBox ID="R01_Item_txt" CommandName="myUpdateRowTotal" runat="server" BackColor="White"
Font-Names="Arial" Font-Size="10pt" ForeColor="Blue"
Text='<%# Bind("R01_TARGET_COMMISSION", "{0:###,###,##0}") %>'
Width="75px"></asp:TextBox>
</ItemTemplate>
I have a web page with a Form a Button, a TextBox and a DataGridView in it. The DataGridView uses a SqlDataSource as its data source. SqlDataSource has one parameter which gets it's value from a
form parameter (TextBox1). When the page is opened for the first time I set the TextBox1 default value in code behind:
protected void Page_Load(object sender, EventArgs e)
I have a datalist and gridview that have a image in a column.. when you click the imagebutton, its calls my method that updates a table. The page is posting during this event, but when the page is done, the image hasnt changed.. im sure it has to do with the datasource not binding during that click.. so where can i move this code to or can i simply bind the control during that click? Currently im handling it in the itemdatabound event.. which would explain it.. but where is the correct place to handle this logic?
[Code]....
The control on the page is configured like so..
[Code]....
I was trying to update a detail view from code behind (vb.net). I know how to fire the event but dont know where to put the DML query where i should do update and insert, i mean in which event?:
update.aspx
[Code]....
update.aspx.vb
[Code]....
No error but is not working.
There is a very common problem I am facing in my new webproject in gridview control.The sequence of the execution of the process is as follows:There are some search parameters in SearchPage with a gridview. In gridview's rows there is an Edit button.By providing search parameter(s), data populated to gridview and if we click edit button a new page opens as a popup to update record.In new page the record is updated fine. On successful updation user close the window but he goes to the Search page he again finds the same record with the same parameters to see changes it remains unchanged.Its only changed when he search another record and then again provides the previous parameters.I don't know why is this behaviour of gridview?
Any idea would be helpful.
I need to know how to check last updated rows in Gridview.
View 2 RepliesI have used the same steps that you have used on your sample for inserting, deleting and updating. This is my code
private String strConnString = ConfigurationManager.ConnectionStrings["CustomerConnectionString2"].ConnectionString;
protected void Page_Load(object sender, EventArgs e) {
if (!IsPostBack) {
BindData();
[Code] ....
It is deleting the data but not updating the data,it sticks to the same data after clicking on the update button...
So I am using a formview that gets in Update mode with a bunch of values from a sqldatasource --- but I want to fill a couple dropdowns with data from the database --- but I cannot figure out how to bind the data to the dropdown box FIRST and then select the value in that dropdown box... but I keep getting an error that the Selected value is not a part of the dropdown (I assume because the sqldatasource is trying to bind BEFORE I can get the dropdown box bound).
IE -- when I load my values, lets say a 'Crop' comes back as 'Corn' ... I want to download the available crops from the database (ie. corn, beans, wheat, okra, etc.) and then set the selected value as CORN.... SO HOW do I get the dropdown filled BEFORE I try and bind the selected value?
I have a GridView with an ItemTemplate and an EditTemplate:
[code]....
I am able to go into Edit Mode and once in edit mode I can see the textBox tbLogEntry fine. lblLogEntry is gone. I have left regular Item mode and am in Edit mode:
[code]........
gives me back the original value, not the new one.
How do I get the edited value from the front end textbox?