Method Error 500

• pulak_mca

  Mr or Mrs. 500

  Points: 505

  More actions

  August 19, 2008 at 2:43 am

  #154634

  aspx form:

  Category: <asp:DropDownList ID="ddlCategory"

  runat="server" />

  <ajaxToolkit:CascadingDropDown

  ID="CascadingDropDown1"

  runat="server"

  TargetControlID="ddlCategory"

  Category="category"

  PromptText="Select a Category"

  LoadingText="[Loading Category...]"

  ServicePath="AutoComplete.asmx"

  ServiceMethod="GetCategory" />

  Webservice file:

  [WebService(Namespace = "http://tempuri.org/")]

  [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

  [System.Web.Script.Services.ScriptService]

  public class AutoComplete : System.Web.Services.WebService

  {

  [WebMethod]

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

  public CascadingDropDownNameValue[] GetCategory(string knownCategoryValues, string category)

  {

  SqlConnection conn = new SqlConnection("server=localhost;database=blankphed;user id=sa;password=nicnet10");

  conn.Open();

  SqlCommand comm = new SqlCommand("SELECT categoryname,categoryid from ContractorCategory", conn);

  SqlDataReader dr = comm.ExecuteReader();

  List ();

  try

  {

  while (dr.Read())

  {

  string name = (string)dr["categoryname"];

  int id = (int)dr["categoryid"];

  value.Add(new CascadingDropDownNameValue(name, id.ToString()));

  }

  }

  catch { }

  finally

  {

  conn.Close();

  }

  return value.ToArray();

  }

  }

  When i run it ,it lead to a problem in the combobox method error 500 .What i have to do.

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  August 19, 2008 at 11:56 am

  #860197

  It does not seem to be a database server issue. Here is link. May it help.

  http://www.mrexcel.com/archive2/38800/44953.htm