c# winforms DataGridView - how to repeat content of selected cell or cells ?

Memento

How can I copy (repeat) selectedCellsValue - till end of row.
Number of cells (i.e. Columns) in a row - varies (about 30).
Excel have that option named - autoFill - Copy.
Here is my try:
int x = dgv.SelectedCells.Count;
foreach (DataGridViewCell c in dgv.CurrentRow.Cells)
{
if (c.Selected == true)
{
string a = c.Value.ToString();
x = x+1;
dgv.CurrentRow.Cells[x].Value = a;
But it copies selectedeCells only once.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Accepted answer
OK, see if the following will work.

I've assumed this is a continuation of your previous thread and so you won't want to copy the first row:

private void copy_Click(object sender, EventArgs e)
{
int count = dgv.Columns.Count;

foreach(DataGridViewRow row in dgv.Rows)
{
if (row.Index == 0) continue;
if (row.IsNewRow) break;
int start = -1, end = -1;
bool hasSelected = false;

for (int i = 0; i < count; i++)
{
if (dgv.Columns[i].HeaderText == "") break;
if (!hasSelected && row.Cells[i].Selected)
{
start = i;
hasSelected = true;
}
else if (hasSelected && !row.Cells[i].Selected)
{
end = i - 1;
break;
}
}

if (hasSelected)
{
int range = end - start + 1;

for (int i = start; i <= end; i++)
{
object value = row.Cells[i].Value;

for (int j = i + range; j < count; j += range)
{
if (dgv.Columns[j].HeaderText == "") break;
row.Cells[j].Value = value;
}
}
}
}
}
Memento14y ago
Ok, I understand.
VeryUsefulLargeProgrammingExcellentSupport :)
Vulpes14y ago
Although I don't always do so, I did test this code before posting and so was reasonably confident that there would be no syntax errors and that it would do what you wanted.

It not difficult to write once you're clear what's needed so I'm surprised that you haven't been able to get a satisfactory answer previously as there are plenty of decent coders on those sites.

One of my posting rules is that I don't do anything privately - I just don't have the time. Within reason, I'll do what I can to help on the forums but the best help of all is to learn to do it yourself - the more you practice, the better you'll get :)
Memento14y ago
Vulpes,
One big mistake:
Your avatar is inCorrect. You must take an EinsteinLike image.
In fact... - Who are you?
What is your DataSource, i.e. from which CosmicPoint you receive all these perfectly and punctually correct codeLines ?
Is that some book, or Guru or...

I was searching for solutions - about ten days (msdn forum, stackoverflow, codeproject...) - you could go there and see what all was answered.

Your code works without changing any point, any comma, any letter.

My FarGoal is to make a rather large application for my company, based on sql. We already have some, but, for years, we are not satisfied. When finished the application would be ready to offer - on a commercial basis. May I write you on a private mail ?
Memento14y ago
Excuse me, only one dgv - I corrected my post.
Yes, regardless how many cell are selected, they should be copied sequentially till end of row.
For example selection is: a b c d
After a buttonClick the rest of row should be: a b c d a b c d a b c d ... till end of row.
If I select only a b - then a b a b a b ... till end - and so on for every rows (if selected cells belongs to multiple rows).

Or, maybe, there is a shorter way to have an excelLike dgv in c# project. The same company produced both.
Vulpes14y ago
So have you got two DataGridViews here as I notice you have both dgv and dgvRasp?

Also what happens if more than one cell is selected in the same row - do you copy up to the next selection and so on until the end of the line?