Response.Redirect("booklist.aspx?Type=Serarch&SerarchField=" & ddlsearch.SelectedItem.Value + & "&SerchText=" + Tel1.Text);获得:
string Type = Request.QueryString["Type"];
string SerarchField= Request.QueryString["SerarchField"];
string SerchText= Request.QueryString["SerchText"];
string Type = Request.QueryString["Type"];
string SerarchField= Request.QueryString["SerarchField"];
string SerchText= Request.QueryString["SerchText"];
解决方案 »
- .net中GridView的问题。。。高手求救。。
- runat='server'的form的action属性问题
- 如何用sqldatasource实现注册登陆功能?还要用到其他控件么?
- kernel32.dll 有哪些可调用的方法
- 一个正则的问题
- js 控制CheckBox 单选后取消选择
- 紧急求救!!!!!!VS2005+SqlServer2000连接出错啊.....
- 请大家推荐一些有名的,有用的,常去的.net C#,ASP.NET博客网站,我先推存二位,请看!!!
- 我用一下vs.net2005但是在vs.net200下建asp.net项目是在那里建?
- javascript 的问题
- 怎样使select 具有像onserverchange 直接运行!
- 新手求助
修改后的~不对啊~~Tppe=Search 是什么意思?看的不太明白?谁能给改一下~~
错误:
编译向该请求提供服务所需资源的过程中出现错误。请检查下列特定错误详细信息并适当地修改源代码。 编译器错误信息: CS1010: 常数中有换行符
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<%@ Page Language="C#" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %><HTML>
<HEAD>
<TITLE> 查询窗口 </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<Script Language="C#" runat="server">
void Search_Click(Object sender,EventArgs e)
{
//Response.Redirect("booklist.aspx?Type=Search&"SearchField="&ddlsearch.SelectedItem.Value+&"&SearchText="+Tel1.Text"");
// Response.Redirect("booklist.aspx?Type=Search&"&SearchField="+ddlsearch.SelecteItem.Value+"&SearchText="+Tel1.Text);
Response.Redirect("booklist.aspx?Type=Serarch&SearchField=" + ddlsearch.SelectedValue.ToString() + "&SerchText=" + Tel1.Text); }
</Script>
</HEAD><BODY>
<form runat="server">
<asp:DropDownList id="ddlsearch" runat="server">
<asp:ListItem Value="bookTitle" Selected="True">图书名</asp:ListItem>
<asp:ListItem Value="author">作者 </asp:ListItem>
<asp:ListItem Value="ISBN">编码号</asp:ListItem>
<asp:ListItem Value="keywords">关键字</asp:ListItem>
<asp:ListItem Value="description">图书简介</asp:ListItem>
</asp:DropDownList>
<p>
<asp:TextBox
id="Tel1"
Columns="25"
MaxLength="30"
runat="server"/>
<p>
<asp:Button id="butSerarch"
text="确定"
OnClick="Search_Click"
runat="server"
/></form>
</BODY>
</HTML>接收页面:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<%@ Page Language="C#" Debug="True" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<HTML>
<HEAD>
<TITLE> 显示 </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<Script Languge="C#" runat="server">
void Page_Load(Object sender,EventArgs e)
{
string Type = Request.QueryString["Type"];
string SerarchField= Request.QueryString["SearchField"];
string SerchText= Request.QueryString["SearchText"];
string myConnString=@"server=localhost;uid=sa;pwd= ;database=library";
string mySelectQuery = "SELECT * from books SerarchField like %SerchText% ";
SqlConnection myConnection=new SqlConnection(myConnString);
DataSet myDataSet = new DataSet();
SqlDataAdapter myAdapter;
myAdapter = new SqlDataAdapter(mySelectQuery, myConnection);
myAdapter.Fill(myDataSet, "books");
show.DataSource=myDataSet.Tables["books"].DefaultView;
show.DataBind();
}
</script>
</HEAD><BODY>
<form runat="server">
<asp:DataGrid id="show" runat="server"></asp:DataGrid></P>
</form>
</BODY>
</HTML>
就是这一句:string mySelectQuery = "SELECT * from books SerarchField like %SerchText% ";
要怎么写呢??????????
???
CodeBehind不好么?
string mySelectQuery = "SELECT * from books SerarchField like \'%"+ SerchText +"%\'";
”应用程序中的服务器错误。
--------------------------------------------------------------------------------在关键字 'like' 附近有语法错误。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 在关键字 'like' 附近有语法错误。源错误:
行 27: SqlDataAdapter myAdapter;
行 28: myAdapter = new SqlDataAdapter(mySelectQuery, myConnection);
行 29: myAdapter.Fill(myDataSet, "books");
行 30: show.DataSource=myDataSet.Tables["books"].DefaultView;
行 31: show.DataBind();
string mySelectQuery = "SELECT * from books where SerarchField like \'%"+ SerchText +"%\'";