{"id":3234,"date":"2016-04-04T03:55:37","date_gmt":"2016-04-04T03:55:37","guid":{"rendered":"http:\/\/blog.jaringanhosting.com\/?p=3234"},"modified":"2016-04-04T03:55:37","modified_gmt":"2016-04-04T03:55:37","slug":"asp-net-hosting-indonesia-asp-net-mvc-data-binding-dengan-dapper","status":"publish","type":"post","link":"https:\/\/blog.jaringanhosting.com\/index.php\/asp-net-hosting-indonesia-asp-net-mvc-data-binding-dengan-dapper\/","title":{"rendered":"ASP.NET Hosting Indonesia &#8211; ASP.NET MVC Data Binding dengan Dapper"},"content":{"rendered":"<p>Pada controller tambahkan namespace berikut<\/p>\n<pre>using System.Web.Configuration;\r\nusing System.Data.SqlClient;\r\nusing Dapper;\r\nusing MvcLabs.Models;\r\nusing System.Data;<\/pre>\n<p>Pada action di controller tersebut, dimana kita akan menggunakan dapper, tambahkan kode berikut untuk melakukan data binding.<\/p>\n<pre>Pada action di controller tersebut, dimana kita akan menggunakan dapper, tambahkan kode berikut untuk melakukan data binding.\r\n\r\npublic ActionResult Index()\r\n{\r\n var connectionString = WebConfigurationManager.ConnectionStrings[\"ApplicationServices\"].ConnectionString;\r\n\r\n using (var connection = new SqlConnection(connectionString))\r\n {\r\n var result = connection.Query&lt;City&gt;(\"GetCities\", commandType: CommandType.StoredProcedure).ToList();\r\n\r\n return View(result);\r\n }\r\n}<\/pre>\n<p>&nbsp;<\/p>\n<p>Sehingga secara keseluruhan, controller yang baru saja kita buat menjadi seperti ini :<\/p>\n<pre>using System;\r\nusing System.Collections.Generic;\r\nusing System.Linq;\r\nusing System.Web;\r\nusing System.Web.Mvc;\r\nusing System.Web.Configuration;\r\nusing System.Data.SqlClient;\r\nusing Dapper;\r\nusing MvcLabs.Models;\r\nusing System.Data;\r\nnamespace MvcLabs.Controllers\r\n{\r\npublic class CityController : Controller\r\n{\r\n\/\/\r\n\/\/ GET: \/City\/\r\n\r\npublic ActionResult Index()\r\n{\r\nvar connectionString = WebConfigurationManager.ConnectionStrings[\"ApplicationServices\"].ConnectionString;\r\n\r\nusing (var connection = new SqlConnection(connectionString))\r\n{\r\nvar result = connection.Query&lt;City&gt;(\"GetCities\", commandType: CommandType.StoredProcedure).ToList();\r\n\r\nreturn View(result);\r\n}\r\n}\r\n\r\n}\r\n}\r\n\r\n<\/pre>\n<h2>Setelah selesai bekerja dengan controller, mari kita mulai untuk membuat view.<\/h2>\n<p>1. Klik kanan pada action index \u2013&gt; Add View<\/p>\n<p>2. Buat view dengan class\/model City.cs (Model ini harus sesuai dengan class\/model yang kita gunakan pada dapper di controller). Dengan temlpate List. Lebih jelasnya, kita dapat melihat gambar di bawah ini.<\/p>\n<p><img loading=\"lazy\" class=\"alignnone\" src=\"https:\/\/mfaisolriza.files.wordpress.com\/2014\/06\/listview.jpg?w=665&amp;h=601\" alt=\"\" width=\"486\" height=\"440\" \/><\/p>\n<p>Visual Studio akan membuat template view dengan gambar dibawah ini<\/p>\n<p><img loading=\"lazy\" class=\"alignnone\" src=\"https:\/\/mfaisolriza.files.wordpress.com\/2014\/06\/viewcode.jpg?w=665&amp;h=552\" alt=\"\" width=\"651\" height=\"541\" \/><\/p>\n<p>Untuk melihat hasilnya run project (F5), masuk ke controller City , contoh : http:\/\/localhost:54614\/City<\/p>\n<p>Data yang kita dapatkan akan ditampilkan seperti berikut ini :<\/p>\n<p><img loading=\"lazy\" class=\"alignnone\" src=\"https:\/\/mfaisolriza.files.wordpress.com\/2014\/06\/listui.jpg?w=665&amp;h=410\" alt=\"\" width=\"665\" height=\"411\" \/><\/p>\n<p>Selesai<\/p>\n<p>&nbsp;<br \/>\n<a href=\"http:\/\/jaringanhosting.com\/\"><img loading=\"lazy\" class=\"wp-image-3231 aligncenter\" src=\"http:\/\/blog.jaringanhosting.com\/wp-content\/uploads\/2016\/04\/^E53310598E83672F51C32C961DFE30F4C3B33A242CDC407495^pimgpsh_fullsize_distr.jpg\" alt=\"^E53310598E83672F51C32C961DFE30F4C3B33A242CDC407495^pimgpsh_fullsize_distr\" width=\"751\" height=\"278\" srcset=\"https:\/\/blog.jaringanhosting.com\/wp-content\/uploads\/2016\/04\/^E53310598E83672F51C32C961DFE30F4C3B33A242CDC407495^pimgpsh_fullsize_distr.jpg 851w, https:\/\/blog.jaringanhosting.com\/wp-content\/uploads\/2016\/04\/^E53310598E83672F51C32C961DFE30F4C3B33A242CDC407495^pimgpsh_fullsize_distr-300x111.jpg 300w\" sizes=\"(max-width: 751px) 100vw, 751px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/jaringanhosting.com\/\">JaringanHosting.com<\/a> adalah provider ASP.NET dan Windows hosting No #1 di Indonesia. Web Hosting kami mendapatkan Microsoft Spotlight Award dari Microsoft dan ini berdasarkan pada beberapa persyaratan utama, yaitu: WebMatrix, WebDeploy, Visual Studio 2015, ASP.NET 4.6, ASP.NET MVC 6, Silverlight 5 and Visual Studio Lightswitch.<\/p>\n<h2><\/h2>\n","protected":false},"excerpt":{"rendered":"<p>Pada controller tambahkan namespace berikut using System.Web.Configuration; using System.Data.SqlClient; using Dapper; using MvcLabs.Models; using System.Data; Pada action di controller tersebut, dimana kita akan menggunakan dapper, tambahkan kode berikut untuk melakukan data binding. Pada action di controller tersebut, dimana kita akan<\/p>\n","protected":false},"author":10337,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/blog.jaringanhosting.com\/index.php\/wp-json\/wp\/v2\/posts\/3234"}],"collection":[{"href":"https:\/\/blog.jaringanhosting.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.jaringanhosting.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.jaringanhosting.com\/index.php\/wp-json\/wp\/v2\/users\/10337"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.jaringanhosting.com\/index.php\/wp-json\/wp\/v2\/comments?post=3234"}],"version-history":[{"count":0,"href":"https:\/\/blog.jaringanhosting.com\/index.php\/wp-json\/wp\/v2\/posts\/3234\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.jaringanhosting.com\/index.php\/wp-json\/wp\/v2\/media?parent=3234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.jaringanhosting.com\/index.php\/wp-json\/wp\/v2\/categories?post=3234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.jaringanhosting.com\/index.php\/wp-json\/wp\/v2\/tags?post=3234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}