Kalpesh Chhatrala's Blog

How do you run a 300mb+ MS SQL .sql file?

2011-12-07T10:42:00.001+05:30

From the command prompt, start up sqlcmd:

sqlcmd -S <server> -i C:\<your file here>.sql -o

Just replace with the location of your SQL box and with the name of your script. Don't forget if you're using a SQL instance the syntax is:

Here is the list of all arguments you can pass sqlcmd:

Sqlcmd            [-U login id]          [-P password]
  [-S server]            [-H hostname]          [-E trusted connection]
  [-d use database name] [-l login timeout]     [-t query timeout] 
  [-h headers]           [-s colseparator]      [-w screen width]
  [-a packetsize]        [-e echo input]        [-I Enable Quoted Identifiers]
  [-c cmdend]            [-L[c] list servers[clean output]]
  [-q "cmdline query"]   [-Q "cmdline query" and exit] 
  [-m errorlevel]        [-V severitylevel]     [-W remove trailing spaces]
  [-u unicode output]    [-r[0|1] msgs to stderr]
  [-i inputfile]         [-o outputfile]        [-z new password]
  [-f  | i:[,o:]] [-Z new password and exit] 
  [-k[1|2] remove[replace] control characters]
  [-y variable length type display width]
  [-Y fixed length type display width]
  [-p[1] print statistics[colon format]]
  [-R use client regional setting]
  [-b On error batch abort]
  [-v var = "value"...]  [-A dedicated admin connection]
  [-X[1] disable commands, startup script, enviroment variables [and exit]]
  [-x disable variable substitution]
  [-? show syntax summary]

How to Block Websites without using any Software

2011-10-08T09:09:00.001+05:30

1.) Open “Run” from the start menu (or press WinKey + r). Just copy paste the following path and hit ENTER.

notepad %windir%\system32\drivers\etc\hosts

Alternately, go to C:\Windows\System32\Drivers\Etc and find the file “hosts”. Open that file in Notepad.

2.) When this hosts file is opened in Notepad, at the end of the file you will see something like “127.0.0.1 localhost”.

3.) Under “127.0.0.1 localhost” just add another website URL that you want to block.

For Example:-

127.0.0.1 localhost
127.0.0.2 www.kalpesh.biz
127.0.0.3 www.consumer-complaints.in

4.) Make sure every time you add another website, the last digit of the address 127.0.0.x should not be the same.

5.) Save the file and exit.

So, here you go. Restart your browser if it is opened and changes will take place immediately.

The good thing is that no message, no pop ups nothing will be displayed when someone tries to open a blocked website. Your browser will just fail to open those websites without any error messages.

FireFox : Debugging Problem in Silverlight

2011-08-11T15:23:00.000+05:30

Solution 1:

Manually attach the visual studio debugger to “plugin-container.exe”

Solution 2:

This involves changing Firefox’s config, and really should only be done to ease silverlight debugging until a proper fix is released.

Type "about:config" into FF's address bar
Accept the warning (if applicable)
Search for the entry "dom.ipc.plugins.enabled.npctrl.dll"
Change its value from "true" to "false" (double-click)
Restart the browser

Thanks MisterGoodcat for this solution More info

RunTime Sum & GroupBy of DataTable using LINQ

2011-08-09T18:39:00.003+05:30

            DataTable dt = new DataTable();

            

            dt.Columns.Add("ItemName", typeof(String));

            dt.Columns.Add("SalebyEmployee", typeof(String));

            dt.Columns.Add("ItemRate", typeof(Double));

            dt.Columns.Add("Qty", typeof(Int32));

            dt.Columns.Add("Amount", typeof(Double));



            DataRow oRow = dt.Rows.Add();

            oRow["ItemName"] = "Item No. 1 ";

            oRow["SalebyEmployee"] = "Kalpesh";

            oRow["ItemRate"] = 10;

            oRow["Qty"] = 5;

            oRow["Amount"] = 50;



            oRow = dt.Rows.Add();

            oRow["ItemName"] = "Item No. 2 ";

            oRow["SalebyEmployee"] = "Kalpesh";

            oRow["ItemRate"] = 15;

            oRow["Qty"] = 3;

            oRow["Amount"] = 45;



            oRow = dt.Rows.Add();

            oRow["ItemName"] = "Item No. 3 ";

            oRow["SalebyEmployee"] = "Kalpesh";

            oRow["ItemRate"] = 4;

            oRow["Qty"] = 20;

            oRow["Amount"] = 80;



            oRow = dt.Rows.Add();

            oRow["ItemName"] = "Item No. 1 ";

            oRow["SalebyEmployee"] = "Chirag";

            oRow["ItemRate"] = 10;

            oRow["Qty"] = 20;

            oRow["Amount"] = 200;



            oRow = dt.Rows.Add();

            oRow["ItemName"] = "Item No. 2 ";

            oRow["SalebyEmployee"] = "Chirag";

            oRow["ItemRate"] = 15;

            oRow["Qty"] = 30;

            oRow["Amount"] = 450;



            oRow = dt.Rows.Add();

            oRow["ItemName"] = "Item No. 3 ";

            oRow["SalebyEmployee"] = "Kalpesh";

            oRow["ItemRate"] = 10;

            oRow["Qty"] = 15;

            oRow["Amount"] = 150;



            oRow = dt.Rows.Add();

            oRow["ItemName"] = "Item No. 1 ";

            oRow["SalebyEmployee"] = "Rohit";

            oRow["ItemRate"] = 11;

            oRow["Qty"] = 50;

            oRow["Amount"] = 550;



            oRow = dt.Rows.Add();

            oRow["ItemName"] = "Item No. 2 ";

            oRow["SalebyEmployee"] = "Rohit";

            oRow["ItemRate"] = 10;

            oRow["Qty"] = 20;

            oRow["Amount"] = 200;



            oRow = dt.Rows.Add();

            oRow["ItemName"] = "Item No. 3 ";

            oRow["SalebyEmployee"] = "Rohit";

            oRow["ItemRate"] = 10;

            oRow["Qty"] = 4;

            oRow["Amount"] = 40;



            oRow = dt.Rows.Add();

            oRow["ItemName"] = "Item No. 4 ";

            oRow["SalebyEmployee"] = "Rohit";

            oRow["ItemRate"] = 100;

            oRow["Qty"] = 50;

            oRow["Amount"] = 5000;

