GridView Hints

22 Ara 2015 In:
   protected void dtg_kalemler_RowDataBound(object sender, GridViewRowEventArgs e)
if (e.Row.RowType == DataControlRowType.DataRow)
                     DataRowView m = (DataRowView)e.Row.DataItem;
                     if (m != null)
+ ((DataTable)m.DataView.Table) {} System.Data.DataTable
- ((DataRowView)e.Row.DataItem).Row {System.Data.DataRow} System.Data.DataRow

Automatic Update causes SVCHOST.EXE High CPU

18 Ara 2015 In: ipucu
Solution for Win7 x64 

Antalya Kimlik Bildirim Projesi

29 Tem 2015 In:

Antalya Emniyet Müdürlüğünce faaliyete geçirilecek Online Kimlik Bildirim Projesi için gerekli protokol taraflarca imzalandı.

Antalya Emniyet Müdürlüğünce hazırlanan “Antalya Online Kimlik Bildirim” Projesine erismek icin tiklayiniz. veya direk adresi ile birlikte adresinden de erislie bilir.

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

A simple cursor usage example in SQL

15 May 2015 In:
Update destination table with source table's data... 
DECLARE @BusinessEntityID as NVARCHAR(50);
DECLARE @BusinessName as NVARCHAR(50);
DECLARE @BusinessCursor as CURSOR;
SET @BusinessCursor = CURSOR FOR

SELECT namesurname, usern
 FROM [SourceDB].[dbo].[Users];
OPEN @BusinessCursor;
FETCH NEXT FROM @BusinessCursor INTO @BusinessEntityID, @BusinessName;
 --PRINT cast(@BusinessEntityID as VARCHAR (50)) + ' ' + @BusinessName;
 UPDATE [DestinationDB].[dbo].[Users] SET Usern=@BusinessName WHERE Name=@BusinessEntityID
 FETCH NEXT FROM @BusinessCursor INTO @BusinessEntityID, @BusinessName;
CLOSE @BusinessCursor;
DEALLOCATE @BusinessCursor;

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