Bind Dropdown using ajax

Jebin Dhanush

7y650.NET

hi ,

dropdown doesnot bind

my code

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="ajax.WebForm1" %>

Ajax

Code Behind

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

using System.Web.Services;

using System.Configuration;

namespace ajax

{

public partial class WebForm1 : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

[WebMethod]

public static List GetCustomers()

{

string query = "SELECT CustomerId, Name FROM Customers";

string constr = ConfigurationManager.ConnectionStrings["jk"].ConnectionString;

using (SqlConnection con = new SqlConnection(constr))

{

using (SqlCommand cmd = new SqlCommand(query))

{

List customers = new List();

cmd.CommandType = CommandType.Text;

cmd.Connection = con;

con.Open();

using (SqlDataReader sdr = cmd.ExecuteReader())

{

while (sdr.Read())

{

customers.Add(new ListItem

{

Value = sdr["CustomerId"].ToString(),

Text = sdr["Name"].ToString()

});

}

con.Close();

return customers;

}

code doesnot works

2 Replies

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

Kalyani Shevale7y ago
another one Solution follow below Link

https://www.c-sharpcorner.com/blogs/bind-dropdown-using-jquery-ajax
https://stackoverflow.com/questions/14747883/how-to-bind-the-dropdownlist-using-ajax
Kalyani Shevale7y ago
html
<asp:DropDownList ID="ddlCustomers" runat="server">
asp:DropDownList>
c# Code for bind data List
public static List GetCustomers()
{
    string query = "SELECT CustomerId, Name FROM Customers";
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand(query))
        {
            List customers = new List();
            cmd.CommandType = CommandType.Text;
            cmd.Connection = con;
            con.Open();
            using (SqlDataReader sdr = cmd.ExecuteReader())
            {
                while (sdr.Read())
                {
                    customers.Add(new ListItem
                    {
                        Value = sdr["CustomerId"].ToString(),
                        Text = sdr["Name"].ToString()
                    });
                }
            }
            con.Close();
            return customers;
        }
    }
}
AJAX code bind with Dropdown
"text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js">
"text/javascript">
$(function () {
    $.ajax({
        type: "POST",
        url: "Default.aspx/GetCustomers",
        data: '{}',
        contentType: "application/json; charset=utf-8",
        dataType: "json",
        success: function (r) {
            var ddlCustomers = $("[id*=ddlCustomers]");
            ddlCustomers.empty().append('Please select');
            $.each(r.d, function () {
                ddlCustomers.append($("").val(this['Value']).html(this['Text']));
            });
        }
    });
});