Category Archives: ASP.NET

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.

 

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

<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

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

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 (Imran Sir):
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

ASP.NET Part (Imran Sir):
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
Web Forms

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

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

C# part(Protap sir):
Func, Action, Anonymous Function, Object Initializer, Collection Initializer
delegates, Lambda

IEnumerable, IQueryable, Anonymous Type, Var, Boxing Unboxing

ASP.NET(Protap Sir):

ASP.NET MVC(Protap Sir):

MVC

Entity Framework
– Codefirst Approach

 

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