.aspx
<div>
<asp:Label ID="Label1" runat="server" Text="试剂名称:"></asp:Label>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />
<asp:Label ID="Label2" runat="server" Text="试剂编号:"></asp:Label>
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
<asp:Label ID="Label" runat="server" Text=""></asp:Label>
</div>
.aspx.cs
protected void Button1_Click(object sender, EventArgs e)
{
string Name = TextBox1.Text;
SqlConnection conn = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=Test03;Integrated security = true;");
conn.Open();
SqlCommand cmd = new SqlCommand("select * from TB_RuKu where MingCheng='" + Name + "'", conn);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
if (sdr["MingCheng"].ToString() == this.TextBox1.Text)
TextBox2.Text = sdr["No"].ToString();
Label.Text = sdr["NO"].ToString();
}
sdr.Close();
sdr.Dispose();
cmd.Dispose();
}
不足之处:输入名称后,在点击button按钮触发事件后,才能获取数据输出到Text Box和label中,这不是我想要实现的功能,我想要实现的是输入名称后,页面直接获取数据输出到Text Box和Label中,无需触发Button事件
本人只是出入C#的菜鸟,才疏学浅,有很多不足之处,望各位大佬指教