At first I couldn't figure out how to use the FetchByQuery with the objectdatasource since in requires a Query object and the objectdatasource wizard only seems to be able to pass strings. I found that I can provide the query object to the objectdatasource by using the objectdatasource selecting event. I have listed some example code below:

<br /><br /><%@ Page Language="C#" MasterPageFile="~/site.master" AutoEventWireup="true" CodeFile="EditGreenfield.aspx.cs" Inherits="EditGreenfield" Title="Untitled Page" %><br /><br /><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"><br /> <asp:DropDownList ID="MainTableDropDownList" runat="server" DataSourceID="MainTableObjectDataSource" DataTextField="ProjectName" DataValueField="ID"><br /> </asp:DropDownList><br /><br /> <asp:Button ID="ChangeProjectButton" runat="server" OnClick="ChangeProjectButton_Click"<br /> Text="Change Project" /><br /> <br /><br /> <asp:ObjectDataSource ID="MainTableObjectDataSource" runat="server" SelectMethod="FetchAll"<br /> TypeName="Greenfield.MainTable"></asp:ObjectDataSource><br /> <br /><br /> <asp:Wizard ID="Wizard1" runat="server" ActiveStepIndex="0"><br /> <WizardSteps><br /> <asp:WizardStep runat="server" Title="Protective Services"><br /> <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" DeleteMethod="Delete"<br /> InsertMethod="Insert" SelectMethod="FetchByQuery" TypeName="Greenfield.ProtectiveServicesController"<br /> UpdateMethod="Update" OnSelecting="ObjectDataSource1_Selecting"><br /> <InsertParameters><br /> <asp:Parameter Name="MainTableFK" Type="Int32" /><br /> <asp:Parameter Name="FireInsuranceClassRating" Type="String" /><br /> <asp:Parameter Name="FireStationType" Type="String" /><br /> <asp:Parameter Name="DistanceToNearestFireStation" Type="String" /><br /> <asp:Parameter Name="DistanceToNearestPoliceStation" Type="String" /><br /> <asp:Parameter Name="PolicePatrolProvided24Hours" Type="String" /><br /> </InsertParameters><br /> <DeleteParameters><br /> <asp:Parameter Name="ID" Type="Object" /><br /> </DeleteParameters><br /> <UpdateParameters><br /> <asp:Parameter Name="ID" Type="Int32" /><br /> <asp:Parameter Name="MainTableFK" Type="Int32" /><br /> <asp:Parameter Name="FireInsuranceClassRating" Type="String" /><br /> <asp:Parameter Name="FireStationType" Type="String" /><br /> <asp:Parameter Name="DistanceToNearestFireStation" Type="String" /><br /> <asp:Parameter Name="DistanceToNearestPoliceStation" Type="String" /><br /> <asp:Parameter Name="PolicePatrolProvided24Hours" Type="String" /><br /> </UpdateParameters><br /> <SelectParameters><br /> <asp:Parameter Name="qry" Type="Object" /><br /> </SelectParameters><br /> </asp:ObjectDataSource><br /> <br /><br /> <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="ObjectDataSource1"<br /> Height="50px" Width="125px" DataKeyNames="ID,MainTableFK" ><br /> <Fields><br /> <asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True" SortExpression="ID" /><br /> <asp:BoundField DataField="MainTableFK" HeaderText="MainTableFK" ReadOnly="True"<br /> SortExpression="MainTableFK" /><br /> <asp:BoundField DataField="FireInsuranceClassRating" HeaderText="FireInsuranceClassRating"<br /> SortExpression="FireInsuranceClassRating" /><br /> <asp:BoundField DataField="FireStationType" HeaderText="FireStationType" SortExpression="FireStationType" /><br /> <asp:BoundField DataField="DistanceToNearestFireStation" HeaderText="DistanceToNearestFireStation"<br /> SortExpression="DistanceToNearestFireStation" /><br /> <asp:BoundField DataField="DistanceToNearestPoliceStation" HeaderText="DistanceToNearestPoliceStation"<br /> SortExpression="DistanceToNearestPoliceStation" /><br /> <asp:BoundField DataField="PolicePatrolProvided24Hours" HeaderText="PolicePatrolProvided24Hours"<br /> SortExpression="PolicePatrolProvided24Hours" /><br /> <asp:CommandField ShowEditButton="True" /><br /> </Fields><br /> </asp:DetailsView><br /> <br /><br /> </asp:WizardStep><br /> <asp:WizardStep runat="server" StepType="Finish" Title="Finish"><br /> </asp:WizardStep><br /> </WizardSteps><br /> </asp:Wizard><br /></asp:Content><br /><br /><br />using System;<br />using System.Data;<br />using System.Configuration;<br />using System.Collections;<br />using System.Web;<br />using System.Web.Security;<br />using System.Web.UI;<br />using System.Web.UI.WebControls;<br />using System.Web.UI.WebControls.WebParts;<br />using System.Web.UI.HtmlControls;<br />using Greenfield;<br />using SubSonic;<br />public partial class EditGreenfield : System.Web.UI.Page<br />{<br /> protected void Page_Load(object sender, EventArgs e)<br /> {<br /> }<br /><br /> protected void ChangeProjectButton_Click(object sender, EventArgs e)<br /> {<br /> DetailsView1.DataBind();<br /> }<br /> protected void ObjectDataSource1_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)<br /> {<br /> Query qry = new Query(ProtectiveServices.Schema);<br /> qry.AddWhere("MainTableFK", Comparison.Equals, MainTableDropDownList.SelectedValue);<br /> e.InputParameters["qry"] = qry;<br /> }<br />}<br /><br />

Welcome

Welcome to my blog. Programming information and discussion to follow.