Monthly Archives: April 2020

Blazor get value from Textbox

Posted on April 29, 2020 by chanmingman

This post shows how to get the value from a TextBox from Blazor page. To Add a new Blazor page see the detail here https://chanmingman.wordpress.com/2020/02/09/blazor-add-static-data/.. <input @bind=”CurrentValue“> is the TextBox that you can play with The complete code for the … Continue reading →

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

WEBASSEMBLY USING C# BLAZOR Global Azure

Posted on April 26, 2020 by chanmingman

The post gives you the resources I presented on 25 Apr 2020 in Global Azure live event. The event link was https://mygab.azurewebsites.net/. Also thanks who has supported the session. Step-by-step Getting Started Blazor C#: https://chanmingman.wordpress.com/2020/01/21/getting-started-blazor-c/ Blazor with static data: https://chanmingman.wordpress.com/2020/02/09/blazor-add-static-data/ … Continue reading →

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

CTO Article April 2020

Posted on April 26, 2020 by chanmingman

These are the good reads found in this month. During covid-19 work from home topics and secure your work from home environment related discussions are popular. Azure Database Migration Guide, this guide give you ideas to move almost from any … Continue reading →

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

SQL Server View dependencies – List all tables in View

Posted on April 22, 2020 by chanmingman

This post shows you one of the fastest ways to know what are the tables are inside the View of SQL Server. Let’s say you have the below View consists of 4 tables. The View name is Product Sales for … Continue reading →

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

Convert d/M/yyyy to dd/MM/yyyy C#

Posted on April 18, 2020 by chanmingman

This post shows you how to Convert d/M/yyyy to dd/MM/yyyy using C#. At first, I thought I can find a library to do this but ended I will should this as a library to you. If you try to insert … Continue reading →

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

Jsonconvert is missing in json.net

Posted on April 13, 2020 by chanmingman

This post shows where can you get the Jsonconvert object. When I read the link https://www.newtonsoft.com/json/help/html/DeserializeObject.htm then I added the json.net nuget package to Visual Studio. With the code the link as below. string json = @”{ ‘Email’: ‘james@example.com’, ‘Active’: … Continue reading →

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

Blazor with SQL Server database

Posted on April 12, 2020 by chanmingman

This article showing you how to add the database into the Blazor page.It is pretty much the same like the static data, https://chanmingman.wordpress.com/2020/02/09/blazor-add-static-data/. Just that in the service part you need to connect to database. I will create a 1. … Continue reading →

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

How to use alias column name in where clause in SQL Server

Posted on April 11, 2020 by chanmingman

This post shows you one of the ways to use alias column name in where clause in SQL Server. I have a table called Journeys. When I execute the SQL Statement below. SELECT vesselId, mcValue, SCN, voyageNumber, batchId, ETD, ATD, … Continue reading →

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

gRPC using Visual Studio 2017

Posted on April 5, 2020 by chanmingman

I have watched a video on msdn Channel 9 about gRPC and it is using of course Visual Studio 2019. Most of my machine is still Visual Studio 2017. So I went on to search for gRPC using Visual Studio … Continue reading →

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

List all columns in View SQL server

Posted on April 4, 2020 by chanmingman

This short post shows a very handy SQL Statement. A Sql statement to list all the column in particular View MS SQL Server. M_VIEW is the name of the View. select schema_name(v.schema_id) as schema_name, object_name(c.object_id) as view_name, c.column_id, c.name as column_name, type_name(user_type_id) as … Continue reading →

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