how to retrieve data using ajax in c# ASP.NET ?

im trying to retrieve data using ajax and bound it to a dropdownlist

i have created a web method in remin.aspx form as follows :

[WebMethod]
public static List GetCustomers()
{
string query = "select c_no, c_name from cust";
string constr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
using (OracleConnection con = new OracleConnection(constr))
{
using (OracleCommand cmd = new OracleCommand(query, con))
{
List customers = new List();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
OracleDataAdapter da = new OracleDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count>0) {
for (int i=0;i
customers.Add(new senders_list
{
c_no = dt.Rows[i]["c_no"].ToString(),
c_name = dt.Rows[i]["c_name"].ToString()
});
}
}
return customers; // i have created breakpoint here and it return the data fine
}
}
}

and this is the class :

and im calling the ajax request from test.aspx

this is the test.aspx ,ajax call

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="test.aspx.cs" Inherits="WEBDBIRAQI.test1" %>
"http://www.w3.org/1999/xhtml">
"server">
"text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js">
"text/javascript">
(document).ready(function () {
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "remin.aspx/GetCustomers",
data: "{}",
dataType: "json",
success: function (Result) {
Result = Result.d;
$.each(Result, function (key, value) {
$("#ss_list").append($("").val
(value.C_NO).html(value.C_NAME));
});
},
error: function (Result) {
alert("Error");
}
});
});
"form1" runat="server">
"ss_list" runat="server" >

when i run the form it shows only the dropdownlist but with no data inside !

im sure that the problem is with my ajax call Code ,because i have created a break point in the web method and it returned the data fine !

i need help please !

Hi,

Please use this link which has same implementation will solve your issue.

https://www.c-sharpcorner.com/blogs/bind-dropdown-using-jquery-ajax

https://www.aspsnippets.com/Articles/Populate-Bind-ASPNet-DropDownList-using-jQuery-AJAX-and-JSON-in-C-and-VBNet.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="test.aspx.cs" Inherits="WEBDBIRAQI.test1" %>
"http://www.w3.org/1999/xhtml">
"server">
"text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js">
"text/javascript">
(document).ready(function () {
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "remin.aspx/GetCustomers",
data: "{}",
dataType: "json",
success: function (Result) {
$.each(Result.d, function (key, value) {
$("#ss_list").append($("").val
(value.c_no).html(value.c_name));
});
},
error: function (Result) {
alert("Error");
}
});
});
"form1" runat="server">
"ss_list" runat="server" >

6 Replies

Know the answer? Post it — somebody with the same question will find it here.