Universe Guide Blog Archive 4
How do you resolve "503 - Not Logged In" error when using FTP / 29th August 2021 4:16 PM
If you are getting "503 - Not Logged In" issue when FTPing to a remote site using C#, the problem is unlikely to be your code. Instead, the issue lies with the hosting server. Read More...
When Google says "Getting Ready" in Adsense, what does it actually mean? / 29th August 2021 11:20 AM
It can be frustrating when you develop a website and pass all the Google tests for adsense but they reject you. Why they actually reject you is for probably for another reason, one which they don't reveal. Read More...
How to export a DataTable to a .CSV file / 28th August 2021 6:02 PM
If you need to export the results of a datatable to a .csv file for viewing in a spreadsheet, you can use the following code and example to get the task done. Read More...
What is the difference between a DataReader and a DataTable in C# (.NET)? / 28th August 2021 3:07 PM
DataReaders and DataTables are two methods using in .NET to retrieve records from a database. They have different connections, one is a disconnected recordset and the other is a connected recordset at the simpliest, Read More...
What is the difference between Truncate Table and delete in SQL? / 28th August 2021 1:57 PM
Truncate Table and Delete will both allow you to delete records from a database table but there are a few things to be aware of when choosing which to use. Read More...
How to read a file in C# .NET / 28th August 2021 1:16 PM
Reading a file into memory is simple and there are three different methods for reading a file into memory using .NET. Examples are given in C#. Read More...
The Differences, Advantages and Disadvantages of Clustered vs. Non-Clusted Indexes in SQL Databases / 27th August 2021 8:06 PM
Indexes applied to databases are mainly either clustered or non-clustered, each have their own advantage and disadvantage and using the right one can help with the effciency of the system. Read More...
How to load a file into a field in SQL Server / 25th August 2021 8:21 PM
Example of how to load a large file into a database field in SQL Server without having to write any C# or equivalent code. Read More...
How to extract an XML value from a SQL Server Table / 25th August 2021 8:02 PM
If you need to extract an XML value from SQL Server to a file, this article will show you how it can be achieved. Read More...
How to get an image out of a table in SQL Server / 25th August 2021 7:29 PM
SQL Server code to extract an image file from a table and export it to a file on the disk. The disk being normally, the server, not the user whose doing the operation. Read More...