Deploy ASP .NET MVC application using LocalDB to local IIS

When ASP application is published to IIS using LocalDB accessing the database may result in the following error:

Server Error in '/Application_Name' Application.A network-related or instance-specific error occurred while establishing a connection to SQL Server.
2017/10/18 05:49

Introduction to Widows Forms and Visual Studio IDE

Visual Studio .NET provides a user-friendly graphic designer for building user interfaces. With it, within a few minutes, a user interface design can be built, whether it's a Windows Forms window, a Web page, or a mobile application interface
CompilationWhen compiling, VS.NET automatically creates the required assemblies and resource files.
| | | | |
2017/10/05 05:45

Introduction to .NET Framework, C# (C Sharp) and Windows Forms

| 2017/10/05 03:59

Microsoft .NET Framework

Microsoft .NET Framework is technology for building and running .NET applications. It provides a standard library of classes and a run-time environment called Common Language Runtime (CLR).CLR is the foundation of the .NET Framework. It manages code at execution time, memory management, thread management, remoting.

c# combobox fill from database

| 2017/10/05 03:18
To get only the unique /distinct/ data table records from any database connected to DataSet in C# project and to put them inside combobox.Fill the table adapter with the records from database.
Create a view containing the database table
DataView view = new DataView(this.myDB_DataSet.myDBTable);

Copy only the distinct records to new data table.

Get latest date record - SQL query

To return the latest record (one record only) from data base table where one of the fields is in Date/Time format:
SELECT TOP 1 * FROM table_name ORDER BY date_time_column_name DESC
2017/10/05 03:02