Programming and Web Development Help

Monday, 1 April 2013

Select table column name In SQL

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TableNameGoesHere'ORDER BY ORDINAL_POSITION

Saturday, 30 March 2013

asp.net grid view sorting in linq to sql

public void bindGrid()
{
REGISTRATIONDataContext objDB = new REGISTRATIONDataContext();
var listuser = (from p in objDB.REGISTRATIONs
select p).ToArray();

if (listuser != null)
{
if (GridViewSortDirection == SortDirection.Ascending)
{
GridView1.DataSource = listuser.OrderBy(x => x.GetType().GetProperty(GridViewSortExpression).GetValue(x, null)).ToList();
}
else
{
GridView1.DataSource = listuser.OrderByDescending(x => x.GetType().GetProperty(GridViewSortExpression).GetValue(x, null)).ToList();
};
}
else
{
GridView1.DataSource = null;
}
//GridView1.DataSource = listuser;
GridView1.DataBind();
}

public string GridViewSortExpression
{
get
{
return ViewState["GridViewSortExpression"] == null ? "NAME":ViewState["GridViewSortExpression"] as string;
}
set
{
ViewState["GridViewSortExpression"] = value;
}
}

public SortDirection GridViewSortDirection
{
get
{
if (ViewState["sortDirection"] == null)
ViewState["sortDirection"] = SortDirection.Ascending;

return (SortDirection)ViewState["sortDirection"];
}
set { ViewState["sortDirection"] = value; }
}

protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{

GridViewSortExpression = e.SortExpression;
if (GridViewSortDirection == SortDirection.Ascending)
{
GridViewSortDirection = SortDirection.Descending;
}
else
{
GridViewSortDirection = SortDirection.Ascending;
};
bindGrid();
}

Monday, 25 March 2013

html5 File Api & Read file in Javascript

<style>

  .thumb {
    height: 75px;
    border: 1px solid #000;
    margin: 10px 5px 0 0;
  }
</style>

<input type="file" id="files" name="files[]" multiple />
<output id="list"></output>

<script>
  function handleFileSelect(evt) {
    var files = evt.target.files; // FileList object

    // Loop through the FileList and render image files as thumbnails.
    for (var i = 0, f; f = files[i]; i++) {

      // Only process image files.
      if (!f.type.match('image.*')) {
        continue;
      }

      var reader = new FileReader();

      // Closure to capture the file information.
      reader.onload = (function(theFile) {
        return function(e) {
          // Render thumbnail.
          var span = document.createElement('span');
          span.innerHTML = ['<img class="thumb" src="', e.target.result,
                            '" title="', escape(theFile.name), '"/>'].join('');
          document.getElementById('list').insertBefore(span, null);
        };
      })(f);

      // Read in the image file as a data URL.
      reader.readAsDataURL(f);
    }
  }

  document.getElementById('files').addEventListener('change', handleFileSelect, false);
</script>

Sunday, 3 March 2013

The difference between trigger() and triggerHandler()

<!DOCTYPE html>
<html>
<head>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js">
</script>
<script>
$(document).ready(function(){
$("input").select(function(){
$("input").after(" Text marked!");
});
$("#btn1").click(function(){
$("input").trigger("select");
});
$("#btn2").click(function(){
$("input").triggerHandler("select");
});
});
</script>
</head>
<body>

<p>Click each button to see the difference between trigger() and triggerHandler().
<br><br>
<input type="text" value="Hello World">
<br><br>
<button id="btn1">trigger()</button>
<button id="btn2">triggerHandler()</button>

</body>
</html>

trigger() is call a internel code of select event and select a textbox
The trigger() method triggers the specified event and the default behavior of an event (like form submission) for the selected elements.

triggerHandler() is call internel code of select event ,but textbox is not select

Monday, 25 February 2013

Difference between IEnumerable VS IQueryable

IEnumerable

IEnumerable exists in System.Collections Namespace.
IEnumerable can move forward only over a collection, it can’t move backward and between the items.
IEnumerable is best to query data from in-memory collections like List, Array etc.
While query data from database, IEnumerable execute select query on server side, load data in-memory on client side and then filter data.
IEnumerable is suitable for LINQ to Object and LINQ to XML queries.
IEnumerable supports deferred execution.
IEnumerable doesn’t supports custom query.
IEnumerable doesn’t support lazy loading. Hence not suitable for paging like scenarios.
Extension methods supports by IEnumerable takes functional objects.

IQueryable
1. IQueryable exists in System.Linq Namespace.
2. IQueryable can move forward only over a collection, it can’t move backward and between the items.
3. IQueryable is best to query data from out-memory (like remote database, service) collections.
4. While query data from database, IQueryable execute select query on server side with all filters.
5. IQueryable is suitable for LINQ to SQL queries.
6. IQueryable supports deferred execution.
7. IQueryable supports custom query using CreateQuery and Execute methods.

