Dot Net Tips And Tricks

Page Inspector In Visual Studio 2012

noreply@blogger.com (Jainil Prajapati) — Mon, 16 Dec 2013 21:26:00 -0800

The Page Inspector is a Web development tool that simulates a browser experience and runs entirely within Visual Studio. That is to say, you can select the Page Inspector to be your default browser instead of IE, Firefox, or Chrome. While running in debug mode, you can use the Page Inspector to alter CSS rules, change text, and make live changes to the DOM without having to switch back and forth between your browser and Visual Studio (see Figure 1)

Page Inspector provides integrated browser diagnostic tools that allow you to see where UI elements are derived from the underlying source code.

Let’s look at a very simple example. I created a new Project using the ASP.NET 4.5 to demonstrate asp.net New Feature Page Inspector

1) Right Click on solution and click on 'Page Inspector'

Changes in ASPX page is directly updated on page view :

There’s a lot more to the Page Inspector, such as editing the DOM elements and CSS and seeing the results, realtime.

Web Developer have to follow below steps for editing the DOM elements and CSS.
- Change DOM element in aspx page 'Step 1' in above screen shot
- Click on Message in the Page Inspector window 'Step 2' in above screen shot
- Check the updated field in the browser 'Step 3' in above screen shot.
How to Trace JavaScript Files, CSS Files using Page Inspector in Visual Studio 2012 ?

Click on Files tab in above screen shot,where you can find all JavaScript and css files related to aspx webform.

To trace css element click on Styles and Web Developer can Modify CSS realtime, add new css property run time.

The Visual Studio 2012 Page Inspector tool is an awesome productivity enhancement functionality for web developers.It brings the entire debug experience inside Visual Studio Development environment and it’s navigation capabilities help reduce searching element , files and guess work to change elements.

#page inspector visual studio 2012
#The Magic of Visual Studio 2012 Page Inspector
#visual studio 2012 page inspector
#Debugging in Visual Studio 2012
#Visual Studio 2012
#Page Inspector
#Web Applications

Dot Net Naming Conversions and Style

noreply@blogger.com (Jainil Prajapati) — Thu, 12 Dec 2013 08:52:00 -0800

Naming Conversions and Style
Coding Practices
Error Handling
Data Access

Naming Conversions and Style

Use Pascal casing for type and method and constants

Ex: public class SomeClass
{
const int DefaultSize= 100;
public SomeMethod ()
{ }
}

Use camel casing for local variable names and method arguments

Ex:
int number;
void MyMethod (int someNumber)
{ }

Prefix member variables with m_. Use Pascal casing for the rest of a member variable name following the m_.

Ex:public class SomeClass
{
private int m_Number;
}

Name methods using verb-object pair, such as ShowDialog ().
Method with return values should have a name describing the value returned, such as GetObjectState ().
Use descriptive variable names
Always use C# predefined types rather than the aliases in the System Namespace.

For Example:
object NOT Object
string NOT String
int NOT Int32.

Use meaningful namespace such as the product name or the company name.
Avoid fully qualified type names. Use the using statement instead.
Avoid putting a using statement inside a namespace.
Group all framework namespaces together and put custom or third-party namespaces underneath.

Example: using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MyCompany;
using MyControl;

Maintain strict indentation. Do not use Tabs or non standard indentation. Such as one space. Recommended values are three or four spaces, and the value should be uniformed across.
Indent comment at the same level of indentation as the code you are documenting.
All comments should pass spell checking. Misspelled comments indicate sloppy development.
All member variables should be declared at the top, with one line separating them from the properties or methods.

public class MyClass
{
int m_Number;
string m_Name;
public void SomeMethod1()
{ }
public void SomeMethod2()
{ }
}

Declare a local variable as close as possible to its first use.
A file name should reflect the class it contains.
Always place an open curly ({) in a new line.

Coding Practices:

Avoid putting multiple classes in a single file.
A single file should contribute types to only a single namespace. Avoid having multiple namespaces in the same file.
Avoid files with more than 500 lines (Excluding machine-Generated code)
Avoid method with more than 25 lines.
Avoid methods with more than 5 arguments. Use structures for passing multiple arguments.
Do not manually edit any machine generated code.
If modifying machine generated code, modify the format and style to match this coding standard.
Use partial classes whenever possible to factor out the maintained portions.
Avoid comments that explain the obvious. Code should be self-explanatory. Good code with readable variables and method names should not require comments.
Document only operational assumptions, algorithms insights and so on.
Avoid method level documentation.
With the exception of zero or one, never hard-code a numeric value; always declare a constant instead.
Use the const directive only on natural constants such as the number of days of the week.
Avoid using const on read-only variables. For that, use the readonly directive.
Every line of code should be walked through in a “white Box” testing manner.
Catch only exceptions for which you have explicit handling.
Avoid error code as method return values.
Avoid defining custom exception classes.
Avoid multiple Main () methods in a single assembly.
Make only the most necessary types public. Mark other as internal.
Avoid friend assemblies. As they increases inter assembly coupling.
Avoid code that relies on an assembly that running form a particular location.
Minimize code in application assemblies (EXE client assemblies). Use class libraries instead to contain business logic.
Always use a curly brace scope in an if statement, even if it contains a single statement.
Always use zero based arrays.
Do not provide public or protected member variables. Use properties instead.
Avoid using “new” inheritance qualifier. Use “override” instead.
Never use unsafe code. Except using interop.
Always check a delegate for null before invoking it.
Classes and Interfaces should have at least 2:1 ratio of methods to properties.
Avoid Interfaces with one member. Strive to have three to five members per interface. Don’t have more than 20 members per interface.12 is probably principle limit.
Prefer using explicit interface implementation.
Never hardcode strings that might change based on deployment such as connection strings.
When building a long string use “StringBuilder”, not “String”.
Don’t use late binding invocation when early-binding is possible.
Use application logging and tracing.
Never use “go to” unless in a switch statement fall-through.
Don’t use the “this” reference unless invoking another constructor from within a constructor.
Avoid casting to and from “System.Object” in code that uses generics. Use constraints or the “as” operator instead.
Do not use the base word to access base class members unless you wish to resolve a conflict with a subclasses member of the same name or when invoking a base class constructor.

Error Handling:

Error handler should be present whenever you anticipate possibility of error.
Do not use Try-catch for flow- control.
Never declare an empty catch block.
Error Message should be user friendly, simple and understandable.
Errors should be raised in the routines present in the components and captured in the application’s GUI.
Use Try-Catch statements in each and every function you write. Adhere to it strictly with out fail.
Use dispose on types holding scarce resources, i.e., files, database connections.

Data Access:

ANSI SQL 92 standards have to be followed for writing queries.
Do not put order by clause in the query unless required.
Do not encapsulate readonly database operations in transactions.
Use a stored procedure with output parameters instead of single record SELECT statements when retrieving one row of data.
Stored procedure execution is fast when we pass parameters by position (the order in which the parameters are declared in the stored procedure) rather then by name.
After each data modification statement inside a transaction, check for an error by testing the global variable @@ERROR
Verify the row count when performing DELETE operation
Use RETURN statement in stored procedures to help the calling program know whether the procedure worked properly.
Key words should be capital. For example; SELECT, UPDATE, DELETE, INSERT, FROM, AND WHERE, etc.
Do not use “SELECT * FROM” type of query. If all the columns of the table are to be selected, list all columns in the SELECT in same order as they appear in the table definition.
While writing a query as a string, do not put any space after single quote (‘). There should be a single space between every two words. There should not be a space between the last word and the concluding single quote (‘).
Where multiple columns are selected, there should be a single space after every ‘,’ between two columns.
All the major keywords should come on the new lines
The number of columns in a SELECT statement should not be more than 6. The line separator should be placed in this case after the (,) of the last column of this line and a single space.
For any new line separator, the separator should come after a single space after the last word of the line.
Place a tab after each key word on a new line.

Sorting Gridview Columns Using Linq

noreply@blogger.com (Jainil Prajapati) — Mon, 2 Dec 2013 20:32:00 -0800

How to do Sorting gridview columns using linq ?

Sorting for existing data set using LINQ.

Using Generinc Comparer class we can sort class object using LINQ.

1) Add 'GenericComparer.cs” class

