{"id":107,"date":"2008-12-30T07:52:00","date_gmt":"1970-01-01T00:00:00","guid":{"rendered":"http:\/\/www.yazilimmutfagi.com\/?p=107"},"modified":"2008-12-30T07:52:00","modified_gmt":"1970-01-01T00:00:00","slug":"gridview-icindeki-verileri-excele-aktarmak","status":"publish","type":"post","link":"https:\/\/www.yazilimmutfagi.com\/index.php\/2008\/12\/30\/gridview-icindeki-verileri-excele-aktarmak\/","title":{"rendered":"GridView i\u00e7indeki verileri Excel’e Aktarmak"},"content":{"rendered":"

GridView ASP.Net’te sik olarak kullandigimiz ve gerçekten isimizi kolaylastiran bir bilesendir. Eminim çogunuzun grid üzerindeki verileri bir Excel sayfasina aktarmaya ihtiyaci olmustur. Bu makalemizde grid içerisindeki verileri bir Excel dosyasina nasil aktaracagimizi anlatacagim.<\/span><\/p>\n

aspx ve aspx.cs dosyalarini indirmek için tiklayin<\/a><\/p>\n

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

GridView den Excel’e Veri Aktarma<\/span><\/span><\/strong><\/p>\n

Aslinda grid den excel’e veri aktarma oldukça kolay bir istir. Basit bir örnekle bunu nasil gerçeklestirecegimize bakacagiz. Makalemizde örnek olarak Microsoft tarafindan ücretsiz olarak sunulan AdventureWorksDW2008 veritabanini kullanacagim.  <\/span><\/span><\/span><\/p>\n

Ilk olarak yeni bir solution içinde web sitesi olusturup ExceleAktarForm.aspx adinda bir webform ekleyelim. Daha önceki makalelerimizde bir gridviewi nasil bind edecegimizi anlatmistik, bu yüzden bu konulari bildiginizi varsayarak geçecegim. Gelelim nasil yapacagimiza<\/span><\/p>\n

ExceleAktarForm .aspx sayfamizi asagidaki gibi düzenleyelim.<\/span><\/p>\n

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

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

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

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

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

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

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

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

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

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

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

    <\/span>SelectCommand<\/span>="SELECT TOP 20 [FirstName], [LastName], [BirthDate], [EmailAddress], [AddressLine1] FROM [DimCustomer]"><\/span><\/span><\/p>\n

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

<<\/span>asp<\/span>:<\/span>LinkButton<\/span> ID<\/span>="ExceleAktarLinkButton"<\/span> runat<\/span>="server"<\/span> OnClick<\/span>="ExceleAktarLinkButton_Click"><\/span>Excele Aktar<\/<\/span>asp<\/span>:<\/span>LinkButton<\/span>><\/span><\/span><\/p>\n

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

ExceleAktarForm .aspx.cs içerisinde <\/span>ExceleAktarLinkButton <\/span>tiklandigi zaman çalisacak olan eventi asagidaki gibi düzenleyelim.<\/span><\/p>\n

protected<\/span> void<\/span> ExceleAktarLinkButton_Click(object<\/span> sender, EventArgs<\/span> e)<\/span><\/p>\n

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

    <\/span>Response.Clear();<\/span><\/p>\n

    <\/span>Response.AddHeader("content-disposition"<\/span>, "attachment;filename=FileName.xls"<\/span>);<\/span><\/p>\n

    <\/span>Response.Charset = ""<\/span>;<\/span><\/p>\n

    <\/span>Response.Cache.SetCacheability(HttpCacheability<\/span>.NoCache);<\/span><\/p>\n

    <\/span>Response.ContentType = "application\/vnd.xls"<\/span>;<\/span><\/p>\n

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

    <\/span>System.IO.StringWriter<\/span> stringWrite = new<\/span> System.IO.StringWriter<\/span>();<\/span><\/p>\n

    <\/span>System.Web.UI.HtmlTextWriter<\/span> htmlWrite = new<\/span> HtmlTextWriter<\/span>(stringWrite);<\/span><\/p>\n

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

    <\/span>form1.Controls.Clear();<\/span><\/p>\n

    <\/span>form1.Controls.Add(MusteriGridView);<\/span><\/p>\n

    <\/span>form1.RenderControl(htmlWrite);<\/span><\/p>\n

    <\/span>Response.Write(stringWrite.ToString());<\/span><\/p>\n

    <\/span>Response.End();<\/span><\/p>\n

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

Yukarida ki koda dikkat ederseniz RenderControl fonksiyonunu gridview için degil form için kullandik, bunun sebebine gelince; ASP.NET 1.1 de kullandigimiz DataGrid bileseninde excel’e aktarmak için datagridAdi.RenderControl kullaniyorduk fakat Asp.NET 2.0 dan sonra gelen GridView kontrolünde RenderControl özelligini kullandigimizda hata aliriz. Bu yüzden sayfamizda kullandigimiz form nesnesini kullaniyoruz. Gelelim diger kisimlarin açiklamasina;<\/span><\/p>\n

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

Projemizi çalistirip Excel’e Aktar butonuna bastigimizda Excel dosyasinin olusturuldugunu göreceksiniz.<\/span><\/p>\n

 <\/p>\n

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

Gördügünüz gibi bir gridview içindeki verileri Excel’e aktarmak oldukça basit bir islem. Bir sonraki makalemizde de grid içerisindeki verileri Word ortamina atmaya deginecegiz.<\/span><\/p>","protected":false},"excerpt":{"rendered":"

GridView ASP.Net\u2019te sik olarak kullandigimiz ve gerçekten isimizi kolaylastiran bir bilesendir. Eminim çogunuzun grid üzerindeki verileri bir Excel sayfasina aktarmaya ihtiyaci olmustur. Bu makalemizde grid içerisindeki verileri bir Excel dosyasina nasil aktaracagimizi anlatacagim.<\/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":[5651,4469,5056,4304,5211],"_links":{"self":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/107"}],"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=107"}],"version-history":[{"count":0,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/107\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/media?parent=107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/categories?post=107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/tags?post=107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}