Advertisements

Archive

Author Archive

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

xml

Hope this help!

Advertisements
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:

System.Web.UI.HtmlControls.HtmlIframe

to

System.Web.UI.HtmlControls.HtmlGenericControl

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

Morris.Bar({
barGap:4,
barSizeRatio:0.55,
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: , , ,

How to fix function is ambiguous in the namespace ‘system’ compiler error


When you are upgrading your project framework its possible that old version of DLL reference still exists , to remove that follow the below steps

-Open Object Explorer in Visual Studio
-Find that function
-Find the function/dll which has old reference and delete it

Hope it helps!

Categories: ASP.NET