Method Error 500 on cascading dropdownlist

Question

1.80/5 (2 votes)

See more:

This is my web service which i used to retrieve data from database (I used data set for it).It runs on IIS properly but when I upload it on web server it gives method error 500.

MSIL

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]
public class ReceiptService : System.Web.Services.WebService
{
    public ReceiptService () {

        //Uncomment the following line if using designed components
        //InitializeComponent();
    }
    [WebMethod]
    public CascadingDropDownNameValue[] GetSchoolName(string knownCategoryValues, string category)
    {
        dsScoolTableAdapters.school_detailTableAdapter school_detailAdapter = new dsScoolTableAdapters.school_detailTableAdapter();
        dsScool.school_detailDataTable schools = school_detailAdapter.GetSchoolName();
        List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>();
        foreach (DataRow dr in schools)
        {
            string school_name = (string)dr["school_name"];
            string district = (string)dr["district"];
            values.Add(new CascadingDropDownNameValue(school_name, school_name.ToString()));
        }
        return values.ToArray();
    }


}

Posted 24-May-11 4:37am

vineesha

Updated 2-Aug-16 23:58pm

Add a Solution

8 solutions

Solution 1

The 500 Internal Server Error is a "server-side" error, meaning the problem is not with your PC or Internet connection but instead is a problem with the web site's server.

Read about Error 500 here: HTTP Error 500 Internal server error[^]

Also this microsoft article: How Web site administrators can troubleshoot an "HTTP 500 - Internal Server Error"[^]

Posted 24-May-11 5:51am

Sandeep Mewara

Comments

vineesha 25-May-11 8:36am

No I am not asking about HTTP Error 500 Internal server error, on my page method error 500 occurs if you had any solution for it then tell me. my page link is - http://vidyabhartimahakoshal.org/sspstore/Ghosh.aspx

Solution 3

In case anyone is as dumb as I apparently am for me the issue was that I left out

[System.Web.Script.Services.ScriptService]

in my web service declaration! D'oh! Hopefully this will save someone the time I spent trying to track down the issue.

Posted 1-Nov-12 0:15am

Davie Crocket

Solution 5

In case this problem occurres with the large amount of data try change value in the parameter

maxJsonLength

in the web.config:

XML

<system.web.extensions>
        <scripting>
            <webServices>
                <jsonSerialization maxJsonLength="5000000" />
            </webServices>
        </scripting>
    </system.web.extensions>

this solution was found in http://forums.asp.net/t/1038620.aspx/2/10[^]

Posted 22-Nov-12 20:29pm

denko-z

Solution 6

I also got this kind of error and after done research on Internet, I found solution.

If the below line of code is commented, first remove the comment and then try to execute, it will work. If you will not find, then type it.

[System.Web.Script.Services.ScriptService()]

It should be like this in WebService

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService()]
public class CascadingDropDown : System.Web.Services.WebService {

It should fix the error

Posted 10-Jun-13 7:48am

varanasiprakash

Solution 4

In case anyone is as dumb as I apparently am for me the issue was that I left out

[System.Web.Script.Services.ScriptService]

in my web service declaration! D'oh! Hopefully this will save someone the time I spent trying to track down the issue.

Posted 1-Nov-12 0:15am

Davie Crocket

Comments

Devesh2179 20-Oct-13 5:29am

Thanks it works

Solution 7

Install this add-on on server

http://www.microsoft.com/en-us/download/details.aspx?id=883[^]

Posted 23-Jul-14 8:45am

Fernando Arreguin

Comments

VICK 25-Jul-14 1:07am

What could be the logic to answer an already solved and 3 year old question???

Solution 8

XML

<system.web.extensions>
        <scripting>
            <webServices>
                <jsonSerialization maxJsonLength="5000000" />
            </webServices>
        </scripting>
    </system.web.extensions>

Posted 2-Aug-16 23:58pm

vikas panwar

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)

vineesha · Accepted Answer · 2011-05-27T03:18:00

I get the solution of that error.In this i used dataset for data binding but on the web server it is not work perfectly then now i changed the code as
using System;
using System.Collections;
using System.Configuration;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml.Linq;
using AjaxControlToolkit;
using System.Data;
using System.Data.SqlClient;
/// <summary>
/// Summary description for ReceiptService
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]
public class ReceiptService : System.Web.Services.WebService
{
string connStr = ConfigurationManager.ConnectionStrings["TutTestConn"].ToString();
public ReceiptService () {
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
public CascadingDropDownNameValue[] GetSchoolName(string knownCategoryValues, string category)
{
//dsScoolTableAdapters.school_detailTableAdapter school_detailAdapter = new dsScoolTableAdapters.school_detailTableAdapter();
//dsScool.school_detailDataTable schools = school_detailAdapter.GetSchoolName();
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
SqlCommand dCmd = new SqlCommand("LoadAllSchool", conn);
dCmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = null;
rdr = dCmd.ExecuteReader();
List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>();
while(rdr.Read())
{
string school_name = (string)rdr["school_name"];
string district = (string)rdr["district"];
values.Add(new CascadingDropDownNameValue(school_name, school_name.ToString()));
}
return values.ToArray();
}

}

Method Error 500 on cascading dropdownlist

8 solutions

Solution 1

Solution 3

Solution 5

Solution 2

Solution 6

Solution 4

Solution 7

Solution 8

Add your solution here

Preview 0

Existing Members

...or Join us