|
We have some code that export a datagrid to Excel, and, for small data sets, it works using 'application/vnd.ms-excel'.
However, there appears to be a size limitation on the data...
EDIT: If I limit the stored procedure to returning only 15 rows and 20 colums, the export works. However, at 20 rows and 20 columns, the error occurs.
If the size limitation is reached, when trying to open the file, the message 'Unable to read file' is shown.
Has anyone found a work around for this?
And yes, I have spent the morning in Google, MSDN forums, etc.
Thanks in advance,
Tim
modified on Wednesday, July 16, 2008 12:15 PM
|
|
|
|
|
Tim Carmichael wrote: However, there appears to be a size limitation on the data
what does "appears to be" mean? Do you have a link to something documenting this limitation or ???
led mike
|
|
|
|
|
Updated original post with further details.
|
|
|
|
|
Tim: I support the finance department, and we dump a lot of data for them from SQL Server into Excel. We had lots of problems rolling our own, so we bought Aspose Cells package. It sits on your web server and you just instantiate an object, set some properties and go. It does a lot of nice formatting and other functions. It is a little pricey ($600), but it was really easy to use. Our folks use it daily and it just runs.
Someone's gotta be the last to know, but why is it always me?
|
|
|
|
|
Hi all..
Im developing an asp.net application which requires users to posts their messages in english or arabic language. For this purpose i require someone to guide me to any good rich text box and how to enable support for arabic language in it. Ive tried to use freetextbox but did not get sufficient support of how can i write arabic in it.
Please help me.
Thanks in advance
Bye
|
|
|
|
|
This this one[^] - it's not free but not expensive and claims to have multi-language support. I haven't had to try that feature, so can't guarantee it, but in all other areas I've found it an excellent editor. And i have found their support helpful.
|
|
|
|
|
Hello All,
I need to validate
http://www.pfizer.com/news/rss_article.jsp?rssUrl=http://mediaroom.pfizer.com/portal/site/pfizer/index.jsp?ndmViewId=news_view&newsId=20080610006500&newsLang=en
URL and also http://www.pfizer.com/news/rss_article.jsp
Below is the code which I am using but it validates first one but not the second one.
function ValidateURL()
{
var Url = "(((ht|f)tp(s?):\/\/)|(www\.[^ \[\]\(\)\n\r\t]+)|(([012]?[0-9]{1,2}\.){3}[012]?[0-9]{1,2})\/)([^ \[\]\(\),;"'<>\n\r\t]+)([^\. \[\]\(\),;"'<>\n\r\t])|(([012]?[0-9]{1,2}\.){3}[012]?[0-9]{1,2})";
var tempURL=document.getElementById("ctl00_ContentPlaceHolder1_txteventlink").value;
var matchURL=tempURL.match(Url);
if(matchURL==null)
{
alert("Web URL does not look valid");
document.getElementById("ctl00_ContentPlaceHolder1_txteventlink").value="http://";
document.getElementById("ctl00_ContentPlaceHolder1_txteventlink").focus();
return false;
}
}
Please help me....
Thanks in advance...
|
|
|
|
|
Hi Guys,
I have an asp.net page that will be called once automatically through the scheduler. And after the processes are done it will then close the page. But my problem is the page will stop on the confirmation dialog.
Is there a way to bypass the confirmation dialog?
Below is my test code of closing the page...
Response.Write("<script language='javascript'> { window.close();}</script>")
Button3.Attributes.Add("onclick", "window.close();")
hifiger2004
|
|
|
|
|
hi, I am building a web application in which i need to fetch data from database to an array without using any kind of ADO objects.
i.e. i am restricted not to use dataset, datatable, TableAdpter, datareadder or Datalist,Repeater,ArrarList,ListItem but i can use connection object.in short only ARRAY Nothing Else
Is there any solution to this if yes please
Thanks & Regard
|
|
|
|
|
hi frainds i try to catch ip_address and hostname of pc that is connected in lan with router or switch. i dont know how to catch hostname of pc and mac_address. i am using code for ip address
Request.ServerVariables("REMOTE_ADDR") 
sanjeev
|
|
|
|
|
I purchased a template site through www.9dx.com and need some assistance setting up tables in my pages. This site has a content management system for general web design but I do not understand how to add a table. I have for instance a profit and loss statement that I need to post for investors. It comes from excel and is a pretty large chart. Could someone direct me to a resource to understand how to add a spreadsheet directly into a web page?
|
|
|
|
|
Hi.
I have a DIV tag .
I want to fix maximum height of it with height of the browser (FF or IE)
how can I do it ?
|
|
|
|
|
Hi,
As far as im aware you can just add the following to your css code. Not 100% sure as its been a while since i did web development, but i dont think this can be set in IE.
div {
max-height: 1000px;
overflow: auto;
}
Many thanks,
TF
|
|
|
|
|
Thank you DJ.
I tested it. But it wasn't thing that I wanted. 
|
|
|
|
|
Sorry, misread your question, thought you meant set a maximum height on the div rather than div to maximum height of window.
html
{
height: 100%;
}
body
{
min-height: 100%;
height: 100%;
}
div
{
height: 100%;
min-height: 100%;
}
(div would be given name of your div)
This might work, again not 100% sure.
TF
|
|
|
|
|
Wow. thank you very much.
but it doesn't work in IE6.
|
|
|
|
|
sadly cant test in ie6, dont have it installed, only ie7
it does however work fine in ie7 if thats any help 
TF
|
|
|
|
|
However thank you my friend.
|
|
|
|
|
You can do it with Javascript:
function setHeight(id) //id is the ID of the div
{
var d = document.getElementById(id);
d.style.position = "absolute";
d.style.height = document.body.clientHeight;
}
--Perspx
"Nowadays, security guys break the Mac every single day. Every single day, they come out with a total exploit, your machine can be taken over totally. I dare anybody to do that once a month on the Windows machine." - Bill Gates
BSoD during a Win98 presentation
|
|
|
|
|
Thank you. I tested your function, but it just return zero (0) 
function setHeight()
{
var d = document.getElementById('main');
d.style.position = "absolute";
d.style.height = document.body.clientHeight;
alert(document.body.clientHeight);
}
|
|
|
|
|
It should work.. I tested it in Opera and IE. Where are you calling the function from? Because in IE it's a bit awkward, I think you have to call it on the onLoad() handler or after it or something..
--Perspx
"Nowadays, security guys break the Mac every single day. Every single day, they come out with a total exploit, your machine can be taken over totally. I dare anybody to do that once a month on the Windows machine." - Bill Gates
BSoD during a Win98 presentation
|
|
|
|
|
I tested in FF3 and IE6.
I call it on the onLoad handler.
|
|
|
|
|
You can also use document.body.offsetHeight, however this will only return the browser client height if there is no vertical scrolling on the page, and if you dont want the DIV to be larger than the client height of the browser just assign this to a variable on the onLoad handler and use it afterwards?
Also, try out IE 7 - document.body.clientHeight worked fine for me there.
Hope this helps,
--Perspx
"Nowadays, security guys break the Mac every single day. Every single day, they come out with a total exploit, your machine can be taken over totally. I dare anybody to do that once a month on the Windows machine." - Bill Gates
BSoD during a Win98 presentation
|
|
|
|
|
|
I want to add facility in website build your jacket as on site : www.lettermansclub.com
Can anybody guide me how to do this. Using javascript I can add change image on mouse click. But this will require a lot of images for different colors and different styles.
I hope there must be other method to do this. Please reply soon.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
