How to using Windiff as External Diff in SourceTree

How to using Windiff as External Diff in SourceTree

1. Open SourceTree
2. Tools - Options
3. Diff - External Diff Tool : Custom
Diff command : C:\PathToWindiff\WinDiff.Exe
Argument :   $LOCAL $REMOTE

*note: put <space> in First letter in Argument
example in command prompt : WinDiff.Exe $LOCAL $REMOTE

How to compare file using Command Prompt and Visual Studio 2015

How to compare file using Command Prompt and Visual Studio 2015
1. open command prompt
2. go to visual studio path : "C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE"
3. example :

.\devenv.exe /diff “C:\b.txt” “C:\a.txt” “SOURCE” “TARGET”

Copy Multi Folders using Robocopy for "Infinite Folders"

Intro dulu ya ....
gw lagi coding php, pake php designer 8. trus gw coba-coba toolsnya. ada export, eh pas gw coba, kok ga beres2 copynya?? trus gw cancel. pas gw liat, eh ternyata ngebuat folder yg banyak bgt.
gw coba cek pake software2, ada sekitar 475 folders (dibaca: tak terbatas a.k. infinity / infinite).
foldernya ampe ga bisa dibuka.
trus gw googling2.
- pake cmd , pake cara buat remove autorun.inf nya SMADAV seperti rmdir, rd, del, erase.
- install winUtilities, Unlocker, pake power shell, dsb.
- trus gw coba robocopy. pake cmd jg. setelah menggila lama , akhirnya nemu juga caranya. yaitu
robocopy [source] [dest] /purge /s /mov
contoh :  robocopy c:\hapus\a\ c:\delete\a\ /purge /s /mov

beres deh...

So, ini kesimpulannya :
Pakai Robocopy (using cmd)
command : 
robocopy [source] [dest] /purge /s /mov
contoh :  robocopy c:\hapus\a\ c:\delete\a\ /purge /s /mov

**dipublish setelah gw liat ini as draft (udah 4 tahun sepertinya...)

using Entity Framework or EF to copy an Object.

using Entity Framework or EF to copy an Object.
This can be used to avoid Error : PK cannot be modified :
"The property 'MyPrimaryKey' is part of the object's key information and cannot be modified. "
we can use this query :

var item = _context.MyTableName.First(z => z.Name == "Ardi");
var newItem = (MyTableName)_context.Entry(item).GetDatabaseValues().ToObject();
newItem.MyPrimaryKey = "Generated_" + DateTime.Now.ToString();
_context.SaveChanges();

How to import Huge SQL Script on mysql

open xampp Control Panel
click / open : shell

on shell type this commands:

1. command : "MYSQL -U USERNAME -H LOCALHOST -P PASSWORD"
USERNAME : your database username
PASSWORD : your database password
(if no password, then don't use "-P PASSWORD")

2. command : "USE NAME_OF_DATABASE"
 NAME_OF_DATABASE : name of your database

3. command : "SOURCE PATH_TO_SQL_FILE"
PATH_TO_SQL_FILE : location to script.sql
(ex. "source d:/myscript.sql")

4. done

Firefox Text Bold Problem

I got my Firefox Text get Bold. This problem caused by regular Arial Font is missing. So, Arial Black is used.
To fix this, I got arial.ttf from http://www.fontsupply.com/fonts/A/Arial.html .
After you download, open arial.zip then open arial.ttf. Click install.
Your arial font will installed.
Problem done.

Creating ASPNET WebForm GridView Paging

Here is code for Creating ASPNET WebForm GridView Paging :

On *.aspx files, gridview need : properties AllowPaging and events OnPageIndexChanging

You can set and configure the pager style & setting by changing the PagerStyle and PagerSettings.

<asp:GridView ID="GridView1" runat="server" AllowPaging="True"  OnPageIndexChanging="GridView1_PageIndexChanging>

        <PagerStyle HorizontalAlign="Center" CssClass="foo" />

        <PagerSettings Mode="NumericFirstLast" PageButtonCount="5" FirstPageText="First" LastPageText="Last" />

</asp:GridView>

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

        GridView1.PageIndex = e.NewPageIndex;

        LoadData();

}

private void LoadData()

{

        GridView1.DataSource = mylist.ToList();

        GridView1.DataBind();

}

LoadData is a function to bind list or array to GridView. 

We can Manage the list by put them in a ViewState or in a Session to Keep Consistent List.

This could happend when you have searched list or sorted it.

SQL Server Rename Table Name

To rename table name in SQL Server , you can use this store procedure:
SP_RENAME 'TABLE_NAME' , 'NEW_TABLE_NAME' .
For example: sp_rename 'TFileFolder' , 'TFolder'
 

CompiledQuery Linq to SQL C#

using CompiledQuery Linq to SQL C# using CompiledQuery can do more good performance and more efficient.

 using System.Data.Linq;

 public static Func> userData
        = CompiledQuery.Compile((myDataContext db) => db.TableUsers);

Using StopWatch to Count Execution Time in ASP.NET

Using Stopwatch to Count Execution Time in ASP.NET

 using System.Diagnostics;

 Stopwatch sw = new Stopwatch(); //create object
 sw.Start(); // start the stopwatch
 //do something here
 sw.Stop(); // stop the stopwatch
 Console.WriteLine("Time elapsed : " + sw.ElapsedMilliseconds.ToString());