how to write Jquery Ajax and Josn in Asp.Net Web Form?

Question

1.00/5 (1 vote)

See more:

XML

<script type="text/javascript">
    $(document).ready(function () {
        $.ajax({
            type: "POST",
            contentType: "application/json; charset=utf-8",
            url: "Bind/BindDatatable",
            data: "{}",
            dataType: "json",
            success: function (data) {
                for (var i = 0; i < data.d.length; i++) {
                    $("#gvDetails").append("<tr><td>" + data.d[i].UserId + "</td><td>" + data.d[i].UserName + "</td><td>" + data.d[i].Location + "</td></tr>");
                }
            },
            error: function (result) {
                alert("Error");
            }
        });
    });
</script>

After Page Loading Error will came ...plz help me...

url: "Bind/BindDatatable",

------>how to write this line code
iam using web forms....

Posted 2-Jun-15 5:24am

iamvinod34

Add a Solution

Comments

F-ES Sitecore 2-Jun-15 11:52am

What error? What line? What is "Bind/BindDataTable"? Google "call asp.net webmethod from jquery" and you'll find example webmethod and jquery code to do this, and go from there.

iamvinod34 2-Jun-15 12:05pm

bind is asp webform page name and Binddatatable webmethod name
--->url:bind.aspx/Binddatatable is current process but this not excuted
iam writing url:bind/Binddatatable ---->
error: function (result) {
alert("Error");
} excuted
sir
:)

Mathi Mani 2-Jun-15 13:07pm

Your url seems incorrect. You have to give the correct url. For example, if you have a aspx page called Bind that has BindDatatable method (this method had to be marked as web method in Bind.aspx.cs), then the url should be like:
url:"Bind.aspx/BindDatatable".

iamvinod34 2-Jun-15 13:09pm

ok, but iam using webform pages
sir

Mathi Mani 2-Jun-15 13:49pm

As far as I know, Asp.Net Web forms are the ones with .aspx extension as I mention in my comment. If you are talking about something else, do share that info.

iamvinod34 2-Jun-15 14:23pm

iam using Bind data to gridview with JQuery or JSON in asp.net

Form :<form id="form1" runat="server" action="Bind.aspx" method="post">
<asp:GridView ID="gvDetails" runat="server">
<HeaderStyle BackColor="#DC5807" Font-Bold="true" ForeColor="White" />

Jquery Ajax Code :<script type="text/javascript">
$(document).ready(function () {
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "Bind/BindDatatable",
data: "{}",
dataType: "json",
success: function (data) {
for (var i = 0; i < data.d.length; i++) {
$("#gvDetails").append("<tr><td>" + data.d[i].UserId + "</td><td>" + data.d[i].UserName + "</td><td>" + data.d[i].Location + "</td></tr>");
}
},
error: function (result) {
alert("Error");
}
});
});
</script>
Page_Load Event :
private void BindColumnToGridview()
{
DataTable dt = new DataTable();
dt.Columns.Add("UserId");
dt.Columns.Add("UserName");
dt.Columns.Add("Location");
dt.Rows.Add();
gvDetails.DataSource = dt;
gvDetails.DataBind();
gvDetails.Rows[0].Visible = false;
}
Web Method Code : [WebMethod]
public static UserDetails[] BindDatatable()
{
DataTable dt = new DataTable();
List<userdetails> details = new List<userdetails>();

using (SqlConnection con = new SqlConnection("Data Source=184.168.47.17;Initial Catalog=Question_Papers;User ID=Shravan;Password=Shravan@34; Trusted_Connection=False"))
{
using (SqlCommand cmd = new SqlCommand("select TOP 10 UserId,UserName,Location from Test_1", con))
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dtrow in dt.Rows)
{
UserDetails user = new UserDetails();
user.UserId = dtrow["UserId"].ToString();
user.UserName = dtrow["UserName"].ToString();
user.Location = dtrow["Location"].ToString();
details.Add(user);
}
}
}
return details.ToArray();
}
Class :
public class UserDetails
{
public string UserId { get; set; }
public string UserName { get; set; }
public string Location { get; set; }
}

code not executed....jquery ajax error did executed...this::::error: function (result) {
alert("Error");
}
so plz help me sir

Mathi Mani 2-Jun-15 17:34pm

What is the error message? What is the name of the class that contains this code?

virang_21 2-Jun-15 18:55pm

Change your URL in AJAX call to url: "Bind.aspx/BindDatatable"

iamvinod34 2-Jun-15 22:55pm

url:Bind.aspx/BindDataTable not fsire sir,,,no action
url:Bind/BindDataTable
error: function (result) {
alert("Error");
} this did executed sir

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)

Rahul Gangahar · Answer 1 · 2015-06-02T19:01:00

1.This is code when you need to save the value on button click using json

$("#btnApprove").click(function () {

$.ajax({
url: "@Url.Action("IsApprove", "ControllerName")",
data: JSON.stringify({ 'requestId': requestId, 'referenceNumber': referenceNumber, 'userId': userId, 'value': value, note: $("#Custom.text").val() }),
cache: false,
type: 'POST',
contentType: "application/json; charset=utf-8",
dataType: 'json',
success: function (data) {
window.location.reload(data);
}
});
});