Skip to main content

JSON/Jquery to get data from webservice and add webservice data to Dropdownlist in asp.net

WEB SERVICE :First make web method on cs page .

 [WebMethod]
    public static List<getdisttdata> getdisttt(string prefixText)
    {
        List<getdisttdata> li = new List<getdisttdata>();
        try
        {
            if (connection.State == ConnectionState.Closed)
                connection.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "Your Query";
            cmd.Connection = connection;
            cmd.CommandType = CommandType.Text;
            SqlDataAdapter adp = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            adp.Fill(ds);
            connection.Close();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                getdisttdata bkl = new getdisttdata();
                bkl.distt = dr["District"].ToString();
                bkl.disttcode = dr["CityCode"].ToString();
                li.Add(bkl);
            }

        }
        catch (Exception ex)
        {
            //  return null;
        }
        return li;
    }

  public class getdisttdata
    {
        private string _distt;
        private string _disttcode;
        public string distt
        {
            get
            {
                return _distt;
            }
            set
            {
                _distt = value;
            }
        }
        public string disttcode
        {
            get
            {
                return _disttcode;
            }
            set
            {
                _disttcode = value;
            }
        }

    }



Then add below Code in Aspx page.

 function getdistt() {

            var statecod = $("#<%=Your control on whom to call this function %>").val();
            $.ajax({
                type: "POST",
                url: "aspx page name/webmethod created above (getdistt)",
                contentType: "application/json; charset=utf-8",
                data: JSON.stringify({ prefixText: statecod }),
                dataType: "json",
                success: function (response) {
                    $("#ctl00_ContentPlaceHolder1_ddlPDistt").find('option').remove().end();
                   // to remove already added items in dropdown
                    var teams = response;
// loop to add items in dropdownlist
                    for (var i = 0; i < teams.length; i++) {
                        statename = teams[i].distt;
                        stateid = teams[i].disttcode;
                        $('<option value="' + stateid + '">' + statename + '</option>').appendTo("#ctl00_ContentPlaceHolder1_ddlPDistt");
                    }
                    $("#<%=hdnstate.ClientID %>").val($("#<%=ddlPState.ClientID %>").val());
                    $("#<%=hdncountry.ClientID %>").val($("#<%=ddlPCountry.ClientID %>").val());
                    if ($("#<%=hdndistt.ClientID %>").val() != "" && check == 'F') {
                        $("#<%=ddlPDistt.ClientID %>").val($("#<%=hdndistt.ClientID %>").val());
                     
                    }

                }
            })
        }

DropDownList on which this function is called

  <asp:DropDownList ID="ddlPDistt" runat="server"  DataSourceID="sqlPDistt"
                                                        TabIndex='1' Width='255px' DataTextField="District" DataValueField="CityCode" onblur="gettown()">
                                                    </asp:DropDownList>

Comments

Post a Comment

Popular posts from this blog

Export Doc,Access,Image,CSV,Excel,Pdf,XML,HTML,Text,Print of Gridview in Asp.net

First import itextsharp.dll in the solution and use three namespces (basically for pdf) using iTextSharp.text; using iTextSharp.text.pdf; using iTextSharp.text.html.simpleparser;          Then Use the following code :- on each button  click  protected void Page_Load(object sender, EventArgs e)         {             if (!Page.IsPostBack)             {                 BindGridDetails(GridView1);             }         }                 protected DataTable BindGridDetails(GridView GridView1)         {             DataTable dt = new DataTable();             dt.Columns.Add("Student_ID", typeof(Int32));             dt.Columns.Add("Student_Name", typeof(string));             dt.Columns.Add("Education", typeof(string));             dt.Columns.Add("City", typeof(string));             DataRow dtrow = dt.NewRow();             dtrow["Student_ID"] = 1;             dtrow["Student_Name"] = "Musakkhir";   
1 comment
Read more

Ip Sec Internet Security Basic Structure

The IPsec suite is an  open standard . IPsec uses the following  protocols  to perform various functions: Authentication Headers (AH)  provide connectionless  integrity  and data origin  authentication  for IP  datagrams  and provides protection against  replay attacks . Encapsulating Security Payloads (ESP)  provide  confidentiality , data-origin  authentication , connectionless  integrity , an anti-replay service (a form of partial sequence integrity), and limited traffic-flow confidentiality. Security Associations (SA)  provide the bundle of algorithms and data that provide the parameters necessary to AH and/or ESP operations. The  Internet Security Association and Key Management Protocol  (ISAKMP) provides a framework for authentication and key exchange, with actual authenticated keying material provided either by manual configuration with pre-shared keys,  Internet Key Exchange  (IKE and IKEv2),  Kerberized Internet Negotiation of Keys  (KINK), or IPSECKEY  DNS records .
1 comment
Read more

Advent of code 2022 day 22 part 1

  function main(input, input1) {     let grid = input.split( '\n' );     grid.shift();     // only in big input     for ( let i = 0 ; i < 100 ; i++) {         grid[i] = '                                                  ' + grid[i];     }     //console.log(grid[100])     grid = grid.map(x => x.split( '' ))     // find first left top allowed     let temppos = - 1 ;     grid[ 0 ].forEach((element, i) => {         if (temppos == - 1 && element == '.' ) {             temppos = i;         }     });     let initpos = new pos(temppos, 0 )     // console.log(initpos)     // make grid equal shape     let maxlength = 0 ;     grid.forEach(el => {         if (el.length > maxlength) {             maxlength = el.length         }     })     console.log(maxlength)     grid.forEach(el => {         if (el.length < maxlength) {             let diff = maxlength - el.length;             while (diff > 0 ) {                 di
Post a Comment
Read more