Re: Performance : "input runat=server" or "asp:textbox" - ASP.NET Discussion Boards

Re: google translator - error - page is auto refreshing..any one can help me...

Anand Desai22-Jul-08 22:17

Anand Desai

22-Jul-08 22:17

Check your POSTBACK events

Anand Desai
Developer
Atharva Infotech

Excel -COM Class factory initialization error

K.P.Kannan22-Jul-08 21:42

K.P.Kannan

22-Jul-08 21:42

We are exporting some data to excel and we have installed Excel 2007 in our Development/Staging/Production(Web Farm) environments. All the environments are running in Win 2003 Server,IIS 6. We are receiving the following error while initializing excel object in production.

Application:
System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.at System.Runtime.Remoting.RemotingServices.AllocateUninitializedObject(RuntimeType objectType) at System.Runtime.Remoting.RemotingServices.AllocateUninitializedObject(Type objectType) at System.Runtime.Remoting.Activation.ActivationServices.CreateInstance(Type serverType) at System.Runtime.Remoting.Activation.ActivationServices.IsCurrentContextOK(Type serverType, Object[] props, Boolean bNewObj)

Event Log:
The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID
{00024500-0000-0000-C000-000000000046}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

We have given the permissions for Network Service in DCOMCNFG for Excel Application. The error is coming only in production and not in any other environments.

I searched for solutions and all are pointing to giving Activation Permissions to Network Service(The application pool is running under this identity only) which has been done.

I could not figure out any other reasons that may be causing this problem.

Please help

K.P.Kannan

Spell Checking in web application

VB 8.022-Jul-08 21:40

VB 8.0

22-Jul-08 21:40

Hi ,

I am having email compose interface in web application

In that i am having Spell Check button in web application

if i click that button it has to check all the words, or spelling in web application

In that i want to use the spell checking .like in Gmail Compose
Spell Checking

What things i need . how to get the dictionary .

is there any free resources to use from google or from any site in web application

Thanks .

Re: Spell Checking in web application

eyeseetee22-Jul-08 21:54

eyeseetee

22-Jul-08 21:54

check these out:
http://www.codeproject.com/KB/asp/spell_check.aspx
http://www.codeproject.com/KB/aspnet/checkspelling.aspx
http://www.aspspellcheck.com/downloads.asp

Re: Spell Checking in web application

VB 8.023-Jul-08 19:55

VB 8.0

23-Jul-08 19:55

Thanks ,

These links are nice but those r not fit to my web application.

Can i get the same which i see in outlook Express while composing a new mail . Can i get the same interface so that it will take care all the things .

I am new to web applications.

Regards ,

Performance : "input runat=server" or "asp:textbox"

gnjunge22-Jul-08 21:24

gnjunge

22-Jul-08 21:24

Hello,

Does anybody have a preference of using htmlcontrols over webcontrols? If I don't need all the props of asp:textbox, should I use the html control equivalent? Are there differences in performance?

(Idem the difference between for example select runat="server" and asp:dropdownlist)

Would like to hear your thoughts.

Gidon

Re: Performance : "input runat=server" or "asp:textbox"

eyeseetee22-Jul-08 21:31

eyeseetee

22-Jul-08 21:31

I tend to use asp.net controls because in the future if I need to make adjustments to them and add features its easier to leave as asp.net controls.
To be honest I think the asp.net controls were created to go with the back end code.
If you arent using back end code with them, then it might as well use html controls

Re: Performance : "input runat=server" or "asp:textbox"

Arindam Tewary22-Jul-08 22:14

Arindam Tewary

22-Jul-08 22:14

Performancw wise Input with Ruat=server is better. Because asp:textbox webcontrol is converted into input control from server(when it is rendered by browser). This is an extra step done by server if you use asp:textbox.

But associating data(we say its databinding) with asp:textbox is much more easier than input type with runat=server for a developer. Apart from that Asp:textbox is having more properties and methods exposed to developer which makes it more useful( makes job is easier for developer ) to developer.

Thanks,
Arindam D Tewary

Re: Performance : "input runat=server" or "asp:textbox"

N a v a n e e t h23-Jul-08 0:16

N a v a n e e t h

23-Jul-08 0:16

Arindam Tewary wrote:
Performancw wise Input with Ruat=server is better

I don't think you will see a huge difference as both needs to processed to render HTML input. ASP.NET engine is quick enough to do this.

Arindam Tewary wrote:
asp:textbox webcontrol is converted into input control from server(when it is rendered by browser)

ASP.NET just converts the asp:textbox to equivalent HTML input control and emits the HTML to response and it is rendered by browser. Browser is not the one who is converting from asp:textbox HTML input.

Arindam Tewary wrote:
This is an extra step done by server if you use asp:textbox.

This step is happening for input element with runat=server attribute.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: Performance : "input runat=server" or "asp:textbox"

Arindam Tewary23-Jul-08 0:39

Arindam Tewary

23-Jul-08 0:39

N a v a n e e t h wrote:
both needs to processed to render HTML

In HTML server control, actually the code written is copied back to browser.
But if you have asp web server server control, AS.NET engine emits equivalent HTML output therfore a CONVERSION happens. Yah I agree system quick enough, still you cant ignore the basic difference of HTML and asp web server controls.

It was never told that browser does that conversion. It was wriiten that server does that job.

Anywaz good post by you. I must appreciate.

Thanks,
Arindam D Tewary

Re: Performance : "input runat=server" or "asp:textbox"

N a v a n e e t h23-Jul-08 2:03

