/** // <Summary>
/// Province list box
/// </Summary>
Private void displayprovince ()
{
Sqldatareader SDR = dB. runprocgetreader ("select * From Province ");
Ddlprovince. datasource = SDR;
Ddlprovince. datatextfield = "proname ";
Ddlprovince. datavaluefield = "proid ";
Ddlprovince. databind ();
SDR. Close ();
}
/** // <Summary>
/// City list
/// </Summary>
Private void displaycity ()
{
Sqldataadapter SDA = dB. createda ("select * from city ");
Datatable dt = new datatable ();
SDA. Fill (DT );
// Put the city data into a label. This label can hide the property.
Lbltemp. Text = "";
Foreach (datarow row in DT. Rows)
{
Lbltemp. TEXT = lbltemp. text + row ["proid"] + "-" + row ["cityid"] + "-" + row ["cityname"] + ",";
}
SDA. Dispose ();
} <Script language = "JavaScript">
// Extract the hidden string and split it into an array.
VaR STR = Document. getelementbyid ("lbltemp"). innertext;
Arr = Str. Split (",");
A = arr. Length
AR = new array ()
For (I = 0; I <A; I ++ ){
Ar [I] = arr [I]. Split ("-");
}
Onecount = ar. length;
// Linkage is implemented here
Function LD (){
Document. form1.ddlcity. Length = 0
Lid = form1.ddlprovince. value;
For (I = 0; I <onecount; I ++ ){
If (AR [I] [0] = lid ){
Document. form1.ddlcity. Options. Add (New Option (AR [I] [2], ar [I] [1]);
}
}
}
Function showmsg ()
{
Alert (document. form1.ddlprovince. value );
Alert (document. form1.ddlcity. value );
}
</SCRIPT>