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

Question

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.

Vulpes · 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 { 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 { object value = row.Cells[i].Value; for (int j = i + range; j { if (dgv.Columns[j].HeaderText == ) break; row.Cells[j].Value = value; } } } } }

Memento · Answer

Ok I understand. V ery U seful L arge P rogramming E xcellent S upport :)

Vulpes · Answer

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 :)

Memento · Answer

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 ?

Memento · Answer

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.

Vulpes · Answer

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?