Export GridView Only to Excel in asp.net - ASP.NET Discussion Boards

Re: ajax popup extender black background around the window

Tyarla7-Apr-10 0:26

7-Apr-10 0:26

refer this and add style for the extender ...

http://www.asp.net/ajax/ajaxcontroltoolkit/Samples/ModalPopup/ModalPopup.aspx

Help with This Error --> Exception Details: System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {0002E55D-0000-0000-C000-000000000046} failed due to the following error: 80040154

felipependragon6-Apr-10 3:19

felipependragon

6-Apr-10 3:19

Hi everybody, I made an application in asp.net using c# in vs 2003, so now we are using VS2008. In this application I have a class that generates charts and with the old framework everything worked fine, but now in the framework for vs 2008 it not runs! when I run the site and make the request of the chart I get the message below:

Failure Recovery COM class factory for component with CLSID (0002E55D-0000-0000-C000-000000000046) due to the following error: 80040154.

The class that generates charts does reference of Microsoft.Office.Interop.OWC11.dll, I've searched on other sites and discussion groups and not got a solution for my case ... Some say that I must register the dll, others say you should give access to the COM object clsid (0002E55D-0000-0000-C000-000000000046) ....

Anyone know something that can be done?

Thanks

Felipe, Brazil

Re: Help with This Error --> Exception Details: System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {0002E55D-0000-0000-C000-000000000046} failed due to the following error: 80040154

felipependragon6-Apr-10 5:00

felipependragon

6-Apr-10 5:00

Hi Guys, well, we discovery how to fix the problem,

We just registered the OWC11.dll and everything worked fine again! Smile | :)

I found in this site a usefull list,

http://technet.microsoft.com/en-us/library/cc262506.aspx[^]

see ya !

how to remove the rows from the gridview control when check box is unchecked

developerit5-Apr-10 23:52

developerit

5-Apr-10 23:52

hi iam using asp.net with c#

in my gridview 1st column is templatefield which contains check box control,

default i set to check, iam displaying data at page load event

but when i unchecked the checkbox then that row should be remove from gridview .

can you give me example which helps me

Re: how to remove the rows from the gridview control when check box is unchecked

m@dhu6-Apr-10 0:39

m@dhu

6-Apr-10 0:39

Check.. This may help you link

Re: how to remove the rows from the gridview control when check box is unchecked

Brij6-Apr-10 0:43

Brij

6-Apr-10 0:43

So for that, use rowcommand event and when user uncheck the checkbox then remove it from db and bind the grid again.
for details on rowcommand event, have a look to the link Click here

Cheers!!
Brij
Check my latest Article :Exploring ASP.NET Validators

Re: how to remove the rows from the gridview control when check box is unchecked

carlecomm7-Apr-10 2:38

carlecomm

7-Apr-10 2:38

for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox ck=(CheckBox)GridView1.Rows[i].Controls[0];
if(!ck.Check)
{
GridView1.Rows[i].visible=false;
}
}

modified 27-May-14 4:38am.

Export GridView Only to Excel in asp.net

Abdul Rahman Hamidy5-Apr-10 23:31

Abdul Rahman Hamidy

5-Apr-10 23:31

Dear All,
I am exporting grid view to excel using following code

void Export()
{
        string attachment = "attachment; filename=Contacts.xls";
        Response.ClearContent();
        Response.AddHeader("content-disposition", attachment);
        Response.ContentType = "application/ms-excel";
        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);
        GridView1.RenderControl(htw);
        Response.Write(sw.ToString());
        Response.End();
}

but what happens, It exports all the control to excel. I have button, listbox and other controls above my GridView but when exporting I want to export only my gridview to Excel
using above code all the page is exported,

any ideas how to export only gridview to excel?

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Re: Export GridView Only to Excel in asp.net

Dinesh Mani5-Apr-10 23:58

Dinesh Mani

5-Apr-10 23:58

Your code looks clean to me. It should work. Have you overridden VerifyRenderingInServerForm method?

public override void VerifyRenderingInServerForm(Control control)
{

    // Confirms that an HtmlForm control is rendered for the
    // specified ASP.NET server control at run time.

}

Re: Export GridView Only to Excel in asp.net

Abdul Rahman Hamidy6-Apr-10 0:13

Abdul Rahman Hamidy

6-Apr-10 0:13

I have already done that but no success.

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Re: Export GridView Only to Excel in asp.net

Arun Jacob6-Apr-10 0:02

Arun Jacob

6-Apr-10 0:02

This is a working sample,

Export Gridview in ASP.NET[^]

Arun Jacob
http://codepronet.blogspot.com/

Re: Export GridView Only to Excel in asp.net

Abdul Rahman Hamidy6-Apr-10 0:21

Abdul Rahman Hamidy

6-Apr-10 0:21

thanks for your reply.
I have done the same thing, but all controls within the page are rendered and exported to excel file.
I want to export only the gridview not other controls.

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Gantt Control

