Category: Uncategorized

Got long forms on your website ? Break them up into smaller logical sections and convert it into a multi-step form with a cool progress bar. Could work for lengthy processes like registration, checkout, profile fillups, 2-factor authentication logins, etc. The form has 3 fieldsets containing the 3 different sections of the form. The fieldsets are absolutely positioned and only the first one is visible by default. Moving to the next section fades out the current fieldset using jQuery .animate() and brings in the next fieldset from the right. The…

The following steps will tell you if your database version supports full text searching and if so how to enable it. Open SQL server management console Right click on the database and select properties On the left select files If “Full-Text Indexing” is greyed out it means that full-text indexing is not enabled. NOTE: If you are using SQL Server 2012 Please see the SQL Server 2012 notes at the bottom of this article. How to enable Full Text Searching Click on the New Query button top left of the…

I was wondering how it’s possible to get the structure of one or more table(s) in a database, using possibly a SELECT; I need to retrieve the composition of the DB I’m working onto to attach it in some docs about the webapp I’m currently developing. SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS ORDER BY TABLE_NAME

If this is a one- time task, just open Object Explorer, expand your database > programmability and highlight the Stored Procedures node. Then turn on Object Explorer Details. On the right you should see your list, and here you can multi-select – so you can sort by name, choose all procedures that start with aspnet_, and delete them all with one keystroke. If you are doing this repeatedly, then (assuming your procedures are all in the dbo schema): DECLARE @sql NVARCHAR(MAX) = N”; SELECT @sql += N’DROP PROCEDURE dbo.’ +…

Introduction In this article I will explain how to encrypt or decrypt connection Strings in web.config file using asp.net. Description In Previous posts I explained lot of articles regarding Asp.net, Gridview, SQL Server, Ajax, JavaScript etc. In many of articles I used connection Strings section in web.config file to store database connection. The connection Strings section contains sensitive information of database connections including username and password of database. Is it secured to store the sensitive information of database connections in plain text files called web.config and machine.config files? If we…

I have a very simple solution. If you have a field in database in int format and you want to know how many seconds it’s, the query is: SELECT CONVERT(char(5), DATEADD(second, AVG(Avg_time), ‘20150101’), 108) as myAverageFROM         T_GoogleAnalytics_dataHAVING      (AVG(Avg_time) IS NOT NULL)

.xlsx application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.xltx application/vnd.openxmlformats-officedocument.spreadsheetml.template.potx application/vnd.openxmlformats-officedocument.presentationml.template.ppsx application/vnd.openxmlformats-officedocument.presentationml.slideshow.pptx application/vnd.openxmlformats-officedocument.presentationml.presentation.sldx application/vnd.openxmlformats-officedocument.presentationml.slide.docx application/vnd.openxmlformats-officedocument.wordprocessingml.document.dotx application/vnd.openxmlformats-officedocument.wordprocessingml.template.xlam application/vnd.ms-excel.addin.macroEnabled.12.xlsb application/vnd.ms-excel.sheet.binary.macroEnabled.12

This example shows how to detect whether a host name or IP address belongs to local computer. Get local computer name Get local computer host name using static method Dns.GetHostName. [C#] string localComputerName = Dns.GetHostName(); Get local IP address list Get list of computer IP addresses using static method Dns.GetHostAd­dresses. To get list of local IP addresses pass local computer name as a parameter to the method. [C#] IPAddress[] localIPs = Dns.GetHostAddresses(Dns.GetHostName()); Check whether an IP address is local The following method checks if a given host name or IP…

This example shows how to download files from any website to local disk. The simply way how to download file is to use WebClient class and its method DownloadFile. This method has two parameters, first is the url of the file you want to download and the second parameter is path to local disk to which you want to save the file. Download File Synchronously The following code shows how to download file synchronously. This method blocks the main thread until the file is downloaded or an error occur (in…

I’m VERY confused as to why this code Html.ActionLink(“About”, “About”, “Home”, new { hidefocus = “hidefocus” }) results in this link: <a hidefocus=”hidefocus” href=”/Home/About?Length=4″>About</a> The hidefocus part is what I was aiming to achieve, but where does the “?Length=4” come from? Solution The Length=4 is coming from an attempt to serialize a string object. Your code is running this ActionLink method: public static string ActionLink(this HtmlHelper htmlHelper, string linkText, string actionName, object routeValues, object htmlAttributes) This takes a string object “Home” for routeValues, which the MVC plumbing searches for public…

This is another post which was inspired by a recent question in the ASP.NET forums, when someone asked what the difference is between @functions and @helpers in ASP.NET Web Pages. Here, I look at both of these contructs and explain what they are, how they are different, and how each should be used appropriately. Both @helpers and @functions do share one thing in common – they make code reuse a possibility within Web Pages. They also share another thing in common – they look the same at first glance, which…

Introduction Working with images in a web application can turn from a simple task to a complexity in need of some serious attention as soon as traffic starts to grow or image assets become too vast to reasonably maintain multiple versions of each (large, medium, thumbnail). A general reference to an image in a HTML img tag does not provide a way to control caching or additional headers like the ETag to help site speed performance, nor does it provide a true way to handle resizing (the use of the…

I have a textbox with a button inside. When the user presses the Action, a progress bas is displayed, the screen goes dark, and some magic happens. My problem is that since the action doesn’t result in the textbox losing focus, the on-screen keyboard is not hidden, and keeps covering half the screen. Just set focus to the main page: this.Focus(); this will focus a control that doesn’t use the keyboard and thus hide the keyboard. Unfortunately there is no API to the keyboard to hide it.

Windows Phone 8.1 Dev Preview Windows Phone 8.1 developer preview is totally awesome. So what is one of the most important things app devs can do right away, without much fuss, to make their apps look great with Windows Phone 8.1? Revisit your app’s Live Tile images. Why? In 8.1, Start screen is mesmerizing with the parallax effect and Live Tile with background overlay. Dev preview users are going crazy with new Start experience, and I am sure, with public release, end users are going to love to have background…