Export your data to Excel file with JS

5 Haz 2011 Author: Admin In:

Repeater üzerindeki verilerinizi Excel dosyasına JS ile aktarma işlemi

  <script type='text/javascript'>
         var tableToExcel = (function () {
             var uri = 'data:application/vnd.ms-excel;base64,'
                , template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--> <meta charset="utf-8"></head><body><table>{table}</table></body></html>'
                , base64 = function (s) { return window.btoa(unescape(encodeURIComponent(s))) }
                , format = function (s, c) { return s.replace(/{(\w+)}/g, function (m, p) { return c[p]; }) }
             return function (table, name) {
                 if (!table.nodeType) table = document.getElementById(table)
                 var ctx = { worksheet: name || 'Worksheet', table: table.innerHTML }
                 window.location.href = uri + base64(format(template, ctx))
             }
         })()
    </script>

  ----------------

    <h2>Rapor</h2><span style="float:right;margin-right:3px;right:0"><input type="button" class="btn btn-warning" onclick="tableToExcel('ContentPlaceHolder1_dtg_rapor', 'Raporumuz')" value="Excel'e Aktar"></span>

 

 

 

----------------------- export table to excel v2 -----------------

 

 

        function ExportToExcel(tableid,wsadi,dsadi) {
            var tab_text = "<table border='2px'><tr bgcolor='#87AFC6'>";
            var textRange; var j = 0;
            tab = document.getElementById(tableid);//.getElementsByTagName('table'); // id of table

            if (tab == null) {
                return false;
            }

            if (tab.rows.length == 0) {
                return false;
            }

            for (j = 0 ; j < tab.rows.length ; j++) {
                tab_text = tab_text + tab.rows[j].innerHTML + "</tr>";//tab_text=tab_text+"</tr>";
            }

            tab_text = tab_text + "</table>";
            tab_text = tab_text.replace(/<A[^>]*>|<\/A>/g, "");//remove if u want links in your table
            tab_text = tab_text.replace(/<img[^>]*>/gi, ""); // remove if u want images in your table
            tab_text = tab_text.replace(/<input[^>]*>|<\/input>/gi, ""); // reomves input params
            tab_text = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>' + wsadi + '</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--> <meta charset="utf-8"></head><body>' + tab_text + '</body></html>';

            var ua = window.navigator.userAgent;
            var msie = ua.indexOf("MSIE ");

            if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./))      // If Internet Explorer
            {
                txtArea1.document.open("txt/html", "replace");
                txtArea1.document.write(tab_text);
                txtArea1.document.close();
                txtArea1.focus();
                sa = txtArea1.document.execCommand("SaveAs", true, dsadi+".xls");
            }
            else {
                //other browser not tested on IE 11
                //sa = window.open('data:application/vnd.ms-excel,' + encodeURIComponent(tab_text));
                try {
                    var blob = new Blob([tab_text], { type: "application/vnd.ms-excel" });
                    window.URL = window.URL || window.webkitURL;
                    link = window.URL.createObjectURL(blob);
                    a = document.createElement("a");
                    a.download = dsadi;
                    a.href = link;
                    document.body.appendChild(a);
                    a.click();
                    document.body.removeChild(a);
                } catch (e) {
                }
            }
            return false;
            //return (sa);
        }

 

 

 

 

GridView to Ecxel

18 May 2011 Author: Admin In: .net, ipucu

Master page içinde kullanılacaksa

ilk olarak  EnableEventValidation="false"

Daha Sonra 

    public override void VerifyRenderingInServerForm(Control control)
    {
        if (control.ID != "GridView2")
            base.VerifyRenderingInServerForm(control);
    } 

 

    protected void lbtn_excele_Click(object sender, EventArgs e)
    {
        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
        Response.Charset = "windows-1254";;
        Response.Cache.SetCacheability(HttpCacheability.NoCache);
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
        Response.ContentType = "application/vnd.xls";

        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
        dtg_liste.RenderControl(htmlWrite);
        Response.Write(stringWrite.ToString());
        Response.End();
    } 

 

 

