Error on 'OnSqlUpdated' and 'OnSqlUpdating'

Question

0.00/5 (No votes)

See more:

I am facing these 2 errors which state that:

SQL

Error   1   'ASP.appointment_booknewappointment_aspx' does not contain a definition for 'OnSqlUpdated' and no extension method 'OnSqlUpdated' accepting a first argument of type 'ASP.appointment_booknewappointment_aspx' could be found (are you missing a using directive or an assembly reference?)Appointment\Appointment\BookNewAppointment.aspx    96

SQL

Error   2   'ASP.appointment_booknewappointment_aspx' does not contain a definition for 'OnSqlUpdating' and no extension method 'OnSqlUpdating' accepting a first argument of type 'ASP.appointment_booknewappointment_aspx' could be found (are you missing a using directive or an assembly reference?)Appointment\Appointment\BookNewAppointment.aspx    96

My codes seems to be fine but when i run, these 2 errors are shown. I do not really understand as it is my first time trying asp.net transaction.

Here is my .aspx code

C#

<asp:SqlDataSource ID="SqlDataSource2" runat="server"
           ConnectionString="<%$ ConnectionStrings:BORosesConnection %>"
           DeleteCommand="DELETE FROM [Appointment] WHERE [ApptID] = @ApptID"
           InsertCommand="INSERT INTO [Appointment] ([ApptDate], [ApptStartTime], [ApptEndTime], [WeddingPlanner]) VALUES (@ApptDate, @ApptStartTime, @ApptEndTime, @WeddingPlanner)"
           SelectCommand="SELECT * FROM [Appointment]"
           UpdateCommand="UPDATE [Appointment] SET [ApptDate] = @ApptDate, [ApptStartTime] = @ApptStartTime, [ApptEndTime] = @ApptEndTime, [WeddingPlanner] =  @WeddingPlanner WHERE [ApptID] = @ApptID" DataSourceMode="DataReader" OnUpdated="OnSqlUpdated" OnUpdating="OnSqlUpdating">
           <SelectParameters>
           <asp:QueryStringParameter Name="ApptID"
           QueryStringField="AID" Type="Int32" />
           </SelectParameters>
           <DeleteParameters>
               <asp:QueryStringParameter Name="ApptID" QueryStringField="AID" Type="Int32" />
           </DeleteParameters>
           <InsertParameters>
               <asp:ControlParameter Name="ApptDate" ControlId="TextBox1" Type="String" />
               <asp:ControlParameter Name="ApptStartTime" ControlId="ddlStart" Type="String" />
               <asp:ControlParameter Name="ApptEndTime" ControlId="ddlEnd" Type="String" />
               <asp:ControlParameter Name="WeddingPlanner" ControlId="weddingPlanner" Type="String" />
           </InsertParameters>
           <UpdateParameters>
               <asp:ControlParameter Name="ApptDate" ControlId="TextBox1" Type="String" />
               <asp:ControlParameter Name="ApptStartTime" ControlId="ddlStart" Type="String" />
               <asp:ControlParameter Name="ApptEndTime" ControlId="ddlEnd" Type="String" />
               <asp:ControlParameter Name="WeddingPlanner" ControlId="weddingPlanner" Type="String" />
               <asp:QueryStringParameter Name="ApptID" QueryStringField="AID" Type="Int32" />
           </UpdateParameters>
       </asp:SqlDataSource>

Posted 11-Jul-12 4:39am

kellycx

Updated 11-Jul-12 5:18am

v2

Add a Solution

Comments

[no name] 11-Jul-12 11:11am

Just what it says. You are trying to call 2 functions that do not exist in your ASP.appointment_booknewappointment_aspx file. If they do exist you need to add the references for them.

kellycx 11-Jul-12 11:17am

What do they mean by assembly reference?

I have added the 2 functions under my SqlDataSource in the .aspx and in my .cs file. Is that considered as references?

[no name] 11-Jul-12 11:20am

They mean adding a reference to the DLL that contains the definitions for those functions. In this case, Namespace: System.Web.UI.WebControls
Assembly: System.Web (in System.Web.dll)

kellycx 11-Jul-12 11:40am

Alright, Thanks for your help! I managed to write off those errors. Thank You!

[no name] 11-Jul-12 22:57pm

You're welcome

R. Giskard Reventlov 11-Jul-12 18:03pm

You should post this as the solution.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wes Aday · Accepted Answer · 2012-07-11T12:31:00

To take this off the unanswered list

Just what it says. You are trying to call 2 functions that do not exist in your ASP.appointment_booknewappointment_aspx file. If they do exist you need to add the references for them.

They mean adding a reference to the DLL that contains the definitions for those functions. In this case, Namespace: System.Web.UI.WebControls Assembly: System.Web (in System.Web.dll)