https://www.gemboxsoftware.com/spreadsheet/examples/excel-images/209
GemBox.Spreadsheet supports all popular image formats like PNG, JPEG, EXIF, GIF, TIFF, ISO, SVG, EMF, and WMF. However, note that only PNG, JPEG, and EMF images are supported in XLS files (old binary format).
In PDF files, the SVG images are rendered as vector graphics, resulting in smaller file sizes and better quality than bitmap images (PNG, JPEG, BMP, etc.).
https://www.cisdem.com/resource/recover-notepad-files.html#:~:text=Steps%20to%20recover%20unsaved%20Notepad,AppData%5CRoaming%20by%20File%20Explorer.
Differing from Notepad, Notepad++ has the autosave option by default. Via menu > Settings > Preferences > Backup > Enable session snapshot and periodic backup, Notepad++ users are allowed to recover unsaved notes easily, even after restarting the app. As a bonus tip, here we’ll demonstrate how to restore unsaved files from Notepad++ using auto backup feature.
Unsaved files in Notepad++ will be automatically backed up and saved to its temporary folder on the local disk of Windows 11/10. The Notepad++ temp files location is C:\Users\USERNAME\AppData\Roaming\Notepad++\backup.
https://www.zickty.com/gziptotext
Controller.cs
Public Function GetValue() As HttpResponseMessage
Dim objResponse As Object = ""
Dim numeroElementos As Int32 = 0
Dim fecha As Date = Date.Now
Dim departamentoId As String = ""
Dim paramOption As String = Convert.ToString(Request.Headers.GetValues("paramOption").FirstOrDefault())
If Request.Headers.Contains("fecha") Then
fecha = Convert.ToString(Request.Headers.GetValues("fecha").FirstOrDefault())
End If
Select Case paramOption
Case "ObtenerInfoDisponibles"
Dim jResults As String = ObtenerInfoDisponiblesSerializar(fecha)
objResponse = CompressJsonData(jResults)
End Select
End Function
Private Function ObtenerInfoDisponiblesSerializar(fecha As String) As String
Dim sqlQuery As New System.Text.StringBuilder
sqlQuery.Append("ObtenerInfoDisponibles " + fecha & vbCrLf)
Dim dt As DataTable = MSSQL1.QueryDataTable(conexion, sqlQuery.ToString())
If dt.Rows.Count > 0 Then
Return JsonConvert.SerializeObject(dt)
End If
Return Nothing
End Function
Public Function CompressGZip(input As String, Optional encoding As Encoding = Nothing) As Byte()
encoding = If(encoding, Encoding.Unicode)
Dim bytes As Byte() = encoding.GetBytes(input)
Using stream As New MemoryStream()
Using zipStream As New GZipStream(stream, CompressionMode.Compress)
zipStream.Write(bytes, 0, bytes.Length)
Return stream.ToArray()
End Using
End Using
End Function
Function CompressJsonData(jsonData As String) As Byte()
Dim byteArray As Byte() = Encoding.UTF8.GetBytes(jsonData)
Using memoryStream As New MemoryStream()
Using gzipStream As New GZipStream(memoryStream, CompressionLevel.Optimal)
gzipStream.Write(byteArray, 0, byteArray.Length)
End Using
Return memoryStream.ToArray()
End Using
End Function
ALTER PROCEDURE [dbo].[ObtenerListaCorreos] @OpcionId AS varchar(50)
AS
BEGIN
DECLARE @strCorreos AS VARCHAR(MAX);
DECLARE @dtCorreos TABLE(correo VARCHAR(100));
DECLARE @intIndiceInicio AS INT;
DECLARE @intIndiceFin AS INT;
DECLARE @strCorreo AS VARCHAR(100);
DECLARE @ultimo AS INT;
SET @intIndiceInicio = 1;
SET @intIndiceFin = 0;
SET @ultimo = 0;
SELECT @strCorreos = [correo] from (
SELECT correo
FROM CORREOS
WHERE OPCIONID = @OpcionId
) as x
;
WHILE @intIndiceFin <> LEN(@strCorreos)
BEGIN
SET @intIndiceFin = CHARINDEX(',', @strCorreos, @intIndiceInicio);
IF @intIndiceFin = 0
BEGIN
SET @IntIndiceFin = LEN(@strCorreos);
SET @ultimo = 1
END;
IF @ultimo = 0
SET @strCorreo = SUBSTRING(@strCorreos, @intIndiceInicio, (@intIndiceFin - @intIndiceInicio));
ELSE
SET @strCorreo = SUBSTRING(@strCorreos, @intIndiceInicio, ((@intIndiceFin - @intIndiceInicio) + 1));
INSERT INTO @dtCorreos
VALUES(@strCorreo);
SET @intIndiceInicio = (@intIndiceFin + 1);
END;
SELECT *
FROM @dtcorreos
ORDER BY correo;
END;
In SQL Server, the sp_lock stored procedure was used in older versions to display information about locks that were currently being held by processes.
SELECT *
FROM sys.dm_exec_requests;
SELECT *
FROM sys.dm_os_waiting_tasks;
EXEC sp_who2;
DECLARE @sqltext VARBINARY(128)
SELECT @sqltext = sql_handle
FROM sys.sysprocesses
WHERE spid = 322
SELECT TEXT
FROM sys.dm_exec_sql_text(@sqltext)
https://www.c-sharpcorner.com/article/filtering-in-datagridview-in-vb-net-and-also-in-c-sharp/
In this article we will learn about how to filter data in datagridview. We can better understand this with an example.
Step 1
Create Windows Form with Textbox and DataGridView.
Step 2
In coding view, code as per the following code. Here, I give both code c# and vb.Net. You can choose as per your requirement(s).
Code as per Vb.Net
Code as per C#
Output 1
When you run the application, by default all data will be loaded in datagridview as per the following:
Final Output
In Textbox, when I type IT, the following records will be filtered:
In this article, we have learned about how to filter data in datagridview and also highlight cells.