Türkçe karakter sorunu yaşıyorsanız :

            StringWriter sw = new StringWriter();
            HtmlTextWriter htw = new HtmlTextWriter(sw);
            dtg_DersiAlanlar.RenderControl(htw);

            Response.Clear();
            Response.ClearHeaders();
            Response.ClearContent();

            Response.Cache.SetCacheability(HttpCacheability.NoCache);
            Response.ContentEncoding = System.Text.Encoding.GetEncoding("windows-1254");

            Response.Charset = "windows-1254";
            Response.Buffer = true;

            this.EnableViewState = false;
            Response.ContentType = "application/vnd.xls";

            Response.AddHeader("content-disposition", "attachment;filename=" + lbl_dersadi.ToolTip.Trim() + "_" + ddl_budersialanlarinbolumleri.SelectedValue.Trim() + "_SinavSonuclari.xls");

            string header = "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\n<head>\n<title></title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1254\" />\n<style>\n</style>\n</head>\n<body>\n";

            Response.Write(header + sw);
            Response.End();

 

 

SQL Server 2008 Rule " Performance counter registry hive consistency " failed.

12 May 2011 Author: Admin In: ipucu, SQL

Windows Server 2008 Foundation sürümü üzerine SQL Server 2008 Express Edition kurarken aşagıdaki hatayı alırsanız :

Rule "Performance counter registry hive consistency" failed.

Çözümü Registry de ve oldukca basit :

Türkçe işletim sisteminde 
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\01F

İngilizce de ise 
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009

Klasörüne gidin ve
"Counter" ve "Help" anahtarlarını (Çok Dizeli Deger) açın ve içindeki verileri var olan kalsörden kopyalayıp yapıştırın. 

Şimdi kurulumu tamamlaya bilirsiniz. 



 

Ortak Class

12 Şub 2011 Author: Admin In: .net

public class Ortak
{

public string scs(string c, string cs, string p1, string p2, string p3, string p4, string p5)
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[cs].ConnectionString))
{
using (SqlCommand comm = new SqlCommand(c, conn))
{
try
{
conn.Open();
if (p1 != null) comm.Parameters.Add("p1", SqlDbType.NVarChar).Value = p1;
if (p2 != null) comm.Parameters.Add("p2", SqlDbType.NVarChar).Value = p2;
if (p3 != null) comm.Parameters.Add("p3", SqlDbType.NVarChar).Value = p3;
if (p4 != null) comm.Parameters.Add("p4", SqlDbType.NVarChar).Value = p4;
if (p5 != null) comm.Parameters.Add("p5", SqlDbType.NVarChar).Value = p5;

if (c.ToLower().Contains("@p1") && p1 == null) comm.Parameters.Add("p1", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p2") && p2 == null) comm.Parameters.Add("p2", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p3") && p3 == null) comm.Parameters.Add("p3", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p4") && p4 == null) comm.Parameters.Add("p4", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p5") && p5 == null) comm.Parameters.Add("p5", SqlDbType.NVarChar).Value = "";

return comm.ExecuteScalar().ToString();
}
catch (Exception ex)
{
return null;
}
}
}
}
public int scn(string c, string cs, string p1, string p2, string p3, string p4, string p5)
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[cs].ConnectionString))
{
using (SqlCommand comm = new SqlCommand(c, conn))
{
try
{
conn.Open();
if (p1 != null) comm.Parameters.Add("p1", SqlDbType.NVarChar).Value = p1;
if (p2 != null) comm.Parameters.Add("p2", SqlDbType.NVarChar).Value = p2;
if (p3 != null) comm.Parameters.Add("p3", SqlDbType.NVarChar).Value = p3;
if (p4 != null) comm.Parameters.Add("p4", SqlDbType.NVarChar).Value = p4;
if (p5 != null) comm.Parameters.Add("p5", SqlDbType.NVarChar).Value = p5;

if (c.ToLower().Contains("@p1") && p1 == null) comm.Parameters.Add("p1", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p2") && p2 == null) comm.Parameters.Add("p2", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p3") && p3 == null) comm.Parameters.Add("p3", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p4") && p4 == null) comm.Parameters.Add("p4", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p5") && p5 == null) comm.Parameters.Add("p5", SqlDbType.NVarChar).Value = "";

return comm.ExecuteNonQuery();
}
catch (Exception ex)
{
return -1;
}
}
}
}
public DataTable sc(string c, string cs, string p1, string p2, string p3, string p4, string p5)
{
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[cs].ConnectionString))
{
using (SqlDataAdapter adap = new SqlDataAdapter(c, conn))
{
try
{
conn.Open();
if (p1 != null) adap.SelectCommand.Parameters.Add("p1", SqlDbType.NVarChar).Value = p1;
if (p2 != null) adap.SelectCommand.Parameters.Add("p2", SqlDbType.NVarChar).Value = p2;
if (p3 != null) adap.SelectCommand.Parameters.Add("p3", SqlDbType.NVarChar).Value = p3;
if (p4 != null) adap.SelectCommand.Parameters.Add("p4", SqlDbType.NVarChar).Value = p4;
if (p5 != null) adap.SelectCommand.Parameters.Add("p5", SqlDbType.NVarChar).Value = p5;

if (c.ToLower().Contains("@p1") && p1 == null) adap.SelectCommand.Parameters.Add("p1", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p2") && p2 == null) adap.SelectCommand.Parameters.Add("p2", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p3") && p3 == null) adap.SelectCommand.Parameters.Add("p3", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p4") && p4 == null) adap.SelectCommand.Parameters.Add("p4", SqlDbType.NVarChar).Value = "";
if (c.ToLower().Contains("@p5") && p5 == null) adap.SelectCommand.Parameters.Add("p5", SqlDbType.NVarChar).Value = "";

adap.Fill(dt);
}
catch (Exception ex)
{
}
}
}
return dt;
}
public static void Logla(string IP, string kim, string ne, string nasil)
{
if (ConfigurationManager.AppSettings["logla"] == "1")
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString))
{
using (SqlCommand comm = new SqlCommand("INSERT INTO Logs(IP,Kim,Ne,Nasil) values (@ip,@kim,@ne,@nasil)", conn))
{
try
{
conn.Open();
comm.Parameters.AddWithValue("@ip", (IP==null?HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]:""));
comm.Parameters.AddWithValue("@kim", kim);
comm.Parameters.AddWithValue("@ne", ne);
comm.Parameters.AddWithValue("@nasil", nasil);


comm.ExecuteNonQuery();

}
catch (Exception ex)
{

}
}
}
}
}
}

