Thursday, November 27, 2008

The use Of window.opener function in Java Script .

HI All.


Today I m going to describe the use of the window.opner function .Basically It is used to update the Value Of parent page from the child pop Up page.

The fully described code is given as below.

Step 1.) Parent Page.

A.) Script of the parent page :


function goChild()
{

window.open("~\WindowOpener\ChildPage.aspx");

}



B.)HTML of this page is :

[form id="form1" runat="server"]
[div]
[asp:Label ID="lblSum" runat="server" /][br /]

[br /]
[asp:Button ID="btnChild" OnClientClick="goChild();" Text="PopUp Open" runat="server" / /]
[br /]
[/div]
[/form]

C.) The Code Behind File of the Page.

There is no need to write any line of the code for this little Example




Step 2.)child Popup page.


A.) Script of the Child popUp page

function SumAndGO(varValue)
{
self.close();
window.opener.document.getElementById('lblSum').innerHTML=varValue;
}
function Validation(varValue)
{
for(i=0; i< varValue.length ;i++)
{
alert(varValue.charCodeAt(i));
}
}



B.) HTML of this page is :

[body]
[form id="form1" runat="server"]
[div]
Number 1: [asp:TextBox onblur="Validation(this.value);" ID="TxtNum1" runat="server"][/asp:TextBox][br /]
Number 1: [asp:TextBox ID="TxtNum2" runat="server"][/asp:TextBox][br /]
[asp:Button ID="btnSum" runat="server" Text="Go For Sum" OnClick="btnSum_Click" /]
[/div]
[/form]
[/body]




c.) The Code Behind File of the Page.

protected void btnSum_Click(object sender, EventArgs e)
{
int sum = Convert.ToInt32(TxtNum1.Text) + Convert.ToInt32(TxtNum2.Text);
string Jscript = "SumAndGO(" + sum + ")";
Jscript = "";
ClientScript.RegisterStartupScript(typeof(Page), "Jscript", Jscript);
}




Regards:
Sanjeev Chauhan

Tuesday, November 25, 2008

How To Register Client Script Inside Update Panel.

Hi EveryBody...

To use client script inside an update panel at runtime, you have to use "ScriptManager.RegisterClientScriptBlock". Just check if the input parameters are right, say for example you have:

ScriptManager.RegisterClientScriptBlock(UpdatePanelName, UpdatePanelName.GetType(), "jscript", "JavaScript Function", true);

Here parameter 1: the name of your update panel (Control Name).
parameter 2: you are passing the type of control, you have GetType() function which returns the type of control
parameter 3: telling it is "jscript" you want to execute
parameter 4: the name of the JavaScript function you want to call
parameter 5: true to enclose the script block in tags; otherwise, false.

For example we can use it as given below:-

string JScript = string.Empty;
JScript = "alert('Jai Sri RamChandra ji maharaaj')";
JScript = "[script language='javascript']" + JScript + "[/script]";
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, UpdatePanel1.GetType(), "JScript", JScript,false);




Hope this improves your coding.

Sanjeev Chauhan

Friday, November 21, 2008

Set The Default Enter button

HI

Now some kidding with a small and easy javascript stuff.



Set The Default Enter button on any textbox when we press the Enter

// this.txtusername.Attributes.Add("onkeydown", "if(event.which || event.keyCode){if ((event.which == 13) || (event.keyCode == 13)) {document.getElementById('" + imgbtnlogin.UniqueID + "').click();return false;}} else {return true}; "); this.txtpwd.Attributes.Add("onkeydown", "if(event.which || event.keyCode){if ((event.which == 13) || (event.keyCode == 13)) {document.getElementById('" + imgbtnlogin.UniqueID + "').click();return false;}} else {return true}; "); this.imgbtnlogin.Attributes.Add("onkeydown", "if(event.which || event.keyCode){if ((event.which == 13) || (event.keyCode == 13)) {document.getElementById('" + imgbtnlogin.UniqueID + "').click();return false;}} else {return true}; ");



Sanjeev Kumar

Using of Javascript Trim Functions

Hello again ..


The follwing code can be used to trim the string in java script.



function trim(stringToTrim) {
return stringToTrim.replace(/^\s+|\s+$/g,"");
}
function ltrim(stringToTrim) {
return stringToTrim.replace(/^\s+/,"");
}
function rtrim(stringToTrim) {
return stringToTrim.replace(/\s+$/,"");
}

