what is the best way of updating to db only the changed rows using gridview?i have a gridview control that has inline editing and when the user edit the row there are two options "Update" or "Cancel" so user might just click update button without really updating the row...how can i make sure that, user really changed the row?
View 2 Replies
I've got a GridView in which all rows are set to Edit by default.
I want to be able to save the rows only where changes have been made. At present, my code will only update the first row from my GridView to my database. I've had a look on the internet, and think that the Getchanges might be able to help me, but I'm struggling to work our how exactly to implement it in my scenario.
[Code]....
Having a bit of difficulty working this gridview update problem out - I have managed to get edit/update function working but instead of only updating the current gridview row it is updating the whole table I believe this is due to a missing where statement on my Update statement - to single out the row index of my grid row.When I configure my sql datasource I am using custom statements Here is my update statement
UPDATE SimpData SET store_nbr = @store_nbr, date = @date, data_type = @data_type, acct_1 = @acct_1, amt_1 = @amt_1, acct_2 = @acct_2, amt_2 = @amt_2, acct_3 = @acct_3, amt_3 = @amt_3, cheque_nbr = @cheque_nbr, cheque_amt = @cheque_amt, gst_hst = @gst_hst, qst = @qst, comments = @comments, uploaded = @uploaded
Here is my gridview
<asp:GridView
ID="GridView1"
runat="server"
CellPadding="4"
Font-Names="Arial"
ForeColor="#333333"
GridLines="None"
Font-Size="Smaller"
Width="100%"
AllowPaging="True"
OnSelectedIndexChanged="GridView1_SelectedIndexChanged"
OnRowCommand="GridView1_RowCommand"
OnRowEditing="GridView1_RowEditing"
OnRowUpdating="GridView1_RowUpdating"
AutoGenerateColumns="False"
DataSourceID="SqlDataSource1"
OnRowDataBound="GridView1_RowDataBound">
<RowStyle
BackColor="#EFF3FB"
/>
<FooterStyle
BackColor="#507CD1"
Font-Bold="True"
ForeColor="White"
/>
<PagerStyle
BackColor="#2461BF"
ForeColor="White"
HorizontalAlign="Center"
/>
<SelectedRowStyle
BackColor="#D1DDF1"
Font-Bold="True"
ForeColor="#333333"
/>
<HeaderStyle
BackColor="#507CD1"
Font-Bold="True"
ForeColor="White"
Font-Size="Smaller"
/>
<EditRowStyle
BackColor="#2461BF"
/>
<AlternatingRowStyle
BackColor="White"
/>
<Columns>
<asp:ButtonField
ButtonType="Button"
CommandName="Select"
HeaderText="Select item to delete"
ShowHeader="True"
Text="Delete">
<ControlStyle
Font-Size="Smaller"
/>
</asp:ButtonField>
<asp:CommandField
ShowEditButton="True"
/>
<asp:ButtonField
ButtonType="Button"
CommandName="Select"
HeaderText="Select item to upload"
ShowHeader="True"
Text="Upload">
<ControlStyle
Font-Size="Smaller"
/>
</asp:ButtonField>
<asp:BoundField
DataField="store_nbr"
HeaderText="Store Number"
SortExpression="store_nbr"
/>...............
When i update rows using gridview itz updating as m"System.Web.UI.WebControls.TextBox" what should i do?
View 22 RepliesI have a gridview inside an updatepanel.After updating the gridview, accessing the individual rows does not seem to give the right row. For example:
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
GridViewRow row = ((e.CommandSource as Control).NamingContainer as GridViewRow);
Row from the above code gives the values from the gridview before the gridview is refreshed/updated.
I am using untyped database bind to gridview in an edit form. Now user makes some changes to that datatable (update, delete, insert). How do I detect which rows he changes and which rows he deleted (so I drop them from DB). I know it can be done easily via table adapters but I am supporting a previously built app using untyped datatables/datasets.
View 9 RepliesExisting records can be updatedNew records can be insertedAll existing records can be deleted & new ones can be insertedExisting records have a primary key field
New ones are just blank inserts
All this detail is stored in a data table. On form update I only want to update existing (only modified rows) & insert new rows. I have gone about loading the changed records in a new data table
DataTable changedRecordsTable = dataTable_old.GetChanges();
How do I compare it with all the records in the old datatable and pass them to the save query ?
I want to allow people visiting my website to have the ability to change the displayed data in a DataGridView from a Dropdown box and have it auto postback. So options are in the dropdown box 10, 20, 30
View 5 RepliesI have a datagrid that is displaying data that is being returned from a stored procedure. That works fine. The problem is that I want to do sorting. I know that there is sorting functionality in the grid, however, I don't want to go back to the server and get a new set of data. What I want to do is just re-sort the data that is already being displayed.
Basically, I couldn't not find an easy solution to this issue. I tried updating my dataGrid to a gridView control and even that (for my particular issue) was difficult. I wound up un-doing all the changes and just adding another grid that had just the data I wanted for the requirement. If anyone else has an issue like this I would recommend taking it out of a datagrid and writing it in jQuery. I could of written a table that had the data I wanted (and fully sortable using a plug-in mentioned below) in 15 minutes compared to the hours I spent trying to jam a square peg into a round hole.
I have a GridView containing records from a table which can be deleted or updated. If you want to edit a row, it should display the update and cancel buttons so that you can keep or cancel the current edit (I hide update and cancel as default). I am using the following asp for the button column of the GridView:
<asp:TemplateField visible ="true" >
<HeaderTemplate>
<div id = "header">Maintain</div>
[code]...
I am using an Entity Data Model (.edmx) in my project. I am using context.Customers to bind the grid.
Now when the datasource is binded to grid, i made some updates for 2 rows in the database.
Now, how can i capture those 2 updated rows in the context........?
I am sure I am not the first to ask this question but I cannot find an answer in these or any other forums. I guess I am not wording the question right. In short I have a gridview populated but a database via an SQLDatasource. I have an Edit column in the datagrid and an updatequery in the datasource. When the Edit is click the line goes into edit mode, the user then clicks Update and I get an error. Could not find control 'DropDownList1' in ControlParameter 'Frequency'. The only complication is that there is a drop down control when the "EDIT" column is selected. The dropdownlist gets it list from another SQLDatasource. This all works fine. Here is the code snip:
<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateEditButton="True"
I am using fileuploader control in gridview template control's edittemplate but the problem is when i press edit button fileuploader control and update other controls such as textboxes and press update button there is no value for Fileuploader control so i need the value of image control that is in itemtemplate so i pass it as a parameter.
here is my code
<asp:GridView CssClass="mGrid" ID="grdviewAvailForum"
runat="server" AutoGenerateColumns="False"
DataSourceID="objDtsrcAddForum" DataKeyNames="ForumID" [code]....
now here in else i need the old values,how i can get it.
i've dynamically created new rows on button click in gridview with 3 dropdownlist.for the first default row the selectindexchanged is firing and on pageload 1st ddl is loading with values and basing on selection the second ddl is showing values and third ddl is showing basing on second ddl. Now, when i click add new row, a new row is created with 3 ddl's ...1st one is showing properly but when i select from that ddl ,it should show data accordingly but its not showing particular data but showing all realted data from DB.same for 3rd ddl.
Also when new row is added and the first ddl is selected on postback the second ddl data is refreshing..
I'm trying to update fields in a DataTable. The field I'm trying to edit is a date, I need to format it.
foreach (DataRow row in dt.Rows)
{
string originalRow = row["Departure Date"].ToString(); //displays "01/01/2010 12:00:00 AM"
row["Departure Date"] = DateTime.Parse(row["Departure Date"].ToString()).ToString("MM/dd/yyyy");
string newRow = row["Departure Date"].ToString(); //also displays "01/01/2010 12:00:00 AM"
}
How come this isn't getting updated?
I have this code:
<asp:GridView ShowFooter="true" DataSourceID="odsRooms" Width="700" DataKeyNames="id,locationid" ID="gvRooms" GridLines="None" PageSize="10" runat="server" AllowSorting="true" AllowPaging="True" CellSpacing="4" AutoGenerateColumns="False" >
<Columns>
<asp:TemplateField HeaderStyle-HorizontalAlign="Left" HeaderStyle-VerticalAlign="Bottom" >
<ItemTemplate>
<%# Eval("roomname")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tbRoomname" MaxLength="20" Text='<%# Eval("roomname")%>' runat="server" />
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderStyle-HorizontalAlign="Left" HeaderStyle-VerticalAlign="Bottom">
<ItemTemplate>
<%# Eval("sqmeters")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tbSqmeters" MaxLength="6" Width="60" Text='<%# Eval("sqmeters")%>' runat="server" />
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderStyle-HorizontalAlign="Left" >
<ItemTemplate>
<%# Eval("persreception")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tbPersreception" MaxLength="6" Width="60" Text='<%# Eval("persreception")%>' runat="server" />
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderStyle-HorizontalAlign="Left" HeaderStyle-VerticalAlign="Bottom" >
<ItemTemplate>
<%# Eval("persdiner")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tbPersdiner" Text='<%# Eval("persdiner")%>' MaxLength="6" Width="60" runat="server" />
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderStyle-HorizontalAlign="Left" HeaderStyle-VerticalAlign="Bottom" >
<ItemTemplate>
<%# Eval("persparty")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tbPersparty" Text='<%# Eval("persparty")%>' MaxLength="6" Width="60" runat="server" />
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderStyle-HorizontalAlign="Left" HeaderStyle-VerticalAlign="Bottom" >
<ItemTemplate>
<%# Eval("descriptiontext")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tbDescriptiontext" Text='<%# Eval("descriptiontext")%>' TextMode="MultiLine" Rows="2" Columns="28" runat="server" />
</EditItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowDeleteButton="true" DeleteText="Delete" ShowEditButton="true" EditText="Edit" CancelText="Cancel" />
</Columns>
</asp:GridView>
<asp:ObjectDataSource ID="odsRooms" InsertMethod="InsertRoom" DeleteMethod="DeleteRoom" UpdateMethod="UpdateRoom" runat="server" SelectMethod="GetLocationRoomsPagedSorted" SelectCountMethod="GetLocationRoomsCount" SortParameterName="sortExpression"
TypeName="locationsBLL" EnablePaging="true">
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:ControlParameter ControlID="tbRoomname" PropertyName="Text" Name="roomname" Type="String" />
<asp:ControlParameter ControlID="tbSqmeters" PropertyName="Text" Name="sqmeters" Type="String" />
<asp:ControlParameter ControlID="tbPersreception" PropertyName="Text" Name="persreception" Type="String" />
<asp:ControlParameter ControlID="tbPersdiner" PropertyName="Text" Name="persdiner" Type="String" />
<asp:ControlParameter ControlID="tbPersparty" PropertyName="Text" Name="persparty" Type="String" />
<asp:ControlParameter ControlID="tbDescriptiontext" PropertyName="Text" Name="descriptiontext" Type="String" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
</asp:ObjectDataSource>
And get this error when I click 'Edit' and then 'Update':
Server Error in '/' Application. Could not find control 'tbDescriptiontext' in ControlParameter 'descriptiontext'.Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: Could not find control 'tbDescriptiontext' in ControlParameter 'descriptiontext'.
Source Error:
[Code]....
Stack Trace:
[Code]....
[InvalidOperationException: Could not find control 'tbDescriptiontext' in ControlParameter 'descriptiontext'.]
System.Web.UI.WebControls.ControlParameter.Evaluate(HttpContext context, Control control) +2961386
System.Web.UI.WebControls.Parameter.UpdateValue(HttpContext context, Control control) +152
System.Web.UI.WebControls.ParameterCollection.UpdateValues(HttpContext context, Control control) +113
System.Web.UI.WebControls.ParameterCollection.GetValues(HttpContext context, Control control) +47
System.Web.UI.WebControls.ObjectDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +1204
System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +3636597
System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) +1336
System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +641
System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) +164
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +52
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3691
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
i have asp.net chart control and gridview control in updatepanle my issue is when i click on edit link in gridview my chart control is not displaying but when i refresh my page iam to see it why is so??
View 1 RepliesI'm new in ASP.net, i download your code from the below link.URL...I was searching from net to add a new row in client side i go thru this it was OSOME. I have another dought if you add a one link delete option to delete the row in client side.Another thing if we add a template field such as textbox and dropdown list then there no datafield then how we fill the grid from database.
View 1 RepliesMaybe this could be a simple questino, but for me it's difficult to do this action: I have a table in sql server 2005 with some records stored, for example 10 records. The primary key of this table, let's call it "Employee", it's a number field with an autoincrement constraint. I want to store more data into the table by using a OdbcDataTable object and OdbcDataAdapter and adding new rows to the datatable and afeter that use the "Update" method from the OdbcDataAdapter object.
The big deal is this: let's suppose that I want a add a new record to the datatable object, using any method or code sequence that you want. if I have 10 records stored on the data base table, when I retrieve this table schema by using the OdbcDataAdapter "Fill" method, I have a copy of the data base table schema in the DataTable object, right?. if I add a new row on the datatable object, it's suppose that the primary key column of that table must AUTO-INCREMENT the value of the key, I mean if the last value that I store on the table was the number 10 on the PK field, when I add a new row on the datatable object, the PK value on the datatable object must be the number 11 if the autoincrement constraint is present into the DataTable object, but in my case, it doesn't work
So, How can I define the conditions or set the c# data objects properties to wor in that way???. In this moment the PK column on the odbcDataTable doesn't auto-increment its value when I add a new row on it.
Please helpe with this.
PD: I have another question about the DataTable object, how many records can store this object?? I have some problems with this because sometimes when I use the Fill() method to get data into the DataTable or a DataSet object there's no problem if the Fill() method retrieves about 142000 records, but when I retrieve over the 145000 records, when I inspect the DataSet or DataTable object by using the debuging mode, they have null value. Any of you can tell me why this situation ocurrs??
To what way student is useful Dropdownlist1(Good,Fair,Poor) When i select the Dropdpownlist1 in that select the Poor POPUP Screen will open. the POPUP Screen as follows Negative_Feed_Back Textbox1(In that textbox type the reason for Poor) OK (Button) When user click the OK (Button) the select dropdownlist and Remarks will be displayed in the gridview In gridview as follows Dropdown Remarks 0 Student performance is not good Suppose if user wrongly type the reason for poor want to change means in that case he can change reason for poor and click the ok button. In that case two Poor reasons are there in gridview as follows Dropdown Remarks 0 Student performance is not good 0 The Students not good at all in that case i want to delete the first First Row of the gridview. Output as follows Dropdown Remarks 0 The Students not good at all
My code as follows
private void SetDropdowndetails(string Dropdownname, Int32 Dropdownid)
{
string SelectedDropdown = string.Empty;
SelectedDropdown = Dropdownname.ToString();
hfnegativefeedback.Value = Dropdownid.ToString();
[code]....
When I run my above code shows error as follows Column 'Remarks' does not belong to underlying table 'Table1'. The above error shows in the below function as follows :
DataTable dt = new DataTable();
dt = (DataTable)ViewState["Remarks"];
dt = dt.DefaultView.ToTable(true, "Dropdown", "Remarks");
gvnegative.DataSource = dt;
gvnegative.DataBind();
I have this function:
[Code]....
I set itemsRead and startRowIndex in ViewState:
[Code]....
This is my PageIndexChanged event:
[Code]....
My purpose is to modified some data only for current page in a gridview. I call this function in page load and GridView_PageIndexChanged events. When it's called in page load event, it works fine. But when it's called in PageIndexChanged event, only the rows on the first page in GridView are looped through. For example, if I click page 5, the rowStartIndex becomes 100 = 5 x 20 (my pagesize). The if condition becomes itemsRead >= 100 andAlso itemsRead < 120. But after itemsRead is increased to 19, the For each gridViewRow loop stops and the if condition is never satisfied.
I put a GridView control in a Panel control so that the GridView's rows can be scrolled vertically. With selection of row enabled for a Button field, I am able to select any row with the selected row background color highlighted. Problem is when you scroll down to a row that is way pass the Panel height and select the row, after postback the GridView will render to show the top rows which are visible within the Panel height. So the selected row in it's background color cannot be seen.
View 3 RepliesI have user control. Inside that have some buttons. my page has gridview . I want check grid view rows from user control button. User control is my menu. My grid has column with radio button.
When i click button of user control i want load item page which data which gridview radio button cheked true.
i'm using the code below to select multiple rows in a gridview using a checkbox, how do I modify the code in a "select all" button click event to select all the rows by checking the checkboxes in all the rows? How do I also clear all the checkboxes using sa "Clear" button click event?
[code]....
i have read and used this script.Adding Dynamic Rows in ASP.Net GridView Control with TextBoxes..it is very usful to me but i want to fetch data from sqll database and fill the newest row with it. the past row data hav to be remain same. becoz of the same name of textbox it happens. whenever i try to fetch data from database and fill textbox all rows get updated with the same data.
View 1 Replies
