.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

How to update multiple rows in gridview in one shot?

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :ASP.Net
 
Hi I am using an SqlDataSource control to bind employee data to the gridview.I am displaying 20 rows per page and each row has a checkbox in the Itemtemplate. I may select(check) randomly 15 rows. I want to update all these selected rows in one shot. Is it possible in gridview? Would somebody explain with a piece of code..?


View Complete Post


More Related Resource Links

How to format and update GridView and DataGrid rows using JQuery

  
The behavior described in this question is as expected. When you set text of a cell in grid, it directly affects HTML that is going to be rendered. When you set text value of a cell, it means that you are setting innerText of the cell. The column that GridView creates for command fields (Edit, Delete and Select) are a (anchor) or button elements. So you can see what will happen if you set text value in that cell. It will wipe out those link or button controls and replace them with simple text string.

Adding Multiple Columns and Rows in GridView without using a Database

  
This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

>>>How to update multiple rows of gidview by one click

  

Hi,

I want to add multiple rows of a gridview if the data for multiple fields are same.

Idea for this is that a user may search a record with some parameter e.g. Sector, plot.

For example 15 records being displayed in gridview.

There should be checkbox before every row and if user wants to update Plot and Flat No that is same for 10 rows out of 15 so he will check the rows and update.

For this a dialog box should appear asking for the parameter i.e. Plot and Flat or something else next time may be it will be City or country. Moreover, there is already an Edit button to update records, when user click it another page open for the record to be updated and whatever he wants to update, it updates.

Hope everone understand the scenario.

I don't want to disturb the already provided Edit functionality and want to provide same record to be updated.

Any idea in this regard would be appreciated.


Multiple update statements per row in Gridview Edit

  

I want to set up a gridview that will display data like this

WeekEndingDate Project Category Sun Mon Tues Wed Thu Fri Sat
8/14/2010      proj1   test     2   1   2    3   2   1   0
8/21/2010      proj1   test     0   2   2    2   2   1   0
8/28/2010      proj1   test     0   1  

update all gridview rows at once

  

Hi,

when I execute this code i get the following error:Incorrect syntax near the keyword When.

StringBuilder sb = new StringBuilder();
             foreach (GridViewRow row in GridView1.Rows)
        {
            
            string note1 = (row.FindControl("note1") as TextBox).Text.Replace(",", ".");
            string note2 = (row.FindControl("note2") as TextBox).Text.Replace(",", ".");
            string userID = (row.FindControl("lblUserID1") as Label).Text;
 
            sb.AppendFormat(
                @"UPDATE EXAMEN
             SET NOTE = case  when 
  CODE_MATIERE ='111' then {0}
 
 
         when   CODE_MATIERE ='112' then {1}
          
         END
             where NUM_INSCRIPTION  = {2}
         ;
         ", note1, note2, userID);
 
        }




Update Trigger For Multiple Rows

  

All,

I've written a trigger that fires on a table after an insert and SHOULD update the destination table if a record exists or performs an insert if the record doesn't exist. I'm having trouble because in some instances it won't run because the subquery is returning multiple rows from the INSERTED table. Code is below. Any help is greatly appreciated.

 

CREATE TRIGGER [dbo].[InsertOverflowHistory_Trigger]
  ON [dbo].[ContainerDetail]
  AFTER INSERT
AS
BEGIN
  SET NOCOUNT ON;

  DECLARE @DCID       INT;
  DECLARE @ScheduledShipDate SMALLDATETIME;
  DECLARE @Store       NCHAR(5);
  DECLARE @ItemWeight    DECIMAL(12,4);
  DECLARE @ItemCube     D

Problem adding multiple header rows to a gridview

  

Hello all!

I'm having difficulty adding a repeating header row, every x rows, to a gridview.  I'm able to add the header only once with the below code.  For some reason it will only add it during the last iteration through the for/next statement.  I tried manually adding three separate .addat statements to different rows and it only executed the last .addat statement.  I couldn't find any information on why it's only working the one time and I hope someone has a fix or better solution.

Thanks in advance!

Code snippet (Note the IsWhole() function verifies that the rownumber divided into a whole number):

Protected Sub Gridview1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles Gridview.DataBound

        Dim grid As GridView = TryCast(sender, GridView)

        If grid IsNot Nothing Then

            Dim row As New GridViewRow(0, -1, DataControlRowType.Header, DataControlRowState.Normal)
            Dim header As GridViewRow = POSTURE_RESULT.HeaderRow
            For i As Integer = 0 To POSTURE_RESULT.Columns.C

How to access multiple header rows of the gridview in Render method

  

I have extended a gridview to add an additional header with following two hyperlink controls "Select All" and "Clear All". These will operate on checkboxes in the data rows of the grid. I hide the column headers as I only want to show one column with checkboxes and "Select/Clear All" links. Everything is working as expected. 

Now, I wanted to add a scrollbar to my grid control, I did add the scroll bar using div but what it does is, it includes the "Select All and Clear All" links aswell. I only need to add the scrollbar to datarows and not to the header.

I am trying to extend my control to include hte scrollbar by adding div during Render function. But how will I determine or loop through header rows? How will i get the header row with hyperlinks that I created above?? In Render if I do this.HeaderRow, it gets the original column header and not the custom header. Please help!!!


How to perform insert, update, delete and select rows in ASP.NET gridview control using stored proce

  
In this article, we will explore how to add, update, delete and select a record from sql server database using gridview control in a simple way. I'm using visual studio 2010 and sql server 2008 for this sample.

Adding Dynamic Rows in ASP.NET GridView Control with TextBoxes and with Delete functionality

  
In my previous examples, I have demonstrated on how to add dynamic rows in GridView control with TextBoxes and how to save the values into the database. Now, seems that most of the developers are asking if how to add a delete functionality with it. So in this example, I'm going to show on how to delete a certain row in the dynamic GridView with TextBoxes.

jQuery: Highlight Gridview Rows with Checkbox

  
Im learning and experimenting with jQuery and ASP.NET. Below is a simple solution I created to highlight rows in a gridview by clicking on a checkbox next to the row.

Gridview setup:

Binding the multiple drop down boxes in GridView using JQuery in ASP.NET

  
Here is the code for binding the multiple drop down boxes in GridView using JQuery in ASP.NET

ASP.Net Gridview Edit Update Cancel Commands

  
In ASP.Net 2.0, GridView Control also provides the functionality to edit and update the data retrieved from the database using CommandField template. You can cancel the action using Cancel Command of the CommandField. GridView consists of events that can be used to perform the actions like edit, update and cancel upon the Data items displayed in the ASP.Net GridView Data Control.

jQuery: Highlight Gridview Rows with Checkbox

  
Im learning and experimenting with jQuery and ASP.NET. Below is a simple solution I created to highlight rows in a gridview by clicking on a checkbox next to the row.

Insert Rows with a GridView

  
In ASP.NET version 1.x, I used the footer on the DataGrid control to insert new rows by placing a series of TextBox, DropDownLists, CheckBoxes etc. controls on it and then handling a save button. This also works with the GridView in version 2.0 but with one major exception: if your data source is empty, the GridView will hide your footer (and header) and only display the EmptyDataText.

Problem to group radio button across gridview rows

  
In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:

Adding Rows in GridView without using a Database

  
This article describes on how to add rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in the TextBox on Button Click and retain the GridView data on post back.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend