Posts made by Prateek G

Prateek G

Searching results is not taking much time but I have Entities kind of thing (collection of properties) binding data to that entity is taking much time. But sometime when I am not searchin any results then also this pop up is coming. Any way where I can check which one is the script which taking the time. I think problem is something related to number of scripts running on the IE, coz IE has a limitation about that.

Prateek G

Hi All, I am developing a solution where on a page m using some ajax control (hover menu, updatepanel, extender menu). I am getting about 1400 search results from database and I am puttin it in repeater control (No paging). All these things causing this warning message. Is there any resolution. Will paging help ??? If yes what is the maximum number of results which I can put on my page. Thanks in advance..

Prateek G

I want to avoid to page to get refreshed on click of F5,Is it possible and how? Thanks..

Prateek G

Are you sure you want the data from .xls, Basically .xls files define just rendering of xml. Be more precize paste a sample source file and specify requirement.

Prateek G

<xsl:stylesheet version="1.1" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="html"/> <xsl:template match="/"> <html> <body>  <div> Results </div> <br/>  <table width="100%" border="1"> <tr> <xsl:for-each select="/*/* [position()=1] /*"> <th> <xsl:value-of select="name()"/> </th> </xsl:for-each> </tr> xsl:apply-templates/ </table> </body> </html> </xsl:template> <xsl:template match="/*/*"> <tr> <xsl:for-each select="*"> <td> <xsl:value-of select="."/> </td> </xsl:for-each> </tr> </xsl:template> </xsl:stylesheet>

Prateek G

Then u can incorporate the same in ur xslt itself, u just need to use xpath,select desired node and directly put the value. If u can give me same xml and xsl may be i can give u an example of the same.

Prateek G

I can think of two ways to put your data into excel file... 1.) Use com object.Add reference to microsoft office and use namespace microsoft.office.interop.excel; then create ur workbook, worksheet and put all the data one by one in a forloop. Export To Excel[^] Export to excel.[^] 2.) Another and very interesting way of doing it use xsl transformation.wot u need to do is just get xml from dataset and then apply xsl on the same and create ur excel sheet.Lemme knw if u r interested...

modified on Monday, December 10, 2007 5:24:30 AM

Prateek G

Without reading ur xml and .cs file Its not possible to answer your query...

Prateek G

var xslt = new ActiveXObject("Msxml2.XSLTemplate"); var xslDoc = new ActiveXObject("Msxml2.FreeThreadedDOMDocument"); var xslProc; xslDoc.async = false; xslDoc.resolveExternals = false; xslDoc.load("YourXsl.xsl"); xslt.stylesheet = xslDoc; var xmlDoc = new ActiveXObject("Msxml2.DOMDocument"); xmlDoc.async = false; xmlDoc.resolveExternals = false; xmlDoc.load(YourXmlString); xslProc = xslt.createProcessor(); xslProc.input = xmlDoc; xslProc.addParameter("surname",valueofSurname) xslProc.output will give u desired table.. u just need to put it as innerHTML for ur page/form...

Prateek G

Response.ContentType = "application/ms-excel"; Response.AppendHeader("Content-Disposition", "attachment; filename="+fileName+".xls"); Response.End();

Prateek G

u will have to zip the files and then display..

Prateek G

check out this one also easiest way-- Export data to excel[^]

Prateek G

u can use com object and prepare excel directly from database. Get data from database in a dataset, create and excelapp, workbook,worksheet etc and then just loop through the dataset assign the values to each cell.

Prateek G

Thats wot I want to know wot value u r assigning to Months column.

Prateek G

where are u storing result of the query.... and In which line u r gettin error..

Prateek G

which method u r using to retrieve value from database. like executenonquery etc.. Better if u can paste the code here.

Prateek G

u can create a proc with following steps which will return a table.. 1) Get no. of days in month. say @no and @p = 1 2) while (@p < @no) 3) Get date and write query GetDate[^] 4> create table with date and count and return it. Lemme know if it is useful...

Prateek G

you can loop through all the days of months and store count of moves in another table.

Prateek G

RSS

Prateek G

Insert and delete are pretty simple methods. U just need to access proper node with the help of Xpath query. Post ur specific question if u have any...