How to edit in Datagrid like excel typee?

Question

I need to add product and quanity in a grid where grid should have rows added by default and once i leave the last textbox a new row to be created. How to start with Datagrid. How to make Datagrid editable?

Sundaram Subramanian · Answer

Follow this code. private void dg_PreviewKeyDown(object sender, KeyEventArgs e) { try { if (e.Key == Key.Enter) { e.Handled = true; var cell = GetCell(dgIssuance, dgIssuance.Items.Count - 1, 2); if (cell != null) { cell.IsSelected = true; cell.Focus(); dg.BeginEdit(); } } } catch (Exception ex) { MessageBox(ex.Message, "Error", MessageType.Error); } } public static DataGridCell GetCell(DataGrid dg, int row, int column) { var rowContainer = GetRow(dg, row); if (rowContainer != null) { var presenter = GetVisualChild (rowContainer); if (presenter != null) { // try to get the cell but it may possibly be virtualized var cell = (DataGridCell)presenter.ItemContainerGenerator.ContainerFromIndex(column); if (cell == null) { // now try to bring into view and retreive the cell dg.ScrollIntoView(rowContainer, dg.Columns[column]); cell = (DataGridCell)presenter.ItemContainerGenerator.ContainerFromIndex(column); } return cell; } } return null; }

suresh kumar · Answer

I cant Understand can u explain with one sample example in WPF

Sundaram Subramanian · Answer

Follow the Code, This will add a Row if and only if the current cell is the last one in the DGV and the user presses Tab . int yourLastColumnIndex = dataGridView.Columns.Count - 1; protected override bool ProcessCmdKey(ref Message msg, Keys keyData) { if (dataGridView.Focused && keyData == Keys.Tab) && if (dataGridView.CurrentCell.ColumnIndex == yourLastColumnIndex dataGridView.CurrentRow.Index == dataGridView.RowCount - 1) { dataGridView.Rows.Add(); // we could return true; here to suppress the key // but we really want to move on into the new row..! } return base.ProcessCmdKey(ref msg, keyData); }

suresh kumar · Answer

Thanks Bro I will try

How to edit in Datagrid like excel typee?

Answers (4)