DotNet

Matrix Program

2011-11-24T23:32:00.000-08:00

This is a matrix program.Execute it and see the Matrix

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace m7tr1x
{
class Program
{
static void Main(string[] args)
{
Console.Title = "Site4Dotnet(MaHi)";
Console.ForegroundColor = ConsoleColor.DarkGreen;
Console.WindowLeft = Console.WindowTop = 0;
Console.WindowHeight = Console.BufferHeight = Console.LargestWindowHeight;
Console.WindowWidth = Console.BufferWidth = Console.LargestWindowWidth;

Console.WriteLine("press any key");
Console.ReadKey();

Console.CursorVisible = false;
int width, height;
int[] y;
int[] l;
Initialize(out width, out height, out y, out l);
int ms;

while (true)
{
DateTime t1 = DateTime.Now;
MatrixStep(width, height, y, l);
ms = 10 - (int)((TimeSpan)(DateTime.Now - t1)).TotalMilliseconds;

if (ms > 0)
System.Threading.Thread.Sleep(ms);

if (Console.KeyAvailable)
if (Console.ReadKey().Key == ConsoleKey.F5)
Initialize(out width, out height, out y, out l);
}
}

static bool thistime = false;

private static void MatrixStep(int width, int height, int[] y, int[] l)
{
int x;
thistime = !thistime;

for (x = 0; x < width; ++x)
{
if (x % 11 == 10)
{
if (!thistime)
continue;

Console.ForegroundColor = ConsoleColor.White;
}
else
{
Console.ForegroundColor = ConsoleColor.DarkGreen;
Console.SetCursorPosition(x, inBoxY(y[x] - 2 - (l[x] / 40 * 2), height));
Console.Write(R);
Console.ForegroundColor = ConsoleColor.Green;
}
Console.SetCursorPosition(x, y[x]);
Console.Write(R);
y[x] = inBoxY(y[x] + 1, height);
Console.SetCursorPosition(x, inBoxY(y[x] - l[x], height));
Console.Write(' ');
}
}

private static void Initialize(out int width, out int height, out int[] y, out int[] l)
{
int h1;
int h2 = (h1 = (height = Console.WindowHeight) / 2) / 2;
width = Console.WindowWidth - 1;
y = new int[width];
l = new int[width];
int x;
Console.Clear();
for (x = 0; x < width; ++x)
{
y[x] = r.Next(height);
l[x] = r.Next(h2 * ((x % 11 != 10) ? 2 : 1), h1 * ((x % 11 != 10) ? 2 : 1));
}
}

static Random r = new Random();

static char R
{
get
{
int t = r.Next(10);
if (t <= 2)
return (char)('0' + r.Next(10));
else if (t <= 4)
return (char)('a' + r.Next(27));
else if (t <= 6)
return (char)('A' + r.Next(27));
else
return (char)(r.Next(32, 255));
}
}

public static int inBoxY(int n, int height)
{
n = n % height;
if (n < 0)
return n + height;
else
return n;
}
}
}

XML Basics

2011-11-23T23:05:00.000-08:00

What is XML?

XML (eXtensible Markup Language) is a meta-language; that is, it is a language in which other languages are created. In XML, data is "marked up" with tags, similar to HTML tags. In fact, the latest version of HTML, called XHTML, is an XML-based language, which means that XHTML follows the syntax rules of XML.

XML is used to store data or information. This data might be intended to be by read by people or by machines. It can be highly structured data such as data typically stored in databases or spreadsheets, or loosely structured data, such as data stored in letters or manuals.

XML Benefits

Initially XML received a lot of excitement, which has now died down some. This isn't because XML is not as useful, but rather because it doesn't provide the Wow! factor that other technologies, such as HTML do. When you write an HTML document, you see a nicely formatted page in a browser - instant gratification. When you write an XML document, you see an XML document - not so exciting. However, with a little more effort, you can make that XML document sing!

This section discusses some of the major benefits of XML.

XML Holds Data, Nothing More

XML does not really do much of anything. Rather, developers can create XML-based languages that store data in a structure way. Applications can then use this data to do any number of things.

XML Separates Structure from Formatting

One of the difficulties with HTML documents, word processor documents, spreadsheets, and other forms of documents is that they mix structure with formatting. This makes it difficult to manage content and design, because the two are intermingled.

As an example, in HTML, there is a <u> tag used for underlining text. Very often, it is used for emphasis, but it also might be used to mark a book title. It would be very difficult to write an application that searched through such a document for book titles.

In XML, the book titles could be placed in <book_title> tags and the emphasized text could be place in <em> tags. The XML document does not specify how the content of either tag should be displayed. Rather, the formatting is left up to an external stylesheet. Even though the book titles and emphasized text might appear the same, it would be relatively straight forward to write an application that finds all the book titles. It would simply look for text in<book_title> tags. It also becomes much easier to reformat a document; for example, to change all emphasized text to be italicized rather than underlined, but leave book titles underlined.

XML Promotes Data Sharing

Very often, applications that hold data in different structures must share data with one another. It can be very difficult for a developer to map the different data structures to each other. XML can serve as a go between. Each application's data structure is mapped to an agreed-upon XML structure. Then all the applications share data in this XML format. Each application only has to know two structures, its own and the XML structure, to be able to share data with many other applications.

XML is Human-Readable

XML documents are (or can be) read by people. Perhaps this doesn't sound so exciting, but compare it to data stored in a database. It is not easy to browse through a database and read different segments of it as you would a text file. Take a look at the XML document below.

Code Sample: XMLBasics/Demos/Paul.xml

<?xml version="1.0"?>
<person>
 <name>
  <firstname>Paul</firstname>
  <lastname>McCartney</lastname>
 </name>
 <job>Singer</job>
 <gender>Male</gender>
</person>

Code Explanation

