A Deep Dive into CSS Grid

As the title says A Deep Dive into CSS Grid, I’m not gonna explain the basic of CSS grid rather in this post I’ll try to explore almost all features and properties of CSS grid.

Recap: CSS grid allows us to divide a webpage into rows and columns with simple properties to build complex layouts as well as small user interfaces using CSS only, without any change to the HTML.

Let’s dive in detail..

Property: display
To make an element a grid, set its display property to grid.

.to-be-grid {
display: grid;
}

Doing this makes .to-be-grid a grid container and its children grid items.

Property: grid-template-columns

We can create columns by using the grid-template-columns property. To define columns set this grid-template-columns property to column sizes in the order that you want them in the grid to appear. Let’s have a look:

.grid {
display: grid;
grid-template-columns: 100px 100px 100px;
}

This defines 3 100px width columns. All grid items will be arranged in order, in these columns. And the row height will be equal to the height of the tallest element in row but this also can be changed with grid-template-rows.

Property: grid-template-rows

It is used to define the number & the size of rows in a grid. It is similar in syntax to grid-template-rows.

.grid {
display: grid;
grid-template-columns: 100px 100px 100px;
grid-template-rows: 100px 100px 100px;
}

Only the grid-template-rows property without grid-template-columns would result in column width being same as the width of the widest element in that row.

Property: grid-template

Grid is shorthand for three properties: grid-template-rows, grid-template-columns, and grid-template-areas.

You can use it is like this:

.grid {
grid-template:
“header header header” 80px
“nav article article” 600px
/ 100px 1fr;
}

You define the template areas such as you normally would, place the width of every row on its side then finally place all the column widths after a forward slash. Like before, you’ll place all of it on one line.

Data Type:

The unit “fr” is a newly created unit for CSS Grid Layout. The fr unit helps to create flexible grids without calculating percentages. 1 fr represents one fraction of available space. The available space is divided into total number of fractions defined. So, 3fr 4fr 3fr divides the space into 4+3+4=11 parts and allocates 4, 3 and 4 parts of the available space for the three rows/columns respectively. For example:

.grid {
display: grid;
grid-template-columns: 3fr 4fr 3fr;
}

If you combine fixed units with flexible units, the available space for the fractions is calculated after subtracting the fixed space. Let’s check out another example:

.grid {
display: grid;
grid-template-columns: 3fr 200px 3fr;
}

The width of a single fraction is calculated like: (width of .grid – 200px) / (3 + 3). The space of the gutters, if any would have also been subtracted initially from the width of .grid. This is the difference between frs and %s that percentages don’t include the gutter that you define with grid-gap.

Here 3fr 200px 3fr is essentially equal to 1fr 200px 1fr.

Guess, that’s a lot for today :p  Will continue remaining in part two.

C# join tables using IQueryable in LINQ

Yesterday I was struggling with how to Join tables using IQueryable in C# or Asp.Net and return it in List. So, here I’m with the solution. Let’s start..

With the introduction of LINQ the difference between writing code for  accessing a list of data in an external data source like SQL Server is vanishing. With the introduction of .NET Framework 4.0 this has changed.In this post i would like to filter my SQL data employing 2 tables.

In my project I’ve 2 tables. 1: Containing all the basic user data like Full Name, DOB etc and 2nd containing user’s student id, card number and so on.. I’ve needed a Data like this: Full Name [Roll Number]

So, here’s the code

var query = (from a in DbInstance.User_Account
join s in DbInstance.User_Student on a.Id equals s.Id
where s.Status == 1
select new { a, s } into t1
select new
{
Id = t1.a.Id.ToString(),
Name = string.Concat(t1.a.FullName.ToString(), ” [“, t1.s.RollNumber.ToString(), “]”)
}).ToList();

Happy #programmers day

Happy programmer’s day to every programmer who said:

– I convert coffee into code
– It is working on my machine
– I will fix that later
– It’s not a bug, it’s a feature
– That’s weird
– How is that possible?
– I cannot repair your computer
– I am not a hacker

In case you don’t know about it :p

The Day of the Programmer is an international professional day that is celebrated on the 256th (hexadecimal 100th, or the 28th) day of each year (September 13 during common years and on September 12 in leap years). It is officially recognized in Russia.

The number 256 (28) was chosen because it is the number of distinct values that can be represented with a byte, a value well known to programmers. 256 is also the highest power of two that is less than 365, the number of days in a common year.

To know more, have a look a here.

Happy programmer’s day again. Cheers!

GitHub is now free for all developer teams

YES, THAT’S TRUE!

Popular software collaboration and hosting platform GitHub has made some of its core premium features free for everyone. The Microsoft-owned company said yesterday that an organization can now make private repositories for development without paying any fees.

Image courtesy: Github Blog

Teams that want more advanced features like code owners or enterprise features like SAML support will still have to upgrade to a paid plan, but those now start at $4 per month and user for the Teams plans instead of the previous $9, with the Enterprise plan starting at $21 per month and user.

