locked
Cannot Edit an Ad!!! RRS feed

  • Question

  • User327079555 posted

     

    <UpdateCommand>
    									<DBCOMMAND class=st CommandType=""StoredProcedure" ModifiedByUser="False">
    										<COMMANDTEXT>dbo.UpdateAd</COMMANDTEXT>
    										<PARAMETERS>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="MemberId" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Title" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumn="Description" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumn="URL" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" ProviderType="Money" Scale="4" Size="8" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@City" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="City" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@State" Precision="0" ProviderType="NVarChar" Scale="0" Size="2" SourceColumn="State" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Zip" Precision="0" ProviderType="NVarChar" Scale="0" Size="5" SourceColumn="Zip" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Beds" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Beds" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Baths" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Baths" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AirConditioning" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="AirConditioning" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FitnessCenter" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="FitnessCenter" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HardwoodFloors" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="HardwoodFloors" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Laundry" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Laundry" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Pool" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Pool" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WasherDryerInUnit" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="WasherDryerInUnit" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WasherDryerHookUps" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="WasherDryerHookUps" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WalkInClosets" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="WaslkInClosets" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OnStreetParking" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="OnStreetParking" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
                          <PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Patio" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Patio" SourceColumnNullMapping="False" SourceVersion="Current">
                          </PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GarageParking" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="GarageParking" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
                          <PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Balcony" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Balcony" SourceColumnNullMapping="False" SourceVersion="Current">
                          </PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NumberOfSpots" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="NumberOfSpots" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AllCats" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="AllCats" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AllDogs" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="AllDogs" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SmallDogs" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="SmallDogs" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RegisteredStudentHome" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="RegisteredStudentHome" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Dishwasher" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Dishwasher" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Furnished" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Furnished" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fireplace" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Fireplace" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DiningRoom" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="DiningRoom" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WheelChairAccess" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="WheelChairAccess" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SecurityAccess" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="SecurityAccess" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    											<PARAMETER class=st AllowDbNull=""True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WiFi" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="WiFi" SourceColumnNullMapping="False" SourceVersion="Current">
    											</PARAMETER>
    										</PARAMETERS>
    									</DBCOMMAND>
    								</UPDATECOMMAND>
     This is KILLING me!  I don't understand why this is not working,

    Here is my ObjectDataSource code for EditAd.aspx:

     

    <asp:ObjectDataSource ID="AdDataSource" Runat="server" TypeName="GCDC.StudentHousing.Listings.BusinessLogicLayer.AdsDB"
                        SelectMethod="GetAdById" UpdateMethod="UpdateAd" OnUpdated="AdDataSource_Updated"
                        OnSelected="AdDataSource_Selected" OldValuesParameterFormatString="original_{0}">
                        <UPDATEPARAMETERS>
                        <?xml:namespace prefix = asp /><asp:Parameter class=st Name=""original_Id" Type="Int32">
                            <asp:ProfileParameter class=st Type=""Int32" Name="memberId" PropertyName="MemberId">
                            <asp:Parameter class=st Type=""String" Name="title"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="description"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="URL"></asp:Parameter>
                            <asp:Parameter class=st Type=""Decimal" Name="price"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="city"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="state"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="zip"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="beds"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="baths"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="AirConditioning"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="FitnessCenter"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="HardwoodFloors"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="Laundry"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="Pool"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="WasherDryerInUnit"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="WasherDryerHookUps"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="WalkInClosets"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="OnStreetParking"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="Patio"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="GarageParking"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="Balcony"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="NumberOfSpots"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="AllCats"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="AllDogs"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="SmallDogs"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="RegisteredStudentHome"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="Dishwasher"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="Furnished"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="Fireplace"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="DiningRoom"></asp:Parameter>                        
                            <asp:Parameter class=st Type=""String" Name="WheelChairAccess"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="SecurityAccess"></asp:Parameter>
                            <asp:Parameter class=st Type=""String" Name="WiFi"></asp:Parameter>
                            <asp:Parameter class=st Type=""Boolean" Name="isRelisting" DefaultValue="False"></asp:Parameter>
                        </UPDATEPARAMETERS>
                        <SELECTPARAMETERS>
                            <asp:QueryStringParameter class=st Name=""adId" DefaultValue="0" Type="Int32" QueryStringField="id"></asp:QueryStringParameter>
                        </SELECTPARAMETERS>
                    

     And here is the code from Ads.cs:

    public static void UpdateAd(int original_Id, int memberId, string title, string description, string url, decimal price, string city, string state, string zip,
                string beds, string baths, string AirConditioning, string FitnessCenter, string HardwoodFloors, string Laundry, string Pool, string WasherDryerInUnit, string WasherDryerHookUps,
                string WalkInClosets, string OnStreetParking, string Patio, string GarageParking, string Balcony, string NumberOfSpots, string AllCats, string AllDogs, string SmallDogs, string RegisteredStudentHome,
                string Dishwasher, string Furnished, string Fireplace, string DiningRoom, string WheelChairAccess, string SecurityAccesss, string WiFi, bool isRelisting)
            {
                if (url == null)
                    url = String.Empty;
                using (AdsDataAdapter db = new AdsDataAdapter())
                {
                    db.UpdateAd(original_Id, memberId,
                        HttpUtility.HtmlEncode(title),
                        HttpUtility.HtmlEncode(description),
                        HttpUtility.UrlEncode(url),
                        price,
                        HttpUtility.HtmlEncode(city),
                        HttpUtility.HtmlEncode(state),
                        HttpUtility.HtmlEncode(zip),
                        HttpUtility.HtmlEncode(beds),
                        HttpUtility.HtmlEncode(baths),
                        HttpUtility.HtmlEncode(AirConditioning),
                        HttpUtility.HtmlEncode(FitnessCenter),
                        HttpUtility.HtmlEncode(HardwoodFloors),
                        HttpUtility.HtmlEncode(Laundry),
                        HttpUtility.HtmlEncode(Pool),
                        HttpUtility.HtmlEncode(WasherDryerInUnit),
                        HttpUtility.HtmlEncode(WasherDryerHookUps),
                        HttpUtility.HtmlEncode(WalkInClosets),
                        HttpUtility.HtmlEncode(OnStreetParking),
                        HttpUtility.HtmlEncode(Patio),
                        HttpUtility.HtmlEncode(GarageParking),
                        HttpUtility.HtmlEncode(Balcony),
                        HttpUtility.HtmlEncode(NumberOfSpots),
                        HttpUtility.HtmlEncode(AllCats),
                        HttpUtility.HtmlEncode(AllDogs),
                        HttpUtility.HtmlEncode(SmallDogs),
                        HttpUtility.HtmlEncode(RegisteredStudentHome),
                        HttpUtility.HtmlEncode(Dishwasher),
                        HttpUtility.HtmlEncode(Furnished),
                        HttpUtility.HtmlEncode(Fireplace),
                        HttpUtility.HtmlEncode(DiningRoom),                                        
                        HttpUtility.HtmlEncode(WheelChairAccess),
                        HttpUtility.HtmlEncode(SecurityAccesss),
                        HttpUtility.HtmlEncode(WiFi));
                }
            }

     </asp:ProfileParameter></asp:Parameter>And here is the code from Ads.xsd:

     

    <UpdateCommand>
    									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
    										<CommandText>dbo.UpdateAd</CommandText>
    										<Parameters>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="MemberId" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Title" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumn="Description" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumn="URL" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" ProviderType="Money" Scale="4" Size="8" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@City" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="City" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@State" Precision="0" ProviderType="NVarChar" Scale="0" Size="2" SourceColumn="State" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Zip" Precision="0" ProviderType="NVarChar" Scale="0" Size="5" SourceColumn="Zip" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Beds" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Beds" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Baths" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Baths" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AirConditioning" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="AirConditioning" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FitnessCenter" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="FitnessCenter" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HardwoodFloors" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="HardwoodFloors" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Laundry" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Laundry" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Pool" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Pool" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WasherDryerInUnit" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="WasherDryerInUnit" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WasherDryerHookUps" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="WasherDryerHookUps" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WalkInClosets" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="WaslkInClosets" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OnStreetParking" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="OnStreetParking" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
                          <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Patio" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Patio" SourceColumnNullMapping="False" SourceVersion="Current">
                          </Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GarageParking" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="GarageParking" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
                          <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Balcony" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Balcony" SourceColumnNullMapping="False" SourceVersion="Current">
                          </Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NumberOfSpots" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="NumberOfSpots" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AllCats" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="AllCats" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AllDogs" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="AllDogs" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SmallDogs" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="SmallDogs" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RegisteredStudentHome" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="RegisteredStudentHome" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Dishwasher" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Dishwasher" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Furnished" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Furnished" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fireplace" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="Fireplace" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DiningRoom" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="DiningRoom" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WheelChairAccess" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="WheelChairAccess" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SecurityAccess" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="SecurityAccess" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WiFi" Precision="0" ProviderType="NVarChar" Scale="0" Size="3" SourceColumn="WiFi" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    										</Parameters>
    									</DbCommand>
    								</UpdateCommand>

     And here are the mappings from Ads.xsd:

    <Mappings>
    							<Mapping SourceColumn="Id" DataSetColumn="Id" />
    							<Mapping SourceColumn="MemberId" DataSetColumn="MemberId" />
    							<Mapping SourceColumn="CategoryId" DataSetColumn="CategoryId" />
    							<Mapping SourceColumn="Title" DataSetColumn="Title" />
    							<Mapping SourceColumn="Description" DataSetColumn="Description" />
    							<Mapping SourceColumn="URL" DataSetColumn="URL" />
    							<Mapping SourceColumn="Price" DataSetColumn="Price" />
    							<Mapping SourceColumn="State" DataSetColumn="State" />
    							<Mapping SourceColumn="Zip" DataSetColumn="Zip" />
    							<Mapping SourceColumn="ExpirationDate" DataSetColumn="ExpirationDate" />
    							<Mapping SourceColumn="DateCreated" DataSetColumn="DateCreated" />
    							<Mapping SourceColumn="DateApproved" DataSetColumn="DateApproved" />
    							<Mapping SourceColumn="NumViews" DataSetColumn="NumViews" />
    							<Mapping SourceColumn="NumResponses" DataSetColumn="NumResponses" />
    							<Mapping SourceColumn="AdLevel" DataSetColumn="AdLevel" />
    							<Mapping SourceColumn="AdStatus" DataSetColumn="AdStatus" />
    							<Mapping SourceColumn="AdType" DataSetColumn="AdType" />
    							<Mapping SourceColumn="PreviewImageId" DataSetColumn="PreviewImageId" />
    							<Mapping SourceColumn="Baths" DataSetColumn="Baths" />
    							<Mapping SourceColumn="AirConditioning" DataSetColumn="AirConditioning" />
    							<Mapping SourceColumn="FitnessCenter" DataSetColumn="FitnessCenter" />
    							<Mapping SourceColumn="HardwoodFloors" DataSetColumn="HardwoodFloors" />
    							<Mapping SourceColumn="Laundry" DataSetColumn="Laundry" />
    							<Mapping SourceColumn="Pool" DataSetColumn="Pool" />
    							<Mapping SourceColumn="WasherDryerInUnit" DataSetColumn="WasherDryerInUnit" />
    							<Mapping SourceColumn="WasherDryerHookUps" DataSetColumn="WasherDryerHookUpd" />
    							<Mapping SourceColumn="WalkInClosets" DataSetColumn="WalkInClosets" />
    							<Mapping SourceColumn="OnStreetParking" DataSetColumn="OnStreetParking" />
    							<Mapping SourceColumn="GarageParking" DataSetColumn="GarageParking" />
    							<Mapping SourceColumn="NumberOfSpots" DataSetColumn="NumberOfSpots" />
    							<Mapping SourceColumn="AllCats" DataSetColumn="AllCats" />
    							<Mapping SourceColumn="AllDogs" DataSetColumn="AllDogs" />
    							<Mapping SourceColumn="SmallDogs" DataSetColumn="SmallDogs" />
    							<Mapping SourceColumn="RegisteredStudentHome" DataSetColumn="RegisteredStudentHome" />
    							<Mapping SourceColumn="Dishwasher" DataSetColumn="Dishwasher" />
    							<Mapping SourceColumn="Furnished" DataSetColumn="Furnished" />
    							<Mapping SourceColumn="Fireplace" DataSetColumn="Fireplace" />
    							<Mapping SourceColumn="DiningRoom" DataSetColumn="DiningRoom" />
    							<Mapping SourceColumn="Patio" DataSetColumn="Patio" />
    							<Mapping SourceColumn="Balcony" DataSetColumn="Balcony" />
    							<Mapping SourceColumn="WheelChairAccess" DataSetColumn="WheelChairAccess" />
    							<Mapping SourceColumn="SecurityAccess" DataSetColumn="SecurityAccess" />
    							<Mapping SourceColumn="WiFi" DataSetColumn="WiFi" />
    							<Mapping SourceColumn="CategoryName" DataSetColumn="CategoryName" />
    						</Mappings>

     And here is the OTHER UpdateAd from Ads.xsd:

    <DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.dbo.UpdateAd" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="UpdateAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
    								<SelectCommand>
    									<DbCommand CommandType="StoredProcedure" ModifiedByUser="True">
    										<CommandText>dbo.UpdateAd</CommandText>
    										<Parameters>
    											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" Scale="0" Size="2500" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" Scale="0" Size="500" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" Scale="4" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@City" Precision="0" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@State" Precision="0" Scale="0" Size="2" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Zip" Precision="0" Scale="0" Size="5" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Beds" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Baths" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AirConditioning" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FitnessCenter" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HardwoodFloors" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Laundry" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Pool" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WasherDryerInUnit" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WasherDryerHookUps" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WalkInClosets" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OnStreetParking" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
                          <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Patio" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
                          </Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GarageParking" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
                          <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Balcony" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
                          </Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NumberOfSpots" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AllCats" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AllDogs" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SmallDogs" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RegisteredStudentHome" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Dishwasher" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Furnished" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fireplace" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DiningRoom" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WheelChairAccess" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SecurityAccess" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WiFi" Precision="0" Scale="0" Size="3" SourceColumnNullMapping="False" SourceVersion="Current">
    											</Parameter>
    										</Parameters>
    									</DbCommand>
    								</SelectCommand>
    							</DbSource>

     And here is the error I get when I click the Save button on EditAd.aspx:

    Server Error in '/___GCDC' Application.

    ObjectDataSource 'AdDataSource' could not find a non-generic method 'UpdateAd' that has parameters: original_Id, memberId, Title, Description, URL, Price, City, State, Zip, Beds, Baths, AirConditioning, FitnessCenter, HardwoodFloors, Laundry, Pool, WasherDryerInUnit, WasherDryerHookUps, WalkInClosets, OnStreetParking, Patio, GarageParking, Balcony, NumberOfSpots, AllCats, AllDogs, SmallDogs, RegisteredStudentHome, Dishwasher, Furnished, Fireplace, DiningRoom, WheelChairAccess, SecurityAccess, WiFi, isRelisting.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.InvalidOperationException: ObjectDataSource 'AdDataSource' could not find a non-generic method 'UpdateAd' that has parameters: original_Id, memberId, Title, Description, URL, Price, City, State, Zip, Beds, Baths, AirConditioning, FitnessCenter, HardwoodFloors, Laundry, Pool, WasherDryerInUnit, WasherDryerHookUps, WalkInClosets, OnStreetParking, Patio, GarageParking, Balcony, NumberOfSpots, AllCats, AllDogs, SmallDogs, RegisteredStudentHome, Dishwasher, Furnished, Fireplace, DiningRoom, WheelChairAccess, SecurityAccess, WiFi, isRelisting.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:

    [InvalidOperationException: ObjectDataSource 'AdDataSource' could not find a non-generic method 'UpdateAd' that has parameters: original_Id, memberId, Title, Description, URL, Price, City, State, Zip, Beds, Baths, AirConditioning, FitnessCenter, HardwoodFloors, Laundry, Pool, WasherDryerInUnit, WasherDryerHookUps, WalkInClosets, OnStreetParking, Patio, GarageParking, Balcony, NumberOfSpots, AllCats, AllDogs, SmallDogs, RegisteredStudentHome, Dishwasher, Furnished, Fireplace, DiningRoom, WheelChairAccess, SecurityAccess, WiFi, isRelisting.]
       System.Web.UI.WebControls.ObjectDataSourceView.GetResolvedMethodData(Type type, String methodName, IDictionary allParameters, DataSourceOperation operation) +1122670
       System.Web.UI.WebControls.ObjectDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +1008
       System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +92
       System.Web.UI.WebControls.FormView.HandleUpdate(String commandArg, Boolean causesValidation) +835
       System.Web.UI.WebControls.FormView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +509
       System.Web.UI.WebControls.FormView.OnBubbleEvent(Object source, EventArgs e) +95
       System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
       System.Web.UI.WebControls.FormViewRow.OnBubbleEvent(Object source, EventArgs e) +113
       System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
       System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
       System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +166
       System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
       System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
       System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
    


    Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082
    <!-- [InvalidOperationException]: ObjectDataSource 'AdDataSource' could not find a non-generic method 'UpdateAd' that has parameters: original_Id, memberId, Title, Description, URL, Price, City, State, Zip, Beds, Baths, AirConditioning, FitnessCenter, HardwoodFloors, Laundry, Pool, WasherDryerInUnit, WasherDryerHookUps, WalkInClosets, OnStreetParking, Patio, GarageParking, Balcony, NumberOfSpots, AllCats, AllDogs, SmallDogs, RegisteredStudentHome, Dishwasher, Furnished, Fireplace, DiningRoom, WheelChairAccess, SecurityAccess, WiFi, isRelisting. at System.Web.UI.WebControls.ObjectDataSourceView.GetResolvedMethodData(Type type, String methodName, IDictionary allParameters, DataSourceOperation operation) at System.Web.UI.WebControls.ObjectDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) at System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) at System.Web.UI.WebControls.FormView.HandleUpdate(String commandArg, Boolean causesValidation) at System.Web.UI.WebControls.FormView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) at System.Web.UI.WebControls.FormView.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) at System.Web.UI.WebControls.FormViewRow.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) at System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) [HttpUnhandledException]: Exception of type 'System.Web.HttpUnhandledException' was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP._editlisting_aspx.ProcessRequest(HttpContext context) in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\___gcdc\462e1218\b9119525\App_Web_fyi7ofzv.22.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) -->

     

    Monday, April 13, 2009 8:54 PM