public class GenericComparer<T> : IComparer<T>

{

private SortDirection _sortDirection;

private string _sortExpression;

/// <summary>

/// Direction in which to sort.

/// </summary>

public SortDirection GenericSortDirection

{

get { return this._sortDirection; }

set { this._sortDirection = value; }

}

public GenericComparer(string sortExpression, SortDirection sortDirection)

{

this._sortExpression = sortExpression;

this._sortDirection = sortDirection;

}

public int Compare(T x, T y)

{

PropertyInfo propertyInfo = typeof(T).GetProperty(_sortExpression);

IComparable obj1 = (IComparable)propertyInfo.GetValue(x, null);

IComparable obj2 = (IComparable)propertyInfo.GetValue(y, null);

if (GenericSortDirection == SortDirection.Ascending) return obj1.CompareTo(obj2);

else return obj2.CompareTo(obj1);

}

}

Add Following Code into GridView Sort Event:

2) Create Object List as Static:

static List<Projects> objProjectsList = new List<Projects>();

3) Bind Object List:

objProjectsList = DataSouce;

4) Sort Gridview Event code:

protected void gvHeader_Sorting(object sender, GridViewSortEventArgs e)

{

SortDirection sortdirection;

if (ViewState["SortDirection"] != null && ViewState["SortDirection"].ToString() == "Ascending")

sortdirection = SortDirection.Descending;

else

sortdirection = SortDirection.Ascending;

objProjectsList.Sort(new GenericComparer<Projects>(e.SortExpression, sortdirection));

gvHeader.DataSourceID = null;

gvHeader.DataSource = listProjectTask;

gvHeader.DataBind();

ViewState["SortDirection"] = sortdirection.ToString();

}

Enable Unobtrusive Validation in ASP.NET Application

noreply@blogger.com (Jainil Prajapati) — Mon, 2 Dec 2013 20:26:00 -0800

How to Enable Unobtrusive Validation in ASP.NET Application.

Prior to Unobtrusive Validation feature, a lot of JavaScript would get added into a page for each of the different validator controls.

Add JQuery Reference in to Application.
Create New ASP.net Web Application
Right Click Reference and click on Manage NuGet package

Install JQuery Reference

There are three way to enabled Unobtrusive Validation into asp.net application

Add App key in Web.Config File as:

</add>

</appsettings>

We can also set it at Application_Start method in Global.asax file as

Add Referance: using System.Web.UI;
Add Following Code in Application Start Event

void Application_Start(object sender, EventArgs e)

{

ValidationSettings.UnobtrusiveValidationMode = UnobtrusiveValidationMode.None;

}

We can also set it at page level by setting the property of Page class as

protected void Page_Load(object sender, EventArgs e)

{

//Code UnobtrusiveValidationMode at Page Level

Page.UnobtrusiveValidationMode = System.Web.UI.UnobtrusiveValidationMode.WebForms;

}

Unobtrusive Validation Benefit:

It can minimize the size of your overall page
It involves less JavaScript overall on page

ASP.NET 4.5 NEW FEATURES

noreply@blogger.com (Jainil Prajapati) — Tue, 22 Oct 2013 22:49:00 -0700

ASP.net 4.5 have many new features. Below is the list of new features list:

HTML Editor Features
Javascript Editor Features
Css Editor Features
The Page Inspector
Working with data
Framework Features
SignalR
Asynchronous Programming with Async and Await
Unobtrusive Validation
HTML5 features
Oauth and Security Features

HTML Editor Features

Smart Tasks (source view)
Event handler setup (source view)
HTML 5 Snippets
IntelliSense for tags, Attributes
Automatic matching tag renaming
Automatic brace completion and type-through
New doctype, missing some simplifications
Extract to User control

HTML Editor Features Sample:

Javascript Editor Features

Code Outlining
Brace Matching
Go to Definition
DOM Intellisense
ECMA Script Support
Implicit Reference (_references.js file)

CSS Editor Features

Hierarchical Indentation
Support for CSS Hacks
Vendor Extension Support Ex: require -moz, -ms for Microsoft or -webkit for Chrome and Safari
Color Picker
Code Snippets
if you type an @ you'll automatically get support for @ and then you'll see media for instance
Custom Regions

How to Close Window Using Javascript

noreply@blogger.com (Jainil Prajapati) — Sat, 22 Dec 2012 03:37:00 -0800

Window.Close() method is used for close window using JavaScript in HTML

Example :

HTML Example For Open Window and Close Window on Button Click Event:

