asp如何实现模糊查询，求助急在线等！！！！！

[CS_95500]

<%
var sqlwhere = Request.Form("textfield");
var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_conn_ods_STRING;
if(Request.Form("n")+"'"=="undefined'"){
Recordset1.Source = "SELECT * FROM occ_code";
}else{
Recordset1.Source = "SELECT * FROM occ_code WHERE occ_name_chn like '%"+ Recordset1__ocname.replace(/'/g, "''") + "%'";
};
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%>

<th>职业代码<input type="text" name="proco" id="procode" value="请输入职业代码" onFocus="if(this.value=='请输入职业代码')this.value='';"></th>
<th>职业名称<input type="text" name="prona" id="proname" value="请输入职业名称" onFocus="if(this.value=='请输入职业名称')this.value='';"></th>
<th><input name="execute" type="button" id="exec" value="查询" "/></th>

以上就是本菜鸟的代码，进来直接查询出了所有的记录，我想再做个模糊查询，通过点击查询按钮传值给上面的sql语句，不会弄，求助！！！！！

[CS_95500]

楼上能不能给个联系方式，我的问题好像描述的不是很清楚。

[CS_95500]

引用 1 楼 oi_2273131935 的回复:

asp.net实现模糊查询示例 //查询设置 protected void ImageButton1_Click1(object sender, ImageClickEventArgs e) { if (this.ddlCity.SelectedValue != "") { Session["searchKey1"] = ddlCity.SelectedItem.Text;//设置查询地区 Session["searchKey2"] = radlistSex.SelectedValue.Trim();//根据地区查询性别 Response.Redirect("Ssdiqu_nn.aspx");//如果存在此信息就跳转显示信息 } else { Response.Write("<script>alert('还没有信息！');location='Yhguanli.aspx'</script>"); } }//codego.net/tags/11/1/ //aspx查询显示页面设置 <asp:DataList ID="DataList1" runat="server" RepeatColumns="2" Width="600px" Height="403px"> <ItemTemplate> <table style="font-size: 10pt; height: 100px" border="0" cellpadding="0" cellspacing="0"> <tr> <tr> <td rowspan="6" style="width: 120px; height: 100px;"> <img alt="查看图片" id="image" src='<%#Eval("Images")%>' style="border: 0" width="100" /> </td> <td style="width: 220px; height: 20px; text-align: left; font-size: 9pt; vertical-align: middle;"> 客户名称：<%# Eval("UserName") %> </td> </tr> <tr> <td style="width: 220px; height: 20px; text-align: left; vertical-align: middle"> 地址：<%# Eval("Province") %>省<%# Eval("city") %>市 </td> </tr> <tr> <td style="width: 220px; height: 20px; text-align: left; vertical-align: middle"> QQ号码：<%# Eval("QQ") %> </td> </tr> <tr> <td style="width: 220px;"> 昵称：<%# Eval("sex") %> </td> </tr> <tr> <td style="width: 220px;"> 详细信息：<a href='xiang_xi.aspx?HenuID=<%#Eval("HenuID") %>'><%# Eval("UserName") %></a> </td> </tr> </tr> </table> </ItemTemplate> </asp:DataList> //绑定数据控件显示数据库相关数据并翻页 protected void Page_Load(object sender, EventArgs e)//加载信息 { bindDataList();//显示方法 } //定义方法显示数据绑定 protected void bindDataList() { int noncePage = Convert.ToInt32(labPage.Text); PagedDataSource ps = new PagedDataSource(); string sqlSel1 = "select * from tb_huen_lian,tb_HuenLian where ICQ between '1983-01-01' and '1988-01-01' and tb_huen_lian.UserName = tb_HuenLian.UserName and tb_HuenLian.sex like '%" + Session["searchKey2"] + "%' and tb_HuenLian.city like '%" + Session["searchKey1"] + "%'"; ps.DataSource = operateData.getRows(sqlSel1).DefaultView; ps.AllowPaging = true; ps.PageSize = 8; ps.CurrentPageIndex = noncePage - 1; this.lnkbtnFront.Enabled = true; this.lnkbtnNext.Enabled = true; this.lnkbtnLast.Enabled = true; this.lnkbtnFirst.Enabled = true; if (noncePage == 1) { this.lnkbtnFirst.Enabled = false;//不显示第一页按钮 this.lnkbtnFront.Enabled = false;//不显示上一页按钮 } if (noncePage == ps.PageCount) { this.lnkbtnNext.Enabled = false;//不显示下一页 this.lnkbtnLast.Enabled = false;//不显示最后一页 } labBackPage.Text = Convert.ToString(ps.PageCount); DataList1.DataSource = ps; DataList1.DataBind(); }

你的方法我看了下，貌似是我描述的问题不对，能不能给个联系方式！

[oi_2273131935]

asp.net实现模糊查询示例 //查询设置 protected void ImageButton1_Click1(object sender, ImageClickEventArgs e) { if (this.ddlCity.SelectedValue != "") { Session["searchKey1"] = ddlCity.SelectedItem.Text;//设置查询地区 Session["searchKey2"] = radlistSex.SelectedValue.Trim();//根据地区查询性别 Response.Redirect("Ssdiqu_nn.aspx");//如果存在此信息就跳转显示信息 } else { Response.Write("<script>alert('还没有信息！');location='Yhguanli.aspx'</script>"); } }//codego.net/tags/11/1/ //aspx查询显示页面设置 <asp:DataList ID="DataList1" runat="server" RepeatColumns="2" Width="600px" Height="403px"> <ItemTemplate> <table style="font-size: 10pt; height: 100px" border="0" cellpadding="0" cellspacing="0"> <tr> <tr> <td rowspan="6" style="width: 120px; height: 100px;"> <img alt="查看图片" id="image" src='<%#Eval("Images")%>' style="border: 0" width="100" /> </td> <td style="width: 220px; height: 20px; text-align: left; font-size: 9pt; vertical-align: middle;"> 客户名称：<%# Eval("UserName") %> </td> </tr> <tr> <td style="width: 220px; height: 20px; text-align: left; vertical-align: middle"> 地址：<%# Eval("Province") %>省<%# Eval("city") %>市 </td> </tr> <tr> <td style="width: 220px; height: 20px; text-align: left; vertical-align: middle"> QQ号码：<%# Eval("QQ") %> </td> </tr> <tr> <td style="width: 220px;"> 昵称：<%# Eval("sex") %> </td> </tr> <tr> <td style="width: 220px;"> 详细信息：<a href='xiang_xi.aspx?HenuID=<%#Eval("HenuID") %>'><%# Eval("UserName") %></a> </td> </tr> </tr> </table> </ItemTemplate> </asp:DataList> //绑定数据控件显示数据库相关数据并翻页 protected void Page_Load(object sender, EventArgs e)//加载信息 { bindDataList();//显示方法 } //定义方法显示数据绑定 protected void bindDataList() { int noncePage = Convert.ToInt32(labPage.Text); PagedDataSource ps = new PagedDataSource(); string sqlSel1 = "select * from tb_huen_lian,tb_HuenLian where ICQ between '1983-01-01' and '1988-01-01' and tb_huen_lian.UserName = tb_HuenLian.UserName and tb_HuenLian.sex like '%" + Session["searchKey2"] + "%' and tb_HuenLian.city like '%" + Session["searchKey1"] + "%'"; ps.DataSource = operateData.getRows(sqlSel1).DefaultView; ps.AllowPaging = true; ps.PageSize = 8; ps.CurrentPageIndex = noncePage - 1; this.lnkbtnFront.Enabled = true; this.lnkbtnNext.Enabled = true; this.lnkbtnLast.Enabled = true; this.lnkbtnFirst.Enabled = true; if (noncePage == 1) { this.lnkbtnFirst.Enabled = false;//不显示第一页按钮 this.lnkbtnFront.Enabled = false;//不显示上一页按钮 } if (noncePage == ps.PageCount) { this.lnkbtnNext.Enabled = false;//不显示下一页 this.lnkbtnLast.Enabled = false;//不显示最后一页 } labBackPage.Text = Convert.ToString(ps.PageCount); DataList1.DataSource = ps; DataList1.DataBind(); }