{"id":1667,"date":"2024-12-12T22:49:48","date_gmt":"2024-12-12T22:49:48","guid":{"rendered":"https:\/\/davidlennuk23.thkit.ee\/wp\/?page_id=1667"},"modified":"2024-12-12T23:10:18","modified_gmt":"2024-12-12T23:10:18","slug":"asp-net-ab","status":"publish","type":"page","link":"https:\/\/davidlennuk23.thkit.ee\/wp\/asp-net-ab\/","title":{"rendered":"ASP.Net + AB"},"content":{"rendered":"\n<p><strong>Loome andmebaasi<\/strong> <strong>SQL<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nCREATE DATABASE Kaubad\nUSE Kaubad\n\nCREATE TABLE kaubagrupid( \n id INT NOT NULL identity(1,1) PRIMARY KEY, \n grupinimi VARCHAR(255) \n);\n \nINSERT INTO kaubagrupid(grupinimi) VALUES (&#039;tellised&#039;); \nINSERT INTO kaubagrupid(grupinimi) VALUES (&#039;katusematerjal&#039;);\n \nCREATE TABLE kaubad( \n id INT NOT NULL identity(1,1)  PRIMARY KEY, \n nimetus VARCHAR(255), \n kaubagrupi_id INT, \n hind DECIMAL(10, 2)\n foreign key (kaubagrupi_id) references kaubagrupid(id)\n);\n \nINSERT INTO kaubad (nimetus, kaubagrupi_id, hind) VALUES (&#039;ahjutellis&#039;, 1, 8.20); \nINSERT INTO kaubad (nimetus, kaubagrupi_id, hind) VALUES (&#039;fassaaditellis&#039;, 1, 7.50); \nINSERT INTO kaubad (nimetus, kaubagrupi_id, hind) VALUES (&#039;bituumenrull&#039;, 2, 520);\n<\/pre><\/div>\n\n\n<p><strong>Kontrollime<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT nimetus, grupinimi, hind \nFROM kaubad, kaubagrupid \nWHERE kaubad.kaubagrupi_id=kaubagrupid.id; \n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"243\" height=\"81\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image.png\" alt=\"\" class=\"wp-image-1670\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image.png 243w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-150x50.png 150w\" sizes=\"auto, (max-width: 243px) 100vw, 243px\" \/><\/figure>\n\n\n\n<p><strong>View sees otsime\u00a0Server Explorer<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"308\" height=\"22\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-1.png\" alt=\"\" class=\"wp-image-1671\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-1.png 308w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-1-300x21.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-1-150x11.png 150w\" sizes=\"auto, (max-width: 308px) 100vw, 308px\" \/><\/figure>\n\n\n\n<p><strong>Connect to Database<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"209\" height=\"82\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-2.png\" alt=\"\" class=\"wp-image-1672\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-2.png 209w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-2-150x59.png 150w\" sizes=\"auto, (max-width: 209px) 100vw, 209px\" \/><\/figure>\n\n\n\n<p><strong>Siin vaatame, et on\u00a0Data sourse\u00a0sees on\u00a0Microsoft SQL Server (SqlClient)<br>Server name sees on\u00a0(localdb)\\mssqllocaldb<br>Connect to a database\u00a0sees valime\u00a0Select or enter a database name<br>Sinna valime v\u00f5i kirjutame\u00a0kaubad<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"546\" height=\"688\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-3.png\" alt=\"\" class=\"wp-image-1673\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-3.png 546w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-3-238x300.png 238w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-3-119x150.png 119w\" sizes=\"auto, (max-width: 546px) 100vw, 546px\" \/><\/figure>\n\n\n\n<p><strong>Test Connection<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"226\" height=\"143\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-4.png\" alt=\"\" class=\"wp-image-1674\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-4.png 226w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-4-150x95.png 150w\" sizes=\"auto, (max-width: 226px) 100vw, 226px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"190\" height=\"242\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-5.png\" alt=\"\" class=\"wp-image-1675\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-5.png 190w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-5-118x150.png 118w\" sizes=\"auto, (max-width: 190px) 100vw, 190px\" \/><\/figure>\n\n\n\n<p><strong>Parem click\u00a0kaubad<\/strong><\/p>\n\n\n\n<p><strong>Liiguta tabeli kaubad\u00a0about.aspx\u00a0faili\u00a0design\u00a0sisse<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"525\" height=\"381\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-6.png\" alt=\"\" class=\"wp-image-1676\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-6.png 525w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-6-300x218.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-6-150x109.png 150w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/figure>\n\n\n\n<p><strong>Valime\u00a0Configure Data Source<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"728\" height=\"587\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-7.png\" alt=\"\" class=\"wp-image-1677\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-7.png 728w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-7-300x242.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-7-150x121.png 150w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-7-600x484.png 600w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/figure>\n\n\n\n<p>Next-><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"724\" height=\"588\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-8.png\" alt=\"\" class=\"wp-image-1678\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-8.png 724w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-8-300x244.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-8-150x122.png 150w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-8-600x487.png 600w\" sizes=\"auto, (max-width: 724px) 100vw, 724px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"726\" height=\"590\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-9.png\" alt=\"\" class=\"wp-image-1679\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-9.png 726w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-9-300x244.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-9-150x122.png 150w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-9-600x488.png 600w\" sizes=\"auto, (max-width: 726px) 100vw, 726px\" \/><\/figure>\n\n\n\n<p><strong>Query builder<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"755\" height=\"808\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-10.png\" alt=\"\" class=\"wp-image-1680\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-10.png 755w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-10-280x300.png 280w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-10-140x150.png 140w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-10-600x642.png 600w\" sizes=\"auto, (max-width: 755px) 100vw, 755px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"793\" height=\"523\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-11.png\" alt=\"\" class=\"wp-image-1681\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-11.png 793w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-11-300x198.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-11-768x507.png 768w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-11-150x99.png 150w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-11-600x396.png 600w\" sizes=\"auto, (max-width: 793px) 100vw, 793px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"664\" height=\"492\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-12.png\" alt=\"\" class=\"wp-image-1682\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-12.png 664w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-12-300x222.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-12-150x111.png 150w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-12-600x445.png 600w\" sizes=\"auto, (max-width: 664px) 100vw, 664px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"639\" height=\"403\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-13.png\" alt=\"\" class=\"wp-image-1683\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-13.png 639w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-13-300x189.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-13-150x95.png 150w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-13-600x378.png 600w\" sizes=\"auto, (max-width: 639px) 100vw, 639px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"365\" height=\"163\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-14.png\" alt=\"\" class=\"wp-image-1684\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-14.png 365w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-14-300x134.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-14-150x67.png 150w\" sizes=\"auto, (max-width: 365px) 100vw, 365px\" \/><\/figure>\n\n\n\n<p><strong>Jah<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"445\" height=\"377\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-15.png\" alt=\"\" class=\"wp-image-1685\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-15.png 445w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-15-300x254.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-15-150x127.png 150w\" sizes=\"auto, (max-width: 445px) 100vw, 445px\" \/><\/figure>\n\n\n\n<p><strong>Auto Format<\/strong> (\u0432\u044b\u0431\u0435\u0440\u0438\u0442\u0435 \u043b\u044e\u0431\u043e\u0439 \u0444\u043e\u0440\u043c\u0430\u0442 \u0442\u0430\u0431\u043b\u0438\u0446\u044b)<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"462\" height=\"233\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-16.png\" alt=\"\" class=\"wp-image-1686\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-16.png 462w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-16-300x151.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-16-150x76.png 150w\" sizes=\"auto, (max-width: 462px) 100vw, 462px\" \/><\/figure>\n\n\n\n<p><strong>Result:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"847\" height=\"307\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-17.png\" alt=\"\" class=\"wp-image-1687\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-17.png 847w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-17-300x109.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-17-768x278.png 768w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-17-150x54.png 150w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-17-600x217.png 600w\" sizes=\"auto, (max-width: 847px) 100vw, 847px\" \/><\/figure>\n\n\n\n<p><strong>DropDownList<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"645\" height=\"470\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-18.png\" alt=\"\" class=\"wp-image-1688\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-18.png 645w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-18-300x219.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-18-150x109.png 150w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-18-600x437.png 600w\" sizes=\"auto, (max-width: 645px) 100vw, 645px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"655\" height=\"519\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-19.png\" alt=\"\" class=\"wp-image-1689\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-19.png 655w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-19-300x238.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-19-150x119.png 150w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-19-600x475.png 600w\" sizes=\"auto, (max-width: 655px) 100vw, 655px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"603\" height=\"283\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-20.png\" alt=\"\" class=\"wp-image-1690\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-20.png 603w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-20-300x141.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-20-150x70.png 150w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-20-600x282.png 600w\" sizes=\"auto, (max-width: 603px) 100vw, 603px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"651\" height=\"527\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-21.png\" alt=\"\" class=\"wp-image-1691\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-21.png 651w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-21-300x243.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-21-150x121.png 150w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-21-600x486.png 600w\" sizes=\"auto, (max-width: 651px) 100vw, 651px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"378\" height=\"279\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-22.png\" alt=\"\" class=\"wp-image-1692\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-22.png 378w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-22-300x221.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-22-150x111.png 150w\" sizes=\"auto, (max-width: 378px) 100vw, 378px\" \/><\/figure>\n\n\n\n<p><strong>Kus on DetailsView DefaultMode INSERT<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"236\" height=\"591\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-23.png\" alt=\"\" class=\"wp-image-1693\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-23.png 236w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-23-120x300.png 120w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-23-60x150.png 60w\" sizes=\"auto, (max-width: 236px) 100vw, 236px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"244\" height=\"30\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-24.png\" alt=\"\" class=\"wp-image-1694\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-24.png 244w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-24-150x18.png 150w\" sizes=\"auto, (max-width: 244px) 100vw, 244px\" \/><\/figure>\n\n\n\n<p><strong>Pane DropDownList tabelise(Ripploend)<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"398\" height=\"212\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-25.png\" alt=\"\" class=\"wp-image-1696\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-25.png 398w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-25-300x160.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-25-150x80.png 150w\" sizes=\"auto, (max-width: 398px) 100vw, 398px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"649\" height=\"473\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-26.png\" alt=\"\" class=\"wp-image-1698\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-26.png 649w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-26-300x219.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-26-150x109.png 150w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-26-600x437.png 600w\" sizes=\"auto, (max-width: 649px) 100vw, 649px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"652\" height=\"527\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-27.png\" alt=\"\" class=\"wp-image-1699\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-27.png 652w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-27-300x242.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-27-150x121.png 150w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-27-600x485.png 600w\" sizes=\"auto, (max-width: 652px) 100vw, 652px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"653\" height=\"615\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-28.png\" alt=\"\" class=\"wp-image-1700\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-28.png 653w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-28-300x283.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-28-150x141.png 150w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-28-600x565.png 600w\" sizes=\"auto, (max-width: 653px) 100vw, 653px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"644\" height=\"522\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-29.png\" alt=\"\" class=\"wp-image-1701\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-29.png 644w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-29-300x243.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-29-150x122.png 150w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-29-600x486.png 600w\" sizes=\"auto, (max-width: 644px) 100vw, 644px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"644\" height=\"472\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-30.png\" alt=\"\" class=\"wp-image-1702\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-30.png 644w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-30-300x220.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-30-150x110.png 150w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-30-600x440.png 600w\" sizes=\"auto, (max-width: 644px) 100vw, 644px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"853\" height=\"368\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-31.png\" alt=\"\" class=\"wp-image-1703\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-31.png 853w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-31-300x129.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-31-768x331.png 768w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-31-150x65.png 150w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-31-600x259.png 600w\" sizes=\"auto, (max-width: 853px) 100vw, 853px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"343\" height=\"187\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-32.png\" alt=\"\" class=\"wp-image-1704\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-32.png 343w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-32-300x164.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-32-150x82.png 150w\" sizes=\"auto, (max-width: 343px) 100vw, 343px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"491\" height=\"266\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-34.png\" alt=\"\" class=\"wp-image-1706\" style=\"width:367px;height:auto\" srcset=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-34.png 491w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-34-300x163.png 300w, https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image-34-150x81.png 150w\" sizes=\"auto, (max-width: 491px) 100vw, 491px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Loome andmebaasi SQL Kontrollime View sees otsime\u00a0Server Explorer Connect to Database Siin vaatame, et on\u00a0Data sourse\u00a0sees on\u00a0Microsoft SQL Server (SqlClient)Server name sees on\u00a0(localdb)\\mssqllocaldbConnect to a database\u00a0sees valime\u00a0Select or enter a database nameSinna valime v\u00f5i kirjutame\u00a0kaubad Test Connection Parem click\u00a0kaubad Liiguta tabeli kaubad\u00a0about.aspx\u00a0faili\u00a0design\u00a0sisse Valime\u00a0Configure Data Source Next-> Query builder Jah Auto Format (\u0432\u044b\u0431\u0435\u0440\u0438\u0442\u0435 \u043b\u044e\u0431\u043e\u0439 \u0444\u043e\u0440\u043c\u0430\u0442 \u0442\u0430\u0431\u043b\u0438\u0446\u044b)&hellip; <a class=\"more-link\" href=\"https:\/\/davidlennuk23.thkit.ee\/wp\/asp-net-ab\/\">Continue reading <span class=\"screen-reader-text\">ASP.Net + AB<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1667","page","type-page","status-publish","hentry","entry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>ASP.Net + AB - David Lennuk &otilde;pimapp | portfoolio<\/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:\/\/davidlennuk23.thkit.ee\/wp\/asp-net-ab\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ASP.Net + AB - David Lennuk &otilde;pimapp | portfoolio\" \/>\n<meta property=\"og:description\" content=\"Loome andmebaasi SQL Kontrollime View sees otsime\u00a0Server Explorer Connect to Database Siin vaatame, et on\u00a0Data sourse\u00a0sees on\u00a0Microsoft SQL Server (SqlClient)Server name sees on\u00a0(localdb)mssqllocaldbConnect to a database\u00a0sees valime\u00a0Select or enter a database nameSinna valime v\u00f5i kirjutame\u00a0kaubad Test Connection Parem click\u00a0kaubad Liiguta tabeli kaubad\u00a0about.aspx\u00a0faili\u00a0design\u00a0sisse Valime\u00a0Configure Data Source Next-&gt; Query builder Jah Auto Format (\u0432\u044b\u0431\u0435\u0440\u0438\u0442\u0435 \u043b\u044e\u0431\u043e\u0439 \u0444\u043e\u0440\u043c\u0430\u0442 \u0442\u0430\u0431\u043b\u0438\u0446\u044b)&hellip; Continue reading ASP.Net + AB\" \/>\n<meta property=\"og:url\" content=\"https:\/\/davidlennuk23.thkit.ee\/wp\/asp-net-ab\/\" \/>\n<meta property=\"og:site_name\" content=\"David Lennuk &otilde;pimapp | portfoolio\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-12T23:10:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image.png\" \/>\n\t<meta property=\"og:image:width\" content=\"243\" \/>\n\t<meta property=\"og:image:height\" content=\"81\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"8 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/asp-net-ab\\\/\",\"url\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/asp-net-ab\\\/\",\"name\":\"ASP.Net + AB - David Lennuk &otilde;pimapp | portfoolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/asp-net-ab\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/asp-net-ab\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/image.png\",\"datePublished\":\"2024-12-12T22:49:48+00:00\",\"dateModified\":\"2024-12-12T23:10:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/asp-net-ab\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/asp-net-ab\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/asp-net-ab\\\/#primaryimage\",\"url\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/image.png\",\"contentUrl\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/image.png\",\"width\":243,\"height\":81},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/asp-net-ab\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ASP.Net + AB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/\",\"name\":\"David Lennuk &otilde;pimapp | portfoolio\",\"description\":\"Noorem Tarkvaraarendaja eriala\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ASP.Net + AB - David Lennuk &otilde;pimapp | portfoolio","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:\/\/davidlennuk23.thkit.ee\/wp\/asp-net-ab\/","og_locale":"et_EE","og_type":"article","og_title":"ASP.Net + AB - David Lennuk &otilde;pimapp | portfoolio","og_description":"Loome andmebaasi SQL Kontrollime View sees otsime\u00a0Server Explorer Connect to Database Siin vaatame, et on\u00a0Data sourse\u00a0sees on\u00a0Microsoft SQL Server (SqlClient)Server name sees on\u00a0(localdb)mssqllocaldbConnect to a database\u00a0sees valime\u00a0Select or enter a database nameSinna valime v\u00f5i kirjutame\u00a0kaubad Test Connection Parem click\u00a0kaubad Liiguta tabeli kaubad\u00a0about.aspx\u00a0faili\u00a0design\u00a0sisse Valime\u00a0Configure Data Source Next-> Query builder Jah Auto Format (\u0432\u044b\u0431\u0435\u0440\u0438\u0442\u0435 \u043b\u044e\u0431\u043e\u0439 \u0444\u043e\u0440\u043c\u0430\u0442 \u0442\u0430\u0431\u043b\u0438\u0446\u044b)&hellip; Continue reading ASP.Net + AB","og_url":"https:\/\/davidlennuk23.thkit.ee\/wp\/asp-net-ab\/","og_site_name":"David Lennuk &otilde;pimapp | portfoolio","article_modified_time":"2024-12-12T23:10:18+00:00","og_image":[{"width":243,"height":81,"url":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"8 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/asp-net-ab\/","url":"https:\/\/davidlennuk23.thkit.ee\/wp\/asp-net-ab\/","name":"ASP.Net + AB - David Lennuk &otilde;pimapp | portfoolio","isPartOf":{"@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/asp-net-ab\/#primaryimage"},"image":{"@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/asp-net-ab\/#primaryimage"},"thumbnailUrl":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image.png","datePublished":"2024-12-12T22:49:48+00:00","dateModified":"2024-12-12T23:10:18+00:00","breadcrumb":{"@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/asp-net-ab\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/davidlennuk23.thkit.ee\/wp\/asp-net-ab\/"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/asp-net-ab\/#primaryimage","url":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image.png","contentUrl":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/12\/image.png","width":243,"height":81},{"@type":"BreadcrumbList","@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/asp-net-ab\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/davidlennuk23.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"ASP.Net + AB"}]},{"@type":"WebSite","@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/#website","url":"https:\/\/davidlennuk23.thkit.ee\/wp\/","name":"David Lennuk &otilde;pimapp | portfoolio","description":"Noorem Tarkvaraarendaja eriala","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/davidlennuk23.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1667","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-json\/wp\/v2\/comments?post=1667"}],"version-history":[{"count":3,"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1667\/revisions"}],"predecessor-version":[{"id":1707,"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1667\/revisions\/1707"}],"wp:attachment":[{"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-json\/wp\/v2\/media?parent=1667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}