员工编号:<input id="Text1" type="text" /> //HTML 控件
员工编号:<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> //服务器控件
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />想查询员工编号为某个人的数据是这样操作:(用服务器控件)
protected void Button1_Click(object sender, EventArgs e)
{
string sql = " select * From employee where empId='"+this.TextBox1.Text+"'";//取服务器控件的值
SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=sa;database=pubs");
con.Open();
SqlCommand cmd = new SqlCommand(sql);
cmd.ExecuteReader();
}
如果换成是HTML 控件的话代码应如何写呢?
员工编号:<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> //服务器控件
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />想查询员工编号为某个人的数据是这样操作:(用服务器控件)
protected void Button1_Click(object sender, EventArgs e)
{
string sql = " select * From employee where empId='"+this.TextBox1.Text+"'";//取服务器控件的值
SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=sa;database=pubs");
con.Open();
SqlCommand cmd = new SqlCommand(sql);
cmd.ExecuteReader();
}
如果换成是HTML 控件的话代码应如何写呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货