HTML Page mapped into aspnet_isapi.dll showing weird resuls - ASP.NET Discussion Boards

meeram39522-Aug-07 4:19

22-Aug-07 4:19

HI,

Is anybody knows how to export the dataset to excel in a formatted way? I should be able to make the cell bold or italic, or should be able to give background color etc.

When I tried to write it to excel, I'm getting the error message "Exception from HRESULT: 0x800A03EC"}. Anybody pls help.

Thanks in advance.

Meeram395

Re: Exporting to Excel in ASP.Net

Vasudevan Deepak Kumar22-Aug-07 4:31

Vasudevan Deepak Kumar

22-Aug-07 4:31

There is a workaround discussed out here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=991265&SiteID=1[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

How to use FormView in my webForm ?

hdv21222-Aug-07 4:09

hdv212

22-Aug-07 4:09

hi i want using FormView in my webForm, for update my Data, but when i load data into my FormView and click Update linkButton, nothing occured(nothing postBack occured). how to use FormView for update data ?

Re: How to use FormView in my webForm ?

John-ph22-Aug-07 4:14

John-ph

22-Aug-07 4:14

http://msdn2.microsoft.com/en-us/library/ms227970.aspx[^]

Regards
John

Re: How to use FormView in my webForm ?

chathu03j22-Aug-07 18:15

chathu03j

22-Aug-07 18:15

well, if u r using VS.NET 2005 u can do it in a very simple way by using an SqlDataSource object. You can configure the SqlDataSource object by appropriately selecting the server name, the database and the table u want to add the data. Then it automatically generates the SELECT,INSERT,UPDATE,DELETE statements or u can use ur own stored Procedures to do them.
then drag n drop a formview on to the application and set it's datasource to SqlDataSource.

e.g: FormView1.DataSource = SqlDataSource1;
FormView1.DataBind();

Building Javascript using http handler .ashx and client side cache

Tomz_KV22-Aug-07 3:40

Tomz_KV

22-Aug-07 3:40

It is often to see this tag on a aspx page in which javascript is created with somepage.ashx http handler. Does anyone know how or any good articles talking about how this is done, how to cache the javascript in client side and how to triger a rebuild for the javascript if data changed on server?

<div class="ForumSig">Tom Z. (PMA)</div>

Re: Building Javascript using http handler .ashx and client side cache

Vasudevan Deepak Kumar22-Aug-07 5:18

Vasudevan Deepak Kumar

22-Aug-07 5:18

You can append a random number querystring to the URL to prevent the useragents and proxy servers from caching your file.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

HTML Page mapped into aspnet_isapi.dll showing weird resuls

N a v a n e e t h22-Aug-07 3:16

N a v a n e e t h

22-Aug-07 3:16

Hello,

In my ASP.NET application I am tracking user behavior ( tracking pages visited by user ) . For doing this I created a HTTPModule and attached with the application. Everything worked smoothly. But my website contains number of HTML pages, so this HTTPModule was not tracking this HTML pages. For doing this, I mapped html and htm extensions to aspnet_isapi.dll in IIS. Now it started to track HTML pages also.

For tracking each user behaviors, I was storing his id in one session. But in HTML pages this session failed to work. It throws "session state is not available in this context exception". I have added HttpHandlers for html and htm pages and mapped to System.Web.UI.PageHandlerFactory. Still I am getting the same error. Any body please help me to solve this issue ?

If the page is mapped to ASPX engine, then it will be served by that engine rite, So session also should be available. But why this is happening in my scenario ? When I am going wrong ? Please guide me.

My Website | Ask smart questions

Re: HTML Page mapped into aspnet_isapi.dll showing weird resuls

Vasudevan Deepak Kumar22-Aug-07 5:15

Vasudevan Deepak Kumar

22-Aug-07 5:15

Did you research about IRequiresSessionState marker interface?

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

What is maximum Session Timeout Value in Web.config

swapnilbhavsar22-Aug-07 2:47

swapnilbhavsar

22-Aug-07 2:47

Hello
I am developing an Web Applcation.
What is the maximum timeout for sessionState in web.config so that my Session variables doesn't get destroy.

Swapnil Bhavsar

Re: What is maximum Session Timeout Value in Web.config

sulabh202022-Aug-07 3:04

sulabh2020

22-Aug-07 3:04

By default is 20 minutes and rest u can set it upto life time.

Hello Forum
Always be in touch to help about the topic ASP.NET

Re: What is maximum Session Timeout Value in Web.config

kubben22-Aug-07 3:08

kubben

22-Aug-07 3:08

According to MS documentation:
The Timeout property cannot be set to a value greater than 525,600 minutes (1 year).

NOTE there is another thing you need to be concerned with. If you are running IIS 6.0 then you are also using an application pool. The application pool by default is set to recycle itself after like 27 hours. If the app pool is recycled you would lose all session information.

Hope that helps.
Ben

Re: What is maximum Session Timeout Value in Web.config

Vasudevan Deepak Kumar22-Aug-07 4:33

Vasudevan Deepak Kumar

22-Aug-07 4:33

swapnilbhavsar wrote:
Applcation

Web Application

swapnilbhavsar wrote:
maximum timeout for sessionState in web.config so that my Session variables doesn't get destroy

That much high cost of memory and open idle sessions to remain.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Re: What is maximum Session Timeout Value in Web.config

Guffa22-Aug-07 10:58

Guffa

22-Aug-07 10:58

The maximum timeout for sessions is much larger than any sane person would use.

The purpose of having a timeout on sessions, is that it removes the session objects from memory when they aren't used any more. If you have a very long timeout, you will have a lot of session objects in memory.

Memory is cheap, but it's still a limited resource. If the server starts to run out of memory, it gets tremendously slow.

---
single minded; short sighted; long gone;

Retrieve ImageDataType i(SqlServer ) in Asp.net

LishaDamian22-Aug-07 2:41

LishaDamian

22-Aug-07 2:41

hi
I h've created one sql table with a column "image data type". I want to retrive it and want to send this as an attachment using SendSMTPMail. Can anyone tell me , how to retrieve the image type from Sql server

thanks in advance

Re: Retrieve ImageDataType i(SqlServer ) in Asp.net

sulabh202022-Aug-07 3:06

sulabh2020

22-Aug-07 3:06

I am not cler with ur requirements.

what i had done is , while uploading the file i fetched the file extension using the fileinfo class. and stores it in database.

Hello Forum
Always be in touch to help about the topic ASP.NET

How to get length of multiple uploaded file from http header in asp.net ?

-- Abhi --22-Aug-07 2:22

-- Abhi --

22-Aug-07 2:22

Hi...
Friends.

I want to get the length of multiple uploaded file from http header in asp.net ?

Do you have any solution or suggestions for that ?

Thanks in advance.

Regards,
Abhi

Re: How to get length of multiple uploaded file from http header in asp.net ?

sulabh202022-Aug-07 3:01

sulabh2020

22-Aug-07 3:01

U have to controll this logically at ur end.
what i get in mind to store size of every file on one variable and get updated every time the file is uploaded to upstaging server.

Hello Forum
Always be in touch to help about the topic ASP.NET

Re: How to get length of multiple uploaded file from http header in asp.net ?

-- Abhi --22-Aug-07 3:23

-- Abhi --

22-Aug-07 3:23

Sorry, I can't get you !!

Can you please explain me this pardon !!

Thanks..

Regards,
Abhi

Re: How to get length of multiple uploaded file from http header in asp.net ?

Vasudevan Deepak Kumar22-Aug-07 5:17

Vasudevan Deepak Kumar

22-Aug-07 5:17

http://www.codeproject.com/aspnet/multiuploads.asp[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

stored procedure

Sonia Gupta22-Aug-07 2:20

Sonia Gupta

22-Aug-07 2:20

i was using the stored procedure , there i am usiong the two queries
select * from tablename
select is from table where name='name'

for that i am using the following code.
SqlConnection con;
con = new SqlConnection("database=db`;user id=sa;pwd=sa;server=localhost");
con.Open();
SqlCommand cmd;
SqlDataAdapter ad;
ad = new SqlDataAdapter("abc", con);
DataSet ds;
ds = new DataSet();
ad.Fill(ds);

if i use the select * form table queryt then the above code is working vey fine.
if i use both the queries , then the above cod eis not working.

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

Re: stored procedure

sulabh202022-Aug-07 2:53

sulabh2020

22-Aug-07 2:53

Hi sonia, well nice to see u again in problem ha ha ha , kidding ok.

So can u plz specify what exact is ur requirement and what u need to do.

i am not clear abt what u r asking.
Regards
sulabh

Hello Forum
Always be in touch to help about the topic ASP.NET

Re: stored procedure

kubben22-Aug-07 3:14

kubben

22-Aug-07 3:14

If you have sql statements directly in your sqlcommand, it is expecting only one result set to return. If you are calling a stored procedure, which I think you are, then you can return multiple result sets. The down side is that .net version 1.1 doesn't handle multiple result sets. They only added that to .net 2.0. So if you are using .net 1.1 you will have to call the stored procedure. Then call another one to get the second result set.

Ben

Re: stored procedure [modified]

John-ph22-Aug-07 3:31

John-ph

22-Aug-07 3:31

Sonia Gupta wrote:
con = new SqlConnection("database=db`;user id=sa;pwd=sa;server=localhost");

Connection String Syntax error...

Regards
John

Re: stored procedure

\laddie24-Aug-07 0:40

\laddie

24-Aug-07 0:40

Hi,

Try this.

SqlConnection con;
con = new SqlConnection("database=db`;user id=sa;pwd=sa;server=localhost");
con.Open();
SqlCommand cmd;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "abc"; // Assuming abc is ur sp name;
cmd.Connection = con;

SqlDataAdapter ad = new SqlAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds);

Let me know if it works.

Laddie

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.