GridControl Cut and Insert

Hi, How can we cut and insert the row or rows in the Gridcontrol.(Behavior same like excel) If there is any sample application pls share regards Pratiksha

By default, you can mouse down and select a range of cells. Once the cells are selected, you can press ctl+C to copy them, and ctl+X to cut them. You can then paste them into Excel or any other application that accepts a text from the clipboard.

Can you pls tell how can we do that programatically. on the context menu option cut i was them to cut (just like excel) and when insert context menu is clicked i want selected cut rows to remove from the original position and inserted at the new positions >By default, you can mouse down and select a range of cells. Once the cells are selected, you can press ctl+C to copy them, and ctl+X to cut them. You can then paste them into Excel or any other application that accepts a text from the clipboard. > >

You can call these methods in a GridControl. gridControl1.CutPaste.Copy gridControl1.CutPaste.Paste gridControl1.CutPaste.Cut In a GridDataBoundGrid, the CutPaste object is a member of the gridDataBoundGrid1.Model.

Can you pls suggest method for adding the rows and deleting the rows in the Gridcontrol... so that the copied contents can be pasted in the newly inserted rows >You can call these methods in a GridControl. > >gridControl1.CutPaste.Copy >gridControl1.CutPaste.Paste >gridControl1.CutPaste.Cut > >In a GridDataBoundGrid, the CutPaste object is a member of the gridDataBoundGrid1.Model.

To insert rows and/cols, you will need to call grid.Rows.InsertRange and grid.Cols.InsertRange. To decide how many rows/columns you need to insert, you will have to get the data from the Clipboard and see how big the paste is. Here is a code snippet.

DataObject data = (DataObject) Clipboard.GetDataObject();

if(data.GetDataPresent(DataFormats.Text))

{

	string s = (string)data.GetData(DataFormats.Text);

	string[] rows = s.Split(new char[]{''\n''});

	int numRows = rows.GetLength(0);

	if(numRows > 0 && rows[numRows - 1].Length == 0)

		numRows--; //remove extra empty row if present

		int numCols = 0;

	if(numRows > 0)

	{

		string[] cols = rows[0].Split(new char[]{''\t''});

		numCols = cols.GetLength(0);

	}

	Console.WriteLine("{0} rows by {1} cols", numRows, numCols);

}