如何使用jQuery和JSON在asp.net中保存数据到数据库中 [英] How to save data into database using jquery and json in asp.net

问题描述

我工作的一个应用程序来存储使用jQuery和放数据到数据库; JSON。

I am working on an application to store data into database using jquery & json.

我的脚本功能：

<script type="text/javascript">
    function test() {
        $(document).ready(function () {
            var Email = document.getElementById('<%= txtEmail.ClientID %>').value;
            var Message = document.getElementById('<%= txtMessage.ClientID %>').value;
            var Name = document.getElementById('<%= txtMessage.ClientID %>').value;
            var ID=32;
            $.ajax({
                type: "POST",
                url: "Detail.aspx/InsertMethod",
                data: "{'Name':'" + Name + "'Email:'" + Email + "'Message:'" + Message + "'ID:'"+ID+"'}",
                dataType: "json",
                contentType: "application/json; charset=utf-8",
                success: function (data) {
                    var returnedstring = data.d;

                }
            });

        });
    }
</script>

我的设计是： -

My design is:-

<table>
                                    <tr>
                                        <td>
                                            <label>Name</label>
                                        </td>
                                        <td>input type="text" id="txtName" runat="server" class="form-control">
                                        <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="txtName"
                                            Display="Dynamic" SetFocusOnError="true" ErrorMessage="Enter Name." ValidationGroup="Comment">
                                        </asp:RequiredFieldValidator>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            <label>Email</label>
                                        </td>
                                        <td>asp:TextBox ID="txtEmail" runat="server" CssClass="form-control"></asp:TextBox>
                                        <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="txtEmail"
                                            Display="Dynamic" SetFocusOnError="true" ErrorMessage="Enter Email." ValidationGroup="Comment">
                                        </asp:RequiredFieldValidator>
                                            <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="txtEmail"
                                                SetFocusOnError="true" ValidationExpression="^[a-z0-9_\+-]+(\.[a-z0-9_\+-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*\.([a-z]{2,4})$"
                                                ErrorMessage="Invalid Email-Id"></asp:RegularExpressionValidator>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            <label>Message</label>
                                        </td>
                                        <td>
                                            <textarea class="form-control" rows="8" id="Textarea1" runat="server"></textarea>
                                            <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="txtMessage"
                                                Display="Dynamic" SetFocusOnError="true" ErrorMessage="Enter Message." ValidationGroup="Comment">
                                            </asp:RequiredFieldValidator>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td></td>
                                        <td>
                                            <button class="btn-ps" type="submit" id="btnSave" validationgroup="Comment" onclick="test()">Send Message</button>
                                        </td>
                                    </tr>
                                </table>

我的Web方法是： -

My Web Method is:-

  [System.Web.Script.Services.ScriptMethod()]
  [System.Web.Services.WebMethod(enableSession: true)]
    public static string InsertMethod(string Name, string Email,string Message,sting ID)
    {
        int retval = 0;
        try
        {
            Entity_NewsComments objComment = new Entity_NewsComments();

            objComment.ID= ID;    
            objComment.Comment = Message;
            objComment.Email = Email;
            objComment.Name = Name;

            if ((!string.IsNullOrEmpty(objComment.Email)) && (!string.IsNullOrEmpty(objComment.Name)) && (!string.IsNullOrEmpty(objComment.Comment)))
            {
                objComment.QFlag = "I";
                objComment.Date = Convert.ToDateTime(DateTime.Now.ToString());
                objComment.Status = 0;
                //retval = new Process_NewsComments().insert(objComment);
                if (retval > 0)
                {                        

                }

            }

            return "true";
        }
        catch (Exception ex)
        {
            throw (ex);
        }
    }

但它不是working.I已经把对网络的方法的调试器，但它不会there.It没有显示任何错误also.Please帮助我

But it is not working.I have put a debugger on web-method, But it is not going there.It is not showing any error also.Please help me

推荐答案

的document.ready不使用这种方式..反正你可以直接调用该函数。有多种事情，我在你的问题观察

document.ready is not used by this way.. and anyway you can directly call that function. There are multiple things, I observed in your question

1. 的document.ready没有在您的测试要求（）方法


2. 您的控件ID和你所检索的参数不同步。

上面的东西正确，然后再试一次。

Correct above things and try once.

您的JavaScript方法应该象下面这样

Your javascript method should like below

<script type="text/javascript">
    function test() {
            var Email = $('Your Email field client ID').val();
            var Message = $('Your message field client ID %>').val();
            var Name = $('Your Name field client ID').val();
            var ID=32;
            $.ajax({
                type: "POST",
                url: "Detail.aspx/InsertMethod", //URL should be fully qualified
                data: "{'Name':'" + Name + "'Email:'" + Email + "'Message:'" + Message + "'ID:'"+ID+"'}",
                dataType: "json",
                contentType: "application/json; charset=utf-8",
                success: function (data) {
                    var returnedstring = data.d;

                },
               error: function(a)
               { alert(a.responseText);}
            });
    }
</script>

这篇关于如何使用jQuery和JSON在asp.net中保存数据到数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！