Calling Innovative

[innovative]

[quote name='HAPPYNESS' timestamp='1372862472' post='1303915240']
reported [img]http://lh3.ggpht.com/-oPHs6L73geM/UViwz4-n6nI/AAAAAAAALXI/vESDOee3pnQ/s180/IB.gif[/img]
[/quote]
[quote name='chittimallu8' timestamp='1372862494' post='1303915241']
nee reply choosthe sasthadu
[/quote]

[king420]

[quote name='innovative' timestamp='1372862441' post='1303915238']

enti ee swings code using frames ... naaku em akkarla .. simple JDBC results , JSP lo print kavali ... adhi choodu
[/quote]
oho JSP lo print kavala ....mari daniki kuda back end frames...Grid kavali ....Onclick table results vary ayye requirement emanna unda?

[innovative]

[quote name='HAPPYNESS' timestamp='1372862694' post='1303915255']
oho JSP lo print kavala ....mari daniki kuda back end frames...Grid kavali ....Onclick table results vary ayye requirement emanna unda?
[/quote]

yup .. backend nunchi result set pampaka .. how to display on front end depending on result set .. adhi matter ..

yaa depends on user input, resultset real time lo vary avthadhi so obvious ga table num of rows n columns kooda .. clear na ?

[king420]

[quote name='innovative' timestamp='1372862868' post='1303915269']

yup .. backend nunchi result set pampaka .. how to display on front end depending on result set .. adhi matter ..

yaa depends on user input, resultset real time lo vary avthadhi so obvious ga table num of rows n columns kooda .. clear na ?
[/quote]

aa clear clear....[img]http://lh3.ggpht.com/-oPHs6L73geM/UViwz4-n6nI/AAAAAAAALXI/vESDOee3pnQ/s180/IB.gif[/img] idigoo


