How can I get diffrence time of 2 ip address?

Question

Hi all I have a table with 3 column(source ipaddress destination ipaddress start time) which every source ipaddress assign many record of every destination like below. source ip destination ip stime 0.0.0.2 0.0.0.4 5 0.0.0.1 0.0.0.3 4 0.0.0.2 0.0.0.4 7 0.0.0.2 0.0.0.4 10 0.0.0.2 0.0.0.3 4 I want to get diffrence of stime between 2 ip addresses like 0.0.0.2 and 0.0.0.4. I must compute diffrence stime of first and second record of these ip adresses like : (7-5) and second record with third (10-7). Let me know how can I do? I should do for every source ip address with destination ip addresses.

Vulpes · Answer

OK try this revised version of the program. The data is of course just for testing: using System; using System.Data; using System.Linq; using System.IO; class Program { static void Main() { DataTable dt = new DataTable(); dt.Columns.Add(source ip); dt.Columns.Add(destination ip); dt.Columns.Add(stime typeof(int)); dt.Rows.Add(0.0.0.2 0.0.0.4 5); dt.Rows.Add(0.0.0.1 0.0.0.3 4); dt.Rows.Add(0.0.0.2 0.0.0.4 7); dt.Rows.Add(0.0.0.2 0.0.0.4 10); dt.Rows.Add(0.0.0.2 0.0.0.3 4); dt.Rows.Add(0.0.0.2 0.0.0.3 9); dt.Rows.Add(0.0.0.2 0.0.0.3 11); var query = from DataRow dr in dt.Rows let source = dr[source ip].ToString() let dest = dr[destination ip].ToString() group dr by new {source dest} into g select g; using (StreamWriter sw = new StreamWriter(diamond.txt)) { foreach(var g in query) { if(g.Count() > 1) { sw.Write(String.Format({0-15} {1-15}  g.Key.source g.Key.dest)); int time1 = Convert.ToInt32(g.ElementAt(0)[stime]); int time2; for(int i = 1; i { time2 = Convert.ToInt32(g.ElementAt(i)[stime]); if (i > 1) sw.Write(new string(' ' 34)); sw.WriteLine(String.Format({0} time2 - time1)); time1 = time2; } } } } } } The file should contain the following: 0.0.0.2 0.0.0.4 2 3 0.0.0.2 0.0.0.3 5 2

diamond diamond · Answer

Thankssss Vulpes. you are same as an angel

diamond diamond · Answer

Hi Vulpes I want save in an txt file like below: source ip destination ip difference 0.0.0.2 0.0.0.4 2 5 0.0.0.2 0.0.0.30 10 5 6  .... I need urgently if you have an idea please share with me. Thanks

Vulpes · Answer

Can you give me an example of how you'd like the output file to look.

diamond diamond · Answer

Thanks Vulpes I should say that my data is very large and the above data is an example. I want similar records of 2 ip addresses get save in lists then automatic is computed difference of stimes and save in txt file for all ip addresses. for example records of 2 ip adresses are 12 records and I have compute their difference stimes Thanks in advance

diamond diamond · Answer

Thanks so much Vulpes every time I 'm in trouble you help me. Let me test it and if I had a question I ask you. Thankssss again

Vulpes · Answer

It sounds like you need to group the records by source and destination ip maintaining the same order as you do so. You can then work out the time differences between successive records. Here's some sample code: using System; using System.Data; using System.Linq; class Program { static void Main() { DataTable dt = new DataTable(); dt.Columns.Add(source ip); dt.Columns.Add(destination ip); dt.Columns.Add(stime typeof(int)); dt.Rows.Add(0.0.0.2 0.0.0.4 5); dt.Rows.Add(0.0.0.1 0.0.0.3 4); dt.Rows.Add(0.0.0.2 0.0.0.4 7); dt.Rows.Add(0.0.0.2 0.0.0.4 10); dt.Rows.Add(0.0.0.2 0.0.0.3 4); var query = from DataRow dr in dt.Rows let source = dr[source ip].ToString() let dest = dr[destination ip].ToString() group dr by new {source dest} into g select g; foreach(var g in query) { Console.WriteLine(g.Key); if (g.Count() == 1) { Console.WriteLine(Only one record in this group); } else { int time1 = Convert.ToInt32(g.ElementAt(0)[stime]); int time2; for(int i = 1; i { time2 = Convert.ToInt32(g.ElementAt(i)[stime]); Console.WriteLine({0} - {1} = {2} time2 time1 time2 - time1); time1 = time2; } } Console.WriteLine(); } Console.ReadKey(); } } The output is: { source = 0.0.0.2 dest = 0.0.0.4 } 7 - 5 = 2 10 - 7 = 3 { source = 0.0.0.1 dest = 0.0.0.3 } Only one record in this group { source = 0.0.0.2 dest = 0.0.0.3 } Only one record in this group

diamond diamond · Answer

Thanks yes I use datatable but I have duplicate source ipaddress and destination ip addresses. if I want to sort I should choose all rows of one source ip address with one destination ip address. I think with sort it gets difficult.

Dhirendra Misra · Answer

Hello Diamond I think you you would be getting the result at datatable or DataSet. If so you can make use of dataview and get sorted resultset then use foreach to traver each record and then calculate the difference. Details on dataview can be found here: http://www.dotnetperls.com/dataview Hope it will help you.