var queryResult = from item in dt.AsEnumerable()

                              group item by new { ItemSale = item.Field<String>("ItemName") + "_" + item.Field<String>("SaleByEmployee") } into grp

                              orderby grp.Key.ItemSale

                              select new

                              {

                                  ItemSaleByEmp = grp.Key.ItemSale,

                                  TotalAmount = grp.Sum(i => i.Field<Double>("Amount"))

                              };



                   DataTable dtNew  = queryResult.ToList().ToDataTable();

        public static DataTable ToDataTable(this IList data)

        {

            PropertyDescriptorCollection props =

                TypeDescriptor.GetProperties(typeof(T));

            DataTable table = new DataTable();

            for (int i = 0; i < props.Count; i++)

            {

                PropertyDescriptor prop = props[i];

                table.Columns.Add(prop.Name, prop.PropertyType);

            }

            object[] values = new object[props.Count];

            foreach (T item in data)

            {

                for (int i = 0; i < values.Length; i++)

                {

                    values[i] = props[i].GetValue(item);

                }

                table.Rows.Add(values);

            }

            return table;

        }

Add & Delete Custom Printer Forms

2011-07-12T09:36:00.000+05:30

* AddPrinterForm.prg
DEFINE CLASS AddPrinterForm AS Custom
 
 HIDDEN cUnit, cPrinterName, nFormHeight, nFormWidth, nLeftMargin, ;
              nTopMargin, nRightMargin, nBottomMargin, nInch2mm, nCm2mm, nCoefficient, hHeap
 
 cUnit = "English"  && inches or Metric - cm's
 cPrinterName = ""
 nFormHeight = 0
 nFormWidth = 0
 nLeftMargin = 0
 nTopMargin = 0
 nRightMargin = 0
 nBottomMargin = 0
 
 cApiErrorMessage = ""
 cErrorMessage = ""
 
 nInch2mm = 25.4
 nCm2mm = 10
 nCoefficient = This.nInch2mm * 1000
 
 hHeap = 0
 
 * Win API support class
 oWas = NULL
 
 PROCEDURE Init(tcUnit)
 This.oWas = NEWOBJECT("WinApiSupport", "WinApiSupport.fxp")
 IF PCOUNT() = 1 
  This.cUnit = PROPER(tcUnit)
 ENDIF
 This.LoadApiDlls()
 This.hHeap = HeapCreate(0, 4096, 0)
 * Use Windows default printer
 This.cPrinterName = SET("Printer",2)
 ENDPROC
 
 PROCEDURE cUnit_Assign(tcUnit)
 IF INLIST(tcUnit, "English", "Metric")
  This.cUnit = PROPER(tcUnit)
 ELSE
  RETURN 
 ENDIF
 * Calculate conversion coefficient
 This.nCoefficient = IIF(PROPER(This.cUnit) = "English", ;
      This.nInch2mm, This.nCm2mm) * 1000
 ENDPROC
 
 PROCEDURE Destroy
 IF This.hHeap <> 0
  HeapDestroy(This.hHeap)
 ENDIF
 
 ENDPROC
 
 PROCEDURE SetFormMargins(tnLeft, tnTop, tnRight, tnBottom)
 WITH This
  .nLeftMargin  = tnLeft   * .nCoefficient
  .nTopMargin  = tnTop    * .nCoefficient
  .nRightMargin  = tnRight  * .nCoefficient
  .nBottomMargin  = tnBottom * .nCoefficient
 ENDWITH
 ENDPROC
 
 PROCEDURE AddForm(tcFormName, tnWidth, tnHeight, tcPrinterName)
 LOCAL lhPrinter, llOK, lcForm
 
 This.nFormWidth  = tnWidth  * This.nCoefficient
 This.nFormHeight = tnHeight * This.nCoefficient
 IF PCOUNT() > 3
  This.cPrinterName = tcPrinterName
 ENDIF
 
 This.ClearErrors()
 lhPrinter = 0
 IF OpenPrinter(This.cPrinterName, @lhPrinter, 0) = 0
  This.cErrorMessage = "Unable to get printer handle for " + This.cPrinterName 
  This.cApiErrorMessage = WinApiErrMsg(GetLastError())
  RETURN .F.
 ENDIF
 
 lnFormName = HeapAlloc(This.hHeap, 0, LEN(tcFormName) + 1)
 = SYS(2600, lnFormName, LEN(tcFormName) + 1, tcFormName + CHR(0))
 
 * Build FORM_INFO_1 structure
 WITH This.oWas
  lcForm = .Num2Long(0) + .Num2Long(lnFormName) + ;
   .Num2Long(This.nFormWidth) + .Num2Long(This.nFormHeight) + ;
   .Num2Long(This.nLeftMargin) + .Num2Long(This.nTopMargin) + ;
   .Num2Long(This.nFormWidth - This.nRightMargin) + ;
   .Num2Long(This.nFormHeight - This.nBottomMargin)
 ENDWITH
 
 * Finally, call the API
 IF AddForm(lhPrinter, 1, @lcForm) = 0
  This.cErrorMessage = "Unable to Add Form " + tcFormName 
  This.cApiErrorMessage = STRTRAN(WinApiErrMsg(GetLastError()), "file", "form", -1, -1, 3)
  llOK = .F.
 ELSE
  llOK = .T.
 ENDIF
 = HeapFree(This.hHeap, 0, lnFormName)
 = ClosePrinter(lhPrinter)
 
 RETURN llOK
 
 PROCEDURE ClearErrors
 This.cErrorMessage = ""
 This.cApiErrorMessage = ""
 ENDPROC
 
 PROCEDURE DeleteForm(tcFormName, tcPrinterName)
 LOCAL lhPrinter, llOK
 
 IF PCOUNT() > 1
  This.cPrinterName = tcPrinterName
 ENDIF
 
 This.ClearErrors()
 lhPrinter = 0
 IF OpenPrinter(This.cPrinterName, @lhPrinter, 0) = 0
  This.cErrorMessage = "Unable to get printer handle for " + This.cPrinterName + "."
  This.cApiErrorMessage = WinApiErrMsg(GetLastError())
  RETURN .F.
 ENDIF
 
 * Finally, call the API
 llOK = ( DeleteForm(lhPrinter, tcFormName) <> 0 )
 IF NOT llOK 
  This.cErrorMessage = "Unable to delete Form " + tcFormName 
  This.cApiErrorMessage = STRTRAN(WinApiErrMsg(GetLastError()), "file", "form", -1, -1, 3)
 ENDIF
 = ClosePrinter(lhPrinter)
 RETURN llOK
 
 HIDDEN PROCEDURE LoadApiDlls
  DECLARE Long HeapCreate IN WIN32API Long dwOptions, Long dwInitialSize, Long dwMaxSize
  DECLARE Long HeapAlloc IN WIN32API Long hHeap, Long dwFlags, Long dwBytes
  DECLARE Long HeapFree IN WIN32API Long hHeap, Long dwFlags, Long lpMem
  DECLARE HeapDestroy IN WIN32API Long hHeap
  DECLARE Long GetLastError IN kernel32
 ENDPROC
 
