SQL string agg methodu

8 Oca 2023 In: ipucu
select * from (
select u.UYE_ID,
  (
    SELECT STRING_AGG (CONVERT(NVARCHAR(max),v.Kodu), ', ') AS csv 
    FROM [v_UyelerveMulkleri] v where v.UYE_ID=u.UYE_ID 
  ) as Mulkleri
from Uyeler u) z
where Mulkleri is not null

BootBox JS ile Confirm ve Alert

20 Şub 2019 In: ipucu
    <script src="js/bootbox.all.min.js"></script>
 
 
<button id="btn_ydilkaydet_" onclick="sinavyerisec();return false;" value="Seçimi Kaydet" class="btn btn-primary" style="width: 130px"></button>
<asp:Button ID="btn_ydilkaydet" runat="server" Text="Kaydet" style="display:none"  OnClick="btn_ydilkaydet_Click" /> 
 
 
        function sinavyerisec() {
            var ms = "<br>Bu bilgiler kaydedilsin mi?<br>";
            bootbox.confirm({
                message: ms,
                buttons: {
                    confirm: {
                        label: 'Kaydet',
                        className: 'btn-primary'
                    },
                    cancel: {
                        label: 'Vazgeç',
                        className: 'btn-warning'
                    }
                },
                callback: function (result) {
    //if(result){}
    //window.open('<%= ConfigurationManager.AppSettings["failurlsi"] %>'); 
                    $("[id$='btn_ydilkaydet']").click();
                }
            });
                }
 
veya
 

bootbox.confirm("This is the default confirm!", function(result){ console.log('This was logged in the callback: ' + result);  

}); 

 
 
 
//ALERT
 
bootbox.alert("This is the default alert!"); 
 

bootbox.alert({ message: "This is an alert with a callback!", callback: function () { console.log('This was logged in the callback!'); } 

}); 

ASUS UX430UQ Windows 10 Kurulumu

24 Şub 2018 In: ipucu

Merhabalar,

UX430 u USB den boot edebilmek ve Win10 kurabilmek için 

1. F2 deyip BIOS a giriyoruz

2. Advanced Mode -> Security -> Secure boot : Disabled -> F10 (Save and Quit)

3. F2 deyip yeniden BIOS a  

4. Advanced Mode -> Boot -> CSM Support : Enabled -> F10 (Save and Quit) 

5. F2 deyip yeniden BIOS a  

6. Advanced Mode -> Boot -> Change Boot Priorities with your USB Disk ( seçebilirsiniz hangi cihaz ile açılacagını)

Transfer HTTP to HTTPS on IIS

1 Haz 2017 In: .net, ipucu

We have 2 methods for this purpose:

1. You can add this line to your index.html/default.aspx web page

if (location.protocol !== "https:"){
location.replace(window.location.href.replace("http:","https:"));
}

 

2. If you are using higher version of IIS 6.1, just put this lines to web.config

<system.webServer>
<rewrite>
<rules>
<rule name="HTTPyi HTTPSye Yonlendirme" stopProcessing="true">
<match url="(.*)" />
<conditions>
<add input="{HTTPS}" pattern="off" ignoreCase="true" />
</conditions>
<action type="Redirect" redirectType="Permanent" url="https://{HTTP_HOST}/{R:1}" />
</rule>
</rules>
</rewrite>
</system.webServer>

 

 

CSS ve Table

13 May 2017 In: ipucu

response ve sade olsun

 <style>
table {
    border-collapse: collapse;
    width: 100%;
}

th {
    padding-top: 11px;
    padding-bottom: 11px;
    background-color: #4CAF50;
    color: white;
}  

th, td {
    border: 1px solid #ddd;
    text-align: left;
    padding: 8px;
}

tr:nth-child(even){background-color: #f2f2f2}
</style>

 

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

 

<style>
table#customers {
    font-size:16px;
    font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
    border-collapse: collapse;
    border-spacing: 0;
    width: 100%;
}

#customers td, #customers th {
    border: 1px solid #ddd;
    text-align: left;
    padding: 8px;
}

#customers tr:nth-child(even){background-color: #f2f2f2}

#customers th {
    padding-top: 11px;
    padding-bottom: 11px;
    background-color: #4CAF50;
    color: white;

 

 <table id="customers">

<tbody><tr>

  <th>Company</th>

  <th>Contact</th>

  <th>Country</th>

</tr>

<tr>

<td>Alfreds Futterkiste</td>

<td>Maria Anders</td>

<td>Germany</td>

</tr>

<tr class="alt">

<td>Berglunds snabbköp</td>

<td>Christina Berglund</td>

<td>Sweden</td>

</tr></table>

 

 

 

 

 

RadioButton group name solution for repater

25 Şub 2017 In: .net, ipucu

I got a templated control (a repeater) listing some text and other markup. Each item has a radiobutton associated with it, making it possible for the user to select ONE of the items created by the repeater.

The repeater writes the radiobutton setting its ID and NAME generated with the default ASP.NET naming convention making each radiobutton a full 'group'. This means all radiobuttons are independent on each other, which again unfortunately means I can select all radiobuttons at the same time. The radiobutton has the clever attribute 'groupname' used to set a common name, so they get grouped together and thus should be dependant (so I can only select one at a time). The problem is - this doesn't work - the repeater makes sure the id and thus the name (which controls the grouping) are different.
 
With this JS method, you can set name with a constant name. And that s solved :) 
 
    function set_radio_name() {
        $("[type=radio]").each(function (i) {
            var name = $(this).attr("name");
            var splitted = name.split("$");
            $(this).attr("name", "sec");
        });
    };

    $(document).ready(function () {
        set_radio_name();
    });
On device

1. Menu -> Settings -> About Device -> Build No (click seven times to Enable Developer Mode)

2. Menu -> Settings -> Developer Options -> Allow USB Debug Mode to ON

 

On Mac

1. Connect to USB port of your MAC 

2. First try to MTP mode when connected on your device, if its not connected or not appears in Android Studio then try to choose PTP mode.

3. Select in your device in deployment target window in Android Studio

Türkiye için gerekli time zone update ini buradan erişebilirsiniz.

http://www.catalog.update.microsoft.com/Search.aspx?q=KB3192321

 

Windows 7, Windows Server 2008,  Windows Server 2012

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...