Category Archives: Software Development

LICT .NET Training | Kamal Protap Sir | Part 6

19.11.17 Videos:
Inheritance, Association, Aggregation and Composition
These are except that inheritance
From the slide:
Relation between students and teacher. Both are independent.
Manager has a swipe card to enter the company premises Association
A manager is a type of Employee. Employee is a parent of manager
These kind of relationship is called Aggregations. It represents a Has-A relationship.
public class Manager{
//aggregation relation
public List<Worker> workers=new  List<Worker>();
//here worker is the child object and manager  is the parent object


public class Worker{

public string WorkerName=” “;

Worker object=new Objects;

Composition(Death Relationships)


It is very useful while string can make complexity in heap but StringBuilder helps to reduce it by modifed string.

System.Text.StringBuilder class can be used  and it comes from System.Text namespace


StringBuilder is mutable
StringBuilder performs faster than string when appending multiple string values

StringBuilder sb=new StringBuilder();

Use append method to add or append strings with StringBuilder
Use ToString() method to get the string from StringBuilder

Relationships Code and Videos:


  1. Manager( is a )type of employee(Employee is a parent of Manager) – Inheritance
  2. Manager ( has a ) swipe card to enter company premises – Association
  3. He has many workers under him.  – Aggregation relationship
  4.  His salary depend on project success. – Composition
  5.  Project success depends on a manager. –

I have completed the program may be I need to do it / practice it letter with heart. 🙂

C# IEnumerable vs IEnumerator

When we work with Collections in C# we need to iterate the items of collections. One way fo doing is this foreach loop.


The class should implenet IEnumerable interface. The IEnumerable interface also inehirts from IEnumerator interface/







LICT .NET Training | Kamal Protap Sir | Part 5

16/11/2017 vids

Object Initializer
– It contains three clauses
from, where, orderby

Diffrenet Datasource:
Array, Database, XML,LIST/Collection also datasource, File Concept also data source
Data we can able to store in known as data source
Data source: Where the data is available

Linq-Language Integrated Query
What is strongly typed ?

Strongly typed means:
Which show error immediately at a time of declaration that  is called strongly typed. It is also called compile time error.

Weakly typed means:
Which show error in runtime is called weakly typed like delegate.It is also known as loosely type.

Intellisense and Strongly typed is supproted in LINQ concept.

LINQ enabled data sources is very very important for interview:
LINQ to Objects : It means with array, arralist, etc.
LINQ to Datasets: It’s connected with ADO.NET
LINQ to SQL: It’s connected to SQL
LINQ to Entities: It’s connected to other data base like oracle or mysql
LINQ to XML: It’s connected to XML files

Where IQueryable is inherited from IEnumerable

There are two expression in LINQ QueryExpression and methodExpression

Differed Execution:


Forced Execution:



LICT .NET Training | Kamal Protap Sir | Part 4

MVC Part:

Controller getting input.

ApplicationManagement video was so important


In Controller Folder HomeController.Cs is a controller which is controlling all the things

here is the code:

App_Start Folder:

RouteConfig.cs file we will find that


How to communicate with Controller and View:
ViewData and ViewBag passing the data from a controller to view

Interview questions:
ViewData: ViewData is dictionary of objects that is dervied from ViewData dictionary class and is accessible using string as keys.

ViewBag: viewBag is dynamic property. That take advantages of dynamic features.

both does not provide any compile time error.


In model we need to write the business logic.

In View we can show the actual things what we want to show:







LICT .NET Training | Kamal Protap Sir | Part 3

09/11/2017 vids


Automatic Property:


Lambda Expression with FUNC:

Some logics:

Lambda using Function:

Multicast Delegates:

A delegate instance holding the multiple method at a time is multicast delegate.
But the rule is that all the method must be altered because all method in a single instance they remain present. Multiple reference method at a  time.

Anonymous Method:
Unnamed function. In the bracket we are writing the logic. Unnamed method we are writing the logic. Unanmed method.


The same AnonymousMethod work can be done in a single line with this lambda operation:

=> This is known as goes to operator and it is similar to AnonymousMethod()

Linq also using lambda not only Delegate


Func is a readymade function where the first data type is for input and the second one is for output. It does not need any delegate to declare.

Action does not support any return type:







DataReader and DataAdapter and DataSet

Difference Between DataReader and DataAdapter and DataSet:

Datareader: Datareader will be the best choice where we need to show the data to the user which requires no manipulation.

DataAdapter: DataAdapter read data from the database and is used to bind the data to the DataSet because DataAdapter working as a bridge between DataSet and the DataBase.

DataSet: DataSet is best suited where there is possibility of manipulation on the data.



In this article you will learn about the Connected And Disconnected Environment in ADO.NET.


LICT .NET Training | Kamal Protap Sir | Part 2

07.11.17 Vids
DataAdapater vs DataReader:

SqlDataReader row by row executes from the table

ExecuteReader() always executes the query to the data reader object.

Using data reader:

Using data adapter:


Difference between DataReader and DataAdapter:

Using data adapter:
First we call data adapter then data set


DataSet is a disconnected architecture
DataReader is a connected architecture



With DataAdapter:

Whole datagridview has been binded with the data.


Stored procedure in Our Application:





SqlConnection in ADO.NET

LICT Training Vids Summary

10.12.17: (This is one of the important videos)
AuthenticateLogic is very very important for project works: also the store procedure here is important



<deny users=”?”> //if it is * it means that it is open for all but ? sign means it is only for requested users

What is difference between connection string and appSettings ?

<add key=””>




LinqToSql Class

12.12.17: (This is one of the important videos)

For project works

Stored Procedures






LICT .NET Training | Kamal Protap Sir

DDL – Data definition Language(Which deals with database schemas and descriptions that how the data should reside in database) – create,alter,drop, truncate, comment
DML – Data manipulation language(Modify, Update, Delete data in database) – select, insert, update, delete
DCL – Data Control Language(Regarding the rights of the database)  grant,revoke


31-10-17 vids

SQL Query

SQL Aggregate functions, slides presentation: This presentation describes SQL Aggregate function covering SQL COUNT(), SUM(), MAX(), MIN(), AVG) functions with examples.


A query within another query is called subquery or nested query . Inner Query, Outer query is in subquery.

Sub Query are two types they are, co-related sub query and non co-related subquery. They works for both DDL and DML statements
Co-related means relationship/dependent on
Non co-related means independent

There are two queries in sub query. You will see group by, order by is single type query but in sub query it needs multiple query

Non co related: They are two types,
Inner query: It will first execute. It will return some result. Independently it will execute.
Outer Query: Based on the inner query result now outer query will execute. The whole process is known as non co-related


= for comapring single value
IN for comparing multiple value

Co-related: It is dependent query. Inner query can’t execute independently. Inner query depends on outer query. Without returning row from the outer query inner can’t execute. In co-related sub query. All execute first.

02.11.17 Vids
Store Procedure:

MS SQL Server store procedure is used to save time write the same code again and again for storing in database and also get the rquired output by passing parameters.


Following the basic syntax of stored procedure creation.

Lots of parameters used in stored procedure:

IN paramater is a paramater whose values are passed inside of the procedure
OUT paramater is a paramater whose value is pass outside the parameter
OUT parameter return some value
IN does not return any value
create procedure

Executing the stored procedure:


Here are the store procedure example basic in my blog

Creating View:
View is something where other developers can’t find details. But they can make query with the name when they need it.

View helps to show the particular data for the

UPDATE with view

View don’t support order by in that case we  need top keyword in view:

05.11.2017 vids

ADO.NET is  a set of classes that allows you to connect and work with data sources like databases,excel file, access file, xml file,my sql, and notepad.

To connect your application with different data sources of database you need to know the right data provider. There are sevral data providers in ADO.NET that connects with different types of sources.


There are 4 core components of .NET data providers that is used to connect,access and retrieve data from the database.

  1. Connection- This component is used for connecting to the database. The base class is DbConnection
  2. Command: This component executes SQL query against the data source. The base class is DbCommand.
  3. DataReader-It reads data from data source. It accesses data read only and forward only. The base class is DbDataReader.
  4. DataAdapter-It invokes dataset and resolves updates with the data source. The base class is DbDataAdapater

Pass value with parameters:


Extension Methods in C# 3.0













Xamarin Mobile For .NET Devs

When considering iOS or Android app development, most of us think about Objective-C vs Swift, and Java first of all. Being considered native tech stacks, th


Insert Values into Tables using ADO.NET


code for Form1.cs:

There is also Form1.cs design

Login and Logout page in ASP.NET using Session, Sign up using DataReader