martes, 27 de agosto de 2019
Extraer datos array
Dim dte() As String = array.Skip(2).ToArray
validar nombres de los nodos xml
Dim child As XmlElement = xml.CreateElement(XmlConvert.EncodeName(data(0)))
Etiquetas:
EncodeName,
xml,
XmlConvert
Buscar elementos repetidos en una columna
Dim query1 = (From i As DataGridViewRow In dg_captura.Rows Select i.Cells(0)).ToList()
Dim query2 = query1.GroupBy(Function(x) x.Value).Where(Function(g) g.Count > 1).Select(Function(y) y.Key).ToList()
fuente
Dim query2 = query1.GroupBy(Function(x) x.Value).Where(Function(g) g.Count > 1).Select(Function(y) y.Key).ToList()
fuente
obtener los valores de la columna datagrid
Dim query1 = (From i As DataGridViewRow In dg_captura.Rows Select i.Cells(0)).ToList()
Busca elemento repetido en una columna especifica
Dim query2 = query1.GroupBy(Function(x) x.Value).Where(Function(g) g.Count > 1).Select(Function(y) y.Key).ToList()
Busca elemento repetido en una columna especifica
Dim query2 = query1.GroupBy(Function(x) x.Value).Where(Function(g) g.Count > 1).Select(Function(y) y.Key).ToList()
Etiquetas:
DataGridView,
From,
Repetido
viernes, 23 de agosto de 2019
actualizar grid
Private Sub DataGridView1_CurrentCellDirtyStateChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DgvTareas.CurrentCellDirtyStateChanged
If DataGridView1.IsCurrentCellDirty Then
DataGridview1.CommitEdit(DataGridViewDataErrorContexts.Commit)
End If
End Sub
If DataGridView1.IsCurrentCellDirty Then
DataGridview1.CommitEdit(DataGridViewDataErrorContexts.Commit)
End If
End Sub
encriptar desencriptar
Public hash As String = "@H45H@"
Public Function encriptar(ByVal str As String) As String
Dim data As Byte() = UTF8Encoding.UTF8.GetBytes(str)
Dim transform As ICryptoTransform
Dim results As Byte()
Dim keys As Byte()
Using md5 As MD5CryptoServiceProvider = New MD5CryptoServiceProvider
keys = md5.ComputeHash(UTF8Encoding.UTF8.GetBytes(hash))
Using tripDes As TripleDESCryptoServiceProvider = New TripleDESCryptoServiceProvider
tripDes.Key = keys
tripDes.Mode = CipherMode.ECB
tripDes.Padding = PaddingMode.PKCS7
transform = tripDes.CreateEncryptor
results = transform.TransformFinalBlock(data, 0, data.Length)
Return Convert.ToBase64String(results, 0, results.Length)
End Using
End Using
End Function
' Using tripDes As TripleDESCryptoServiceProvider = New TripleDESCryptoServiceProvider With {.Key = keys, .Mode = CipherMode.ECB, .Padding = PaddingMode.PKCS7}
Public Function desencriptar(ByVal str As String) As String
Dim data As Byte() = Convert.FromBase64String(str)
Dim transform As ICryptoTransform
Dim results As Byte()
Dim keys As Byte()
Using md5 As MD5CryptoServiceProvider = New MD5CryptoServiceProvider
keys = md5.ComputeHash(UTF8Encoding.UTF8.GetBytes(hash))
Using tripDes As TripleDESCryptoServiceProvider = New TripleDESCryptoServiceProvider
tripDes.Key = keys
tripDes.Mode = CipherMode.ECB
tripDes.Padding = PaddingMode.PKCS7
transform = tripDes.CreateDecryptor
results = transform.TransformFinalBlock(data, 0, data.Length)
Return UTF8Encoding.UTF8.GetString(results)
End Using
End Using
End Function
fuente
Public Function encriptar(ByVal str As String) As String
Dim data As Byte() = UTF8Encoding.UTF8.GetBytes(str)
Dim transform As ICryptoTransform
Dim results As Byte()
Dim keys As Byte()
Using md5 As MD5CryptoServiceProvider = New MD5CryptoServiceProvider
keys = md5.ComputeHash(UTF8Encoding.UTF8.GetBytes(hash))
Using tripDes As TripleDESCryptoServiceProvider = New TripleDESCryptoServiceProvider
tripDes.Key = keys
tripDes.Mode = CipherMode.ECB
tripDes.Padding = PaddingMode.PKCS7
transform = tripDes.CreateEncryptor
results = transform.TransformFinalBlock(data, 0, data.Length)
Return Convert.ToBase64String(results, 0, results.Length)
End Using
End Using
End Function
' Using tripDes As TripleDESCryptoServiceProvider = New TripleDESCryptoServiceProvider With {.Key = keys, .Mode = CipherMode.ECB, .Padding = PaddingMode.PKCS7}
Public Function desencriptar(ByVal str As String) As String
Dim data As Byte() = Convert.FromBase64String(str)
Dim transform As ICryptoTransform
Dim results As Byte()
Dim keys As Byte()
Using md5 As MD5CryptoServiceProvider = New MD5CryptoServiceProvider
keys = md5.ComputeHash(UTF8Encoding.UTF8.GetBytes(hash))
Using tripDes As TripleDESCryptoServiceProvider = New TripleDESCryptoServiceProvider
tripDes.Key = keys
tripDes.Mode = CipherMode.ECB
tripDes.Padding = PaddingMode.PKCS7
transform = tripDes.CreateDecryptor
results = transform.TransformFinalBlock(data, 0, data.Length)
Return UTF8Encoding.UTF8.GetString(results)
End Using
End Using
End Function
fuente
Etiquetas:
encriptar,
md5,
MD5CryptoServiceProvider
martes, 13 de agosto de 2019
eliminar registros vacíos (Nothing) en un array
array = array.Where(Function(x) x IsNot Nothing).ToArray
Dim carpeta_xml() As String
carpeta_xml = carpeta_xml.Where(Function(x) Not String.IsNullOrEmpty(x)).ToArray
fuente
fuente1
fuente2
Dim carpeta_xml() As String
carpeta_xml = carpeta_xml.Where(Function(x) Not String.IsNullOrEmpty(x)).ToArray
fuente
fuente1
fuente2
TimeSpan mes,semana,día,hora,minuto,segundo
Dim total As TimeSpan = New TimeSpan((Now.AddMonths(nud_mes.Value).Date - Now.Date).TotalDays + (Now.AddDays(nud_semana.Value * 7).Date - Now.Date).TotalDays + nud_dia.Value, nud_hora.Value, nud_minuto.Value, nud_segundo.Value, 0)
Etiquetas:
AddMonths,
milisegundos,
Now,
TimeSpan,
TotalDays
consola
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
Try
'Dim sr As New StreamReader("file.txt")
rtb_console.Text = File.ReadAllText("file.txt")
'rtb_console.AppendText(File.ReadAllText("file.txt"))
rtb_console.SelectionStart = rtb_console.TextLength
rtb_console.ScrollToCaret()
'rtb_console.Focus()
'rtb_console.Refresh()
Catch ex As Exception
End Try
' https://www.codeproject.com/Questions/430020/which-is-the-control-best-suited-for-displaying-th
End Sub
Try
'Dim sr As New StreamReader("file.txt")
rtb_console.Text = File.ReadAllText("file.txt")
'rtb_console.AppendText(File.ReadAllText("file.txt"))
rtb_console.SelectionStart = rtb_console.TextLength
rtb_console.ScrollToCaret()
'rtb_console.Focus()
'rtb_console.Refresh()
Catch ex As Exception
End Try
' https://www.codeproject.com/Questions/430020/which-is-the-control-best-suited-for-displaying-th
End Sub
timespan
Private Sub btn_ok_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_ok.Click
Dim totalDia As Long = (Now.AddDays(1).Date - DateTime.Now).TotalMilliseconds
'Dim t As TimeSpan = TimeSpan.FromDays(31)
Dim cantidad_dias_mes As Integer = (Now.AddMonths(12).Date - DateTime.Now).TotalDays
Dim t1 As TimeSpan = TimeSpan.FromDays(cantidad_dias_mes)
Dim cantidad_dias_semana As Integer = (Now.AddDays(2 * 7).Date - DateTime.Now).TotalDays
Dim t2 As TimeSpan = TimeSpan.FromDays(cantidad_dias_semana)
Dim cantidad_dias_dia As Integer = (Now.AddDays(1).Date - DateTime.Now).TotalDays
Dim t3 As TimeSpan = TimeSpan.FromDays(cantidad_dias_dia)
End Sub
Dim totalDia As Long = (Now.AddDays(1).Date - DateTime.Now).TotalMilliseconds
'Dim t As TimeSpan = TimeSpan.FromDays(31)
Dim cantidad_dias_mes As Integer = (Now.AddMonths(12).Date - DateTime.Now).TotalDays
Dim t1 As TimeSpan = TimeSpan.FromDays(cantidad_dias_mes)
Dim cantidad_dias_semana As Integer = (Now.AddDays(2 * 7).Date - DateTime.Now).TotalDays
Dim t2 As TimeSpan = TimeSpan.FromDays(cantidad_dias_semana)
Dim cantidad_dias_dia As Integer = (Now.AddDays(1).Date - DateTime.Now).TotalDays
Dim t3 As TimeSpan = TimeSpan.FromDays(cantidad_dias_dia)
End Sub
Suscribirse a:
Entradas (Atom)