Cascading drop down lists is a really nice feature for web developers. I thought it was time to write an article on how to do this using ASP.NET and jQuery. Well here’s one way of doing it. Before we get started, this example uses the latest version of jQuery which is 1.3.2. That can be downloaded from here.
Open Visual Studio 2008 and create a new Web Application. For this article I’m not going to connect to a database. I’ve created two classes, Employee and EmployeeCars, which will store the data. Create two new classes and add the following code:
C#
public class Employee
{
public int Id { get; set; }
public string GivenName { get; set; }
public string Surname { get; se ......
¶ÔÓÚ´óÁ¿µÄÊý¾Ý£¬ÓÐʱºòµ¼³öµ½ExcelÖн«¸ü¼Ó·½±ã½øÐÐÊý¾Ýͳ¼Æ·ÖÎö£¬¶ø¶ÔÓÚÅŰæ´òÓ¡Ôòµ¼³öµ½WorldÎĵµÖиü¼Ó·½±ã¡£ÔÚASP.NET¿ÉÒÔͨ¹ýÉÙÁ¿´úÂëʵÏÖÕâÁ½ÖÖµ¼³ö¡£
н¨Ò»Ò³Ã棬¸ÃÒ³Ãæ²¼¾ÖHtmlÔ´ÂëÈçÏ£º
<form id="form1" runat="server"><div>
<asp:Button ID="cmdOpen" runat="server" Text="ÔÚÏß´ò¿ª" CommandName="open"
OnCommand="Button_Click" /> <asp:Button ID="cmdSave"
runat="server" Text="±¾µØ±£´æ" CommandName="save"
OnCommand="Button_Click" />
<asp:DropDownList ID="listType" runat="server">
<asp:ListItem Value="excel">Excel</asp:ListItem ......
·ÂpetshopµÄÒ»¸öÊý¾Ý·ÃÎʲãµÄÀà ³Ë·çÏÖÓÐÔ´´³ÌÐò³Ë·ç¹ã¸æÁªÃËϵͳ³Ë·ç¶àÓû§¼ÆÊýÆ÷ ³Ë·ç¶àÓû§PHPͳ¼ÆÏµÍ³ ³Ë·çµçÓ°³ÌÐò³Ë·çÍøÖ·³ÌÐò³Ë·ç¹ã¸æ¹ÜÀíϵͳ³Ë·çasp.net̽Õë·ÂpetshopµÄÒ»¸öÊý¾Ý·ÃÎʲãµÄÀà using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
namespace yueying.Components
{
/// <summary>
/// DBClass µÄժҪ˵Ã÷¡£
/// </summary>
public class DBClass
{
protected static string strConn = ConfigurationSettings.AppSettings["strConn"];
public DBClass()
{
//
// TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼
//
}
//¹¦ÄÜ:Ö´ÐÐsqlÓï¾ä,·µ»Øbool
internal bool ExecuteSql(string strSQL)
{
bool success=false;
OleDbConnection conn = new OleDbConnection(strConn);
OleDbCommand myCmd = new OleDbCommand(strSQL,c ......
ÔÚ·þÎñÆ÷¶Ë£¬´¦ÀíÒ»¸öASP.NET Web FormÐèÒª¼¸¸ö²½Ö裬ÔÚÿ¸ö²½Öè¶¼»áÒý·¢¸÷ÖÖʼþ£¬Õâ¾ÍÔÊÐíÄã°ÑÍøÒ³²åÈëµ½ÈÎÒ»²½ÖèµÄ´¦ÀíÁ÷Öв¢ÇÒÏìÓ¦ÈκÎÄãËùÆÚÍûµÄ´¦Àí¡£
ÒÔÏÂÊÇASP.NETÍøÒ³´¦ÀíÁ÷ÖеöÖ÷Òª²½Öè
1.ÍøÒ³¿ò¼Ü³õʼ»¯
2.Óû§´úÂë³õʼ»¯
3.ÑéÖ¤
4.ʼþ´¦Àí
5.×Ô¶¯Êý¾Ý°î¶¨
6.ÇåÀí ......
ǰÑÔ
FCKeditorÊÇʹÓ÷dz£¹ã·ºµÄHTML±à¼Æ÷£¬±¾ÎÄ´Ó ASP.NET µÄʹÓó¡¾°¶Ô FCKeditor Óë FCKeditor.NET µÄÅäÖᢹ¦ÄÜÀ©Õ¹£¨Èç×Ô¶¨ÒåÎļþÉÏ´«×ÓĿ¼¡¢×Ô¶¨ÒåÎļþÃû¡¢ÉÏ´«Í¼Æ¬µÄºóÆÚ´¦ÀíµÈ£©¡¢ÒÔ¼°°²È«ÐÔ½øÐгõ²½µÄ²ûÊö¡£
Ï£ÍûÄܰïÖúÓÐͬÑùÐèÇóµÄͬÈʽÚʡһµãʱ¼ä£»Ò²Ï£Íû¸÷λÄÜÖ¸ÕýÆäÖеIJ»×㡣лл¡£
Ò»¡¢×Ô¶¨Òå FCKeditor µÄ BasePath
BasePath ¼´FCKeditorÔÚÍøÕ¾ÖеÄÏà¶Ô·¾¶£¬Ä¬ÈÏÖµÊÇ /fckeditor/£¬×îºÃÔÚWeb.config appSettingsÖÐ¶ÔÆä½øÐÐÅäÖãº
<add key="FCKeditor:BasePath" value="/FCKeditor_2.6.3/"/>
ÕâÑù×öÓÐÖî¶àÓŵ㣺
¿ª·¢»·¾³ÓëÉú²ú»·¾³²»Í¬£¬¿ª·¢»·¾³Ò»°ãÊÇhttp://localhost/xxx.com/ÕâÖÖÇé¿öÏÂFCKeditor¾ÍµÃ·ÅÔÚÒ»¸öÐéÄâĿ¼http://localhost/fckeditor/ÖУ¬ÈôÉæ¼°¶à¸öÍøÕ¾µÄ¿ª·¢£¬¶ø¸÷ÍøÕ¾µÄFCKeditorÓвî±ðʱ£¬ÕâÑùÏÔÈ»²»ÊÇ×îÓÅ£»
¶øÇÒÒòΪÎïÀíĿ¼½á¹¹ÓëÂ߼Ŀ¼½á¹¹²»Í¬£¬Ò²»áÓз¢Éú´íÎóµÄÒþ»¼£»
¶øÈç¹û²ÉÓÃWeb.configµÄÅäÖ㬾ͿÉÒÔÔÚ¿ª·¢»·¾³²ÉÓò»Í¬µÄÅäÖã¬FCKeditorµÄÎïÀí·¾¶ÓëÉú²ú»·¾³±£³ÖÒ»Ö£»
µ±Éý¼¶FCKeditorʱ£¬Ö»ÐèÒª½«Ð°汾µÄFCKeditor·ÅÔÚÏàÓ¦°æ±¾ºÅµÄĿ¼ÀÐÞ¸ÄÒ»ÏÂÅäÖü´¿É¡£ÕâÑù¿ÉÒÔ½â¾öÒòΪ¾²Ì¬×ÊÔ´µÄ¿Í»§¶Ë»º´ ......
Abs(number) È¡µÃÊýÖµµÄ¾ø¶ÔÖµ¡£
Asc(String) È¡µÃ×Ö·û´®±í´ïʽµÄµÚÒ»¸ö×Ö·ûASCII Âë¡£
Atn(number) È¡µÃÒ»¸ö½Ç¶ÈµÄ·´ÕýÇÐÖµ¡£
CallByName (object, procname, usecalltype,[args()]) Ö´ÐÐÒ»¸ö¶ÔÏóµÄ·½·¨¡¢É趨»ò´«»Ø¶ÔÏóµÄÊôÐÔ¡£
CBool(expression) ת»»±í´ïʽΪBoolean ÐÍ̬¡£
CByte(expression) ת»»±í´ïʽΪByte ÐÍ̬¡£
CChar(expression) ת»»±í´ïʽΪ×Ö·ûÐÍ̬¡£
CDate(expression) ת»»±í´ïʽΪDate ÐÍ̬¡£
CDbl(expression) ת»»±í´ïʽΪDouble ÐÍ̬¡£
CDec(expression) ת»»±í´ïʽΪDecimal ÐÍ̬¡£
CInt(expression) ת»»±í´ïʽΪInteger ÐÍ̬¡£
CLng(expression) ת»»±í´ïʽΪLong ÐÍ̬¡£
CObj(expression) ת»»±í´ïʽΪObject ÐÍ̬¡£
CShort(expression) ת»»±í´ïʽΪShort ÐÍ̬¡£
CSng(expression) ת»»±í´ïʽΪSingle ÐÍ̬¡£
CStr(expression) ת»»±í´ïʽΪString ÐÍ̬¡£
Choose (index, choice-1[, choice-2, ... [, choice-n]]) ÒÔË÷ÒýÖµÀ´Ñ¡Ôñ²¢´«»ØËùÉ趨µÄ²ÎÊý¡£
Chr(charcode) ÒÔASCII ÂëÀ´È¡µÃ×Ö·ûÄÚÈÝ¡£
Close(filenumberlist) ½áÊøÊ¹ÓÃOpen ¿ªÆôµÄµµ°¸¡£
Cos(number) È¡µÃÒ»¸ö½Ç¶ÈµÄÓàÏÒÖµ¡£
Ctype(expression, ......