ENDDEFINE
*----------------------------------------------------------------------------------------------
 
FUNCTION OpenPrinter(tcPrinterName, thPrinter, tcDefault)
DECLARE Long OpenPrinter IN WinSpool.Drv ;
 String pPrinterName, Long @ phPrinter, String pDefault
RETURN  OpenPrinter(tcPrinterName, @thPrinter, tcDefault)
 
FUNCTION ClosePrinter (thPrinter)
DECLARE Long ClosePrinter IN WinSpool.Drv Long hPrinter
RETURN ClosePrinter(thPrinter)
 
 
FUNCTION AddForm(thPrinter, tnLevel, tcForm)
DECLARE Long AddForm IN winspool.drv Long hPrinter, Long Level, String @pForm
RETURN AddForm(thPrinter, tnLevel, tcForm)
 
FUNCTION DeleteForm(thPrinter, tcForm)
DECLARE Long DeleteForm IN winspool.drv Long hPrinter, String  pFormName 
RETURN DeleteForm(thPrinter, tcForm)

* Ref : http://www.berezniker.com

Silverlight Isolated Storage Folder / Out of Browser Location

2011-06-24T14:50:00.000+05:30

Isolated storage is stored in the OS user's local application data directory, which is different on various operating systems. For example...

Windows XP Operating System

Isolated File Storage

C:\Documents and Settings\\Local Settings\Application Data\Microsoft\Silverlight\js\

Out of Browser Folder

C:\Documents and Settings\\Local Settings\Application Data\Microsoft\Silverlight\OutOfBrowser\

Windows 7 or Windows Vista Operating System

Isolated File Storage

C:\Users\username>\AppData\LocalLow\Microsoft\Silverlight\is\

Out of Browser Folder

C:\Users\username>\AppData\LocalLow\Microsoft\Silverlight\OutOfBrowser\