Which GridView Event To Use When Updating

Jun 28, 2010

I have a GridView with ItemTemplate and EditTemplate. There is some text boxes in EditTemplate. I want to update records myself using EditTemplate controls. Which event of GridView I should use? If I use Telerik's RadGrid then what event is better?

View 1 Replies


Similar Messages:

VS 2010 - GridView Updating Event When GridView Has Paging

Dec 1, 2013

I have a GridView that is populated via a dataset that contain 1 table. I have enabled paging on my GridView.

In my Updating event, I handle the new values and call a store proc to update my database with the new values for the selected row. In order to minimize the call to the DB, instead of getting back a new dataset with the updated values, I simply update the row of the dataset that I have in session with the new values and then I bind back my gridview.

The problem that I have is since I have let's say 5 pages of 10 row... If I update a row on the first page as soon as I click update, the gridview will show the new values. However, if I select page 3 for example, click on update and update the values, once the update is done, the gridview will still be displayed with the old values.

View 4 Replies

Create Gridview Updating Event Dynamically?

Jan 21, 2011

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;

[Code]....

the row used to get in edit mode only if i edit the next row means first row never get in edited mode.

View 2 Replies

Forms Data Controls :: Gridview Updating Event Will Not Fire?

Jan 24, 2011

in my webpage gridview is there in that gridview gridTags_Updating event is there.when am keep a breakpoint inin that event will not fire as well as when am clicking update button gridview is disappear

View 4 Replies

VS 2010 / Updating A Row In A Gridview Using EDIT Link (RowUpdating Event)

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

Forms Data Controls :: Updating Field Value In Gridview Rowupdating Event

Mar 15, 2010

I have a Modified Date and Modified By column in my gridview and I want them to be updated with the current date and current user any time a user updates the row.

I converted my columns to template fields and the textboxes in the edititemtemplate are bound to my sql data columns "ModifiedDate" and "ModifiedBy"

Then I added the attached code in my RowUpdating event.

When I test the code and click the Update link on my gridview I don't get an error but the values don't update either. I put a breakpoint on the code and when I hover over "ModifiedDateLabel.Text" I see the old value of the field so I know I'm accessing the control correctly.

View 3 Replies

What Query To Fire In Row Updating Event?

Mar 23, 2010

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
conn.Open();
int idx = e.RowIndex;
GridViewRow row1 = GridView1.Rows[idx];
// string s = row1.Cells[0].Text;

[Code]....

the Contactno is my primary key here....whenever i try to update the number it doesn't get updated while all other values get easily updated..i know there is some problem with WHERE clause in my query but i cant figure out what to write instead of this??? and i know firing a sql query is not considered a good programming method ?

View 4 Replies

How To Change Properties Of Class In ObjectDataSource Updating-Event

Aug 9, 2010

I have the following situation:My business class:

public class Foo
{
public String A {get;set;}
public DateTime B {get;set;}
// .. and other properties like
public String Intern {get;set;}
}

I'm binding that Item to a DetailsView in Editmode. (I bind a List containing a single object of Foo, becuase I do recall that I can only bind IEnumerable<> classes to the DetailView)The binding is done via a ObjectDataSource

View 1 Replies

AJAX :: DropDownList Inside UpdatePanel Not Updating TextBox In SelectedIndexChanged Event

Oct 26, 2013

I have 1dropdownlist and 1 textbox in my page

I want when I select item from DropDownList in textbox write"Correct" so I wrote below code

protected void DDLclass_SIC(object sender, EventArgs e)
{
Txtsub1.Text = "Correct";
}

but it didn't worked when I select Item from DDL in textbox didn't wirte "Correct"

How I can do it?

View 1 Replies

Forms Data Controls :: How To Update Parent Gridview After Updating Child Gridview

Dec 14, 2010

I have a parent gridview which has a child gridview in the itemsTemplate. Both are binded to different SqlDataSources. I can successfully update and delete rows in the child gridview. After updating in the child gridview, some related data in the parent gridview are not updated automatically. So i have placed ParentGridview.Databind() in the rowupdated event of child gridview. But it doesnt look working.

How can i accomplish this?

View 4 Replies

Forms Data Controls :: Updating GridView Based On Computation In Another GridView

Jan 27, 2010

[Code]....

[Code]....

View 1 Replies

Forms Data Controls :: Updating GridView With GridView Columns That Are Readonly

