Using Different Parameter Types : ObjectDataSource « ADO.net Database « ASP.Net






Using Different Parameter Types


<%@ 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" >
<body>
    <form id="form1" runat="server">
    <asp:DropDownList
        id="ddlProductCategory"
        DataSourceID="srcProductCategories"
        DataTextField="Name"
        DataValueField="Id"
        ToolTip="Product Category"
        Runat="server" />
     <asp:Button
        id="btnSelect"
        Text="Select"
        Runat="server" />

     <asp:GridView
         id="grdProducts"
         DataSourceID="srcProducts"
         CssClass="Products"
         GridLines="None"
         Runat="server" />

     <asp:ObjectDataSource
         id="srcProductCategories"
         TypeName="ProductCategories"
         SelectMethod="GetCategories"
         Runat="server" />

     <asp:ObjectDataSource
         id="srcProducts"
         TypeName="ProductCategories"
         SelectMethod="GetProducts"
         Runat="server">
         <SelectParameters>
         <asp:ControlParameter
             Name="CategoryId"
             ControlID="ddlProductCategory" />
         </SelectParameters>
     </asp:ObjectDataSource>
     </form>
</body>
</html>

            
File: ProductCategories.cs

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

public class ProductCategories
{
    private readonly string _conString;

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

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

        cmd.Parameters.AddWithValue("@CategoryId", categoryId);

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

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

        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "SELECT Id,Name FROM ProductCategories";

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

    public ProductCategories()
    {
        _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>

 








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.Passing Objects as Parameters
5.Filtering Data
6.Handling ObjectDataSource Control Events
7.Handling Method Errors
8.Handling the Object Creating Event
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