using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string sql = "server=XUXINGSHI-PC\\SQLEXPRESS;database=SS;integrated security=sspi";
DataSet dt = new DataSet();
using (SqlConnection sqlcnn = new SqlConnection())
{
sqlcnn.ConnectionString = sql;
SqlCommand sqlcmm = sqlcnn.CreateCommand();
sqlcmm.CommandText = "select proid,proname from t_province";
SqlDataAdapter da = new SqlDataAdapter(sqlcmm);
da.Fill(dt);
}
this.RadioButtonList1.DataSource = dt.Tables[0];
this.RadioButtonList1.DataTextField = "proname";
this.RadioButtonList1.DataValueField = "proid";
this.CheckBoxList1.DataSource = dt.Tables[0];
this.CheckBoxList1.DataTextField = "proname";
this.CheckBoxList1.DataValueField = "proid";
this.Dropdownlist1.Items.Clear();
this.Dropdownlist1.DataSource = dt.Tables[0];
this.Dropdownlist1.DataTextField = "proname";
this.Dropdownlist1.DataValueField = "proID";
this.DataBind();
using (SqlConnection sqlcnn = new SqlConnection())
{
sqlcnn.ConnectionString = sql;
SqlCommand sqlcmm = sqlcnn.CreateCommand();
sqlcmm.CommandText = "select cityID,cityname from t_city where proID=" + this.Dropdownlist1.SelectedValue;
SqlDataAdapter da = new SqlDataAdapter(sqlcmm);
da.Fill(dt);
}
this.Dropdownlist2.Items.Clear();
this.Dropdownlist2.DataSource = dt.Tables[0];
this.Dropdownlist2.DataTextField = "cityname";
this.Dropdownlist2.DataValueField = "cityID";
this.DataBind();
}
}
protected void Dropdownlist1_SelectedIndexChanged(object sender, EventArgs e)
{
string sql = "server=XUXINGSHI-PC\\SQLEXPRESS;database=SS;integrated security=sspi";
DataSet dt = new DataSet();
using (SqlConnection sqlcnn = new SqlConnection())
{
sqlcnn.ConnectionString = sql;
SqlCommand sqlcmm = sqlcnn.CreateCommand();
sqlcmm.CommandText = "select cityID,cityname from t_city where proID=" + this.Dropdownlist1.SelectedValue;
SqlDataAdapter da = new SqlDataAdapter(sqlcmm);
da.Fill(dt);
}
this.Dropdownlist2.Items.Clear();
this.Dropdownlist2.DataSource = dt.Tables[0];
this.Dropdownlist2.DataTextField = "cityname";
this.Dropdownlist2.DataValueField = "cityID";
this.DataBind();
}
protected string title;
//protected string Title1
//{
// get { return title; }
// set { title = value; }
//}
protected void Button1_Click(object sender, EventArgs e)
{
title = Convert.ToString(this.RadioButtonList1.SelectedItem.Text);
this.DataBind();
}
}