Wednesday, November 5, 2014

DataGridView Windows Forms Control

Windows Forms > DataGridView Control

You can use a DataGridView control to display data with or without an underlying data source.
DataGridView contains cells, rows, columns, and borders.
Without specifying a data source, you can create columns and rows that contain data and add them directly to the DataGridView using the Rows and Columns properties.

HyperLink ASP.NET Example

ASP.NET > System.Web > Web Controls > HyperLink

Displays a link to another Web page.

Events

onClick

Example

<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/WebForm1.aspx">HyperLink</asp:HyperLink>

Web Controls ASP.NET

ASP.NET > System.Web > Web Controls

Web server controls run on the server.

HyperLink

ASP.NET Hyperlink OnClick Code Behind

ASP.NET > System.Web > Web Controls > > onClick

Script

<script br="" gt="" language="javascript" type="text/javascript">

function onClick(obj) {

}
lgt;/script>

C# Code behind

HyperLink1.Attributes.Add("onclick", "return onClick(this)");

Tuesday, November 4, 2014

Transact-SQL SQL Server

SQL Server > Transact-SQL

Transact-SQL is Microsoft's proprietary extension to SQL (Structured Query Language).
All applications that communicate with SQL Server use Transact-SQL to send statements to the server, regardless of the user interface of the application.

SET Statements

Mnagements Commands

Kill