Update Gridview on single button click

[Harshad Teli]

I am using GridGrouping control , I set ExcelEditMode="True" ,i also have the checkbox column. Now what i want is after making changes in grid i clicked on Save button and that button will loop over that gridview and save updated record in database and refresh grid with updated values.I am using dataset to bind gridview.. please provide me code sample if possible.(see attached image)

[Harshad Teli]

I am using SQL Server2005 and VS2008

[Rekha P]

Hi Harsha,

Thank you for your interest in Syncfusion Products.

The Essential Grid provides support for Excel-like Edit for all editable fields. This feature offers cell in-line editing, cell selection and row selection. Please find a simple sample illustrtaing Excel Like Edit feature.

http://files.syncfusion.com/support/GGC.Web/7.2.0.37/F82654/Sample.zip

Features illustrated in above sample:
- GridGroupingControl is binded with SqlDataSource.
- ExcelEditMode is enabled with a column [Discontinued] with CheckBox.
- Updated values can be retrieved via Save button click and then updated into DataBase.
- Get the TableRow in the TopLevelTable.
- Check if that Row is GridRow if so Iterate the updated Records. Please refer the code snippet.

    void Button1_Click(object sender, EventArgs e)
    {
        Label1.Text = "";
        foreach (TableRow row in this.GridGroupingControl1.TopLevelTable.Rows)
        {
            if (row is GridRow)
            {
                GridRow gridRow = row as GridRow;
                if (gridRow.Record != null)
                {
                    foreach (GridColumnDescriptor gcd in this.GridGroupingControl1.TableDescriptor.Columns)
                    {
                        Label1.Text += gridRow.Record.GetValue(gcd.Name) + "--";
                    }
                    Label1.Text += "
";
					
		    //Update the values into the database.
										
                }
            }
        }
    }

Please have a look at the above sample and let me know if this helps you out.

Thanks,
Rekha

[Fernando]

Hi! I am trying to accomplish this, the sample posted here is not available, can you send me a similar sample? Thanks!

 

Regards,

Fernando

[Sandhya D]

Hi Fernando,

Thanks for your interest in syncfusion products.

We have created a similar sample based on your requirement , Please refer the code below.

[Default.aspx.cs]:

public  void  button2_Click(object sender, EventArgs e)

{

Label1.Text = "";

foreach (TableRow row in this.GridGroupingControl1.TopLevelTable.Rows)

{

if (row is GridRow)

{

GridRow gridRow = row as GridRow;

if (gridRow.Record != null)

{

foreach (GridColumnDescriptor gcd in this.GridGroupingControl1.TableDescriptor.Columns)

{

Label1.Text += gridRow.Record.GetValue(gcd.Name) + "--";

}

Label1.Text += "";

//Update the values into the database.

}

}

}

}

[Default.aspx]:

<asp:Button ID="Button2" onClick="button2_click" runat="server" Text="Getdata" OnClientClick="update()"/>

We have attached sample for your reference.Please get back to us if you need further assistance.

Regards,

Sandhya D

LocalizeGrid_5e6fea31.zip