Add new row (end table)

[Slava]

And another question) How to add a row but in the end, but not to the top of the all inserted

[Mohanraj Gunasekaran]

Hi Slava,  

  

Thanks for using Syncfusion products.  

  

In order to add the new row at end of the table in GridControl, you can use the GridControl.Rows.InsertRange method. Please make use of the below code and refer the below attached sample  

  

Code Example  

private void addRowsBtn_Click(object sender, EventArgs e)  

{  

    this.gridControl1.Rows.InsertRange(this.gridControl1.RowCount + 1, 1);  

}  

  

UG link: https://help.syncfusion.com/windowsforms/grid/managing-the-rows-and-columns#inserting-rows-and-columns  

  

Sample link: GridControl  

 

Regards,  

Mohanraj G

[Slava]

Hi Slava,  

  

Thanks for using Syncfusion products.  

  

In order to add the new row at end of the table in GridControl, you can use the GridControl.Rows.InsertRange method. Please make use of the below code and refer the below attached sample  

  

Code Example  

private void addRowsBtn_Click(object sender, EventArgs e)  

{  

    this.gridControl1.Rows.InsertRange(this.gridControl1.RowCount + 1, 1);  

}  

  

UG link: https://help.syncfusion.com/windowsforms/grid/managing-the-rows-and-columns#inserting-rows-and-columns  

  

Sample link: GridControl  

 

Regards,  

Mohanraj G

Thanks for the answer. But now the problem with filling column
I was here such code:
                    this.checkGrid.Rows.InsertRange(1, 1);
                    this.checkGrid[1, 1].Text = item.Attribute("text").Value;
                    this.checkGrid[1, 2].CellValue = item.Attribute("kol").Value;
                    this.checkGrid[1, 3].Text = item.Attribute("ed").Value;
                    this.checkGrid[1, 4].CellValue = item.Attribute("cost").Value;
                    this.checkGrid[1, 5].CellValue = item.Attribute("skidka").Value;
                    this.checkGrid[1, 6].CellType = GridCellTypeName.FormulaCell;
                    this.checkGrid[1, 6].CellValue = "=" + "(" + item.Attribute("kol").Value + "*" + item.Attribute("cost").Value + ")" + "*" + "(" + "1" + "-" + item.Attribute("skidka").Value + ")";
                    this.checkGrid.Refresh();

I changed your decision

                    this.checkGrid.Rows.InsertRange(this.checkGrid.RowCount +1, 1);
                    this.checkGrid[this.checkGrid.RowCount +1, 1].Text = item.Attribute("text").Value;
                    this.checkGrid[this.checkGrid.RowCount +1, 2].CellValue = item.Attribute("kol").Value;
                    this.checkGrid[this.checkGrid.RowCount +1, 3].Text = item.Attribute("ed").Value;
                    this.checkGrid[this.checkGrid.RowCount +1, 4].CellValue = item.Attribute("cost").Value;
                    this.checkGrid[this.checkGrid.RowCount +1, 5].CellValue = item.Attribute("skidka").Value;
                    this.checkGrid[this.checkGrid.RowCount +1, 6].CellType = GridCellTypeName.FormulaCell;
                    this.checkGrid[this.checkGrid.RowCount +1, 6].CellValue = "=" + "(" + item.Attribute("kol").Value + "*" + item.Attribute("cost").Value + ")" + "*" + "(" + "1" + "-" + item.Attribute("skidka").Value + ")";
                    this.checkGrid.Refresh();


Lines are added but empty. Without filling (

[Mohanraj Gunasekaran]

Hi Slava,     

   

Thanks for your update.   

   

We have analyzed your provided code part. If you have used the InsertRange method to add the new row for GridControl, then row count will be increased automatically. So please use the “RowCount” instead of “RowCount + 1” to set the value for new row. Please refer the below code example and attached sample,   

   

Code example   

//Row count is 25   

 this.checkGrid.Rows.InsertRange(this.checkGrid.RowCount +1, 1); //Now row count is 26   

this.checkGrid[this.checkGrid.RowCount +1, 1].Text = item.Attribute("text").Value; //So you have tried to set the value for 27^th row. But there is not presenting the 27^th row in GridCotnrol   

   

Please modify your code like below   

this.checkGrid[this.checkGrid.RowCount , 1].Text = item.Attribute("text").Value;   

this.checkGrid[this.checkGrid.RowCount, 2].CellValue = item.Attribute("kol").Value;
this.checkGrid[this.checkGrid.RowCount, 3].Text = item.Attribute("ed").Value;
this.checkGrid[this.checkGrid.RowCount, 4].CellValue = item.Attribute("cost").Value;
this.checkGrid[this.checkGrid.RowCount, 5].CellValue = item.Attribute("skidka").Value;
this.checkGrid[this.checkGrid.RowCount, 6].CellType = GridCellTypeName.FormulaCell; this.checkGrid[this.checkGrid.RowCount +1, 6].CellValue = "=" + "(" + item.Attribute("kol").Value + "*" + item.Attribute("cost").Value + ")" + "*" + "(" + "1" + "-" + item.Attribute("skidka").Value + ")";   

   

Sample link: GridControl   

   

Regards,   

Mohanraj G