'DataGridView'에 해당하는 글 2건

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

020. Prigraming/01. C# 2012. 6. 4. 18:57

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

     

    저작자표시

    '020. Prigraming > 01. C#' 카테고리의 다른 글

    [C#] DataGridView Row 이동처리  (0) 2012.09.05
    [C#] XML 간편접근  (0) 2012.07.09
    [C#] DataGridView - Related Contents  (0) 2012.06.04
    [C#] Dataset 데이터 내부 데이터 삭제할 경우(추가)  (0) 2012.05.08
    [C#] 쓰레드 사용시 Invoke 처리  (0) 2012.05.03
    WRITTEN BY
    테네시왈츠
    항상 겸손하게 항상 새롭게 항상 진실하게
    ,

    알아두면 피가되고 살이되는 유용한 사이트

    999. Etc 2011. 5. 18. 09:44

    1. 윈도우7 XP 모드 설치하기
    http://pupple.net/130083595056

    2. MS-SQL 2008 설치
    http://blog.naver.com/withyou_ai?Redirect=Log&logNo=120126288830

    3. Sql Developer 에서 MS-SQL 사용하기
    http://blog.naver.com/jeto99?Redirect=Log&logNo=60062317106

    4. 오라클 설치시 javaw.exe 문제로 설치안될때
    http://uiandwe.tistory.com/338

    5. 윈도우 7에 Visual Studio 2005 SP1 설치 후 추가 업데이트
    http://www.microsoft.com/downloads/ko-kr/details.aspx?displaylang=ko&FamilyID=90e2942d-3ad1-4873-a2ee-4acc0aace5b6

    >> 개발관련
    6. DataGridView 활용 Tip
    http://monsterwave.tistory.com/21

    7. MSSQL Linked Server
    http://blog.naver.com/lovzip?Redirect=Log&logNo=20056016860

    8. SqlHelper Transaction
    http://cafe.naver.com/jquerymytour.cafe?iframe_url=/ArticleRead.nhn%3Farticleid=36&

    저작자표시

    '999. Etc' 카테고리의 다른 글

    HTML5에 대해 공부할 수 있는 좋은 사이트  (0) 2011.11.23
    나의 정체성은 무엇인가?  (0) 2011.08.09
    [영화] 조금만 더 가까이. 2010  (0) 2010.12.28
    2010's Happy Christmas!!!  (0) 2010.12.25
    cmd창 영문&한글 설정방법  (0) 2010.12.09
    WRITTEN BY
    테네시왈츠
    항상 겸손하게 항상 새롭게 항상 진실하게
    ,