It is not hard to tell from looking at this that the XML is describing a person named Paul McCartney, who is a singer and is male.
Do people read XML documents? Programmers do (hey, we're people too!). And it is easier for us if the documents we work with are easy to read.

XML is Free

XML doesn't cost anything to use. It can be written with a simple text editor or one of the many freely available XML authoring tools, such as XML Notepad. In addition, many web development tools, such as Dreamweaver and Visual Studio .NET have built-in XML support. There are also many free XML parsers, such as Microsoft's MSXML (downloadable from microsoft.com) and Xerces (downloadable at apache.org).

XML in Practice

Content Management

Almost all of the leading content management systems use XML in one way or another. A typical use would be to store a company's marketing content in one or more XML documents. These XML documents could then be transformed for output on the Web, as Word documents, as PowerPoint slides, in plain text, and even in audio format. The content can also easily be shared with partners who can then output the content in their own formats.

Storing the content in XML makes it much easier to manage content for two reasons.

Content changes, additions, and deletions are made in a central location and the changes will cascade out to all formats of presentation. There is no need to be concerned about keeping the Word documents in sync with the website, because the content itself is managed in one place and then transformed for each output medium.
Formatting changes are made in a central location. To illustrate, suppose a company had many marketing web pages, all of which were produced from XML content being transformed to HTML. The format for all of these pages could be controlled from a single XSLT and a sitewide formatting change could be made modifying that XSLT.

Web Services

XML Web services are small applications or pieces of applications that are made accessible on the Internet using open standards based on XML. Web services generally consist of three components:

SOAP - an XML-based protocol used to transfer Web services over the Internet.
WSDL (Web Services Description Language) - an XML-based language for describing a Web service and how to call it.
Universal Discovery Description and Integration (UDDI) - the yellow pages of Web services. UDDI directory entries are XML documents that describe the Web services a group offers. This is how people find available Web services.

RDF / RSS Feeds

RDF (Resource Description Framework) is a framework for writing XML-based languages to describe information on the Web (e.g, web pages). RSS (RDF Site Summary) is an implementation of this framework; it is a language that adheres to RDF and is used to describe web content. Website publishers can use RSS to make content available as a "feed", so that web users can access some of their content without actually visiting their site. Often, RSS is used to provide summaries with links to the company's website for additional information.

XML Documents

An XML document is made up of the following parts.

An optional prolog.
A document element, usually containing nested elements.
Optional comments or processing instructions.

The Prolog

The prolog of an XML document can contain the following items.

An XML declaration
Processing instructions
Comments
A Document Type Declaration

The XML Declaration

The XML declaration, if it appears at all, must appear on the very first line of the document with no preceding white space. It looks like this.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

This declares that the document is an XML document. The version attribute is required, but the encoding andstandalone attributes are not. If the XML document uses any markup declarations that set defaults for attributes or declare entities then standalone must be set to no.

Processing Instructions

Processing instructions are used to pass parameters to an application. These parameters tell the application how to process the XML document. For example, the following processing instruction tells the application that it should transform the XML document using the XSL stylesheet beatles.xsl.

<?xml-stylesheet href="beatles.xsl" type="text/xsl"?>

As shown above, processing instructions begin with and <? end with ?>.

Comments

Comments can appear throughout an XML document. Like in HTML, they begin with .

<!--This is a comment-->

A Document Type Declaration

The Document Type Declaration (or DOCTYPE Declaration) has three roles.

It specifies the name of the document element.
It may point to an external Document Type Definition (DTD).
It may contain an internal DTD.

The DOCTYPE Declaration shown below simply states that the document element of the XML document is beatles.

<!DOCTYPE beatles>

If a DOCTYPE Declaration points to an external DTD, it must either specify that the DTD is on the same system as the XML document itself or that it is in some public location. To do so, it uses the keywords SYSTEM and PUBLIC. It then points to the location of the DTD using a relative Uniform Resource Indicator (URI) or an absolute URI. Here are a couple of examples.

Syntax

<!--DTD is on the same system as the XML document-->
<!DOCTYPE beatles SYSTEM "dtds/beatles.dtd">

Syntax

<!--DTD is publicly available-->
<!DOCTYPE beatles PUBLIC "-//Webucator//DTD Beatles 1.0//EN"
     "http://www.webucator.com/beatles/DTD/beatles.dtd">

As shown in the second declaration above, public identifiers are divided into three parts:

An organization (e.g, Webucator)
A name for the DTD (e.g, Beatles 1.0)
A language (e.g, EN for English)

Elements

Every XML document must have at least one element, called the document element. The document element usually contains other elements, which contain other elements, and so on. Elements are denoted with tags. Let's look again at the Paul.xml.

Code Sample: XMLBasics/Demos/Paul.xml

<?xml version="1.0"?>
<person>
 <name>
  <firstname>Paul</firstname>
  <lastname>McCartney</lastname>
 </name>
 <job>Singer</job>
 <gender>Male</gender>
</person>

Code Explanation

The document element is person. It contains three elements: name, job and gender. Further, the name element contains two elements of its own: firstname and lastname. As you can see, XML elements are denoted with tags, just as in HTML. Elements that are nested within another element are said to be children of that element.

Empty Elements

Not all elements contain other elements or text. For example, in XHTML, there is an img element that is used to display an image. It does not contain any text or elements within it, so it is called an empty element. In XML, empty elements must be closed, but they do not require a separate close tag. Instead, they can be closed with a forward slash at the end of the open tag as shown below.

<img src="images/paul.jpg"/>

The above code is identical in funciton to the code below.

<img src="images/paul.jpg"></img>

Attributes

XML elements can be further defined with attributes, which appear inside of the element's open tag as shown below.

Syntax

<name title="Sir">
 <firstname>Paul</firstname>
 <lastname>McCartney</lastname>
</name>

CDATA

Sometimes it is necessary to include sections in an XML document that should not be parsed by the XML parser. These sections might contain content that will confuse the XML parser, perhaps because it contains content that appears to be XML, but is not meant to be interpreted as XML. Such content must be nested in CDATA sections. The syntax for CDATA sections is shown below.

Syntax

<![CDATA[
 This section will not get parsed
 by the XML parser.
]]>

White Space

In XML data, there are only four white space characters.

Tab
Line-feed
Carriage-return
Single space

There are several important rules to remember with regards to white space in XML.

White space within the content of an element is significant; that is, the XML processor will pass these characters to the application or user agent.
White space in attributes is normalized; that is, neighboring white spaces are condensed to a single space.
White space in between elements is ignored.

xml:space Attribute

The xml:space attribute is a special attribute in XML. It can only take one of two values: default and preserve. This attribute instructs the application how to treat white space within the content of the element. Note that the application is not required to respect this instruction.

XML Syntax Rules

XML has relatively straightforward, but very strict, syntax rules. A document that follows these syntax rules is said to be well-formed.

There must be one and only one document element.
Every open tag must be closed.
If an element is empty, it still must be closed.
- Poorly-formed: <tag>
- Well-formed: <tag></tag>
- Also well-formed: <tag />
Elements must be properly nested.
- Poorly-formed: <a><b></a></b>
- Well-formed: <a><b></b></a>
Tag and attribute names are case sensitive.
Attribute values must be enclosed in single or double quotes.

Special Characters

There are five special characters that can not be included in XML documents. These characters are replaced with predefined entity references as shown in the table below.

Special Characters
Character	Entity Reference
<	<
>	>
&	&
"	"
'	'

Creating a Simple XML File

The following is relatively simple XML file describing the Beatles.

Code Sample: XMLBasics/Demos/Beatles.xml

<?xml version="1.0"?>
<beatles>
 <beatle link="http://www.paulmccartney.com">
  <name>
   <firstname>Paul</firstname>
   <lastname>McCartney</lastname>
  </name>
 </beatle>
 <beatle link="http://www.johnlennon.com">
  <name>
   <firstname>John</firstname>
   <lastname>Lennon</lastname>
  </name>
 </beatle>
 <beatle link="http://www.georgeharrison.com">
  <name>
   <firstname>George</firstname>
   <lastname>Harrison</lastname>
  </name>
 </beatle>
 <beatle link="http://www.ringostarr.com">
  <name>
   <firstname>Ringo</firstname>
   <lastname>Starr</lastname>
  </name>
 </beatle>
 <beatle link="http://www.webucator.com" real="no">
  <name>
   <firstname>Nat</firstname>
   <lastname>Dunn</lastname>
  </name>
 </beatle>
</beatles>

Exercise: Editing an XML File

In this exercise, you will be modifying an existing XML file.

Open XMLBasics/Exercises/Xml101.xml
Add a required prerequisite: "Experience with computers".
Add the following to the topics list:
- XML Documents
  - The Prolog Elements
  - Attributes
  - CDATA
  - XML Syntax Rules
  - Special Characters
- Creating a Simple XML File
Add a modifications element that shows the modifications you've made.

Code Sample: XMLBasics/Exercises/Xml101.xml

<?xml version="1.0"?>
<course>
 <head>
  <title>Introduction to XML</title>
  <course_num>XML101</course_num>
  <course_length>3 days</course_length>
 </head>
 <body>
  <prerequisites>
   <prereq>Experience with Word Processing</prereq>
   <prereq optional="true">Experience with HTML</prereq>
   <!-- Add a required prerequisite: "Experience with computers"  -->
  </prerequisites>
  <outline>
   <topics>
    <topic>XML Basics
     <topics>
      <topic>What is XML?</topic>
      <topic>XML Benefits
       <topics>
        <topic>XML Holds Data, Nothing More</topic>
        <topic>XML Separates Structure from Formatting</topic>
        <topic>XML Promotes Data Sharing</topic>
        <topic>XML is Human-Readable</topic>
        <topic>XML is Free</topic>
       </topics>
      </topic>
      <!-- 
    Add the following to the topics list ("XML Documents" and

    "Creating a Simple XML File" should be siblings of "What

      is XML?" and "XML Benefits"):

       
       -XML Documents
        -The Prolog
        -Elements
        -Attributes
        -CDATA
        -XML Syntax Rules
        -Special Characters
       -Creating a Simple XML File
       -->
     </topics>
    </topic>
   </topics>
  </outline>
 </body>
 <foot>
  <creator>Josh Lockwood</creator>
  <date_created>2002-07-25</date_created>
  <modifications madeby="Colby Germond" date="2003-05-05">
   <modification type="insert">Added HTML prerequisite</modification>
   <modification type="edit">Fixed some typos</modification>
  </modifications>
  <!-- 
   Add a modifications element that shows the modifications you've made.
   -->
 </foot>
</course>

XML Basics Conclusion

In this lesson of the XML tutorial, you have learned the benefits of XML, how XML is used, and how to write a well-formed XML document.

CLR Stored Procedure

2011-11-23T00:47:00.000-08:00

SQL SERVER – Introduction to CLR – Simple Example of CLR Stored Procedure

CLR is abbreviation of Common Language Runtime. In SQL Server 2005 and later version of it database objects can be created which are created in CLR. Stored Procedures, Functions, Triggers can be coded in CLR. CLR is faster than T-SQL in many cases. CLR is mainly used to accomplish task which are not possible by T-SQL or can use lots of resources. CLR can be usually implemented where there is intense string operation, thread management or iteration methods which can be complicated for T-SQL. Implementing CLR provides more security to Extended Stored Procedure.

Let us create one very simple CLR where we will print current system datetime.

1) Open Microsoft Visual Studio >> Click New Project >> Select Visual C# >> Database >> SQL Server Project

2) Either choose from existing database connection as reference or click on Add New Reference. In my example I have selected Add New Reference.

