2023-05-29 17:51
Right Click Sheet1 and click on View Code
Select Worksheet from drop-down
Type Cells.EntireColumn.AutoFit and close VBA
Enjoy! You are good to go Read More
Blog Directory > Blogging Blogs > BUG FIXES AND CODING SOLUTIONS blogging Blog >
Bug Fixes And Coding Solutions Blog
bugs.code.blog
My personal blog that addresses coding bugs and coding solutions particularly related to technologies like asp.net, html, javascript,PHP, MVC, C#, SQL
2022-09-17 00:02
This Month we bring you the great Domains that are:
on Sale
of Great Value with minimum or Zero bids so you become one of the first ones to bid on them
Domain NameWhy It’s GreatL… Read More
2022-08-24 22:41
Cause
It uses an older debugging engine which causes the problem. In other words, it is caused when you compile a 32-bit assembly and try to use it from a 64-bit process.
Solution… Read More
2022-08-16 01:19
Sometimes, Videos You never watched are in your liked video playlist on YouTube, It might be due to some malware or chrome extension deliberately doing it. However, If you want to empty the… Read More
2022-03-17 16:34
Solution:
If you intend to create a table without a primary key in the database just add [Keyless] before class name
as follows:
[Keyless]
public class DisplayDetails
{
}
You mi… Read More
2022-03-15 16:25
The solution is simple. Just force to remove the migration by typing this command in the package manager console and the migration will be removed:
Remove-Migration -Force Read More
2022-02-12 18:15
This issue occurs when we copy paste the entire code to the new file and we forget to change the name of namespace. After pasting the code to new file, change this line:
namespace Project… Read More
2022-02-08 21:23
Check the .net versions of all your projects in the solution explorer. In my case, it was .net 6.0.1 in 2 projects and .net 6.2.0 in the 3rd project so I changed the version of the third… Read More
2021-07-03 15:40
This Month we bring you the great Domains that are:
on Saleof Great Value with minimum or Zero bids so you become one of the first ones to bid on themDomain NameWhy It’s GreatLink w… Read More
2021-06-01 15:14
This Month we bring you the great Domains that are:
on Saleof Great Value with minimum or Zero bids so you become one of the first ones to bid on themDomain NameWhy It’s GreatLink w… Read More
2021-05-17 19:53
We list 3 domains monthly that are
on Saleof Great Value with minimum or Zero bids so you become one of the first ones to bid on themDomain NameWhy It’s GreatLink where you can pla… Read More
2021-04-04 00:24
We weekly list 3 domains that are
on Saleof Great Value with minimum or Zero bids so you become one of the first ones to bid on themDomain NameWhy It’s GreatLink where you can plac… Read More
2021-01-30 14:23
Uncompressing C Drive or any drive is as ease as compressing the drive. Just follow these simple to uncompress C Drive:
Right click the drive to uncompress. (C Drive in our case).Click on… Read More
2020-09-15 18:49
Sometimes we receive 404 not found error on a particular page of our WordPress website when we open it on another device than the device we are creating our website on.
No worries! It ca… Read More
Easiest Way To Run Command Prompt From A Particular Drive Without Writing Commands In Command Prompt
2020-08-06 18:46
Yes, you can run command prompt from a particular drive without writing any command in command prompt. Follow these easiest steps:
Open the drive in File Explorer where you want to run y… Read More
2020-03-21 20:05
I know there are lots of articles on how to o Free up disk space and some of them ask you to download special softwares for that. But a layman or a non-computer expert and other lazy people… Read More
2020-03-14 20:30
Are you the one who always closes a tab or tabs accidentally and realize later how important it was? Tired of this hassle? Just adopt 1 useful habit of pinning the tab.
In the middle of a… Read More
2020-03-05 20:23
PizzaCodes.com is a site to go. Yes, you tell your location and the site will tell you some amazing pizza coupon codes based on your location. Give it a try and thank me later Read More
2020-03-02 20:50
win + e
Hit windows key + E to immediately open windows explorer. It works faster then the mouse as you don’t have to search for the icon to click. In the middle of doing anything… Read More
2020-02-28 20:00
Ever heard of erasing a text on image while opened in a browser, or editing it? Don’t get shocked! You can actually do that when you browse an image using a browser extension Project&n&hell…Read More
2020-02-27 18:27
In the middle of a movie or something and there is no pen or paper around but want to note down something immediately?
Just type “” in the address bar (without the inverted co… Read More
2020-02-26 16:06
Just type % appdata% in the search bar of your windows explorer and hit Enter
You will automatically get to roaming folder which actually resides in the hidden folder AppData like this:… Read More
2019-09-07 16:55
what is mean?
Are you a web developer? Curious to know about Mean? Here you go!
Well, MEAN stands for Mongo DB, Express, Anguar JS, Node.js. MEAN is an end-to-end JavaScript stack larg… Read More
2019-08-25 15:14
CDN – abbreviation of Content Delivery Network is a system or network of computers that exist worldwide and cache files for users to access. Web developers all over the world can lever… Read More
2019-08-24 19:19
As we know that JavaScript statements are executed line by line. But, if the effects are applied, the next line of code can be run even before the finishing of the current effect which can c… Read More
2019-08-22 17:07
Among several effects, there also exists animation in jquery. Yes, we can also animate a jquery element such as a div or button using the animate() method.
Syntax
$(selector).animate({… Read More
2019-08-21 17:50
.each() iterates for each matched element.
Syntax
$(selector).each(function(index,element))
For example, in the following piece of code, on the click of button, text of each list… Read More
2019-08-19 16:39
C# Code
using System;
namespace ReverseNumber
{
class Program
{
static void Main(string[] args)
{
Console.WriteLine("Enter a Number to… Read More
2019-08-17 16:21
C# Code
using System;
namespace reverseString
{
class Program
{
static void Main(string[] args)
{
string strng = "", reverse = "";… Read More
2019-08-04 19:14
Differences
POINTERREFERENCEIs a variable that holds memory address of another variable. // int *ptr = &i; Is an alias i.e. another name for an already existing variable. // int &am&helli…Read More
2019-07-20 16:19
This regular expression will not verify if the particular email id exists or not. Instead, this regex is to validate the format of email id
In jquery
var ValidateEmail= function (emai… Read More
2019-07-19 18:33
Using jQuery, We can chain together actions/methods as it allows us to run multiple jQuery methods/actions on the same element using just a single statement. We can chain the methods togethe… Read More
2019-07-17 17:25
There are four main fading effects in jQuery that can be applied to the HTML elements. They can be applied using these 4 methods:
fadeIn() //to fade in a hidden element
fadeOut() //to fad… Read More
2019-07-15 18:04
Most of the times, these methods are confused with each other or are thought of as performing the same functionality. But,remove() removes the selected element and all its child element… Read More
2019-07-13 16:39
The slideToggle() method toggles between the slideUp() and slideDown() methods. If an element is slid up, slideToggle() will slide it down and vice versa.
Syn… Read More
2019-07-12 19:35
We can show and hide HTML elements with the show()and hide methods in jquery. A simple example is as follows
Example
$("#hide").click(function(){
$("p").hide();
});
$("… Read More
2019-07-09 17:34
A hashing algorithm is a mathematical function that shortens the data to a fixed size.
example
Input
“The Quick Brown Fox Jumps Over The White Lazy Dog”
MD5 Hashing… Read More
2019-07-07 20:55
Dangling pointers
Dangling pointers arise when an object is destroyed. Despite being deleted or de-allocated, it still has an incoming reference because the value of the pointer… Read More
2019-07-04 20:02
A void pointer or generic pointer is a special pointer that can point to objects of any datatype. It is declared just like a normal pointer by using void keyword at the time of declaration… Read More
2019-07-03 19:59
There is a lot of confusion about the size of the pointers based on datatypes. A usual question is if there is a difference of size in:
int *p;
char *p;
string *p;
The answer is simp… Read More
2019-06-29 20:39
Declaration of a pointer
int *p;
int a=10;
int is not the datatype of pointer as pointer points to the address of the memory location. Therefore, it is the data type of the content sto… Read More
2019-06-24 20:13
These 3 types are used to store any type of data in C#. It means type of variable is decided at the compile time by the compiler and it has all information about the stored value to avoid a… Read More
2019-06-23 22:00
Boxing
Boxing means to convert any value-type to object type or to any interface type implemented by this value type. When the CLR boxes a value type, it wraps the value inside a Sy… Read More
2019-06-22 23:54
Having clause is used after group by clause whereas where clause is used before group by clauseHaving clause is used to filter the groups and where clause is used to filter rows Syntax
se… Read More
2019-06-21 18:16
It is a constructor that creates an object by copying variables from another object of same class or we can simply say that it copies the data from one object into another obj… Read More
2019-06-05 22:30
in Header
using GemBox.Spreadsheet;
CODE
var workbook = ExcelFile.Load("ContactNumbers.xlsx");
workbook.Save("Convert.pdf");
Yes, it is that simple to convert excel file… Read More
2019-06-03 20:43
var workbook = ExcelFile.Load("officeDials.xlsx");
var worksheet = workbook.Worksheets[0];
worksheet.PrintOptions.PrintHeadings = true;
worksheet.PrintOptio… Read More
2019-06-01 20:39
var workbook = ExcelFile.Load("MyWorkbook.xls");
var worksheet = workbook.Worksheets.ActiveWorksheet;
MessageBox.Show(worksheet.Cells["A1"].GetFormattedValue());
EXPLANATION
Excel file… Read More
2019-05-31 22:00
GemBox.Spreadsheet is an easy to use .NET component that enables us perform different operations with spreadsheet files such as reading, writing, editing, converting and pri… Read More
2019-05-30 23:45
STORED PROCEDURE
USE [DB_obj]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[sp_FillUserRoles]
-- Add the parameters for the stored procedure here
AS
BEGIN… Read More
Populate Dropdown List Based On Data Retrieved From Database In MVC Application (Controller And BLL)
2019-05-29 21:06
Controller
public JsonResult FillRoles()
{
return Json(BLLFile.FillUserRoles(), JsonRequestBehavior.AllowGet);
}
Code in BLL file
public static List FillUserRol… Read More
2019-05-28 17:45
View
jquery
function getRelation() {
$.ajax
({
url: "@(Url.Action("FillRoles", "Roles"))",
data: {},
success: fu… Read More
2019-05-27 17:14
View
jquery
function Save()
{
$.ajax
({
url: "@(Url.Action("SaveMember", "Members"))",
data: { name: $("#MemberName").val(),designation: $("#ddlD… Read More
2019-05-26 11:38
Button to Print as PDF
Print PDF
Button To print large PDF files
Print PDF with Message
Button to Print base64 PDF
Print PDF with Message Read More
Subscribe to Bug Fixes And Coding Solutions
Get updates delivered right to your inbox!