ansaurus

Question

Efficient way to serialize form data to .NET ASHX/C# from JQuery

Answer 1

A:

You start by writing your generic handler:

public class TestHandler : IHttpHandler
{
    public void ProcessRequest(HttpContext context)
    {
        using (var connection = new SqlConnection(ConnectionString))
        using (var command = connection.CreateCommand())
        {
            connection.Open();
            command.CommandText = "NameOfYourSP";
            command.CommandType = CommandType.StoredProcedure;
            foreach (string name in context.Request.Form.Keys)
            {
                command.Parameters.AddWithValue("@" + name, context.Request.Form[name]);
            }
            command.ExecuteNonQuery();
        }
        context.Response.ContentType = "text/plain";
        context.Response.Write("success");
    }

    public bool IsReusable
    {
        get { return false; }
    }
}

Which you may call like this:

<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Test</title>
    <script type="text/javascript" src="jquery-1.4.1.js"></script>
    <script type="text/javascript">
    $(function() {
        $('a').click(function() {
            $.ajax({
                url: '/testhandler.ashx',
                data: $('form').serialize(),
                type: 'POST',
                success: function(data) {
                    alert(data);
                }
            });
        });
    });
    </script>
</head>
<body>

<form action="/test.ashx" method="post">
    <input type="text" name="param1" value="value1" /><br/>
    <input type="text" name="param2" value="value2" /><br/>
    <input type="text" name="param3" value="value3" /><br/>
</form>

<a href="#">Submit data</a>

</body>
</html>

Darin Dimitrov 2010-02-25 11:10:12

Hey thanks Darin, very complete example.. many many thanks. I guess I still need to validate and all of that which is of course fundemental, but at least there is a relatively straight forward way of getting the serialized data from the front-end, into the server/database.

David S 2010-02-26 21:39:46

ansaurus

tags:

views:

answers:

Efficient way to serialize form data to .NET ASHX/C# from JQuery

related questions