// example of using trim, ltrim, and rtrim
var myString = " hello my name is ";
alert("*"+trim(myString)+"*");
alert("*"+ltrim(myString)+"*");
alert("*"+rtrim(myString)+"*");


Regards:
Sanjeev Chaudhary

How to call Javascript after pageLoad Within UpdatePanel Like ClientScript...

Hi Every Body..

Today we are here to discuss really a vary interesting topic. You will enjoy it and it is vary usefull in several conditions.
How to call Javascript after some processing in Codebehind when we are in a update panel You know. clientscript is not working with update panel and master Page. So ummm.. there is problem. after a long googleing and some RnD finally I got the sloution.
The step for solution is geiven Below...

1.) On HTML page write the follwing line of code in java script


function load() {
Sys.WebForms.PageRequestManager.getInstance().add_endRequest(testfunction);
}
In above "testfunction" is our java script function which we want to call in C# code after some processing within an Update Panel.

2.)
write the function as below:
function testfunction()
{
var i=0;
var ctrl = document.getElementById('ctl00_ContentPlaceHolder1_hid');
// Where ctl00_ContentPlaceHolder1_hid is an hiden field which is used to get updated value from code behind.
if(ctrl.value!="Some Condition")
{
// here Put your code which you want after page load..
}

}


3.)Now move to Code Behind...C# File of the page

on Page LoadEvent
protected void Page_Load(object sender, EventArgs e)
{
imgButton.Attributes.Add("onload", "load()");
// Do your Coding as per requirment...
}

4.) Look in to Click Event of the "imgButton" button

protected void imgButton_Click(object sender, ImageClickEventArgs e)
{
hid.Value=""; // Vocate the hidden field if it has some value ie. used to call script.
// do Your coding as per the requirment
If(Condtion)// The condtion on which you want to call java script..
{
//Update the value of the hidden field "hid"
hid.Value ="Your Comment as per the Condition";
}
else
{
hid.Value="";// again Vocate the hidden field...
}
imgButton.Attributes.Clear();// To prevent call script again and again.
//It is Esential.Please note that

}

5.) In the same way You can call script whenever you want just by repeating this process



Enjoy surfing our blog..

Sanjeev Kumar /Mahesh Sharma
On behalf of HelpOnDesk Team

Saturday, November 15, 2008

How to Cerate BookMark/Add Favourites in FireFox/IE

Hi EveryBody...

Today I want to discuss with you how add "Add Favourites" in IE browser or "Add BookMark" in firefox acoording to the browser.This is very Simple just go through with the following code.


[html]
[head id="Head1" runat="server"]
[title]How to Cerate BookMark/Add Favourites in FireFox/IE[/title]
[script language="JavaScript" type="text/javascript"]
function BodyOnload()
{
var myLink=document.getElementById("myLink");
if (document.all)
{
myLink.innerHTML="Add to Favorites";
}
else if (window.sidebar)
{
myLink.innerHTML="Add Bookmark";
}
}
function bookmarksite()
{
if (document.all)
{
window.external.AddFavorite(location.href, document.title);
}
else if (window.sidebar)
{
window.sidebar.addPanel(document.title, location.href, "");
}

}
[/script]

[/head]
[body onload="BodyOnload();"]
[a href="javascript:bookmarksite();" style="color: Blue;" id="myLink"]InnerHTML[/a]
[/body]
[/html]


Enjoy coding...
Sanjeev Chauhan

Wednesday, November 12, 2008

The correct script for detecting the mouse coordinates...

Hi...
Dear friend Now again I am here with a very good post which get you free from tension of calculating the co-ordinates(X and Y) of mouse clicking .

function doSomething(e) {
var posx = 0;
var posy = 0;
if (!e) var e = window.event;
if (e.pageX || e.pageY) {
posx = e.pageX;
posy = e.pageY;
}
else if (e.clientX || e.clientY) {
posx = e.clientX + document.body.scrollLeft
+ document.documentElement.scrollLeft;
posy = e.clientY + document.body.scrollTop
+ document.documentElement.scrollTop;
}
// posx and posy contain the mouse position relative to the document
// Do something with this information
}