Example :

<html>

<head>

function openWin() {

myWindow = window.open("", "", "width=200,height=100");

myWindow.document.write("<p>This is 'myWindow'</p>");

}

function closeWin() {

myWindow.close();

}

</script>

</head>

<body>

</body>

</html>

Window.Close() method is used for close window using JavaScript in ASP.NET.

Example :

<asp:Button ID="Button2" runat="server" Text="Close" OnClientClick="javascript: window.close();"/>

#ASP.NET, #JAVASCRIPT,#CLOSE WINDOW

SQL Custom Paging

noreply@blogger.com (Jainil Prajapati) — Sat, 21 Apr 2012 04:35:00 -0700

Using SQL Server Stored Procedure for implementing Custom Paging:

All of us would have implemented Paging in our applications.

Paging is particularly useful if you have lots of records to be displayed on a page and you can't get them displayed in one stretch. Say we have 1000 records to be displayed in a page. In this scenario, we cannot show up all the records in a single stretch in the page. Hence we need to implement Paging functionality whereby users can see a set of records and then click on a Button/Link to view the next set of records.

Here is the sample store procedure that is used for the SQL Server store procedure for paging.

Example:

CREATE PROCEDURE USP_PRODUCT_SELECT
(
@CurrentIndex int,
@TotalPageSize int
)
AS

SELECT * FROM
(

SELECT ROW_NUMBER() OVER(ORDER BY ProductID) AS RowId, * FROM Products

) AS P
WHERE P.RowId BETWEEN (@CurrentIndex -1) * @TotalPageSize+ 1 AND (@CurrentIndex * @TotalPageSize )

#SQL Server, #Custom Paging

Recursive Query In Sql Server

noreply@blogger.com (Jainil Prajapati) — Sat, 21 Apr 2012 04:16:00 -0700

A common table expression (CTE) provides the significant advantage of being able to reference itself, thereby creating a recursive CTE. A recursive CTE is one in which an initial CTE is repeatedly executed to return subsets of data until the complete result set is obtained.

A query is referred to as a recursive query when it references a recursive CTE. Returning hierarchical data is a common use of recursive queries, for example: Displaying employees in an organizational chart, or data in a bill of materials scenario in which a parent product has one or more components and those components may, in turn, have subcomponents or may be components of other parents.

A recursive CTE can greatly simplify the code required to run a recursive query within a SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. In earlier versions of SQL Server, a recursive query usually requires using temporary tables, cursors, and logic to control the flow of the recursive steps.

The structure of the recursive Query

The structure of the recursive CTE in Transact-SQL is similar to recursive routines in other programming languages. Although a recursive routine in other languages returns a scalar value, a recursive CTE can return multiple rows.

A recursive CTE consists of three elements:

Invocation of the routine.
The first invocation of the recursive CTE consists of one or more CTE_query_definitions joined by UNION ALL, UNION, EXCEPT, or INTERSECT operators. Because these query definitions form the base result set of the CTE structure, they are referred to as anchor members.
CTE_query_definitions are considered anchor members unless they reference the CTE itself. All anchor-member query definitions must be positioned before the first recursive member definition, and a UNION ALL operator must be used to join the last anchor member with the first recursive member.
Recursive invocation of the routine.
The recursive invocation includes one or more CTE_query_definitions joined by UNION ALL operators that reference the CTE itself. These query definitions are referred to as recursive members.
Termination check.
The termination check is implicit; recursion stops when no rows are returned from the previous invocation.

Recursive query in sql server Example:

WITH CTE(categoryId,CategoryName,ParentCategoryID,TopParentCategoryID) AS

(

SELECT

a.CategoryId,

a.CategoryName,

a.ParentCategoryID,

a.CategoryId AS TopParentCategoryID

FROM Categories a WHERE ParentCategoryID is null

UNION ALL

SELECT c.CategoryId, c.CategoryName, c.ParentCategoryID, cte.TopParentCategoryID AS TopParentCategoryID FROM Categories c,cte

WHERE cte.CategoryId = c.ParentCategoryID

)

SELECT CTE.categoryId,cte.CategoryName,cte.ParentCategoryID,cte.TopParentCategoryID FROM CTE

Reverse Word In String in C#

noreply@blogger.com (Jainil Prajapati) — Sat, 21 Apr 2012 02:55:00 -0700

Reverse Word In String in C#

Words in a string can be reversed. We have several methods or ways to reverse word in a string.
Using C# you can reverse string:

Example:
char [] charAray = "This is Test String".ToCharArray();

StringBuilder sb = new StringBuilder();

System.Console.WriteLine((new string(charAray)));

System.Console.WriteLine("Reverse");

for(int i=charAray.Length-1;i>=0 ;i--)

