select from table distinct column

SELECT * FROM TABLE WITH DISTINCT COLUMN
---------------------------------------------------------------

SELECT * FROM [TABLE NAME]
WHERE [ID] IN (
  SELECT MIN([ID]) FROM [TABLE NAME] GROUP BY [DISTINCT COLUMN NAME])

Example:

       SELECT * FROM [SKILLS] WHERE [ID] IN
       (
      SELECT MIN([ID]) FROM [SKILLS] GROUP BY [SKILL NAME]
       )

string split using jquery / java script

var a = "one,two,three".split(",") // Delimiter is a string
for (var i = 0; i < a.length; i++)
{
alert(a[i])
}

var b = "1+2=3".split(/[+=]/) // Delimiter is a regular expression
for (var i = 0; i < b.length; i++)
{
alert(b[i])
}

500 Internal Server Error” when adding HttpModule in my Web.config

use the following new module syntax made for IIS7 (godaddy is using IIS7 for windows hosting)

<configuration>
   <system.webServer>
      <modules>
         <add name="Header" type="Contoso.ShoppingCart.Header"/>
      </modules>
   </system.webServer>
</configuration>

here details about module tag  

Differences Between WCF and ASP.NET Web Services

Login failed for user 'IIS APPPOOL\ASP.NET v4.0'

Set Identity : LocalSystem


You can change the ApplicationPoolIdentity from IIS7 -> Application Pools -> Advanced Settings.

How to Draw Text on an Image c#

Bitmap myBitmap = new Bitmap("C:\\myImage.jpg");

Graphics g = Graphics.FromImage(myBitmap);

StringFormat strFormat = new StringFormat();
strFormat.Alignment = StringAlignment.Center;
strFormat.LineAlignment = StringAlignment.Center;
g.DrawString("My\nText", new Font("Tahoma", 20), Brushes.White,
    new RectangleF(0, 0, 500, 500), strFormat);

myBitmap.Save("C:\\myImage1.jpg");

Highlight Asp.net Gridview Rows on MouseOver in jQuery

<script type="text/javascript">

$(document).ready(function() {

$('#gvrecords tr:has(td)').mouseover(function() {

$(this).addClass('highlightRow');

});

$('#gvrecords tr').mouseout(function() {

$(this).removeClass('highlightRow');

})

})

</script>

<style type="text/css">

.highlightRow

{

background-color:#FFCC00;

text-decoration:underline;

cursor:pointer;

}

</style>

$('#gvrecords tr:has(td)').mouseover(function() {

By using this we are identifying row tr with td and applying css style for gridview. Instead of this we can write the code like this

$('#gvrecords tr').mouseover(function() {

But above code will apply css style for gridview header also for that reason we written above code to identity and apply css style for row tr with td