ziwez05-Apr-10 23:19

ziwez0

5-Apr-10 23:19

Im looking for a interactive gannt control for my web app (something that mimics MS Project)
the only half decent control ive found is
http://www.plexityhide.com/[^]
but wanted to see it anyone else uses anything better?
thanks

Re: Gantt Control

Steven J Jowett6-Apr-10 0:29

Steven J Jowett

6-Apr-10 0:29

Have a look on [Component Source]. You can usually download trail versions on components, to try before you buy.

Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.

System for sharing a browser session between two clients [modified]

Samarjeet Singh@india5-Apr-10 21:46

Samarjeet Singh@india

5-Apr-10 21:46

Hello,
In my website I am maintaining log of users in which I am storing some user's information such as user machine IP number,SessionId,UserName etc.and able to show the list of current and past users in webpage.

I want to share a browser session of my current users.suppose there are many users who is accesing my site and if I click any perticular user then we can find the user's session and able to know the working of users.
Is it possiable,if yes then how ?
Please tell me......

Thanks to all.

modified on Tuesday, April 6, 2010 4:01 AM

Re: System for sharing a browser session between two clients

Venkatesh Mookkan6-Apr-10 17:40

Venkatesh Mookkan

6-Apr-10 17:40

Samarjeet Singh@india wrote:
I want to share a browser session of my current users.suppose there are many users who is accesing my site and if I click any perticular user then we can find the user's session and able to know the working of users.

You cannot share other user's information from one session. May be try using Application object which can be shared across the users.

Castle Rider

What if I freeze??? Don't forget to breath...

My: Website | Yahoo Group | Blog Spot

/xml>

Re: System for sharing a browser session between two clients

Samarjeet Singh@india6-Apr-10 20:26

Samarjeet Singh@india

6-Apr-10 20:26

hmmmmmmmmmmmm,
I am not very sure but I heared that some shopping site have sites where we shop on, and they can have people join you session and drive it and user sees you moving around driving it.

Thanks to Reply.

Re: System for sharing a browser session between two clients

Venkatesh Mookkan7-Apr-10 1:11

Venkatesh Mookkan

7-Apr-10 1:11

In that case you have to write your own Session Management. Simple way is maintaining a static or shared object.

Castle Rider

What if I freeze??? Don't forget to breath...

My: Website | Yahoo Group | Blog Spot

/xml>

IIS hosting problem

Amit Patel19855-Apr-10 21:14

Amit Patel1985

5-Apr-10 21:14

Hi ,

I am hosting web site on IIS 7 on windows vista operating system.I am getting
HTTP Error 500.19 - Internal Server how to fix this issue.

Thanks and regards,

Amit Patel

Re: IIS hosting problem

Brij5-Apr-10 21:41

Brij

5-Apr-10 21:41

There is very good article whic explains, how to deploy website on IIS7.Have a look
Deploying ASP.NET Websites on IIS 7.0

Hope it helps.

Cheers!!
Brij
Check my latest Article :Exploring ASP.NET Validators

Re: IIS hosting problem

Abhijit Jana6-Apr-10 8:05

Abhijit Jana

6-Apr-10 8:05

Try to run application under IIS_IUSRs user or Put your publish code into C:\Inetpub\wwwroot\ folder.

Cheers !
Abhijit
My Blog : http://abhijitjana.net

Disable menu item

Paulraj G5-Apr-10 20:59

Paulraj G

5-Apr-10 20:59

Hi Everyone,

My menu is looking like following,

<a class="menu"; href="page1.aspx"; title="Page1">&nbsp;&nbsp;&nbsp;Page1&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a class="menu"; href="page2.aspx"; title="page2">&nbsp;&nbsp;&nbsp;page2&nbsp;&nbsp;&nbsp;&nbsp;</a>
<a class="menu"; href="page3.aspx"; title="page3">&nbsp;&nbsp;&nbsp;page3&nbsp;&nbsp;&nbsp;&nbsp;</a>

Now i want to disable page3 menu.
how to do it...

any help will be appriciated...

thanks...

G.Paulraj

Re: Disable menu item

Arun Jacob5-Apr-10 21:17

Arun Jacob

5-Apr-10 21:17

Try this,

<a class="menu" href="page3.aspx" title="page3" disabled="disabled">   page3    </a>

Arun Jacob
http://codepronet.blogspot.com/

Re: Disable menu item

Paulraj G5-Apr-10 21:21

Paulraj G

5-Apr-10 21:21

Hi Arun Jacob,

Its working in Internet Explorere. but not working in other browser(Opera).

G.Paulraj

Re: Disable menu item

Arun Jacob5-Apr-10 21:47

Arun Jacob

5-Apr-10 21:47

Okay then either remove href attribute or set onclick="return false;"

Arun Jacob
http://codepronet.blogspot.com/

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