C sharp - Silverlight Programming

What is Trigger ? After Trigger & Instead of Triggers with Examples

2012-09-13T04:14:00.001-07:00

A trigger is a SQL procedure that initiates an action when an event like Insert, Delete or Update occurs.

Triggers are stored and managed by DBMS.

Triggers are used to maintain data Integrity.

Triggers cannot be called or executed , the DBMS automatically calls the trigger as a result of data modification to table.

A trigger that contains data modification logic within itself is called a nested trigger.

There are two types of Triggers : After Triggers and Instead of Triggers

After Triggers :

It runs after Insert, Delete or Update on a table.

No support for View.

After Triggers are Further Classified as :

AFTER INSERT Trigger.

AFTER UPDATE Trigger.

AFTER DELETE Trigger.

Example of AFTER INSERT Trigger.

CREATE TRIGGER mytrigger ON Table1

FOR INSERT

AS

   --declaring local variables

   declare @empid int;

   declare @empname varchar (150);

   --storing values in above declared variables

   select @empid=i.Emp_ID from inserted i;

   select @empname=i.Emp_Name from inserted i;

   --inserting record in new table

   insert into Table2 (Emp_ID,Emp_Name) values (@empid,@empname);

GO

Delegates in C#

2012-07-02T10:59:00.001-07:00

Delegates

It is a reference type, holds address of a method.
Allows to change reference to a method at runtime.
Referring method should have the return type and function signature same as that of the delegate.

The following are the steps for implementing Delegates

o Declare a delegate

* Syntax

[access modifier] delegate <return type> <delegate name> <parameter list>

* E.g.

public delegate void MyDelegate();

* This delegate can refer any method having no parameter with no return type.

o Instantiate a delegate

* MyDelegate delObj = new MyDelegate(staticMethod);

* delObj is an object of type MyDelegate

* delObj refers to staticMethod, by passing the name of method to the delegate constructor.

o Invoke a delegate

* Delegates are invoked using its object name and passing the parameters, if required, in a similar way of calling methods.

* delObj();

Types of Delegate

o Single-cast Delegate

* Refers to only one method at a time.

o Multicast Delegate

* A single delegate can refer to multiple methods.

* Contains an invocation list of multiple methods.

* Invokes multiple methods provided all methods have same return type and same function signature.

* When invoked, executes the referenced methods in the calling order.

DOWNLOAD SAMPLE CODE: CLICK HERE

What is .NET Framework ?

2012-06-24T01:34:00.000-07:00

The .NET Framework is a Platform for software development.The .NET Framework consists of

CLR (Common Language Runtime)
CLS (Common Language Specification)
CTS (Common Type System)
.NET base class library

CLR (Common Language Runtime) :
Provides many of the core services required for program execution.

CLS (Common Language Specification) :
The CLS defines a minimum set of standards that all languages using the .NET Framework must support,

CTS (Common Type System) :
The CTS ensures type compatibility between components developed in different languages.

.NET base class library :
The .NET base class library, which exposes a set of pre-developed classes to facilitate program development.

The primary unit of a .NET application is the assembly, which includes an assembly manifest. The assembly manifest describes the assembly and one or more modules , and modules contain the source code for the application.

A .NET executable is stored as an IL file. When loaded, the assembly is checked against the security policy of local system. If it is allowed to run, the first assembly is loaded into memory and JIT compiled into native binary code, where it is stored for the remainder of the program's execution.

Top 5 advantages of ASP.NET

2012-06-23T23:22:00.002-07:00

ASP.NET has many advantages over other platforms when it comes to creating Web applications. The advantage is mainly because in ASP.NET web applications can be easily created , debugged and deployed within a single development environment Visual Studio .NET.

Executable portions of a Web application compiled so they execute more quickly than interpreted scripts.
Built in security through the Windows server or through other authentication/authorization methods.
Integration with ADO.NET to provide database access and database design tools from within Visual Studio .NET.
Full support for Extensible Markup Language (XML), cascading style sheets (CSS), and other new and established Web standards.
Built in feature for caching frequently requested Web pages on the server, localizing content for specific languages and cultures, and detecting browser capabilities.

2012-06-23T12:03:00.003-07:00

C sharp for Noob..hws it?
for Newwbies or beginners newette p wbies b

its newbies
otte
its )better
). hmmm

Page Navigation in Silverlight

2012-06-12T11:07:00.003-07:00

Navigation in Silverlight from one page to another is done on Frame.
Below example will explain how to navigate between pages in Silverlight.