3) If you have selected existing reference skip to next step or add database reference as displayed in image.

4) Once database reference is added following project will be displayed in Solution Explorer. Right click on Solution Explorer >> Click on Add >> Stored Procedure.

5) Add new stored procedure template from following screen.

6) Once template added it will look like following image.

7) Now where it suggest to //Put your code here. Replace it with code displayed in the image. Once the code is complete do following two steps.
a) Click on menu bar >> Build >> Build ProjectName
b) Click on menu bar >> Build >> Deploy ProjectName
Building and Deploying project should give successful message.

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;

public partial class StoredProcedures
{
[Microsoft.SqlServer.Server.SqlProcedure]
public static void CLRSPTest()
{
SqlPipe sp;
sp = SqlContext.Pipe;
String strCurrentTime = “Current System DateTime is: “
+ System.DateTime.Now.ToString();
sp.Send(strCurrentTime);
}
};
8) Now open SQL Server Management Studio and run following script in Query Editor. It should return current system datetime. Running it again the time will change.

USE AdventureWorks
GOEXEC dbo.CLRSPTest
GO

WCF Architecture

2011-11-21T21:50:00.000-08:00

The following figure illustrates the major components of WCF.

Figure 1: WCF Architecture

Contracts

Contracts layer are next to that of Application layer. Developer will directly use this contract to develop the service. We are also going to do the same now. Let us see briefly what these contracts will do for us and we will also know that WCF is working on message system.

Service contracts

- Describe about the operation that service can provide. Example, Service provided to know the temperature of the city based on the zip code, this service we call as Service contract. It will be created using Service and Operational Contract attribute.

Data contract

- It describes the custom data type which is exposed to the client. This defines the data types, are passed to and from service. Data types like int, string are identified by the client because it is already mention in XML schema definition language document, but custom created class or datatype cannot be identified by the client e.g. Employee data type. By using DataContract we can make client aware that we are using Employee data type for returning or passing parameter to the method.

Message Contract

- Default SOAP message format is provided by the WCF runtime for communication between Client and service. If it is not meeting your requirements then we can create our own message format. This can be achieved by using Message Contract attribute.

Policies and Binding

- Specify conditions required to communicate with a service e.g security requirement to communicate with service, protocol and encoding used for binding.

Service Runtime

- It contains the behaviors that occur during runtime of service.

Throttling Behavior- Controls how many messages are processed.
Error Behavior - Specifies what occurs, when internal error occurs on the service.
Metadata Behavior - Tells how and whether metadata is available to outside world.
Instance Behavior - Specifies how many instance of the service has to be created while running.
Transaction Behavior - Enables the rollback of transacted operations if a failure occurs.
Dispatch Behavior - Controls how a message is processed by the WCF Infrastructure.

Messaging

- Messaging layer is composed of channels. A channel is a component that processes a message in some way, for example, by authenticating a message. A set of channels is also known as a channel stack. Channels are the core abstraction for sending message to and receiving message from an Endpoint. Broadly we can categories channels as

Transport Channels

Handles sending and receiving message from network. Protocols like HTTP, TCP, name pipes and MSMQ.

Protocol Channels

Implements SOAP based protocol by processing and possibly modifying message. E.g. WS-Security and WS-Reliability.

Activation and Hosting

- Services can be hosted or executed, so that it will be available to everyone accessing from the client. WCF service can be hosted by following mechanism

Internet information Service provides number of advantages if a Service uses Http as protocol. It does not require Host code to activate the service, it automatically activates service code.

