CODE
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.Text;
using System.Data.SqlClient;
using System.Security;
using System.Security.Principal;
using System.Security.Cryptography;public interface IType
{
/// <summary>
/// 获取大类
/// </summary>
/// <returns><returns>
SqlDataReader GetDtype(); /// <summary>
/// 获取小类
/// </summary>
/// <returns><returns>
SqlDataReader GetDty();
}public class Type : IType
{
private static readonly string GETDTYPE = "SELECT * FROM Dtype";
private static readonly string GETDTY = "SELECT * FROM Dty,Dtype WHERE Dty.TID=Dtype.TypeId"; public SqlDataReader GetDtype()
{
///创建链接
SqlConnection myConnection = new SqlConnection(
ConfigurationManager.ConnectionStrings["AConn"].ConnectionString);
///创建Command
SqlCommand myCommand = new SqlCommand(GETDTYPE, myConnection); ///定义DataReader
SqlDataReader dr = null;
try
{
///打开链接
myConnection.Open();
///读取数据
dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (SqlException ex)
{
///抛出异常
throw new Exception(ex.Message, ex);
}
///返回DataReader
return dr;
}
public SqlDataReader GetDty()
{
///创建链接
SqlConnection myConnection = new SqlConnection(
ConfigurationManager.ConnectionStrings["AConn"].ConnectionString);
///创建Command
SqlCommand myCommand = new SqlCommand(GETDTY, myConnection); ///定义DataReader
SqlDataReader dr = null;
try
{
///打开链接
myConnection.Open();
///读取数据
dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (SqlException ex)
{
///抛出异常
throw new Exception(ex.Message, ex);
}
///返回DataReader
return dr;
}}
//////////////////////////////////////////////////////////////////////////////////////////////////
前台:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged"></asp:DropDownList>
<asp:DropDownList ID="DropDownList2" runat="server"><asp:ListItem Text="请选择..." Value=""></asp:ListItem>
</asp:DropDownList>
</div>
</form>
</body>
</html>
/////////////////////////////////////////////////////////////////////////////////////////////
后台:
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 (!Page.IsPostBack)
{
BindDtypeData();
}
}
private void BindDtypeData()
{
///获取大类
IType type = new Type();
SqlDataReader dr = type.GetDtype(); ///设置DropDownList的数据源,并绑定数据
DropDownList1.DataSource = dr;
DropDownList1.DataTextField = "TypeName";
DropDownList1.DataValueField = "TypeID";
DropDownList1.SelectedIndex = this.DropDownList1.SelectedValue;
DropDownList1.DataBind(); ///关闭数据读取器
dr.Close();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
///获取小类
IType type = new Type();
SqlDataReader ds = type.GetDty(); ///设置DropDownList的数据源,并绑定数据
DropDownList2.DataSource = ds;
DropDownList2.DataTextField = "TyName";
DropDownList2.DataValueField = "TyID";
DropDownList2.DataBind(); ///关闭数据读取器
ds.Close();
}
}
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.Text;
using System.Data.SqlClient;
using System.Security;
using System.Security.Principal;
using System.Security.Cryptography;public interface IType
{
/// <summary>
/// 获取大类
/// </summary>
/// <returns><returns>
SqlDataReader GetDtype(); /// <summary>
/// 获取小类
/// </summary>
/// <returns><returns>
SqlDataReader GetDty();
}public class Type : IType
{
private static readonly string GETDTYPE = "SELECT * FROM Dtype";
private static readonly string GETDTY = "SELECT * FROM Dty,Dtype WHERE Dty.TID=Dtype.TypeId"; public SqlDataReader GetDtype()
{
///创建链接
SqlConnection myConnection = new SqlConnection(
ConfigurationManager.ConnectionStrings["AConn"].ConnectionString);
///创建Command
SqlCommand myCommand = new SqlCommand(GETDTYPE, myConnection); ///定义DataReader
SqlDataReader dr = null;
try
{
///打开链接
myConnection.Open();
///读取数据
dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (SqlException ex)
{
///抛出异常
throw new Exception(ex.Message, ex);
}
///返回DataReader
return dr;
}
public SqlDataReader GetDty()
{
///创建链接
SqlConnection myConnection = new SqlConnection(
ConfigurationManager.ConnectionStrings["AConn"].ConnectionString);
///创建Command
SqlCommand myCommand = new SqlCommand(GETDTY, myConnection); ///定义DataReader
SqlDataReader dr = null;
try
{
///打开链接
myConnection.Open();
///读取数据
dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (SqlException ex)
{
///抛出异常
throw new Exception(ex.Message, ex);
}
///返回DataReader
return dr;
}}
//////////////////////////////////////////////////////////////////////////////////////////////////
前台:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged"></asp:DropDownList>
<asp:DropDownList ID="DropDownList2" runat="server"><asp:ListItem Text="请选择..." Value=""></asp:ListItem>
</asp:DropDownList>
</div>
</form>
</body>
</html>
/////////////////////////////////////////////////////////////////////////////////////////////
后台:
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 (!Page.IsPostBack)
{
BindDtypeData();
}
}
private void BindDtypeData()
{
///获取大类
IType type = new Type();
SqlDataReader dr = type.GetDtype(); ///设置DropDownList的数据源,并绑定数据
DropDownList1.DataSource = dr;
DropDownList1.DataTextField = "TypeName";
DropDownList1.DataValueField = "TypeID";
DropDownList1.SelectedIndex = this.DropDownList1.SelectedValue;
DropDownList1.DataBind(); ///关闭数据读取器
dr.Close();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
///获取小类
IType type = new Type();
SqlDataReader ds = type.GetDty(); ///设置DropDownList的数据源,并绑定数据
DropDownList2.DataSource = ds;
DropDownList2.DataTextField = "TyName";
DropDownList2.DataValueField = "TyID";
DropDownList2.DataBind(); ///关闭数据读取器
ds.Close();
}
}
解决方案 »
- 网上购物后怎么让消费者查询邮包.
- 请问一下 MVC 中 ,我要拼接一个 id 如何拼接呢。
- 实体类加个[Serializable]有无必要?
- 关于jmail配置的简单问题,在线等
- repeater中一行显示两组数据
- 关于IE6,IE7共存 Error:The download of the specified resource had failed,
- 怎么样在后台代码自己添加控件,比如Button!
- 请问大家过滤数据表里的换行符是怎样过滤?比如这样的一列dsDN.Tables(view_name).Rows(0).Item(6)我想过滤掉里面的换行符应是怎样写?
- 急急急!一个关于水晶报表注册码的问题!
- B/S系统如何控制指定客户端登陆?
- 无法赋值
- 日文环境下的中文asp.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
{
SqlConnection conn = new SqlConnection("server=localhost;database=Archives;uid=sa;pwd=ak4740;");
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
P();
}
}public void P()
{
conn.Open();
string sql1 = "Select * From DType";
SqlDataAdapter sda = new SqlDataAdapter(sql1, conn);
DataSet ds1 = new DataSet();
sda.Fill(ds1, "P");
DataTable dt = ds1.Tables["P"];
DropDownList1.Items.Add(new ListItem("请选择...", ""));
foreach (DataRow dr in dt.Rows)
{
DropDownList1.Items.Add(new ListItem(dr["TypeName"].ToString(), dr["TypeID"].ToString()));
}
conn.Close();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
conn.Open();
string sql2 = "Select * From Dty Where TID=" + DropDownList1.SelectedValue + "";
SqlCommand comm = new SqlCommand(sql2, conn);
SqlDataReader sdr = comm.ExecuteReader();
DropDownList2.Items.Clear();
while (sdr.Read())
{
DropDownList2.Items.Add(new ListItem(sdr["TyName"].ToString(), sdr["TyID"].ToString()));
}
conn.Close();
}
}