XploreDotNet

python -m pip install Scrapy - error: command 'cl.exe' failed: No such file or directory

noreply@blogger.com (Unknown) — Sun, 26 Apr 2020 23:34:00 +0000

While Installing Scrapy library in windows in case if you receive "Command 'cl.exe' failed" error means the system doesn't have Microsoft C Compiler or Environment path not set properly.

To Fix this error try installing Desktop Development with C++ from Visual Studio Installer. After installing it try running this command in windows Command prompt python -m pip install Scrapy

HowTo update PIP

noreply@blogger.com (Unknown) — Sat, 25 Apr 2020 20:10:00 +0000

Sometime we need to upgrade PIP in our machine. to upgrade use this command python -m pip install --upgrade pip in the windows command prompt.

pip install matplotlib - SyntaxError: invalid syntax

noreply@blogger.com (Unknown) — Sat, 25 Apr 2020 19:57:00 +0000

When we are trying to install mapplotlib using PiP command into the python interactive prompt then it will throw invalid syntax error. To Over come this issue try running this command windows command prompt "python -m pip install matplotlib" Note: before running this command install python in the machine.

Python 3.8.2 (tags/v3.8.2:7b3ab59, Feb 25 2020, 22:45:29) [MSC v.1916 32 bit (Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> pip install matplotlib
File "", line 1
pip install matplotlib
^
SyntaxError: invalid syntax

SSRS 2005 - How To Format Globals!ExecutionTime To "MM/dd/yyyy"

noreply@blogger.com (Unknown) — Thu, 12 May 2016 19:16:00 +0000

To format the build-in global in SSRS 2005 you have to you FORMAT functions which will take two parameters (Expression & Style)

Example

= FORMAT(Globals!ExecutionTime, "MM/dd/yyyy")

Select Query - Case Statement In Order by - Msg 241 - Conversion failed when converting datetime from character string Error

noreply@blogger.com (Unknown) — Thu, 13 Aug 2015 19:32:00 +0000

Today when i was working on store procedure which i need to use case statement in Order by in the select clause i have came across the following issue,

Msg 241, Level 16, State 1, Line 16
Conversion failed when converting datetime from character string.

After a spending some time I found the root cause of this issue, the golden rule we have to use the same type in all the branches of case/when.

Sample Code

Execute the below sample script to recreate that issue,

DECLARE @tmpTBL table

(

ID INT IDENTITY(1,1),

SampleDT datetime

)

INSERT INTO @tmpTBL VALUES('2015-08-01');

INSERT INTO @tmpTBL VALUES('2015-08-02');

INSERT INTO @tmpTBL VALUES('2015-08-03');

INSERT INTO @tmpTBL VALUES('2015-08-04');

Declare @SordDirection CHAR(1); SET @SordDirection = 'D';

Declare @OrderBy VARCHAR(10);SET @OrderBy = 'SampleDT';

SELECT * FROM @tmpTBL

ORDER BY

CASE WHEN @SordDirection ='D' THEN 'A'

ELSE

CASE WHEN @OrderBy = 'SampleDT' THEN SampleDT

END

END ASC,

CASE WHEN @SordDirection='A' THEN 'D'

ELSE

CASE WHEN @OrderBy = 'SampleDT' THEN SampleDT

END

END DESC

Replace the CASE WHEN @OrderBy = 'SampleDT' THEN SampleDT with the following line

CASE WHEN @OrderBy = 'SampleDT' THEN CAST(SampleDT as VARCHAR(12))

After replacing if you execute the script, you can see the results without any issues,

Complete Script

DECLARE @tmpTBL table
(
ID INT IDENTITY(1,1),
SampleDT datetime
)

INSERT INTO @tmpTBL VALUES('2015-08-01');
INSERT INTO @tmpTBL VALUES('2015-08-02');
INSERT INTO @tmpTBL VALUES('2015-08-03');
INSERT INTO @tmpTBL VALUES('2015-08-04');

Declare @SordDirection CHAR(1); SET @SordDirection = 'D';
Declare @OrderBy VARCHAR(10);SET @OrderBy = 'SampleDT';

        SELECT * FROM @tmpTBL
ORDER BY
       CASE WHEN @SordDirection ='D' THEN 'A'
       ELSE
       CASE WHEN @OrderBy = 'SampleDT' THEN CAST(SampleDT as VARCHAR(12))
       END
       END ASC,
       CASE WHEN @SordDirection='A' THEN 'D'
       ELSE
       CASE WHEN @OrderBy = 'SampleDT' THEN CAST(SampleDT as VARCHAR(12))
       END
       END DESC

Sql Server order by month name

noreply@blogger.com (Unknown) — Sat, 16 May 2015 13:49:00 +0000

Following Script will order the result in actual calendar month order.

SELECT * FROM [dbo].[tablename]
ORDER BY DATEPART(mm,CAST([DateFieldColumnName] + ' 1900' AS DATETIME)) ASC

How To retain aspajax:CalendarExtender selected value after postback

noreply@blogger.com (Unknown) — Thu, 23 Oct 2014 14:23:00 +0000

Try This below snippet to retain the CalendarExtender selected value after postback

if(isPostback)
{
YourCalendarExtender.SelectedDate =
DateTime.ParseExact(YourTextBox.Text, YourCalendarExtender.Format, null);
}

Command Prompt How to list all files in a folder as well as sub-folders in windows

noreply@blogger.com (Unknown) — Thu, 25 Sep 2014 15:30:00 +0000

Step 1 : Goto required folder in Command prompt.

Step 2: Type the following command    dir /b /s

              /b - User bare format
              /s - Lists the files in the directory that you are in and all sub directories after that directory

              Step 2 will list all the files reside in the parent folder and it's sub folder.

Step 3: To get the specific file give the appropriate file extension. for example if we need sql file to be listed, give the following command dir /b /s *.sql | sort

ArrayList, List, HashTable, Dictionary, SortedList, SortedDictionary — Speed, memory, and when to use each?

noreply@blogger.com (Unknown) — Tue, 08 Apr 2014 20:02:00 +0000

Array - represents an old-school memory array - kind of like a alias for a normal type[] array. Can enumerate. Can't grow automatically. I would assume very fast insertion and retriv. speed.

ArrayList - automatically growing array. Adds more overhead. Can enum., probably slower than a normal array but still pretty fast. These are used a lot in .NET

List - one of my favs - can be used with generics, so you can have a strongly typed array, e.g. List. Other than that, acts very much like ArrayList.

Hashtable - plain old hashtable. O(1) to O(n) worst case. Can enumerate the value and keys properties, and do key/val pairs.

Dictionary - same as above only strongly typed via generics, such as Dictionary

but note Hashtable has less performance than Dictionary because of Boxing and Unboxing.

SortedList - a sorted generic list. Slowed on insertion since it has to figure out where to put things. Can enum., probably the same on retrieval since it doesn't have to resort, but deletion will be slower than a plain old list.

I tend to use List and Dictionary all the time - once you start using them strongly typed with generics, its really hard to go back to the standard non-generic ones.

There are lots of other data structures too - there's KeyValuePair which you can use to do some interesting things, there's a SortedDictionary which can be useful as well.

Courtesy - Stackoverflow

Access modifiers

noreply@blogger.com (Unknown) — Tue, 25 Mar 2014 18:42:00 +0000

public

The type or member can be accessed by any other code in the same assembly or another assembly that references it.

private

The type or member can only be accessed by code in the same class or struct.

protected

The type or member can only be accessed by code in the same class or struct, or in a derived class.

internal

The type or member can be accessed by any code in the same assembly, but not from another assembly.

protected internal

The type or member can be accessed by any code in the same assembly, or by any derived class in another assembly.

Entity framework in WCF Service - Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool.

noreply@blogger.com (Unknown) — Thu, 27 Feb 2014 19:58:00 +0000

Incase if you getting the "Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool." while using the Entity framework WCF service required MSDTC follow the below steps,

To find that,
1. go to start -> run -> type "c:\Windows\System32\comexp.msc" or comexp.msc
2. Click Component Services
3. Click Computers. Under this, click "My Computer"
4. Once you open "My Computer" you will see 4 folders.
5. Click on Distributed Transaction Coordinator. Underneath this, you will see "Local DTC'
6. Right click "Local DTC" and go to properties.
7. Select Security Tab.
8. Check mark "Network DTC Access" checkbox
9. Finally check mark "Allow Inbound" and "Allow Outbound" checkboxes.
10. Click Apply, Ok.
11. A message will pop up about restarting the service.
12. Click ok and That's all.

Forgot SQL Server Admin Password

noreply@blogger.com (Unknown) — Sat, 14 May 2011 05:55:00 +0000

exec sp_password @new='NewPassword', @loginame='sa'
go
alter login sa enable
go

Bend Replacement for Traditional notepad ?

noreply@blogger.com (Unknown) — Sat, 07 Aug 2010 17:53:00 +0000

Notepad is the light-weight text editor for Windows OS for a long time with simple UI and limited functionalities. I had a chance to try bend for few minutes and I am convinced with its functionalities.

Bend have all the functionalities available in the notepad, and also having tab interface, better find and replace, Zoom Ctrl + Mouse Wheel, Syntax highlighting etc.

Its Prerequisites,

Note :Apparently Bend works on Vista and XP SP3 as well. As long as .net 4.0 works

Courtesy:Codeplex

How To Zip The Folder using VB script

noreply@blogger.com (Unknown) — Mon, 01 Feb 2010 16:09:00 +0000

Option Explicit

Const FOF_SIMPLEPROGRESS = 256
Dim MySource, MyTarget, MyHex, MyBinary, i
Dim oShell, oCTF
Dim oFileSys
dim winShell
Const cstrApp = "Zip It"
MySource = InputBox("Enter path to folder to zip (Ex:D:\xyzfolder)", cstrApp ) 'Example :"D:\test\"
MyTarget = InputBox("Enter path and name of Zip file (Ex:D:\xyz.zip)", cstrApp)'"D:\smp.zip"

MyHex = Array(80, 75, 5, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,0, 0)

For i = 0 To UBound(MyHex)
MyBinary = MyBinary & Chr(MyHex(i))
Next

Set oShell = CreateObject("WScript.Shell")
Set oFileSys = CreateObject("Scripting.FileSystemObject")

'Create the basis of a zip file.
Set oCTF = oFileSys.CreateTextFile(MyTarget, True)
oCTF.Write MyBinary
oCTF.Close
Set oCTF = Nothing

'Add File to zip
set winShell = createObject("shell.application")
winShell.namespace(MyTarget).CopyHere MySource

wScript.Sleep(5000)

'Follow these steps only if you're receiving the 800A01AD error for Wscript.Shell component. For any other ActiveX object, the following steps does not apply:
'Click Start, Run and type:
' * regsvr32 wshom.ocx
' * regsvr32 scrrun.dll

Wishing you all a very joyful, peaceful and happy New Year.

noreply@blogger.com (Unknown) — Fri, 01 Jan 2010 05:15:00 +0000

Wishing you all a very joyful, peaceful and happy New Year.

How To Add Border To Image Within DataGrid Column in Silverlight

noreply@blogger.com (Unknown) — Thu, 31 Dec 2009 05:11:00 +0000

<data:DataGridTemplateColumn Header="Image">
                        <data:DataGridTemplateColumn.CellTemplate>
                            <DataTemplate>
                                <Border BorderBrush="Black" Width="101" BorderThickness="1,1,1,1" Height="13" >
                                    <Image Width="25" Height="11" Source="http://localhost/SLR/images/pers_org.png" Stretch="UniformToFill" HorizontalAlignment="Left" Canvas.Top="0" Canvas.Left="0" >
                                    </Image>
                                </Border>
                            </DataTemplate>
                        </data:DataGridTemplateColumn.CellTemplate>
                    </data:DataGridTemplateColumn>

//Bind the Following code within datagrid LoadingRow Event

Border border = (Border)dgName.Columns[4].GetCellContent(e.Row);// value 4 is the Possible of the Cell in the datagrid
Image image = (Image)border.Child;
//RelMang tmpRm = (RelMang)e.Row.DataContext;
//image.Width = Convert.ToDouble(tmpRm.mx_Rel_Prcntg.ToString());
image.Width = Convert.ToDouble(20); // Dynamically Setting Width of the Image Which in Datagrid Cell

Silverlight How To Pass Values Between Pages or Forms

noreply@blogger.com (Unknown) — Thu, 24 Dec 2009 10:35:00 +0000

In App.xaml.cs have declared some application level variables as follows,

private string valueToPass

public string valTo
{
   get
   {
       return valueToPass;
   }

   set
   {
       valueToPass = value;
   }
}

page1.xaml.cs

App ap = (App)Application.Current;
ap.valueToPass = "YourValue";

page2.xaml.cs

App ap = (App)Application.Current;
messageBox.show(ap.valueToPass);

How To wrap Text In silverlight DataGrid Column

noreply@blogger.com (Unknown) — Thu, 24 Dec 2009 04:41:00 +0000

Make your datagrid AutoGenerateColumns="False" , then do the following changes to wrap text in the datagrid coloumn

<data:DataGridTemplateColumn Header="Your Header" Width="150">
         <data:DataGridTemplateColumn.CellTemplate>
                 <DataTemplate>
                        <TextBlock TextWrapping="Wrap" Text="{Binding Your_Data_Display}" />
                 </DataTemplate>
        </data:DataGridTemplateColumn.CellTemplate>
</data:DataGridTemplateColumn>

Silverlight The type or namespace name 'IValueConverter' could no

noreply@blogger.com (Unknown) — Wed, 23 Dec 2009 05:52:00 +0000

While Using Silverlight if you are getting the following Error "The type or namespace name 'IValueConverter' could not be found (are you missing a using directive or an assembly reference?)" Just Include namespace System.Windows.Data; in your code behind.

Silverlight The type or namespace name 'BitmapImage' could not be

noreply@blogger.com (Unknown) — Wed, 23 Dec 2009 05:49:00 +0000

While Using Silverlight if you are getting the following Error "The type or namespace name 'BitmapImage' could not be found (are you missing a using directive or an assembly

reference?)" Just Include namespace System.Windows.Media.Imaging; in your application

How To Pass values from iframe to Controls In parent Document

noreply@blogger.com (Unknown) — Mon, 07 Dec 2009 09:37:00 +0000

if(parent.document.Yourformname.YOurfieldname != null){

parent.document.Yourformname.YourfieldId.value = SetYourValue;
}

For Div Content

if(parent.document.all["DIVName"] != null){

parent.document.all["YourDIVName"].innerHTML = SetYourValue;
}

How to call the function with parameter in iframe

noreply@blogger.com (Unknown) — Mon, 07 Dec 2009 09:24:00 +0000

var objIFrame = document.frames["ifrmId"];
    if ((objIFrame ) && (objIFrame .fnNameInIframe)) {
        objIFrame .fnNameInIframe(Param1);
    }

Whats The Difference Between Manifest and Metadata

noreply@blogger.com (Unknown) — Thu, 03 Dec 2009 08:46:00 +0000

Metadata describes contents in an assembly, classes, interfaces, enums, structs, etc.

Manifest describes an assembly itself, Assembly name version number, culture, strong name, etc.

How To Find The Number Of Live Connection In Database

noreply@blogger.com (Unknown) — Fri, 20 Nov 2009 04:12:00 +0000

SELECT DB_NAME(dbid) AS db, COUNT(dbid) AS connection FROM SYS.SYSPROCESSES WHERE dbid > 0
GROUP BY dbid

How To Duplicate Tab Or Clone Tab In Firefox

noreply@blogger.com (Unknown) — Mon, 16 Nov 2009 10:05:00 +0000

Just press the Ctrl key And drag The corresponding tab which is to Clone or duplicate

Supported By Firefox 3.x