Coder Baba

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

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.

😂😅😂