QueryStringParameter 建構函式

定義

初始化 QueryStringParameter 類別的新執行個體。

多載

名稱 Description
QueryStringParameter()

初始化 QueryStringParameter 類別的新未命名實例。

QueryStringParameter(QueryStringParameter)

使用 QueryStringParameter 參數所指定的實例值,初始化 original 類別的新實例。

QueryStringParameter(String, String)

使用指定的字串來識別要系結至的查詢字串字位,初始化 QueryStringParameter 類別的新具名實例。

QueryStringParameter(String, DbType, String)

使用指定的查詢字串字位和 參數的數據類型,初始化 QueryStringParameter 類別的新具名實例。

QueryStringParameter(String, TypeCode, String)

使用指定的字串來識別要系結的查詢字串字位,初始化 QueryStringParameter 類別的新具名和強型別實例。

QueryStringParameter()

初始化 QueryStringParameter 類別的新未命名實例。

public:
 QueryStringParameter();
public QueryStringParameter();
Public Sub New ()

範例

以下範例展示了如何使用 QueryStringParameter 建構子建立新 QueryStringParameter 參數並將其加入 SelectParameters 控制項的集合 AccessDataSource

QueryStringParameter empIdParam = new QueryStringParameter();
empIdParam.Name = "empId";
empIdParam.QueryStringField = "empId";

AccessDataSource1.SelectParameters.Add(empIdParam);
Dim empIdParam As New QueryStringParameter()
empIdParam.Name = "empId"
empIdParam.QueryStringField = "empId"

AccessDataSource1.SelectParameters.Add(empIdParam)

QueryStringParameter 物件會被加入 AccessDataSource 控制項,並在 ASP.NET 網頁中宣告。 ListBox控制項會利用控制AccessDataSource項綁定並顯示頁面,當頁面請求包含已命名empId欄位且有相應值的查詢字串時。

<asp:ListBox
  id ="ListBox2"
  runat="server"
  DataSourceID="AccessDataSource1"
  DataValueField="EmployeeID"
  DataTextField="LastName" />

<asp:AccessDataSource
  id="AccessDataSource1"
  runat="server"
  DataFile="Northwind.mdb"
  SelectCommand="Select EmployeeID, LastName From Employees where EmployeeID = ?" />
<asp:ListBox
  id ="ListBox2"
  runat="server"
  DataSourceID="AccessDataSource1"
  DataValueField="EmployeeID"
  DataTextField="LastName" />

<asp:AccessDataSource
  id="AccessDataSource1"
  runat="server"
  DataFile="Northwind.mdb"
  SelectCommand="Select EmployeeID, LastName From Employees where EmployeeID = ?" />

備註

QueryStringParameter使用QueryStringParameter建構子建立的物件會以所有屬性的預設值初始化。 屬性初始化如下:

適用於

QueryStringParameter(QueryStringParameter)

使用 QueryStringParameter 參數所指定的實例值,初始化 original 類別的新實例。

protected:
 QueryStringParameter(System::Web::UI::WebControls::QueryStringParameter ^ original);
protected QueryStringParameter(System.Web.UI.WebControls.QueryStringParameter original);
new System.Web.UI.WebControls.QueryStringParameter : System.Web.UI.WebControls.QueryStringParameter -> System.Web.UI.WebControls.QueryStringParameter
Protected Sub New (original As QueryStringParameter)

參數

original
QueryStringParameter

一個 QueryStringParameter 初始化目前實例的實例。

備註

QueryStringParameter建構子是一種受保護的複製建構器,用於克隆實QueryStringParameter例。 這些 、 NameType 屬性的值QueryStringField會轉移到新的實例。

另請參閱

適用於

QueryStringParameter(String, String)

使用指定的字串來識別要系結至的查詢字串字位,初始化 QueryStringParameter 類別的新具名實例。

public:
 QueryStringParameter(System::String ^ name, System::String ^ queryStringField);