Difference between disabled and read only attributes

Disabled attribute

Disabled form fields or elements values don’t post to the server for processing.
Disabled form fields or elements don’t get focus.
Disabled form fields or elements are skipped while tab navigation.
Some browsers (Like IE) provide default style (Gray out or emboss text) for disabled form fields or elements.

Read Only Attribute

Read Only form fields or elements values post to the server for processing.
Read Only form fields or elements get focus.
Read Only form fields or elements are included while tab navigation.
Some browsers do not provide default style for Read-Only form fields or elements.

Monday, 4 February 2013

jQuery-Selecting elements with uncommon / special characters in ID or class name

Just add double backslashes \\ before any of the special characters

HTML generated by some CMS or frameworks include elements with rather 
uncommon characters in ID or class names. For example, some may have 
special characters such as ‘.’ or ‘[..]’ in the ID or Class. To work 
around this, a selector in jQuery should be written this way:

Example 1

$("$title.id") // won't work for ID: title.id

$("$title\\.id") // works for ID: title.id

Example 2
$("$ title[id]") // won't work for ID: title[id]

$("$ title\\[id\\]") // works for ID: title[id]

Sunday, 6 January 2013

jQuery to Validate File Upload Extension in File Upload Control

$(function() {

$('#<%=fileupload1.ClientID %>').change(function() {

var fileExtension = ['jpeg', 'jpg', 'png', 'gif', 'bmp'];

if ($.inArray($(this).val().split('.').pop().toLowerCase(), fileExtension) == -1) {

alert("Only '.jpeg','.jpg', '.png', '.gif', '.bmp' formats are allowed.");

}

})

</script>

Tuesday, 1 January 2013

C# - Difference between Convert.tostring and .tostring() method

The basic difference between them is “Convert.ToString(variable)” handles NULL values even if variable value become null but “variable.ToString()” will not handle NULL values it will throw a NULL reference exception error.

Example

//Returns a null reference exception for str.

string strque;

object i = null;

strque = i.ToString();

//Returns an empty string for str and does not throw an exception.

string strque;

object i = null;

strque = Convert.ToString(i);

So as a good coding practice using “convert” is always safe.

Monday, 3 December 2012

Remove Elements Without Deleting Data in jquery

The new ".detach()" method allows you to remove elements from the DOM, much like the ".remove()" method. The key difference with this new method is that it doesn’t destroy the data held by jQuery on that element. This includes data added via ".data()" and any event handlers added via jQuery’s event system.

This can be useful when you need to remove an element from the DOM, but you know you’ll need to add it back at a later stage. Its event handlers and any other data will persist.

var foo = jQuery('#foo');
// Bind an important event handler
foo.click(function(){
alert('Foo!');
});
foo.detach(); // Remove it from the DOM
// … do stuff
foo.appendTo('body'); // Add it back to the DOM
foo.click(); // alerts "Foo!"

jquery Everything “until”!

Three new methods have been added to the DOM traversal arsenal in 1.4, "nextUntil", "prevUntil" and "parentsUntil". Each of these methods will traverse the DOM in a certain direction until the passed selector is satisfied. So, let’s say you have a list of fruit:

<ul>
<li>Apple</li>
<li>Banana</li>
<li>Grape</li>
<li>Strawberry</li>
<li>Pear</li>
<li>Peach</li>
</ul>

You want to select all of items after "Apple", but you want to stop once you reach "Strawberry". It couldn’t be simpler:

jQuery('ul li:contains(Apple)').nextUntil(':contains(Pear)');

Wednesday, 28 November 2012

template link

http://themeforest.net/item/oreva-business-html5-template/full_screen_preview/2374211
http://themeart.net/themes/simplex/
http://htmldemo.themi.co/popular-demo/01_home.html

http://themeforest.net/item/alexx-multipurpose-html5-theme/full_screen_preview/3370259
http://themes.purethemes.net/?theme=centum
http://simplicitywp.olegnax.com/
http://themes.webmandesign.eu/clifden/
http://demo.arrowthemes.com/index.php?theme=lighthouse-joomla
http://themeforest.net/item/arapah-modern-culinary-wordpress-themes/full_screen_preview/3236943
http://www.sorrifacil.com.br/clinicas/

http://themeforest.net/item/onecart-ajax-responsive-ecommerce-wordpress-theme/full_screen_preview/3167538

http://joomla.themesoul.com/rammih/

http://www.beoplay.com/Products/BeoplayA3#features

Saturday, 3 November 2012

How To Prevent Skype from Highlighting Phone Numbers

<meta name="SKYPE_TOOLBAR" content="SKYPE_TOOLBAR_PARSER_COMPATIBLE" />