Get QueryString with JS

1 Eyl 2018 In:
Get Request Values from URL :
 
 
<html xmlns="http://www.w3.org/1999/xhtml"><head><script>
function gup(name) {
    name = name.replace(/[\[]/, '\\[').replace(/[\]]/, '\\]');
    var regex = new RegExp('[\\?&]' + name + '=([^&#]*)');
    var results = regex.exec(location.search);
    return results === null ? '' : decodeURIComponent(results[1].replace(/\+/g, ' '));
};
if(gup('ck')!='')
{window.location.href='http://x/default.aspx?a='+gup('a')+'&b='+gup('b')+'&c='+gup('c');
}else{window.location.href='http://x/default.aspx';};</script></head></html> 
 

Offline Google Font Usage

4 Ağu 2018 In:

Google fontlarını offline kulanım için :

https://google-webfonts-helper.herokuapp.com/fonts/roboto?subsets=latin,latin-ext 

 

/* roboto-regular - latin-ext_latin */
@font-face {
font-family: 'Roboto';
font-style: normal;
font-weight: 400;
src: url('../fonts/roboto-v18-latin-ext_latin-regular.eot'); /* IE9 Compat Modes */
src: local('Roboto'), local('Roboto-Regular'),
url('../fonts/roboto-v18-latin-ext_latin-regular.eot?#iefix') format('embedded-opentype'), /* IE6-IE8 */
url('../fonts/roboto-v18-latin-ext_latin-regular.woff2') format('woff2'), /* Super Modern Browsers */
url('../fonts/roboto-v18-latin-ext_latin-regular.woff') format('woff'), /* Modern Browsers */
url('../fonts/roboto-v18-latin-ext_latin-regular.ttf') format('truetype'), /* Safari, Android, iOS */
url('../fonts
/roboto-v18-latin-ext_latin-regular.svg#Roboto') format('svg'); /* Legacy iOS */ 

} 

Delete row from Datatable with an iteration

1 Mar 2018 In: .net
List<DataRow> toDelete = new List<DataRow>();
                foreach (DataRow dr in dt_kimaylmt.Rows)
                {
                    if (dr["DepartmentId"].ToString() == "" || dr["FleetId"].ToString().Length == 0)
                    {
                        toDelete.Add(dr);
                    }
                }

                foreach (DataRow dr in toDelete)
                {
                    dt_kimaylmt.Rows.Remove(dr);
                }
               

                dt_kimaylmt.AcceptChanges();

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ı)

SQL FullText Search

20 Oca 2018 In: SQL
DECLARE
    @search_string  VARCHAR(100),
    @TABLE_NAME     SYSNAME,
    @table_id       INT,
    @column_name    SYSNAME,
    @sql_string     VARCHAR(2000)
 
SET @search_string = 'deneme12345'
 
DECLARE tables_cur CURSOR FOR SELECT name, object_id FROM sys.objects WHERE TYPE = 'U'
OPEN tables_cur
FETCH NEXT FROM tables_cur INTO @TABLE_NAME, @table_id
 
WHILE (@@FETCH_STATUS = 0)
BEGIN
    DECLARE columns_cur CURSOR FOR SELECT name FROM sys.columns WHERE object_id = @table_id AND system_type_id IN (167, 175, 231, 239)
    OPEN columns_cur
 
    FETCH NEXT FROM columns_cur INTO @column_name
    WHILE (@@FETCH_STATUS = 0)
    BEGIN
        SET @sql_string = 'IF EXISTS (SELECT * FROM ' + @TABLE_NAME + ' WHERE [' + @column_name + '] LIKE ''%' + @search_string + '%'') PRINT ''' + @TABLE_NAME + ', ' + @column_name + ''''
 
        EXECUTE(@sql_string)
 
        FETCH NEXT FROM columns_cur INTO @column_name
    END
 
    CLOSE columns_cur
    DEALLOCATE columns_cur
 
    FETCH NEXT FROM tables_cur INTO @TABLE_NAME, @table_id
END
 
CLOSE tables_cur
DEALLOCATE tables_cur
 
 
 
 
 
-------------------------
 
Find a specified string in a database with all tables :
 
 
CREATE PROC SearchAllTables ( @SearchStr nvarchar(100) ) AS BEGIN

DECLARE @Results TABLE(ColumnName nvarchar(370), ColumnValue nvarchar(3630))

SET NOCOUNT ON

DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
SET  @TableName = ''
SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')

WHILE @TableName IS NOT NULL
BEGIN
    SET @ColumnName = ''
    SET @TableName = 
    (
        SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))
        FROM    INFORMATION_SCHEMA.TABLES
        WHERE       TABLE_TYPE = 'BASE TABLE'
            AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName
            AND OBJECTPROPERTY(
                    OBJECT_ID(
                        QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)
                         ), 'IsMSShipped'
                           ) = 0
    )

    WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)
    BEGIN
        SET @ColumnName =
        (
            SELECT MIN(QUOTENAME(COLUMN_NAME))
            FROM    INFORMATION_SCHEMA.COLUMNS
            WHERE       TABLE_SCHEMA    = PARSENAME(@TableName, 2)
                AND TABLE_NAME  = PARSENAME(@TableName, 1)
                AND DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar')
                AND QUOTENAME(COLUMN_NAME) > @ColumnName
        )

        IF @ColumnName IS NOT NULL
        BEGIN
            INSERT INTO @Results
            EXEC
            (
                'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630) 
                FROM ' + @TableName + ' (NOLOCK) ' +
                ' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2
            )
        END
    END 
END

SELECT ColumnName, ColumnValue FROM @Results
END 
 
 
 
------------------- 
 
 exec SearchAllTables 'deneme12345';
 
------------------- 

xCode için plist.info

19 Ara 2017 In:

<key>NSAppTransportSecurity</key>
<dict>
<key>NSAllowsArbitraryLoads</key>
<true/>
<key>NSAllowsArbitraryLoadsInWebContent</key>
<true/>
<key>NSExceptionDomains</key>
<dict>
<key>thekidsup.com</key>
<dict>
<key>NSExceptionAllowsInsecureHTTPLoads</key>
<true/>
<key>NSIncludesSubdomains</key>
<true/>
</dict>
</dict>
</dict>
<key>NSAppleMusicUsageDescription</key>
<string>Lütfen izin veriniz</string>
<key>NSCameraUsageDescription</key>
<string>Lütfen izin veriniz</string>
<key>NSLocationAlwaysUsageDescription</key>
<string>Lütfen izin veriniz</string>
<key>NSLocationUsageDescription</key>
<string>Lütfen izin veriniz</string>
<key>NSLocationWhenInUseUsageDescription</key>
<string>Lütfen izin veriniz</string>
<key>NSMicrophoneUsageDescription</key>
<string>Lütfen izin veriniz</string>
<key>NSPhotoLibraryUsageDescription</key>
<string>Lütfen izin veriniz</string>
 

Repeater Footer Summary

1 Ağu 2017 In: .net
        protected void rpt_kayitlar_ItemDataBound(object sender, RepeaterItemEventArgs e)
        {
            if (e.Item.ItemType == ListItemType.Header) { Session["ktp"] = 0m; }
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { Session["ktp"] = (decimal)Session["ktp"] + (decimal)DataBinder.Eval(e.Item.DataItem, "Tutar");  }
            if (e.Item.ItemType == ListItemType.Footer) { ((Label)e.Item.FindControl("lbl_t")).Text = ((decimal)Session["ktp"]).ToString("N2"); }
        }

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>

 

 

 

 

 

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