And Also I have something more of calculating the C0-0rdinates(X and Y) of any HTML object (eg: Textbox or any other.) so I am giving you 2 javascript function look them...


function findPosX(obj)
{
var curleft = 0;
if(obj.offsetParent)
while(1)
{
curleft += obj.offsetLeft;
if(!obj.offsetParent)
break;
obj = obj.offsetParent;
}
else if(obj.x)
curleft += obj.x;
return curleft;
}

function findPosY(obj)
{
var curtop = 0;
if(obj.offsetParent)
while(1)
{
curtop += obj.offsetTop;
if(!obj.offsetParent)
break;
obj = obj.offsetParent;
}
else if(obj.y)
curtop += obj.y;
return curtop;
}







Enjoy scripting...
Sanjeev Kumar Chauhan
(On Behalf Of Help On Desk Team)

Tuesday, November 11, 2008

sp is used for get split string from coma

This Stored Procedure is used for get values from CSV.
e.g a,b,c,d,e,f is split by coma


create proc [dbo].[ufn_CountChar] ( @pInput VARCHAR(1000), @pSearchChar CHAR(1) )
as
BEGIN

/*DECLARE @vInputLength INT*/
DECLARE @vIndex INT
DECLARE @vCount INT
DECLARE @s varchar(2)
DECLARE @str varchar(10)
declare @SubStr varchar(1000)

set @SubStr=''
SET @vCount = 0
SET @vIndex = 1
/*SET @vInputLength = LEN(@pInput)*/
set @str=''

WHILE @vIndex <= len(@pInput)
BEGIN
IF SUBSTRING(@pInput, @vIndex, 1) = @pSearchChar
BEGIN
SET @vCount = @vCount + 1
set @SubStr = substring(@pInput,len(@SubStr),len( @str))
select @str
set @str=''
END
else
BEGIN
set @s=SUBSTRING(@pInput,@vindex,1)
set @str=@str+@s
print ' i m in else part'+ space(3)+ @str
if( @vIndex = len(@pInput))
begin
select @str
end

END
SET @vIndex = @vIndex + 1

END

--select @str


END
GO

ufn_CountChar 'afd,hghg,hgjgh',','

Thankks
helpondesk team

http://aspalliance.com/1125_Dynamically_Templated_GridView_with_Edit_Delete_and_Insert_Options.all

http://www.dotnetcurry.com/ShowArticle.aspx?ID=107&AspxAutoDetectCookieSupport=1

select all values in csv format

This SP is used for the create CSV values
like A,B,C,D,E

CREATE FUNCTION SEL_MAIL(@Email varchar(100))
RETURNS varchar(100)
AS
BEGIN

DECLARE @xyz VARCHAR(100)
declare @abc varchar(100)

set @abc=' '

declare selemail cursor for

select email from dataadi

open selemail
fetch NEXT from selemail into @xyz
WHILE @@Fetch_status = 0
begin


set @abc= @abc+ @xyz+','

FETCH NEXT FROM selemail INTO @xyz
END

CLOSE selemail
DEALLOCATE selemail

return @abc
END

--Sample table schema

Create table SchemaID([ID] smallint,SchemaID int NOT NULL)

--Dummy insert statements

Insert into SchemaID values (1,12)Insert into SchemaID values (1,13)Insert into SchemaID values (1,14)Insert into SchemaID values (2,15)Insert into SchemaID values (2,16)Insert into SchemaID values (2,17)Insert into SchemaID values (2,18)

--Solution

Declare @ID varchar(100)
Select @id=Coalesce(@ID + ', ', '') + Cast(SchemaID AS varchar(5)) From SchemaID Where [ID] = 1 SELECT @ID

Thanks
helpondesk team

Monday, November 10, 2008

How to print a specified div only rather than a complete page..

Hi..

This time here is some java script stuff. the follwing function is used to print the specific div from the page..
now simply call this function whereEver you want as per the requirment.


function CallPrint()
{
{
var prtContent1 = document.getElementById("ctl00_ContentPlaceHolder1_PrintALL");
//var WinPrint = window.open('','','letf=1,top=1,width=100,height=100,toolbar=0,scrollbars=0,status=0');
var WinPrint = window.open('','');
WinPrint.document.write(prtContent1.innerHTML);
//WinPrint.document.close();
WinPrint.focus();
//WinPrint.print();
//WinPrint.close();
}
}

