[C#] dataGridView 내부에서 copy&paste 기능

dataGridView 만지작 거리면서 내부적으로 copy & paste가 안되는것을 보고 바로 구글링에 들어갔다.

다행히 착한 소스가 보여 바로 들고왔다.

 

디자인은 대략이렇고 구성돼 있고

 

 

소스는 아래와 같다.

 

 

 

1. using System;
2. using System.Collections.Generic;
3. using System.ComponentModel;
4. using System.Data;
5. using System.Drawing;
6. using System.Linq;
7. using System.Text;
8. using System.Windows.Forms;
10. namespace CopyPasteInGrid
11. {
12. public partial class Form1 : Form
13. {
14. public Form1()
15. {
16. InitializeComponent();
17. PopulateDataGridView();
18. }
20. public void PopulateDataGridView()
21. {
22. dataGridView1.ColumnCount = 6;
24. dataGridView1.Columns[0].Name = "C0";
25. dataGridView1.Columns[1].Name = "C1";
26. dataGridView1.Columns[2].Name = "C2";
27. dataGridView1.Columns[3].Name = "C3";
28. dataGridView1.Columns[4].Name = "C4";
29. dataGridView1.Columns[5].Name = "C5";
31. dataGridView1.Columns[0].HeaderText = "C0";
32. dataGridView1.Columns[1].HeaderText = "C1";
33. dataGridView1.Columns[2].HeaderText = "C2";
34. dataGridView1.Columns[3].HeaderText = "C3";
35. dataGridView1.Columns[4].HeaderText = "C4";
36. dataGridView1.Columns[5].HeaderText = "C5";
38. dataGridView1.Columns[0].Width = 40;
39. dataGridView1.Columns[1].Width = 40;
40. dataGridView1.Columns[2].Width = 40;
41. dataGridView1.Columns[3].Width = 40;
42. dataGridView1.Columns[4].Width = 40;
43. dataGridView1.Columns[5].Width = 40;
45. dataGridView1.Rows.Add(new string[] { "A1", "B1", "C1", "D1", "E1", "F1" });
46. dataGridView1.Rows.Add(new string[] { "A2", "B2", "C2", "D2", "E2", "F2" });
47. dataGridView1.Rows.Add(new string[] { "A3", "B3", "C3", "D3", "E3", "F3" });
48. dataGridView1.Rows.Add(new string[] { "A4", "B4", "C4", "D4", "E4", "F4" });
49. dataGridView1.Rows.Add(new string[] { "A5", "B5", "C5", "D5", "E5", "F5" });
50. dataGridView1.Rows.Add(new string[] { "A6", "B6", "C6", "D6", "E6", "F6" });
51. dataGridView1.Rows.Add(new string[] { "A7", "B7", "C7", "D7", "E7", "F7" });
53. dataGridView1.AutoResizeColumns();
54. }
56. private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
57. {
58. if (dataGridView1.SelectedCells.Count > 0)
59. dataGridView1.ContextMenuStrip = contextMenuStrip1;
60. }
62. private void cutToolStripMenuItem_Click(object sender, EventArgs e)
63. {
64. //Copy to clipboard
65. CopyToClipboard();
67. //Clear selected cells
68. foreach (DataGridViewCell dgvCell in dataGridView1.SelectedCells)
69. dgvCell.Value = string.Empty;
70. }
72. private void copyToolStripMenuItem_Click(object sender, EventArgs e)
73. {
74. CopyToClipboard();
75. }
77. private void pasteToolStripMenuItem_Click(object sender, EventArgs e)
78. {
79. //Perform paste Operation
80. PasteClipboardValue();
81. }
83. private void dataGridView1_KeyDown(object sender, KeyEventArgs e)
84. {
85. try
86. {
87. if (e.Modifiers == Keys.Control)
88. {
89. switch (e.KeyCode)
90. {
91. case Keys.C:
92. CopyToClipboard();
93. break;
95. case Keys.V:
96. PasteClipboardValue();
97. break;
98. }
99. }
100. }
101. catch (Exception ex)
102. {
103. MessageBox.Show("Copy/paste operation failed. "+ex.Message, "Copy/Paste", MessageBoxButtons.OK, MessageBoxIcon.Warning);
104. }
105. }
107. private void CopyToClipboard()
108. {
109. //Copy to clipboard
110. DataObject dataObj = dataGridView1.GetClipboardContent();
111. if (dataObj != null)
112. Clipboard.SetDataObject(dataObj);
113. }
115. private void PasteClipboardValue()
116. {
117. //Show Error if no cell is selected
118. if (dataGridView1.SelectedCells.Count == 0)
119. {
120. MessageBox.Show("Please select a cell", "Paste", MessageBoxButtons.OK, MessageBoxIcon.Warning);
121. return;
122. }
124. //Get the satring Cell
125. DataGridViewCell startCell = GetStartCell(dataGridView1);
126. //Get the clipboard value in a dictionary
127. Dictionary<int, Dictionary<int, string>> cbValue = ClipBoardValues(Clipboard.GetText());
129. int iRowIndex = startCell.RowIndex;
130. foreach (int rowKey in cbValue.Keys)
131. {
132. int iColIndex = startCell.ColumnIndex;
133. foreach (int cellKey in cbValue[rowKey].Keys)
134. {
135. //Check if the index is with in the limit
136. if (iColIndex <= dataGridView1.Columns.Count - 1 && iRowIndex <= dataGridView1.Rows.Count - 1)
137. {
138. DataGridViewCell cell = dataGridView1[iColIndex, iRowIndex];
140. //Copy to selected cells if 'chkPasteToSelectedCells' is checked
141. if ((chkPasteToSelectedCells.Checked && cell.Selected) ||
142. (!chkPasteToSelectedCells.Checked))
143. cell.Value = cbValue[rowKey][cellKey];
144. }
145. iColIndex++;
146. }
147. iRowIndex++;
148. }
149. }
151. private DataGridViewCell GetStartCell(DataGridView dgView)
152. {
153. //get the smallest row,column index
154. if (dgView.SelectedCells.Count == 0)
155. return null;
157. int rowIndex = dgView.Rows.Count - 1;
158. int colIndex = dgView.Columns.Count - 1;
160. foreach (DataGridViewCell dgvCell in dgView.SelectedCells)
161. {
162. if (dgvCell.RowIndex < rowIndex)
163. rowIndex = dgvCell.RowIndex;
164. if (dgvCell.ColumnIndex < colIndex)
165. colIndex = dgvCell.ColumnIndex;
166. }
168. return dgView[colIndex, rowIndex];
169. }
171. private Dictionary<int, Dictionary<int, string>> ClipBoardValues(string clipboardValue)
172. {
173. Dictionary<int, Dictionary<int, string>> copyValues = new Dictionary<int, Dictionary<int, string>>();
175. String[] lines = clipboardValue.Split('\n');
177. for (int i = 0; i <= lines.Length - 1; i++)
178. {
179. copyValues[i] = new Dictionary<int, string>();
180. String[] lineContent = lines[i].Split('\t');
182. //if an empty cell value copied, then set the dictionay with an empty string
183. //else Set value to dictionary
184. if (lineContent.Length == 0)
185. copyValues[i][0] = string.Empty;
186. else
187. {
188. for (int j = 0; j <= lineContent.Length - 1; j++)
189. copyValues[i][j] = lineContent[j];
190. }
191. }
192. return copyValues;
193. }
194. }
195. }

 

 

 

 

[출처] http://www.codeproject.com/Articles/208281/Copy-Paste-in-Datagridview-Control?rp=/KB/TipsnTricks/CopyPasteInDatagridview/SourceCode.zip

 

 

- 솔루션 소스 파일 첨부 -

 

CopyPasteInGrid.zip