[background=yellow]<%@[/background][color=#800000] taglib uri[/color][color=blue]="[/color][color=blue]/WEB-INF/tags/datagrid.tld"[/color][color=red] prefix[/color][color=blue]="[/color][color=blue]grd"[/color][color=red] [/color][background=yellow]%>[/background]
[background=yellow]<%@[/background][color=#800000] page import[/color][color=blue]="[/color][color=blue]java.sql.Connection"[/color][color=red] [/color][background=yellow]%>[/background]
[background=yellow]<%@[/background][color=#800000] page import[/color][color=blue]="[/color][color=blue]java.sql.DriverManager"[/color][color=red] [/color][background=yellow]%>[/background]
[background=yellow]<%@[/background][color=#800000] page import[/color][color=blue]="[/color][color=blue]java.sql.SQLException"[/color][color=red] [/color][background=yellow]%>[/background]
[background=yellow]<%@[/background][color=#800000] page import[/color][color=blue]="[/color][color=blue]com.freeware.gridtag.*"[/color][color=red] [/color][background=yellow]%>[/background]
[background=yellow]<%[/background]
int intCurr = 1;
int intSortOrd = 0;
[color=blue]String[/color] strTmp = null;
[color=blue]String[/color] strSQL = null;
[color=blue]String[/color] strSortCol = null;
[color=blue]String[/color] strSortOrd = [color=purple]"[/color][color=purple]ASC"[/color];
[color=blue]boolean[/color] blnSortAsc = true;
strSQL = [color=purple]"[/color][color=purple]SELECT CLICORPORATION, CLICLIENT, CLIDESCRIPTION, "[/color] +
[color=purple]"[/color][color=purple]CLIENABLED, CLIUPDSTAMP FROM CLIENTMASTER "[/color];
Connection objCnn = null;
[color=blue]Class[/color] objDrvCls = null;
objDrvCls = [color=blue]Class[/color].forName([color=purple]"[/color][color=purple]oracle.jdbc.driver.OracleDriver"[/color]);
objCnn = DriverManager.getConnection([color=purple]"[/color][color=purple]jdbc:oracle:thin:@Host:port:sid"[/color],
[color=purple]"[/color][color=purple]cashincpri"[/color], [color=purple]"[/color][color=purple]cashincpri"[/color]);
[color=blue]if[/color] (objDrvCls != null) objDrvCls = null;
strTmp = request.getParameter([color=purple]"[/color][color=purple]txtCurr"[/color]);
[color=blue]try[/color]
{
[color=blue]if[/color] (strTmp != null)
intCurr = [color=blue]Integer[/color].parseInt(strTmp);
}
[color=blue]catch[/color] (NumberFormatException NFEx)
{
}
strSortCol = request.getParameter([color=purple]"[/color][color=purple]txtSortCol"[/color]);
strSortOrd = request.getParameter([color=purple]"[/color][color=purple]txtSortAsc"[/color]);
[color=blue]if[/color] (strSortCol == null) strSortCol = [color=purple]"[/color][color=purple]CLICLIENT"[/color];
[color=blue]if[/color] (strSortOrd == null) strSortOrd = [color=purple]"[/color][color=purple]ASC"[/color];
blnSortAsc = (strSortOrd.equals([color=purple]"[/color][color=purple]ASC"[/color]));
[background=yellow]%>[/background]
[color=blue]<[/color][color=#800000]html[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]head[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]title[/color][color=blue]>[/color]Grid Tag Demonstration[color=blue]<[/color][color=blue]/[/color][color=#800000]title[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]link[/color] [color=red]REL[/color][color=blue]="[/color][color=blue]StyleSheet"[/color] [color=red]HREF[/color][color=blue]="[/color][color=blue]css/GridStyle.css"[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]script[/color] [color=red]LANGUAGE[/color][color=blue]="[/color][color=blue]javascript"[/color][color=blue]>[/color]
[color=blue]function[/color] doNavigate(pstrWhere, pintTot)
{
[color=blue]var[/color] strTmp;
[color=blue]var[/color] intPg;
strTmp = document.frmMain.txtCurr.value;
intPg = parseInt(strTmp);
[color=blue]if[/color] (isNaN(intPg)) intPg = [color=navy]1[/color];
[color=blue]if[/color] ((pstrWhere == [color=purple]'[/color][color=purple]F'[/color] || pstrWhere == [color=purple]'[/color][color=purple]P'[/color]) && intPg == [color=navy]1[/color])
{
alert([color=purple]"[/color][color=purple]You are already viewing first page!"[/color]);
[color=blue]return[/color];
}
[color=blue]else[/color] [color=blue]if[/color] ((pstrWhere == [color=purple]'[/color][color=purple]N'[/color] || pstrWhere == [color=purple]'[/color][color=purple]L'[/color]) && intPg == pintTot)
{
alert([color=purple]"[/color][color=purple]You are already viewing last page!"[/color]);
[color=blue]return[/color];
}
[color=blue]if[/color] (pstrWhere == [color=purple]'[/color][color=purple]F'[/color])
intPg = [color=navy]1[/color];
[color=blue]else[/color] [color=blue]if[/color] (pstrWhere == [color=purple]'[/color][color=purple]P'[/color])
intPg = intPg - [color=navy]1[/color];
[color=blue]else[/color] [color=blue]if[/color] (pstrWhere == [color=purple]'[/color][color=purple]N'[/color])
intPg = intPg + [color=navy]1[/color];
[color=blue]else[/color] [color=blue]if[/color] (pstrWhere == [color=purple]'[/color][color=purple]L'[/color])
intPg = pintTot;
[color=blue]if[/color] (intPg < [color=navy]1[/color]) intPg = [color=navy]1[/color];
[color=blue]if[/color] (intPg > pintTot) intPg = pintTot;
document.frmMain.txtCurr.value = intPg;
document.frmMain.submit();
}
[color=blue]function[/color] doSort(pstrFld, pstrOrd)
{
document.frmMain.txtSortCol.value = pstrFld;
document.frmMain.txtSortAsc.value = pstrOrd;
document.frmMain.submit();
}
[color=blue]</[/color][color=#800000]script[/color][color=blue]>[/color]
[color=blue]<[/color][color=blue]/[/color][color=#800000]head[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]body[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]h2[/color][color=blue]>[/color]Grid Example[color=blue]<[/color][color=blue]/[/color][color=#800000]h2[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]form[/color] [color=red]NAME[/color][color=blue]="[/color][color=blue]frmMain"[/color] [color=red]METHOD[/color][color=blue]="[/color][color=blue]post"[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:dbgrid[/color] [color=red]id[/color][color=blue]="[/color][color=blue]tblStat"[/color] [color=red]name[/color][color=blue]="[/color][color=blue]tblStat"[/color] [color=red]width[/color][color=blue]="[/color][color=blue]100"[/color] [color=red]pageSize[/color][color=blue]="[/color][color=blue]10"[/color]
[color=red]currentPage[/color][color=blue]="[/color][color=blue]<%=intCurr%>"[/color] [color=red]border[/color][color=blue]="[/color][color=blue]0"[/color] [color=red]cellSpacing[/color][color=blue]="[/color][color=blue]1"[/color] [color=red]cellPadding[/color][color=blue]="[/color][color=blue]2"[/color]
[color=red]dataMember[/color][color=blue]="[/color][color=blue]<%=strSQL%>"[/color] [color=red]dataSource[/color][color=blue]="[/color][color=blue]<%=objCnn%>"[/color] [color=red]cssClass[/color][color=blue]="[/color][color=blue]gridTable"[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:gridpager[/color] [color=red]imgFirst[/color][color=blue]="[/color][color=blue]images/First.gif"[/color] [color=red]imgPrevious[/color][color=blue]="[/color][color=blue]images/Previous.gif"[/color]
[color=red]imgNext[/color][color=blue]="[/color][color=blue]images/Next.gif"[/color] [color=red]imgLast[/color][color=blue]="[/color][color=blue]images/Last.gif"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:gridsorter[/color] [color=red]sortColumn[/color][color=blue]="[/color][color=blue]<%=strSortCol%>"[/color] [color=red]sortAscending[/color][color=blue]="[/color][color=blue]<%=blnSortAsc%>"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:rownumcolumn[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]#"[/color] [color=red]width[/color][color=blue]="[/color][color=blue]5"[/color] [color=red]HAlign[/color][color=blue]="[/color][color=blue]right"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:imagecolumn[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]"[/color] [color=red]width[/color][color=blue]="[/color][color=blue]5"[/color] [color=red]HAlign[/color][color=blue]="[/color][color=blue]center"[/color]
[color=red]imageSrc[/color][color=blue]="[/color][color=blue]images/Edit.gif"[/color]
[color=red]linkUrl[/color][color=blue]="[/color][color=blue]javascript:doEdit('{CLICORPORATION}', '{CLICLIENT}')"[/color]
[color=red]imageBorder[/color][color=blue]="[/color][color=blue]0"[/color] [color=red]imageWidth[/color][color=blue]="[/color][color=blue]16"[/color] [color=red]imageHeight[/color][color=blue]="[/color][color=blue]16"[/color]
[color=red]alterText[/color][color=blue]="[/color][color=blue]Click to edit"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:textcolumn[/color] [color=red]dataField[/color][color=blue]="[/color][color=blue]CLICLIENT"[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]Client"[/color]
[color=red]width[/color][color=blue]="[/color][color=blue]10"[/color] [color=red]sortable[/color][color=blue]="[/color][color=blue]true"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:textcolumn[/color] [color=red]dataField[/color][color=blue]="[/color][color=blue]CLIDESCRIPTION"[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]Description"[/color]
[color=red]width[/color][color=blue]="[/color][color=blue]50"[/color] [color=red]sortable[/color][color=blue]="[/color][color=blue]true"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:decodecolumn[/color] [color=red]dataField[/color][color=blue]="[/color][color=blue]CLIENABLED"[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]Enabled"[/color] [color=red]width[/color][color=blue]="[/color][color=blue]10"[/color]
[color=red]decodeValues[/color][color=blue]="[/color][color=blue]Y,N"[/color] [color=red]displayValues[/color][color=blue]="[/color][color=blue]Yes,No"[/color] [color=red]valueSeperator[/color][color=blue]="[/color][color=blue],"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:datecolumn[/color] [color=red]dataField[/color][color=blue]="[/color][color=blue]CLIUPDSTAMP"[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]Last Updated"[/color]
[color=red]dataFormat[/color][color=blue]="[/color][color=blue]dd/MM/yyyy HH:mm:ss"[/color] [color=red]width[/color][color=blue]="[/color][color=blue]20"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=blue]/[/color][color=#800000]grd:dbgrid[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]input[/color] [color=red]TYPE[/color][color=blue]="[/color][color=blue]hidden"[/color] [color=red]NAME[/color][color=blue]="[/color][color=blue]txtCurr"[/color] [color=red]VALUE[/color][color=blue]="[/color][color=blue]<%=intCurr%>"[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]input[/color] [color=red]TYPE[/color][color=blue]="[/color][color=blue]hidden"[/color] [color=red]NAME[/color][color=blue]="[/color][color=blue]txtSortCol"[/color] [color=red]VALUE[/color][color=blue]="[/color][color=blue]<%=strSortCol%>"[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]input[/color] [color=red]TYPE[/color][color=blue]="[/color][color=blue]hidden"[/color] [color=red]NAME[/color][color=blue]="[/color][color=blue]txtSortAsc"[/color] [color=red]VALUE[/color][color=blue]="[/color][color=blue]<%=strSortOrd%>"[/color][color=blue]>[/color]
[color=blue]<[/color][color=blue]/[/color][color=#800000]form[/color][color=blue]>[/color]
[color=blue]<[/color][color=blue]/[/color][color=#800000]body[/color][color=blue]>[/color]
[color=blue]<[/color][color=blue]/[/color][color=#800000]html[/color][color=blue]>[/color]
[background=yellow]<%[/background]
[color=blue]try[/color]
{
[color=blue]if[/color] (objCnn != null)
objCnn.close();
}
[color=blue]catch[/color] (SQLException SQLExIgnore)
{
}
[color=blue]if[/color] (objCnn != null) objCnn = null;
[background=yellow]%>[/background]

[innovative]

[quote name='HAPPYNESS' timestamp='1372863045' post='1303915277']

aa clear clear....[img]http://lh3.ggpht.com/-oPHs6L73geM/UViwz4-n6nI/AAAAAAAALXI/vESDOee3pnQ/s180/IB.gif[/img] idigoo


[background=yellow]<%@[/background][color=#800000] taglib uri[/color][color=blue]="[/color][color=blue]/WEB-INF/tags/datagrid.tld"[/color][color=red] prefix[/color][color=blue]="[/color][color=blue]grd"[/color][color=red] [/color][background=yellow]%>[/background]
[background=yellow]<%@[/background][color=#800000] page import[/color][color=blue]="[/color][color=blue]java.sql.Connection"[/color][color=red] [/color][background=yellow]%>[/background]
[background=yellow]<%@[/background][color=#800000] page import[/color][color=blue]="[/color][color=blue]java.sql.DriverManager"[/color][color=red] [/color][background=yellow]%>[/background]
[background=yellow]<%@[/background][color=#800000] page import[/color][color=blue]="[/color][color=blue]java.sql.SQLException"[/color][color=red] [/color][background=yellow]%>[/background]
[background=yellow]<%@[/background][color=#800000] page import[/color][color=blue]="[/color][color=blue]com.freeware.gridtag.*"[/color][color=red] [/color][background=yellow]%>[/background]
[background=yellow]<%[/background]
int intCurr = 1;
int intSortOrd = 0;
[color=blue]String[/color] strTmp = null;
[color=blue]String[/color] strSQL = null;
[color=blue]String[/color] strSortCol = null;
[color=blue]String[/color] strSortOrd = [color=purple]"[/color][color=purple]ASC"[/color];
[color=blue]boolean[/color] blnSortAsc = true;
strSQL = [color=purple]"[/color][color=purple]SELECT CLICORPORATION, CLICLIENT, CLIDESCRIPTION, "[/color] +
[color=purple]"[/color][color=purple]CLIENABLED, CLIUPDSTAMP FROM CLIENTMASTER "[/color];
Connection objCnn = null;
[color=blue]Class[/color] objDrvCls = null;
objDrvCls = [color=blue]Class[/color].forName([color=purple]"[/color][color=purple]oracle.jdbc.driver.OracleDriver"[/color]);
objCnn = DriverManager.getConnection([color=purple]"[/color][color=purple]jdbc:oracle:thin:@Host:port:sid"[/color],
[color=purple]"[/color][color=purple]cashincpri"[/color], [color=purple]"[/color][color=purple]cashincpri"[/color]);
[color=blue]if[/color] (objDrvCls != null) objDrvCls = null;
strTmp = request.getParameter([color=purple]"[/color][color=purple]txtCurr"[/color]);
[color=blue]try[/color]
{
[color=blue]if[/color] (strTmp != null)
intCurr = [color=blue]Integer[/color].parseInt(strTmp);
}
[color=blue]catch[/color] (NumberFormatException NFEx)
{
}
strSortCol = request.getParameter([color=purple]"[/color][color=purple]txtSortCol"[/color]);
strSortOrd = request.getParameter([color=purple]"[/color][color=purple]txtSortAsc"[/color]);
[color=blue]if[/color] (strSortCol == null) strSortCol = [color=purple]"[/color][color=purple]CLICLIENT"[/color];
[color=blue]if[/color] (strSortOrd == null) strSortOrd = [color=purple]"[/color][color=purple]ASC"[/color];
blnSortAsc = (strSortOrd.equals([color=purple]"[/color][color=purple]ASC"[/color]));
[background=yellow]%>[/background]
[color=blue]<[/color][color=#800000]html[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]head[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]title[/color][color=blue]>[/color]Grid Tag Demonstration[color=blue]<[/color][color=blue]/[/color][color=#800000]title[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]link[/color] [color=red]REL[/color][color=blue]="[/color][color=blue]StyleSheet"[/color] [color=red]HREF[/color][color=blue]="[/color][color=blue]css/GridStyle.css"[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]script[/color] [color=red]LANGUAGE[/color][color=blue]="[/color][color=blue]javascript"[/color][color=blue]>[/color]
[color=blue]function[/color] doNavigate(pstrWhere, pintTot)
{
[color=blue]var[/color] strTmp;
[color=blue]var[/color] intPg;
strTmp = document.frmMain.txtCurr.value;
intPg = parseInt(strTmp);
[color=blue]if[/color] (isNaN(intPg)) intPg = [color=navy]1[/color];
[color=blue]if[/color] ((pstrWhere == [color=purple]'[/color][color=purple]F'[/color] || pstrWhere == [color=purple]'[/color][color=purple]P'[/color]) && intPg == [color=navy]1[/color])
{
alert([color=purple]"[/color][color=purple]You are already viewing first page!"[/color]);
[color=blue]return[/color];
}
[color=blue]else[/color] [color=blue]if[/color] ((pstrWhere == [color=purple]'[/color][color=purple]N'[/color] || pstrWhere == [color=purple]'[/color][color=purple]L'[/color]) && intPg == pintTot)
{
alert([color=purple]"[/color][color=purple]You are already viewing last page!"[/color]);
[color=blue]return[/color];
}
[color=blue]if[/color] (pstrWhere == [color=purple]'[/color][color=purple]F'[/color])
intPg = [color=navy]1[/color];
[color=blue]else[/color] [color=blue]if[/color] (pstrWhere == [color=purple]'[/color][color=purple]P'[/color])
intPg = intPg - [color=navy]1[/color];
[color=blue]else[/color] [color=blue]if[/color] (pstrWhere == [color=purple]'[/color][color=purple]N'[/color])
intPg = intPg + [color=navy]1[/color];
[color=blue]else[/color] [color=blue]if[/color] (pstrWhere == [color=purple]'[/color][color=purple]L'[/color])
intPg = pintTot;
[color=blue]if[/color] (intPg < [color=navy]1[/color]) intPg = [color=navy]1[/color];
[color=blue]if[/color] (intPg > pintTot) intPg = pintTot;
document.frmMain.txtCurr.value = intPg;
document.frmMain.submit();
}
[color=blue]function[/color] doSort(pstrFld, pstrOrd)
{
document.frmMain.txtSortCol.value = pstrFld;
document.frmMain.txtSortAsc.value = pstrOrd;
document.frmMain.submit();
}
[color=blue]</[/color][color=#800000]script[/color][color=blue]>[/color]
[color=blue]<[/color][color=blue]/[/color][color=#800000]head[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]body[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]h2[/color][color=blue]>[/color]Grid Example[color=blue]<[/color][color=blue]/[/color][color=#800000]h2[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]form[/color] [color=red]NAME[/color][color=blue]="[/color][color=blue]frmMain"[/color] [color=red]METHOD[/color][color=blue]="[/color][color=blue]post"[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:dbgrid[/color] [color=red]id[/color][color=blue]="[/color][color=blue]tblStat"[/color] [color=red]name[/color][color=blue]="[/color][color=blue]tblStat"[/color] [color=red]width[/color][color=blue]="[/color][color=blue]100"[/color] [color=red]pageSize[/color][color=blue]="[/color][color=blue]10"[/color]
[color=red]currentPage[/color][color=blue]="[/color][color=blue]<%=intCurr%>"[/color] [color=red]border[/color][color=blue]="[/color][color=blue]0"[/color] [color=red]cellSpacing[/color][color=blue]="[/color][color=blue]1"[/color] [color=red]cellPadding[/color][color=blue]="[/color][color=blue]2"[/color]
[color=red]dataMember[/color][color=blue]="[/color][color=blue]<%=strSQL%>"[/color] [color=red]dataSource[/color][color=blue]="[/color][color=blue]<%=objCnn%>"[/color] [color=red]cssClass[/color][color=blue]="[/color][color=blue]gridTable"[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:gridpager[/color] [color=red]imgFirst[/color][color=blue]="[/color][color=blue]images/First.gif"[/color] [color=red]imgPrevious[/color][color=blue]="[/color][color=blue]images/Previous.gif"[/color]
[color=red]imgNext[/color][color=blue]="[/color][color=blue]images/Next.gif"[/color] [color=red]imgLast[/color][color=blue]="[/color][color=blue]images/Last.gif"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:gridsorter[/color] [color=red]sortColumn[/color][color=blue]="[/color][color=blue]<%=strSortCol%>"[/color] [color=red]sortAscending[/color][color=blue]="[/color][color=blue]<%=blnSortAsc%>"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:rownumcolumn[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]#"[/color] [color=red]width[/color][color=blue]="[/color][color=blue]5"[/color] [color=red]HAlign[/color][color=blue]="[/color][color=blue]right"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:imagecolumn[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]"[/color] [color=red]width[/color][color=blue]="[/color][color=blue]5"[/color] [color=red]HAlign[/color][color=blue]="[/color][color=blue]center"[/color]
[color=red]imageSrc[/color][color=blue]="[/color][color=blue]images/Edit.gif"[/color]
[color=red]linkUrl[/color][color=blue]="[/color][color=blue]javascript:doEdit('{CLICORPORATION}', '{CLICLIENT}')"[/color]
[color=red]imageBorder[/color][color=blue]="[/color][color=blue]0"[/color] [color=red]imageWidth[/color][color=blue]="[/color][color=blue]16"[/color] [color=red]imageHeight[/color][color=blue]="[/color][color=blue]16"[/color]
[color=red]alterText[/color][color=blue]="[/color][color=blue]Click to edit"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:textcolumn[/color] [color=red]dataField[/color][color=blue]="[/color][color=blue]CLICLIENT"[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]Client"[/color]
[color=red]width[/color][color=blue]="[/color][color=blue]10"[/color] [color=red]sortable[/color][color=blue]="[/color][color=blue]true"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:textcolumn[/color] [color=red]dataField[/color][color=blue]="[/color][color=blue]CLIDESCRIPTION"[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]Description"[/color]
[color=red]width[/color][color=blue]="[/color][color=blue]50"[/color] [color=red]sortable[/color][color=blue]="[/color][color=blue]true"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:decodecolumn[/color] [color=red]dataField[/color][color=blue]="[/color][color=blue]CLIENABLED"[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]Enabled"[/color] [color=red]width[/color][color=blue]="[/color][color=blue]10"[/color]
[color=red]decodeValues[/color][color=blue]="[/color][color=blue]Y,N"[/color] [color=red]displayValues[/color][color=blue]="[/color][color=blue]Yes,No"[/color] [color=red]valueSeperator[/color][color=blue]="[/color][color=blue],"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:datecolumn[/color] [color=red]dataField[/color][color=blue]="[/color][color=blue]CLIUPDSTAMP"[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]Last Updated"[/color]
[color=red]dataFormat[/color][color=blue]="[/color][color=blue]dd/MM/yyyy HH:mm:ss"[/color] [color=red]width[/color][color=blue]="[/color][color=blue]20"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=blue]/[/color][color=#800000]grd:dbgrid[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]input[/color] [color=red]TYPE[/color][color=blue]="[/color][color=blue]hidden"[/color] [color=red]NAME[/color][color=blue]="[/color][color=blue]txtCurr"[/color] [color=red]VALUE[/color][color=blue]="[/color][color=blue]<%=intCurr%>"[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]input[/color] [color=red]TYPE[/color][color=blue]="[/color][color=blue]hidden"[/color] [color=red]NAME[/color][color=blue]="[/color][color=blue]txtSortCol"[/color] [color=red]VALUE[/color][color=blue]="[/color][color=blue]<%=strSortCol%>"[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]input[/color] [color=red]TYPE[/color][color=blue]="[/color][color=blue]hidden"[/color] [color=red]NAME[/color][color=blue]="[/color][color=blue]txtSortAsc"[/color] [color=red]VALUE[/color][color=blue]="[/color][color=blue]<%=strSortOrd%>"[/color][color=blue]>[/color]
[color=blue]<[/color][color=blue]/[/color][color=#800000]form[/color][color=blue]>[/color]
[color=blue]<[/color][color=blue]/[/color][color=#800000]body[/color][color=blue]>[/color]
[color=blue]<[/color][color=blue]/[/color][color=#800000]html[/color][color=blue]>[/color]
[background=yellow]<%[/background]
[color=blue]try[/color]
{
[color=blue]if[/color] (objCnn != null)
objCnn.close();
}
[color=blue]catch[/color] (SQLException SQLExIgnore)
{
}
[color=blue]if[/color] (objCnn != null) objCnn = null;
[background=yellow]%>[/background]
[/quote]

enti happy idhi ... app code motham ichava ikkada .. JSP lo dynamic result ela display cheyyali adhi cheppu chalu eha ..

[dreamgirl]

happy google lo unnadhantha yethukosthunnadu

[dreamgirl]

[quote name='innovative' timestamp='1372863228' post='1303915292']

enti happy idhi ... app code motham ichava ikkada .. JSP lo dynamic result ela display cheyyali adhi cheppu chalu eha ..
[/quote]

Hi Inno, ela vunnav?

[innovative]

[quote name='Diva' timestamp='1372863434' post='1303915315']

Hi Inno, ela vunnav?
[/quote]

hi .. im fine dg .. hru ?

[dreamgirl]

[quote name='innovative' timestamp='1372863476' post='1303915318']

hi .. im fine dg .. hru ?
[/quote]

nenu kuda fine

[dennis]

[quote name='innovative' timestamp='1372862868' post='1303915269']

yup .. backend nunchi result set pampaka .. how to display on front end depending on result set .. adhi matter ..

yaa depends on user input, resultset real time lo vary avthadhi so obvious ga table num of rows n columns kooda .. clear na ?
[/quote]
check this once
[url="http://iam-rakesh.blogspot.com/2010/06/simple-ajax-jsp-example.html"]http://iam-rakesh.blogspot.com/2010/06/simple-ajax-jsp-example.html[/url]

[innovative]

[quote name='Diva' timestamp='1372863510' post='1303915321']

nenu kuda fine
[/quote]

asalu enti okesari name change and display pic change ?

[Gachibowli_Diwakar]

[quote name='HAPPYNESS' timestamp='1372863045' post='1303915277']

aa clear clear....[img]http://lh3.ggpht.com/-oPHs6L73geM/UViwz4-n6nI/AAAAAAAALXI/vESDOee3pnQ/s180/IB.gif[/img] idigoo


[background=yellow]<%@[/background][color=#800000] taglib uri[/color][color=blue]="[/color][color=blue]/WEB-INF/tags/datagrid.tld"[/color][color=red] prefix[/color][color=blue]="[/color][color=blue]grd"[/color][color=red] [/color][background=yellow]%>[/background]
[background=yellow]<%@[/background][color=#800000] page import[/color][color=blue]="[/color][color=blue]java.sql.Connection"[/color][color=red] [/color][background=yellow]%>[/background]
[background=yellow]<%@[/background][color=#800000] page import[/color][color=blue]="[/color][color=blue]java.sql.DriverManager"[/color][color=red] [/color][background=yellow]%>[/background]
[background=yellow]<%@[/background][color=#800000] page import[/color][color=blue]="[/color][color=blue]java.sql.SQLException"[/color][color=red] [/color][background=yellow]%>[/background]
[background=yellow]<%@[/background][color=#800000] page import[/color][color=blue]="[/color][color=blue]com.freeware.gridtag.*"[/color][color=red] [/color][background=yellow]%>[/background]
[background=yellow]<%[/background]
int intCurr = 1;
int intSortOrd = 0;
[color=blue]String[/color] strTmp = null;
[color=blue]String[/color] strSQL = null;
[color=blue]String[/color] strSortCol = null;
[color=blue]String[/color] strSortOrd = [color=purple]"[/color][color=purple]ASC"[/color];
[color=blue]boolean[/color] blnSortAsc = true;
strSQL = [color=purple]"[/color][color=purple]SELECT CLICORPORATION, CLICLIENT, CLIDESCRIPTION, "[/color] +
[color=purple]"[/color][color=purple]CLIENABLED, CLIUPDSTAMP FROM CLIENTMASTER "[/color];
Connection objCnn = null;
[color=blue]Class[/color] objDrvCls = null;
objDrvCls = [color=blue]Class[/color].forName([color=purple]"[/color][color=purple]oracle.jdbc.driver.OracleDriver"[/color]);
objCnn = DriverManager.getConnection([color=purple]"[/color][color=purple]jdbc:oracle:thin:@Host:port:sid"[/color],
[color=purple]"[/color][color=purple]cashincpri"[/color], [color=purple]"[/color][color=purple]cashincpri"[/color]);
[color=blue]if[/color] (objDrvCls != null) objDrvCls = null;
strTmp = request.getParameter([color=purple]"[/color][color=purple]txtCurr"[/color]);
[color=blue]try[/color]
{
[color=blue]if[/color] (strTmp != null)
intCurr = [color=blue]Integer[/color].parseInt(strTmp);
}
[color=blue]catch[/color] (NumberFormatException NFEx)
{
}
strSortCol = request.getParameter([color=purple]"[/color][color=purple]txtSortCol"[/color]);
strSortOrd = request.getParameter([color=purple]"[/color][color=purple]txtSortAsc"[/color]);
[color=blue]if[/color] (strSortCol == null) strSortCol = [color=purple]"[/color][color=purple]CLICLIENT"[/color];
[color=blue]if[/color] (strSortOrd == null) strSortOrd = [color=purple]"[/color][color=purple]ASC"[/color];
blnSortAsc = (strSortOrd.equals([color=purple]"[/color][color=purple]ASC"[/color]));
[background=yellow]%>[/background]
[color=blue]<[/color][color=#800000]html[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]head[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]title[/color][color=blue]>[/color]Grid Tag Demonstration[color=blue]<[/color][color=blue]/[/color][color=#800000]title[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]link[/color] [color=red]REL[/color][color=blue]="[/color][color=blue]StyleSheet"[/color] [color=red]HREF[/color][color=blue]="[/color][color=blue]css/GridStyle.css"[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]script[/color] [color=red]LANGUAGE[/color][color=blue]="[/color][color=blue]javascript"[/color][color=blue]>[/color]
[color=blue]function[/color] doNavigate(pstrWhere, pintTot)
{
[color=blue]var[/color] strTmp;
[color=blue]var[/color] intPg;
strTmp = document.frmMain.txtCurr.value;
intPg = parseInt(strTmp);
[color=blue]if[/color] (isNaN(intPg)) intPg = [color=navy]1[/color];
[color=blue]if[/color] ((pstrWhere == [color=purple]'[/color][color=purple]F'[/color] || pstrWhere == [color=purple]'[/color][color=purple]P'[/color]) && intPg == [color=navy]1[/color])
{
alert([color=purple]"[/color][color=purple]You are already viewing first page!"[/color]);
[color=blue]return[/color];
}
[color=blue]else[/color] [color=blue]if[/color] ((pstrWhere == [color=purple]'[/color][color=purple]N'[/color] || pstrWhere == [color=purple]'[/color][color=purple]L'[/color]) && intPg == pintTot)
{
alert([color=purple]"[/color][color=purple]You are already viewing last page!"[/color]);
[color=blue]return[/color];
}
[color=blue]if[/color] (pstrWhere == [color=purple]'[/color][color=purple]F'[/color])
intPg = [color=navy]1[/color];
[color=blue]else[/color] [color=blue]if[/color] (pstrWhere == [color=purple]'[/color][color=purple]P'[/color])
intPg = intPg - [color=navy]1[/color];
[color=blue]else[/color] [color=blue]if[/color] (pstrWhere == [color=purple]'[/color][color=purple]N'[/color])
intPg = intPg + [color=navy]1[/color];
[color=blue]else[/color] [color=blue]if[/color] (pstrWhere == [color=purple]'[/color][color=purple]L'[/color])
intPg = pintTot;
[color=blue]if[/color] (intPg < [color=navy]1[/color]) intPg = [color=navy]1[/color];
[color=blue]if[/color] (intPg > pintTot) intPg = pintTot;
document.frmMain.txtCurr.value = intPg;
document.frmMain.submit();
}
[color=blue]function[/color] doSort(pstrFld, pstrOrd)
{
document.frmMain.txtSortCol.value = pstrFld;
document.frmMain.txtSortAsc.value = pstrOrd;
document.frmMain.submit();
}
[color=blue]</[/color][color=#800000]script[/color][color=blue]>[/color]
[color=blue]<[/color][color=blue]/[/color][color=#800000]head[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]body[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]h2[/color][color=blue]>[/color]Grid Example[color=blue]<[/color][color=blue]/[/color][color=#800000]h2[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]form[/color] [color=red]NAME[/color][color=blue]="[/color][color=blue]frmMain"[/color] [color=red]METHOD[/color][color=blue]="[/color][color=blue]post"[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:dbgrid[/color] [color=red]id[/color][color=blue]="[/color][color=blue]tblStat"[/color] [color=red]name[/color][color=blue]="[/color][color=blue]tblStat"[/color] [color=red]width[/color][color=blue]="[/color][color=blue]100"[/color] [color=red]pageSize[/color][color=blue]="[/color][color=blue]10"[/color]
[color=red]currentPage[/color][color=blue]="[/color][color=blue]<%=intCurr%>"[/color] [color=red]border[/color][color=blue]="[/color][color=blue]0"[/color] [color=red]cellSpacing[/color][color=blue]="[/color][color=blue]1"[/color] [color=red]cellPadding[/color][color=blue]="[/color][color=blue]2"[/color]
[color=red]dataMember[/color][color=blue]="[/color][color=blue]<%=strSQL%>"[/color] [color=red]dataSource[/color][color=blue]="[/color][color=blue]<%=objCnn%>"[/color] [color=red]cssClass[/color][color=blue]="[/color][color=blue]gridTable"[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:gridpager[/color] [color=red]imgFirst[/color][color=blue]="[/color][color=blue]images/First.gif"[/color] [color=red]imgPrevious[/color][color=blue]="[/color][color=blue]images/Previous.gif"[/color]
[color=red]imgNext[/color][color=blue]="[/color][color=blue]images/Next.gif"[/color] [color=red]imgLast[/color][color=blue]="[/color][color=blue]images/Last.gif"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:gridsorter[/color] [color=red]sortColumn[/color][color=blue]="[/color][color=blue]<%=strSortCol%>"[/color] [color=red]sortAscending[/color][color=blue]="[/color][color=blue]<%=blnSortAsc%>"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:rownumcolumn[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]#"[/color] [color=red]width[/color][color=blue]="[/color][color=blue]5"[/color] [color=red]HAlign[/color][color=blue]="[/color][color=blue]right"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:imagecolumn[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]"[/color] [color=red]width[/color][color=blue]="[/color][color=blue]5"[/color] [color=red]HAlign[/color][color=blue]="[/color][color=blue]center"[/color]
[color=red]imageSrc[/color][color=blue]="[/color][color=blue]images/Edit.gif"[/color]
[color=red]linkUrl[/color][color=blue]="[/color][color=blue]javascript:doEdit('{CLICORPORATION}', '{CLICLIENT}')"[/color]
[color=red]imageBorder[/color][color=blue]="[/color][color=blue]0"[/color] [color=red]imageWidth[/color][color=blue]="[/color][color=blue]16"[/color] [color=red]imageHeight[/color][color=blue]="[/color][color=blue]16"[/color]
[color=red]alterText[/color][color=blue]="[/color][color=blue]Click to edit"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:textcolumn[/color] [color=red]dataField[/color][color=blue]="[/color][color=blue]CLICLIENT"[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]Client"[/color]
[color=red]width[/color][color=blue]="[/color][color=blue]10"[/color] [color=red]sortable[/color][color=blue]="[/color][color=blue]true"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:textcolumn[/color] [color=red]dataField[/color][color=blue]="[/color][color=blue]CLIDESCRIPTION"[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]Description"[/color]
[color=red]width[/color][color=blue]="[/color][color=blue]50"[/color] [color=red]sortable[/color][color=blue]="[/color][color=blue]true"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:decodecolumn[/color] [color=red]dataField[/color][color=blue]="[/color][color=blue]CLIENABLED"[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]Enabled"[/color] [color=red]width[/color][color=blue]="[/color][color=blue]10"[/color]
[color=red]decodeValues[/color][color=blue]="[/color][color=blue]Y,N"[/color] [color=red]displayValues[/color][color=blue]="[/color][color=blue]Yes,No"[/color] [color=red]valueSeperator[/color][color=blue]="[/color][color=blue],"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]grd:datecolumn[/color] [color=red]dataField[/color][color=blue]="[/color][color=blue]CLIUPDSTAMP"[/color] [color=red]headerText[/color][color=blue]="[/color][color=blue]Last Updated"[/color]
[color=red]dataFormat[/color][color=blue]="[/color][color=blue]dd/MM/yyyy HH:mm:ss"[/color] [color=red]width[/color][color=blue]="[/color][color=blue]20"[/color][color=blue]/[/color][color=blue]>[/color]
[color=blue]<[/color][color=blue]/[/color][color=#800000]grd:dbgrid[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]input[/color] [color=red]TYPE[/color][color=blue]="[/color][color=blue]hidden"[/color] [color=red]NAME[/color][color=blue]="[/color][color=blue]txtCurr"[/color] [color=red]VALUE[/color][color=blue]="[/color][color=blue]<%=intCurr%>"[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]input[/color] [color=red]TYPE[/color][color=blue]="[/color][color=blue]hidden"[/color] [color=red]NAME[/color][color=blue]="[/color][color=blue]txtSortCol"[/color] [color=red]VALUE[/color][color=blue]="[/color][color=blue]<%=strSortCol%>"[/color][color=blue]>[/color]
[color=blue]<[/color][color=#800000]input[/color] [color=red]TYPE[/color][color=blue]="[/color][color=blue]hidden"[/color] [color=red]NAME[/color][color=blue]="[/color][color=blue]txtSortAsc"[/color] [color=red]VALUE[/color][color=blue]="[/color][color=blue]<%=strSortOrd%>"[/color][color=blue]>[/color]
[color=blue]<[/color][color=blue]/[/color][color=#800000]form[/color][color=blue]>[/color]
[color=blue]<[/color][color=blue]/[/color][color=#800000]body[/color][color=blue]>[/color]
[color=blue]<[/color][color=blue]/[/color][color=#800000]html[/color][color=blue]>[/color]
[background=yellow]<%[/background]
[color=blue]try[/color]
{
[color=blue]if[/color] (objCnn != null)
objCnn.close();
}
[color=blue]catch[/color] (SQLException SQLExIgnore)
{
}
[color=blue]if[/color] (objCnn != null) objCnn = null;
[background=yellow]%>[/background]
[/quote] sadhuvula devudivayya nuvu [img]http://1.bp.blogspot.com/-1AI0qV6sius/UXrJ-5dc_3I/AAAAAAAADsw/L4YnIIQAziI/s1600/ragada11.gif[/img]

[innovative]

[quote name='dennis' timestamp='1372863562' post='1303915328']
check this once
[url="http://iam-rakesh.blogspot.com/2010/06/simple-ajax-jsp-example.html"]http://iam-rakesh.bl...sp-example.html[/url]
[/quote]

cant open in office ..

anyways nenu trying .. thank you ..

[dreamgirl]

[quote name='innovative' timestamp='1372863569' post='1303915329']

asalu enti okesari name change and display pic change ?
[/quote]

vuurike..just for change

[dennis]

[quote name='innovative' timestamp='1372863720' post='1303915345']

cant open in office ..

anyways nenu trying .. thank you ..
[/quote]
nee question enti..how to make ajax call..or how to get data..or how to display in the jsp