How To

How to download a file from server using SSH?
12/11/2024 2:16:48 AM  40

To download a file from a server using SSH, you'll typically use SCP (Secure Copy Protocol) or SFTP (SSH File Transfer Protocol).

How to generate random number in Javascript?
12/11/2024 2:07:54 AM  50

In JavaScript, you can generate random numbers using the Math.random() function. This function returns a random floating-point number between 0 and 1.

How to convert timestamp to date in SQL Server
12/11/2024 2:00:16 AM  186

In SQL Server, you can convert a timestamp (or datetime) to just a date using the CAST or CONVERT functions.

How to convert SQL Server's timestamp column to datetime format
12/11/2024 1:55:35 AM  117

SQL Server's `TIMESTAMP` datatype has no relation to date or time. It is simply a hexadecimal representation of a consecutive 8-byte integer used for versioning, ensuring that a row hasn't been modified since it was last read.

How to set data attribute in JQuery
12/11/2024 1:34:42 AM  88

In jQuery, you can set a data attribute using the .data() method or by directly manipulating the data-* attribute using .attr().

IEnumerable<T> vs IQueryable<T>
12/10/2024 8:08:37 AM  33

The primary difference between IQueryable<T> and IEnumerable<T> lies in how and when the data is retrieved and processed.

How to fix 'FolderBrowserDialog not showing Network shared folders on Win10'
12/10/2024 4:46:11 AM  45

If you're using the FolderBrowserDialog in a Windows Forms application, and it's not showing network shared folders on Windows 10, there are a few things you can check and try to resolve the issue.

How to install and uninstall Windows services
12/10/2024 3:42:49 AM  63

To install a Windows service developed with the .NET Framework, you can use the `InstallUtil.exe` command-line utility or PowerShell.

How to fix 'Authorization in ASP.NET Core' with 401 Unauthorized
12/10/2024 2:46:51 AM  596

Getting a 401 Unauthorized error when using the [Authorize] attribute in ASP.NET Core generally indicates that there is an issue with the authentication or authorization setup.

Connection string password with special characters in C#
12/10/2024 2:44:01 AM  603

When you create a connection string in C# that includes a password with special characters, it's important to properly format and escape those characters to ensure the connection string is interpreted correctly.

How to convert varchar to uniqueidentifier in SQL Server
12/10/2024 2:41:58 AM  755

To convert a varchar to a uniqueidentifier in SQL Server, you can use the CAST or CONVERT function.

How to retrieve the Executable Path in C#
12/10/2024 2:11:28 AM  828

In C#, you can retrieve the executable path of the current application using the System.Reflection namespace.