Sign in

Knowledge grows when shared

Hi guys, as you know SQL express is not supporting agent services so we can schedule our jobs, but windows has a feature “Task Scheduler”. This is our hope :)

First of all, I create a folder on C disk, the name is DatabaseBackup than crate two folders inside of…

Hi Guys, today I want to speak about my search box problem, when you type something in the text area, you can combine this with 3 javascript events which are

  • The onKeyDown event is triggered when the user presses a key.
  • The onKeyUp event is triggered when the user releases…

Hi everyone, Today I want to speak about how eCommerce web pages define a price filter on their pages.

Its a small prices category example

Hi, I want to say something about output formatter because if someone doesn't know the term of this maybe can find it by searching words.

If you want to download an excel from your backend. You can implement an excel file and you can send it to your front end.

Hi Guys, today I want to explain time problems as I am known. When you use javascript on your front end, you will use the javascript time property.

In my case, I used

  • angular.js on the front end
  • .net 5 on the back end
  • SQL server 12.0 sp2 on db

Fast and Fast

Hi guys, I am currently working on how to speed up ef core?

I found first, asnotracking feature

DbConn db = serviceProvider.GetService<DbConn>();
var Animals = db.Animals;
var Animals2 = db.Animals.AsNoTracking().ToList();

What is differences Animals vs Animals2 ?

EF is caching all entities that you have done, then when you use SaveChanges feature, it will append all changes…

Given a time in -hour AM/PM format, convert it to military (24-hour) time.

Note: — 12:00:00AM on a 12-hour clock is 00:00:00 on a 24-hour clock.
- 12:00:00PM on a 12-hour clock is 12:00:00 on a 24-hour clock.


  • “12:01:00PM”

Return ‘12:01:00’

  • “12:01:00AM”

Return ‘00:01:00’

static string timeConversion(string s) {
// s= "12:01:00PM";
int hour = (Int16.Parse(s.Substring(0,2)));
if(s.Substring(8,2)== "AM" && hour==12 ) {hour=0;}
if(s.Substring(8,2)== "PM" && hour!=12 ) {hour= (hour + 12)%24;}
return hour.ToString().PadLeft(2, '0') + s.Substring(2,6);

this c# codes which I tried to finish with a minimum if condition

Hi Guys,

I am solving problems in hackerrank, I am improving my skills, I shared one of my solutions for a counting problem.

Most of the users when need to count elements in the array. …

Hi, today I want to speak about the re-index in the SQL server. Indexes are thrown for fast access in SQL Server but sometimes they lose their characteristics as the data changes over time and needs maintenance.

Firstly you should know indexing everything is not a good idea and secondly…

Hi guys, I want to read an excel file which was ‘xls’ I had always that issue

in Object explorer>Server Objects>Linked Servers>Providers>Microsoft.ACE.OLEDB.12.0>properties

then you have to enable dynamic parameters and allow in-process

if there is no option inside linked servers you should do that

SQL Server 2019C:\Windows\SysWOW64\SQLServerManager15.msc

SQL Server 2017C:\Windows\SysWOW64\SQLServerManager14.msc

SQL Server 2016C:\Windows\SysWOW64\SQLServerManager13.msc

SQL Server 2014(12.x)C:\Windows\SysWOW64\SQLServerManager12.msc

SQL Server 2012 (11.x)C:\Windows\SysWOW64\SQLServerManager11.msc

you can paste last to run window

windows + r then paste which version of sql you have like SQLServerManager15.msc

if you are getting a transport level error when executing openrowset you should update the access database engine

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.16.0','Excel 12.0;Database=C:\adress\products.xlsx;HDR=no','SELECT * FROM [sheetname$]')SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0 Xml;Database=C:\adress\products.xlsx;', sheetname$);SELECT * FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0','Data Source=C:\adress\products.xlsx;Extended Properties="Excel 12.0;IMEX=1;HDR=YES;"')...[sheetname$];


Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store