Author Archive

Issue: Password field returned empty in edit mode

January 4, 2019 Leave a comment

This is as per design. Passwords are not filled to prevent accidental resubmits, and to prevent the page from containing unencrypted passwords.

Here is the solution

@Html.PasswordFor(model => model.Password,new{@Value=Model.Password})

@Html.PasswordFor(model => model.Password, new { placeholder = "********" })

This will put some 'visual' asterisks in the input box which will be disappeared when the user starts entering an actual value.

Hope this help!

Categories: Tips & Tricks

Load XML from URL giving an error (The remote server returned an error: (401) Unauthorized.)

November 1, 2018 Leave a comment

If you are getting a 401 Unauthorized error while reading an XML from URL, here is the solution you can try


Hope this help!

Categories: ASP.NET Tags: , ,

How to use Variable in MySQL Like Clause ?

October 24, 2018 Leave a comment

Here is an example to use SQL variable in the mysql select query like clause

SET @name = 'advancewebsoftware';

SELECT * from `user` WHERE name LIKE CONCAT('%', @name, '%');

Hope this help!


Categories: Sql Server Tags: , ,

Error :(System.Web.UI.HtmlControls.HtmlIframe) is not compatible with the type of control (System.Web.UI.HtmlControls.HtmlGenericControl) in VS2017

Reason for the above error is I have my project in .NET framework 3.5 and I update it to .NET framework 4.5,

Solution for the above error is:
We need to change the *.designer.cs file reference from:




Categories: ASP.NET

MySQL : The user specified as a definer (‘root’@’%’) does not exist

This error occurs when exporting views/triggers/procedures from one database or server to another as the user that created that object no longer exists.

So here are the solutions:

  • Change DEFINERCreate the missing user
  • Create the missing user

or simply run following query

grant all on *.* to ‘root’@’%’ identified by ‘password’ with grant option;

Hope it helps.

Categories: ASP.NET

MySQL : The host localhost does not support SSL connections

When I moved database MySql.Data 7.0.7 to 8.0.8. I got following error

The host localhost does not support SSL connections.

So, here is the solution for this error ,Just add SslMode=none in connection string

server=localhost;user id=roor;password=xyz;persistsecurityinfo=True;port=123;database=TestDB; SslMode=none

Hope it helps !

Categories: ASP.NET, Sql Server

How to Add space and increase width of Morris.Js Bar?

There are two properties of Morris.Js bar we can use to achieve this
1) barGap
2) barSizeRatio

barGap is an integer that sets the space between bars in a single bar group.
Default is 3.
Increase this value to space them further, decrease it to bring them closer.

barSizeRatio is the proportion of the width of the entire graph given to bars. Defaults to 0.75.
Increase the number closer to 1 to make the bars wider, if its =1 the bars will take up the entire graph, if its > 1 bars will overlap.

Here is an example of code

element: ‘bar-chart’,
data: [
{ y: ‘Apr’, a: 75, b: 60, c: 5, d: 50 },
{ y: ‘May’, a: 180, b: 220, c: 140, d: 160 },
{ y: ‘June’, a: 420, b: 340, c: 350, d: 270 }
xkey: ‘y’,
ykeys: [‘a’, ‘b’, ‘c’, ‘d’],
labels: [‘A’, ‘B’, ‘C’, ‘D’],
barColors: [‘#0B62A4′,’#f75b68′,’#4DA74D’,’#646464′],
hideHover: ‘auto’

Hope it helps!

Categories: ASP.NET Tags: , , ,