Apart from private repository access, a team can also get 2,000 GitHub action minutes/month at no cost. Actions is GitHub’s automation tool offering which lets applications orchestrate any workflow based on an event — like sending a notification. So, the free tier offering is ideal for small-scale projects.

Previously on Last February, Github announced unlimited private repositories for all types of users.

Microsoft’s new Office app now available for Android and iOS

Few months ago Microsoft has announced to publicly test a new version of the Office app that combines Word, Excel and the PowerPoint app at the Ignite conference in Florida, details can be found here.

So as promised, Microsoft has released its new unified Office app for Android and iOS which combines Word, Excel, and PowerPoint into a single application.

Microsoft’s new Office app now available for Android and iOS. Image courtesy: iphonehacks

All of the main apps are combined in this one. Means you can switch between documents quickly, scan PDFs, text and even capture whiteboards and tables into digital versions. Microsoft has also added support for third-party cloud storage like Box, Dropbox, Google Drive and iCloud. This release is also be available on Android tablets with “limited support” and a fully optimized tablet experience will be available on both iPadOS and Android soon.

Microsoft’s new Office app now available for Android and iOS.

More features they are planning in foreseeable future releases:

  • Word Dictation—This will turn your voice into written text and use voice commands and simple toolbars to easily apply the right formatting and punctuation you need.
  • Excel Cards View—View and edit data in an Excel table row in a simple, digestible card format so you do not have span across columns that extend beyond the limits of the screen.
  • Outline to PowerPoint—Write your presentation content as a simple outline and let PowerPoint Designer turn it into presentable slides with the proper styling, formatting, and iconography of your content.

Feeling thrilled? Download the Office app now and have a look:

Download for Android | Download for iOS

Standalone version user’s don’t panic, Microsoft is still planning to keep the individual Word, Excel, and PowerPoint apps available but this combined app is clearly where most of the new mobile-focused features will appear in the foreseeable release.

Google-Dataset-Search-Engine

25 million free datasets was published by Google!

Note: Google’s new dataset search tool was publicly released on January 23rd, 2020.

Google-Dataset-Search-Engine

Google recently released a free tool for searching 25 million publicly available datasets! Yes free! Click here to search these datas datasetsearch, .

Dataset Search was primarily launched in September 2018.

People using Dataset Search thus far range from academic researchers, to students, to business analysts can use these data sets, which range from pretty small ones that tell you how many cats there were in the Netherlands from 2010 to 2018 to large annotated audio and image sets, to check their hypotheses or train and test their machine learning models. The tool currently indexes about 6 million tables.

The most commonly searched for datasets include “education,” “weather,” “cancer,” “crime,” “soccer,” and “dogs”.

Word, Excel and PowerPoint in one app!

Microsoft has officially announced to publicly test a new version of the Office app that combines World, Excel and the PowerPoint app at the Ignite conference in Florida. This app will be available for both Android and iOS.

Microsoft says that with the new Office app users will be able to create new presentations, documents and spreadsheets as well as edit/view existing documents. Further more, you’ll can also “snap a picture of a document” and make it into an editable Word file, create and sign PDFs or “transform tables from a printed page into an Excel spreadsheet!”

New Office app by Microsoft. Image courtesy: iphonehacks

Any can use the unified Office app without signing into a Microsoft account, though signing in will give access to their files to be saved on OneDrive.

https://giphy.com/gifs/Md9r1h5AEdGCk3EJhZ
via GIPHY

To be noted, Microsoft also told CNet, that the brand new Office app won’t be replacing the existing 3 individual apps. “We know some users may only need to use any one of the apps and it is the user’s choice to install the app that best fits according to their needs.

If you are interested to try out the new unified Office app for iOS, sign up for the Testflight program here.

Google brings new privacy controls for mobile users

Google launched Incognito Mode for Maps,YouTube and Google Assistant

Returning to Google I / O in May, we saw that Maps and Search are the next two Android apps to add Incognito mode. Google now officially rolls it out so that you can keep your activity off your Google account and search for information. The functionality will be available from within the app’s profile menu.

google launched incognito mode for maps youtube and google assistant
google launched incognito mode for maps youtube and google assistant

Google Maps Incognito mode

Google Maps Incognito mode first introduced at its Google I / O developer conference earlier this year in May.

The incognito mode of Google Maps is based on the similarly named feature found in all modern browsers and present in Chrome since its release back in 2008.

This enables users of Google Maps to search and access locations without adding this information to their history with Google Account.

Google says Google Maps incognito mode will begin rolling out this month on Android, with iOS coming soon. The functionality is not currently available for the internet version of Google Maps.

YouTube history auto-delete

And since we’re on YouTube, there’s also a new feature for Google to include. Google previously introduced this feature in May when it was added to Google Search, Google Maps, and Google Account (which allowed users to remove past use of the app).