Have a Nice Day
sanjeev Kumar...

CODE BEHIND FILE OF CUSTOM PAGING...

Hi ..

plase find the code for custom paging here it is very simple..

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 BusenessObject;
using BusenessLogic;

public partial class CustomPaging : System.Web.UI.Page
{
BusenessObject.CustomPagingBo oCustomPaging = new CustomPagingBo();
int UserId = 1;
int PageSize = 1;
int GridCurrentPageIndex;
protected void Page_Load(object sender, EventArgs e)
{
if (ViewState["GridCurrentPageIndex"] != null && ViewState["GridCurrentPageIndex"].ToString() != "")
{
GridCurrentPageIndex = Convert.ToInt32(ViewState["GridCurrentPageIndex"]);

}
else
{
GridCurrentPageIndex = 1;

}
DisplayBottomPageLinks();
}



protected void click_PreviousPage(object sender, EventArgs e)
{
GridCurrentPageIndex = GridCurrentPageIndex - 1;
Searching();
DisplayBottomPageLinks();
}


protected void BtnShowUser_Click(object sender, EventArgs e)
{
Searching();
}

public void Searching()
{
ViewState["imgClick"] = "Image_Search";
oCustomPaging.Uid = UserId;
oCustomPaging.GridPageSize = PageSize;
oCustomPaging.GridCurrentPageIndex = GridCurrentPageIndex;
DisplayUser();
}
public void DisplayUser()
{
DataList1.DataSource = CustomPagingBl.GetImageData(oCustomPaging);
DataList1.DataBind();
ViewState["count"] = oCustomPaging.TotalRecords;
if (ViewState["GridCurrentPageIndex"] != null && ViewState["GridCurrentPageIndex"].ToString() != "")
{
GridCurrentPageIndex = Convert.ToInt32(ViewState["GridCurrentPageIndex"]);
}
else
{
GridCurrentPageIndex = 1;
}
DisplayBottomPageLinks();
}

protected void DisplayBottomPageLinks()
{
if (ViewState["GridCurrentPageIndex"] != null && ViewState["GridCurrentPageIndex"].ToString() != "")
{
GridCurrentPageIndex = Convert.ToInt32(ViewState["GridCurrentPageIndex"]);
}
else
{
GridCurrentPageIndex = 1;
}

// Following code is used for the Gridview paging
Int32 count;
int showPages = 3;// 4; or 5 or 6 as you want (This is the key variable...)
//The variable showPages is used to show the no. of Pages you want to show at One time on the page..

Panel pnlPaging = Page.FindControl("pnlPaging") as Panel;
pnlPaging.Controls.Clear();
count = Convert.ToInt32(ViewState["count"]);
GetPageLinks(pnlPaging, GridCurrentPageIndex, PageSize, count, showPages);

}
public void GetPageLinks(Panel pnlPaging,int CurrentPageIndex, int pageSize, int totalRecords, int showPages)
{
#region Paging pageIndex
LinkButton lnk;
//int pageSize = PageSize;// To Give the page size ....
int totalPages = totalRecords / pageSize;
if (totalRecords % pageSize > 0)
{
totalPages += 1;
}
if (totalPages > 1)
{

for (int i = 0; i < totalPages; i++)
{
int pageNo = i + 1;

if (i != (CurrentPageIndex - 1))
{
if (i <= showPages)
{

if (i != showPages)
{
lnk = new LinkButton();
lnk.ID = "linkpage" + pageNo.ToString();
lnk.Text = pageNo.ToString() + " ";
lnk.CausesValidation = false;
lnk.CommandArgument = pageNo.ToString();
lnk.CommandName = "Paging_click";
lnk.Command += new CommandEventHandler(lnk_Command);
lnk.ToolTip = pageNo.ToString();
pnlPaging.Controls.Add(lnk);


}
if (i == showPages)
{

lnk = new LinkButton();
lnk.ID = "linkpage" + pageNo.ToString();
lnk.Text = " .. ";
lnk.CausesValidation = false;

lnk.CommandArgument = pageNo.ToString();
lnk.CommandName = "Paging_click";
lnk.Command += new CommandEventHandler(lnk_Command);
lnk.ToolTip = pageNo.ToString();
pnlPaging.Controls.Add(lnk);
}

}
if (CurrentPageIndex > showPages)
{
int x;
pnlPaging.Controls.Clear();
lnk = new LinkButton();
lnk.ID = "linkpage1";
lnk.Text = " << ";
lnk.CausesValidation = false;
lnk.CommandArgument = "1";
lnk.CommandName = "Paging_click";
lnk.ToolTip = "1";
lnk.Command += new CommandEventHandler(lnk_Command);

pnlPaging.Controls.Add(lnk);
lnk = new LinkButton();
lnk.ID = "linkpage" + (CurrentPageIndex - 1).ToString();
lnk.Text = " .. ";
lnk.CausesValidation = false;
lnk.CommandArgument = (CurrentPageIndex - 1).ToString();
lnk.CommandName = "Paging_click";
lnk.Command += new CommandEventHandler(lnk_Command);
lnk.ToolTip = (CurrentPageIndex - 1).ToString();
lnk.CssClass = "Paging";
pnlPaging.Controls.Add(lnk);

for (x = 0; x < showPages; x++)
{
if ((CurrentPageIndex + x) < totalPages)
{

lnk = new LinkButton();
lnk.ID = "linkpage" + (CurrentPageIndex + x).ToString();
lnk.Text = (CurrentPageIndex + x).ToString() + " ";
lnk.CausesValidation = false;
lnk.CommandArgument = (CurrentPageIndex + x).ToString();
lnk.CommandName = "Paging_click";
lnk.ToolTip = (CurrentPageIndex + x).ToString(); ;

lnk.Command += new CommandEventHandler(lnk_Command);
pnlPaging.Controls.Add(lnk);
}
}
if (x == showPages && (CurrentPageIndex + x) <= totalPages)
{

lnk = new LinkButton();
lnk.ID = "linkpage" + (CurrentPageIndex + x).ToString();
lnk.Text = " .. ";
lnk.CausesValidation = false;
lnk.CommandArgument = (CurrentPageIndex + x).ToString();
lnk.CommandName = "Paging_click";
lnk.Command += new CommandEventHandler(lnk_Command);
lnk.ToolTip = (CurrentPageIndex + x).ToString();
pnlPaging.Controls.Add(lnk);
}
}
if (i == (totalPages - 1) && (CurrentPageIndex != totalPages) && (totalPages > (showPages + 1)))
{

lnk = new LinkButton();
lnk.ID = "linkpage1" + totalPages.ToString();
lnk.Text = " >> ";
lnk.CausesValidation = false;
lnk.CommandArgument = totalPages.ToString();
lnk.CommandName = "Paging_click";
lnk.Command += new CommandEventHandler(lnk_Command);
lnk.ToolTip = totalPages.ToString();
pnlPaging.Controls.Add(lnk);
}

if (CurrentPageIndex > (totalPages - showPages))
{

if (CurrentPageIndex == totalPages)
{
pnlPaging.Controls.Clear();
lnk = new LinkButton();
lnk.ID = "linkpage1";
lnk.Text = " << ";
lnk.CausesValidation = false;
lnk.CommandArgument = "1";
lnk.CommandName = "Paging_click";
lnk.ToolTip = "1";
lnk.Command += new CommandEventHandler(lnk_Command);
pnlPaging.Controls.Add(lnk);

lnk = new LinkButton();
lnk.ID = "linkpage" + (totalPages - (showPages + 1)).ToString();
lnk.Text = " .. ";
lnk.CausesValidation = false;
lnk.CommandArgument = (totalPages - (showPages + 1)).ToString();
lnk.CommandName = "Paging_click";
lnk.Command += new CommandEventHandler(lnk_Command);
lnk.ToolTip = (totalPages - (showPages + 1)).ToString();
pnlPaging.Controls.Add(lnk);
for (int x = (showPages - 1); x > 0; x--)
{
lnk = new LinkButton();
lnk.ID = "linkpage" + (totalPages - x).ToString();
lnk.Text = (totalPages - x).ToString() + " ";
lnk.CausesValidation = false;
lnk.CommandArgument = (totalPages - x).ToString();
lnk.CommandName = "Paging_click";
lnk.Command += new CommandEventHandler(lnk_Command);
lnk.ToolTip = (totalPages - x).ToString();
pnlPaging.Controls.Add(lnk);
}
}
else
{
pnlPaging.Controls.Clear();
lnk = new LinkButton();
lnk.ID = "linkpage1";
lnk.Text = " << ";
lnk.CausesValidation = false;
lnk.CommandArgument = "1";
lnk.CommandName = "Paging_click";
lnk.ToolTip = "1";
lnk.Command += new CommandEventHandler(lnk_Command);
pnlPaging.Controls.Add(lnk);

lnk = new LinkButton();
lnk.ID = "linkpage" + (totalPages - (showPages + 1)).ToString();
lnk.Text = " .. ";
lnk.CausesValidation = false;
lnk.CommandArgument = (totalPages - (showPages + 1)).ToString();
lnk.CommandName = "Paging_click";
lnk.Command += new CommandEventHandler(lnk_Command);
lnk.ToolTip = (totalPages - (showPages + 1)).ToString();
pnlPaging.Controls.Add(lnk);
for (int x = showPages; x > 0; x--)
{
lnk = new LinkButton();
lnk.ID = "linkpage" + (totalPages - x).ToString();
lnk.Text = (totalPages - x).ToString() + " ";
lnk.CausesValidation = false;
lnk.CommandArgument = (totalPages - x).ToString();
lnk.CommandName = "Paging_click";
lnk.Command += new CommandEventHandler(lnk_Command);
lnk.ToolTip = (totalPages - x).ToString();
pnlPaging.Controls.Add(lnk);
}

lnk = new LinkButton();
lnk.ID = "linkpage1" + totalPages.ToString();
lnk.Text = " >> ";
lnk.CausesValidation = false;
lnk.CommandArgument = totalPages.ToString();
lnk.CommandName = "Paging_click";
lnk.ToolTip = totalPages.ToString();
lnk.Command += new CommandEventHandler(lnk_Command);
pnlPaging.Controls.Add(lnk);

}
}
}

else
{
if (i == (CurrentPageIndex - 1))
{
lnk = new LinkButton();
lnk.ID = "linkpage" + pageNo.ToString();
lnk.Text = pageNo.ToString() + " ";
lnk.CausesValidation = false;
lnk.ToolTip = pageNo.ToString();
//lnk.Attributes["OnClick"] = "return false;";
lnk.Enabled = false;
lnk.Style["cursor"] = "text";
pnlPaging.Controls.Add(lnk);

}
}

}
}


#endregion
}
void lnk_Command(Object sender, CommandEventArgs e)
{
Panel pnlPaging = (Panel)Page.FindControl("pnlPaging");
ViewState["linkId"] = e.CommandArgument.ToString();
if (e.CommandName == "FirstPaging_click")
{
GridCurrentPageIndex = Convert.ToInt32(e.CommandArgument);
ViewState["GridCurrentPageIndex"] = GridCurrentPageIndex;
}
else if (e.CommandName == "Paging_click")
{
GridCurrentPageIndex = Convert.ToInt32(e.CommandArgument);
ViewState["GridCurrentPageIndex"] = GridCurrentPageIndex;
}
Searching();
LinkButton lnk = (LinkButton)pnlPaging.FindControl("linkpage" + ViewState["linkId"].ToString());
lnk.Enabled = false;

}
}




