[Winforms] Datagrid with cut and paste

[BrightSoul]

Hi,
can you advice me with some .NET component similar to a datagrind (with databinding support) that has cut and paste funcionality?

I need to copy data from MS Excel and paste it into my application.

...or a tutotial on how to tweak a common datagrid would do too.
thanks, bye

[Danial]

Originally posted by BrightSoul
Hi,
can you advice me with some .NET component similar to a datagrind (with databinding support) that has cut and paste funcionality?

I need to copy data from MS Excel and paste it into my application.

...or a tutotial on how to tweak a common datagrid would do too.
thanks, bye

Here is an simple example i put together, modify it to your need.

Place a Datagrid in you form and paste the following in Form Load and KeyDown event.

private void Form1_Load(object sender, System.EventArgs e)
{
	DataColumn dc;
	DataTable dt = new DataTable();

	dc = new DataColumn();
	dc.ColumnName="First Name";
	dt.Columns.Add(dc);

	dc = new DataColumn();
	dc.ColumnName = "Last Name";	
	dt.Columns.Add(dc);

	DataRow dr;

	dr = dt.NewRow();
	dr["First Name"]= "Joe";
	dr["Last Name"] = "Blogs";
	dt.Rows.Add(dr);

	dr = dt.NewRow();
	dr["First Name"]= "Robert";
	dr["Last Name"] = "Frisk";
	dt.Rows.Add(dr);

	this.dataGrid1.DataSource=dt;
}

private void dataGrid1_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
{
	if (e.Control && e.KeyCode== Keys.V)
	{
		DialogResult ret;

		ret = MessageBox.Show("Are you sure you want to Paste Data?", "", MessageBoxButtons.YesNoCancel);

		if (ret==DialogResult.Yes)
		{
			IDataObject data = Clipboard.GetDataObject();

			string strData;

			if (data.GetDataPresent(DataFormats.Text))
			{
				strData = data.GetData(DataFormats.Text).ToString();
				MessageBox.Show(strData);

				string [] row;
				string [] info;

				row = strData.Split('\n');


				foreach(string s in row)
				{
					info=s.Split('\t');

					DataRow dr;
					DataTable dt = new DataTable();

					dt = (DataTable)this.dataGrid1.DataSource;

					dr = dt.NewRow();
					dr[0]= info[0];
					dr[1]= info[1];

					dt.Rows.Add(dr);
				}
			}

		}
	}

}

[BrightSoul]

wow, much appreciated! this is just what I've been looking for. It also makes me understand how to handle different data types stored in the Clipboard, thanks.

One last question:
you are pasting data into new rows:

dr = dt.NewRow();
dr[0]= info[0];
dr[1]= info[1];

and while this is nice, I would also like to implement a feature that OVERWRITES the contents of the cells the user selected. i.e. I may want to start pasting from existent cell 2,3. If none are selected, than start pasting at 0,0 OR insert data as new rows.

How do I get the cell selection boundaries from a datagrid? I just need 4 numbers: start from cell 0,1; end to cell 2,3.

I just need a guideline, then I can help myself using a classbrowser. Thanks again

[Danial]

This will over write the data in selected cell.

private void button1_Click(object sender, System.EventArgs e)
{
	DataTable dt = new DataTable();

	dt=(DataTable)this.dataGrid1.DataSource;

	int c;
	int r;
	r = this.dataGrid1.CurrentCell.RowNumber;
	c = this.dataGrid1.CurrentCell.ColumnNumber;
			
	dt.Rows[r][c]="Hi ";

}