110,524
社区成员
发帖
与我相关
我的任务
分享
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
Namespace="System.Web.UI" TagPrefix="asp" %>
<!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">
<asp:ScriptManager ID="ScriptManager1" runat="server" EnablePartialRendering="true">
</asp:ScriptManager>
<table>
<tr>
<td style="width: 100px">
<asp:UpdatePanel ID="UpdatePanel2" runat="server" UpdateMode="Conditional"> <ContentTemplate>
<asp:DropDownList ID="ddlMine" runat="server" Width="150px" AutoPostBack="True" OnSelectedIndexChanged="ddlMine_SelectedIndexChanged">
</asp:DropDownList>
<asp:TextBox ID="tbMine" runat="server" Width="284px"><asp:TextBox>
</ContentTemplate>
<Triggers>
<asp:AsyncPostBackTrigger ControlID="ddlMine" EventName="SelectedIndexChanged" />
</Triggers>
</asp:UpdatePanel>
</td>
</tr>
</table>
</form>
</body>
</html>
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 SqlCommon conn = new SqlCommon();//数据库类
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
try
{
string strSql = string.Empty;
strSql = "select MineName from Mine where AreaNum='01'";
conn.open();
DataSet myDsDP = conn.ExceDS(strSql);//此方法返回一个DataSet类型
for (int i = 0; i < myDsDP.Tables[0].Rows.Count; i++)
{
ddlMine.Items.Add(myDsDP.Tables[0].Rows[i][0].ToString());
}
}
catch
{
Response.Write("<script language=javascript>alert('读取数据库失败!!!')</script>");
}
finally
{
conn.close();
}
}
}
protected void ddlMine_SelectedIndexChanged(object sender, EventArgs e)
{
tbMine.Text = ddlMine.SelectedItem.Text;
}
<%@ Page enableEventValidation="false"%>
<!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>
<script type="text/javascript">
function ddlChange(ddl)
{
document.getElementById("<%= tbMine.ClientID %>").value = ddl.options[ddl.selectedIndex].value;
}
</script>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<table>
<tr>
<td style="width: 100px">
<asp:DropDownList ID="ddlMine" runat="server" Width="150px" onchange="ddlChange(this);">
</asp:DropDownList>
<asp:TextBox ID="tbMine" runat="server" Width="284px"><asp:TextBox>
</td>
</tr>
</table>
</form>
</body>
</html>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
Namespace="System.Web.UI" TagPrefix="asp" %>
<!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">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<table>
<tr>
<td style="width: 100px">
<asp:UpdatePanel ID="UpdatePanel2" runat="server"> <ContentTemplate>
<asp:DropDownList ID="ddlMine" runat="server" Width="150px" AutoPostBack="True" OnSelectedIndexChanged="ddlMine_SelectedIndexChanged">
</asp:DropDownList>
<asp:TextBox ID="tbMine" runat="server" Width="284px"><asp:TextBox>
</ContentTemplate>
</asp:UpdatePanel>
</td>
</tr>
</table>
</form>
</body>
</html>