Category Archives: Software Development

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

<authentication>

</authentication>

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

What is difference between connection string and appSettings ?

<appSettings>
<add key=””>
</appSettings>

<connectionStrings>

</connectionStrings>

 

LinqToSql Class

12.12.17: (This is one of the important videos)

For project works

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.

SubQuery:

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.

Syntax:

Following the basic syntax of stored procedure creation.

Lots of parameters used in stored procedure:

IN paramater is a paramater whose value is past 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

 

Here are the store procedure example basic in my blog

Stored Procedures

 

Extension Methods in C# 3.0

program.cs

StaticClass.cs

TestExtensionMethods.cs

 

 

 

 

 

 

 

output:

 

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

 

Gridview CRUD with Visual Studio

HTML 5 Template Creation With Visual Studio

ASP.NET Master Page Concept in a nutshell !!

Opening existing Project for previous website :
File->Open->Website
(Opening the whole directory created from an empty website)

 

 

LICT C#, OOP and .NET Syllabus

C# Part:
Objects & Classes

Constructor
Destructor
Static
Polymorphism
Abstraction
Inheritance
Property
Generics
Exception Handling
Access Modifier
Interface
Encapsulation
Commandline
Aggregation
Method Hiding
base
seal
Implicit Explicit Convert
Boxing Unboxing
Ref and Out
Foreach
Array
Enum
String Buffer, String Builder
Partial Class
Partial Method
Delegates
Multicast Delegates
Lambda Expresssion

MVC Part:
HTML
CSS
Master Page
Session
Database Insert, Login, Registration, Logout using visual studio ( SqlData Reader)
Calendar Events
Validation
Ado.net
CRUD automatically(with built in process)
CRUD manually(without builtin toolbox- It was H.W)
Data Bound Control

SQL:(Protap Sir)
DDL, DML
Constraint
Inner Join/Equi Join,
Primary Key, Foreign Key
Aggregate, Group BY
Outer Join – Left Outer Join, Right Outer Join, Full Join,
Self Join

Sub-query, Store Procedure
ADO.NET, Regi System, Login System

Func, Action, Anonymous Function, Object Initializer, Collection Initializer
delegates, Lambda

Advanced ASP.NET, C#:
List Bind Control Postback
State Management

Excel(Ameer Sir):
Min, Max, Average, Count, Present, Past
Vlookup, COUNTIF, Conditional Formatting

 

Assesment:
1 Exam was on OOP basics(50 marks)
2 Assignment:
1st was on basic switch, if else etc.
2nd was on OOP and little more advance topic of C# with out/ref
3rd Class Work by Protap Sir.. To write some sql queries [29.10.2017]
4th Assesment on LINQ  28.11.2017

Registration System Using ASP.NET using SQL Database

ASP.NET Master Page Creation

 

 

 

 

 

String vs string in c#

https://stackoverflow.com/questions/7074/what-is-the-difference-between-string-and-string-in-c/19729734

Function in C#

 

using parameter and return type

 

Java vs C# Similarity

https://www.harding.edu/fmccown/java_csharp_comparison.html