public QueryStringParameter(string name, string queryStringField);
new System.Web.UI.WebControls.QueryStringParameter : string * string -> System.Web.UI.WebControls.QueryStringParameter
Public Sub New (name As String, queryStringField As String)

參數

name
String

參數的名稱。

queryStringField
String

參數物件所綁定的查詢字串欄位名稱。 預設為空字串(“”)。

範例

以下範例展示如何利用QueryStringParameter建構子建立兩個QueryStringParameter物件,並將其加入AccessDataSource控制項的SelectParameters集合中。 GridView如果employee請求中傳遞了 和 country 查詢字串欄位,且值是否有效,控制項會顯示資料。

<%@ Page language="C#"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">
private void Page_Load(object sender, System.EventArgs e)
{
    MyAccessDataSource.SelectParameters.Add(new QueryStringParameter("employee", "employee"));
    MyAccessDataSource.SelectParameters.Add(new QueryStringParameter("country",  "country"));
}
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
  <head runat="server">
    <title>ASP.NET Example</title>
</head>
<body>
    <form id="Form1" method="post" runat="server">

      <!-- Use a Query String that includes employee=1&country=USA -->
      <asp:gridview
        id ="GridView1"
        runat="server"
        datasourceid="MyAccessDataSource" />

<!-- Security Note: The AccessDataSource uses a QueryStringParameter,
     Security Note: which does not perform validation of input from the client.
     Security Note: To validate the value of the QueryStringParameter, handle the Selecting event. -->

      <asp:accessdatasource
        id="MyAccessDataSource"
        runat="server"
        datafile="Northwind.mdb"
        selectcommand="SELECT EmployeeID, LastName, FirstName 
                       FROM Employees
                       WHERE EmployeeID = ? AND Country = ?">
      </asp:accessdatasource>

    </form>
  </body>
</html>
<%@ Page language="VB"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">
Private Sub Page_Load(sender As Object, e As EventArgs)
    Dim param1 As New QueryStringParameter("employee", "employee")
    MyAccessDataSource.SelectParameters.Add(param1)

    Dim param2 As New QueryStringParameter("country", "country")
    MyAccessDataSource.SelectParameters.Add(param2)
End Sub ' Page_Load
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
  <head runat="server">
    <title>ASP.NET Example</title>
</head>
<body>
    <form id="Form1" method="post" runat="server">

      <!-- Use a Query String that includes employee=1&country=USA -->
      <asp:gridview
        id ="GridView1"
        runat="server"
        datasourceid="MyAccessDataSource" />

<!-- Security Note: The SqlDataSource uses a QueryStringParameter,
     Security Note: which does not perform validation of input from the client.
     Security Note: To validate the value of the QueryStringParameter, handle the Selecting event. -->

      <asp:accessdatasource
        id="MyAccessDataSource"
        runat="server"
        datafile="Northwind.mdb"
        selectcommand="SELECT EmployeeID, LastName, FirstName
                       FROM Employees
                       WHERE EmployeeID = ? AND Country = ? ">
      </asp:accessdatasource>
    </form>
  </body>
</html>

備註

QueryStringParameter使用QueryStringParameter建構子建立的物件會以指定的參數名稱初始化,該名稱用以識別該參數綁定的查詢字串欄位。 TypeDirection 屬性以預設值初始化。

另請參閱

適用於

QueryStringParameter(String, DbType, String)

使用指定的查詢字串字位和 參數的數據類型,初始化 QueryStringParameter 類別的新具名實例。

public:
 QueryStringParameter(System::String ^ name, System::Data::DbType dbType, System::String ^ queryStringField);
public QueryStringParameter(string name, System.Data.DbType dbType, string queryStringField);
new System.Web.UI.WebControls.QueryStringParameter : string * System.Data.DbType * string -> System.Web.UI.WebControls.QueryStringParameter
Public Sub New (name As String, dbType As DbType, queryStringField As String)

