sqldatasourse 中的查询字符串值
我有以下工作正常：
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="test_library_newsletter_Default2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div style="font-family:Arial;">
<asp:gridview id="CustomersGridView"
datasourceid="CustomersSource"
autogeneratecolumns="false"
emptydatatext="No data available."
allowpaging="true"
runat="server"
ShowHeader="True"
GridLines="None"
CellPadding="10">
<Columns>
<asp:BoundField HeaderText="Date"
DataField="date"
dataformatstring="{0:dd-MM-yyyy}" />
<asp:HyperLinkField HeaderText="Subject"
DataTextField="subject"
DataNavigateUrlFields="id"
DataNavigateUrlFormatString="http://intranet/Default2.aspx?id={0}" />
</Columns>
<pagersettings mode="Numeric"
position="Bottom"
pagebuttoncount="10"/>
<HeaderStyle HorizontalAlign="Left" />
</asp:gridview>
<asp:sqldatasource id="CustomersSource"
selectcommand="select id, subject, date from table order by id desc"
connectionstring="connection string here"
runat="server"/>
</div>
</form>
</body>
</html>
但是，我想在 sql 语句中使用查询字符串值。我该怎么做？
I have the following which works fine:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="test_library_newsletter_Default2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div style="font-family:Arial;">
<asp:gridview id="CustomersGridView"
datasourceid="CustomersSource"
autogeneratecolumns="false"
emptydatatext="No data available."
allowpaging="true"
runat="server"
ShowHeader="True"
GridLines="None"
CellPadding="10">
<Columns>
<asp:BoundField HeaderText="Date"
DataField="date"
dataformatstring="{0:dd-MM-yyyy}" />
<asp:HyperLinkField HeaderText="Subject"
DataTextField="subject"
DataNavigateUrlFields="id"
DataNavigateUrlFormatString="http://intranet/Default2.aspx?id={0}" />
</Columns>
<pagersettings mode="Numeric"
position="Bottom"
pagebuttoncount="10"/>
<HeaderStyle HorizontalAlign="Left" />
</asp:gridview>
<asp:sqldatasource id="CustomersSource"
selectcommand="select id, subject, date from table order by id desc"
connectionstring="connection string here"
runat="server"/>
</div>
</form>
</body>
</html>
However, I want to use a querystring value in the sql statement. How do I do that?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
你需要这样的东西
阅读全文
https://web.archive.org/web/20211020150717/https://www.4guysfromrolla.com/articles/030106-1.aspx
希望有帮助。
you need something like this
Read full post at
https://web.archive.org/web/20211020150717/https://www.4guysfromrolla.com/articles/030106-1.aspx
Hope it helps.