<form id="form1" runat="server">
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/union/qwe.mdb"
SelectCommand="SELECT [keywords], [titlecontent] FROM [titlelist] WHERE ([keywords] LIKE '%' + ? + '%')">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="图片" Name="keywords" QueryStringField="tags"
Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="AccessDataSource1">
<Columns>
<asp:BoundField DataField="keywords" HeaderText="keywords" SortExpression="keywords" />
<asp:BoundField DataField="titlecontent" HeaderText="titlecontent" SortExpression="titlecontent" />
</Columns>
</asp:GridView>
</form>
我设置成这个样子参数还是传不过来哪位朋友能不能提供一个接收传递过来的参数作为数据库查询条件的方法
最好能给的详细些
因为我是刚刚接触asp.net
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/union/qwe.mdb"
SelectCommand="SELECT [keywords], [titlecontent] FROM [titlelist] WHERE ([keywords] LIKE '%' + ? + '%')">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="图片" Name="keywords" QueryStringField="tags"
Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="AccessDataSource1">
<Columns>
<asp:BoundField DataField="keywords" HeaderText="keywords" SortExpression="keywords" />
<asp:BoundField DataField="titlecontent" HeaderText="titlecontent" SortExpression="titlecontent" />
</Columns>
</asp:GridView>
</form>
我设置成这个样子参数还是传不过来哪位朋友能不能提供一个接收传递过来的参数作为数据库查询条件的方法
最好能给的详细些
因为我是刚刚接触asp.net
我现在把代码贴出来<%@ Page Language="C#" AutoEventWireup="true" CodeFile="CallPage.aspx.cs" Inherits="_Default" %>
<%@ OutputCache Duration="1" VaryByParam="tags;skinId" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<script runat="server">
void Page_Load(object sender, EventArgs e)
{
//设置仅将缓存数据存储在服务器上
Response.Cache.SetCacheability(HttpCacheability.Server);
}
//截取固定长度的字符串
public static string CutString(string inputString,int len)
{
ASCIIEncoding ascii = new ASCIIEncoding();
int tempLen=0;
string tempString="";
byte[] s = ascii.GetBytes(inputString);
for(int i=0;i<s.Length;i++)
{
if((int)s[i]==63)
{
tempLen+=2;
}
else
{
tempLen+=1;
}
try
{
tempString+=inputString.Substring(i,1);
}
catch
{
break;
}
if(tempLen>len)
break;
}
//如果截过则加上半个省略号
byte[] mybyte=System.Text.Encoding.Default.GetBytes(inputString);
if(mybyte.Length>len)
tempString+=""; return tempString;
}
</script>
<head id="Head1" runat="server">
</head>
<% //string mytags = Request.QueryString["tags"];
string mytags = "图片";
Label1.Text = "设置了缓存的时间:" + mytags;
%>
<body style="margin:0px;font-size: 12px;">
<form id="form1" runat="server"><div >
<table cellpadding="0" cellspacing="0" border="0" ><tr><td style="height:5px;"></td></tr></table>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="AccessDataSource1" CellPadding="0" Font-Size="Small" GridLines="None" Height="108px" ShowHeader="False" UseAccessibleHeader="False" Width="196px" >
<Columns><asp:TemplateField >
<ItemTemplate>
<tr><td width="5"><span class="tesu_h">·</span></td><td style="padding-top:2px;"><asp:HyperLink runat="server" ID="lnkCategory" CssClass="tesu_x" Target="_blank" NavigateUrl='<%# string.Format("~/union/turnpage.asp?page=&g={0},{1},{2}&url={3}", Eval("titleid"),Eval("unionid"),Request.QueryString["uid"],HttpUtility.UrlEncode(Eval("listurl").ToString(),Encoding.Default) ) %>' Text='<%# CutString( Eval("titlecontent").ToString() ,18) %>' /></td>
<td align="right"><a href="" class="tesu_x" title="<%# Eval("unionname")%>" ><%# CutString(Eval("unionname").ToString(), 7)%></a></td></tr>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<EditRowStyle Height="20px" />
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/union/qwe.mdb"
SelectCommand="SELECT top 10 titlelist.titlecontent,titlelist.listurl,titlelist.titleid,titlelist.unionid,unioninfo.unionname FROM [titlelist],[unioninfo] where titlelist.unionid=unioninfo.unionid and titlelist.keywords like '%'+ '<%# Console.Write("图片"); %>'+'%'"></asp:AccessDataSource>
</div>
<%Label2.Text = "设置了缓存的时间:" + Request.QueryString["tags"].ToString(); %>
<asp:Label ID="Label1" runat="server" CssClass="commonText"></asp:Label>
<asp:Label ID="Label2" runat="server" CssClass="commonText"></asp:Label>
</form>
</body>
</html>