ASP.NET - The Hashtable Object The Hashtable object contains items in key/value pairs. Try it Yourself - Examples Hashtable RadiobuttonList 1 Hashtable RadiobuttonList 2 Hashtable DropDownList Create a Hashtable The Hashtable object contains items in key/value pairs.…[ More ]

ASP.NET - The ArrayList Object The ArrayList object is a collection of items containing a single data value. Try it Yourself - Examples ArrayList DropDownList ArrayList RadioButtonList Create an ArrayList The ArrayList object is a collection of items containing a si…[ More ]

ASP.NET - Data Binding We may use data binding to fill lists with selectable items from an imported data source, like a database, an XML file, or a script. Data Binding The following controls are list controls which support data binding: asp:RadioButtonList asp:CheckBoxList asp:D…[ More ]

ASP.NET - The Button Control The Button control is used to display a push button. The Button Control The Button control is used to display a push button. The push button may be a submit button or a command button. By default, this control is a submit button. A submit button does no…[ More ]

ASP .NET - The TextBox Control The TextBox control is used to create a text box where the user can input text. The TextBox Control The TextBox control is used to create a text box where the user can input text. The TextBox control's attributes and properties are listed in our web c…[ More ]

ASP .NET Maintaining the ViewState You may save a lot of coding by maintaining the ViewState of the objects in your Web Form. Maintaining the ViewState When a form is submitted in classic ASP, all form values are cleared. Suppose you have submitted a form with a lot of information a…[ More ]

ASP.NET Web Forms All server controls must appear within a

tag, and the tag must contain the runat="server" attribute. ASP.NET Web Forms All server controls must appear within a tag, and the tag must contain the runat="server" attribute. The runat="server…[ More ]

ASP.NET - Events An Event Handler is a subroutine that executes code for a given event. ASP.NET - Event Handlers Look at the following code: <%lbl1.Text="The date and time is " & now()%>

[ More ]

ASP.NET - Server Controls Server controls are tags that are understood by the server. Limitations in Classic ASP The listing below was copied from the previous chapter:

Hello W3Schools!

<%Response.Write(now())%>

[ More ]

ASP.NET - Web Pages A simple ASP.NET page looks just like an ordinary HTML page. HelloSchools To start learning ASP.NET, we will construct a very simple HTML page that will display "Hello W3Schools" in an Internet browser like this: HelloSchools! HelloSchool in HTML …[ More ]

ASP.NET Installing ASP.NET is easy to install. Just follow the instructions below. What You Need If you have a Beta version of ASP.NET installed, we recommend that you completely uninstall it! Or even better: start with a fresh Windows 2000 or XP installation! Windows 2000 or XP …[ More ]

ASP.NET vs. ASP ASP.NET has better language support, a large set of new controls, XML-based components, and better user authentication. ASP.NET provides increased performance by running compiled code. ASP.NET code is not fully backward compatible with ASP. New in ASP.NET Better la…[ More ]

ASP.NET Introduction What You Should Already Know Before you continue you should have a basic understanding of the following: WWW, HTML, XML and the basics of building Web pages Scripting languages like JavaScript or VBScript The basics of server side scripting like ASP or PHP If yo…[ More ]

SQL Hosting SQL Hosting If you want your web site to be able to store and display data from a database, your web server should have access to a database system that uses the SQL language. If your web server will be hosted by an Internet Service Provider (ISP), you will have to look fo…[ More ]

SQL Quick Reference SQL Statement Syntax AND / OR SELECT column_name(s)FROM table_nameWHERE conditionAND|OR condition ALTER TABLE ALTER TABLE table_name ADD column_name datatype or ALTER TABLE table_name DROP COLUMN column_name AS (alias) SELECT column_name AS column_al…[ More ]

SQL FORMAT() Function The FORMAT() Function The FORMAT() function is used to format how a field is to be displayed. SQL FORMAT() Syntax SELECT FORMAT(column_name,format) FROM table_name Parameter Description column_name Required. The field to be formatted. format Re…[ More ]

SQL NOW() Function The NOW() Function The NOW() function returns the current system date and time. SQL NOW() Syntax SELECT NOW() FROM table_name SQL NOW() Example We have the following "Products" table: Prod_Id ProductName Unit UnitPrice 1 Jarlsberg 1000 g 10.45…[ More ]

SQL ROUND() Function The ROUND() Function The ROUND() function is used to round a numeric field to the number of decimals specified. SQL ROUND() Syntax SELECT ROUND(column_name,decimals) FROM table_name Parameter Description column_name Required. The field to round. …[ More ]

SQL LEN() Function The LEN() Function The LEN() function returns the length of the value in a text field. SQL LEN() Syntax SELECT LEN(column_name) FROM table_name SQL LEN() Example We have the following "Persons" table: P_Id LastName FirstName Address City 1 Hans…[ More ]

SQL MID() Function The MID() Function The MID() function is used to extract characters from a text field. SQL MID() Syntax SELECT MID(column_name,start[,length]) FROM table_name Parameter Description column_name Required. The field to extract characters from start R…[ More ]