Datagridview

Question

Hi All first of all thanks for the time you are putting in reading this. i need assistance in the following. i have a datagridview in which is being filled from a database. what i want to do is the following: check a specific cell in a row and compare it to the previous one. in case they are the same do one thing in case they are different do another one. for example: the datagridview has a column name long lat. Row Name Long Lat 1 AZ1 55.555522 55.555522 2 AZ1 55.555533 55.555533 3 AZ1 55.555544 55.555544 4 AZ1 55.555555 55.555555 5 AZ2 55.555522 55.555522 6 AZ2 55.555533 55.555533 7 AZ2 55.555544 55.555544 8 AZ2 55.555555 55.555555 and so on. what i want to do the following: if row[2].cell[name] = row[1].cell[name] { do XXXXXXXXXXXXXXXXX } else { do yyyyyyyyyyyyyyyyyyyyy } hope i am clear. once again. thanks

Hemant Srivastava · Answer

It looks like you need to keep on collecting all the Lat Long pairs for a name (say AZ1) from the DataGrid until you get another different name (say AZ2) If this is the case then you may try following: class LatLongPair { public double Lat { get; set; } public double Lon { get; set; } } private void button4_Click(object sender EventArgs e) { Dictionary > LatLongCollectionByName = new Dictionary >(); List lst = null; LatLongPair lPair = null; string matchHandle = string.Empty; for (int i = 0; i { if (dataGridView2.Rows[i].Cells[0].Value.ToString() == matchHandle) { lPair.Lat = Convert.ToDouble(dataGridView2.Rows[i].Cells[1].Value); lPair.Lon = Convert.ToDouble(dataGridView2.Rows[i].Cells[2].Value); lst.Add(lPair); } else { matchHandle = dataGridView2.Rows[i].Cells[0].Value.ToString(); lPair = new LatLongPair(); lPair.Lat = Convert.ToDouble(dataGridView2.Rows[i].Cells[1].Value); lPair.Lon = Convert.ToDouble(dataGridView2.Rows[i].Cells[2].Value); lst = new List (); lst.Add(lPair); LatLongCollectionByName.Add(matchHandle lst); } } foreach (KeyValuePair > item in LatLongCollectionByName) { Console.WriteLine(
 For name : + item.Key +  lat/long vaues are:
 ); foreach (LatLongPair lp in item.Value) { Console.Write(	+ lp.Lat + 	 + lp.Lon + | ); } } }

j k · Answer

Hi the purpose of this application is to eventually create an KML (google earth) file with specific coordinates take from the sql server. as i mentioned above the query i created eventually will give me this Row Name Long Lat 1 AZ1 55.555522 55.555522 2 AZ1 55.555533 55.555533 3 AZ1 55.555544 55.555544 4 AZ1 55.555555 55.555555 5 AZ2 55.555522 55.555522 6 AZ2 55.555533 55.555533 7 AZ2 55.555544 55.555544 8 AZ2 55.555555 55.555555 i want the application to create a kml file for each name with the relevant coordinates. the kml file should look like this AZ1 #m_ylw-pushpin 1 55.555522 55.5555220 55.555533 55.5555330 55.555544 55.5555440 55.555555 55.5555550 i can not do it via the database. thanks

Suthish Nair · Answer

Why can't just do this comparison at SQL level instead of code behind? Check the collection it having same key or duplicate key.

j k · Answer

Hi Mate sorry for the long long reply i didnt have time to continue working on this. [code] class LatLongPair { public double Lat { get; set; } public double Lon { get; set; } } private void button4_Click(object sender EventArgs e) { Dictionary > LatLongCollectionByName = new Dictionary >(); List lst = null; LatLongPair lPair = null; string matchHandle = string.Empty; for (int i = 0; i { if (dataGridView2.Rows[i].Cells[0].Value.ToString() == matchHandle) { lPair.Lat = Convert.ToDouble(dataGridView2.Rows[i].Cells[1].Value); lPair.Lon = Convert.ToDouble(dataGridView2.Rows[i].Cells[2].Value); lst.Add(lPair); } else { matchHandle = dataGridView2.Rows[i].Cells[0].Value.ToString(); lPair = new LatLongPair(); lPair.Lat = Convert.ToDouble(dataGridView2.Rows[i].Cells[1].Value); lPair.Lon = Convert.ToDouble(dataGridView2.Rows[i].Cells[2].Value); lst = new List (); lst.Add(lPair); LatLongCollectionByName.Add(matchHandle lst); } } foreach (KeyValuePair > item in LatLongCollectionByName) { Console.WriteLine(
 For name : + item.Key +  lat/long vaues are:
 ); foreach (LatLongPair lp in item.Value) { Console.Write(	+ lp.Lat + 	 + lp.Lon + | ); } } } [/code] i have added the below code and i get the following error LatLongCollectionByName.Add(matchHandle lst); An item with the same key has already been added. any idea what i am doing wrong. thanks

j k · Answer

Hi thanks for the prompt reply. the google file is not related to the problem or to the request as i know how to do it. the solution you gave me is great but i believe i might have explained my request wrong. as i stated in my previous thread is what i need. your help is much appriciated. in case you still think that i need to close this thread and open a new one i will be more than glad. thanks

Hemant Srivastava · Answer

Hi Jonathan If you problem in this thread is resolved please close it by marking it accepted answer and ask your another question (i.e. creating a kml (google) file ) in a new seperate thread so that everybody could easily identify your problem by the title and resolve your problem. Thanks

j k · Answer

Thanks Hemant i need another solution. what i am trying to do is to create a kml (google) file. i have all the correct structure and i know how to create a placemark. what i need now is to create a polygon. the golygon structure is as following: [code] Untitled Polygon #m_ylw-pushpin 1 -99.4569637259620337.321893771036840 -99.4973605369902937.271142529298380 -99.534083679939237.18440408914040 -99.5467093678366637.159484564780020 -99.504617633882537.041423735605550 -99.4350241622085836.949156190820430 -99.412908966093136.878077363216750 -99.4093574840994936.842072922153850 -99.3573461207182936.772795232642490 -99.2156248118870836.708863140830750 -99.0441624817421236.646481901588640 -98.8933919535774436.64306656979140 -98.6987538978819236.653969025831920 -98.5660565058336636.685376998098530 -98.4653272210374336.739107875299990 -98.356479579272936.877573297115070 -98.3668458229264636.997804649264640 -98.4460419955101937.211006057726160 -98.9285330055945637.510105273667830 -99.4569637259620337.321893771036840 [/code] since my kml file is getting the data from a datagrid view and contains the below data: [code] Row Name Long Lat 1 AZ1 55.555522 55.555522 2 AZ1 55.555533 55.555533 3 AZ1 55.555544 55.555544 4 AZ1 55.555555 55.555555 5 AZ2 55.555522 55.555522 6 AZ2 55.555533 55.555533 7 AZ2 55.555544 55.555544 8 AZ2 55.555555 55.555555 [/code] what i need is eventruall that for each name if will add just the points. for example [code] AZ1 #m_ylw-pushpin 1 55.555522 55.5555220 55.555533 55.5555330 55.555544 55.5555440 55.555555 55.5555550 [/code] thanks

Hemant Srivastava · Answer

Instead of putting Cell[0] you may put coulmn name... like Cell[Lat]

Hemant Srivastava · Answer

Try this one: for(int i=1;i { if (dataGridView1.Rows[i].Cells[0].Value.ToString() == dataGridView1.Rows[i-1].Cells[0].Value.ToString()) { // DO XXXXXXXXXXX } else { // DO YYYYYYYYYY } }