如何在Web方法中显示我的错误消息 [英] How to show my error messages in web method

问题描述

当我插入数据时，重复项不被允许并显示已存在的错误消息，如果不重复插入成功完成。请告诉我该怎么做呢



我尝试过：

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:

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

< br $> b $ b webmethod

webmethod

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

推荐答案

.ajax（{
类型： POST，
url： WebForm1.aspx / AddRecord，
data：' {A：' + a + ' }'，
contentType： application / json; charset = utf-8，
dataType： json
）}

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

webmethod

webmethod

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

Web方法OOTB在客户端处理错误，您只需要抛出错误消息。



请参阅示例代码以供参考在下面。



在Web服务器端网页方法

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

[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客户

At Client

.ajax（{
type： POST，
url： wsGetData.asmx / getXXXXXX，
data： JSON .stringify（{UserId：userId}），
contentType：< span class =code-string> application / json; charset = utf-8，
dataType： json，
成功：CallBackFunction，
错误： function （xhr，status，error）{
var exception = JSON .parse（xhr.responseText）;
ErrorMessageModel（' 错误'，exception.Message）;
}，
失败： function （响应）{
ErrorMessageModel（' 错误'，response.d）;
}
}）;

.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); } });

这篇关于如何在Web方法中显示我的错误消息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！