N a v a n e e t h

23-Jul-08 2:03

Arindam Tewary wrote:
In HTML server control, actually the code written is copied back to browser.

Not exactly. It also will go through all the phases like loading/saving viewstate etc.

Arindam Tewary wrote:
It was never told that browser does that conversion. It was wriiten that server does that job.

I know, but something written in the brackets was giving confusion. Smile | :)

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: Performance : "input runat=server" or "asp:textbox"

Arindam Tewary23-Jul-08 2:32

Arindam Tewary

23-Jul-08 2:32

You won man !!! Laugh | :laugh:

Thanks,
Arindam D Tewary

Re: Performance : "input runat=server" or "asp:textbox"

N a v a n e e t h23-Jul-08 3:06

N a v a n e e t h

23-Jul-08 3:06

Arindam Tewary wrote:
You won man

you are sporty.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: Performance : "input runat=server" or "asp:textbox"

Anand Desai22-Jul-08 22:30

Anand Desai

22-Jul-08 22:30

It depends on purpose certainly..
but I use "input/select.. with runat=server" as much as possible because you find difficult to perform Javascript functions like "OnClick" or "OnChange" or "OnKeyUp"... likewise on server controls. It give strange error at that perticular HTML line..
Using "input/select.. with runat=server" solves that smoothly.

And as I have to use Javascripts frequently with my coding, i prefer runat=server
comments pls.

Anand Desai
Developer
Atharva Infotech

Re: Performance : "input runat=server" or "asp:textbox"

Arindam Tewary22-Jul-08 23:29

Arindam Tewary

22-Jul-08 23:29

Hi Ananth,

First you can never have a OnClick or OnChange in javascript. This are server side event so you can never haandle that using javascript (No way)

In javascript what you handle is onclick and onchange event. Please check the case of this (Upper case and lower case which I mean).

Thanks,
Arindam D Tewary

Re: Performance : "input runat=server" or "asp:textbox"

N a v a n e e t h23-Jul-08 0:21

N a v a n e e t h

23-Jul-08 0:21

Anand Desai wrote:
as much as possible because you find difficult to perform Javascript functions like "OnClick" or "OnChange" or "OnKeyUp"... likewise on server controls. It give strange error at that perticular HTML line..

Then you are not using it in the proper way. Since ASP.NET 2.0, most of the server controls provide "OnClientClick" event which can be used to hook JS methods. You can also use Attributes.Add() to add these type of attributes to the control as well.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: Performance : "input runat=server" or "asp:textbox"

gnjunge23-Jul-08 22:17

gnjunge

23-Jul-08 22:17

Thank you all for your replies. My general perception from all your replies is that it doesn't really matter for simple textboxes what method one chooses.

I wonder though with a dropdownlist, with lets say a 100 entries (static, written inside the markup, so no databinding), would there be a difference in using select runat="server" and asp:dropdownlist runat="server?

how to get url of addressbar

please help22-Jul-08 20:56

please help

22-Jul-08 20:56

how to get whole url with querystring of addressbar like

http://www.codeproject.com/script/Forums/Edit.aspx?fid=12076&floc=/script/Forums/View.aspx

Re: how to get url of addressbar

Gayani Devapriya22-Jul-08 21:08

Gayani Devapriya

22-Jul-08 21:08

Hi,

Request.Url.ToString();

Thx,
Gayani

Excel data to sql server database in asp.net c# 2.0

VijayVishwakarma22-Jul-08 20:51

VijayVishwakarma

22-Jul-08 20:51

Hi,

I m looking to fetch data from excel file and insert in to sql server 2005 database using asp.net c# 2.0. I can do it with sqlbulk copy but I have an extra column field that is not in excel sheet. Can any one suggest me how I can insert that column data. It is basically ID field which I want to keep for table.

thanks

Re: Excel data to sql server database in asp.net c# 2.0

Arindam Tewary22-Jul-08 20:57

Arindam Tewary

22-Jul-08 20:57

I have not worked with Sql BulkCopy. But have a thought.

Would it be helpful that you have an Identity column in the table which is updated by BulkCopy. So you can easily update/insert except ID column.

Thanks,
Arindam D Tewary

Re: Excel data to sql server database in asp.net c# 2.0

VijayVishwakarma22-Jul-08 21:16

VijayVishwakarma

22-Jul-08 21:16

Hi Arindam,

Thanks for reply.

I too thought of keeping an identity column initially but I think its better to have any other alternative coz I want an alphanumeric value for ID and its not possible with Identity column.

SQLBULK copy will directly copy all the rows to their respective rows in sql server DB but since I dont have that ID column in Excel and hence its getting difficult for me.

Other option is to add the id column to excel file but data is in thousands so....

Any suggestions?

Paging in table.

raushan_922-Jul-08 20:39

raushan_9

22-Jul-08 20:39

Hello,

I have created table dynemically. and then bound the value from database.
and i want to give paging in the table.
how can i give paging please suggest me....

Thanks
Raushan

Re: Paging in table.

Sam Xavier22-Jul-08 20:50

Sam Xavier

22-Jul-08 20:50

Here is one nice and complete link you can follow:
http://www.codeproject.com/KB/aspnet/ClientPaging.aspx[^]

Also, if you are using .NET 3.5, then all this trouble can be saved by using a DataPager control.

Best Regards,
Sam Xavier
www.componentone.com

Re: Paging in table.

raushan_922-Jul-08 21:12

raushan_9

22-Jul-08 21:12

Thanks for Reply...

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