Feb 20, 2011

I have a GridView with 5 fields. Only two of the fields are edittable (the others are READONLY).

I have an UpdateCommand as follows

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:NHLPOOL %>"
SelectCommand="SELECT [PlayerID], [Firstname], [lastname], [Goals], [Assists], [Goals]+[Assists] as Points, [AsOfDate] FROM [PlayerStats], [Player] where [PlayerStats].[PlayerID] =[Player].[ID] ORDER BY Points DESC"
UpdateCommand="UPDATE PlayerStats SET Goals =@GOALS, Assists =@ASSISTS, AsofDate=GETDATE() WHERE PLAYERID = @PLAYERID">
</asp:SqlDataSource>

The issue is I want the PLAYERID GV column to be READONLY but I get a runtime error when updating if the PLAYERID is READONLY.

I get the error "

Must declare the scalar variable "@PLAYERID"."

View 1 Replies

How To Fire One Gridview RowDataBound Event Rom Another Gridview RowCommand Event

Feb 8, 2010

I have two gridview in a single webform, I need to fire one gridview RowDataBound event from another one gridview's RowCommand.

View 3 Replies

ADO.NET :: Row Updating In A Gridview?

Feb 23, 2011

I am updating values in a gridview below is my code [Code]....

but whenever i update the value it is not getting updated in the database and it is not showing any error.

View 3 Replies

Forms Data Controls :: Gridview RowDataBound Event Fires On Every Command Event?

Jul 19, 2010

why the gridview RowDataBound event fires during a select command. I only expect it to run when the gridview is being populated with data. Is there some way to stop it from running when the select command is triggered?

View 3 Replies

C# - GridView Isn't Updating Properly

Sep 14, 2010

I have a Gridview with these parameters:

<asp:GridView runat="server" ID="ItemGrid" CssClass="Grid"
AutoGenerateColumns="false"
AutoGenerateDeleteButton="true" OnRowDeleting="RowDeleting"
AutoGenerateEditButton="true" onRowEditing="RowEdit"
OnRowCancelingEdit="CancelRowEdit" onRowUpdating="RowUpdating"
DataKeyNames="Item_ID">
<Columns>
<asp:BoundField HeaderText="Item" DataField="Item"/>
<asp:BoundField HeaderText="Family" DataField="Family"/>
<asp:BoundField HeaderText="Structure" DataField="Structure"/>
<asp:BoundField HeaderText="Updated" ReadOnly="true" DataFormatString="{0:d}" DataField="Updated"/>
</Columns>
</asp:GridView>


On updating it calls:

