Datagrid Export to Excel [modified] - Web Development Discussion Boards

Setting ClearType(Font Smoothing) to Web Control Application and IE browser

Sonani Prakash16-Jul-08 22:33

16-Jul-08 22:33

Hi
You might aware of ClearType or font Smoothing feature by default provided by microsoft on IE7.On XP by defaul it's off.

My application is having Web Control(ActiveX control).and I want to set cleartype on specific to my application.

Can any body tell how can I do whether using any window message or registry settings ?

To set the cleartype on wholse OS I guess there is one API "SystemParametersInfo" that also I don't know how to use to set for application specific. I tried using this API but does not setting into my XP Pro SP2 MACHINE.

Can any body help me on this. ?

Thanks,
Prakash.

sonani prakash

Tool for creating web screens

Brendan Vogt16-Jul-08 21:03

Brendan Vogt

16-Jul-08 21:03

Hi,

I am looking for a tool that can create webscreens that I can show to clients. I use VS2008 for the screen creation and coding, but I looking for something very basic to show clients (even before I start with the code as part of the detailed requirements docs), nothing fancy. What do web designers normally use?

Thanks

Re: Tool for creating web screens

Ashfield18-Jul-08 2:16

Ashfield

18-Jul-08 2:16

I don't know about other people, but I use Visio to produce mock up screens.

Bob
Ashfield Consultants Ltd

PHP Classifieds mail server ini_set mail help

devintm016-Jul-08 20:36

devintm0

16-Jul-08 20:36

I have a PHP Classifieds (like a craigslist) and I'm using a free host with no mail server. So I'm trying to use the ini_set to use gmail for my mail server. I have no luck. I tried insert the ini_set in the php script that sends the mail. Is there something I'm doing wrong? Thanks

ini_set("SMTP","smtp.gmail.com");
ini_set("smtp_port","25");
ini_set("sendmail_from","Name <username@gmail.com>");
ini_set("username","username@gmail.com");
ini_set("password","password");

Re: PHP Classifieds mail server ini_set mail help

Johnny ²17-Jul-08 1:17

Johnny ²

17-Jul-08 1:17

Your host has probably prevented ini changes. You should instead look at something like Swiftmailer[^]

Meta Tag For Refresh Problem

Jack Black X16-Jul-08 19:23

Jack Black X

16-Jul-08 19:23

Hello there.

I have a webpage that need to reload every 10 seconds, so I have put a meta tag:
<meta http-equiv="refresh" content="10">

Now this seems to work ok.

Now the problem is that my application requires to be monitored most time of the day and some users have reported that the refresh thing stops working after some time in the day.

So is there any problem in the meta refresh so that if it is allowed to refresh for many hours then at some time it stops working and the page don't reload?

Is it a browser problem?

Is there any work around for this?

Re: Meta Tag For Refresh Problem

Saul Johnson20-Jul-08 11:13

Saul Johnson

20-Jul-08 11:13

Hi!

Hmm.. Can't think why META would stop working, but I trust it has, so, if you don't mind using javaScript, this code could provide a reasonable workaround:

<HTML>
<HEAD>
<SCRIPT TYPE="Text/JavaScript">
function StartRefreshing()
{
setInterval("this.location = this.location", 10000);
}
</SCRIPT>
</HEAD>
<BODY ONLOAD="StartRefreshing()">
</BODY>
</HTML>

This works in pretty much the same way the META tag does, and, to the best of my knowledge, will not stop refreshing after any amount of time.

Hope This Helps!

MrWolfy Big Grin | :-D

Datagrid Export to Excel [modified]

Tim Carmichael16-Jul-08 5:52

Tim Carmichael

16-Jul-08 5:52

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

Re: Datagrid Export to Excel

led mike16-Jul-08 6:09

led mike

16-Jul-08 6:09

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

Re: Datagrid Export to Excel

Tim Carmichael16-Jul-08 6:19

Tim Carmichael

16-Jul-08 6:19

Updated original post with further details.

Re: Datagrid Export to Excel

goodideadave18-Jul-08 13:59

goodideadave

18-Jul-08 13:59

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?

Multiple languages support

Mr.Sam15-Jul-08 23:50

Mr.Sam

15-Jul-08 23:50

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

Re: Multiple languages support

NeverHeardOfMe16-Jul-08 7:26

NeverHeardOfMe

16-Jul-08 7:26

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.

How to Validate URL??

varshavmane15-Jul-08 23:25

varshavmane

15-Jul-08 23:25

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})\/)([^ \[\],;&quot;'&lt;&gt;\n\r\t]+)([^\. \[\],;&quot;'&lt;&gt;\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...

How to bypass confirmation message in asp.net

hifiger200415-Jul-08 19:43

hifiger2004

15-Jul-08 19:43

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

Fetching Data From database to an Array without using any ADO objects

Silver Pearl15-Jul-08 19:37

Silver Pearl

15-Jul-08 19:37

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

how can catch hostname mac address of pc

idsanjeevjha15-Jul-08 19:21

idsanjeevjha

15-Jul-08 19:21

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

spreadsheet directly into web design

softfalls15-Jul-08 11:35

softfalls

15-Jul-08 11:35

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?

CSS question ?

Mohammad Dayyan15-Jul-08 9:49

Mohammad Dayyan

15-Jul-08 9:49

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 ?

Re: CSS question ?

David Muir15-Jul-08 10:09

David Muir

15-Jul-08 10:09

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

Re: CSS question ?

Mohammad Dayyan15-Jul-08 10:26

Mohammad Dayyan

15-Jul-08 10:26

Thank you DJ.
I tested it. But it wasn't thing that I wanted. Frown | :(

Re: CSS question ?

David Muir15-Jul-08 10:52

David Muir

15-Jul-08 10:52

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

Re: CSS question ?

Mohammad Dayyan15-Jul-08 11:05

Mohammad Dayyan

15-Jul-08 11:05

Wow. thank you very much.
but it doesn't work in IE6. Frown | :(

Re: CSS question ?

David Muir15-Jul-08 11:13

David Muir

15-Jul-08 11:13

sadly cant test in ie6, dont have it installed, only ie7 Frown | :(

it does however work fine in ie7 if thats any help Smile | :)