SQL2000+.NET做省市联动
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
//绑定省
SqlConnection con = new SqlConnection("server=.;database=dropDownTest;integrated security=true;");
}
} using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack) SQL2000+.NET做省市联动
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
//绑定省
SqlConnection con = new SqlConnection("server=.;database=dropDownTest;integrated security=true;");
con.Open();
SqlCommand cmd = new SqlCommand("select*from provience", con);
SqlDataReader sdr = cmd.ExecuteReader();
this.ddlprovince.DataSource = sdr;
this.ddlprovince.DataTextField = "proName";
this.ddlprovince.DataValueField = "proID";
this.ddlprovince.DataBind();
sdr.Close();
//绑定市
SqlCommand cmdcity = new SqlCommand("select*from city where proID=" + this.ddlprovince.SelectedValue, con);
SqlDataReader sdr1 = cmdcity.ExecuteReader();
this.ddlcity.DataSource = sdr1;
this.ddlcity.DataTextField = "cityName";
this.ddlcity.DataValueField = "cityID";
this.ddlcity.DataBind();
sdr1.Close();
con.Close();
}
}
SqlCommand cmdcity = new SqlCommand("select*from city where proID=" + this.ddlprovince.SelectedValue, con);
SqlDataReader sdr1 = cmdcity.ExecuteReader();
this.ddlcity.DataSource = sdr1;
this.ddlcity.DataTextField = "cityName";
this.ddlcity.DataValueField = "cityID";
this.ddlcity.DataBind();
sdr1.Close();
con.Close();
}
SqlConnection con = new SqlConnection("server=.;database=dropDownTest;integrated security=true;");
con.Open();
SqlCommand cmd = new SqlCommand("select*from city where proID=" + this.ddlprovince.SelectedValue, con);
SqlDataReader sdr= cmd.ExecuteReader();
this.ddlcity.DataSource = sdr;
this.ddlcity.DataTextField = "cityName";
this.ddlcity.DataValueField = "cityID";
this.ddlcity.DataBind();
sdr.Close();
con.Close();
}
}SQL2000+.NET做省市联动
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
//绑定省
SqlConnection con = new SqlConnection("server=.;database=dropDownTest;integrated security=true;");
con.Open();
SqlCommand cmd = new SqlCommand("select*from provience", con);
SqlDataReader sdr = cmd.ExecuteReader();
this.ddlprovince.DataSource = sdr;
this.ddlprovince.DataTextField = "proName";
this.ddlprovince.DataValueField = "proID";
this.ddlprovince.DataBind();
sdr.Close();
//绑定市
SqlCommand cmdcity = new SqlCommand("select*from city where proID=" + this.ddlprovince.SelectedValue, con);
SqlDataReader sdr1 = cmdcity.ExecuteReader();
this.ddlcity.DataSource = sdr1;
this.ddlcity.DataTextField = "cityName";
this.ddlcity.DataValueField = "cityID";
this.ddlcity.DataBind();
sdr1.Close();
con.Close();
}
SqlConnection con = new SqlConnection("server=.;database=dropDownTest;integrated security=true;");
con.Open();
SqlCommand cmd = new SqlCommand("select*from city where proID=" + this.ddlprovince.SelectedValue, con);
SqlDataReader sdr= cmd.ExecuteReader();
this.ddlcity.DataSource = sdr;
this.ddlcity.DataTextField = "cityName";
this.ddlcity.DataValueField = "cityID";
this.ddlcity.DataBind();
sdr.Close();
con.Close();
}
}SQL2000+.NET做省市联动
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
//绑定省
SqlConnection con = new SqlConnection("server=.;database=dropDownTest;integrated security=true;");
con.Open();
SqlCommand cmd = new SqlCommand("select*from provience", con);
SqlDataReader sdr = cmd.ExecuteReader();
this.ddlprovince.DataSource = sdr;
this.ddlprovince.DataTextField = "proName";
this.ddlprovince.DataValueField = "proID";
this.ddlprovince.DataBind();
sdr.Close();
//绑定市
SqlCommand cmdcity = new SqlCommand("select*from city where proID=" + this.ddlprovince.SelectedValue, con);
SqlDataReader sdr1 = cmdcity.ExecuteReader();
this.ddlcity.DataSource = sdr1;
this.ddlcity.DataTextField = "cityName";
this.ddlcity.DataValueField = "cityID";
this.ddlcity.DataBind();
sdr1.Close();
con.Close();
}
SQL2000+.NET做省市联动
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
//绑定省
SqlConnection con = new SqlConnection("server=.;database=dropDownTest;integrated security=true;");
con.Open();
SqlCommand cmd = new SqlCommand("select*from provience", con);
SqlDataReader sdr = cmd.ExecuteReader();
this.ddlprovince.DataSource = sdr;
this.ddlprovince.DataTextField = "proName";
this.ddlprovince.DataValueField = "proID";
this.ddlprovince.DataBind();
sdr.Close();
//绑定市
SqlCommand cmdcity = new SqlCommand("select*from city where proID=" + this.ddlprovince.SelectedValue, con);
SqlDataReader sdr1 = cmdcity.ExecuteReader();
this.ddlcity.DataSource = sdr1;
this.ddlcity.DataTextField = "cityName";
this.ddlcity.DataValueField = "cityID";
this.ddlcity.DataBind();
sdr1.Close();
con.Close();
}