All replies

  • User327079555 posted

    And here is the stored procedure:

     

    ALTER PROCEDURE UpdateAd
    	@Id int,
    	@MemberId int,
    	@Title nvarchar(100),
    	@Description ntext,
    	@URL nvarchar(500),
    	@Price money,
    	@City varchar(50),
    	@State char(2),
    	@Zip nvarchar(5),
    	@Beds varchar(3),
    	@Baths varchar(3),
    	@AirConditioning varchar(3),
    	@FitnessCenter varchar(3),
    	@HardwoodFloors varchar(3),
    	@Laundry varchar(3),
    	@Pool varchar(3),
    	@WasherDryerInUnit varchar(3),
    	@WasherDryerHookUps varchar(3),
    	@WalkInClosets varchar(3),
    	@OnStreetParking varchar(3),
    	@Patio varchar(3),
    	@GarageParking varchar(3),
    	@Balcony varchar(3),
    	@NumberOfSpots varchar(3),
    	@AllCats varchar(3),
    	@AllDogs varchar(3),
    	@SmallDogs varchar(3),
    	@RegisteredStudentHome varchar(3),
    	@Dishwasher varchar(3),
    	@Furnished varchar(3),
    	@Fireplace varchar(3),
    	@DiningRoom varchar(3),
    	@WheelChairAccess varchar(3),
    	@SecurityAccess varchar(3),
    	@WiFi varchar(3)
    AS
    UPDATE Ads
    SET
    	Title = @Title,
    	[Description] = @Description,
    	Url = @URL,
    	Price = @Price,
    	Zip = @Zip,
    	Beds = @Beds,
    	Baths = @Baths,
    	AirConditioning = @AirConditioning,
    	FitnessCenter = @FitnessCenter,
    	HardwoodFloors = @HardwoodFloors,
    	Laundry = @Laundry,
    	Pool = @Pool,
    	WasherDryerInUnit = @WasherDryerInUnit,
    	WasherDryerHookUps = @WasherDryerHookUps,
    	WalkInClosets = @WalkInClosets,
    	OnStreetParking = @OnStreetParking,
    	Patio = @Patio,
    	GarageParking = @GarageParking,
    	Balcony = @Balcony,
    	NumberOfSpots = @NumberOfSpots,
    	AllCats = @AllCats,
    	AllDogs = @AllDogs,
    	SmallDogs = @SmallDogs,
    	RegisteredStudentHome = @RegisteredStudentHome,
    	Dishwasher = @Dishwasher,
    	Furnished = @Furnished,
    	Fireplace = @Fireplace,
    	DiningRoom = @DiningRoom,
    	WheelChairAccess = @WheelChairAccess,
    	SecurityAccess = @SecurityAccess,
    	WiFi = @WiFi
    WHERE
    	Id = @Id
    
     

     

    Please help!!!
    Monday, April 13, 2009 9:11 PM
  • User327079555 posted

    No responses?  Please...  I know it has to be some simple thing I am missing, but the code seems right to me.

    And by the way... you need to vertically scroll to see everything.

    Thank you!

    Monday, April 13, 2009 10:31 PM
  • User327079555 posted

    Could someone PLEASE take a look at this and respond?

    Thank you!

    Tuesday, April 14, 2009 7:12 AM
  • User327079555 posted

    146 views?  And no response?

    I know it's something simple, I just need another set of eyes.  DarKnight?  You out there?  [:)]

    Tuesday, April 14, 2009 9:02 AM
  • User-1853252149 posted

    Did you look at:

    http://www.google.com/search?q=could+not+find+a+non-generic+method

    Jeff

    Tuesday, April 14, 2009 10:34 AM
  • User327079555 posted

    Dude... I have been banging my head on this one for three days now.  Everything looks right!  I don't get it.  I've tried all kinds of things.  I just don't understand.

    Tuesday, April 14, 2009 1:58 PM
  • User327079555 posted

    Am I seriously missing something here?!  Has anyone looked at my post fully?  I don't understand!  This does NOT makes sense...

    How can this work "out-of-the-box", but once you add parameters, it gives this error?!

    Tuesday, April 14, 2009 4:55 PM
  • User327079555 posted

    So, that's it?  Nothing...

    Tuesday, April 14, 2009 8:41 PM
  • User730446648 posted

    I had the same error a while back.
    And I hate to tell you, but my fix was doing them one by one.

    You missed a stupid mistake somewhere loading so many at once.
    At least that was my issue.

    So what I did is copied and pasted in all of the original upate sections.
    Test the update, should work.

    And then add a update column one by one.
    And test often.

    Maybe even make some backups as you go.
    I know it's a pain, but it'll work.

    Good Luck

     

    Tuesday, April 14, 2009 11:31 PM
  • User327079555 posted

    I had the same error a while back.
    And I hate to tell you, but my fix was doing them one by one.

    You missed a stupid mistake somewhere loading so many at once.
    At least that was my issue.

    So what I did is copied and pasted in all of the original upate sections.
    Test the update, should work.

    And then add a update column one by one.
    And test often.

    Maybe even make some backups as you go.
    I know it's a pain, but it'll work.

    Good Luck

    Man... Am I glad to hear from you!

    I had a feeling that is what I would have to do.  I actually copied the original EditAd.aspx from the kit, and copied and pasted the sections for the XSD, SP, Ads.cs, et cera... and it didn't work.

    I think I am just going to delete what I have and try to get back to as original as possible.  I was getting an error for the Description box as well, but I have no idea where that came from.  This is just very frusrating, because everything seems like it is there and in the right order.  It's a killer man.  And NOW, I get duplicate parameters!  Like: 

    SecurityAccess, WiFi, SecurityAccess

    Now THAT'S strange!  I have no idea why it would put TWO SecurityAccess parameters when clearly I only have one.

    Whatever...

    Thanks, dude... Tomorrow is another day.

    Cheers.

    Tuesday, April 14, 2009 11:39 PM
  • User327079555 posted

    I had the same error a while back.
    And I hate to tell you, but my fix was doing them one by one.

    You missed a stupid mistake somewhere loading so many at once.
    At least that was my issue.

    So what I did is copied and pasted in all of the original upate sections.
    Test the update, should work.

    And then add a update column one by one.
    And test often.

    Maybe even make some backups as you go.
    I know it's a pain, but it'll work.

    Good Luck

     

     

    Well, I re-created the page and all works well now.  I think it had something to do with the mappings in the XSD.  I left those alone.

    Cheers.

    Wednesday, April 15, 2009 12:51 PM