Thanks :
Sanjeev Chauhan
HelpOnDesk Team

STORED PROCEDURE FOR CUSTOM PAGING...

Hi EveryBody...
I am again here with my new post.The follwing post is for how to write a good stored procedure for custom paging.I m not saying that it is the best SP..can assure you that is good enough.the SP is here..


CREATE PROC USP_DEMO_PAGING
(
@UID INT,
@GridCurrentPageIndex INT,
@GridPageSize INT
)
AS
BEGIN

DECLARE @LastDisplayingRecordIndex int -- To store the index number of last displayed records in Grid in .NET page. For next page it will start by increment last index by 1.
DECLARE @MaxDisplayingRecordIndex int -- To store upto which index records should be display.

SET @LastDisplayingRecordIndex = @GridPageSize * (@GridCurrentPageIndex-1)
SET @MaxDisplayingRecordIndex = @GridPageSize * @GridCurrentPageIndex

-- VARIABLE DECLARATION FOR DYNAMIC QUERY PARTS TO BE USED IN PAGING

DECLARE @SelectQueryWhere varchar(500)-- Used to put the condtion of lower and higher record index
DECLARE @QueryCount varchar(max) -- Used to count the total records.

DECLARE @SelectMainQuery varchar(500) -- To store the selected column part of the SELECT statement
DECLARE @SelectMainQueryResultSet varchar(7000) -- To store the result set query with Row_Number
DECLARE @SelectWhereCreteria varchar(4000)
DECLARE @SelectJoinPart varchar(max)
DECLARE @SelectOrderByPart varchar(255)



