Accessing SelectMethod Property of SQLDataSource

Sheraz Khan · September 9th, 2007, 08:00 AM

Hi

I am trying to call a Method that retrieve records form a table in database. the method is defined in a class. But for some reason i am unable to access the "SelectMethod" property of the SQLDataSource Object. (The SQLDataSource Object i am trying to use is on line number 12). The Code is written bellow:

1 <%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Products.aspx.vb" Inherits="MyCustomerSupport.Products" %>
2
3 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4
5 <html xmlns="http://www.w3.org/1999/xhtml" >
6 <head runat="server">
7 <title>Untitled Page</title>
8 </head>
9 <body>
10 <form id="form1" runat="server">
11 <div>
12 <asp:SqlDataSource ID="SqlDataSource1" runat="server">
13 <SelectParameters>
14 <asp:Parameter Name="parentCategoryId" Type="Int32" />
15 </SelectParameters>
16 </asp:SqlDataSource>
17 <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:CustomerSupport %>" SelectCommand="sprocCategorySelectList" SelectCommandType="StoredProcedure">
18 <SelectParameters>
19 <asp:ControlParameter ControlID="DropDownList1" Name="parentCategoryId" PropertyName="SelectedValue"
20 Type="Int32" />
21 </SelectParameters>
22 </asp:SqlDataSource>
23 <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:CustomerSupport %>" SelectCommand="sprocCategorySelectList" SelectCommandType="StoredProcedure">
24 <SelectParameters>
25 <asp:ControlParameter ControlID="DropDownList2" Name="parentCategoryId" PropertyName="SelectedValue"
26 Type="Int32" />
27 </SelectParameters>
28 </asp:SqlDataSource>
29 <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" Style="left: 76px;
30 position: relative; top: 0px">
31 </asp:DropDownList>
32 <asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True" Style="left: 186px;
33 position: relative; top: 0px">
34 </asp:DropDownList>
35 <asp:DropDownList ID="DropDownList3" runat="server" AutoPostBack="True" Style="left: 304px;
36 position: relative; top: -2px">
37 </asp:DropDownList></div>
38 </form>
39 </body>
40 </html>
41

Cheers
Sheraz