Windows Activation Service

(WAS) is the new process activation mechanism that ships with IIS 7.0. In addition to HTTP based communication, WCF can also use WAS to provide message-based activation over other protocols, such as TCP and named pipes.

Self-Hosting

WCF service can be self hosted as console application, Win Forms or WPF application with graphical UI.

Windows Service

WCF can also be hosted as a Windows Service, so that it is under control of the Service Control Manager (SCM).

FileStream Open File [C#]

2011-11-21T04:52:00.000-08:00

This example shows how to open files for reading or writing, how to load and save files using FileStream in C#. To open file create instance of FileStream class with FileMode and FileAccess enumerations as parameters.

FileStream typical use
This is typical code when opening file using FileStream. It's important to always close the stream. If you don't close the stream it can take a minute to be file again accessible (it will wait to garbage collector to free the FileStream instance and close the file).

[C#]
using System.IO;

FileStream fileStream = new FileStream(@"c:\file.txt", FileMode.Open);
try
{
// read from file or write to file
}
finally
{
fileStream.Close();
}

Open file examples
Following examples show the most common cases how to open a file for reading or writing or how to create a file.

[C#] Open existing file for read and write.
FileStream fileStream = new FileStream(@"c:\file.txt", FileMode.Open);

[C#] Open existing file for reading.
FileStream fileStream = new FileStream(@"c:\file.txt", FileMode.Open, FileAccess.Read);

[C#] Open existing file for writing.
FileStream fileStream = new FileStream(@"c:\file.txt", FileMode.Open, FileAccess.Write);

[C#] Open file for writing (with seek to end), if the file doesn't exist create it.
FileStream fileStream = new FileStream(@"c:\file.txt", FileMode.Append);

[C#] Create new file and open it for read and write, if the file exists overwrite it.
FileStream fileStream = new FileStream(@"c:\file.txt", FileMode.Create);

[C#] Create new file and open it for read and write, if the file exists throw exception.
FileStream fileStream = new FileStream(@"c:\file.txt", FileMode.CreateNew);

SQL - Join

2011-11-18T02:24:00.000-08:00

SQL JOIN joins together two tables on a matching table column, ultimately forming one single temporary table. The key word here is temporary. The tables themselves remain intact, and running a JOIN query does not in any way change the data or table structure. JOIN is another way to select specific data from two or more relational tables.

In order to perform a JOIN query, we need a few pieces of information: the name of the table and table column we want to join on and a condition to meet for the JOIN to happen. This should sound a little confusing as there is much going on in a JOIN query, so let's take a look at an example:

SQL Join Query Code:

USE mydatabase;

SELECT *
FROM orders
JOIN inventory
ON orders.product = inventory.product;

SQL Join Results:

id	customer	day_of_order	product	quantity	id	product	quantity	price
1	Tizag	2008-08-01 00:00:00.000	Hanging Files	11	5	Hanging Files	33	14.99
2	Tizag	2008-08-01 00:00:00.000	Stapler	3	4	Stapler	3	7.99
3	A+Maintenance	2008-08-16 00:00:00.000	Hanging Files	14	5	Hanging Files	33	14.99
4	Gerald Garner	2008-08-15 00:00:00.000	19" LCD Screen	5	1	19" LCD Screen	25	179.99
5	Tizag	2008-07-25 00:00:00.000	19" LCD Screen	5	1	19" LCD Screen	25	179.99
6	Tizag	2008-07-25 00:00:00.000	HP Printer	4	2	HP Printer	9	89.99

The line beginning with JOIN (Line 4) is where we tell SQL which table we would like to join. The next line (Line 5) is a different story. Here is where we have specified the condition to JOIN ON. In this case, both tables have identical product columns which makes them an ideal target for a join. Basically we are temporarily merging the tables connecting them where they match, the product column.

This type of join matches values from one table column with a corresponding value in another table and uses that match to merge the tables together. In our make-believe store world, this let's us join the inventory table with the orders table to show us all the items we currently have in stock for our customers and also the price of each item.

Let's rework this query a bit and strip away a few of the table columns to make our results easier to read and understand. We will replace the (*) parameter with a list containing only the table columns we are interested in viewing.

SQL Join:

USE mydatabase;

SELECT orders.customer,
orders.day_of_order,
orders.product,
orders.quantity as number_ordered,
inventory.quantity as number_instock,
inventory.price
FROM orders
JOIN inventory
ON orders.product = inventory.product

SQL Results:

customer	day_of_order	product	number_ordered	number_instock	price
Tizag	2008-08-01 00:00:00.000	Hanging Files	11	33	14.99
Tizag	2008-08-01 00:00:00.000	Stapler	3	3	7.99
A+Maintenance	2008-08-16 00:00:00.000	Hanging Files	14	33	14.99
Gerald Garner	2008-08-15 00:00:00.000	19" LCD Screen	5	25	179.99
Tizag	2008-07-25 00:00:00.000	19" LCD Screen	5	25	179.99
Tizag	2008-07-25 00:00:00.000	HP Printer	4	9	89.99

Since we have one column in each table named the same thing (quantity), we used AS to modify how these columns would be named when our results were returned. These results should be more satisfying and easier to read now that we have removed some of the unnecessary columns.

SQL - Right Join

RIGHT JOIN is another method of JOIN we can use to join together tables, but its behavior is slightly different. We still need to join the tables together based on a conditional statement. The difference is that instead of returning ONLY rows where a join occurs, SQL will list EVERY row that exists on the right side, (The JOINED table).

SQL - Right Join:

USE mydatabase;

SELECT *
FROM orders
RIGHT JOIN inventory
ON orders.product = inventory.product

SQL Results:

id	customer	day_of_order	product	quantity	id	product	quantity	price
4	Gerald Garner	2008-08-15 00:00:00.000	19" LCD Screen	5	1	19" LCD Screen	25	179.99
5	Tizag	2008-07-25 00:00:00.000	19" LCD Screen	5	1	19" LCD Screen	25	179.99
6	Tizag	2008-07-25 00:00:00.000	HP Printer	4	2	HP Printer	9	89.99
NULL	NULL	NULL	NULL	NULL	3	Pen	78	0.99
2	Tizag	2008-08-01 00:00:00.000	Stapler	3	4	Stapler	3	7.99
1	Tizag	2008-08-01 00:00:00.000	Hanging Files	11	5	Hanging Files	33	14.99
3	A+Maintenance	2008-08-16 00:00:00.000	Hanging Files	14	5	Hanging Files	33	14.99
NULL	NULL	NULL	NULL	NULL	6	Laptop	16	499.99

You should see a new row at the bottom of the results box with a bunch of NULL values. This is a result of the RIGHT JOIN and is the intended result from running the query. We end up with an extra row because inside of the inventory table, the Laptop item was not joined with a product from the orders table. This just means that we have not sold a laptop as of yet and it shouldn't be much a surprise since we already know from querying the orders table in previous lessons that there have been no laptop orders so far.

By specifying RIGHT JOIN, we have told SQL to join together the tables even if no matches are found in the conditional statement. All records that exist in the table on the right side of the conditional statement (ON orders.product = inventory.product) will be returned and NULL values will be placed on the left if no matches are found.

SQL - Left Join

SQL LEFT JOIN works exactly the same way as RIGHT JOIN except that they are opposites. NULL values will appear on the right instead of the left and all rows from the table on the left hand side of the conditional will be returned.

Unfortunately, we will not be able to show a very intuitive example of a LEFT JOIN because of how our tables are structured. The orders table should always have a matching inventory item and if not, that means we are in big trouble as we could be selling items we do not carry in inventory. For good measure, here's what a LEFT JOIN would look like:

SQL Left Join:

USE mydatabase;

SELECT *
FROM orders
LEFT JOIN inventory
ON orders.product = inventory.product

SQL JOIN is intended to bring together data from two tables to form a single larger table, and often, it will paint a more detailed picture of what the data represents. By merging these two data sets, we were able to peer into our database and ensure that each item ordered so far is in stock and ready to be shipped to our customers.

Update the UI Asynchronously on a Timer

2011-11-17T04:33:00.000-08:00

<Window x:Class="WpfApplication1.Window1"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    Title="WPF" Height="100" Width="300">
    <StackPanel>
        <Button x:Name="button" Click="Button_Click">Start Timer</Button>
        <TextBlock x:Name="txtStatus">
        </TextBlock>
    </StackPanel>
</Window>

//File:Window.xaml.cs

using System;
using System.Windows;
using System.Windows.Threading;

namespace WpfApplication1
{
    public partial class Window1 : Window
    {
        private DispatcherTimer timer;

        public Window1()
        {
            InitializeComponent();
        }

        private void Button_Click(object sender, RoutedEventArgs e)
        {
            if(timer == null || !timer.IsEnabled)
            {
                timer = new DispatcherTimer();

                timer.Interval = TimeSpan.FromMilliseconds(1000);
                timer.Tick += new EventHandler(timer_Tick);

                timer.Start();
                button.Content = "Stop Timer";
            }
            else
            {
                timer.Stop();
                button.Content = "Start Timer";
            }
        }

        private void timer_Tick(object sender, EventArgs e)
        {
            txtStatus.Text = DateTime.Now.Second.ToString();
        }
    }
}

Rolling Ball Animation

2011-11-16T03:57:00.000-08:00

<Window x:Class="WpfApplication1.RollingBall"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

Title="Rolling Balls" Height="350" Width="518">

<Rectangle Fill="Gray" Width="500" Height="5"

Canvas.Top="60" />

<Ellipse x:Name="ellipse1" Width="50" Height="50"

Stroke="Blue" Canvas.Top="10" Canvas.Left="0">

<Ellipse.Fill>

</LinearGradientBrush>

</Ellipse.Fill>

<Ellipse.RenderTransform>

<RotateTransform x:Name="ellipse1Rotate"

CenterX="25" CenterY="25" />

</Ellipse.RenderTransform>

</Ellipse>

<Rectangle Fill="Gray" Width="500" Height="5"

Canvas.Top="130" />

<Ellipse x:Name="ellipse2" Width="50" Height="50"

Stroke="Red" Canvas.Top="80" Canvas.Left="0">

<Ellipse.Fill>

</LinearGradientBrush>

</Ellipse.Fill>

<Ellipse.RenderTransform>

<RotateTransform x:Name="ellipse2Rotate"

CenterX="25" CenterY="25" />

</Ellipse.RenderTransform>

</Ellipse>

<Rectangle Fill="Gray" Width="500" Height="5"

Canvas.Top="200" />

<Ellipse x:Name="ellipse3" Width="50" Height="50"

Stroke="Green" Canvas.Top="150" Canvas.Left="0">

<Ellipse.Fill>

</LinearGradientBrush>

</Ellipse.Fill>

<Ellipse.RenderTransform>

<RotateTransform x:Name="ellipse3Rotate"

CenterX="25" CenterY="25" />

</Ellipse.RenderTransform>

</Ellipse>

        <Ellipse.Fill>
          <LinearGradientBrush>
            <GradientStop Color="Purple" Offset="0.5" />
            <GradientStop Color="LightPink" Offset="0.2" />
          </LinearGradientBrush>
        </Ellipse.Fill>
        <Ellipse.RenderTransform>
          <RotateTransform x:Name="ellipse4Rotate" CenterX="25" CenterY="25" />
        </Ellipse.RenderTransform>
      </Ellipse>
    </Canvas>
  </Border>
</Window>
//File:Window.xaml.cs

using System;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;

namespace WpfApplication1
{
    public partial class RollingBall : Window
    {

        public RollingBall()
        {
            InitializeComponent();
            double nRotation = 2;

            DoubleAnimation da = new DoubleAnimation(0, 450,TimeSpan.FromSeconds(5));
            da.RepeatBehavior = RepeatBehavior.Forever;
            da.AutoReverse = true;
            ellipse1.BeginAnimation(Canvas.LeftProperty, da);

            da = new DoubleAnimation(0, nRotation,TimeSpan.FromSeconds(15));
            da.RepeatBehavior = RepeatBehavior.Forever;
            da.AutoReverse = true;
            ellipse1Rotate.BeginAnimation(RotateTransform.AngleProperty, da);

            da = new DoubleAnimation(0, 450,TimeSpan.FromSeconds(15));
            da.AccelerationRatio = 0.4;
            da.RepeatBehavior = RepeatBehavior.Forever;
            da.AutoReverse = true;
            ellipse2.BeginAnimation(Canvas.LeftProperty, da);

            da = new DoubleAnimation(0, nRotation,TimeSpan.FromSeconds(15));
            da.AccelerationRatio = 0.4;
            da.RepeatBehavior = RepeatBehavior.Forever;
            da.AutoReverse = true;
            ellipse2Rotate.BeginAnimation(RotateTransform.AngleProperty, da);

            da = new DoubleAnimation(0, 450,TimeSpan.FromSeconds(5));
            da.DecelerationRatio = 0.6;
            da.RepeatBehavior = RepeatBehavior.Forever;
            da.AutoReverse = true;
            ellipse3.BeginAnimation(Canvas.LeftProperty, da);

            da = new DoubleAnimation(0, nRotation,TimeSpan.FromSeconds(15));
            da.DecelerationRatio = 0.6;
            da.RepeatBehavior = RepeatBehavior.Forever;
            da.AutoReverse = true;
            ellipse3Rotate.BeginAnimation(RotateTransform.AngleProperty, da);

        }
    }
}

Total Of Student's Marks

2011-11-15T04:23:00.000-08:00

/* Simple Program in C# (for beginners) to input the name from the user and his marks in two subject and find the total in the two subjects. */

//Form1.designer.cs
namespace Student_Marks
{
partial class Form1
{
///

/// Required designer variable.
///

private System.ComponentModel.IContainer components = null;

///

/// Clean up any resources being used.
///

/// true if managed resources should be disposed; otherwise, false.
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}

#region Windows Form Designer generated code

///

/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///

private void InitializeComponent()
{
this.label1 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.button1 = new System.Windows.Forms.Button();
this.button2 = new System.Windows.Forms.Button();
this.textBox1 = new System.Windows.Forms.TextBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.textBox3 = new System.Windows.Forms.TextBox();
this.textBox4 = new System.Windows.Forms.TextBox();
this.button3 = new System.Windows.Forms.Button();
this.label5 = new System.Windows.Forms.Label();
this.SuspendLayout();
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(15, 56);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(75, 13);
this.label1.TabIndex = 0;
this.label1.Text = "Student Name";
//
// label2
//
this.label2.AutoSize = true;
this.label2.Location = new System.Drawing.Point(15, 102);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(42, 13);
this.label2.TabIndex = 1;
this.label2.Text = "Marks1";
//
// label3
//
this.label3.AutoSize = true;
this.label3.Location = new System.Drawing.Point(15, 148);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(42, 13);
this.label3.TabIndex = 2;
this.label3.Text = "Marks2";
//
// label4
//
this.label4.AutoSize = true;
this.label4.Location = new System.Drawing.Point(15, 194);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(37, 13);
this.label4.TabIndex = 3;
this.label4.Text = "Result";
//
// button1
//
this.button1.Location = new System.Drawing.Point(18, 227);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(61, 23);
this.button1.TabIndex = 4;
this.button1.Text = "Calculate";
this.button1.UseVisualStyleBackColor = true;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// button2
//
this.button2.Location = new System.Drawing.Point(84, 227);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(54, 23);
this.button2.TabIndex = 5;
this.button2.Text = "Clear";
this.button2.UseVisualStyleBackColor = true;
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(96, 53);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(100, 20);
this.textBox1.TabIndex = 6;
//
// textBox2
//
this.textBox2.Location = new System.Drawing.Point(96, 95);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(100, 20);
this.textBox2.TabIndex = 7;
//
// textBox3
//
this.textBox3.Location = new System.Drawing.Point(96, 141);
this.textBox3.Name = "textBox3";
this.textBox3.Size = new System.Drawing.Size(100, 20);
this.textBox3.TabIndex = 8;
//
// textBox4
//
this.textBox4.Enabled = false;
this.textBox4.Location = new System.Drawing.Point(96, 187);
this.textBox4.Name = "textBox4";
this.textBox4.Size = new System.Drawing.Size(100, 20);
this.textBox4.TabIndex = 9;
//
// button3
//
this.button3.Location = new System.Drawing.Point(143, 227);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(54, 23);
this.button3.TabIndex = 10;
this.button3.Text = "Exit";
this.button3.UseVisualStyleBackColor = true;
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// label5
//
this.label5.AutoSize = true;
this.label5.Location = new System.Drawing.Point(52, 18);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(114, 13);
this.label5.TabIndex = 11;
this.label5.Text = "Display Student Result";
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(215, 266);
this.Controls.Add(this.label5);
this.Controls.Add(this.button3);
this.Controls.Add(this.textBox4);
this.Controls.Add(this.textBox3);
this.Controls.Add(this.textBox2);
this.Controls.Add(this.textBox1);
this.Controls.Add(this.button2);
this.Controls.Add(this.button1);
this.Controls.Add(this.label4);
this.Controls.Add(this.label3);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Name = "Form1";
this.Text = "Student Report";
this.ResumeLayout(false);
this.PerformLayout();

}

#endregion

private System.Windows.Forms.Label label1;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.TextBox textBox3;
private System.Windows.Forms.TextBox textBox4;
private System.Windows.Forms.Button button3;
private System.Windows.Forms.Label label5;
}
}

// Form1.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Student_Marks
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button3_Click(object sender, EventArgs e)
{
Application.Exit();
/*Form2 form = new Form2();
form.Show();*/
}

private void button2_Click(object sender, EventArgs e)
{
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
}

private void button1_Click(object sender, EventArgs e)
{

int marks1 = Convert.ToInt32(textBox2.Text);
int marks2 = Convert.ToInt32(textBox3.Text);
textBox4.Text = Convert.ToString(marks1 + marks2);
}

private void button4_Click(object sender, EventArgs e)
{

}
}
}

Basics of Stored Procedures

2011-11-11T01:37:00.000-08:00

SQL Server implements Client/Server technology.A number of client send queries to the Central Server.The server after receiving the query request,parses it for syntax errors and process the request.Since the query passes from the client to the server through the network it adds to network traffic.Hence an increase in the number of queries from the clients leads to network congestion and load on the server.A stored procedure can solve this problem.

It is a collection or batch of T-SQL statements and control-of-flow language that is stored under one name and executed as a single unit.It helps in improving the performance of the query.A stored procedure is a precompiled object and is readily available for the various applications to execute.

Features of stored procedures are:-

Improved Performance
Reduction in network congestion
Enhanced accuracy
Better consistency
Better security mechanism

Types of procedures

User-Defined stored procedures :- They are created and stored in the current database.
System stored procedures :- They have names prefixed with sp_. These primarily support various administrative tasks that help manage the SQL SERVER.System stored procedures are stored in the system database and are accessible to the users of all the database.
Temporary stored procedures:- It has names prefixed with the #symbol .They are stored in tempdb database and are automatically dropped when the connection terminates.
Remote stored procedures :- They are the procedures that are created and stored in databases on remote servers. These can be accessed from various servers,provided user has appropriate permissions.
Extended stored procedures:- These are dlls that are executed outside the SQL Server environment.

Syntax to create procedure is

Code:

CREATE PROCEDURE proc_name

BEGIN

sql_statement1

sql_statement2

END

Where proc_name specifies the name of the stored procedure.

Syntax to execute procedure is

Code:

EXECUTE proc_name

Syntax to drop procedure is

Code:

DROP PROCEDURE proc_name

Add Two Numbers in C#

2011-11-09T23:36:00.000-08:00

This tutorial will demonstrate how to read from the input console (console line) to answer the prompts. The prompts will need to be a integer value to add the two inputs together.

I am using the System.Console object to read from the console and then converting the string inputs into integers with the Convert.ToInt32 function (the System.Convert has many methods and ToInt32 is one of these).

Start Visual Studio.
On the File menu, point to New, and then click Project.
In the Templates Categories pane, expand Visual C#, and then click Windows.
In the Templates pane, click Console Application.
Type a name for your project in the Name field.
Click OK.

The new project appears in Solution Explorer.
If Program.cs is not open in the Code Editor, right-click Program.cs in Solution Explorer and then click View Code.
Replace the contents of Program.cs with the following code.

The code:

using System;       // for the console object
 
class addtwonumbers
{
       public static void Main()
       {
              try 
              {
                     // output to the console
                     Console.Write("Please enter value 1 : ");
                     // readin the console input, and then convert to a integer value
                     int val1 = Convert.ToInt32(Console.ReadLine());
                     Console.Write("Please enter value 2 : ");
                     int val2 = Convert.ToInt32(Console.ReadLine());
                     // write out the answer 
                     Console.WriteLine("Answer = " + (val1 + val2));
              }
              catch (Exception e)
              {
                     // any errors. Like converting a string to a integer value
                     Console.WriteLine("Error : " + e.ToString());
              }
       }
}

save that as addtwonumbers.cs.

Once compiled  and executed(press F5 will using visual studio) the output will be:

Please enter value 1 : 50
Please enter value 2: 25
Answer = 75

Overview of WCF

2011-11-09T02:22:00.000-08:00

WCF is a .NET platform for developing services .Service is any functionality that can be consumed by the outside world. A service defines well defined communication protocols to communicate with it.

A service can be located anywhere , it could be on local machine on the intranet or even internet.A client consumes the functionality exposed by the service.A service can be anything it can be an independent application like asp.net or it can be another service.

Client and Service communicate with each other by sending messages.

SOAP Message SOAP Message

Client HTTP/TCP /MSMQ HTTP/TCP/MSMQ Server

Figure: Basic Client Server Communication

Since the functionality of the service is hidden to the outside world. Service exposes metadata that client uses to communicate with the service. Metadata can be in any technology neutral format like wsdl.

Client always uses proxy to communicate with the service irrespective of where service is located. In WCF every service has endpoints and the client uses theses endpoints to communicate with the service.

Every endpoint has three important pieces of information.

Address , Binding and Contract.

Address specifies the location of the service.

Binding specifies how to communicate with the service(protocol).

Contract specifies what the service does.

A typical endpoint in the configuration file appears as :

<endpoint address = "http://localhost/TestService/" binding="wsHttpBinding"
contract = "MyNamespace.IContract"/>

WCF has mainly following types of contracts

Service Contract: Describes the operations of the services
Operation Contract: Describes the operations available on the service
Data Contract: Define the data types passed to and from the service
Fault Contract: Define the erros raised by the service
Message Contract: Allows the service to interact directly by using the message.

Basic WCF service

System.ServiceModel.dll is the main assembly for WCF services. To create a WCF service we need to apply the service contract attribute either on the interface or the class.

namespace WcfService1
{

[ServiceContract]
public interface IService1 {

        [OperationContract]
        string HelloWorld();

    }

    public class Service1 : IService1    {
          public string HelloWorld()
            {
                return "Hello WCF";
            }

      }
}

We can also use explicit interface implementation like this :

         string IService1.HelloWorld()
            {
                return "Hello WCF";
            }

Note when using explicit interface implementation we can't use the public access modifier.

Method Overloading

To use method overloading we need to use the name attribute of the OperationContract attribute.

If we write the following implementation for method overloading it will throw an exception at service host load time.

        [OperationContract]
        string HelloWorld();

        [OperationContract]
        string HelloWorld(string Message);

To use method overloading in WCF service we need to use the Name attribute of the OperationContract attribute.

        [OperationContract(Name="HelloWorld")]
        string HelloWorld();

        [OperationContract(Name = "HellowWorldMssg")]
        string HelloWorld(string Message);

In the later articles we will see how to host the service and call it using the client application.

Data Contracts

We can pass only the primitive datatypes to OperationContracts .If we want to pass custom data types to OperationContracts we need to use the DataContract Attribute on the Custom datatype.

    [DataContract]
    class Customer    {
        int name;

        [DataMember]
        public int Name
        {
            get { return name; }
            set { name = value; }
        }
        int address;

        [DataMember]
        public int Address
        {
            get { return address; }
            set { address = value; }
        }

}

To create a WPF application

2011-11-08T04:02:00.000-08:00

On the File menu, click New Project.
In the New Project dialog box, in the Templates pane, click WPF Application.
In the Name box, type WPFWindow, and then click OK.

A new Windows Presentation Foundation project is created. A new window named Window1 appears. Its XAML markup is visible in the XAML editor of the Visual Basic integrated development environment (IDE) and appears as follows:
<Window x:Class="Window1" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Title="Window1" Height="300" Width="300"> <Grid> </Grid> </Window>
Click Window1 to select it.
In the XAML editor, change the Title attribute of the Window element from Window1 toWPF Application.

The XAML markup will now appear as follows:
<Window x:Class="Window1" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Title="WPF Application" Height="300" Width="300"> <Grid> </Grid> </Window>
The text in the title bar of Window1 changes to WPF Application.

Experiment by changing other attributes of the Window, such as Width and Height. When you are ready, continue with the next procedure.

Adding Controls to the WPF Window

In this procedure, you will add controls to your application. You will do this by clicking the control in the Toolbox, usually found on the left-hand side of the Visual Basic IDE, and then dragging the control onto your WPF window. You will set some properties for the control and then adjust the XAML markup to change the control's text and size.

To add a control to the WPF window

From the Toolbox, drag a TextBox control to the upper right side of the WPF window.
Select the TextBox control.
In the Properties window, click the first arrow (Left) for the HorizontalAlignment property, as shown in the following illustration.

HorizontalAlignment property

This moves the TextBox from the right side of the WPF window to the left side.
Set the following properties for the TextBox.

Property Value

VerticalAlignment -- TOP
Top

Width -- 75
75

Height --26
26
In the XAML editor, change the Width attribute of the TextBox element to 140, and change the Margin element to 30, 56, 0, 0, as shown in the following example.
<TextBox Height="26" HorizontalAlignment="Left" Margin="30,56,0,0" Name="TextBox1" VerticalAlignment="Top" Width="140" />
The width and location of the TextBox change after you type the new values.
Add a Button control to the WPF window, next to the TextBox.
Change the text between the opening and closing Button tags from Button to Submit, as shown in the following example.
<Button Height="23" HorizontalAlignment="Right" Margin="0,59,35,0" Name="Button1" VerticalAlignment="Top" Width="75">Submit</Button>
The text on the button changes after you enter the new value.
Press F5 to run your program. A window containing the text box and button that you just added appears. Notice that you can click the button and type in the text box. You must add event handlers to the controls and then write code that instructs the computer what to do when the button is clicked.

Property	Value
VerticalAlignment -- TOP	Top
Width -- 75	75
Height --26	26

Calender Program In C#

2011-11-07T03:56:00.000-08:00

Beginning of Calendar.cs

This program prints out the calendar for a full year, specified by the user.

using System;

class Calendar

{

const int Sunday = 0;

const int Monday = 1;

const int Tuesday = 2;

const int Wednesday = 3;

const int Thursday = 4;

const int Friday = 5;

const int Saturday = 6;

static void Main (string[] args)

{

int year;

GiveInstructions();

year = GetYearFromUser();

PrintCalendar(year);

}

static void GiveInstructions ()

{

Console.WriteLine("This program displays a calendar for a full");

Console.WriteLine("year. The year must not be before 1900.");

}

static int GetYearFromUser ()

{

int year = 1900;

while (true)

{

Console.Write("Which year? ");

year = Int32.Parse(Console.ReadLine());

if (year >= 1900) return year;

Console.WriteLine("The year must be at least 1900.");

};

}

static void PrintCalendar(int year)

{

int month;

for (month = 1; month <= 12; month++)

{

PrintCalendarMonth(month, year);

Console.WriteLine();

}

static void PrintCalendarMonth(int month, int year)

{

int weekday, nDays, day;

Console.WriteLine(" " + (MonthName(month)) + " " + year);

Console.WriteLine(" Su Mo Tu We Th Fr Sa");

nDays = MonthDays(month, year);

weekday = FirstDayOfMonth(month, year);

IndentFirstLine(weekday);

for (day = 1; day <= nDays; day++)

{

if (day > 9) Console.Write(" " + day);

else Console.Write(" " + day);

if (weekday == Saturday) Console.WriteLine();

weekday = (weekday + 1) % 7;

}

if (weekday != Sunday) Console.WriteLine();

}

static void IndentFirstLine(int weekday)

{

int i;

for (i = 0; i < weekday; i++)

{

Console.Write(" ");

}

static int MonthDays(int month, int year)

{

switch (month)

{

case 2:

if (IsLeapYear(year)) return (29);

return (28);

case 4: case 6: case 9: case 11:

return (30);

default:

return (31);

}

static int FirstDayOfMonth(int month, int year)

{

int weekday, i;

weekday = Monday;

for (i = 1900; i < year; i++)

{

weekday = (weekday + 365) % 7;

if (IsLeapYear(i)) weekday = (weekday + 1) % 7;

}

for (i = 1; i < month; i++)

{

weekday = (weekday + MonthDays(i, year)) % 7;

}

return (weekday);

}

static string MonthName(int month)

{

switch (month)

{

case 1: return ("January");

case 2: return ("February");

case 3: return ("March");

case 4: return ("April");

case 5: return ("May");

case 6: return ("June");

case 7: return ("July");

case 8: return ("August");

case 9: return ("September");

case 10: return ("October");

case 11: return ("November");

case 12: return ("December");

default: return ("Illegal month");

}

static bool IsLeapYear(int year)

{

return ( ((year % 4 == 0) && (year % 100 != 0))

|| (year % 400 == 0) );

}

.NET FRAMEWORK

2011-11-05T05:00:00.000-07:00

What is .Net Framework?
A main part of the .Net technology and structure is the ASP.net set of technologies. These web development technologies are used in the making of Websites and net services working on the .NET infrastructure. ASP.NET was build by Microsoft from one of their big technologies and web programmers can make use of any encoding language they want to write ASP.NET, from Perl to C Sharp (C#) and of course VB.NET and a few extra language unspoken with the .NET technology.

Pre requisites for .Net training:
It's all about you should know before starting Training in core java.

Basic concepts of Programming Structure
Environmental Knowledge of OOPs
Should have some knowledge in RDBMS

What will you learn at SSDN Technologies?

Module 1: Object Oriented Programming Using C#

Explain features and phases of the object-oriented approach
Write and execute C# programs
Use decision-making constructs and loop constructs
Implement structures, enumerations, arrays, and collections
Implement polymorphism and overload functions and operators
Explain and use delegates and events
Use various stream classes to implement file handling
Develop single and multithreaded applications
Identify the components of the Visual Studio .NET Framework and Integrated Development Environment (IDE)

Module 2: GUI Applications Development using .NET Framework

Work with the Windows Forms and controls
Perform validation of controls using classes and controls
Work with Dialog Boxes, Menus and MDI Application
Implement Printing and Reporting Functionality in a Windows Forms Application
Implement Asynchronous programming
Package, deploy, and secure applications

Module 3: Developing Database Applications Using ADO.NET and XML

Identify the need for XML as a standard data interchange format
Create an XML schema
Create a cascading style sheet and an Extensible Style Sheet Language Transformation (XSLT) to format data
Use XPath pattern matching in a style sheet
Create and manage connections using ADO.NET
Identify the disconnected and connected environment in ADO.NET
Create datasets and datatables
Retrieve and store large binary data
Perform bulk copy operations
Execute SQL notification maintain and update a cache
Manage distributed transactions
Read, write, validate, and modify XML data using XML reader and writer classes
Read, write, and modify XML data using DOM API

Module 4: Developing Web applications Using ASP.NET 4.0

Create a Web Application
Program a Web Application
Add and Configure Server Controls
Create a Common Layout by Using Master Pages
Manage State for a Web Application
Access and Display Data
Control Access to a Web Application
Deploy a Web Application
Make Web Applications Available to Mobile Devices
Build Dynamic Web Applications
Create Controls for Web Applications
Optimize Web Application Performance
Implement Personalization and Themes in Web Applications
Build Web Part Pages and Web Parts

DotNet

Matrix Program

XML Basics

What is XML?

XML Benefits

XML Holds Data, Nothing More

XML Separates Structure from Formatting

XML Promotes Data Sharing

XML is Human-Readable

Code Sample: XMLBasics/Demos/Paul.xml

XML is Free

XML in Practice

Content Management

Web Services

RDF / RSS Feeds

XML Documents

The Prolog

The XML Declaration

Processing Instructions

Comments

A Document Type Declaration

Elements

Code Sample: XMLBasics/Demos/Paul.xml

Empty Elements

Attributes

CDATA

White Space

xml:space Attribute

XML Syntax Rules

Special Characters

Creating a Simple XML File

Code Sample: XMLBasics/Demos/Beatles.xml

Exercise: Editing an XML File

Code Sample: XMLBasics/Exercises/Xml101.xml

XML Basics Conclusion

CLR Stored Procedure

SQL SERVER – Introduction to CLR – Simple Example of CLR Stored Procedure

WCF Architecture

Contracts

Service contracts

Data contract

Message Contract

Policies and Binding

Service Runtime

Messaging

Activation and Hosting

FileStream Open File [C#]

SQL - Join

SQL Join Query Code:

USE mydatabase; SELECT * FROM orders JOIN inventory ON orders.product = inventory.product;

SQL Join Results:

SQL Join:

USE mydatabase; SELECT orders.customer, orders.day_of_order, orders.product, orders.quantity as number_ordered, inventory.quantity as number_instock, inventory.price FROM orders JOIN inventory ON orders.product = inventory.product

SQL Results:

SQL - Right Join

SQL - Right Join:

USE mydatabase; SELECT * FROM orders RIGHT JOIN inventory ON orders.product = inventory.product

SQL Results:

SQL - Left Join

SQL Left Join:

USE mydatabase; SELECT * FROM orders LEFT JOIN inventory ON orders.product = inventory.product

Update the UI Asynchronously on a Timer

Rolling Ball Animation

Total Of Student's Marks

/* Simple Program in C# (for beginners) to input the name from the user and his marks in two subject and find the total in the two subjects. */

Basics of Stored Procedures

Add Two Numbers in C#

Overview of WCF

To create a WPF application

To add a control to the WPF window

Calender Program In C#

.NET FRAMEWORK