ASP.NET GridView Tutorial

Using stored procedures with objectdatasource control – Part 12

Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists

Link for text version of this video
http://csharp-video-tutorials.blogspot.com/2013/02/using-stored-procedures-with_27.html

In this video we will discuss about using a stored procedure with objectdatasource control, to retrieve and display data in a gridview control. Please watch Part 11 of asp.net gridview tuorial before proceeding with this video. We will be using same sql server tables and stored procedures that we used in Part 11 of asp.net gridview tuorial.

Create an asp.net web application. Add a class file with name, DepartmentDataAccessLayer.cs to the web application project.

Right click on the solution in solution explorer, and select “Build Solution”, so that the classes we added are compiled.

Drag and drop 2 objectdatasource controls, a dropdownlist and a gridview control on WebForm1.aspx.

Configure “ObjectDataSource1” control to retrieve departments data
1. Right click on “ObjectDataSource1” control and select “Show Smart Tag”
2. Now click on “Configure Data Source” link
3. Select “Demo.DepartmentDataAccessLayer” from “Choose your business object” dropdownlist and click “Next”
4. Select “GetAllDepartments()” from “Choose a method” dropdownlist and click finish

We are now done configuring “ObjectDataSource1” control.

Let’s now configure “DropDownList1” to use “ObjectDataSource1” control.
1. Right click on “DropDownList1” control and select “Show Smart Tag”
2. Now click on “Choose Data Source” link
3. Select “ObjectDataSource1” from “Select a Data Source” dropdownlist
4. Select “DepartmentName” from “Select a data field to display in the dropdownlist”
5. Select “DepartmentId” from “Select a data field for the value of the dropdownlist” and click OK

At this point, if you run the application, all the departments should be displayed in the dropdownlist control

Now let us configure “ObjectDataSource2” control, to retrieve employees by department.
1. Right click on “ObjectDataSource2” control and select “Show Smart Tag”
2. Now click on “Configure Data Source” link
3. Select “Demo.EmployeeDataAccessLayer” from “Choose your business object” dropdownlist and click “Next”
4. Select “GetEmployeesByDepartment()” from “Choose a method” dropdownlist and click “Next”
5. On “Define Parameters” screen, select “Control” from “Parameter Source” dropdownlist
8. Select “DropDownList1” from “ControlID” dropdownlist and click “Finish”

Now let us associate “ObjectDataSource2” control with “GridView1” control
1. Right click on “GridView1” control and select “Show Smart Tag”
2. Select “ObjectDataSource2” from “Choose Data Source” dropdownlist

Finally set AutoPostBack property of DropDownList1 control to true, so that the webform will automatically postback to the server whenever the selection in the dropdownlist changes.

Run the application and notice that, as the selection in the dropdownlist changes, the data in gridview control also changes.