Understanding the Common Language Runtime:
The second part of the .NET Framework is the Common Language Runtime (CLR). The Common Language Runtime is responsible for executing your application code.
When you write an application for the .NET Framework with a language such as C# or Visual Basic .NET, your source code is never compiled directly into machine code. Instead, the C# or Visual Basic compiler converts your code into a special language named MSIL (Microsoft Intermediate Language).
MSIL looks very much like an object-oriented assembly language. However, unlike a typical assembly language, it is not CPU specific. MSIL is a low-level and platform-independent language.
When your application actually executes, the MSIL code is "just-in-time" compiled into machine code by the JITTER (the Just-In-Time compiler). Normally, your entire application is not compiled from MSIL into machine code. Instead, only the methods that are actually called during execution are compiled.
In reality, the .NET Framework understands only one language: MSIL. However, you can write applications using languages such as Visual Basic .NET and C# for the .NET Framework because the .NET Framework includes compilers for these languages that enable you to compile your code into MSIL.
You can write code for the .NET Framework using any one of dozens of different languages, including the following:
Ada Apl Caml COBOL Eiffel Forth Fortran JavaScript Oberon PERL Pascal PHP Python RPG Scheme Small Talk
The vast majority of developers building ASP.NET applications write the applications in either C# or Visual Basic .NET.
  The second part of the .NET Framework is the Common Language Runtime (CLR). The Common Language Runtime is responsible for executing your application code.
When you write an application for the .NET Framework with a language such as C# or Visual Basic .NET, your source code is never compiled directly into machine code. Instead, the C# or Visual Basic compiler converts your code into a special language named MSIL (Microsoft Intermediate Language).
MSIL looks very much like an object-oriented assembly language. However, unlike a typical assembly language, it is not CPU specific. MSIL is a low-level and platform-independent language.
When your application actually executes, the MSIL code is "just-in-time" compiled into machine code by the JITTER (the Just-In-Time compiler). Normally, your entire application is not compiled from MSIL into machine code. Instead, only the methods that are actually called during execution are compiled.
In reality, the .NET Framework understands only one language: MSIL. However, you can write applications using languages such as Visual Basic .NET and C# for the .NET Framework because the .NET Framework includes compilers for these languages that enable you to compile your code into MSIL.
You can write code for the .NET Framework using any one of dozens of different languages, including the following:
Ada Apl Caml COBOL Eiffel Forth Fortran JavaScript Oberon PERL Pascal PHP Python RPG Scheme Small Talk
The vast majority of developers building ASP.NET applications write the applications in either C# or Visual Basic .NET.
Create Table tblCountry  
(
CountryId Int Primary Key,
County Varchar(30)
)
Create Table tblcountryState
(
StateId Int Primary Key,
CountryId Int Foreign Key References tblCountry(CountryId),
State Varchar(30)
)
Create Table tblstateCity
(
CityId Int,
StateId Int Foreign Key References tblcountryState(StateId),
City Varchar(30)
)
-------------------------------
Insert Into tblCountry Values(101,'India')
Insert Into tblCountry Values(102,'USA')
Insert Into tblCountry Values(103,'Pakistan')
     
Insert Into tblcountryState Values(1001,101,'U.P')
Insert Into tblcountryState Values(1002,101,'Kerala')
Insert Into tblcountryState Values(1003,101,'Kasmir')
Insert Into tblcountryState Values(2001,102,'Colorado')
Insert Into tblcountryState Values(2002,102,'Delaware')
Insert Into tblcountryState Values(2003,102,'Georgia')
Insert Into tblcountryState Values(3001,103,'Punjap')
Insert Into tblcountryState Values(3002,103,'Baluchistan')
Insert Into tblcountryState Values(3003,103,'Sind')
     
