62,026
社区成员
发帖
与我相关
我的任务
分享
string sno = Request.Params["sno"].ToString();
string querySql = "SELECT [name], [sex], [age] FROM [student] WHERE [sno]=" + sno;
ddlSex.Text = reader.getString(1)
Label1.Text = reader.GetString(1);
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="lblSno" runat="server" Text="学生学号"></asp:Label>
<asp:TextBox ID="txtSno" runat="server"></asp:TextBox>
<br />
<asp:Label ID="lblName" runat="server" Text="学生姓名"></asp:Label>
<asp:TextBox ID="txtName" runat="server"></asp:TextBox>
<br />
<asp:Label ID="lblSex" runat="server" Text="学生性别"></asp:Label>
<asp:DropDownList ID="ddlSex" runat="server" Width="128px">
<asp:ListItem>男</asp:ListItem>
<asp:ListItem>女</asp:ListItem>
</asp:DropDownList>
<br />
<asp:Label ID="lblAge" runat="server" Text="学生年龄"></asp:Label>
<asp:TextBox ID="txtAge" runat="server"></asp:TextBox>
<br />
<asp:Button ID="btnSave" runat="server" Text="保存" />
<asp:Button ID="btnCancel" runat="server" Text="取消" />
<br />
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
</div>
</form>
</body>
public partial class EditStudentInfo : System.Web.UI.Page
{
SqlConnection conn = null;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string connString = ConfigurationManager.ConnectionStrings["testConnectionString1"].ConnectionString;
conn = new SqlConnection(connString);
string sno = Request.Params["sno"].ToString();
try
{
conn.Open();
string querySql = "SELECT [name], [sex], [age] FROM [student] WHERE [sno]=" + sno;
SqlCommand queryCmd = new SqlCommand(querySql, conn);
SqlDataReader reader = queryCmd.ExecuteReader();
while (reader.Read())
{
txtSno.Text = sno;
txtName.Text = reader.GetString(0);
Label1.Text = reader.GetString(1);
ddlSex.Text = reader.GetString(1);
txtAge.Text = reader.GetInt16(2).ToString();
}
}
catch (SqlException sqle1)
{
Console.WriteLine(sqle1.Message);
}
}
}
}
foreach (ListItem item in ddlSex.Items)
{
if (item.Text == "根据Id来读取的男女")
{
item.Selected = true;
break;
}
}