GridDataBoundGrid paste from Excel and add as new records

[Daniel Salazar]

Hi,

I've been searching the forums the samples and trying to read the documentation without success. How do I place a button that allows me the contents of the clipboard, an excel worksheet to be pasted on the databound grid, but the records should be added as new records. Not paste them over the existing records.

Could you point me in the right direction?

Daniel

[haneefm]

Hi Daniel,

If you want to add new row when paste data from excel, then you will have to handle the entire paste yourself. You can do this by catch the grid.Model.ClipboardPaste event and add the new row using the underlying datasource of the grid( For DataTable,use DataTable.NewRow method).Than paste the add over newly added rows in a Grid. Here is a forum thread that shows this "How to customize the ClipBoard paste technique in a Grid?".

http://www.syncfusion.com/Support/Forums/message.aspx?&MessageID=54349

Best regards,
Haneef