TreeView Reqursize C#

15 Oca 2011 Author: Admin In: .net, ipucu
        public void treeviewdeGoster()
        {
            DataTable dt = sc("select * from BAKMAgaci where AnaMKA_ID=0", "ConnStr");
            TreeNode parent = new TreeNode();
            parent.Text = "Makina Agacımız";
            parent.Value = "-1";
            TreeView1.Nodes.Add(parent);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                TreeNode parent2 = new TreeNode();
                parent2.Text = dt.Rows[i]["Adi"].ToString();
                parent2.Value = dt.Rows[i]["MKA_ID"].ToString();

                parent.ChildNodes.Add(parent2);
                trvDoldur(ref parent2, Convert.ToInt16(dt.Rows[i]["MKA_ID"]));
            }
        }
        int ky = 1;
        void trvDoldur(ref TreeNode parent, int parentIdsi)
        {
            DataTable yedek;
            yedek = sc("select * from BAKMAgaci where AnaMKA_ID=" + parentIdsi, "ConnStr");
            for (int y = 0; y < yedek.Rows.Count; y++)
            {
                TreeNode child = new TreeNode();

                child.Text = yedek.Rows[y]["Adi"].ToString();
                child.Value = yedek.Rows[y]["MKA_ID"].ToString();

                parent.ChildNodes.Add(child);
                trvDoldur(ref child, Convert.ToInt16(yedek.Rows[y]["MKA_ID"]));
            }
            ky--;
        }

IMAP Email ayarları

31 Ara 2010 Author: Admin In: ipucu

giden portu 465 ssl TCP firewall dan izin vermek gerekiyor

giden posta sunucusu kimlik dogrulama gerekiyor 

 

gelen 143 security yok

iPhone and Others

31 Ara 2010 Author: Admin In: ilginç
iphones and others

Harika Bir Oyun...

25 Ara 2010 Author: Admin In: hoş

Ben Kimim ?

Celiker BahceciMerhabalar, ben Çeliker BAHÇECİ. 2004 den beri özel sektörde bilgisayar mühendisligi ve egitmenlik yapıyorum. Yine aynı yılın Ekim ayından beri sitemde .Net ile programlama ve hayat görüşüm ile ilgili makalelerimi yayınlıyorum. Blogum dışında Yazgelistir.com, mobilnedir.com gibi ineta kapsamındaki bir çok siteye Microsoft teknolojileri ile ilgili yazılar yazmaktayım.
Bu site ile sizinde hayatınızı anlamlandırmanızda bir parça katkımın olması dilegiyle...


Kategoriler

Arşiv

Takip ettiklerim

Copyright © 2009 - Celiker BAHCECI
Çeliker BAHÇECİ - -