How to show my error messages in web method

Question

0.00/5 (No votes)

See more:

when i am inserting the data the duplicates not allowed and show error message like already existed,if not duplicate "insertion successfully completed".please tell me how can i do this

What I have tried:

JavaScript

$.ajax({
           type: "POST",
           url: "WebForm1.aspx/AddRecord",
           data: '{"A": "' + a + '"}',
           contentType: "application/json; charset=utf-8",
           dataType: "json"
)}

webmethod

VB

Public Shared Sub AddRecord(A As String)
       Dim con As New SqlConnection(ConfigurationManager.AppSettings("test").ToString())
       Try
           Dim sqlCmd = New SqlCommand("select Top 1 A from MDT_MOBILE_FEATURES_SETTINGS WHERE A = @a")

           sqlCmd.Parameters.Add(New SqlParameter("@a", a))

           sqlCmd.CommandType = CommandType.Text
           sqlCmd.Connection = con
           con.Open()
           Dim result = sqlCmd.ExecuteScalar()

           If result IsNot Nothing Then
               Throw New Exception(String.Format("A {0} already existed.", FName))

           End If

           Dim sqlInsertCommand = New SqlCommand("INSERT MDT_MOBILE_FEATURES_SETTINGS(A) VALUES(@a)")

           sqlInsertCommand.Parameters.AddWithValue("@a", a)
           sqlInsertCommand.Connection = con


           sqlInsertCommand.ExecuteNonQuery()

           con.Close()
       Catch ex As Exception
           Console.WriteLine("Exception caught: {0}", ex.Message)
       End Try
   End Sub

Posted 16-Jan-17 16:41pm

Devaraneni Laxman Rao

Updated 16-Jan-17 18:59pm

Mohibur Rashid

v2

Add a Solution

Comments

Suvendu Shekhar Giri 16-Jan-17 23:25pm

So what is the issue with the tried code?

Devaraneni Laxman Rao 17-Jan-17 0:40am

i want to display the error message

3 solutions

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)

Singh Vijay Kumar · Answer 1 · 2017-01-16T17:35:00

Web methods OOTB handles error at client you just need to throw your error message.

Refer Sample Code for your reference below.

At Web Server side web method

C#

[WebMethod]
        public List<Models.SubOrdinates> getXXXX(string UserId)
        {
            try
            {
                    DataTable dt = bal.getSubXXXXOrdinates(UserId).Tables[0];
                    List<Models.SubXXXXs> SubXXXX = new List<Models.SubXXXXs>();
                    foreach (DataRow dr in dt.Rows)
                    {
                        DateTime dtPeriodStart = DateTime.MinValue;
                        DateTime dtPeriodEnd = DateTime.MinValue;
                        if (DateTime.TryParse(dr["PeriodStart"].ToString(), out dtPeriodStart) && DateTime.TryParse(dr["PeriodEnd"].ToString(), out dtPeriodEnd))
                        {
                            SubOrdinates.Add(new Models.SubOrdinates()
                            {
                                PeriodStart = dtPeriodStart,
                                PeriodEnd = dtPeriodEnd
                            });
                        }
                    }
                    return SubOrdinates;
            }
            catch (Exception ex)
            {
                string ErrorCode = util.WriteLog(ex.Message);
                throw new Exception("An Error has occured with Error Code : " + ErrorCode + " Please contact support team");
            }
        }

At Client

JavaScript

$.ajax({
        type: "POST",
        url: "wsGetData.asmx/getXXXXXX",
        data: JSON.stringify({ UserId: userId }),
        contentType: "application/json; charset=utf-8",
        dataType: "json",
        success: CallBackFunction,
        error: function (xhr, status, error) {
            var exception = JSON.parse(xhr.responseText);
            ErrorMessageModel('Error', exception.Message);
        },
        failure: function (response) {
            ErrorMessageModel('Error', response.d);
        }
    });

Member 12953334 · Answer 2 · 2017-01-16T17:36:00

Solution 2

well, first of all...

JavaScript

$.ajax({
    type: "POST",
    url: "WebForm1.aspx/AddRecord",
    data: {A: a},
    contentType: "application/json; charset=utf-8",
    dataType: "json"
}).done(function(response){
   // do something with the  response
});

Posted 16-Jan-17 17:36pm

Member 12953334

Ashwin. Shetty · Answer 3 · 2017-01-16T18:59:00

Solution 3

See if this can help, Code is in C# but it should be able to guide you.
Exception Handling in WebAPI[^]

Posted 16-Jan-17 18:59pm

Ashwin. Shetty

How to show my error messages in web method

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us