GridView CellEndEdit Add New Row

[Paidakal]

Hi

How I have to add new row on cell end edit. I have 10 columns in the gridview, after particular cell end edit and pressing tab key i should add a new row.

I tried ProcessTab Key and it is not working.

Please let me know how i can achieve this.

Thanks in advance.

Regards

Gopinath

 

 

 

 

 

[Dess | Tech Support Engineer, Principal]

Hello , 

Thank you for writing.  

RadGridView has an editing mechanism and only one cell can be in edit mode at a time. Additional information about editing in RadGridView is available here: http://docs.telerik.com/devtools/winforms/gridview/editors/editors

RadGridView manages user mouse and keyboard input over its rows by GridRowBehavior. Depending on the row type, RadGridView introduces different behaviors. Thus, you can achieve some custom behavior when pressing the Tab key considering the row type. You can refer to the following help article: http://docs.telerik.com/devtools/winforms/gridview/rows/row-behaviors

I hope this information helps. Should you have further questions I would be glad to help.

Regards,
Dess
Telerik by Progress

[Gopinath]

Hi,

Thanks for the reply.

I tried working with Row behavior, i am unable to get new row after the rate column. and the focus should be supplier name in newly added Row.

Pl find the attached images.

I tried with the following Code.

 public class MyGridBehavior : Telerik.WinControls.UI.GridNewRowBehavior
        {
            protected override bool ProcessTabKey(KeyEventArgs keys)
            {
                if (this.GridControl.CurrentCell.ColumnIndex == this.GridControl.Columns.Count - 1 && this.GridControl.CurrentCell.RowIndex == this.GridControl.Rows.Count - 1)
                {
                    this.GridControl.Rows.AddNew();
                    return true;
                }

                return base.ProcessTabKey(keys);
            }
        }

 BaseGridBehavior gridBehavior = gvProductSupplier.GridBehavior as BaseGridBehavior;
            gridBehavior.UnregisterBehavior(typeof(GridViewNewRowInfo));
            gridBehavior.RegisterBehavior(typeof(GridViewNewRowInfo), new MyGridBehavior());

Regards

Gopinath

 

 

 

[Gopinath]

Hi Dess,

Sorry to trouble u again.

Pl if u have any sample code on GridNewRowBehavior, pl forward it.

I need that i have to insert a new row after the Rate and continue my data entry process. 

Regards

Gopinath

 

[Gopinath]

Hi Dess,

I tried many ways, I am using unbound grid. I tried GridNewRow. row is not added.

Following code i tried

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.IO;
using System.Drawing;
using System.Text;
using System.Collections;
using System.Windows.Forms;
using Telerik.WinControls;
using Telerik.WinControls.UI;
using Telerik.WinControls.Data;

namespace Oet.Rcv3.Ent.Frms
{
    public partial class TestNewRowBehavior : Telerik.WinControls.UI.RadForm
    {
        public TestNewRowBehavior()
        {
            InitializeComponent();
        }

        private void TestNewRowBehavior_Load(object sender, EventArgs e)
        {
            radGridView1.AllowAddNewRow = false;
            radGridView1.AddNewRowPosition = SystemRowPosition.Bottom;
            radGridView1.Rows.AddNew();

            BaseGridBehavior gridBehavior = radGridView1.GridBehavior as BaseGridBehavior;
            gridBehavior.UnregisterBehavior(typeof(GridViewNewRowInfo));
            gridBehavior.RegisterBehavior(typeof(GridViewNewRowInfo), new MyGridBehavior());

            radGridView1.Columns["Column1"].IsCurrent = true;
            radGridView1.BeginEdit();

        }

        public class MyGridBehavior : Telerik.WinControls.UI.GridNewRowBehavior
        {
            protected override bool ProcessTabKey(KeyEventArgs keys)
            {
                if (this.GridControl.CurrentCell.ColumnIndex == this.GridControl.Columns.Count - 1 && this.GridControl.CurrentCell.RowIndex == this.GridControl.Rows.Count - 1)
                {
                    this.GridControl.Rows.AddNew();
                    return true;
                }

                return base.ProcessTabKey(keys);
            }
        }
    }
}

Regards

Gopinath

 

 

[Dess | Tech Support Engineer, Principal]

Hello Gopinath, 

Thank you for writing back. 

