Straight It solutions: 2016

2016/08/12

How to convert types in C# implicitly ?

2016/08/09

How to customize Visual Studio colors in theme ?

https://www.youtube.com/watch?v=55gyTzWGWEM

To change dots in TextEditor change this property Text Editor -> Operator -> Foreground

2016/07/26

How to generate C# classes from xml in Visual Studio ?

Copy xml to clipboard
Open Visual Studio -> create class file -> remove class definition -> edit menu -> Paste special -> Paste XML As Classes
Replace typeA[][] to List<TypeA>

2016/07/24

How to change XAMPP apache server port?

http://stackoverflow.com/a/21914920

2016/07/22

How to change destination folder for NuGet packages ?

Create nuget.config in directory with solution.
Paste this code to it.

2016/07/16

How to return value to C# from t-sql stored procedure using dapper ?

2016/07/08

How to safly change name of column ?

2016/07/07

How to download site via https with tls 1.0 ?

2016/07/05

How to convert datetime with zone from varchar to datetimeoffset ?

2016/06/30

How to merege n files from directory to one txt file ?

copy *.* output.txt

2016/06/17

How to create windows forms application using visual studio 2015 c++ ?

Create new project: CLR Empty Project ?
Add new item: UI -> Windows Form
Set this options in project properties: Configuration Properties -> Linker -> System -> SubSystem -> WINDOWS (/SUBSYSTEM:WINDOWS); Configuration Properties -> Linker -> Entry Point: main
Your form .cpp file you should look like this:

-------------------------------------------------------------
#include "MyForm.h"

using namespace System;
using namespace System::Windows::Forms;

[STAThread]
void main(array^ args)
{
Application::EnableVisualStyles();
Application::SetCompatibleTextRenderingDefault(false);
mach2gamessnake::MyForm form;
Application::Run(%form);
}
-------------------------------------------------------------

2016/06/12

How to create remote Git repository in Visul Studio using visualstudio.com ?

[Attention: This is not full description]
1/ Create online repository
2/ Connect to repo from Visual Studio
3/ Clone repo locally to empty folder
4/ Create solution under repo control (add manually or create from TeamFoundation tab)

2016/05/25

How to run Remote Desktop under Windows 10 ?

1/ Run Windows command prompt: Ctrl + Windows 2/ From command prompt run command: mstsc.exe

2016/05/16

How to remove leading and trailing strings from dtring in c# ?

How to drop procedure if exists in SqlServer ?

How to drop table if exists in SqlServer

How to create schema if not exists in SqlServer ?

2016/05/09

How to add existing resource file to project in c# ?

1. Install Add-in for Visual Studio: File nesting 2. Add root file and designer file 3. Right click on slave file -> File nesting -> Nest item

How to add existing WinForm to poject in C# ?

1. Select project -> Right click -> Add -> Existing item.. -> select root file -> Add as link

2016/03/21

How to convert string list to table in Sql Server \ t-sql ?

How to compare 2 strings in a safe way ?

2016/03/16

How to stretch image to window size in CSS

2016/02/29

X509Certificate utils class

Download and add reference to BouncyCastle library: http://www.bouncycastle.org/csharp/

2016/02/28

How to attach debuger to NetBeans PHP ?

https://www.youtube.com/watch?v=HbJOP0YcSjs

2016/02/26

How to generate random double from range in c# ?

2016/02/21

How to force prestashop see all css from theme and moduls running

Change
- /themes/.htaccess
- /modules/.htaccess
from

<FilesMatch "\.tpl$">
Deny from all
</FilesMatch>

to

#<FilesMatch "\.tpl$">
#Deny from all
#</FilesMatch>

2016/02/14

How to generate c# classes from xml ?

xsd is available in systems with .net installed.
Usually here: C:\Program Files (x86)\Microsoft SDKs\Windows\
fg. C:\Program Files (x86)\Microsoft SDKs\Windows\v8.1A\bin\NETFX 4.5.1 Tools\x64\xsd.exe

D:\temp>xsd test.xml
D:\temp>xsd test.xsd /classes

Solution found here: http://stackoverflow.com/a/4203551

Sometimes you will have to change generated cs files fg change double dimension array type [][] to []

2016/02/13

How to unzip files on remote server using browser and PHP ?

2016/02/11

Resharper shortcuts

Shortcut	Meaning
ctrl + shift + v	Recent clipboard items
alt+end \| Ctrl + click on class, method -> derived symbols \| Navigate -> Derived symbosl	Show all object that inherit from class or override methods

2016/02/10

How to compare sql server databases structure and data ?

Install SQL Server Data Tools component https://msdn.microsoft.com/en-us/library/hh272686(v=vs.103).aspx in your Visual Studio version.
Show Sql Server Object Explorer in Visual Studio - View -> SQL Server Object Explorer
Connect to server where one of your db is maintained in SQL Server Object Explorer Window
Right click on the database and choose "Schema compare.." or "Data comparison"