Monthly Archives: May 2021

Winform Master Detail CRUD C#

Posted on May 30, 2021 by chanmingman

This blog article provides a complete CRUD in Winform with Master Detail concept. Not all the applications are suitable for web such as Point of Sales application. This blog is good for those who want to start a Winform project … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , , , | 1 Comment

CTO May 2021 articles and resources

Posted on May 30, 2021 by chanmingman

These are the good reads found in this month. 16 traits of a world class chief innovation officer Collaborative Valuing diversity Humble … https://www.cio.com/article/3613075/16-traits-of-a-world-class-chief-innovation-officer.html?upd=1618132623483 3 Opportunities For CMOs To Capitalize On In 2021 Opportunities for CMOs in 2021: More Channels … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO | Tagged | Leave a comment

C# Delete List Collection Item

Posted on May 23, 2021 by chanmingman

This blog article shows you how to remove an object from C# List. In https://chanmingman.wordpress.com/2021/05/16/c-update-data-in-list-collection/ you have seen how to edit the object in C# List. This https://stackoverflow.com/questions/10018957/how-to-remove-item-from-list-in-c is not completely correct. To remove the object from the List, the … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

Unable to connect to web server IIS Express

Posted on May 16, 2021 by chanmingman

This blog article shows you one of the possible ways to resolve the error “Unable to connect to web server IIS Express”, like the one below. This normally happens in .NET Core project. Go to launchSettings.json file and change all … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet | Tagged | Leave a comment

C# update data in List collection

Posted on May 16, 2021 by chanmingman

This blog article shows you how to update the data in C# List Collection. First I have a class created as follow. public class Products {     public int ProductID { get; set; }     public string ProductName { get; set; } … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet | Tagged | 1 Comment

Import rpt file to SQL Server database table

Posted on May 14, 2021 by chanmingman

rpt This blog article shows you how to import rpt file to SQL Server database. In the blog https://chanmingman.wordpress.com/2021/05/09/sql-server-management-studio-output-query-result-to-text-file/ we export the data to rpt file. It is almost impossible to import from rpt direct back to SQL Server database … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

SQL Server Management Studio (SSMS) output query result to text file

Posted on May 9, 2021 by chanmingman

This blog article shows you how to output the query result from SSMS to text files than to the grid like the one below. Choose the Query from pull down menu. Select Result To. Select Result to File. When you … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | 2 Comments

SQL Server T-SQL Delete all the rows beside the first 2 rows

Posted on May 9, 2021 by chanmingman

This blog article shows you how to delete all the rows beside the first 2 rows. Scenario, you have the Proucts1 table with 78 rows. Execute the following SQLstatement with cte as ( select * , ROW_NUMBER() over (order by … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | 3 Comments

SQL Server Management Studio edit more than 200 rows

Posted on May 4, 2021 by chanmingman

This blog article shows you how to use SQL Server Management Studio to edit more than 200 rows. First select any table that has more than 200 rows that you want to edit. Click on Show SQL Pane. You will … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

‘DbContextOptionsBuilder’ does not contain a definition for ‘UseSqlServer’

Posted on May 3, 2021 by chanmingman

This blog article shows you one of the possible ways to resolve the error below: Severity    Code    Description    Project    File    Line    Suppression State Error    CS1061    ‘DbContextOptionsBuilder’ does not contain a definition for ‘UseSqlServer’ and no accessible extension method ‘UseSqlServer’ accepting a first argument of type ‘DbContextOptionsBuilder’ could be … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Leave a comment