Insert Into tblstateCity Values(11,1001,'Kanpur')
Insert Into tblstateCity Values(12,1001,'Varanasi')
Insert Into tblstateCity Values(21,1002,'Kochi')
Insert Into tblstateCity Values(22,1002,' Thiruvananthapuram ')
Insert Into tblstateCity Values(31,1003,'Jammu')
Insert Into tblstateCity Values(32,1003,'Manali')
Insert Into tblstateCity Values(41,2001,'Alabama')
Insert Into tblstateCity Values(42,2001,'Arizona')
Insert Into tblstateCity Values(51,2002,'Bellefonte')
Insert Into tblstateCity Values(52,2002,'Felton')
Insert Into tblstateCity Values(61,2003,'Rustavi')
Insert Into tblstateCity Values(62,2003,'Kobulati')
Insert Into tblstateCity Values(71,3001,'Lahore')
Insert Into tblstateCity Values(72,3001,'Faisalabad')
Insert Into tblstateCity Values(81,3002,'Quetta')
Insert Into tblstateCity Values(82,3002,'Nasirabad')
Insert Into tblstateCity Values(91,3003,'Krachi')
Insert Into tblstateCity Values(92,3003,'Mirpur khas')
  
select * from tblCountry
select * from tblcountryState
select * from tblstateCity
  (
CountryId Int Primary Key,
County Varchar(30)
)
Create Table tblcountryState
(
StateId Int Primary Key,
CountryId Int Foreign Key References tblCountry(CountryId),
State Varchar(30)
)
Create Table tblstateCity
(
CityId Int,
StateId Int Foreign Key References tblcountryState(StateId),
City Varchar(30)
)
-------------------------------
Insert Into tblCountry Values(101,'India')
Insert Into tblCountry Values(102,'USA')
Insert Into tblCountry Values(103,'Pakistan')
Insert Into tblcountryState Values(1001,101,'U.P')
Insert Into tblcountryState Values(1002,101,'Kerala')
Insert Into tblcountryState Values(1003,101,'Kasmir')
Insert Into tblcountryState Values(2001,102,'Colorado')
Insert Into tblcountryState Values(2002,102,'Delaware')
Insert Into tblcountryState Values(2003,102,'Georgia')
Insert Into tblcountryState Values(3001,103,'Punjap')
Insert Into tblcountryState Values(3002,103,'Baluchistan')
Insert Into tblcountryState Values(3003,103,'Sind')
Insert Into tblstateCity Values(11,1001,'Kanpur')
Insert Into tblstateCity Values(12,1001,'Varanasi')
Insert Into tblstateCity Values(21,1002,'Kochi')
Insert Into tblstateCity Values(22,1002,' Thiruvananthapuram ')
Insert Into tblstateCity Values(31,1003,'Jammu')
Insert Into tblstateCity Values(32,1003,'Manali')
Insert Into tblstateCity Values(41,2001,'Alabama')
Insert Into tblstateCity Values(42,2001,'Arizona')
Insert Into tblstateCity Values(51,2002,'Bellefonte')
Insert Into tblstateCity Values(52,2002,'Felton')
Insert Into tblstateCity Values(61,2003,'Rustavi')
Insert Into tblstateCity Values(62,2003,'Kobulati')
Insert Into tblstateCity Values(71,3001,'Lahore')
Insert Into tblstateCity Values(72,3001,'Faisalabad')
Insert Into tblstateCity Values(81,3002,'Quetta')
Insert Into tblstateCity Values(82,3002,'Nasirabad')
Insert Into tblstateCity Values(91,3003,'Krachi')
Insert Into tblstateCity Values(92,3003,'Mirpur khas')
select * from tblCountry
select * from tblcountryState
select * from tblstateCity
WWW and Web Browswer.pdf
    7.5 MB
  Download NIELIT CCC Notes Study material in PDF
  Social Networking.pdf
    2.2 MB
  👆👆👆Download NIELIT CCC Notes Study material in PDF👆👆
  Making Small Presentations.pdf
    18.5 MB
  👆👆👆Download NIELIT CCC Notes Study material in PDF👆👆
  Introduction to GUI Based Operating System.pdf
    21.2 MB
  👆👆👆Download NIELIT CCC Notes Study material in PDF👆👆
  Introduction to Computer.pdf
    15.5 MB
  👆👆👆Download NIELIT CCC Notes Study material in PDF👆👆
  Elements of Word Processing.pdf
    20.3 MB
  👆👆👆Download NIELIT CCC Notes Study material in PDF👆👆
  Comuter Communication and Internet.pdf
    8.5 MB
  👆👆👆Download NIELIT CCC Notes Study material in PDF👆👆