Display Data Using Object. Data. Source. This article explains how to use Object. Data. Source and how to get data and display it in a Grid. View and Form. View using an Object. Data. Source. What Object. Data. Source is. The Object. Data. Source serves as a proxy for working with some other object. Introduction ASP. NET 2. 0s data source controls make it possible to retrieve, insert, update, and delete data without having to write the tedious dedata access code. Usage of ASP. Net 2. 0 Validation controls like CompareValidator and RangeValidator control in Visual basic 2005 and Csharp 2005. System. Data. SqlClient. SqlConnection. OnErrorSqlException exception, Boolean breakConnection 1950890 System. Data. SqlClient. SqlInternalConnection. OnError. This article explains how to use ObjectDataSource and how to get data and display it in a GridView and FormView using an ObjectDataSource. SqlDataSource DetailsView SQL Server. Issuu is a digital publishing platform that makes it simple to publish magazines, catalogs, newspapers, books, and more online. Easily share your publications and get. Many months back I wrote three articles Creating DataGrid Programmatically, Creating DataGrid Templated Columns Dynamically Part I and Creating DataGrid Templated. To configure the Object. Data. Source, we specify the underlying object and how its methods map to the Object. Data. Sources Select, Insert, Update, and Delete methods. Once this underlying object has been specified and its methods mapped to the Object. Data. Sources, we can then bind the Object. Data. Source to a data web control. ASP. NET ships with many data web controls, including the Grid. View, Details. View, Radio. Button. List, and Dropdown List, among others. I wonder how I can forget to write about Ob. Ject. Data. Source when I was writing about data sources. JASP. NET 4. 0 has seven builtin data sources. Getting Started. Begin using the following procedure Start Visual Studio. Create a new website. Provide the name and location of the website. Click NextNow add the connection string in the config file. lt connection. Strings      lt addnameConnection. Stringconnection. StringData Source. SQLEXPRESS Attach. Db. FilenameData. DirectoryNORTHWND. MDF Integrated SecurityTrue User InstanceTrue       provider. NameSystem. Data. Sql. Client      lt connection. Strings Now add a new class and write a function or methods. Employee. BLL. csusing System. Data using System. Data. Sql. Client using System. Configuration    Sql. Connection con    Sql. Command cmd    Sql. Data. Adapter da    Data. Set ds    lt summary    This function gets employee list    lt summary    lt returns lt returns    public Data. Set Get. Employees            con new Sql. Connection        con. Connection. String Configuration. Manager. Connection. StringsConnection. String. Connection. String        cmd new Sql. Command        cmd. Command. Text SELECT Last. Name, First. Name, City, Region, Country, Postal. Code, Birth. Date, Photo, Employee. ID FROM Employees        cmd. Connection con        da new Sql. Data. Adaptercmd        ds new Data. Set        da. Fillds        return ds    Now drag and drop Object. Data. Source, Grid. View and Form. View controls to the page from the toolbox.   Image 1. Now choose your business object and click Next. Image 2. Now choose the method and click Finish. Image 3. Image 4. Grid. Viewlt h. Employee List Grid. View Examplelt h. Grid. View. IDGrid. View. 1runatserverAllow. PagingTrue            Allow. SortingTrueCell. Padding4Data. Source. IDObject. Data. Source. 1            Fore. Color3. 33. 33. Grid. LinesNoneAuto. Generate. ColumnsFalse            Page. Size5            lt Alternating. Row. Style. Back. ColorWhite            lt Columns                lt asp Command. Field. Show. Select. ButtonTrue                                                       lt asp Bound. Field. Data. FieldLast. NameHeader. TextLast Name                lt asp Bound. Field. Data. FieldFirst. NameHeader. TextFirst Name                lt asp Bound. Field. Data. FieldBirth. DateHeader. TextBirth. Date                lt asp Bound. Field. Data. FieldCityHeader. TextCity                lt asp Bound. Field. Data. FieldRegionHeader. TextRegion                lt asp Bound. Field. Data. FieldPostal. CodeHeader. TextPostal. Code                lt asp Bound. Field. Data. FieldCountryHeader. TextCountry                                            lt Columns            lt Footer. Style. Back. Color9. Font BoldTrueFore. ColorWhite            lt Header. Style. Back. Color9. Font BoldTrueFore. ColorWhite            lt Pager. Style. Back. ColorFFCC6. Fore. Color3. 33. Horizontal. AlignCenter            lt Row. Style. Back. ColorFFFBD6Fore. Color3. 33. 33. Selected. Row. Style. Back. ColorFFCC6. Font BoldTrueFore. ColorNavy            lt Sorted. Ascending. Cell. Style. Back. ColorFDF5. AC            lt Sorted. Ascending. Header. Style. Back. Color4. D0. 00. 0            lt Sorted. Descending. Cell. Style. Back. ColorFCF6. C0            lt Sorted. Descending. Header. Style. Back. Color8. Grid. View        lt asp Object. Data. Source. IDObject. Data. Source. 1runatserver            Select. MethodGet. EmployeesType. NameEmployee. BLL lt asp Object. Data. Source    lt div Form. Viewlt h. 1 Employee List Form. View Examplelt h. Panel. IDPanel. Fore. ColorGreen              lt asp Form. View                   IDForm. View. 1                   runatserver                  Data. Source. IDObject. Data. Source. 1                  Allow. Pagingtrue                  lt Item. Template                      lt b Employee ID lt b                      lt EvalEmployee. ID                       lt br                      lt b Name lt b                      lt EvalLast. Name lt EvalFirst. Name                       lt br                      lt b Birth. Date lt b                      lt EvalBirth. Date                      lt br                      lt b City lt b                      lt EvalCity                       lt br                       lt b Region lt b                      lt EvalRegion                      lt br                       lt b Postal. Code lt b                      lt EvalPostal. Code                      lt br                      lt b Country lt b                      lt EvalCountry                   lt Item. Template              lt asp Form. View          lt asp Panel       lt div Hit F5 to see the output. Image 5. Image 6. For more information, download the attached sample application with the database.