Hi I have below Ajax but it is giving Error 404 not found34ddlTrainingType34changefunction e ajax url 34TrainingReportBindTrainingModule34 thisval type 34POST34 contentType 34applicationjsoncharsetUTF834 dataType 34json34 success function result status xhr 34lstTrainingModule34htmlresultd error function xhr status error

Hi ramco1917Check the exampleDatabaseFor this example I have used of Northwind database that you can download using the link given belowDownload Northwind DatabaseHTMLltaspDropDownList ID34ddlCountries34 runat34server34gt ltaspListItem Text34Please select34gtltaspListItemgt ltaspListItem Text34France34gtltaspListItemgt ltaspListItem Text34Germany34gtltaspListItemgt ltaspListItem Text34Canada34gtltaspListItemgtltaspDropDownListgtlthr gtltaspListBox ID34lstCustomers34 runat34server34gtltaspListBoxgtltscript type34textjavascript34 src34httpsajaxgoogleapiscomajaxlibsjquery183jqueryminjs34gtltscriptgtltscript type34textjavascript34gt 39ddlCountries39changefunction ajax type 34POST34 url 34DefaultaspxGetCustomers34 data

[Solved] ASP.Net jQuery Ajax Error 404 not found

ramco191...

SOLVED CLOSED ACTIVE ANSWERED
User: ramco1917
Posted: on Oct 06, 2022 01:41 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 2485
Sample Code: Download

I have below Ajax but it is giving Error 404 not found.

$("#ddlTrainingType").change(function (e) {
    $.ajax({
         url: "~/TrainingReport/BindTrainingModule/" + $(this).val(),
         type: "POST",
         contentType: "application/json;charset=UTF-8",
         dataType: "json",
         success: function (result, status, xhr) {
             $("#lstTrainingModule").html(result.d);
         },
         error: function (xhr, status, error) {
            alert("Result: " + status + " " + error + " " + xhr.status + " " + xhr.statusText)
        }
    });
});

[WebMethod]
public static string BindTrainingModule(string TrainingTypeId)
{ 
    try
    {
        BALTrainingModule bALTrainingModule = new BALTrainingModule();
        List<TrainingModuleMaster> Result = bALTrainingModule.GetRecordDetailsByTypeId(Convert.ToInt32(TrainingTypeId));
        if (Result != null)
        {
            DataTable dt = new DataTable();
 
            dt.Columns.Add("Id", typeof(Int32));
            dt.Columns.Add("Name", typeof(string));
            foreach (var column in Result)
            {
                DataRow row = dt.NewRow();
                row["Id"] = column.TrainingModuleID;
                row["Name"] = column.CourseModule + " / " + column.CourseName;
                dt.Rows.Add(row);
            }
 
            StringBuilder stringBuilder = new StringBuilder();
            //stringBuilder.Append("<option value=\"0\">Select</option>");
            foreach (DataRow dr in dt.Rows)
                stringBuilder.Append("<option value=\"" + dr["Id"] + "\">" + dr["Name"] + "</option>");
            return stringBuilder.ToString();
        }
        return "0";
    }
    catch (Exception ex)
    {
        return "0";
        //Utility.SaveErrorLog(ex.Message, System.IO.Path.GetFileName(Request.Path), System.Reflection.MethodBase.GetCurrentMethod().Name, hdfEmpNumber.Value);
        //ShowMessage("Oops...", ex.Message, "error");
    }
}

Thanks

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 14

Reply
ANSWER
User: dharmendr
Replied: on Oct 07, 2022 09:04 AM
Report

Hi ramco1917,

Check the example.

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

HTML

<asp:DropDownList ID="ddlCountries" runat="server">
    <asp:ListItem Text="Please select"></asp:ListItem>
    <asp:ListItem Text="France"></asp:ListItem>
    <asp:ListItem Text="Germany"></asp:ListItem>
    <asp:ListItem Text="Canada"></asp:ListItem>
</asp:DropDownList>
<hr />
<asp:ListBox ID="lstCustomers" runat="server"></asp:ListBox>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript">
    $('#ddlCountries').change(function () {
        $.ajax({
            type: "POST",
            url: "Default.aspx/GetCustomers",
            data: '{country:"' + $(this).val() + '"}',
            contentType: "application/json; charset=utf-8",
            dataType: "json",
            success: function (r) {
                var lstCustomers = $("[id*=lstCustomers]");
                lstCustomers.empty();
                $.each(r.d, function () {
                    lstCustomers.append($("<option></option>").val(this['Value']).html(this['Text']));
                });
            }
        });
    });
</script>

Namespaces

using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.Services;

Code

[WebMethod]
public static List<ListItem> GetCustomers(string country)
{
    List<ListItem> items = new List<ListItem>();
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT * FROM Customers WHERE Country = @Country"))
        {
            cmd.CommandType = CommandType.Text;
            cmd.Parameters.AddWithValue("@Country", country);
            cmd.Connection = con;
            con.Open();
            SqlDataReader sdr = cmd.ExecuteReader();
            while (sdr.Read())
            {
                items.Add(new ListItem { Text = sdr["ContactName"].ToString(), Value = sdr["CustomerID"].ToString() });
            }
            con.Close();
        }
    }

    return items;
}

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

[Solved] ASP.Net jQuery Ajax Error 404 not found

Company

Explore

Follow us

Contact Us