Syed Akbar Ali

Introduction: ASP.NET 2.0 Folders

ASP.NET 2.0 allows us to create some folders via right clicking project. But lots of people are don't know why we need to create that folder.

Here are the description for the each folder in asp.net 2.0 that we have to create for diffrent purpose.

App_Code

App_code folder contains the code files for the classes, structures, enums etc. It also contains .wsdl files for web services. Typed data set files are also reside in this folder.Any of this item automatically available to whole application.

App_Themes

ASP.NET supports themes to enable visual styles on web page. This folder contains the themes skin and .css(Cascading Style Sheet) files.

App_Data

App_Data contains the database for a application and other data files like .mdf, xml, text and .csv files used in web application.This folder are used to stored data related entities.

App_GlobalResources

ASP.NET allows us to create resource files. There are two types of resources files one is global and another one is local. The global resources files are available to whole application. While local resources files are available to specific page only. This folder store global resource files with .resx extensions.

App_LocalResources

This folder stored local resources files.

App_WebReferences

This folder store web reference of web service from a asp.net 2.0 application. You can web reference via right click project in solutions explorer and then click add web reference.

App_Browsers

The App_Browsers folder holds browser files, which are XML files used to describe characteristics and capabilities of these browsers

Bin

This folder contains assembly files for controls and web pages.Assembly files are basically a .dll files. Any .dll files found this folder automatically links to whole application.

This folder structure are basically supported by asp.net 2.0. You can also create your own folder structure by right click project name in solution explorer. and add new folder

Introduction: What is DML, DDL, DCL and TCL in SQL Server

DML

DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database.

Examples: SELECT, UPDATE, INSERT statements

DDL

DDL is abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in database.

Examples: CREATE, ALTER, DROP statements

DCL

DCL is abbreviation of Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it.

Examples: GRANT, REVOKE statements

TCL

TCL is abbreviation of Transactional Control Language. It is used to manage different transactions occurring within a database.

Examples: COMMIT, ROLLBACK statements

 

This article originally posted by Pinal Dave in his blog. I just want to keep a copy in my blog bcoz some time I am getting confused in DCL, DML, DDL .. So, I can easily refer if its in my blog.

Thanks to Pinal Dave.

Get free Visual Studio 2008 and .NET Framework Training kit

Today I found this training kit at Microsoft site. It is useful for all vs 2008 learners  .. Get it here.

This kit includes presentations, labs and demos.