Author: ErcanOPAK

ASP.Net MVC / ASP.Net WebForms

How to add Output Parameter to SqlDataSource

- - ErcanOPAK comment on How to add Output Parameter to SqlDataSource

<asp:Parameter Name=”NewID” Direction=”Output” Type=”Int32″ DefaultValue=”0″ /> Here is a more detailed example in use: <asp:sqlDataSource ID=”EmployeeDetailsSqlDataSource” SelectCommand=”SELECT EmployeeID, LastName, FirstName FROM Employees WHERE EmployeeID = @EmpID” InsertCommand=”INSERT INTO Employees(LastName, FirstName) VALUES (@LastName, @FirstName); SELECT @EmpID = SCOPE_IDENTITY()” UpdateCommand=”UPDATE Employees SET LastName=@LastName, FirstName=@FirstName WHERE EmployeeID=@EmployeeID” DeleteCommand=”DELETE Employees WHERE EmployeeID=@EmployeeID” ConnectionString=”<%$ ConnectionStrings:NorthwindConnection %>” OnInserted=”EmployeeDetailsSqlDataSource_OnInserted” RunAt=”server”> <SelectParameters> <asp:Parameter […]

Read More
SQL

How to get stored procedure parameters details in SQL

- - ErcanOPAK comment on How to get stored procedure parameters details in SQL

select ‘Parameter_name’ = name, ‘Type’ = type_name(user_type_id), ‘Length’ = max_length, ‘Prec’ = case when type_name(system_type_id) = ‘uniqueidentifier’ then precision else OdbcPrec(system_type_id, max_length, precision) end, ‘Scale’ = OdbcScale(system_type_id, scale), ‘Param_order’ = parameter_id, ‘Collation’ = convert(sysname, case when system_type_id in (35, 99, 167, 175, 231, 239) then ServerProperty(‘collation’) end) from sys.parameters where object_id = object_id(‘MySchema.MyProcedureName’)  

Read More
ASP.Net MVC / ASP.Net WebForms / C# / SQL

How to add default value for Entity Framework migrations for DateTime and Bool

- - ErcanOPAK comment on How to add default value for Entity Framework migrations for DateTime and Bool

When working with Code First Migrations, developers often struggle with setting default values at the database level. While you can set a default value in your C# class, doing it directly in the SQL schema is much more robust. Here is how you can achieve this using defaultValue and defaultValueSql. 1. Using Static Default Values […]

Read More
C#

String Interpolation, String Format, String Concat and String Builder in C#

- - ErcanOPAK comment on String Interpolation, String Format, String Concat and String Builder in C#

We will try to return a string like: “I can text whatever I want with 4 different options in C#. ” with String Interpolation, String Format, String Concat, and String Builder. public class StringOptions { private string data1 = “4”; private string data2 = “C#”; public string StringInterpolation() => ($”I can text whatever I want […]

Read More
SQL

How to get triggers create and update date in SQL

- - ErcanOPAK comment on How to get triggers create and update date in SQL