According to the provided sample code, it seems that you set the AllowAddNewRow property to false. This will automatically hide the new row. As a result, the GridNewRowBehavior will be never used because you don't have a new row at all. I would like to note that when you set the AllowAddNewRow property to true and display the new row, pressing the Tab key in the last editable columns will insert the row in the data rows collection automatically. However, if you need to add a new row after editing the Rate column in a data row, it is appropriate to handle the GridDataRowBehavior.

public RadForm1()
{
    InitializeComponent();

    radGridView1.AllowAddNewRow = false;
    radGridView1.AddNewRowPosition = SystemRowPosition.Bottom;
    radGridView1.Rows.AddNew();

    BaseGridBehavior gridBehavior = radGridView1.GridBehavior as BaseGridBehavior;
    gridBehavior.UnregisterBehavior(typeof(GridViewDataRowInfo));
    gridBehavior.RegisterBehavior(typeof(GridViewDataRowInfo), new MyGridBehavior());

    radGridView1.Columns["Column1"].IsCurrent = true;
    radGridView1.BeginEdit();
}

public class MyGridBehavior : Telerik.WinControls.UI.GridDataRowBehavior
{
    protected override bool ProcessTabKey(KeyEventArgs keys)
    {
        if (this.GridControl.CurrentCell.ColumnIndex == this.GridControl.Columns.Count - 1 &&
            this.GridControl.CurrentCell.RowIndex == this.GridControl.Rows.Count - 1)
        {
            this.GridControl.Rows.AddNew();
            return true;
        }

        return base.ProcessTabKey(keys);
    }
}

I hope this information helps. If you have any additional questions, please let me know. 

Regards,
Dess
Telerik by Progress

[Gopinath]

Hi Dess,

Thanks for the reply. It is working fine, but after Column3 it is adding the row but cursor remains in the same column.

It should go to column1 again to continue enter the data in the next row. After adding the row the cursor should select column1.

I tried working with UserAddedRow, and User AddingRow, it is not working.

Now how to set cursor to  the column1. I tried the follwing code. Expecting your earliest reply.

  private void RadGridView1_UserAddingRow(object sender, GridViewRowCancelEventArgs e)
        {
            radGridView1.Columns["Column1"].IsCurrent = true;
            radGridView1.BeginEdit();
        }

        private void RadGridView1_UserAddedRow(object sender, GridViewRowEventArgs e)
        {
            radGridView1.Columns["Column1"].IsCurrent = true;
            radGridView1.BeginEdit();
        }

Regards

Gopinath

 

[Gopinath]

Hi Dess

Pl find enclosed image for your information.

Regards

Gopinath

 

[Dess | Tech Support Engineer, Principal]

Hello Gopinath, 

Thank you for writing back. 

The UserAdding and UserAdded events are fired when the user commits the new row (by pressing the Enter key or by clicking somewhere in the grid). When you add the row programmatically, these events are not supposed to be fired. However, in order to focus the first column after a new record is inserted, you can set the RadGridView.CurrentColumn. Here is a sample code snippet:

public class MyGridBehavior : Telerik.WinControls.UI.GridDataRowBehavior
{
    protected override bool ProcessTabKey(KeyEventArgs keys)
    {
        if (this.GridControl.CurrentCell.ColumnIndex == this.GridControl.Columns.Count - 1 &&
            this.GridControl.CurrentCell.RowIndex == this.GridControl.Rows.Count - 1)
        {
            this.GridControl.Rows.AddNew();
            this.GridControl.CurrentColumn = this.GridControl.Columns[0];
            return true;
        }

        return base.ProcessTabKey(keys);
    }
}

I hope this information helps. If you have any additional questions, please let me know. 

Regards,
Dess
Telerik by Progress

[Gopinath]

Hi Des,

Thanks for the reply. I was trying to work with IsCurrent method in the class, so it was not working. I hope it works, I will try.

How can i move rows up and down in the grid, by pressing UP Arrow and DownArrow Key. Is there any way to do this?

Expecting your reply.

Regards

Gopinath

[Hristo]

Hi Gopinath,

Thank you for writing.

I hope that the approach suggested by my colleague would fit your actual project.

I would like to point out that we also strive to keep our forum threads more or less focused on a single topic. Regarding your other question please open a support ticket or a new forum thread.

I hope this helps. Please let me know if you have other questions.

Regards,
Hristo
Telerik by Progress

[Gopinath]

Hi

Thank you for replying.  The above solution working good. thanks for that.

I have raised another forum thread.

Regards

Gopinath