Mega Code Archive

 
Categories / ASP.Net Tutorial / ADO Net Database
 

ObjectDataSource binds DataBound controls such as the GridView, DetailsView, and FormView controls to a component

using System; using System.Web.Configuration; using System.Collections.Generic; public class ProductCollection {     public List<string> GetProducts()     {         List<string> products = new List<string>();         products.Add("A");         products.Add("B");         products.Add("C");         return products;     } } File: index.aspx <%@ Page Language="C#" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"    "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head id="Head1" runat="server">     <title>Show Product Collection</title> </head> <body>     <form id="form1" runat="server">     <div>     <asp:GridView         id="grdProducts"         DataSourceID="srcProducts"         Runat="server" />     <asp:ObjectDataSource         id="srcProducts"         TypeName="ProductCollection"         SelectMethod="GetProducts"         Runat="server" />     </div>     </form> </body> </html> File: Web.config <configuration>   <connectionStrings>     <add name="Products"           connectionString="Data Source=.\SQLEXPRESS;          AttachDbFilename=|DataDirectory|MyDatabase.mdf;Integrated Security=True;User Instance=True" />   </connectionStrings> </configuration>