參數

name
String

參數的名稱。

dbType
DbType

參數的數據類型。

queryStringField
String

參數物件所綁定的查詢字串欄位名稱。 預設為空字串(“”)。

適用於

QueryStringParameter(String, TypeCode, String)

使用指定的字串來識別要系結的查詢字串字位,初始化 QueryStringParameter 類別的新具名和強型別實例。

public:
 QueryStringParameter(System::String ^ name, TypeCode type, System::String ^ queryStringField);
public QueryStringParameter(string name, TypeCode type, string queryStringField);
new System.Web.UI.WebControls.QueryStringParameter : string * TypeCode * string -> System.Web.UI.WebControls.QueryStringParameter
Public Sub New (name As String, type As TypeCode, queryStringField As String)

參數

name
String

參數的名稱。

type
TypeCode

參數所代表的類型。 預設值為 Object

queryStringField
String

參數物件所綁定的查詢字串欄位名稱。 預設為空字串(“”)。

範例

以下範例展示了如何利用QueryStringParameter建構子建立QueryStringParameter物件並將其加入AccessDataSource控制項FilterParameters集合。 GridView如果employee請求中傳遞了 和 country 查詢字串欄位,且值是否有效,控制項會顯示資料。

<%@ Page language="C#"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">
private void Page_Load(object sender, System.EventArgs e)
{
  QueryStringParameter countryFilter =
    new QueryStringParameter("country", TypeCode.String, "country");

  MyAccessDataSource.FilterParameters.Add(countryFilter);
}
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
  <head runat="server">
    <title>ASP.NET Example</title>
</head>
<body>
    <form id="Form1" method="post" runat="server">

      <!-- Use a Query String with country=USA -->
      <asp:gridview
        id ="GridView1"
        runat="server"
        datasourceid="MyAccessDataSource" />

<!-- Security Note: The AccessDataSource uses a QueryStringParameter,
     Security Note: which does not perform validation of input from the client.
     Security Note: To validate the value of the QueryStringParameter, handle the Selecting event. -->

      <asp:accessdatasource
        id="MyAccessDataSource"
        runat="server"
        datafile="Northwind.mdb"
        selectcommand="SELECT EmployeeID, LastName, Address, PostalCode, Country FROM Employees"
        filterexpression="Country = '{0}'">
      </asp:accessdatasource>
    </form>
  </body>
</html>
<%@ Page language="VB"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">
Private Sub Page_Load(sender As Object, e As EventArgs)
  Dim countryFilter As QueryStringParameter
  countryFilter = New QueryStringParameter("country", TypeCode.String, "country")
  MyAccessDataSource.FilterParameters.Add(countryFilter)
End Sub ' Page_Load
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
  <head runat="server">
    <title>ASP.NET Example</title>
</head>
<body>
    <form id="Form1" method="post" runat="server">

      <!-- Use a Query String with country=USA -->
      <asp:gridview
        id ="GridView1"
        runat="server"
        datasourceid="MyAccessDataSource" />

<!-- Security Note: The AccessDataSource uses a QueryStringParameter,
     Security Note: which does not perform validation of input from the client.
     Security Note: To validate the value of the QueryStringParameter, handle the Selecting event. -->

      <asp:accessdatasource
        id="MyAccessDataSource"
        runat="server"
        datafile="Northwind.mdb"
        selectcommand="SELECT EmployeeID, LastName, Address, PostalCode, Country FROM Employees"
        filterexpression="Country = '{0}'">
      </asp:accessdatasource>
    </form>
  </body>
</html>

備註

QueryStringParameter使用QueryStringParameter建構子建立的物件會以指定的參數名稱、參數類型,以及一個識別該參數綁定的查詢字串欄位的字串初始化。 DirectionConvertEmptyStringToNull 屬性以預設值初始化。

另請參閱

適用於