{"id":45,"date":"2009-03-22T15:36:00","date_gmt":"1970-01-01T00:00:00","guid":{"rendered":"http:\/\/www.yazilimmutfagi.com\/?p=45"},"modified":"2009-03-22T15:36:00","modified_gmt":"1970-01-01T00:00:00","slug":"datalist-icindeki-bilgileri-gruplayarak-gostermek","status":"publish","type":"post","link":"https:\/\/www.yazilimmutfagi.com\/index.php\/2009\/03\/22\/datalist-icindeki-bilgileri-gruplayarak-gostermek\/","title":{"rendered":"Datalist I\u00e7indeki Bilgileri Gruplayarak G\u00f6stermek."},"content":{"rendered":"

Bu makalemizde datalist içine veritabanimizdan veri doldurmayi ve bu verileri gruplandirarak ekranda göstermeyi anlatacagim.<\/span><\/p>\n

Datalisti veritabanindan aldigimiz bilgilerle istedigimiz yapida doldurabiliriz. Ama bilgilerimiz farkli gruplara aitse ve bizde bu gruplara göre göstermek istiyorsak kullanabilecegimiz birkaç farkli yöntem var. Bir örnekle anlatirsak, elimizde bir ürüne ait özellikler var. Mesela cep telefonu için boyutu, rengi, hafizasi, pil türü, konusma süresi, zoom  <\/span>vs. vs. bu özelliklerin bir kismi genel özellikler, bir kismi güç özellikleri, kamera özellikler seklinde ayirabiliriz. Bu verileri datalistimizde gösterirken, özellikleri gruplarina göre ayirarak göstermek istiyoruz.  <\/span>Örnegimizde kullanacagimiz veritabani yapidi ve içindeki bilgiler asagidaki gibi olsun.<\/span><\/p>\n

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

Id<\/span><\/strong><\/p>\n <\/td>\n

\n

OzellikAdi<\/span><\/strong><\/p>\n <\/td>\n

\n

Deger<\/span><\/strong><\/p>\n <\/td>\n

\n

Grubu<\/span><\/strong><\/p>\n <\/td>\n <\/tr>\n

\n

1<\/span><\/p>\n <\/td>\n

\n

Renk<\/span><\/p>\n <\/td>\n

\n

Siyah<\/span><\/p>\n <\/td>\n

\n

Genel Özellikleri<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

2<\/span><\/p>\n <\/td>\n

\n

Ekran Tipi<\/span><\/p>\n <\/td>\n

\n

TFT<\/span><\/p>\n <\/td>\n

\n

Ekran Özellikleri<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

3<\/span><\/p>\n <\/td>\n

\n

Ekran Çözünürlügü<\/span><\/p>\n <\/td>\n

\n

240 x 320 Piksel<\/span><\/p>\n <\/td>\n

\n

Ekran Özellikleri<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

4<\/span><\/p>\n <\/td>\n

\n

Renk Çözünürlügü<\/span><\/p>\n <\/td>\n

\n

256K Renk<\/span><\/p>\n <\/td>\n

\n

Ekran Özellikleri<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

5<\/span><\/p>\n <\/td>\n

\n

Boyutlar<\/span><\/p>\n <\/td>\n

\n

95 x 47 x 14.3 mm<\/span><\/p>\n <\/td>\n

\n

Genel Özellikleri<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

6<\/span><\/p>\n <\/td>\n

\n

Telefon Tipi<\/span><\/p>\n <\/td>\n

\n

Kayan Kapakli<\/span><\/p>\n <\/td>\n

\n

Genel Özellikleri<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

7<\/span><\/p>\n <\/td>\n

\n

Entegre Kamera<\/span><\/p>\n <\/td>\n

\n

Var<\/span><\/p>\n <\/td>\n

\n

Kamera Özellikleri<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

8<\/span><\/p>\n <\/td>\n

\n

Kamera Zoom<\/span><\/p>\n <\/td>\n

\n

4x<\/span><\/p>\n <\/td>\n

\n

Kamera Özellikleri<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

9<\/span><\/p>\n <\/td>\n

\n

Entegre Flas<\/span><\/p>\n <\/td>\n

\n

Var<\/span><\/p>\n <\/td>\n

\n

Kamera Özellikleri<\/span><\/p>\n <\/td>\n <\/tr>\n <\/tbody>\n<\/table>\n

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

Visual Studio .Net i açip add new Project diyerek yeni bir proje açalim sonra  <\/span>bir datalist ekleyelim. Projemize ekledigimi datalisti asagidaki gibi düzenleyelim.
\n
\n<\/span><\/p>\n\n \n \n
\n

<<\/span>asp<\/span>:<\/span>DataList<\/span> ID<\/span>="MyDataList"<\/span> runat<\/span>="server"><\/span><\/span><\/p>\n

    <\/span><<\/span>HeaderTemplate<\/span>><\/span><\/span><\/p>\n

        <\/span><<\/span>table<\/span>><\/span><\/span><\/p>\n

    <\/span><\/<\/span>HeaderTemplate<\/span>><\/span><\/span><\/p>\n

    <\/span><<\/span>ItemTemplate<\/span>><\/span><\/span><\/p>\n

        <\/span><<\/span>tr<\/span>><\/span><\/span><\/p>\n

            <\/span><<\/span>td<\/span> colspan<\/span>="2"<\/span> style<\/span>="background-color: InactiveCaptionText"><\/span><\/span><\/p>\n

          <\/span>      <\/span><<\/span>asp<\/span>:<\/span>Label<\/span> ID<\/span>="Label1"<\/span> runat<\/span>="server"<\/span> Text<\/span>=’<\/span><%<\/span>#Bind("Grubu") %><\/span>‘><\/<\/span>asp<\/span>:<\/span>Label<\/span>><\/span><\/span><\/p>\n

            <\/span><\/<\/span>td<\/span>><\/span><\/span><\/p>\n

        <\/span><\/<\/span>tr<\/span>><\/span><\/span><\/p>\n

        <\/span><<\/span>tr<\/span>><\/span><\/span><\/p>\n

            <\/span><<\/span>td<\/span>><\/span><\/span><\/p>\n

                <\/span><<\/span>asp<\/span>:<\/span>Label<\/span> ID<\/span>="Label2"<\/span> runat<\/span>="server"<\/span> Text<\/span>=’<\/span><%<\/span>#Bind("OzellikAdi") %><\/span>‘><\/<\/span>asp<\/span>:<\/span>Label<\/span>><\/span><\/span><\/p>\n

           <\/span> <\/span><\/<\/span>td<\/span>><\/span><\/span><\/p>\n

            <\/span><<\/span>td<\/span>><\/span><\/span><\/p>\n

                <\/span><<\/span>asp<\/span>:<\/span>Label<\/span> ID<\/span>="Label3"<\/span> runat<\/span>="server"<\/span> Text<\/span>=’<\/span><%<\/span>#Bind("Deger") %><\/span>‘><\/<\/span>asp<\/span>:<\/span>Label<\/span>><\/span><\/span><\/p>\n

            <\/span><\/<\/span>td<\/span>><\/span><\/span><\/p>\n

        <\/span><\/<\/span>tr<\/span>><\/span><\/span><\/p>\n

    <\/span><\/<\/span>ItemTemplate<\/span>><\/span><\/span><\/p>\n

    <\/span><<\/span>FooterTemplate<\/span>><\/span><\/span><\/p>\n

        <\/span><\/<\/span>table<\/span>><\/span><\/span><\/p>\n

    <\/span><\/<\/span>FooterTemplate<\/span>><\/span><\/span><\/p>\n

<\/<\/span>asp<\/span>:<\/span>DataList<\/span>><\/span><\/p>\n <\/td>\n <\/tr>\n <\/tbody>\n<\/table>\n

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

Sayfamizin kod kismana asagidaki fonksitonu ekleyerek Page_Load kosminda çagiralim.<\/span><\/p>\n

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

public<\/span> void<\/span> VerileriDoldur1()<\/span><\/p>\n

{<\/span><\/p>\n

    <\/span>\/\/ veritabani baglantimiz<\/span><\/span><\/p>\n

    <\/span>SqlConnection<\/span> connection = new<\/span> SqlConnection<\/span>("Data Source=.\\\\sqlexpress;Initial Catalog=deneme;Integrated Security=True"<\/span>);<\/span><\/p>\n

    <\/span>connection.Open();<\/span><\/p>\n

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

    <\/span>\/\/verilrimizi tablodan çekelim<\/span><\/span><\/p>\n

    <\/span>SqlDataAdapter<\/span> da = new<\/span> SqlDataAdapter<\/span>("SELECT OzellikAdi,Deger,Grubu FROM Ozellikler order by Grubu "<\/span>, connection);<\/span><\/p>\n

    <\/span>da.SelectCommand.ExecuteNonQuery();<\/span><\/p>\n

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

    <\/span>\/\/datatable a atalim<\/span><\/span><\/p>\n

    <\/span>DataTable<\/span> dTable = new<\/span> DataTable<\/span>();<\/span><\/p>\n

    <\/span>da.Fill(dTable);<\/span><\/p>\n

    <\/span>MyDataList.DataSource = dTable.DefaultView;<\/span><\/p>\n

    <\/span>MyDataList.DataBind();<\/span><\/p>\n

}<\/span><\/p>\n <\/td>\n <\/tr>\n <\/tbody>\n<\/table>\n

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

Saydamizi yukaridaki gibi düzenleyip çalistirdigimizda ekran görüntümüz asagidaki gibi olur.<\/span><\/p>\n

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

 <\/p>\n

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

Yukarida dikkat edecek oursaniz her özellikten önce grup bilgisi yer aliyor. Biz Her grup altinda o gruba ait özellikleri göstermek istersek. Bunun için ilk yöntemimiz, datalistin içi dolarken ayni olan gruplari silmek. Bunun için item data bound içine asagidaki kodu yaziyoruz.<\/span><\/p>\n

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

protected<\/span> void<\/span> MyDataList_ItemDataBound(object<\/span> sender, DataListItemEventArgs<\/span> e)<\/span><\/p>\n

{<\/span><\/p>\n

    <\/span>if<\/span> (e.Item.ItemType == ListItemType<\/span>.AlternatingItem | e.Item.ItemType == ListItemType<\/span>.Item)<\/span><\/p>\n

    <\/span>{<\/span><\/p>\n

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

        <\/span>string<\/span> GrupAdi = ((Label<\/span>)(e.Item.FindControl("Grup"<\/span>))).Text;<\/span><\/p>\n

        <\/span>string<\/span> MevcutGrup = ""<\/span>;<\/span><\/p>\n

        <\/span>try<\/span><\/span><\/p>\n

        <\/span>{<\/span><\/p>\n

            <\/span>MevcutGrup = ViewState["Grup"<\/span>].ToString();<\/span><\/p>\n

        <\/span>}<\/span><\/p>\n

        <\/span>catch<\/span> (Exception<\/span>)<\/span><\/p>\n

        <\/span>{<\/span><\/p>\n

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

        <\/span>}<\/span><\/p>\n

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

        <\/span>if<\/span> (MevcutGrup == GrupAdi)<\/span><\/p>\n

        <\/span>{<\/span><\/p>\n

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

            <\/span>((Label<\/span>)(e.Item.FindControl("Grup"<\/span>))).Text = ""<\/span>;<\/span><\/p>\n

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

            <\/span>e.Item.Visible = false<\/span>;<\/span><\/p>\n

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

        <\/span>}<\/span><\/p>\n

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

        <\/span>else<\/span><\/span><\/p>\n

        <\/span>{<\/span><\/p>\n

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

            <\/span>MevcutGrup = GrupAdi;<\/span><\/p>\n

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

            <\/span>ViewState["Grup"<\/span>] = MevcutGrup;<\/span><\/p>\n

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

            <\/span>((Label<\/span>)(e.Item.FindControl("Grup"<\/span>))).Text = GrupAdi;<\/span><\/p>\n

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

            <\/span>e.Item.Visible = true<\/span>;<\/span><\/p>\n

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

        <\/span>}<\/span><\/p>\n

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

    <\/span>}<\/span><\/p>\n

}<\/span><\/p>\n <\/td>\n <\/tr>\n <\/tbody>\n<\/table>\n

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

Yukaridaki kodu yazdiktan sonra  <\/span>ekran görüntümüz asagidaki gibi oluyor.<\/span><\/p>\n

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

 <\/p>\n

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

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

Ayni islemi bir de iki datalist iç içe koyarak da yapabiliriz.ilk datalistimiz sadece grup adlarini, bunun içindeki datalistimizde o gruba ait özellikleri gösterecek. Ilk olarak Veritabanindan sadece grup adlarini çekip ilk dataliste atiyoruz. Ve datalistin item data bounduna o gruba ait özellikleri çekip atiyoruz<\/span><\/p>\n

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

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

public<\/span> void<\/span> VerileriDoldur2()<\/span><\/p>\n

{<\/span><\/p>\n

    <\/span>\/\/ veritabani baglantimiz<\/span><\/span><\/p>\n

    <\/span>SqlConnection<\/span> connection = new<\/span> SqlConnection<\/span>("Data Source=.\\\\sqlexpress;Initial Catalog=deneme;Integrated Security=True"<\/span>);<\/span><\/p>\n

    <\/span>connection.Open();<\/span><\/p>\n

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

    <\/span>\/\/gruplari tablodan çekelim<\/span><\/span><\/p>\n

    <\/span>SqlDataAdapter<\/span> da = new<\/span> SqlDataAdapter<\/span>("SELECT  <\/span>distinct Grubu FROM Ozellikler "<\/span>, connection);<\/span><\/p>\n

    <\/span>da.SelectCommand.ExecuteNonQuery();<\/span><\/p>\n

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

    <\/span>\/\/dataliste a atalim<\/span><\/span><\/p>\n

    <\/span>DataTable<\/span> dTable = new<\/span> DataTable<\/span>();<\/span><\/p>\n

    <\/span>da.Fill(dTable);<\/span><\/p>\n

    <\/span>GrupDataList.DataSource = dTable.DefaultView;<\/span><\/p>\n

    <\/span>GrupDataList.DataBind();<\/span><\/p>\n

}<\/span><\/p>\n

protected<\/span> void<\/span> GrupDataList_ItemDataBound(object<\/span> sender, DataListItemEventArgs<\/span> e)<\/span><\/p>\n

{<\/span><\/p>\n

    <\/span>if<\/span> (e.Item.ItemType == ListItemType<\/span>.AlternatingItem || e.Item.ItemType == ListItemType<\/span>.Item)<\/span><\/p>\n

    <\/span>{<\/span><\/p>\n

        <\/span>string<\/span> GrupAdi = ((Label<\/span>)(e.Item.FindControl("Grup"<\/span>))).Text;<\/span><\/p>\n

        <\/span>\/\/ veritabani baglantimiz<\/span><\/span><\/p>\n

        <\/span>SqlConnection<\/span> connection = new<\/span> SqlConnection<\/span>("Data Source=.\\\\sqlexpress;Initial Catalog=deneme;Integrated Security=True"<\/span>);<\/span><\/p>\n

        <\/span>connection.Open();<\/span><\/p>\n

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

        <\/span>\/\/gruba ait özellik ve degerleri tablodan çekelim<\/span><\/span><\/p>\n

        <\/span>SqlDataAdapter<\/span> da = new<\/span> SqlDataAdapter<\/span>("SELECT OzellikAdi,Deger  <\/span>FROM Ozellikler where Grubu=’"<\/span> + GrupAdi + "’ "<\/span>, connection);<\/span><\/p>\n

        <\/span>da.SelectCommand.ExecuteNonQuery();<\/span><\/p>\n

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

        <\/span>\/\/2.dataliste atalim <\/span><\/span><\/p>\n

        <\/span>DataTable<\/span> dTable = new<\/span> DataTable<\/span>();<\/span><\/p>\n

        <\/span>da.Fill(dTable);<\/span><\/p>\n

        <\/span>DataList<\/span> mylist = ((DataList<\/span>)(e.Item.FindControl("OzellikDataList"<\/span>)));<\/span><\/p>\n

        <\/span>mylist.DataSource = dTable.DefaultView;<\/span><\/p>\n

        <\/span>mylist.DataBind();<\/span><\/p>\n

    <\/span>}<\/span><\/p>\n

}<\/span><\/p>\n <\/td>\n <\/tr>\n <\/tbody>\n<\/table>\n

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

Ekran görüntümüz:<\/span><\/p>\n

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

Datalist içine doldurdugumuz verileri nasil gruplara ayirarak gösteririz.<\/p>\n","protected":false},"author":525,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[407],"tags":[4229,4330,4256,5261,5801,4520],"_links":{"self":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/45"}],"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\/525"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/comments?post=45"}],"version-history":[{"count":0,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/45\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/media?parent=45"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/categories?post=45"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/tags?post=45"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}