Asp.net Class Library

Collection of classes that provide standard functionality to execute common tasks (email services, database services, file system services, etc). The Class Library is organized by sections called Namespaces.

To include a Namespace in your application define as following:

<%@ Import Namespace=”System.Data” %>

System: Contains classes that define commonly used value and reference data types, events and event handlers, attributes and processing exceptions.

System.Web.UI.WebControls: Contains classes that allow creating web server controls on a Web page.

System.Web.UI.HTMLInput: Contains classes that allow creating HTML server controls on a Web page.

Microsoft.VisualBasic: Contains classes that support compilation and code generation using the Visual Basic language.

Function	Arguments	Return	Details
IsNumeric()	Value to check	Boolean	Checks if the value is a number. If not it return False, if it a number it returns True
IsDate()	Date to check	Boolean	Checks if the date is a valid format. If not it return False, if it a number it returns True
Trim()	Value to trim	String	Removes blank spaces before and after the value
Len()	Value to check	Integer	Count the number of characters inside the value
CInt()	Value to convert	Integer	Converts a value into a Integer number
CLng()	Value to convert	Long	Converts a value into a Long number
Replace()	Value, original, replacement	String	Replaces string inside a value
InStr()	Value, character	Integer	Find the position of the character in the value

System.Data: Contains classes to build data sources for efficiently manage data.

Classes	Arguments	Methods	Details
DataSet	--	--	In-memory cache of tables
DataTable	TableName	Rows.Count Rows(index).item(“Column”)	In-memory table
DataColumn	Column Name Column Type Column Index		Structural definition of a DataTable column
DataRow	Row Index		Represents a row of data in a DataTable

System.Data.SqlClient: Contains classes to access data in SQL Server.

Classes	Arguments	Methods/Properties	Details
SqlConnection	Server Database UID PWD	Open() Close()	Represents a connection to SQL Server database
SqlCommand	Query SqlConnection	ExecuteNonQuery() ExecuteReader() ExecuteScalar()	Update, insert, delete Select multiple values Select single value
SqlDataReader	--	Item(columname) Close()	Gets a column value Closes the Object
SqlDataAdapter	Query SqlConnection	Fill(DataTable)	Represents a select query that fills a DataSet/DataTable with the query results.

System.Web.Mail: Contain a class to send emails and member functions and properties:

Class	Properties	Functions
MailMessage	From To Subject BodyFormat Body SmtpServer