Currency Conversion using webservice

Add web referance from given URL. It's Free

http://www.webservicex.net/CurrencyConvertor.asmx

Then write following code in Code behind :

using SampleCSharpApplication.net.webservicex.www;

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

Currency cur = new Currency();

Array arr;

arr = System.Enum.GetValues(cur.GetType());

ddlFrom.DataSource = arr;

ddlFrom.DataBind();

ddlTo.DataSource = arr;

ddlTo.DataBind();

}

}

protected void Button1_Click(object sender, EventArgs e)

{

CurrencyConvertor CC = new CurrencyConvertor();

Currency cur = new Currency();

txtResult.Text = CC.ConversionRate((Currency)System.Enum.Parse(cur.GetType(),
ddlFrom.Text), (Currency)System.Enum.Parse(cur.GetType(),
ddlTo.Text)).ToString();

}

<div>

<asp:Literal ID="ltrfrom" runat="server"

Text="Select Currency to convert :"></asp:Literal>

<asp:DropDownList ID="ddlFrom" runat="server"

Style="vertical-align: middle;">

</asp:DropDownList>

<br />

<asp:Literal ID="ltrTo" runat="server"

Text="Select Currency convert to :"></asp:Literal>

<asp:DropDownList ID="ddlTo" runat="server"

Style="vertical-align: middle;">

</asp:DropDownList>

<br />

</div>

<asp:Button ID="Button1" runat="server"

Text="Button" onclick="Button1_Click" />

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

Currency Conversion Using JavaScript

<script type="text/javascript">

function convert() {

var fromCur = document.getElementById('txtVal').value +
document.getElementById('ddlFrom').value;

var ToCur = document.getElementById('ddlTo').value;

var strURL = 'http://www.google.com/ig/calculator?hl=en&q=' +

fromCur + '=?' + ToCur
//Url like this " http://www.google.com/ig/calculator?hl=en&q=1USD=?EUR"

var request = new XMLHttpRequest();

request.open("GET", strURL, false);

request.send(null);

if (request.responseText != "") {

document.getElementById('dv').innerHTML =

request.responseText.split('"')[1] + ' = '

+ request.responseText.split('"')[3]

}

}

</script>

HTML :

Enter Value to convert :<input type="text" id="txtVal" />

<br />

<asp:Literal ID="ltrfrom" runat="server"

Text="Select Currency to convert :">

</asp:Literal>

<asp:DropDownList ID="ddlFrom" runat="server"

Style="vertical-align: middle;">

<asp:ListItem Text="SELECT" Value="0"></asp:ListItem>

<asp:ListItem Text="US Dollar" Value="USD"></asp:ListItem>

<asp:ListItem Text="Rupees" Value="INR"></asp:ListItem>

<asp:ListItem Text="GB Pound" Value="GBP"></asp:ListItem>

<asp:ListItem Text="Australia Dollar" Value="AUD"></asp:ListItem>

<asp:ListItem Text="CAnada Dollar" Value="CAD"></asp:ListItem>

<asp:ListItem Text="Switzerland Frank" Value="CHF"></asp:ListItem>

<asp:ListItem Text="Euro" Value="EUR"></asp:ListItem>

</asp:DropDownList>

<br />

<asp:Literal ID="ltrTo" runat="server"

Text="Select Currency convert to :">

</asp:Literal>

<asp:DropDownList ID="ddlTo" runat="server"

Style="vertical-align: middle;">

<asp:ListItem Text="SELECT" Value="0"></asp:ListItem>

<asp:ListItem Text="US Dollar" Value="USD"></asp:ListItem>

<asp:ListItem Text="Rupees" Value="INR"></asp:ListItem>

<asp:ListItem Text="GB Pound" Value="GBP"></asp:ListItem>

<asp:ListItem Text="Australia Dollar" Value="AUD"></asp:ListItem>

<asp:ListItem Text="CAnada Dollar" Value="CAD"></asp:ListItem>

<asp:ListItem Text="Switzerland Frank" Value="CHF"></asp:ListItem>

<asp:ListItem Text="Euro" Value="EUR"></asp:ListItem>

</asp:DropDownList>

<br />

<input type="button" value="Get" onclick="convert();" />

<div id="dv">

</div>

Custom paging in SQL Server

CREATE PROCEDURE [ProcedureName]

(

    @CurrentIndex int,

    @PageSize int

)

AS

SELECT * FROM(

          SELECT ROW_NUMBER() over(order by ProductID) AS RowId,

                     Product_Name

          FROM    Products

    )a

WHERE RowId BETWEEN (@CurrentIndex -1) * @TotalPageSize+ 1

                      AND     (@CurrentIndex  * @TotalPageSize )