{"id":128352,"date":"2023-05-04T16:53:54","date_gmt":"2023-05-04T11:23:54","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=128352"},"modified":"2024-04-12T14:15:25","modified_gmt":"2024-04-12T08:45:25","slug":"obtaining-a-parameter-from-a-session-variable","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/obtaining-a-parameter-from-a-session-variable\/","title":{"rendered":"Obtaining a Parameter from a Session Variable"},"content":{"rendered":"\n

Obtaining a Parameter from a Session Variable<\/strong><\/h4>\n\n\n\n

In ASP.NET, you can obtain a parameter from a Session variable by using the SessionParameter object in the SelectParameters collection of the SqlDataSource control. 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:SessionParameter Name=”CustomerID” SessionField=”CustomerId” Type=”String” \/><\/p>\n\n\n\n

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

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

Set the SessionField property of the SessionParameter object to the name of the Session variable that contains the value you want to use as the parameter:<\/p>\n\n\n\n

<asp:SessionParameter Name=”CustomerID” SessionField=”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 SessionField property of the SessionParameter object is set to “CustomerId”, which is the name of the Session variable that contains the value you want to use as the parameter.<\/p>\n\n\n\n

Assign a value to the Session variable in your code behind:<\/p>\n\n\n\n

Session[“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 Session variable as the value of the “CustomerID” parameter in the query. You can change the value of the Session variable at runtime, 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":"

Obtaining a Parameter from a Session Variable In ASP.NET, you can obtain a parameter from a Session variable by using the SessionParameter object in the SelectParameters collection of the SqlDataSource control. 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…<\/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-128352","page","type-page","status-publish","hentry","category-asp-net-2"],"acf":[],"yoast_head":"\nObtaining a Parameter from a Session Variable - Tutorial<\/title>\n<meta name=\"description\" content=\"Obtaining a Parameter from a Session Variable\" \/>\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\/obtaining-a-parameter-from-a-session-variable\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Obtaining a Parameter from a Session Variable - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Obtaining a Parameter from a Session Variable\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/obtaining-a-parameter-from-a-session-variable\/\" \/>\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\/obtaining-a-parameter-from-a-session-variable\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/obtaining-a-parameter-from-a-session-variable\/\",\"name\":\"Obtaining a Parameter from a Session Variable - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2023-05-04T11:23:54+00:00\",\"dateModified\":\"2024-04-12T08:45:25+00:00\",\"description\":\"Obtaining a Parameter from a Session Variable\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/obtaining-a-parameter-from-a-session-variable\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/obtaining-a-parameter-from-a-session-variable\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/obtaining-a-parameter-from-a-session-variable\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Obtaining a Parameter from a Session Variable\"}]},{\"@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":"Obtaining a Parameter from a Session Variable - Tutorial","description":"Obtaining a Parameter from a Session Variable","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\/obtaining-a-parameter-from-a-session-variable\/","og_locale":"en_US","og_type":"article","og_title":"Obtaining a Parameter from a Session Variable - Tutorial","og_description":"Obtaining a Parameter from a Session Variable","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/obtaining-a-parameter-from-a-session-variable\/","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\/obtaining-a-parameter-from-a-session-variable\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/obtaining-a-parameter-from-a-session-variable\/","name":"Obtaining a Parameter from a Session Variable - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2023-05-04T11:23:54+00:00","dateModified":"2024-04-12T08:45:25+00:00","description":"Obtaining a Parameter from a Session Variable","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/obtaining-a-parameter-from-a-session-variable\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/obtaining-a-parameter-from-a-session-variable\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/obtaining-a-parameter-from-a-session-variable\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Obtaining a Parameter from a Session Variable"}]},{"@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\/128352","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=128352"}],"version-history":[{"count":2,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128352\/revisions"}],"predecessor-version":[{"id":128357,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128352\/revisions\/128357"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=128352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=128352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=128352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}