{"id":30508,"date":"2023-01-15T08:56:57","date_gmt":"2023-01-15T03:26:57","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/"},"modified":"2023-01-15T08:56:57","modified_gmt":"2023-01-15T03:26:57","slug":"solved-what-does-mean-this-code-in-c-sharp-c-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/","title":{"rendered":"[Solved] what does mean this code in c sharp c# [closed]"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

I’m guessing you’re getting something along the lines of “there is already an open reader associated with the current connection”, yes? If so, see the second part of the answer.<\/p>\n

\n
\n

this what i dont understand<\/p>\n

CustomerDS custDB = new CustomerDS();\ncustDB.Clear();\nadap.Fill(custDB, \"Customers\"); \n<\/code><\/pre>\n<\/blockquote>\n
The first line is trivial, and simply creates a new empty instance of what looks to be a “typed dataset”, that has something to do with customers<\/em>. The main thing this line tells me is that somebody is still, for whatever reason, using DataSet<\/code>. Have mercy on them – they know not what they do.<\/p>\n
The second line does what it sounds like; see intellisense:<\/p>\n
\n
Clears the System.Data.DataSet of any data by removing all rows in all tables.<\/p>\n<\/blockquote>\n
The main thing this line tells me is that whoever wrote it has forgotten that they only just created it<\/em>, and that it doesn’t contain any data yet.<\/p>\n
The third line uses a data adapter<\/em> to populate custDB<\/code> with the data from a table called “Customers” (HOWEVER! the code earlier instructed it to use a very specific select command, which actually looks at a table called “admin”).<\/p>\n
\n
If we instead look at the code marked \/\/ here is error<\/code>…<\/p>\n
MySqlCommand cmd = mysqlclass.connection.CreateCommand();\ncmd.CommandText = \"SELECT * FROM admin \";\nmysqlclass.connection.Open();\nMySqlDataAdapter adap = new MySqlDataAdapter(cmd);\nMySqlDataReader dataReader = cmd.ExecuteReader();\n<\/code><\/pre>\n
This executes a SQL query to obtain all values from a table called “admin”, via the reader<\/em> API (a forewards-only stream of row data), but then completely ignores that reader. It doesn’t use it anywhere. Most notably, it also doesn’t consume<\/em> the data, nor dispose the reader. The main thing this tells me is that the author has lost track of what they were doing. That open reader will cause problems. Delete the line:<\/p>\n
MySqlDataReader dataReader = cmd.ExecuteReader();\n<\/code><\/pre>\n
Also: look into the using<\/code> statement.<\/p>\n<\/p><\/div>\n
<\/div>\n<\/div>\n
            4<\/span> <\/p><\/div>\n<\/div>\n
[ad_2]<\/p>\n
solved what does mean this code in c sharp c# [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"
[ad_1] I’m guessing you’re getting something along the lines of “there is already an open reader associated with the current connection”, yes? If so, see the second part of the answer. this what i dont understand CustomerDS custDB = new CustomerDS(); custDB.Clear(); adap.Fill(custDB, “Customers”); The first line is trivial, and simply creates a new empty … 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":[324,1041,340],"class_list":["post-30508","post","type-post","status-publish","format-standard","hentry","category-solved","tag-c","tag-crystal-reports","tag-mysql"],"yoast_head":"\n[Solved] what does mean this code in c sharp c# [closed] - 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-what-does-mean-this-code-in-c-sharp-c-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] what does mean this code in c sharp c# [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] I’m guessing you’re getting something along the lines of “there is already an open reader associated with the current connection”, yes? If so, see the second part of the answer. this what i dont understand CustomerDS custDB = new CustomerDS(); custDB.Clear(); adap.Fill(custDB, "Customers"); The first line is trivial, and simply creates a new empty ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-15T03:26:57+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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] what does mean this code in c sharp c# [closed]\",\"datePublished\":\"2023-01-15T03:26:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/\"},\"wordCount\":296,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"c++\",\"crystal-reports\",\"mysql\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/\",\"name\":\"[Solved] what does mean this code in c sharp c# [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2023-01-15T03:26:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] what does mean this code in c sharp c# [closed]\"}]},{\"@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] what does mean this code in c sharp c# [closed] - 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-what-does-mean-this-code-in-c-sharp-c-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] what does mean this code in c sharp c# [closed] - JassWeb","og_description":"[ad_1] I’m guessing you’re getting something along the lines of “there is already an open reader associated with the current connection”, yes? If so, see the second part of the answer. this what i dont understand CustomerDS custDB = new CustomerDS(); custDB.Clear(); adap.Fill(custDB, \"Customers\"); The first line is trivial, and simply creates a new empty ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/","og_site_name":"JassWeb","article_published_time":"2023-01-15T03:26:57+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] what does mean this code in c sharp c# [closed]","datePublished":"2023-01-15T03:26:57+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/"},"wordCount":296,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["c++","crystal-reports","mysql"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/","name":"[Solved] what does mean this code in c sharp c# [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2023-01-15T03:26:57+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-what-does-mean-this-code-in-c-sharp-c-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] what does mean this code in c sharp c# [closed]"}]},{"@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\/30508","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=30508"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/30508\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=30508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=30508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=30508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}