110,536
社区成员
发帖
与我相关
我的任务
分享
<asp:TextBox ID="textfield" runat="server">请刷条码号</asp:TextBox>
<asp:Button ID="Submit" runat="server" OnClick="Submit_Click" Text="搜索" />
<asp:FormView ID="FormView1" runat="server" Width="521px" Height="125px" >
<ItemTemplate>
您的姓名:<asp:Label ID="Label2" runat="server" Text='<%# Bind("brxm") %>'></asp:Label><br>
您的联系方式:<asp:Label ID="Label3" runat="server" Text='<%# Bind("jtdh") %>'></asp:Label><br>
<br><br><br><br><br><br><br>
<a href="javascript:location.href='ks.aspx?brxm=' + escape('<%=brxm%>') + '&jtdh=' + escape('<%=jtdh%>');void(0);">下一步</a>
</ItemTemplate>
</asp:FormView>
public partial class _Default : System.Web.UI.Page
{
public string brxm;
public string jtdh;
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["brxm"] != null)//判断是否有接受值,如果有
{
brxm = Request.QueryString["brxm"].ToString();
}
if (Request.QueryString["jtdh"] != null)//判断是否有接受值,如果有
{
jtdh = Request.QueryString["jtdh"].ToString();
}
if (Request.QueryString["textfield"] != null)//判断是否有接受值,如果有
{
id = Request.QueryString["textfield"].ToString();
}
textfield.Attributes.Add("onclick", "if (this.value=='请刷条码号') this.value='';");
textfield.Attributes.Add("onkeydown", "SubmitKeyClick('Submit');");
//Link.Visible = false;
}
protected void Submit_Click(object sender, EventArgs e)
{
string ConnectionString = "server=192.168.1.20;Data Source=hrp;user id=hrp;password=hrp;";//写连接串
OracleConnection conn = new OracleConnection(ConnectionString);//创建一个新连接
try
{
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select distinct brxm,jtdh from v_ms_brxx where jzkh like '%" + textfield.Text.ToString().Trim() + "%'";//sql查询语句
OracleDataReader dr = cmd.ExecuteReader();
FormView1.DataSource = dr;
FormView1.DataBind();
textfield.Text = "";
textfield.Visible = false;
Submit.Visible = false;
dr.Close();
}
catch (Exception ee)
{
Response.Write(ee.Message); //如果有错误,输出错误信息
}
finally
{
conn.Close(); //关闭连接
}
}
}