Result has been displayed below.. Dont Forget to download Source Code for your Reference

On Button Click of Page 1

On Button Click of Page 2

Xaml Page Code For Page Navigation :

Xaml.cs Code For Page Navigation :

Download Source Code : Click here to download Source Code of Page Navigation in Silverlight

Line Series Chart in Silverlight

2012-06-12T10:58:00.001-07:00

Line Series Chart comes with the Silverlight 4 Toolkit.
The Chart control is stored in the Microsoft.Windows.Controls.DataVisualzation.Charting assembly. This assembly can be referenced just like any other assembly in Visual Studio.

Result has been displayed below.. Dont Forget to download Source Code for your Reference

Xaml Page Code For Line Chart Series :

Xaml.cs Code For Line Chart Series :

Download Source Code : Click here to download Source Code of Line Chart Series in Silverlight

Pie Series Chart in Silverlight

2012-06-12T10:51:00.003-07:00

Pie Chart Series comes with the Silverlight 4 Toolkit.
The Chart control is stored in the Microsoft.Windows.Controls.DataVisualzation.Charting assembly. This assembly can be referenced just like any other assembly in Visual Studio.

Result has been displayed below.. Don't Forget to download Source Code for your Reference

Xaml Page Code For Pie Series :

Xaml.cs Code For Pie Series :

Download Source Code : Click here to download Source Code of Pie Chart Series in Silverlight

Column Series Chart in Silverlight

2012-06-12T02:23:00.001-07:00

Column Series Chart comes with the Silverlight 4 Toolkit.
The Chart control is stored in the Microsoft.Windows.Controls.DataVisualzation.Charting assembly. This assembly can be referenced just like any other assembly in Visual Studio.

Result has been displayed below.. Dont Forget to download Source Code for your Reference

Xaml Page Code For Chart Series :

Xaml.cs Code For Chart Series :

Download Source Code : Click here to download Source Code of Column Chart Series in Silverlight

DataGrid Binding in Silverlight

2012-06-12T02:02:00.003-07:00

DataGrid Binding in Silverlight

Result of the Program has been shown below.

Here we bind Each Column to display respected data in Grid.

Detailed Information is given below and dont forget to Download Source Code for Reference.

Xaml Page Code :

Xaml.cs Code :

Download Source Code : Click here to download Source Code of Data Grid binding in Silverlight

Binding Date Picker in Silverlight

2012-06-11T12:04:00.006-07:00

Today we are going to learn how to bind Date Picker in Silverlight .. Lets start with it ..

Below shown is a result of data binding of Date picker in Silverlight.

Xaml Page Code shown below of date picker :

Here SelectedDate Property of Date Picker has been binded to get desired result.

Xaml.cs Page Code :

Binding Date Picker in Silverlight

Download Source Code : Click here to Download Source Code of Binding Date picker in Silverlight

Binding Combo Box in Silverlight

2012-06-11T11:29:00.001-07:00

Binding of Combo Box in Silverlight on Selected Index Property of Combo Box

Xaml Code for binding Combobox :

Xaml.cs Code for binding Combobox :

Output Result of data binding of Combo box :

Thus we have succesfully Binded selected item property of combo box in silverlight.

Download Source Code : Click here to download Source code for binding combo box in silverlight

Simple Animation in Silverlight

2012-06-10T12:08:00.002-07:00

Simple Animation Example in Silverlight has been Explained below with Source Code to download

Xaml Code :-

Xaml.cs Code :-

Download Source Code : Click Here to download Source Code of Silverlight Animation Project

Alternate way to Disable a Button in Silverlight.

2012-06-09T11:57:00.001-07:00

So to avoid this blur Effect we can use other Properties of Button in Silverlight to Disable it.

XAML Code to disable Button :-

BackEnd ( XAML.cs) Code to enable and disable Button at Runtime :-

//button gets Disabled and Visibility of Button Remains same as in Enabled Mode.

MY_BUTTON.IsHitTestVisible = false;
//button gets Enabled
MY_BUTTON.IsHitTestVisible = true;

How to disable Silverlight Button Control ?

2012-06-08T21:22:00.000-07:00

XAML CODE OF BUTTON (ENABLED) IN SILVERLIGHT : -

XAML CODE OF BUTTON (DISABLED) IN SILVERLIGHT : -

BackEnd (XAML.cs) Code to Disable and Enable Silverlight Button at Runtime dynamically :-

MY_BUTTON.IsEnabled = false; // button gets Disabled

MY_BUTTON.IsEnabled = true; // button gets Enabled