protected void RowUpdating(object sender, GridViewUpdateEventArgs e){
int Item_ID = (int)this.ItemGrid.DataKeys[e.RowIndex][0];[code]...

It generates the Update/Edit/Delete buttons, my Delete function is working exactly how I want and the 'Edit' button generates editable TextBoxes as it should.

My problem is in the updating part, the strings Item, Family, Structure are getting the old values, not the new values I put in the generated text boxes.If I hard code in values they are updated to the database and the DateTime.Now is always updating correctly in the database so the update query is working.

I've been looking at this/reading forums testing things for a couple days now. I'm sure I'm just missing something simple that I have overlooked.

Edit:It has been answered but for those who were curious this is my dataBind();

protected void dataBind()
{
ItemTableAdapter taItem = new ItemTableAdapter();
this.ItemGrid.DataSource = taItem.GetActive();
this.ItemGrid.DataBind();
}

View 3 Replies

VS 2008 GridView - How To Refer To The Row That Is Updating

Mar 13, 2010

I'm facing the following issue:

I have a gridview that allows updating. I only want to show the relevant fields to the user. As a result I hide the ID field of the records. But I need this value as a parameter for my update command. Apparently the value is always passed as 0 when the field is set invisible. When the field is set visible, the right value is passed.

I know it is possible to refer to a selected row and its controls, to get their values, even for invisible fields. This is what I want to do when the row is updating, in order to get the ID value of the label control which holds the ID value. How do I refer to the row that is updating? I experienced that the row is not considered 'selected', so the SelectedRow property of the gridview does not do the trick.

View 4 Replies

Dropdownlist On Gridview Updating Only First Value To The Database

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

C# - TemplateField Not Updating In GridView Using LINQDataSource?

Sep 2, 2010

Im using a LINQDataSource to populate a GridView of Universities.

Each University has an associated State, which is in another table and associated by a foreign key (StateID).

I have a TemplateField in the GridView so that when you view it normally it displays the StateName which comes from the State table and when you edit it shows a DDL populated with everything from the State table.

[Code]....

If I debug, inside of RowUpdating, GridViewUpdateEventArgs.NewValues doesnt even have a key for State.

Question: How do I let my gridview know I want it to update this column? All the BoundFields just seem to work...

View 1 Replies

Asp - Updating GridView With DataSet Source

Mar 23, 2011

I am working on a page to let a user import an excel file into our database. I want to allow the user to manipulate certain fields before committing the information so I loaded a DataSet from the Excel file and bound that to a GridView. For some reason on rowUpdate my NewValues collection is empty. Here is my GridView:

<cc1:WWGridView ID="gvImportDisplay" runat="server" CssClass="grid-view" AllowSorting="false" ShowHeader="true"
AutoGenerateColumns="true"
AutoGenerateEditButton="true"
OnRowEditing="gvImportDisplay_RowEditing"
OnRowCancelingEdit="gvImportDisplay_RowCancelingEdit"
OnRowUpdating="gvImportDisplay_RowUpdating"
>
<EmptyDataTemplate>0 results found. </EmptyDataTemplate>
</cc1:WWGridView>..............................

View 2 Replies

C# - Updating GridView Data Using LINQ?

Mar 24, 2011

I have a GridView which needs to get updated on RowUpdating Event. How can I update data using LINQ?

I am populating GV using LINQ too and here is the code for that:

protected void Page_Load(object sender, EventArgs e)
{
string getEntity = Request.QueryString["EntityID"];
int getIntEntity = Int16.Parse(getEntity);
using (OISLinq2SqlVs1DataContext dt = new OISLinq2SqlVs1DataContext())

[Code]....

View 1 Replies

VS 2008 - Gridview With ObjectDataSource Row Updating

Jul 5, 2011

Which is the correct event to handle Updating of a row in my gridview. The gridview is bound to an objectdatasource. I added a tamplate field like this to handle editing a row:

Code:
<asp:TemplateField ShowHeader="false">
<ItemTemplate>
<asp:LinkButton ID="lbEdit" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit"> </asp:LinkButton>
</ItemTemplate>

[Code] ....

No I need to handle the Update Button click.I need to set the ObjectDatasources Update params and call the update method. I'm not sure which is the correct event to do this. IS it gridview_RowUpdating??

View 1 Replies

Web Forms :: Updating Just One Field In The Gridview Update?

Aug 9, 2010

I was wondering if when you add the update link for gridview records, is there a way to only allow the user to update just one field in the record?

View 1 Replies

AJAX :: Gridview's In Update Panel Not Updating

Aug 27, 2010

I have 2 gridviews in an update panel that for some reason will not update. There is no data entry, paging, sorting going on, the data is just there to be displayed. I'm using a timer that initiates every 5 minutes to trigger the updatepanel. I also have an updatepanel on an additional page where I am also using a trigger to fire the updatepanel with 2 charts and 1 oneline/column gridview. The 2 charts update just like they are supposed to however the gridview does not. Here is the code for the 2 Gridview aspx page:

[Code]....

Does anyone know the solution to this issue or if Gridviews just don't refresh in UpdatePanels.

View 7 Replies

AJAX :: UpdatePanel AsyncPostBackTrigger And Gridview Not Updating?

Mar 8, 2011

I have a very simple application that works almost all the time. I am using an UpdatePanel. My script manager is configured to enable partial rendering. My UpdatePanel is configured for conditional update mode. My asynchronous trigger is a timer that runs every 3 seconds. I track unhandled exceptions in the database. I am not getting any unhandled exceptions. Nor am I getting managed exceptions. Now, I had two users side by side running the application today. I had one record in the data queue. The first user did not get updates; her grid did not update. The second user did get updates. The only difference was that the first user was logged in for a long period of time. The second user logged in just before the test. I reviewed the IIS log file and both users were polling the page every 3 seconds for the same data. So why didn't the first user's grid update? The code follows.

<asp:ScriptManager ID="ScriptManager1" runat="server" AsyncPostBackTimeout="30" EnablePartialRendering="true"></asp:ScriptManager>

[Code]....

In my code behind I have the following timer logic. [Code]....

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved