91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 225KB
    文件類型: .zip
    金幣: 2
    下載: 0 次
    發布日期: 2021-05-24
  • 語言: 其他
  • 標簽: DropDownList??

資源簡介

在做web系統時 制作注冊頁面時 有用到省市聯動，在網上看了下 沒有整合好 的 好多都是介紹。所以對于我這樣的新手來說，挺麻煩的。所以把大家的東西整合下。一個完整的省市聯動。

資源截圖

代碼片段和文件信息 

using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Data.SqlClient;
using?System.Data;

namespace?WebApplication2
{
????public?partial?class?WebForm1?:?System.Web.UI.Page
????{
????????protected?void?Page_Load（object?sender?EventArgs?e）
????????{
????????????if?（!Page.IsPostBack）
????????????{
????????????????//創建數據源
????????????????SqlConnection?con?=?new?SqlConnection（“Data?Source=.\\SQLEXPRESS;Initial?Catalog=shengshiliandong;User?ID=sa;password=123456;“）;
????????????????//打開數據源?
????????????????con.Open（）;
????????????????DataSet?ds?=?new?DataSet（）;
????????????????SqlDataAdapter?da?=?new?SqlDataAdapter（“select?*?from?Province“?con）;
????????????????da.Fill（ds）;
????????????????this.DropDownList1.DataTextField?=?ds.Tables[0].Columns[“Name“].ToString（）;
????????????????this.DropDownList1.DataValueField?=?ds.Tables[0].Columns[“ProvinceID“].ToString（）;
????????????????this.DropDownList1.DataSource?=?ds.Tables[0];
????????????????this.DropDownList1.DataBind（）;
????????????????con.Close（）;

????????????}
????????}

????????protected?void?DropDownList1_SelectedIndexChanged（object?sender?EventArgs?e）
????????{
????????????string?str?=?this.DropDownList1.SelectedValue.ToString（）;
????????????SqlConnection?con?=?new?SqlConnection（“Data?Source=.\\SQLEXPRESS;Initial?Catalog=shengshiliandong;User?ID=sa;password=123456;“）;
????????????//打開數據源?
????????????con.Open（）;
????????????DataSet?ds?=?new?DataSet（）;
????????????SqlDataAdapter?da?=?new?SqlDataAdapter（“select?*?from?City?where?ProvinceID?=?‘“?+?str?+?“‘“?con）;
????????????da.Fill（ds）;
????????????this.DropDownList2.DataTextField?=?ds.Tables[0].Columns[“Name“].ToString（）;
????????????this.DropDownList2.DataValueField?=?ds.Tables[0].Columns[“CityID“].ToString（）;
????????????this.DropDownList2.DataSource?=?ds.Tables[0];
????????????this.DropDownList2.DataBind（）;
????????????con.Close（）;
????????}

????????protected?void?Button1_Click（object?sender?EventArgs?e）
????????{
????????????Label1.Text?=?DropDownList1.SelectedItem.Text;
????????????Label2.Text?=?DropDownList2.SelectedItem.Text;
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-03-16?17:12??WebApplication2\
?????目錄???????????0??2013-03-16?17:12??WebApplication2\Data\
?????文件?????3145728??2013-03-16?17:09??WebApplication2\Data\shengshiliandong.mdf
?????文件?????1048576??2013-03-16?17:09??WebApplication2\Data\shengshiliandong_log.ldf
?????目錄???????????0??2013-03-16?16:45??WebApplication2\WebApplication2\
?????文件?????????935??2013-03-16?16:45??WebApplication2\WebApplication2.sln
?????文件???????22016??2013-03-16?17:05??WebApplication2\WebApplication2.suo
?????目錄???????????0??2013-03-16?17:11??WebApplication2\WebApplication2\App_Data\
?????目錄???????????0??2013-03-16?16:57??WebApplication2\WebApplication2\bin\
?????文件????????6144??2013-03-16?17:02??WebApplication2\WebApplication2\bin\WebApplication2.dll
?????文件???????13824??2013-03-16?17:02??WebApplication2\WebApplication2\bin\WebApplication2.pdb
?????目錄???????????0??2013-03-16?16:45??WebApplication2\WebApplication2\obj\
?????目錄???????????0??2013-03-16?17:02??WebApplication2\WebApplication2\obj\Debug\
?????文件????????6879??2013-03-16?17:05??WebApplication2\WebApplication2\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????目錄???????????0??2013-03-16?16:45??WebApplication2\WebApplication2\obj\Debug\TempPE\
?????文件?????????414??2013-03-16?16:57??WebApplication2\WebApplication2\obj\Debug\WebApplication2.csproj.FileListAbsolute.txt
?????文件????????6144??2013-03-16?17:02??WebApplication2\WebApplication2\obj\Debug\WebApplication2.dll
?????文件???????13824??2013-03-16?17:02??WebApplication2\WebApplication2\obj\Debug\WebApplication2.pdb
?????目錄???????????0??2013-03-16?16:45??WebApplication2\WebApplication2\Properties\
?????文件????????1331??2013-03-16?16:45??WebApplication2\WebApplication2\Properties\AssemblyInfo.cs
?????文件?????????313??2013-03-16?16:45??WebApplication2\WebApplication2\Web.config
?????文件????????1240??2013-03-16?16:45??WebApplication2\WebApplication2\Web.Debug.config
?????文件????????1301??2013-03-16?16:45??WebApplication2\WebApplication2\Web.Release.config
?????文件????????4373??2013-03-16?16:57??WebApplication2\WebApplication2\WebApplication2.csproj
?????文件????????1086??2013-03-16?16:57??WebApplication2\WebApplication2\WebApplication2.csproj.user
?????文件????????1280??2013-03-16?17:04??WebApplication2\WebApplication2\WebForm1.aspx
?????文件????????2276??2013-03-16?17:05??WebApplication2\WebApplication2\WebForm1.aspx.cs
?????文件????????2541??2013-03-16?16:54??WebApplication2\WebApplication2\WebForm1.aspx.designer.cs
?????文件?????????114??2013-03-16?17:13??WebApplication2\新建文本文檔.txt

評論

共有 條評論