Forms Data Controls :: Gridview Edits Wrong Row?
Jan 11, 2011
I have a page with a gridview. It has a select command and an edit command which are both SPs. I added a standard "Edit, Update, Cancel" CommandField to the gridview so that I can edit. The edit and update are working fine. However, I have found that if the underlying data changes after I have loaded the page and before I hit "Edit", and this change causes the row I'm going to edit to be in a different row than before, the gridview will open the wrong row for editing.
For example, say the gridview is sorted by the a field called ID, and currently there are rows in the DB with ID of 2,4,6 and 8. I load the page and see those 4 records. While I'm looking, someone adds a record with ID of 1. When I click Edit on the row with ID = 4, I will actually end up editing the record with ID 2. Basically, i'm clicking on Edit in the second row, and I end up editing the record in the 2nd row, but the 2nd row is now a different record than before.
It seems like there HAS to be a way to fix this, otherwise editing in the gridview seems exceptionally dangerous. Is there any easy way to handle this, to make sure the user is editing the row they think they are?
View 17 Replies
Similar Messages:
Feb 5, 2010
Is there a way to restrict being able to edit a gridview column to some users but not to others ? Say setting the column to read only and then resetting it when the row is in edit mode.
View 2 Replies
Oct 29, 2010
I'm using Visual Web Developer 2010 against SQL Server 2008 R2.
I have a number of GridViews and FormViews working now, with edit functionality. However I have one field in my main database table that is of type 'Text'. With that one field, the edits won't take. I click Edit, change the text in the GridView, and click Update, but it just reverts back to the unchanged text.
It seems like I've tried everything. Is there a way to make that work without having to code it the hard way with a Textarea control?
View 4 Replies
Mar 31, 2010
I have a gridview bound to a sqldatasource with editing enabled. If I click Edit, then either Cancel or Update, the update or cancel occurs and the Edit button reappears. However, I cannot then click the browser's back button without having the Update and Cancel buttons reappear. A second click of the back button takes me to a state where the Edit button shows again, *then* another back button click will take me to the referring page (the one before the one with the gridview on it.) IOW, it looks like the postbacks are cached. How can I prevent this and have the back button go straight to the referring page?
View 4 Replies
Aug 1, 2010
I have a weird thing happening. I have two identical databases installed on one virtual machine but under two different instances of SQLServer. For some reason, periodically when saving from one it will save to the other instead. Using debug, I have verified that the connection string is correct and when the item saves, it still saves to the wrong database.I use session variable, and am of the belief that it might have something to do with it...and t hat when I go from one to the other it is still getting the connection string form the other for some reason.To make sure that it isn't a problem, I make sure that I completely close out one database before opening the other in a new IE window.I assume that when I completely close out an internet explorer window that it abandons all session states. Is that true?
View 7 Replies
May 10, 2010
User clicks the Edit Link Button on my grid and I want to launch a new screen for the user to do some edits...I need to be able to pull the ID but I cannot figure out what I need to pass to the HandleSelect function and then how to read my column3 to get selectButton.Attributes.Add("onClick", "return HandleSelect(????);")
View 8 Replies
Oct 15, 2010
I'm using a GridView and GridViewHelper Class [URL] for grouping the grid by desired field. On the grid I also include an "edit" RowCommand.
Example:
ID ... Name ... Company ... Year ... RowCommand
GROUP1
1 ... Alex ... Comp1 ... 1999 ... Edit
2 ... Jane ... Comp2 ... 1999 ... Edit
GROUP 2
3 ... Mike ... Comp1 ... 1999 ... Edit
Now when I click edit in the second row of the grid (ID=1, the Group itself is shown in the first row) I have the following code on RowCommand:
[Code]....
and the index returned is 0 instead of 1. Why? And how can I fix this, because the edit command returns error or points to the wrong records??
View 11 Replies
Dec 7, 2010
I have a gridview in which i have itemtemplates and label controls having data from sql server.
I have two fields say quantity and units and in third field i want their product. I m trying in rowdatabound event like this-
[Code]....
Here my third field is netvalue.
It is throwing error-
Input string in wrong format.
How can i achieve this?
View 5 Replies
Mar 16, 2011
I have a page with 2 GridViews on it. The top GridView shows all the Bike Riders the bottom GridView shows all the Bike Lockers. I have set up both GridViews to be able to Edit the data. And the top GridView to Select.
When I click the Select buton on the top GridView I programically reset the DataSource for the bottom GridView to show the Locker for the Biker of the top GridView Selected.
So far everything works great. I select a Biker on the Top GridView and the Bottom GridView resets just showing one record for the bike locker.
The problem is that if I then click on the Edit button on the bottom GridView (The Bike Locker GridView) the GridView goes into the Edit Mode but it now shows all the Bike Locker records and the edit record is always the top record of the GrdView.
Here is my code Behind:
[Code]....
View 1 Replies
Aug 1, 2010
I have a very weird thing happening. I have two databases that have exactly the same tables but different database names on the same virtual machine, but in different instances of SQL Server. For some reason, when using one of them, it will save to the other. In debug, looking at my connection string..I have verified that it is correct, yet when I allow the save, I look in the table and it isn't there, it is in the other database that is in a table with a completely different name and in a different instance of SQL Server.
View 1 Replies
Jan 17, 2010
I have a datasource:
[Code]....
I have a detailsView bounded by some other datasource. There is a dropdown in detailsview which is bounded by sqldatasource named "sdsNature" . Here is the templatefield for dropdown:
[Code]....
I want to show FNature instead of FNatureID in the selected mode as Label and in Edit mode as dropdown. When I am running this project, in Select mode it is showing FNatureID instead of FNature and if I click to Edit the record it is displaying following error:
'lstNature' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value Do I have to give some If else condition that if FNatureID is .... then dropdown should display FNature.... If yes then what should be the code?
View 6 Replies
Apr 19, 2010
I have use chart controller in my web application but it display wrong percentages this are the value:
TOTAL COST : 75000000000.00
LOYALTY DISCOUNT : 7500000000.00
When it display on pie chart it display TOTAL COST :90.91% and LOYALTY DISCOUNT=9.09%
but it should be 90% and 10 % how can I correct it
chtSavingBrekDown.Series["Series1"].Points.AddXY("Total Cost", totalCost);
chtSavingBrekDown.Series["Series1"].Points.AddXY("Discounted Dolers", discountValue);
chtSavingBrekDown.Series["Series1"].ChartType = SeriesChartType.Pie;// Set the Pie width
//chtSavingBrekDown.Series["Series1"]["PointWidth"] = "0.5";// Show data points labels
chtSavingBrekDown.Series["Series1"].IsVisibleInLegend = true;
chtSavingBrekDown.Series["Series1"].LegendText = "#AXISLABEL";
chtSavingBrekDown.Series["Series1"].Label = "#PERCENT";
chtSavingBrekDown.Series["Series1"]["BarLabelStyle"] = "Center";// Show chart as 3D
chtSavingBrekDown.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;// Draw chart as 3D
chtSavingBrekDown.Series["Series1"]["DrawingStyle"] = "Cylinder";
chtSavingBrekDown.Series["Series1"].Points[1].Color = System.Drawing.Color.Yellow;
chtSavingBrekDown.Series["Series1"].Points[0].Color = System.Drawing.Color.Blue;
chtSavingBrekDown.Series["Series1"].Points[1]["Exploded"] = "true";
chtSavingBrekDown.Legends[0].Enabled = true;
chtSavingBrekDown.Titles[0].Text = "SAVING ESTIMATE BREAKDOWN";
View 1 Replies
Aug 10, 2010
I have a ListView that populates and displays a user's data (via a profile system in VWD 2008) during Page_Load and also when I go from the EditItemTemplate to the ItemTemplate. Then when I go to the edit screen again, my DropDownList and RadioButtonList controls display the first items in the corresponding tables instead of the correct profile values. I don't understand why the controls populate correctly the first and second times but not on the third time (that's right, the third time is NOT a charm).
ItemTemplate:
[Code]....
EditItemTemplate:
[Code]....
[Code]....
View 2 Replies
Nov 8, 2010
[Code]....
View 6 Replies
Sep 1, 2010
I apologize in advance for my poor english:1. I have a dropdownList within my datagrid and its already populated fine (22 rows in my datagrid)2. The select item for the 21 row is the same as the select item of the 22 row3. When trying to do selectedIndexChange for the 22 row, it didn't seem to work.The error:
Dim ddl As DropDownList = CType(sender, DropDownList)
Dim dgi As DataGridItem = CType(ddl.Parent.Parent, DataGridItem)
Dim rowID As Integer = dgi.ItemIndex
The rowID keep staying at 20 even though the selectedIndexChanged is happening in row 22( ie. rowID should be 21)
View 3 Replies
Dec 8, 2010
I'm creating a login page. I want to limit the number of login attempts, say not more than 5, in case of wrong.I want to do it without using the asp:loghin controls and the membership.How can restrict it??
View 3 Replies
Nov 28, 2010
I have a problem using the calendar control on asp.net. Whenever I pick a date from the calendar to input it on my table which is from sql server 2005, I the wrong time. For example the time today is 6pm, 12 AM will be shown on my table. What do you think is the problem?
Do you think I have a problem with my timezone on mysql server 2005 or with my asp.net application. I'm doing a web-based program.
View 1 Replies
Jan 20, 2010
I have a web form with a detailsview controlled by a linkbutton in a gridview. When the user clicks the linkbutton, a panel appears with the detailsview inside it. The select statement is created based on the commandargument of the link button. So far, if there is a record associated with the ID passed through the linkbutton, the detailsview displays correctly. However, if the user needs to update this, it jumps to the default record for that detailsview after clicking the standard update link. Without a default ID set, the detailsview does not display at all, as some IDs do not yet have a corresponding record for the detailsview.
How can I get around this issue? Also - is there a way to immediately display an open detailsview for IDs with no record associated yet?
View 8 Replies
Aug 20, 2010
I have a form that collects some dates. The users can go to this form any time, view the data, and edit the data.
The user should only be able to enter today or future dates only. We don't want users to go in here and be able to past date these dates.
So I created a compare validator which compares the text box against today's date. This works great. The user saves the form and life goes on.
But then, lets say they come back 1 week later and want to change a date. Now all the old dates will fire this validator and they can't save anything unless they change all the dates to today or newer. This is a problem.
So what I thought was when I load the form with the data from the database, I would just disable the validator if there is a date, and if it's null enable the validator. But this won't work because then they can back-date all of those dates with the validator disabled.
So for the dates that are not null, it shouldn't fire the validator unless they change the date.
When I load the form, I'm going to load all these dates into Viewstate. I'm going to create a custom validator and check the value they enter against the previous date that is in Viewstate. If it matches that date then it is valid, if it doesn't match that date then I will run it through the validator to check for past-date.
View 3 Replies
Jul 30, 2010
In my application i have gridview that I export it to excel. When exporting I have the option to select if show the data with images or with no images. The application run well, but when i try export Hebrew data I got gibberish letters. The second thing is that if I select the option "with no images"
Sometimes the Hebrew seems good, and sometime not. Of course I add the Response.ContentEncoding. I thing maybe I should encoding one of this rows
[Code]....
But don't know how. Here is my application printscreen. and this is my code
[Code]....
View 2 Replies
Mar 12, 2014
There is a Dropdown(named "Station") in my code.
<asp:DropDownList ID="DStation" runat="server" Width="100%"></asp:DropDownList>
Im fetching the data saved in DB inside dropdown SelectedValue on page load as below:
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
[Code].....
But its always showing "ABC" (i.e, 1st Id's station) in selectedValue of dropdown, for every "id" dont know why.
View 1 Replies
Aug 11, 2010
I have a ListView that populates and displays a user's data (via a profile system in VWD 2008) during Page_Load and also when I go from the EditItemTemplate to the ItemTemplate.
When I go to the edit screen again, my DropDownList and RadioButtonList controls display the first items in the corresponding tables instead of the correct profile values.
I don't understand why the controls populate correctly the first and second times but not on the third time (that's right, the third time is NOT a charm).
[Code]....
View 2 Replies
Nov 24, 2010
I have an issue with a popup in Asp.net using AJAX modalpoup extender. Is it possible to show one kind of popup when the user edits few textboxes and the other kind of popup for the remaining textboxes.
Ex: Only when txtbox1's value is changed, it should show me popup1 when the save button is clicked. Or else popup2.
View 1 Replies
Feb 26, 2010
I'm in a little bit of a bind and have some weird behavior happening with a multiview control behaving differently between two machines, and of course, the production machine is the broken one. The page renders the correct content on both machines, but if I save the html file the production machine's source is wrong.
For example, if for step 1 the output should be just the letter A, and step 2 the output should be just the letter B, and step 3 the output should be the letter C, here is what happens:
Step 1:
Production - The source and output are both the letter A
Dev - the source and output are both the letter A
Step 2:
Production - the source is the letter A and the ouput on the browser is the letter B
Dev - the source and output on the browser are both the letter B
Step 3:
Production - the source is the letter A and the ouput on the browser is the letter C
Dev - the source and output on the browser are both the letter C
Is this some issue with SessionState? I'm very new to Multiviews and by no means an ASP expert.
View 1 Replies
Nov 20, 2013
I am making an application that generates P.O automatically after entering all the details prices, taxes, descriptions ..
I have used the following code for retrieving the the float type amounts.
Double Price1 = 0;
bool isPrice1Valid = false;
isPrice1Valid = Double.TryParse(TextBox8.Text, out Price1);
if (!string.IsNullOrEmpty(TextBox8.Text) && !isPrice1Valid)
[Code]...
The data in the databse takes null values which are left over while submitting the values..as in the empty textboxes are saving as zeros..
It is atchually a mess when data is retrieved. I retrieve the data using this code ....
TextBox10.Text = reader["Amount11"].ToString();
TextBox24.Text = reader["Amount12"].ToString();
TextBox31.Text = reader["Amount13"].ToString();
TextBox38.Text = reader["Amount14"].ToString();
TextBox45.Text = reader["Amount15"].ToString();
[Code] ....
View 1 Replies