SET @SelectQueryWhere = ') _Results WHERE RowNumber > ' + Convert(varchar,@LastDisplayingRecordIndex) + ' And RowNumber <= ' + Convert(varchar,@MaxDisplayingRecordIndex)
SET @SelectOrderByPart='' -- Please mentioned If any

SET @QueryCount = 'SELECT count(UID) from userImage' -- It Used for Counting all the Records

SET @SelectMainQuery ='SELECT ImageID,UID,USERNAME,USERIMAGE,ROW_NUMBER()over (order by ImageID) AS RowNumber from userImage'
SET @SelectJoinPart =''-- There is any Joins Please put here
SET @SelectWhereCreteria = ' where UId = '+ Convert(varchar,@UID)--Here You Can put Your Calculated Where Creteria
SET @SelectMainQueryResultSet = @SelectMainQuery + @SelectJoinPart + @SelectWhereCreteria
SET @SelectMainQueryResultSet = 'SELECT * FROM ('+ @SelectMainQueryResultSet + @SelectQueryWhere + @SelectOrderByPart
SET @QueryCount = @QueryCount + @SelectJoinPart + @SelectWhereCreteria

EXEC(@SelectMainQueryResultSet)
--PRINT @SelectMainQueryResultSet

EXEC(@QueryCount)

