Error 500 In Cascading Dropdown While Filling 3092 Records From Database Via Webservice
Jan 22, 2011
I am getting the error Method 500 while filling 3092 cities in to cascading dropdown control. i am using the following code.
<asp:ScriptManager ID="ScriptManager1" runat="server">
<Services>
<asp:ServiceReference Path="HotelDestination.asmx" />
</Services>
</asp:ScriptManager>
[code]...
View 2 Replies
Similar Messages:
Oct 22, 2010
i am using Cascading dropdown, with following scenario.a page "myPage.aspx" is loaded with a Querystring. [http://localhost/myVD/myPage.aspx?jobID=003]this page contains 2 cascading dropdowns say state & City . the idea is to fill the provinces Combo based on INCOMING querystring value "jobid".also i have a webservice named "Mywebservice.asmx" which has webmethods to retrieve city based on jobID.but since these webmethods are Contained in asmx . the querystring of the caller page is not visible to the webmetod of the service.
public CascadingDropDownNameValue[] GetContainerByJobID(string knownCategoryValues, string category
)
{
[code]...
View 1 Replies
May 25, 2010
I ultimately need to show countries in one drop down then states/provinces drop down of the previously selected drop down. I'm sure everyone has seen this many times. My page shows the countries but does not show values in the province/states drop down. It's as if the webservice is never run. I've tried removing and adding the ajaxtoolkit reference. The tableadaters run simple working sql code. I'm really at a lose here.
default.aspx:
...
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %>
...
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server" />
<%--Dropdown to display countries--%>
Country:<asp:DropDownList ID="ddlCountries" runat="server" DataSourceID="ods_Countries"
DataTextField="country" DataValueField="abbreviation">
</asp:DropDownList>
<%--data source for the country drop down list--%>
<asp:ObjectDataSource ID="ods_Countries" runat="server" OldValuesParameterFormatString="original_{0}"
SelectMethod="GetAllCountries" TypeName="countryDataSetTableAdapters.CountriesTableAdapter">
</asp:ObjectDataSource>....................................
View 8 Replies
Apr 1, 2010
i am trying to fill a dropdown list from the data base, but could not figure , how to code for it..
View 3 Replies
Dec 6, 2010
I have a cascading dropdown which loads countries into a dropdownlist.
When I type: www.domain.com, it all works.
However, when I type: domain.com it stops working and the dropdown shows: "[method error -1]"
Here's my code:
<asp:TextBox ID="tbCity" Width="90" MaxLength="50" CssClass="inactive" autocomplete="off" runat="server" />
<cc1:AutoCompleteExtender ID="AutoSuggestCities" runat="server" TargetControlID="tbCity"
CompletionInterval="2" CompletionSetCount="50" MinimumPrefixLength="3" ContextKey="" ServicePath="http://www.domain.com/geolocation.asmx" ServiceMethod="GetCitiesForCountryOrProvince" />
ps. I use url rewriting and to make sure the servicepath is always correct I used the full path.
View 7 Replies
Jan 22, 2011
i hv been tryin since a long time..but not able to resolve my problem.M making a cascadin dropdown with ajax but gettin method error 500 in my dropdown on running it..here's my code1. dataservice.cs file
using System;
using System.Web;
using System.Collections;
[code]...
View 1 Replies
Jul 27, 2010
I have created a dropdown through code behind.Then created a Cascading dropdown that also through code behind.
All the properties of cascading dropdown have been initialized properly (as i think).
And web service method is defined in separate file.
DDL and Cascading DDL have been created in App_code/NewFolder through a class file. That webservice.vb file too is placed in this folder. and webservide.asmx file is placed in root directory of the project.
When i run the project dropdown is filled only with [Method error 500]. query to fetch data from database have been written in webservice.vb file without any known error.
View 3 Replies
Oct 18, 2010
I am new to ASP.NET and AJAX. I have recently viewed the video tutorials on the Cascading Dropdowns, and applied that to my website. I am populating the dropdowns from 3 tables, and am wondering how i would be able to open pdf file from the sql databaseand display it in the browser. Can anyone provide me any suggestions
View 1 Replies
Mar 19, 2010
I have 3 cascading dropdown lists in an update panel. To submit the values of cascading dropdown without error it needs to turn eventvalidation off. Is there any way that i can avoid turning off the event validation and still use cascading dropdown?
View 1 Replies
Apr 16, 2010
I am getting [MethodError 500] when I use cascading drop down. below is my code
<tr>
<td >
Select a Hoster:
</td>
<td>
<asp:DropDownList ID="ddlFeaturedHoster" runat="server" ></asp:DropDownList>
</td>
</tr>
<ajaxToolkit:CascadingDropDown ID="cddHoster" runat="server" TargetControlID="ddlFeaturedHoster"
PromptText="Select a Hoster" LoadingText="Loading ..." Category="ActiveHoster"
ServiceMethod="GetDropDownContents" ServicePath="~/Hosting/HostingService.asmx"/>
Service Code:
[WebMethod]
[ScriptMethod]
public CascadingDropDownNameValue[] GetActiveHosters()
{
List<CascadingDropDownNameValue> returnList = new List<CascadingDropDownNameValue>();
HostersManager hosterManager = new HostersManager();
List<Hosters_HostingProviderDetail> hosters = hosterManager.GetAllHosters();
returnList.Add(new CascadingDropDownNameValue("--Please Select One--","0",true));
foreach (Hosters_HostingProviderDetail item in hosters)
{
returnList.Add(new CascadingDropDownNameValue() { name=item.HostingProviderName, value= item.HosterID.ToString()});
}
return returnList.ToArray() ;
}
[WebMethod]
[ScriptMethod]
public CascadingDropDownNameValue[] GetDropDownContents(string knownCategoryValues, string category)
{
knownCategoryValues = FormatCategoryWord(knownCategoryValues);
List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>();
HostersManager hosterManager = new HostersManager();
switch (category)
{
case "ActiveHoster":
values.AddRange(GetActiveHosters());
break;
case "ActiveOffer":
values.AddRange(GetActiveOffers(1));
break;
}
return values.ToArray<CascadingDropDownNameValue>();
}
/// <summary>
/// Formats the category word
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
private string FormatCategoryWord(string value)
{
if (string.IsNullOrEmpty(value)) return value;
if (value.LastIndexOf(":") > 0) value = value.Substring(value.LastIndexOf(":") + 1);
if (value.LastIndexOf(";") > 0) value = value.Substring(0, value.LastIndexOf(";"));
return value;
}
}
View 2 Replies
Aug 11, 2010
I'm trying to follow this article on cascading dropdown list in a GridView control in edit mode (except I'm using C#) [URL] I keep getting this error message "ProjectID is neither a DataColumn nor a DataRelation for table DefaultView."
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if ((e.Row.RowState & DataControlRowState.Edit) == DataControlRowState.Edit)
{
DataRowView dv = (DataRowView)e.Row.DataItem;
//// Preselect correct value in Projects list
DropDownList listProjects = (DropDownList)e.Row.FindControl("DropDownList1");
listProjects.SelectedValue = dv["ProjectID"].ToString(); // *****************this is where I get the error *********
// Databind list of categories in dependent drop-down list
DropDownList listCategories = (DropDownList)e.Row.FindControl("DropDownList2");
SqlDataSource dsc = (SqlDataSource)e.Row.FindControl("sdsDDL2");
dsc.SelectParameters["ProjectName"].DefaultValue = dv["ProjectName"].ToString();
listCategories.DataBind();
listCategories.SelectedValue =(dv["CategoryID"].ToString());
}
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>" SelectCommand="SELECT
TE.TimeEntryID,
P.ProjectName,
CAT.CategoryName,
TE.TimeEntryDescription,
TE.TimeEntryDuration,
TE.TimeEntryDate
FROM dbo.aspnet_starterkits_TimeEntry TE inner join
dbo.aspnet_starterkits_ProjectCategories CAT on
TE.CategoryID=CAT.CategoryID inner join
dbo.aspnet_starterkits_Projects P on
CAT.ProjectID=P.ProjectID
Where TimeEntryUserID=(SELECT UserId FROM dbo.aspnet_Users WHERE
UserName=@UserName) AND
TE.TimeEntryDate=@WeekEnding
" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE dbo.aspnet_starterkits_TimeEntry
SET
TimeEntryDescription=@TimeEntryDescription,
TimeEntryDuration=@TimeEntryDuration,
TimeEntryDate=@TimeEntryDate
WHERE
TimeEntryID=@original_TimeEntryID">
<SelectParameters>
<asp:ControlParameter ControlID="UserList" Name="UserName"
PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="WeekEnding2" Name="WeekEnding"
PropertyName="Text" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="TimeEntryDescription" />
<asp:Parameter Name="TimeEntryDuration" />
<asp:Parameter Name="TimeEntryDate" />
<asp:Parameter Name="original_TimeEntryID" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" BorderWidth="0px"
BorderStyle="None" Width="100%" CellPadding="2" PageSize="25"
DataKeyNames="TimeEntryID" onrowdatabound="GridView1_RowDataBound"
onrowupdating="GridView1_RowUpdating" >
<Columns>
<%--<asp:CommandField ShowEditButton="True" />--%>
<asp:BoundField DataField="TimeEntryID" HeaderText="ID"
SortExpression="TimeEntryID" InsertVisible="False" ReadOnly="True"
ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:TemplateField HeaderText="Project" SortExpression="ProjectName">
<EditItemTemplate>
<asp:DropDownList
ID="DropDownList1"
runat="server"
DataSourceID="sdsDdlProjectsEdit"
DataTextField="ProjectName"
DataValueField="ProjectID"
AutoPostBack="True"
onselectedindexchanged="DropDownList1_SelectedIndexChanged">
</asp:DropDownList>
<asp:SqlDataSource
ID="sdsDdlProjectsEdit"
runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>"
SelectCommand="SELECT ProjectID,ProjectName FROM dbo.aspnet_starterkits_Projects">
</asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("ProjectName") %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Category" SortExpression="CategoryName">
<EditItemTemplate>
<asp:DropDownList
ID="DropDownList2"
runat="server"
DataSourceID="sdsDDL2"
DataTextField="CategoryName"
DataValueField="CategoryID">
</asp:DropDownList>
<asp:SqlDataSource
ID="sdsDDL2"
runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>"
SelectCommand="SELECT CategoryID,CategoryName FROM dbo.aspnet_starterkits_ProjectCategories WHERE ProjectID=@ProjectID">
<SelectParameters>
<asp:Parameter Name="ProjectID" />
</SelectParameters>
</asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryName") %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:BoundField DataField="TimeEntryDescription" HeaderText="Description"
SortExpression="TimeEntryDescription" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField DataField="TimeEntryDuration" HeaderText="Hours"
SortExpression="TimeEntryDuration" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField ApplyFormatInEditMode="True" DataField="TimeEntryDate"
DataFormatString="{0:d}" HeaderText="Week Ending"
SortExpression="TimeEntryDate" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:CommandField ShowEditButton="True" HeaderText="Edit" ButtonType="Image" EditImageUrl="images/icon-edit.gif"
UpdateImageUrl="images/icon-save.gif" CancelImageUrl="images/icon-cancel.gif" />
</Columns>
</asp:GridView>
View 3 Replies
Jan 27, 2012
I wanted to use using database to populated the dropdownbut i am getting error as type or list space cannot be foundat ListCountry GetCountriesas its defined staticthe web methood code is in the same aspx.cs pagehow culd i use it if a different webmethod page .asmx is created
ref : [URL]
View 1 Replies
Mar 15, 2011
I am using oracle as back end. In database there is a table with 5000 records and 160 columns. i want to display all these records in gridview(in asp.net, c#). But it takes more than 10 minutes to fill the dataset.
View 4 Replies
Mar 9, 2011
provide me the cascading dropdown code upto 3 levels without using the WebService .
View 1 Replies
Apr 13, 2010
This has totally spoiled my .net 4 vs2010 realease day happiness. Running Cascading dropdowns using 'webservice' asmx method. Everything worked on .3.5 and i solved the running 'code In page' method with this post. Method error 500 [URL] Thought I was sorted but seems the rules are totaly different for the 'webservice method'. For example where did ToolkitScriptManager come from Ive been using ScriptManager for years. Anyway below is the Webservice and Page code. Ive looked at and tried everything of the forum but all of it is pre .4. This is demo code, the real version has 3 dependant dropdowns and the lookups are used several times so it HAS to be a webservice. My current theroies are:
1. Permissions- dosent makes sense.
2. Something missing in web.config to enable webservices.
3. Something to do with placement of 'System.Web.Script.Services.ScriptService()>'
<%@ Page Language="VB" ValidateRequest="false" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="Default2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "[URL]">
<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %>
<html xmlns="[URL]">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</asp:ToolkitScriptManager>
<asp:DropDownList ID="DDListManufacturer" runat="server" CssClass="ddsearch" Width="140px">
</asp:DropDownList>
<asp:CascadingDropDown ID="DDListManufacturer_CascadingDropDown" runat="server" Category="Manufacturer"
PromptText="Select a manufacturer"
ServiceMethod="WebService.GetDropDownContents"
TargetControlID="DDListManufacturer"
ServicePath="WebService.asmx">
</asp:CascadingDropDown>
</form>
</body>
</html ............................................
View 3 Replies
Feb 26, 2010
I want to add items to a dropdownlist with values return by a webservice which will be called from javascript without cascading extender...
View 3 Replies
Feb 9, 2011
I have a dropdown for tradertype which on selection should populate the dropdown for traders.My view looks like :
[Code]....
I tried using JQuery, but I couldn't get the change event of the 'TraderType' dropdown. My script is: [Code]....
The code in the controller is: [Code]....
I am not receiving any alert when I change the 'TraderType' dropdown.
View 3 Replies
May 6, 2010
I tried cascading dropdown in asp.net using ajax. I have tried with 3 dropdown control. The scenario is First dropdown is loaded when page gets loaded and the second dropdown is loaded based on first is selected and thrid dropdown is loaded based on second one selected, now I want to know how do I load third dropdown based on first and second selected value...
View 1 Replies
Jul 6, 2010
i havce this web service
[Code]....
and this aspx page
[Code]....
perhaps i followed this example here
http://programming.top54u.com/post/AJAX-Cascading-Dropdown-Example-using-SQL-Database.aspx
it return an error that
System.InvalidCastException: unable to cast di object of 'AjaxControlToolkit.CascadingDropDown' on tye 'System.Web.UI.WebControls.DropDownList'.
View 1 Replies
Nov 19, 2010
Suppose parent dropdown is car (Values are car1, car2, car3)and its child is color(for car1 R Y G B, For car2 R Yand for car3 G B).Now on selection of car2 R and Y will appear and select R, then again made the change on car and select car3 then again select is comiing with G and B and select B.
Now if I select again in car, car1 then the child is populating with the values of car1 but it takes the B as a default value as it was previously selected and also present for car1 too.This case is only happen. on select of child value which is availble for both parent selection.
View 1 Replies
Jan 18, 2011
I have a form that needs to display 3 dropdown lists, one for my client type, then, based on the selection, my second list shows the clients for that type, and then based on the client name, my third dropdown box shows the contacts for that client. The first dropdown list one being a normal html.dropdownlist, and the other 2 being CascadingDropdownLists.
I have followed Stephen Walther's method 1 located at [URL]. If I select my client type, then my client names in my second dropdown shows perfectly, but when I choose my client name, the third dropdown does not work. When I view my page source, all my contacts are listed in my <select> control, but my dropdown box stays blank. Did anyone ever get a third dropdown to work?
View 1 Replies
Oct 28, 2010
i am going to use cascading dropdown in my project But i cant understand why it is not working let me know what i am doing wrong...
this is my aspx page,
[code]....
View 5 Replies
Mar 22, 2010
I have a cascading dropdown which is dynamically created and does a postback based on a certain condition. How do i set the selected value after the postback
View 1 Replies
Mar 15, 2010
[Code]....
Dont go away by looking a difficult probem.
View 8 Replies
Sep 15, 2010
A form contains 2 cascading dropdowns. When an item is selected in the first dropdown, jQuery retrieves a list (json) from the server and fills the 2nd dropdown.
The user posts the page to the server, and when the page is returned the dropdown is empty because its not stored in viewstate.
What do you do in this situation? Is this the point where cascading dropdowns using jQuery and trying to make your page a little more stateless gets tedious?
View 1 Replies