No defining declaration found for implementing declaration of partial method

Question

0.00/5 (No votes)

See more:

Hello

I am new to linq and I am using ‘LINQ To Sql’ Tutorial Series , I used the code like below for updating the phone number of

customers table (sample 1) and then add a class and named it "customer.cs" (sample 2)

for preventing bogus phone numbers from being added into our database.

Now when I debug the program I take the error like below (sample 3) ,

please help what is the problem actually I don't know how I have to define partial class

just I know this class should works with "customer" in northwind.desiner.cs.

Thanks in advanced.

Sample 1:

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

namespace WebApplication1
{
    public partial class _Default : System.Web.UI.Page
    {
        

        protected void Page_Load(object sender, EventArgs e)
        {
           NorthwindDataContext northwind=new NorthwindDataContext();
           Customer mycustumer = northwind.Customers.Single(c => c.CompanyName == "B's Beverages");
           mycustumer.Phone = "999";
           northwind.SubmitChanges();
           



        }
    }
}

sample 2:

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Text.RegularExpressions;


namespace WebApplication1
{
    public partial class customer
    {
        partial void onphonechanging(string value)
        {
            Regex phoneNumber = new Regex(@"^[2-9]\d{2}-\d{3}-\d{4}$");

            if (phoneNumber.IsMatch(value) == false)
            {
                throw new Exception("not valid");
            }

            
        }
    }
}

Posted 13-Oct-11 2:50am

alimahdipour

Updated 13-Oct-11 2:52am

sravani.v

v2

Add a 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)

Bala Selvanayagam · Accepted Answer · 2011-10-13T04:56:00

Just comment your partial class customer and do the followings and should work

1.Go to your *.dbml file

2.Right click on the "customer" class and select "View Code" and put your partial validation class there, following is the sample validation i have tried

C#

namespace CSUTOMER_PHONE_NUMBER
{
    partial class Customer
    {
        partial void OnPhoneChanging(string value)
        {
            if (value.Length ==1)
            throw new System.Exception ("not valid");
        }
    }
}

and when you set the value for the phone number it works

try
           {
               DataClasses1DataContext db = new DataClasses1DataContext();
               Customer mycustumer = db.Customers.Single(c => c.CompanyName == "B's Beverages");
               mycustumer.Phone = "1";
               db.SubmitChanges();

               MessageBox.Show("OK");
           }
           catch (Exception ex)
           {
               MessageBox.Show(ex.Message);

           }

Hope this helps