Computer Programming : Installing the ASP.NET AJAX control Toolkit, Example

The ASP.NET ACT is a shared source of projects created by the joint effort of Microsoft developers and ASP.NET and AJAX community; therefore it is not included within ASP.NET 3.5 Framework. In other words, the Toolkit is community supported and community driven . If you want avail the extended functionalities of the ASP.NET controls, you need to download and install the ASP.NET ACT manually. The ACT can be downloaded (available free of cost) with lots of additional AJAX controls and components. The Toolkit is continuously updated and a new release of Toolkit  is available every couple of months.

Perform the following steps to install the ASP.NET AJAX control Toolkit.
Step-1 : Download the compressed file from http://ajaxcontroltoolkit.codeplex.com/releases/view/105897
Step-2 : Decompress the files to any location on your system and change its name to a desired name, say, AjaxControlToolKit.

Step-3: Create New WebSite in Visual Studio 2008 or later

 Step-4: Open new dialog when you create new website. Choose Empty website in middle section also choose c-sharp(c#) for language in left section.After that click on OK Button

Step-5: Add New Webform from Solution Explorer.

Step-6: After Click on Add New Item you will a new dialog panel .

choose Webform in dialog panel also set name according to you.Click on Ok Button

Step-5 : Right click the ToolBox window . Then select Add Tab from the context menu.

Step-6 : Again Right click on ToolBox and choose item link from popup.

Step-7: Now Add AjaxControlToolKit.dll file from this Wizard 

Step-8: Click on Browse Button

Step-9: Select AjaxControlToolkit.dll file from your harddrive.and add your toolkit to your toolbox

Step-10 : The Toolkit controls have been added to the toolbox.

Under the AjaxControlToolkit option, the names of the controls appear and are self-explanatory. This makes it easier to short out the associativity of the ToolKit's control with the ASP.NET controls

How to use Rating Control in AJAX

While surfing on the internet you see a lot of information and content , such as books , tutorials, songs ,movies,and the rest , which ask for user's feedback . This feedback provides a key metric to recognize the satisfaction of users. For this purpose , the owner of the materials provides a rating system that represents a set of stars , which can be used to receive feedback . The rating mechanism used by ASP.NET  needs a synchronous postback. However you can use the rating control that made client callback without refreshing the entire page .

Properties of Rating Control :

AutoPostBack : Set to true if you want to perform a postback by clicking a rating item.

CurrentRating : Sets the initial rating value to display the selected rating item when the page is loaded.

MaxRating : Sets the maximum rating value that you want to allow to rate an item.

ReadOnly : Determine whether or not the rating can be changed.

StarCssClass : Sets the css class for the visible star.

WatingStarCssClass : Sets the css class for the star in waiting state.

FilledStarCssClass : Sets the CSS class for the star in filled state.

EmptyStarCssClass : Sets the CSS class for the star in an empty state.

RatingAlign : Set the alignment for the stars. The value can be either vertical or horizontal.

Combo Box or List Box Binding with Database, Entity Framework 5

Most often when we have a list of items and want to select a single item at a time then we can use Combo Box or List Box in winforms application. The basic difference in both is: In List Box one can select an item only from existing list of items whether in Combo Box one can write his/her own new data that can be added to our binding list.

There are some properties that are used to bind a list of items in c# programming i.e

• Data Source
• Display Member
• Value Member

DataSource property will decide the list of data that is to be bind. It may be a Database, Web Service and an object. When this property is set, the item collection cannot be modified at run time.

DisplayMember property indicates the name of an object contained in DataSource property. It denotes what object will be displayed to the user. The default value is empty string.

ValueMember property is used to get the value associated with the control when we are accessing the selected item property.

Let's suppose we have an employee class with properties as shown below c# class:

public class Employee

    {

        public int Id { get; set; }

        public string Name { get; set; }

        public string Department { get; set; }

    }

Now following code is used to get all records of employee from Database into a var type of variable named employees as given below:

DataContext dc = new DataContext();

var employees = from emp in dc.Employees

                          select emp;

In the above code employees variable have IEnumerable<Employee> type of data and this type of data cannot directly bind to data source property of a control in our programming language. So we have to convert it to a List<Employee>.

To convert this simple type of data a ToList() method is sufficient.

In case of Combo Box

ComboBox1.DataSource = employees.ToList();

ComboBox1.DisplayMember = "Name";

ComboBox1.ValueMember = "Id";

In case of List Box

ListBox1.DataSource = employees.ToList();

ListBox1.DisplayMember = "Name";

ListBox1.ValueMember = "Id";

Here ToList() method is used to convert IEnumerable<Employee> type of data to List<Employee>.

Now when we run our project we will see the list of employees Names in the item collection of Combo Box or ListBox.

How to Perform LINQ in C# Programming to Get Records using Entity Framework 5

LINQ stands for Language INtegrated Queries in the context of sql programming. These are like SQL queries used to manipulate collection of objects through entity framework. LINQ are queries that can be directly written in c# programming language and will be translated to SQL statements and executed against the database. It simplify the complex process of database developer to query in databases.

These type of queries are executed on collection of IEnumerable<T> or IQueryable<T> and as results are returned new collection of IEnumerable<T> objects. In this post I will explain some example that show how to use LINQ on collection of objects in c# programming.

Let’s suppose we have a c# class Student having two properties i.e. Name and Age and of course a primary key Id. Now to get all records of students from database we have to write:

var students = from student in dc.Student

               select student;

In above code it will extract all columns from Student table like Id, Name and Age also. If we want only name and Age column then:

var students = from student in dc.Student

               select new

               {

                   student.Name,

                   student.Age

               };

It will show only Name and Age columns of all the records.

It’s very simple to get some records having where condition like in sql programming. In below code if we want to get all records having age = "25" then the following code should be written:

var students = from student in dc.Student

                     where student.Age == 25

                     select student;

Now at the last if you want to get records having age = "25" and name = "Rahul" then following line of code has to be written:

var students = from student in dc.Student

               where student.Age == 25 && student.Name == "Rahul"

               select student;

So according to above examples, LINQ is very simple language to be queried with databases. Here dc is used for data context that is created through entity framework 5.

How to Update and Delete record from database using EntityFramework in c# programming

Sometimes database developer have to change some of the properties of table, due to insertion mistakes. As we have inserted records into Database using entity framework 5, it's time to modify that record and delete that if required through c# programming language.

We (database developer) all know that update and delete query required a condition through which they retrieve an instance on which action is to be performed.

Update: The update operation is quite simple in entity framework 5. First retrieve an instance of specified Entity object, then edit the properties of that instance and finally save the changes to that context and done. It have a little bit complex syntax in sql programming.

Let’s suppose we have an entry of student named “Student 1” and we want to change his/her name and age then:

DataContext dc = new DataContext();
Student student = dc.Student.First(s = > s.Name.Equals("Student 1"));
student.Name = "Student 2";
student.Age = 25;

dc.SaveChanges();

Execute the code and check the database, you have successfully made changes through the above c# programming code.

Delete: The delete operation is little bit different from Update operation. First retrieve an instance of specified Entity object, then delete that instance from context and finally save changes to context and done.

Let’s suppose we have an entry of student named “Student 2” and we want to delete then:

DataContext dc = new DataContext();
Student student = dc.Student.First(s = > s.Name.Equals("Student 1"));
dc.Student.Remove(student);

dc.SaveChanges();

Execute the above code of c# programming and check the database, there is no student named "Student 2".

Note: "When we are retrieving an instance of Student class and if that student has not been found then there may be an Exception. So better be use 'try catch' block".

Insert Entities into database Table using Entity Framework 5: C# programming

After creating databases with foreign key constraints in entity framework 5, its time to insert some records and save them for further references. In this article i will cover up, how to add entities and how entity framework processes these during saveChanges method. A database developer often use this method to insert records.


As i have added Student table which is a c# class in our solution, i will insert a record in the same table directly through code. I am using the same Winforms Application that we have used in previous article so make sure you have studied Creating databases in entity framework 5.

Note: "You must create an object of DataContext class in Form1's Constructor in order to insert some data in Student class."

To insert a record in database we will use the method i.e. EntityCollection<TEntity>.Add(). Lookout the c# programming code given below:

DataContext dc = new DataContext();
Student newStudent = new Student();
newStudent.Name = "Student 1";
newStudent.Age = 24;

dc.Student.Add(newStudent);
dc.SaveChanges();

All we are doing here is create a new instance of Student class and populate its properties. Then add that instance to Students set using EntityCollection<TEntity>.Add() method.

In above code Add() method is used to add newly created instance in database, and SaveChanges() method is used to save all the changes you have done with database.

Finally, go to your database and check, you will find the above instance there in Students table.

Download Source Code.

Update n Delete Entities in Entity Framework 5

Create Foreign key in database using Entity Framework 5 in C# Programming

In the context of relational database management system (RDBMS), foreign key is a field in one table that uniquely identifies a row of another table. In sql programming, foreign key is a column which points to the primary key of another table.

An entity can be related referenced with other entities through this foreign key, in entity framework. This can be done through an association between the tables. As we have studied in our Previous Post how to create databases and tables in it. In this article i will create a foreign key in the table.

Steps of creating foreign key in entity framework 5.

Here above i have mentioned the version of entity framework, because it is the stable version currently. Follow these steps and it will add a reference of student in address class.

• In our Previous post we have created a table Student. We will use this table here. 
• In that same project add a new class Address and create some properties (fields in context of databases).
• In the Address class create a property type of Student having keyword virtual as written here:
  public virtual Student Student { get; set; }
• Now repeat the same procedure of creating an object of DataContext class in Form1's Constructor.
• And Finally we have successfully created a foreign key in Address table by running Form1.

Download Source code here.

Insert entities in databases