{

if (charAray[i] == ' ')

{

char[] charAray1 = sb.ToString().ToCharArray();

Array.Reverse(charAray1);

System.Console.Write(new string(charAray1) + " ");

sb.Clear();

}

else

{

sb.Append(charAray[i]);

}

char[] temp = sb.ToString().ToCharArray();

Array.Reverse(temp);

System.Console.Write(new string(temp));

Using jQuery to Consume ASP.NET JSON Web Services

noreply@blogger.com (Jainil Prajapati) — Fri, 30 Mar 2012 02:32:00 -0700

Using jQuery to Consume ASP.NET JSON Web Service:

Following are the steps for consume JSON webservice using JQuery.

Add New Web Page JSONSaveDataWebservice.aspx
Add Web Service : wsEmployeeInsert.asmx
Add Java Script in aspx page.

JSONSaveDataWebservice.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="JSONSaveDataWebservice.aspx.cs"

Inherits="JSONSaveDataWebservice" %>

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>JSON SaveData Get Data Using Webservice Jquery title>

function CallService() {

var name = $("#txtName").val();

var age = $("#txtAge").val();

$.ajax({

type: "POST",

url: "JSONSaveDataWebserviceaspx.aspx/InsertEmployee",

data: "{'name':'" + name + "','age':'" + age + "'}",

contentType: "application/json",

async: false,

success: function (data) {

alert("Sucess" + data.d);

error: function (data) { alert("Error" + data.d); }

});

}

$(document).ready(function () {

// Load Employees

GetAllEmployees();

var DropDownList1 = $("#DropDownList1");

DropDownList1.change(function (e) {

var employeeId = DropDownList1.val();

if (employeeId != -1) {

// Get Employee Details

GetEmployeeDetails(employeeId);

} else {

$("#outputTable").hide();

}

});

function GetAllEmployees() {

var DropDownList1 = $("#DropDownList1");

$.ajax({

type: "POST",

url: "wsEmployeeInsert.asmx/GetAllEmployees",

data: "{}",

contentType: "application/json; charset=utf-8",

dataType: "json",

success: function (response) {

var Employees = response.d;

$.each(Employees, function (index, employee) {

DropDownList1.append(' + employee.Name + '');

});

failure: function (msg) {

alert(msg);

}

});

}

function GetEmployeeDetails(employeeId) {

$.ajax({

type: "POST",

url: "wsEmployeeInsert.asmx/GetEmployeeDetails",

data: "{'employeeId':'" + employeeId + "'}",

contentType: "application/json; charset=utf-8",

dataType: "json",

success: function (response) {

var Employee = response.d;

$("#spnEmployeeId").html(Employee.Id);

$("#spnEmployeeName").html(Employee.Name);

$("#spnAddress").html(Employee.Address);

$("#spnSalary").html(Employee.Salary);

$("#outputTable").show();

failure: function (msg) {

alert(msg);

}

});

}

script>

head>

<body>

<div>

Name:

<asp:TextBox ID="txtName" runat="server">asp:TextBox><br />

Age:

<asp:TextBox ID="txtAge" runat="server">asp:TextBox><br />

div>

<div>

Select Employee:

<asp:DropDownList ID="DropDownList1" runat="server" Width="150">

<asp:ListItem Text="Select" Value="-1" />

asp:DropDownList>

<br />

<table style="border: solid 1px black; width: 300px; display: none; background-color: #f3f3f3"

cellpadding="4" cellspacing="0" id="outputTable">

<tr>

<td>

Employee ID:

td>

<td>

td>

tr>

<tr>

<td>

Employee Name:

td>

<td>

td>

tr>

<tr>

<td>

Address:

td>

<td>

td>

tr>

<tr>

<td>

Salary:

td>

<td>

td>

tr>

table>

div>

form>

body>

html>

JSONSaveDataWebservice.aspx.CS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.Services;

public partial class JSONSaveDataWebservice : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

[WebMethod]

public static string InsertEmployee(string name, int age)

{

string s_name = name;

int s_age = age;

return "Save Sucessfully";

}

wsEmployeeInsert.asmx

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Services;

///

/// Summary description for wsEmployeeInsert

///

[WebService(Namespace = "http://tempuri.org/")]

[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.

[System.Web.Script.Services.ScriptService]

public class wsEmployeeInsert : System.Web.Services.WebService,IDisposable {

List<Employee> list = new List<Employee>();

public wsEmployeeInsert () {

//Uncomment the following line if using designed components

//InitializeComponent();

list.Add(new Employee { Id = 1, Name = "Rajesh Tendulkar",Address="India", Salary = 10000 });

list.Add(new Employee { Id = 2, Name = "Rahul Ganguly",Address="Asia", Salary = 20000 });

list.Add(new Employee { Id = 3, Name = "Saurav Dravid",Address="China", Salary = 30000 });

list.Add(new Employee { Id = 4, Name = "Suresh Sharma",Address="US", Salary = 40000 });

list.Add(new Employee { Id = 5, Name = "Sachin Tiwari",Address="UK", Salary = 50000 });

}

[WebMethod]

public List<Employee> GetAllEmployees()

{

return list;

}

[WebMethod]

public Employee GetEmployeeDetails(string employeeId)

{

int empId = Int32.Parse(employeeId);

Employee emp = list.Single(e => e.Id == empId);

return emp;

}

partial class Employee

{

public int Id { get; set; }

public string Name { get; set; }

public string Addresses { get; set; }

public decimal Salary { get; set; }

}

Notes:

Jquery
ASP.net
JSON
Web service

Lazy Loader In ASP.Net And AJAX

noreply@blogger.com (Jainil Prajapati) — Sat, 24 Mar 2012 01:35:00 -0700

1 ) Add Java Script and Call AJAX Method defined in the ASP.net code behind File:

var flag = true;

window.onload = function() {

document.getElementById("hdnPg").value = 1;

// for restart paging from 1

var TargetBaseControl = document.getElementById("TdContainer");

var Inputs = TargetBaseControl.getElementsByTagName("input");

for (var n = 0; n < Inputs.length; ++n) {

if (Inputs[n].type == 'checkbox') {

Inputs[n].disabled = false;

Inputs[n].parentElement.disabled = false;

Inputs[n].checked = false;

Inputs[n].removeAttribute("checked");

}

function AppendResult() {

//debugger;

var getKey = document.getElementById("lblSearch").getElementsByTagName("u")

var Key = getKey[0].innerHTML;

var currPage = parseInt((document.getElementById("hdnPg").value)) + 1;

var KeyID = document.getElementById("hdnSearchUID").value;

var ResultItem = searching.AppendProduct(Key, KeyID, currPage);

if (ResultItem.value != "" && ResultItem != null && ResultItem.value != "N") {

document.getElementById("TdContainer").innerHTML += ResultItem.value;

document.getElementById("hdnPg").value = parseInt((document.getElementById("hdnPg").value)) + 1;

document.getElementById("pPage" + document.getElementById("hdnPg").value).innerHTML = "Page : " + document.getElementById("hdnPg").value;

}

if (ResultItem.value == "N") {

document.getElementById("TdLoadMore").innerHTML = "No More Products For This Keyword";

document.getElementById("TdLoadMore").style.display = "block";

document.getElementById("divLoadingMessage").style.display = "none";

window.onscroll = null;

}

flag = true;

}

window.onscroll = function() {

var tblCmp = document.getElementById("tblComparelist");

if (document.documentElement.scrollTop != undefined) {

if (document.documentElement.scrollTop > 175 || document.body.scrollTop > 175) {

tblCmp.style.top = 0;

tblCmp.style.position = "fixed";

tblCmp.style.width = 765 + "px";

}

else {

tblCmp.style.position = "relative";

tblCmp.style.width = "100%";

}

else if (window.pageYOffset != undefined) {

if (window.pageYOffset > 175) {

tblCmp.style.top = 0;

tblCmp.style.position = "fixed";

tblCmp.style.width = 765 + "px";

}

else {

tblCmp.style.position = "relative";

tblCmp.style.width = "100%";

}

else {

tblCmp.style.position = "relative";

tblCmp.style.width = "100%";

}

/*For scroll paging work fine in ie 7+ , mozilla, chrome*/

if (navigator.appName == "Microsoft Internet Explorer") {

if (document.documentElement.scrollTop > document.documentElement.scrollHeight - 660 && flag == true) {

document.getElementById("divLoading").style.display = "";

flag = false;

AppendResult();

document.getElementById("divLoading").style.display = "none";

}

else {

if (document.documentElement.scrollTop > window.scrollMaxY - 50 && flag == true) {

document.getElementById("divLoading").style.display = "";

flag = false;

AppendResult();

document.getElementById("divLoading").style.display = "none";

}

else if (document.body.scrollTop >= (document.documentElement.scrollHeight - document.documentElement.clientHeight - 20) && flag == true) {

document.getElementById("divLoading").style.display = "";

flag = false;

AppendResult();

document.getElementById("divLoading").style.display = "none";

}

function AddToWishlist(obj) {

var position = [0, 0];

var DL = document.getElementById('<%= "dlSearch"%>')

var tblWish = document.getElementById("tblWishList");

if (DL.offsetParent) {

do {

position[0] += DL.offsetLeft;

position[1] += DL.offsetTop;

} while (DL = DL.offsetParent);

}

var result = searching.AddToWishList(obj.parentElement.parentElement.parentElement.getElementsByTagName("input")[0].parentElement.title);

if (result.value == "True") {

document.getElementById("cartCnt").innerHTML = parseInt(document.getElementById("cartCnt").innerHTML) + 1;

tblWish.style.top = position[1] + "px";

tblWish.style.left = position[0] + document.getElementById('<%= "dlSearch"%>').offsetWidth + "px";

tblWish.style.position = "fixed";

tblWish.style.display = "block";

}

return false;

}

function ClearWishList() {

var result = searching.ClearWishList();

var tblWish = document.getElementById("tblWishList").style.display = "none";

document.getElementById("cartCnt").innerHTML = 0;

}

script>

2) Add Code Behind AJAX Method:

Public Function AppendProduct(ByVal key As String, ByVal KeyID As String, ByVal CurrPage As String) As String

Dim str As String

Dim cn As New SqlConnection(ConfigurationManager.AppSettings("ConnectionString"))

Dim da As SqlDataAdapter

If cn.State = ConnectionState.Closed Then

cn.Open()

End If

' hdnPg.Value = (Convert.ToInt32(hdnPg.Value) + 1).ToString()

Try

da = New SqlDataAdapter("Usp_Searching", cn)

da.SelectCommand.CommandType = CommandType.StoredProcedure

da.SelectCommand.Parameters.AddWithValue("@CmdType", "Select")

da.SelectCommand.Parameters.AddWithValue("@Mode", "Select_Product")

da.SelectCommand.Parameters.AddWithValue("@Keyword", key)

' da.SelectCommand.Parameters.AddWithValue("@KeyUID", KeyID)

da.SelectCommand.Parameters.AddWithValue("@intCurrIndex", CurrPage)

da.SelectCommand.Parameters.AddWithValue("@intPageSize", "12")

da.Fill(ds)

Dim j As Integer = 0

If (ds.Tables(0).Rows.Count > 0) Then

str = "

For i1 As Integer = 0 To Math.Ceiling(ds.Tables(0).Rows.Count / 4) - 1

str += "

For i As Integer = 0 To 3

If ds.Tables(0).Rows.Count > (i + j) Then

str += "

End If

j = j + 4

str += "

If Not Session("CompareProductList") Is Nothing Then

If CType(Session("CompareProductList"), Data.DataTable).Rows.Count >= 3 Then

str += "

Else

str += "

End If

Else

str += "

End If

str += "

onclick='return AddToCmpLst(this);'>Add to Compare
onclick='return AddToCmpLst(this);'>Add to Compare
onclick='return AddToCmpLst(this);'>Add to Compare
	" If ds.Tables(0).Rows(j + i)("Product_MarketPrice").ToString.Trim() <> "0.00" And ds.Tables(0).Rows(j + i)("Product_MarketPrice").ToString.Trim() <> "0" And ds.Tables(0).Rows(j + i)("Product_MarketPrice").ToString.Trim() <> "Rs" And ds.Tables(0).Rows(j + i)("Product_MarketPrice").ToString.Trim() <> "0.00 Rs." And ds.Tables(0).Rows(j + i)("Product_MarketPrice").ToString.Trim() <> "" Then str += "" + ds.Tables(0).Rows(j + i)("Product_MarketPrice").ToString + " " + ds.Tables(0).Rows(j + i)("Unit_Name").ToString + "" Else str += " href='javascript:__doPostBack('','')' style='font-family: verdana; font-size: 8pt; font-weight: normal; text-decoration: none;'>Price On Request" End If str += " Add to WishList
" str += " class='U' href='" + Page.ResolveUrl("pd/" & EncodeURL(ds.Tables(0).Rows(j + i)("Product_Kid")) & "/" & ds.Tables(0).Rows(j + i)("CatName") & "/" & ds.Tables(0).Rows(j + i)("ProdName") & ".aspx") + "'Style = 'color: #163351; font-family: Verdana; font-size: 8pt; font-weight: bold; text-transform: capitalize'>" + ds.Tables(0).Rows(j + i)("Product_Name") + "" str += " style='color: Black; font-family: Verdana; font-size: 7pt;'>" + ds.Tables(0).Rows(j + i)("ProductDescription") + "
Product Code - " + ds.Tables(0).Rows(j + i)("Product_Code").ToString + "" str += " Model No. - " + ds.Tables(0).Rows(j + i)("Product_ModelNo") + " " str += "Brand - " + ds.Tables(0).Rows(j + i)("Brand_Name") + "

str += "

Return str

Else

Return "N"

End If

Catch ex As Exception

Return ""

End Try

End Function

Bind Dropdown Using Javascript and Webservice

noreply@blogger.com (Jainil Prajapati) — Fri, 23 Mar 2012 01:52:00 -0700


1) Add Webservice wsCountry.asmx

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web.Script.Services;
using System.Web.Services;
using Test;
///


/// Summary description for wsCountry
///


[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. 
[System.Web.Script.Services.ScriptService]
public class wsCountry : System.Web.Services.WebService
{

    public wsCountry()
    {

        //Uncomment the following line if using designed components 
        //InitializeComponent(); 
    }
   
    [WebMethod]
    [ScriptMethod(ResponseFormat = ResponseFormat.Json, UseHttpGet = true)]
    public List FindAllCountries()
    {
        List locations = new List();
        string connectionString = ConfigurationManager.ConnectionStrings["TestDBConnectionString"].ConnectionString;
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            using (SqlCommand command = new SqlCommand())
            {
                command.Connection = connection;
                command.CommandText = "SelectAllCountries";
                command.CommandType = CommandType.StoredProcedure;
                connection.Open();
                using (SqlDataReader dataReader = command.ExecuteReader())
                {
                    Location location;
                    if (dataReader != null)
                        while (dataReader.Read())
                        {
                            location = new Location();
                            location.CountryID = (int)dataReader["CountryID"];
                            location.CountryName = Convert.ToString(dataReader["CountryName"]);
                            locations.Add(location);
                        }
                }
            }
        }
        return locations;
    }
}
namespace Test
{
    [Serializable]
    public class Location
    {
        public int CountryID
        { get; set; }

        public string CountryName
        { get; set; }

    }
}

2) Add ASPX Page and Call web service method.
Add script manager
Add Service Reference in the script Manager
Call Web service on the page load and get result and add that result to Dropdown.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="BindDropDown.aspx.cs" EnableEventValidation="false"  Inherits="BindDropDown" %>




    Bind Dropdown

Save View State in Session Variable

noreply@blogger.com (Jainil Prajapati) — Fri, 23 Mar 2012 01:41:00 -0700

ViewState can be customized to be stored in a Session or Cache object. It
is done by overriding the 'SavePageStateToPersistenceMedium' and
'LoadPageStateFromPersistenceMedium' methods.

Add Following Two Override Method in to code behind file:

Step 1:

Protected Overrides Function LoadPageStateFromPersistenceMedium() As Object
        If Session("ViewState") <> Nothing Then
            Return (New LosFormatter().Deserialize(DirectCast(Session("ViewState"), String)))
        End If
    End Function

Step 2:

    Protected Overrides Sub SavePageStateToPersistenceMedium(ByVal state As Object)
        Dim los As New System.Web.UI.LosFormatter()
        Dim sw As New System.IO.StringWriter()
        los.Serialize(sw, state)
        Dim vs As String = sw.ToString()
        Session("ViewState") = Nothing
        Session("ViewState") = vs
    End Sub

Advantage of Moving ViewState object to Session Variable :

If the ViewState size is large, it increases the page size when it load in the browser and results in an increase in response time to load page performance.
Saving the ViewState to a Session can result in an improved response time as it reduce the ViewState object to Session but it use the server resource to store session information, so need to improve hardware information.

ReOrder List in ASP.NET using AJAX

noreply@blogger.com (Jainil Prajapati) — Sun, 26 Feb 2012 20:02:00 -0800

ReorderList is an ASP.NET AJAX control that implements a bulleted, data-bound list with items that can be reordered interactively. To reorder the items in the list, the user simply drags the item's control bar to its new location. Graphical feedback is shown where the item will be placed as it is dragged by the user. The data source is updated after the item is dropped in its new location.

When bound to data, the ReorderList control will behave like many other databound controls. If the data you are displaying has a field that determines sort order (e.g. the select query is sorted by this column), and that column is of an integer type, the ReorderList can automatically perform reorders if its SortOrderField property is set. The ReorderList can also bind to any data source that implements IList (such as Arrays).

The ReorderList control is different than the other samples here because it is an ASP.NET server control that is aware of ASP.NET AJAX behaviors. Rather than extending existing controls on the page, it delivers a rich client experience directly and still has a traditional post-back server model for interacting with the application.

The ReorderList can handle reorders in two ways, either via a callback or via a postback. For a callback, no page postback happens on a reorder. This is useful if the data is only to be ordered. If the data items are to be deleted or edited, a full postback needs to occur to sync the server side state with the client side state. The PostbackOnReorder property enables this.

Step 1: Create Stylesheet (CSS)

.DragHandleClass

{

width: 20px;

height: 20px;

background-color: red;

color: white;

cursor: move;

}

.ajaxOrderedList li

{

list-style: none;

}

</style>

Step 2: Add Reorder List Control and SQL Data source

<asp:SqlDataSource ID="sds" runat="server" ConnectionString="<%$ ConnectionStrings:dbConnectionString %>"

OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [ID], [Product_Kid], [CatName], [Product_Name], [Product_Image], [Brand_Name], [Product_Description], ISNULL(SortOrder,99999) [SortOrder],Product_Code FROM [RecentProducts] ORDER BY [SortOrder]"

UpdateCommand="UPDATE [RecentProducts] SET [SortOrder] = @SortOrder WHERE [ID] = @original_id"

DeleteCommand="DELETE FROM [RecentProducts] WHERE [ID] = @original_id">

<asp:Parameter Name="original_id" Type="Int32" />

</DeleteParameters>

<asp:Parameter Name="SortOrder" Type="Int32" />

<asp:Parameter Name="original_id" Type="Int32" />

</UpdateParameters>

</asp:SqlDataSource>

<br />

<tr>

</td>

Product

</td>

Brand

</td>

Product Code

</td>

Description

</td>

</tr>

</table>

<cc1:reorderlist id="rl1" runat="server" allowreorder="True" sortorderfield="SortOrder"

datakeyfield="ID" datasourceid="sds" postbackonreorder="True">

</div>

</DragHandleTemplate>

<tr>

<asp:ImageButton ID="btnDelete" CommandName="Delete" ImageUrl="~/Images/del3.jpg"

OnClientClick="javascript:return confirm('Are you sure about deleting this record?');"

runat="server" />

</InsertItemTemplate>

</td>

<td>

<b>

<asp:Label ID="lblSrNo" runat="server" Text="" /></b>

</td>

<asp:Image ID="imgdynProd" Height="40" Width="60" runat="server" Style="border: 1px solid gray;

text-align: center;" AlternateText='<%# DataBinder.Eval(Container.DataItem, "Product_Image") %>'

ImageUrl='<%# "/Atcomaart/Upload Image/Product Image/UploadImages/"+ DataBinder.Eval(Container.DataItem, "Product_Image") %>'

onclick="Pop(this,30,'');" />

</td>

<asp:Label ID="Label1" runat="server" Text='<%#Eval("Product_Name") %>' />

</td>

<asp:Label ID="Label2" runat="server" Text='<%#Eval("Brand_Name") %>' />

</td>

</td>

 <asp:Label ID="ItemLabel" runat="server"

Text='<%# Eval("Product_Description") %>' />

</td>

</tr>

</table>

<hr />

</ItemTemplate>

<asp:Panel ID="pnlInsert" runat="server" DefaultButton="btnInsert">

<span>Porduct Code: </span>

<asp:TextBox ID="txtItemCode" runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="rfvItemCode" runat="server" ValidationGroup="1" ControlToValidate="txtItemCode"

ErrorMessage="Product code is required."></asp:RequiredFieldValidator>

<br />

<asp:Button ID="btnInsert" Text="Submit" runat="server" CommandName="Select" ValidationGroup="1"

OnClick="btnInsert_Click" />

</asp:Panel>

</InsertItemTemplate>

</cc1:reorderlist>

</div>

Step 3: Add Insert Command for Insert Method

Protected Sub btnInsert_Click(ByVal sender As Object, ByVal e As System.EventArgs)
        lblMessage.Text = ""
        Dim txtControl As New TextBox
        For i As Integer = 0 To rl1.Items.Count
            If (rl1.Items(i).FindControl("txtItemCode") IsNot Nothing) Then
                txtControl = DirectCast(rl1.Items(i).FindControl("txtItemCode"), TextBox)
                Exit For
            End If
        Next

        If (txtControl IsNot Nothing And txtControl.Text <> "") Then
            If (ProductCheck(txtControl.Text)) Then
                If (InsertRecentProductNew(txtControl.Text)) Then
                    txtControl.Text = ""
                    CreateMessageAlert(Me, "Product Added Sucessfully", "Success")
                    sds.DataBind()
                    rl1.DataBind()
                Else
                    CreateMessageAlert(Me, "Product Already Exists.", "Already")
                End If
            Else
                CreateMessageAlert(Me, "Invalid Product Code", "InValidProductCode")
            End If
        End If
    End Sub

Public Sub CreateMessageAlert(ByRef aspxPage As System.Web.UI.Page, ByVal strMessage As String, ByVal strKey As String)
        Try

            If (Not aspxPage.IsStartupScriptRegistered(strKey)) Then
                ScriptManager.RegisterStartupScript(aspxPage, aspxPage.GetType, "StrKeyVal", "alert('" & strMessage & "')", True)
            End If

        Catch ex As Exception

        End Try
    End Sub

How to Convert Html to PDF in ASP.NET , C# Using iTextsharp

noreply@blogger.com (Jainil Prajapati) — Fri, 9 Sep 2011 07:00:00 -0700

There are many solutions can convert html to PDF.

However they have different effects. As far as I know, the simplest solution that I ever seen is using iTextsharp and the code as below:

Sample Code:

   string FilePath = Server.MapPath("") + "/OrderconfirmationMail.htm";
         System.IO.StreamReader myFile =new System.IO.StreamReader(FilePath);
         string myString = myFile.ReadToEnd();
         myFile.Close();
         string ImagePath = Server.MapPath("") + "\\Images\\";
        myString = myString.Replace("src=\"Images/", ImagePath);
         StringReader sr = new StringReader(myString);
         iTextSharp.text.Document pdfDoc = new iTextSharp.text.Document(iTextSharp.text.PageSize.A4, 2f, 2f, 2f, 2f);
         HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
         string filename = Server.MapPath("") + "\\WordDoc\\parsetest3.pdf";


         if (File.Exists(filename))
         {
             File.Delete(filename);
         }
         PdfWriter.GetInstance(pdfDoc, new FileStream(filename, FileMode.Create));
         pdfDoc.Open();
         htmlparser.Parse(sr);
         pdfDoc.Close();
         Response.Write(pdfDoc);

I found some links where you can find details:

http://stackoverflow.com/questions/2822843/itextsharp-html-to-pdf

http://hamang.net/2008/08/14/html-to-pdf-in-net/

http://forums.asp.net/t/1596224.aspx/1

http://aspdotnetcodebook.blogspot.com/2008/07/how-to-export-content-of-gridview-to.html

http://channel9.msdn.com/Forums/TechOff/117199-ASPNET-and-iTextSharp-free-PDF-Generator-for-NET

Set Session variable in javascript function

noreply@blogger.com (Jainil Prajapati) — Wed, 2 Sep 2009 04:45:00 -0700

How can I set session variables with JavaScript ?

Sample Code In Java script:

function SendRequest() {

var MySessionvalue = '<%= Session["EMP_C"] %>';

var MyColocn = '<%= Session["COLOCN_C"] %>';

alert(MySessionvalue);

}

< /script>

#How can I set session variables with JavaScript
#Assigning Session variable from Javascript
#How do i set a session variable using javascript?

OPENING NEW WINDOWS

noreply@blogger.com (Jainil Prajapati) — Tue, 11 Aug 2009 23:03:00 -0700

var newwindow;
function openwindow(url)
{
 newwindow=window.open(url,'name','height=800,width=600');
 if (window.focus) {newwindow.focus()}
}

calculate hour minutes from milliseconds in oracle query

noreply@blogger.com (Jainil Prajapati) — Wed, 24 Jun 2009 22:23:00 -0700

SQL QUERY:

SELECT
SUBSTR(to_char((39600/60/60),'00.00') , 0, INSTR(to_char((39600/60/60),'00.00'), '.', 1, 1)-1) hour,
to_char((SUBSTR(to_char((39600/60/60),'00.00'), INSTR(to_char((39600/60/60),'00.00'), '.', 1, 1),length(to_char((39600/60/60),'00.0'))) *60),'00') as Minutes
FROM dual;

OUTPUT

HOUR MINUTES
------ -------
11 00

1 rows selected

ANOTHER EXAMPLE

SELECT
SUBSTR(to_char((11700/60/60),'00.00') , 0, INSTR(to_char((11700/60/60),'00.00'), '.', 1, 1)-1) hour,
to_char((SUBSTR(to_char((11700/60/60),'00.00'), INSTR(to_char((11700/60/60),'00.00'), '.', 1, 1),length(to_char((11700/60/60),'00.00'))) *60),'00') as Minutes
FROM dual;

OUTPUT

HOUR MINUTES
------ -------
03 15

1 rows selected

FILL DATA USING ORACLE STORE PROCEDURE IN ASP.NET C#

noreply@blogger.com (Jainil Prajapati) — Fri, 5 Jun 2009 02:09:00 -0700

PROCEDURE "GET_ALL_AREA"

(

ITEMS_CURSOR OUT SYS_REFCURSOR

)

BEGIN

OPEN ITEMS_CURSOR FOR SELECT AREAID,AREANAME,AREAPINCODE FROM AREA;

END;

DataSet ds = new DataSet();

OracleCommand command = new OracleCommand();

command.CommandType = CommandType.StoredProcedure;

command.CommandText = “Get_All_Area”;

command.Connection = conn.Get_Connection();

command.Parameters.Add("ITEMS_CURSOR", OracleType.Cursor ).Direction = ParameterDirection.Output;

OracleDataAdapter adpt = new OracleDataAdapter(Command);

adpt.Fill(ds, str_table);

Close_Connection();

public string Connection_String

{

get

{

return ConfigurationSettings.AppSettings["dbConnectionString"];

}

//Function For Open New Connection

public OracleConnection Get_Connection()

{

try

{

OracleConn = new OracleConnection(Connection_String);

OracleConn.Open();

}

catch (Exception ex)

{

throw ex;

}

return OracleConn;

}

//Close Connection

public void Close_Connection()

{

try

{

OracleConn.Close();

}

catch(Exception ex)

{

throw new Exception(ex.Message, ex);

}

CONVERT TEXT INTO INITCAP IN C#

noreply@blogger.com (Jainil Prajapati) — Fri, 5 Jun 2009 02:05:00 -0700

public static string PropCase(string strText)

{

return new CultureInfo("en").TextInfo.ToTitleCase(strText.ToLower());

}

How To Generate IFrame At Runtime Using Javascript

noreply@blogger.com (Jainil Prajapati) — Mon, 25 May 2009 23:39:00 -0700

var el = document.createElement("iframe");

el.setAttribute('id', 'ifrm');

el.setAttribute('width', '100%');

document.body.appendChild(el);

el.setAttribute('src', 'http://www.yahoo.com');

script>

How to Print Div Tag Using Javascript?

noreply@blogger.com (Jainil Prajapati) — Thu, 14 May 2009 23:36:00 -0700

HTML FILE :

function CallPrint( strid )

{

var prtContent = document.getElementById( strid );

var WinPrint = window.open('', '', 'left=0,top=0,width=900,height=600,toolbar=1,scrollbars=1,status=0');

WinPrint.document.write( prtContent.innerHTML );

WinPrint.document.close();

WinPrint.focus();

WinPrint.print();

WinPrint.close();

prtContent.innerHTML=strOldOne;

}

script>

This is Print

div>

Code FILE :

protected void Page_Load(object sender, EventArgs e)

{

btnPrint.Attributes.Add("onclick", "javascript:CallPrint('print_Grid')");

}

How To Use This Code?

1. Copy JavaScript into your HTML Page

2. Make a Div Tag Which data you want to print into that div tag

3. Add Print Button and call JavaScript Function

How To Get List of Tables in SQL Server

noreply@blogger.com (Jainil Prajapati) — Wed, 13 May 2009 04:38:00 -0700

Using Following SQL Query you can get list of tables in SQL Database

SELECT name [Table Name]

FROM sysobjects

WHERE xtype = 'U'

How to Get SQL Table Columns List

noreply@blogger.com (Jainil Prajapati) — Wed, 13 May 2009 04:32:00 -0700

How to get all field names in a table using sql query?

Following query is use for getting all sql table column names from database in Microsoft SQL server.

SELECT c.name

FROM syscolumns c INNER JOIN sysobjects o ON o.id = c.id

WHERE o.name ='TABLENAME'

ORDER BY colid

#How to find all SQL tables with a column name

#How to Get SQL Table Columns List

#How to get all field names in a table using sql query

sql query for Generate serial no

noreply@blogger.com (Jainil Prajapati) — Thu, 23 Apr 2009 22:03:00 -0700

SELECT C.EmployeeId, C.FirstName,C.LastName,

(SELECT COUNT(*) FROM Employee C2 WHERE C2.EmployeeId <= C.EmployeeId

) as SrNoFROM Employee C ORDER BY EmployeeId

Dot Net Tips And Tricks

Page Inspector In Visual Studio 2012

How to Trace JavaScript Files, CSS Files using Page Inspector in Visual Studio 2012 ?

Dot Net Naming Conversions and Style

Naming Conversions and Style

Coding Practices:

Error Handling:

Data Access:

Sorting Gridview Columns Using Linq

Enable Unobtrusive Validation in ASP.NET Application

How to Enable Unobtrusive Validation in ASP.NET Application.

There are three way to enabled Unobtrusive Validation into asp.net application

Add App key in Web.Config File as:

We can also set it at Application_Start method in Global.asax file as

We can also set it at page level by setting the property of Page class as

Unobtrusive Validation Benefit:

ASP.NET 4.5 NEW FEATURES

How to Close Window Using Javascript

SQL Custom Paging

Recursive Query In Sql Server

The structure of the recursive Query

Reverse Word In String in C#

Reverse Word In String in C#Words in a string can be reversed. We have several methods or ways to reverse word in a string. Using C# you can reverse string:

Using jQuery to Consume ASP.NET JSON Web Services

Lazy Loader In ASP.Net And AJAX

Bind Dropdown Using Javascript and Webservice

Save View State in Session Variable

ReOrder List in ASP.NET using AJAX

How to Convert Html to PDF in ASP.NET , C# Using iTextsharp

Set Session variable in javascript function

How can I set session variables with JavaScript ?

OPENING NEW WINDOWS

calculate hour minutes from milliseconds in oracle query

FILL DATA USING ORACLE STORE PROCEDURE IN ASP.NET C#

CONVERT TEXT INTO INITCAP IN C#

How To Generate IFrame At Runtime Using Javascript

How to Print Div Tag Using Javascript?

How To Get List of Tables in SQL Server

How to Get SQL Table Columns List

How to get all field names in a table using sql query?

sql query for Generate serial no

Reverse Word In String in C#

Words in a string can be reversed. We have several methods or ways to reverse word in a string.
Using C# you can reverse string: