private void pasteRowToolStripMenuItem_Click(object sender, EventArgs e) { if (tcMain.SelectedTabPageIndex == -1 || tcMain.SelectedTabPage == null) { StaticReference.ShowWarning(this, LanguageManager.Get("Message_NoFileOpen")); return; } string fileName = tcMain.SelectedTabPage.Tag as string; KOTableFile tbl = StaticReference.GetTableByFullName(fileName); GridView view = GetViewFromSelectedTabPage(); if (null == tbl || null == view) { StaticReference.ShowWarning(this, LanguageManager.Get("Message_PasteError")); return; } if (InternalClipboard.DataExists()) { /* * Let's check if copied datarow matches the column length of current table * */ int successfulRows = 0; foreach (var copiedRow in InternalClipboard.GetNext()) { /* * 1. Column count of both tables should be same * 2. Data types of columns for both tables should match */ bool column_ok = true; DataRow newRow = tbl.Table.NewRow(); if (tbl.Table.Columns.Count == copiedRow.Table.Columns.Count) { foreach (DataColumn cColumn in copiedRow.Table.Columns) { if (tbl.Table.Columns[cColumn.Ordinal].DataType != cColumn.DataType) { column_ok = false; break; } else { newRow[cColumn.Ordinal] = copiedRow[cColumn]; } } } else { column_ok = false; } if (column_ok) { successfulRows++; /* Create a new row in table */ /* Insert the row.*/ tbl.Table.Rows.Add(newRow); AddNewRowHighlight(view, newRow); } } /* Scroll to bottom */ view.FocusedRowHandle = view.RowCount - 1; view.TopRowIndex = view.RowCount - 1; if (successfulRows == InternalClipboard.GetSize()) { StaticReference.ShowInformation(this, string.Format(LanguageManager.Get("Message_NRowsAddSuccess"), successfulRows)); } else { StaticReference.ShowWarning(this, string.Format(LanguageManager.Get("Message_CopyError"), successfulRows, InternalClipboard.GetSize())); } } else { StaticReference.ShowWarning(this, LanguageManager.Get("Message_PasteNoRows")); } }
private void copyRowToolStripMenuItem_Click(object sender, EventArgs e) { if (tcMain.SelectedTabPageIndex == -1 || tcMain.SelectedTabPage == null) { StaticReference.ShowWarning(this, LanguageManager.Get("Message_NoFileOpen")); return; } string fileName = tcMain.SelectedTabPage.Tag as string; var tbl = StaticReference.GetTableByFullName(fileName); GridView view = GetViewFromSelectedTabPage(); if (view == null || tbl == null) { StaticReference.ShowWarning(this, LanguageManager.Get("Message_SelectPageFirst")); return; } // MessageBox.Show("ctrlc"); if (view.SelectedRowsCount == 0) { StaticReference.ShowWarning(this, LanguageManager.Get("Message_NoRowsSelected")); return; } List <DataRow> drList = new List <DataRow>(); for (int i = 0; i < view.SelectedRowsCount; i++) { drList.Add(tbl.Table.Rows[view.GetSelectedRows()[i]]); //view.GetSelectedRows().cl } /* Copy the content of selected rows to the internal clipboard. */ InternalClipboard.Copy(ref drList); view.ClearSelection(); StaticReference.ShowInformation(this, string.Format(LanguageManager.Get("Message_NRowsCopied"), InternalClipboard.GetSize())); }