--PRINT @QueryCount
END


Happy Coding...
truely yours:
Sanjeev Chaudhary

Thursday, November 6, 2008

How To Make Loan Calculator For Financial Sites

Hi Friends...
Today I'm going to describe you How to make a good loan calculator.That returns you the TotalAmortization Amount and the total Time period in Months as well as in Years Also..
so now the time for having a look on the code and change it according to your need...Code is below:-


///
/// Purpose:This is used for calculating the MortgageLoan...
///

/// Sanjeev Chauhan
/// November 6,2008
///
///
protected void btnCalculate_Click(object sender, EventArgs e)
{
#region The Concept And Formula Derivation By Sanjeev

/*For this I have used the Following Formula Which I have Derived After a long calculation
BY USING THIS FORMULA WE CAN CALCULATE THE UNKNOWN TERM...
(1+ R/12)pow T = 12x/(12x-PR)
FOR CALUCULATING THE TOTAL MORTGAGE AMOUNT WE CAN USE THE FOLLOWING FORMULA
A =P(1+r/12)^T
OR U CAN SAY
A =P(1+r/12)^T

WHERE P= Primary Amount ,A=Final Amount ,T= Total Amount
R=Rate(rate/100(convert to points from %age)) ,x = MOnthly Installing Amount
*/

#endregion

double dblAmount, dblTotalAmt, dblInstallment, dblRate, dblTime;
dblAmount = Convert.ToDouble(txtAmount.Text);
dblInstallment = Convert.ToDouble(txtMontlypayment.Text);
dblRate = Convert.ToDouble(txtRate.Text) / 100;
double logBasevalue = 1 + (dblRate / 12);
double logValue = (12 * dblInstallment) / (12 * dblInstallment - (dblAmount * dblRate));
dblTime = Math.Log(logValue, logBasevalue);
double roundMonth = Math.Round(dblTime);
roundMonth = roundMonth < dblTime ? roundMonth + 1 : roundMonth;
double dblYear =roundMonth / 12;
double roundYear = Math.Round(dblYear, 1);
string strYear = Convert.ToString(roundYear);
dblTotalAmt = Math.Round((dblInstallment * dblTime), 2);
lblMonths.Text = roundMonth.ToString();
lblYears.Text = strYear.Substring(0, strYear.LastIndexOf('.') + 2);
lblTotalAmount.Text = dblTotalAmt.ToString();

}



Enjoy Blogging..

Sanjeev Chaudhary