Advertisement
Guest User

Untitled

a guest
Jul 7th, 2014
247
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 3.97 KB | None | 0 0
  1. Sub CSVR()
  2.        
  3.         Dim tbl_csv As New DataTable
  4.         Dim data() As String
  5.         Dim separator As String = ","
  6.  
  7.         cmb_clmn.Items.Clear()
  8.         For i = 0 To DataGridView1.Columns.Count - 1
  9.             If DataGridView1.Columns(i).HeaderText.Contains("Lastseen") Then
  10.                 tbl_csv.Columns.Add(DataGridView1.Columns.Item(i).HeaderText, GetType(Date))
  11.             Else
  12.                 tbl_csv.Columns.Add(DataGridView1.Columns.Item(i).HeaderText)
  13.             End If
  14.             'tbl_csv.Columns(i).Caption = DataGridView1.Columns.Item(i).HeaderText
  15.             cmb_clmn.Items.Add(DataGridView1.Columns.Item(i).HeaderText)
  16.         Next
  17.  
  18.         Try
  19.             Using csv As New IO.StreamReader(lbl_pth.Text)
  20.                 Do While csv.EndOfStream = False
  21.                     data = Split(csv.ReadLine(), separator)
  22.                     tbl_csv.Rows.Add(data)
  23.                 Loop
  24.             End Using
  25.  
  26.             DataGridView1.Columns("Lastseen").DefaultCellStyle.Format = "d"
  27.             'tbl_csv.Columns("Lastseen").DateTimeMode = DataSetDateTime.UnspecifiedLocal
  28.             'tbl_csv.Columns("Lastseen").DataType = GetType(DateTime)
  29.             'tbl_csv.Columns.Item("Lastseen") = DateTime.Parse(tbl_csv.Columns.Item("Lastseen"))
  30.             DataGridView1.DataSource = Nothing
  31.             DataGridView1.Columns.Clear()
  32.             DataGridView1.DataSource = tbl_csv
  33.  
  34.             For i As Integer = 0 To tbl_csv.Columns.Count - 1
  35.                ' DataGridView1.Columns.Item(i).Visible = False
  36.                 'DataGridView1.Columns.Item(i).ReadOnly = True
  37.                 'DataGridView1.Columns.Item(i).SortMode = DataGridViewColumnSortMode.Automatic
  38.             Next
  39.        Catch ex As Exception
  40.             '///////////////////////////////////////////////
  41.             MsgBox(ex.Message, MsgBoxStyle.Critical, "erR0r in CSVR")
  42.         End Try
  43.     End Sub
  44.  
  45.     Public Shared Function DatTime(ByVal txtDate As String)
  46.         Dim tempDate As DateTime
  47.         DateTime.TryParseExact(txtDate, "dd/MM/yyyy", System.Globalization.CultureInfo.CurrentCulture, Globalization.DateTimeStyles.None, tempDate)
  48.         Return tempDate
  49.     End Function
  50.  
  51.     Public Function RemoveDuplicateRows(ByVal dTable As DataTable, ByVal colName As String) 'As DataTable
  52.         ' On Error Resume .
  53.         Dim dict As New Dictionary(Of String, DataRow)
  54.         Dim dtb As New DataTable
  55.  
  56.         For Each dtRow As DataRow In dTable.Rows
  57.             Dim key As String = dtRow("PublishingPoint") + "," + dtRow("Username") + "," + dtRow("IP") + "," + dtRow("Status") + "," + dtRow("Req URL") '+ ","  + dtRow("Last seen")
  58.             Dim dictRow As DataRow = Nothing
  59.             If dict.TryGetValue(key, dictRow) Then
  60.                 'check and update date
  61.                 'you can skip this part, if your data is sorted
  62.                 If DatTime(dtRow(colName)) > DatTime(dictRow(colName)) Then
  63.                     dictRow(colName) = DatTime(dtRow(colName))
  64.  
  65.                 End If
  66.             Else
  67.                 dict.Add(key, dictRow)
  68.             End If
  69.         Next
  70.  
  71.         Return dict.Values.ToArray()
  72.  
  73.     End Function
  74.  
  75.  Private Sub chb_remdup_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles chb_remdup.CheckedChanged
  76.        
  77.         DataGridView1.DataSource = RemoveDuplicateRows(DataGridView1.DataSource, "Lastseen")
  78.        
  79.     End Sub
  80.  
  81.  
  82.  
  83.  
  84.  
  85.  
  86. My *.csv Content:
  87.  
  88. -,AST-VM2003\Administrator,192.168.137.221,2,file:--C:\WMPub\WMRoot\industrial.wmv,10-10-2014
  89. -,AST-VM2003\Administrator,192.168.137.221,2,file:--C:\WMPub\WMRoot\industrial.wmv,11-10-2014
  90. -,AST-VM2003\Administrator,192.168.137.221,2,file:--C:\WMPub\WMRoot\industrial.wmv,12-30-2014
  91. -,AST-VM2003\Administrator,192.168.137.222,2,file:--C:\WMPub\WMRoot\industrial.wmv,12-10-2014
  92. -,AST-VM2003\Administrator,192.168.137.222,2,file:--C:\WMPub\WMRoot\industrial.wmv,12-11-2014
  93. -,AST-VM2003\Administrator,192.168.137.222,2,file:--C:\WMPub\WMRoot\industrial.wmv,12-12-2014
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement