Skip to content

Instantly share code, notes, and snippets.

@kironroy
kironroy / covid.html
Created May 25, 2020
covid react page
View covid.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta content="width=device-width, initial-scale=1" name="viewport">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<link href="https://kironroy.github.io/apple-touch-icon.png" rel="apple-touch-icon" />
<link href="https://kironroy.github.io/apple-touch-icon-152x152.png" rel="apple-touch-icon" sizes="152x152" />
<link href="https://kironroy.github.io/apple-touch-icon-167x167.png" rel="apple-touch-icon" sizes="167x167" />
@kironroy
kironroy / design.md
Last active Sep 25, 2020
design graphics
View design.md
View Program.cs
using Microsoft.Extensions.Configuration;
using System;
using System.IO;
using DataAccessLibrary;
using DataAccessLibrary.Models;
namespace SQLServerUI
{
class Program
{
View SqlCRUD
using DataAccessLibrary.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace DataAccessLibrary
{
// this class will use the SQLDataAccess.cs
View SqlDataAccess.cs
using Dapper;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
namespace DataAccessLibrary
{
View sql.txt
-- inner join: only the records that match
-- left join: all the records from the left table, and all the matching records from the right table
-- right join: all the records from the right table, and all the matching records from the left table
select c.CompanyName, l.City
from dbo.Customers c
left join dbo.Locations l on c.id = l.CustomerId
View gist:75485a205fe33022b2966810cd444c56
![c sharp logo](https://kironroy.github.io/c_sharp.svg)
---
<a href="https://dev.to/kironroy">
<img src="https://d2fltix0v2e0sb.cloudfront.net/dev-badge.svg" alt="Kiron Roy's DEV Profile" height="40" width="40">
</a>
@kironroy
kironroy / RazorPractice.cshtml
Created Oct 26, 2019
Razor Syntax practice
View RazorPractice.cshtml
@* https://stackoverflow.com/questions/6286868/convert-month-int-to-month-name/6286910 *@
@* https://blogs.msdn.microsoft.com/timlee/2010/07/30/using-functions-in-an-asp-net-page-with-razor-syntax/ *@
@{
ViewData["Title"] = "RazorPractice";
}
<h1>Razor Practice</h1>
You can’t perform that action at this time.