MS SQL 2008: How to Find the Nth Maximum and Minimum Value in a Column?

This post will explain about how to find the Nth Maximum and Minimum Value in a Column. There are several methods to find out the Nth maximum/minimum value using SQL. This article discusses on such method to find Nth maximum value from a desired table. Now write the following code:DECLARE @n INTSET @n=2SELECT USER_ID,username from( SELECT USER_ID,username,ROW_NUMBER() OVER(ORDER BY USER_ID...

How to Produce Text file in ASP.NET 4.6?

In this example we explain that how to produce text file in ASP.NET 4.6 or write data to the text file fetching from the database. Here usually we create new file and write data to text file from the database.below is code for creating text file and write data to it. fs1 = new FileStream(Server.MapPath("Files\\demo.txt"), FileMode.OpenOrCreate, FileAccess.Write); writer.Write("Name :"...

HostForLIFE.eu Launches New Data Center in Chennai (India)

HostForLIFE.eu, a leading Windows hosting provider with innovative technology solutions and a dedicated professional services team proudly announces a new Data Center in Chennai (India) for all costumers. HostForLIFE’s new data center in Chennai will address strong demand from customers for excellent data center services in Asia, as data consumption and hosting services experience continued...

Binding the Drop Down List Form Database

In the web development the drop down list is most vital tool, we have a tendency to Use several time and lots of places to use this for showing the list in hidden format. And to fill date in to this list, after we need on page the choose a particular item in this drop down list in to ASP.NET code.Now, I want to fill all class names in to drop down list that are store in the data base. For this a...

ASP.NET Hosting - How to Hide jQuery Dialog Modal Popup after AJAX Call Success ?

This post is about How to Hide jQuery Dialog Modal Popup after AJAX Call Success. HTML Markup The below HTML Markup consists of an HTML DIV containing a TextBox to enter some content, a Button for triggering jQuery AJAX call. <div id="dialog" style="display: none"><table border="0" cellpadding="0" cellspacing="0"><tr>    <td>       ...

Visual Studio Hosting Tips - How to Find PublicKeyToken of a DLL?

In this post, we will learn about how to find PublicKeyToken of a DLL that we add as a reference to our project. Today i used to be trying to see a public key of a DLL that I added to my MVC project. I learned that we can verify this by using our Visual Studio itself. Here i'm sharing that info and will use Visual Studio 2012.   Using the codeTo determine the DLL information, you need to...

HostForLIFE.eu Launches Cheap New Data Center in Frankfurt

HostForLIFE.eu, a leading Windows and ASP.NET hosting provider with innovative technology solutions and a dedicated professional services team proudly announces a new Data Center in Frankfurt (Germany) for all costumers. HostForLIFE’s new data center in Frankfurt will address strong demand from customers for excellent data center services in Europe, as data consumption and hosting services...