SELECT o.name as [Trigger Name], CASE WHEN o.type = ‘TR’ THEN ‘SQL DML Trigger’ WHEN o.type = ‘TA’ THEN ‘DML Assembly Trigger’ END AS [Trigger Type], sc.name AS [Schema_Name], OBJECT_NAME(parent_object_id) as [Table Name], o.create_date [Trigger Create Date], o.modify_date [Trigger Modified Date] FROM sys.objects o INNER JOIN sys.schemas sc ON o.schema_id = sc.schema_id WHERE (type = […]

Read More
C# / Visual Studio

How to make the default class type ‘public’ instead of ‘internal’ in Visual Studio

- - ErcanOPAK comment on How to make the default class type ‘public’ instead of ‘internal’ in Visual Studio

VS2012: C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\ItemTemplates\CSharp\Code\1033\Class VS2015: C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\ItemTemplates\CSharp\Code\1033\Class VS2017(RC): C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE\ItemTemplates\CSharp\Code\1033\Class VS2017(Professional): C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\Common7\IDE\ItemTemplates\CSharp\Code\1033\Class VS2019 (Enterprise): C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\IDE\ItemTemplates\CSharp\Code\1033\Class\Class.cs VS2019 (Professional): C:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE\ItemTemplates\CSharp\Code\1033\Class\Class.cs Starting with Visual Studio 2022 VS is a 64 bit application, meaning the item templates are in C:\Program Files\… instead of C:\Program Files […]

Read More
Windows

How to solve 0xc0000135 application errors after Windows 11 Update

- - ErcanOPAK comment on How to solve 0xc0000135 application errors after Windows 11 Update

Windows 11 users are receiving 0xc0000135 errors when attempting to launch applications after installing the recent Windows 11 KB5013943 cumulative update. Yesterday, Microsoft released new Windows cumulative updates to fix security vulnerabilities and bugs as part of the May 2022 Patch Tuesday. These updates include the Windows 11 KB5013943 update, which included fixing a bug causing .NET […]

Read More
ASP.Net MVC / ASP.Net WebForms / HTML

How to get the integrity value for a jquery version of script reference in a web page

- - ErcanOPAK comment on How to get the integrity value for a jquery version of script reference in a web page

You can use https://www.srihash.org/ to generate links. https://code.jquery.com/jquery-3.6.0.min.js will be generated as <script src=”https://code.jquery.com/jquery-3.6.0.min.js” integrity=”sha512-894YE6QWD5I59HgZOGReFYm4dnWc1Qt5NtvYSaNcOP+u1T9qYdvdihz0PPSiiqn/+/3e7Jo4EaG7TubfWGUrMQ==” crossorigin=”anonymous”></script> You can get all the versions of jquery from here: https://releases.jquery.com/jquery/ Thanks to mscdeveloper for such great post.

Read More
C#

How to lock the ciritical code part in C#

- - ErcanOPAK comment on How to lock the ciritical code part in C#

According to Microsoft: The lock keyword ensures that one thread does not enter a critical section of code while another thread is in the critical section. If another thread tries to enter a locked code, it will wait, block, until the object is released. The lock keyword calls Enter at the start of the block and Exit at the end of the block. lock keyword actually […]

Read More
Tips and Tricks

How to make theater mode the default for Youtube

- - ErcanOPAK 2 Comments on How to make theater mode the default for Youtube

Love the Theater Mode on YouTube but tired of clicking that button every single time? You don’t need to install heavy browser extensions or third-party software that might track your data. You can fix this with a single line of code in your browser’s console. The Logic Behind the Hack YouTube stores your player preferences […]

Read More
Tips and Tricks

How to hide Youtube chat windows permanently

- - ErcanOPAK comment on How to hide Youtube chat windows permanently

The easiest way to do that is using AdBlock. 1. Open your web browser and go to the Adblock Settings as shown. 2. Click on the Customize option in the left pane. 3. Here in the Customize AdBlock section, locate and click the Edit button next to Manually edit your filters. 4. Then, add the following links and click on the Save button. youtube.com###chat    

Read More
SQL

How to enable, disable and check if Service Broker is enabled on a database in SQL Server

- - ErcanOPAK comment on How to enable, disable and check if Service Broker is enabled on a database in SQL Server

The Context: SQL Server Service Broker is a powerful framework for building highly scalable, asynchronous database applications. Whether you are using Query Notifications, External Activations, or Distributed Messaging, knowing how to properly manage the Broker state is essential for any DBA or Backend Developer. The Challenge: Simply running an ALTER DATABASE command often hangs indefinitely […]

Read More
ASP.Net MVC / ASP.Net WebForms / HTML / JavaScript

Search text through Divs in Javascript

- - ErcanOPAK comment on Search text through Divs in Javascript

<table align=”center” width=”20%”> <tr> <td style=”padding-right: 10px”> <input type=”text” id=”Search” onkeyup=”myFunction()” placeholder=”Please enter a search term..” title=”Type in a name”> </td> </tr> </table> <br> <div class=”target”> This is my DIV element. </div> <div class=”target”> This is another Div element. </div> <div class=”target”> Can you find me? </div> <script> function myFunction() { var input = document.getElementById(“Search”); […]

Read More
SQL

How to check if recursive triggers are enabled in SQL

- - ErcanOPAK comment on How to check if recursive triggers are enabled in SQL

Recursive triggers are set at the database level. It’s part of the database metadata information and is available through “sys.databases” view. You can use the below query to check whether the recursive triggers are enabled or not on your database: SELECT name AS ‘Database’, is_recursive_triggers_on AS ‘Recursive Trigger Enabled’ FROM sys.databases Here is the output:

Read More
SQL

How to hide letters with asterisks except first letter in SQL

- - ErcanOPAK comment on How to hide letters with asterisks except first letter in SQL

The easiest way to do that is using a function CREATE FUNCTION [dbo].[HideNameWithAsterisks](@Name varchar(max)) RETURNS varchar(MAX) AS BEGIN DECLARE @loop int = LEN(@Name) WHILE @loop > 1 SELECT @Name = STUFF(@Name, @loop, 1, CASE WHEN SUBSTRING(@Name, @loop – 1, 2) like ‘% ‘ THEN ‘ ‘ WHEN SUBSTRING(@Name, @loop – 1, 2) like ‘ %’ […]

Read More
JavaScript

How replace characters with asterisks (*) except first characters

- - ErcanOPAK comment on How replace characters with asterisks (*) except first characters

const theName = “Vincent van Gogh”; function hideWord(word) { if (word.length < 2) return word; return word.substring(0, 1) + ‘*’.repeat(word.length-1); } console.log(theName.split(” “).map(hideWord).join(” “)); OUTPUT: V****** v** G*** You could also wrap the whole lot in a function if you wanted to be able to call it from multiple places and avoid redefining it. function […]

Read More
CSS

Hide element in CSS with Display and Visibility

- - ErcanOPAK comment on Hide element in CSS with Display and Visibility

visibility: hidden (Hide but keep the space) <div stlye=”visibility: hidden;”>The Components We want to Hide</div> By default, the value of the visibility property is visible. However, if you want to make an image invisible, you can set the value of visibility to hidden.   display: none (Hide and remove the space) <div stlye=”display: none;”>The Components We want to Hide</div> The display […]

Read More
Page 63 of 69
1 … 58 59 60 61 62 63 64 65 66 67 68 69