Thursday, November 6, 2014

Lambda Expressions in a Query C#

C# > Operators > Lambda > Query

We use lambda expressions in method calls not directly in query syntax.

Simple Example

int[] wages = { 1000, 1200, 1500, 1800, 2000, 2500 };
int highWagesCount = wages.Where(n => n >= 2000).Count();

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