Skip to content

ErcanOPAK.com

  • ASP.Net WebForms
  • ASP.Net MVC
  • C#
  • SQL
  • MySQL
  • PHP
  • Devexpress
  • Reportviewer
  • About

Month: March 2023

C#

How to use TrimEnd to remove last character from string in C#

- 11.03.23 | 11.03.23 - ErcanOPAK comment on How to use TrimEnd to remove last character from string in C#

string useOfTrimEnd1= “Hello World !”.TrimEnd(‘!’); OUTPUT: Hello World string useOfTrimEnd2= “Hello World !!!!!!”.TrimEnd(‘!’); OUTPUT: Hello World Definition from Microsoft.com: TrimEnd(Char) Removes all the trailing occurrences of a character from the current string. TrimEnd() Removes all the trailing white-space characters from the current string. TrimEnd(Char[]) Removes all the trailing occurrences of a set of characters specified […]

Read More
C#

What is the difference between “int” and “uint” / “long” and “ulong”?

- 10.03.23 | 10.03.23 - ErcanOPAK comment on What is the difference between “int” and “uint” / “long” and “ulong”?

The primitive data types prefixed with “u” are unsigned versions with the same bit sizes. Effectively, this means they cannot store negative numbers, but on the other hand, they can store positive numbers twice as large as their signed counterparts. The signed counterparts do not have “u” prefixed.   The limits for int (32-bit) are: […]

Read More
SQL

How to solve the stucking on “Loading Packages” phase for SSMS installation

- 10.03.23 - ErcanOPAK comment on How to solve the stucking on “Loading Packages” phase for SSMS installation

to fix this problem: remove temp files from %temp% folder (C:\Users<user name>\AppData\Local\Temp) open the register and remove “HKLM\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server Management Studio” or execute via cmd (with admin rights): reg DELETE “HKLM\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server Management Studio” /reg:32 run install with admin rights NOTE: Just for those who don’t know register just open CMD as an […]

Read More
March 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  
« Feb   May »

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (668)
  • Get the User Name and Domain Name from an Email Address in SQL (660)
  • How to select distinct rows in a datatable in C# (513)
  • Add Constraint to SQL Table to ensure email contains @ (428)
  • Average of all values in a column that are not zero in SQL (351)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (329)
  • Find numbers with more than two decimal places in SQL (307)
  • Confirm before process with ASPxButton in Devexpress (305)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (281)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (279)

Recent Posts

  • How to remove all non alphanumeric characters from a string in C#
  • How to get the Xth Day of the Week of the Year in C#
  • How to get formatted JSON in C#
  • How to convert JSON to XML or XML to JSON in C#
  • How to use OUTPUT for Insert, Update and Delete in SQL
  • How to get the first and last date of the current year in SQL
  • How to solve extra blank page at end of Microsoft Reportviewer
  • How to Use Picture-in-Picture in Chrome Browser
  • How to add some content to the right side of CardHeader on Bootstrap
  • How to change star rating color on mouseover/out, mouseenter/leave with Javascript

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (668)
  • Get the User Name and Domain Name from an Email Address in SQL (660)
  • How to select distinct rows in a datatable in C# (513)
  • Add Constraint to SQL Table to ensure email contains @ (428)
  • Average of all values in a column that are not zero in SQL (351)

Recent Posts

  • How to remove all non alphanumeric characters from a string in C#
  • How to get the Xth Day of the Week of the Year in C#
  • How to get formatted JSON in C#
  • How to convert JSON to XML or XML to JSON in C#
  • How to use OUTPUT for Insert, Update and Delete in SQL

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter

© 2023 ErcanOPAK.com

Proudly powered by WordPress | Theme: Xblog Plus by wpthemespace.com