{"id":128361,"date":"2023-05-04T16:58:47","date_gmt":"2023-05-04T11:28:47","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=128361"},"modified":"2024-04-12T14:15:25","modified_gmt":"2024-04-12T08:45:25","slug":"passing-a-parameter-on-a-query-string","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/passing-a-parameter-on-a-query-string\/","title":{"rendered":"Passing a Parameter on a query string"},"content":{"rendered":"\n

Passing a Parameter on a query string<\/strong><\/h4>\n\n\n\n

In ASP.NET, you can pass a parameter to a SqlDataSource control on a query string. Here are the steps:<\/p>\n\n\n\n

Define a parameter in your markup, for example:<\/p>\n\n\n\n

<asp:SqlDataSource ID=”SqlDataSource1″ runat=”server” ConnectionString=”<%$ ConnectionStrings:NorthwindConnectionString %>”<\/p>\n\n\n\n

     SelectCommand=”SELECT * FROM Orders WHERE CustomerID = @CustomerID”><\/p>\n\n\n\n

     <SelectParameters><\/p>\n\n\n\n

         <asp:QueryStringParameter Name=”CustomerID” QueryStringField=”CustomerId” Type=”String” \/><\/p>\n\n\n\n

     <\/SelectParameters><\/p>\n\n\n\n

<\/asp:SqlDataSource><\/p>\n\n\n\n

Set the QueryStringField property of the QueryStringParameter object to the name of the query string variable that contains the value you want to use as the parameter:<\/p>\n\n\n\n

<asp:QueryStringParameter Name=”CustomerID” QueryStringField=”CustomerId” Type=”String” \/><\/p>\n\n\n\n

In this example, the Name property of the parameter is set to “CustomerID”, which is the name of the parameter in the SQL query. The QueryStringField property of the QueryStringParameter object is set to “CustomerId”, which is the name of the query string variable that contains the value you want to use as the parameter.<\/p>\n\n\n\n

Add the parameter to the URL of the page that contains the SqlDataSource control:<\/p>\n\n\n\n

http:\/\/localhost\/mypage.aspx?CustomerId=ALFKI<\/p>\n\n\n\n

Run your application to see the results. Now, when the SqlDataSource control is executed, it will use the value of the query string variable as the value of the “CustomerID” parameter in the query. You can change the value of the query string variable in the URL, and the SqlDataSource control will use the new value as the value of the parameter.<\/p>\n\n\n\n

Apply for ASP.NET Certification Now!!<\/h3>\n\n\n\n

https:\/\/www.vskills.in\/certification\/certified-aspnet-programmer<\/a><\/p>\n\n\n\n

Back to Tutorial<\/a><\/strong><\/h4>\n","protected":false},"excerpt":{"rendered":"

Passing a Parameter on a query string In ASP.NET, you can pass a parameter to a SqlDataSource control on a query string. Here are the steps: Define a parameter in your markup, for example: <asp:SqlDataSource ID=”SqlDataSource1″ runat=”server” ConnectionString=”<%$ ConnectionStrings:NorthwindConnectionString %>”      SelectCommand=”SELECT * FROM Orders WHERE CustomerID = @CustomerID”>      <SelectParameters>          <asp:QueryStringParameter Name=”CustomerID” QueryStringField=”CustomerId”…<\/p>\n","protected":false},"author":22,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[3339],"tags":[],"class_list":["post-128361","page","type-page","status-publish","hentry","category-asp-net-2"],"acf":[],"yoast_head":"\nPassing a Parameter on a query string - Tutorial<\/title>\n<meta name=\"description\" content=\"Passing a Parameter on a query string\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/passing-a-parameter-on-a-query-string\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Passing a Parameter on a query string - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Passing a Parameter on a query string\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/passing-a-parameter-on-a-query-string\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:45:25+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/passing-a-parameter-on-a-query-string\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/passing-a-parameter-on-a-query-string\/\",\"name\":\"Passing a Parameter on a query string - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2023-05-04T11:28:47+00:00\",\"dateModified\":\"2024-04-12T08:45:25+00:00\",\"description\":\"Passing a Parameter on a query string\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/passing-a-parameter-on-a-query-string\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/passing-a-parameter-on-a-query-string\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/passing-a-parameter-on-a-query-string\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Passing a Parameter on a query string\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Passing a Parameter on a query string - Tutorial","description":"Passing a Parameter on a query string","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/passing-a-parameter-on-a-query-string\/","og_locale":"en_US","og_type":"article","og_title":"Passing a Parameter on a query string - Tutorial","og_description":"Passing a Parameter on a query string","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/passing-a-parameter-on-a-query-string\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:45:25+00:00","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/passing-a-parameter-on-a-query-string\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/passing-a-parameter-on-a-query-string\/","name":"Passing a Parameter on a query string - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2023-05-04T11:28:47+00:00","dateModified":"2024-04-12T08:45:25+00:00","description":"Passing a Parameter on a query string","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/passing-a-parameter-on-a-query-string\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/passing-a-parameter-on-a-query-string\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/passing-a-parameter-on-a-query-string\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Passing a Parameter on a query string"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=128361"}],"version-history":[{"count":2,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128361\/revisions"}],"predecessor-version":[{"id":128364,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128361\/revisions\/128364"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=128361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=128361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=128361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}