{"id":4741,"date":"2022-08-24T05:09:52","date_gmt":"2022-08-23T23:39:52","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/"},"modified":"2022-08-24T05:09:52","modified_gmt":"2022-08-23T23:39:52","slug":"solved-how-to-pass-parameters-to-sqldataadapter","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/","title":{"rendered":"[Solved] How to pass parameters to SqlDataAdapter"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-24023670\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"24023670\" data-parentid=\"24023575\" data-score=\"8\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>here is an example of what you can use and how to pass Parameters<br \/>\nyou have to make the changes where necessary <\/p>\n<pre class=\"lang-vb prettyprint-override\"><code>Public Shared Function GetCustomerInfo(stardate As DateTime, enddate As DateTime, Department As String, Active as String, Visits as Int33) As List(Of String)\n    Dim cszList = New List(Of String)()\n    Dim DSCityStateZipLookup As New DataSet()\n    'load the List one time to be used thru out the intire application\n    Dim ConnString = System.Configuration.ConfigurationManager.ConnectionStrings(\"CMSConnectionString\").ConnectionString\n    Using connStr As New SqlConnection(ConnString)\n        Using cmd As New SqlCommand(\"your Stored Proc name goes here\", connStr)\n            cmd.Parameters.AddWithValue(\"@stardate\", stardate)\/\/make sure you assign a value to startdate\n            cmd.Parameters.AddWithValue(\"@enddate\", enddate)\/\/make sure you assign a value to enddate\n            cmd.Parameters.AddWithValue(\"@Deparment\", Deparment)\/\/make sure you assign a value to \/\/Department\n            cmd.Parameters.AddWithValue(\"@Active\", Active)\/\/make sure you assign a value to Active\n            cmd.Parameters.AddWithValue(\"@Visits\", Visits)\/\/make sure you assign a value to Visits\n            cmd.Connection.Open()\n            New SqlDataAdapter(cmd).Fill(DSCityStateZipLookup)\n            'If we get a record back from the above stored procedure call, that in itself means the information the user provided from\n            'the UI is in the database. On the other hand, if we do not get a record back from the stored procedure call, we should\n            'simply advise the user that the information they provided does not exist in the database, and to double check their spelling.\n            If DSCityStateZipLookup.Tables.Count = 0 OrElse (DSCityStateZipLookup.Tables.Count &gt; 0 AndAlso DSCityStateZipLookup.Tables(0).Rows.Count = 0) Then\n                cszList.Add(\"Your Error Message goes here if any.\")\n            End If\n        End Using\n    End Using\n    Return cszList\nEnd Function\n<\/code><\/pre>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">12<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved How to pass parameters to SqlDataAdapter <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] here is an example of what you can use and how to pass Parameters you have to make the changes where necessary Public Shared Function GetCustomerInfo(stardate As DateTime, enddate As DateTime, Department As String, Active as String, Visits as Int33) As List(Of String) Dim cszList = New List(Of String)() Dim DSCityStateZipLookup As New DataSet() &#8230; <a title=\"[Solved] How to pass parameters to SqlDataAdapter\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/\" aria-label=\"More on [Solved] How to pass parameters to SqlDataAdapter\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[341,1044,1045,353],"class_list":["post-4741","post","type-post","status-publish","format-standard","hentry","category-solved","tag-sql","tag-sqlconnection","tag-sqldataadapter","tag-vb-net"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] How to pass parameters to SqlDataAdapter - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] How to pass parameters to SqlDataAdapter - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] here is an example of what you can use and how to pass Parameters you have to make the changes where necessary Public Shared Function GetCustomerInfo(stardate As DateTime, enddate As DateTime, Department As String, Active as String, Visits as Int33) As List(Of String) Dim cszList = New List(Of String)() Dim DSCityStateZipLookup As New DataSet() ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-23T23:39:52+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] How to pass parameters to SqlDataAdapter\",\"datePublished\":\"2022-08-23T23:39:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/\"},\"wordCount\":38,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"sql\",\"sqlconnection\",\"sqldataadapter\",\"vb.net\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/\",\"name\":\"[Solved] How to pass parameters to SqlDataAdapter - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-08-23T23:39:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] How to pass parameters to SqlDataAdapter\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] How to pass parameters to SqlDataAdapter - JassWeb","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:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] How to pass parameters to SqlDataAdapter - JassWeb","og_description":"[ad_1] here is an example of what you can use and how to pass Parameters you have to make the changes where necessary Public Shared Function GetCustomerInfo(stardate As DateTime, enddate As DateTime, Department As String, Active as String, Visits as Int33) As List(Of String) Dim cszList = New List(Of String)() Dim DSCityStateZipLookup As New DataSet() ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/","og_site_name":"JassWeb","article_published_time":"2022-08-23T23:39:52+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] How to pass parameters to SqlDataAdapter","datePublished":"2022-08-23T23:39:52+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/"},"wordCount":38,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["sql","sqlconnection","sqldataadapter","vb.net"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/","url":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/","name":"[Solved] How to pass parameters to SqlDataAdapter - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-08-23T23:39:52+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-parameters-to-sqldataadapter\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] How to pass parameters to SqlDataAdapter"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/4741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=4741"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/4741\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=4741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=4741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=4741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}