[handsup]

I have some questions about dataGridView control

A- How can I paste from clipboard to datagridview
B- How can I copy selected row to clipboard
C- How can I remove rows which not starts with "http://"
D- How can I remove dupliate rows

I had 10 problems like that, I figured out 6 of them.
I did much research about these 4 issues, but I can't find any useful information.
Finally I realized that; dataGridView is the most hard to use control in C# visual studio.

Help me please. I really need help urgently. Thanks.

[modi123_1]

Well... what have you tried, or reasoning for how to do each of those?

[Skydiver]

If have had tried to create simple DataGridView, you would have discovered that A and B are built into the DataGridView control and work right out of the box.

But then, I could also be lying to you. You'll need to put together some code to find out.

As for filtering the rows for particular data and duplicates. The DataGridView will display whatever you give it in the DataSource property. It's up to you what that data will be.

[CasiOo]

For D you should take a look at the HashSet class

[Skydiver]

CasiOo, on 09 August 2012 - 01:57 PM, said:

For D you should take a look at the HashSet class

Good suggestion! Unfortunately, the class doesn't implement IList, IListSource, IBindingList, IBindingListView or any other interface that the DataGridView's DataSource needs to display data.

We're not completely hosed, though, one could easily create a class that implements an IListSource and that contains a HashSet. (And no, setting DataSource = hashSet.ToList() is not a solution unless the DataGridView is set to be read only.)

[CasiOo]

Why would you not consider DataSource = hashSet.ToList() a solution?

Edit: Oh now I see

This post has been edited by CasiOo: 09 August 2012 - 03:08 PM

[handsup]

I can't understand you all really is there no specific code to do this?

I tried some codes like this:

          List<string> list = new List<string>();
            for (int i = 0; i < dataGridView1.Rows.Count; i++ )
            {
                string str = dataGridView1.Rows[i].Cells[0].Value.ToString();
                if (!list.Contains(str))
                    list.Add(dataGridView1.Rows[i].Cells[0].Value.ToString());
                else
                {
                    dataGridView1.Rows.Remove(dataGridView1.Rows[i]);
                }

            }

but it didnt work

This post has been edited by JackOfAllTrades: 14 August 2012 - 04:48 PM
Reason for edit:: Added code tags

[Skydiver]

What was not working? Did you step through your code and see the Remove() calls happening?

[handsup]

Hi...

My new method to paste from clipboard to datagridview is:

                StreamWriter sw = new StreamWriter(@"Config/paste");
                string t = Clipboard.GetText();
                sw.Write(t);
                sw.Close();
                StreamReader sr = new StreamReader(@"Config/paste");
                dataGridView1.Rows.Clear();
                while (sr.Peek() >= 0)
                {
                    DataGridViewRow row = dataGridView1.Rows[dataGridView1.Rows.Add()];
                    row.Cells["Column1"].Value = sr.ReadLine();
                }
                sr.Close();
                File.Delete(@"Config/paste");

It works great and TOOO fast for me. But I wonder that what do you guys think of my new method? Is this a good method? Thanks

[Skydiver]

Is that intentional that paste will destroy the current data and start adding rows and putting all the data into the first column? What if the original selected text that was put into the clipboard was multiple columns and didn't start at the top left corner of the grid?

[handsup]

don't worry it is intentional.

[handsup]

hey guys I still cant remove duplicate rows from datagridview give me some codes to do this please

[handsup]

I solved remove duplicates problem now man. it was very easy too..

[Skydiver]

Good for you! Did you stick with your use of the List or did you choose something else?

[handsup]

I used list control for that!
List<string> list = new List<string>();