Handling the Object Creating Event


File: ProductsByCategory.cs

using System;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Web.Configuration;

public class ProductsByCategory
{
    private readonly string _conString;
    private readonly string _ProductCategory;

    public SqlDataReader GetProducts()
    {
        SqlConnection con = new SqlConnection(_conString);

        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "SELECT Title,Director,DateReleased FROM Products"
            + " JOIN ProductCategories ON Products.CategoryId=ProductCategories.Id"
            + " WHERE ProductCategories.Name=@CategoryName";

        cmd.Parameters.AddWithValue("@CategoryName", _ProductCategory);

        con.Open();
        return cmd.ExecuteReader(CommandBehavior.CloseConnection);
    }

    public ProductsByCategory(string ProductCategory)
    {
        _ProductCategory = ProductCategory;
        _conString = WebConfigurationManager.ConnectionStrings["Products"]. ConnectionString;
    }
}
File: Web.config

<configuration>
  <connectionStrings>
    <add name="Products" 
         connectionString="Data Source=.\SQLEXPRESS;
         AttachDbFilename=|DataDirectory|MyDatabase.mdf;Integrated Security=True;User Instance=True" />
  </connectionStrings>
</configuration>

File: Default.aspx

<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<script runat="server">

    protected void srcProducts_ObjectCreating(object sender, ObjectDataSourceEventArgs e)
    {
        ProductsByCategory Products = new ProductsByCategory("Adventure");
        e.ObjectInstance = Products;
    }
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>Adventure Products</title>
</head>
<body>
    <form id="form1" runat="server">
    <asp:GridView
        id="grdProducts"
        DataSourceID="srcProducts"
        Runat="server" />

    <asp:ObjectDataSource
        id="srcProducts"
        TypeName="ProductsByCategory"
        SelectMethod="GetProducts"
        OnObjectCreating="srcProducts_ObjectCreating"
        Runat="server" />

    </div>
    </form>
</body>
</html>

Related examples in the same category

1.	Binding to a LINQ to SQL Query
2.	Binding to a Web Service
3.	Using Parameters with the ObjectDataSource Control
4.	Using Different Parameter Types
5.	Passing Objects as Parameters
6.	Filtering Data
7.	Handling ObjectDataSource Control Events
8.	Handling Method Errors
9.	Concurrency and the ObjectDataSource Control, ConflictDetection: CompareAllValues / OverwriteChanges
10.	Creating a Custom ObjectDataSource Control
11.	Creating Custom Parameter Objects
12.	Creating a Page Property Parameter
13.	Define your own collection for ObjectDataSource
14.	objectdatasource with control parameter
15.	GridView with ObjectDataSource
16.	ObjectDataSource with selectmethod, deletemethod, updatemethod, insertmethod
17.	ObjectDataSource based on XML
18.	ObjectDataSource and backend database

Handling the Object Creating Event : ObjectDataSource « ADO.net Database « ASP.Net

Related examples in the same category