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 () {
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.


Windows 7, Windows Server 2008,  Windows Server 2012

Automatic Update causes SVCHOST.EXE High CPU

18 Ara 2015 In: ipucu
Solution for Win7 x64 

Transfer your data from Excel to SQL Table

29 Haz 2015 In: ipucu

Text was truncated or one or more characters had no match in the target code page.
You can fix with 2 steps;
- Increase your lenght of your data type from SQL database.
-  Or change the value of TypeGuessRows, use these steps:
On the Start menu, click Run. In the Run dialog box, type Regedt32, and then click OK.
Open the following key in the Registry editor:


Note For 64-bit systems, the corresponding key is as follows:

Double-click TypeGuessRows.
In the DWORD editor dialog box, click Decimal under Base. Type a value between 0 and 16, inclusive, for Value data.
Click OK, and then exit the Registry Editor.
A second way to work around this problem (without modifying the registry) is to make sure that rows with fields, which have data 255 characters or greater, are present in the first 8 rows of the source data file.
The valid range of values for the TypeGuessRows key is 0 to 16. However, if the value is 0, the number of source rows scanned is 16384. Keep in mind that a value of zero may cause a small performance hit if the source file is very large. 
Excel den SQL e veri aktarirken, eger asagidaki hatayi aliyorsaniz ;  
Text was truncated or one or more characters had no match in the target code page.
- SQL de tablodaki veri turu alanin boyutunu genisletin.(nvarchar(max))
Baslat Calistir "REGEDIT" 

Sisteminiz 64-bit ise:

TypeGuessRows= 0
yapin, tum satirlara bakacagi icin cok buyuk boyutlu dosyalarda bizraz beklersiniz o kadar. Bu sekilde excel den SQL e aktarim (import,transfer) yaparken sorun olusmayacak...

C:\Program Files\Microsoft Office\Office15\OSPPREARM.exe

Run it and earn more days...  :) 


PS: it works only 5 times, it means 5*30 days. (Rearming the Office 2013 installation) 

Rearming does the following important tasks:
 - Resets the grace timer to 30 days.
 - Freezes the grace timer until either an Office application is run, or the ospp.vbs script is run.
 - Resets the client computer ID (CMID). This is important because the KMS host uses the CMID to determine the number of unique clients. To check the CMID, use the command ospp.vbs /dcmid.

How to change your HP scanner IP changes?

4 Mar 2015 In: ipucu

If your scanner is not working and if it given error like "Communication Error with Scanner..."

Probably the IP address from your printer/scanner changed. It was no communication with the scanner possible anymore.

You can easily change the IP address in the printer settings, but not in the scanner settings. 

The solution of this :

goto Start->Run->regedit 

goto HKEY_USERS\S-1-5-19\Software\Hewlett-Packard\DigitalImaging\NetworkScanners\083E8E8A89D7

right click to right panel Add->String Value->IpAddress

Double click to IpAddress and enter IP address of your MFP or HP scanner like 

If it is not in S-1-5-19  try others  S-1-5-18 or S-1-5-20, etc


My choose is HeidiSQL...
HeidiSQL is a useful and reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases and PostgreSQL. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard or to other servers. 
Some Features : 
Free for everyone, OpenSource since 9 years of active development.
Connect to multiple servers in one window
Connect to servers via commandline
Connect via SSH tunnel, or pass SSL settings
Create and edit tables, views, stored routines, triggers and scheduled events.
Generate nice SQL-exports, compress these afterwards, or put them on the clipboard.
Export from one server/database directly to another server/database
Manage user-privileges
Import text-files
Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array
Browse and edit table-data using a comfortable grid
Bulk edit tables (move to db, change engine, collation etc.)
Batch-insert ascii or binary files into tables
Write queries with customizable syntax-highlighting and code-completion
Pretty reformat disordered SQL
Monitor and kill client-processes
Find specific text in all tables of all databases of one server
Optimize and repair tables in a batch manner
Launch a parallel mysql.exe command line window using your current connection settings 
Download links for portable edition of HeidiSQL :

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