{"id":142,"date":"2008-12-14T15:28:00","date_gmt":"1970-01-01T00:00:00","guid":{"rendered":"http:\/\/www.yazilimmutfagi.com\/?p=142"},"modified":"2008-12-14T15:28:00","modified_gmt":"1970-01-01T00:00:00","slug":"gridview-kontrolu-giris-i","status":"publish","type":"post","link":"https:\/\/www.yazilimmutfagi.com\/index.php\/2008\/12\/14\/gridview-kontrolu-giris-i\/","title":{"rendered":"GridView Kontrol\u00fc Giris – I"},"content":{"rendered":"

      Bu makalemizde ASP.NET kontrollerinden biri olan GridView kontrolü hakkinda bilgi verecegim. <\/span>GridView verilerimizi izgara formatinda görüntülememizi saglayan bir kontroldür. Visual Studio’nun eski sürümlerinde kullandigimiz ve hala desteklenen Repeater kontrolünün gelismisi olarak düsünebiliriz. Makalemizde datasource olarak SqlDataSource kullanacagiz. <\/span><\/span><\/p>\n

.<\/a><\/p>\n

      GridView kontrolü ve SqlDataSource Toolbox menüsünde data sekmesi altinda bulunmaktadir. Ilk olarak yeni bir web projesi açalim ve default.aspx sayfamiza sqldatasource ve GridView ekleyelim. Bu islemden sonra default.aspx sayfamizin asagidaki gibi olmasi gerekiyor. Isterseniz sürükle birak yöntemi yerine asagidakinin aynisiniz kendinizde yazabilirsiniz.  <\/span><\/span><\/p>\n

 .<\/p>\n

<<\/span>body<\/span>><\/span><\/p>\n

    <\/span><<\/span>form<\/span> id<\/span>="form1"<\/span> runat<\/span>="server"><\/span><\/span><\/p>\n

    <\/span><<\/span>div<\/span>><\/span><\/span><\/p>\n

        <\/span><<\/span>asp<\/span>:<\/span>SqlDataSource<\/span> ID<\/span>="SqlDataSource1"<\/span> runat<\/span>="server"><\/<\/span>asp<\/span>:<\/span>SqlDataSource<\/span>><\/span><\/span><\/p>\n

        <\/span><<\/span>asp<\/span>:<\/span>GridView<\/span> ID<\/span>="GridView1"<\/span> runat<\/span>="server"><\/span><\/span><\/p>\n

        <\/span><\/<\/span>asp<\/span>:<\/span>GridView<\/span>><\/span><\/span><\/p>\n

    <\/span><\/<\/span>div<\/span>><\/span><\/span><\/p>\n

    <\/span><\/<\/span>form<\/span>><\/span><\/span><\/p>\n

<\/<\/span>body<\/span>><\/span><\/p>\n

 Design moduna geçerek sqldatasource için veritabaninda bir baglanti yapalim.<\/span><\/p>\n

\"configure<\/span><\/p>\n

      Configure Data Source u tiklayin ve gelen ekranda new connection deyin. Asagidaki ekran da baglanmak istediginiz veritabani ayarlarini yapin.<\/span><\/p>\n

\n\n \n \n
\"Add<\/td>\n \n

 <\/p>\n

Ekranda Ok butonuna bastiktan sonra diger adimlari kendiniz tamamlayin. Islem sonunda SqlDataSource kodunuz seçtiginiz veritabanina göre asagidaki gibi olacaktir.<\/span><\/p>\n

<<\/span>asp<\/span>:<\/span>SqlDataSource<\/span> ID<\/span>="SqlDataSource1"<\/span> runat<\/span>="server"<\/span>           <\/span>ConnectionString<\/span>="<\/span><%<\/span>$ ConnectionStrings:OrnekConnectionString %><\/span>"<\/span> <\/span><\/p>\n

SelectCommand<\/span>="SELECT [No], [Ad], [Soyad], [TCKimlikNo], [Cinsiyet], [Numara], [DogumYeri] FROM [Kisi]"><\/<\/span>asp<\/span>:<\/span>SqlDataSource<\/span>><\/span><\/p>\n <\/td>\n <\/tr>\n <\/tbody>\n<\/table>\n<\/span><\/p>\n

 \"ChooseDataSource\"<\/span><\/p>\n

    Yukarda gördügünüz gibi Gridviewin data sourcenu ayarlayin. Gridview seçtiginiz datasource a göre kolonlarini kendisi otomatik olarak ayarlayacaktir. Bu islemler sonucunda aspx kodunuz asagidaki gibi olacaktir.<\/span><\/p>\n

 <\/p>\n

<<\/span>asp<\/span>:<\/span>GridView<\/span> ID<\/span>="OrnekGridView"<\/span> runat<\/span>="server"<\/span> AutoGenerateColumns<\/span>="False" <\/span><\/span>         <\/span>DataKeyNames<\/span>="No"<\/span> DataSourceID<\/span>="SqlDataSource1"><\/span><\/span><\/p>\n

<Columns<\/span>><\/span><\/span><\/p>\n

<<\/span>asp<\/span>:<\/span>BoundField<\/span> DataField<\/span>="No"<\/span> HeaderText<\/span>="No"<\/span> InsertVisible<\/span>="False"<\/span> <\/span>ReadOnly<\/span>="True"<\/span> SortExpression<\/span>="No"<\/span> \/><\/span><\/span><\/p>\n

<<\/span>asp<\/span>:<\/span>BoundField<\/span> DataField<\/span>="Ad"<\/span> HeaderText<\/span>="Ad"<\/span> SortExpression<\/span>="Ad"<\/span> \/><\/span><\/span><\/p>\n

<<\/span>asp<\/span>:<\/span>BoundField<\/span> DataField<\/span>="Soyad"<\/span> HeaderText<\/span>="Soyad"<\/span> SortExpression<\/span>="Soyad"<\/span> \/><\/span><\/span><\/p>\n

<<\/span>asp<\/span>:<\/span>BoundField<\/span> DataField<\/span>="TCKimlikNo"<\/span> HeaderText<\/span>="TCKimlikNo"<\/span> <\/span><\/p>\n

SortExpression<\/span>="TCKimlikNo"<\/span> \/><\/span><\/span><\/p>\n

<<\/span>asp<\/span>:<\/span>BoundField<\/span> DataField<\/span>="Cinsiyet"<\/span> HeaderText<\/span>="Cinsiyet"<\/span> <\/span><\/p>\n

SortExpression<\/span>="Cinsiyet"<\/span> \/><\/span><\/span><\/p>\n

<<\/span>asp<\/span>:<\/span>BoundField<\/span> DataField<\/span>="Numara"<\/span> HeaderText<\/span>="Numara"<\/span> <\/span><\/p>\n

SortExpression<\/span>="Numara"<\/span> \/><\/span><\/span><\/p>\n

<<\/span>asp<\/span>:<\/span>BoundField<\/span> DataField<\/span>="DogumYeri"<\/span> HeaderText<\/span>="DogumYeri"<\/span> <\/span><\/p>\n

SortExpression<\/span>="DogumYeri"<\/span> \/><\/span><\/span><\/p>\n

 <\/p>\n

<\/<\/span>Columns><\/span><\/span><\/p>\n

<\/<\/span>asp<\/span>:<\/span>GridView<\/span>><\/span><\/span><\/p>\n

 .<\/a><\/p>\n

    Promizi çalistirdigimiz zaman asagidaki görüntüyü elde edecegiz.<\/span><\/p>\n

\"\"<\/span><\/p>\n

Bu makalemizde çok basit olarak GridView kontrolünü isledik. Gridview ile ilgili detayli bilgiyi ilerki makalelerimizde anlatacagim.<\/span><\/p>\n

 <\/p>","protected":false},"excerpt":{"rendered":"

Bu makalemizde ASP.NET kontrollerinden biri olan GridView kontrolü hakkinda bilgi verecegim. GridView verilerimizi izgara formatinda görüntülememizi saglayan bir kontroldür. Visual Studio\u2019nun eski sürümlerinde kullandigimiz ve hala desteklenen Repeater kontrolünün gelismisi olarak düsünebiliriz.<\/p>\n","protected":false},"author":517,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[407],"tags":[5750,4443,5185,5674,4332,5083],"_links":{"self":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/142"}],"collection":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/users\/517"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/comments?post=142"}],"version-history":[{"count":0,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/142\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/media?parent=142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/categories?post=142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/tags?post=142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}