ASP.NET Discussion Boards

mpavas19-Dec-07 20:42

19-Dec-07 20:42

Hello,

I have an ASPX page WITH Grid View with data in below format:

Title
------------------------------------
c# book
------------------------------------
ID AUTHOR ISBN
------------------------------------
1 Andrew 1233456
------------------------------------
Title
------------------------------------
Learn asp.net in 20 days
------------------------------------
ID AUTHOR ISBN
-------------------------------------
2 ROB 412123123
-------------------------------------

Now I want to export this data to excel in following format (Each data in one row)

Title ID AUTHOR ISBN
Learn asp.net 2 ROB 412123123

How can I achive this? Do I need to take a seprate Gridview which is hidden [but do not know how to achive this]?

Or is there a way i can directly export the datatable to Excel. I will not be using Miscosoft excel component to use it in any case.

Please suggest

Regards,
Pavas
-----------------------
[http://longjump.com/]
Dynamic business applications that manage and coordinate teams and information
-----------------------

Re: Export Datatable to Excel

pmarfleet19-Dec-07 21:37

pmarfleet

19-Dec-07 21:37

This article[^] explains how to write to an Excel spreadsheet using the Jet OleDb Provider. The Excel application itself does not need to be installed on the server.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: Export Datatable to Excel

mpavas19-Dec-07 22:28

mpavas

19-Dec-07 22:28

thanks, i will have a look on it

Regards,
Pavas

User Interaction Table

rajanandal19-Dec-07 20:35

rajanandal

19-Dec-07 20:35

hi anybody know about User interaction table. ie it ll accept text,image at runtime simply entering into table cell....

Re: User Interaction Table

Abhijit Jana19-Dec-07 22:42

Abhijit Jana

19-Dec-07 22:42

use gridview for the same

Best Regards
-----------------
Abhijit Jana
View My CodeProject Articles

"Success is Journey it's not a destination"

Re: User Interaction Table

rajanandal20-Dec-07 0:20

rajanandal

20-Dec-07 0:20

for i need this facility at runtime. ie dynamically

Getting the Databound object out from a GridView

boy.pockets19-Dec-07 20:19

boy.pockets

19-Dec-07 20:19

Hello,

I am using a GridView in combination with an ObjectDataSource.

What I am after is a method to call (eg, after the row has been edited), which will return the values bound to the DataObject (i.e. the object that was passed in, or the object that is defined by the ObjectDataSource.DataObjectTypeName property).

Currently, such a method is available when hooking into the RowDataBound action. The property GridViewRowEventArgs.Row.DataItem returns the values that have been bound as a DataObject.

I would like to be able to call such a method when I am responing to postbacks (ie, from a button).

I have looked at GridView.Rows[index].DataItem, but that always seems to be null.

Any hint in right direction is appreciated.

Cheers

Re: Getting the Databound object out from a GridView

Dave Sexton20-Dec-07 10:18

Dave Sexton

20-Dec-07 10:18

Although I'm not entirely certain have a look at the ObjectDataSource's OnUpdated event. There should be arguments passed to that to allow you retrieve the data.

But fortunately we have the nanny-state politicians who can step in to protect us poor stupid consumers, most of whom would not know a JVM from a frozen chicken. Bruce Pierson
Because programming is an art, not a science. Marc Clifton

Re: Getting the Databound object out from a GridView

illusky23-Dec-07 16:11

illusky

23-Dec-07 16:11

boy.pockets wrote:
I have looked at GridView.Rows[index].DataItem, but that always seems to be null.

The DataItem in GridViewRows is not saved by viewstate except in some functions such as RowDataBound.

Permanently stay where my heart locates

Autocomplete textbox not working

mgr_2k719-Dec-07 19:27

mgr_2k7

19-Dec-07 19:27

Hi All,

Absurd problem really.

We have created a web application. In some pages the autocomplete feature of the textboxes occur, while in the ones having tabstrip control the feature does not show up. What can I do to get rid of the problem? Can anybody help me.

TX In Advance.

Manish.

web chart

uglyeyes19-Dec-07 19:24

uglyeyes

19-Dec-07 19:24

trying to build up a web chart from below article but i cant see the chart
http://www.eggheadcafe.com/articles/20021223.asp

it just shows image not available icon. i ahve owc11 installed in my machine. do i need to register owc10 too?

Re: web chart

_AK_19-Dec-07 19:49

_AK_

19-Dec-07 19:49

Although I have not used office web components anytime but can suggest you to see the path of the image (whether it is correct or not) in the browser.

Apurva Kaushal

Re: web chart

uglyeyes20-Dec-07 11:42

uglyeyes

20-Dec-07 11:42

it is pointing to the correct path. src='c:\owc\images'

PDF Browsing in Firefox.

banker_kiran19-Dec-07 19:03

banker_kiran

19-Dec-07 19:03

Hi,..

In my web application, i have one help file as pdf format.

when in firefox

i type like
http://localhost/myapp/help.pdf
then it opens in binary format.

If is there any setting in IIS or in firefox then let me know.

Kiran Banker

Re: PDF Browsing in Firefox.

Paul Conrad23-Dec-07 7:57

Paul Conrad

23-Dec-07 7:57

banker_kiran wrote:

If is there any setting in IIS or in firefox then let me know.

It is probably not an IIS thing, but something with the configuration in Firefox.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

Master Page

senthilsstil19-Dec-07 18:21

senthilsstil

19-Dec-07 18:21

Hi Friends,
I want to know about master page in ASP.NET.Can any one send me the coding.

Thanks & Regards
Senthil Kumar

Re: Master Page

_AK_19-Dec-07 18:44

_AK_

19-Dec-07 18:44

Have you tried to search the same in google. There you will get lots of example for the same. Here[^] is the example.

Apurva Kaushal

Opening different files from the browser

Anuradha61219-Dec-07 17:55

Anuradha612

19-Dec-07 17:55

Hi,

I am developing an application which needs to work with the files. In one page, i have a grid view which lists all the files used for my application, i have used hyperlink column in grid view for these filenames.
If i click on the filename in the grid view, the file should be opened in the browser (i.e) it should not open the file in its original format (for example if it is a word document, it should not open in MS Word), it should open only in the browser.
Files can be of any type - word, excel, ppts, jpegs etc.
I have tried using Response.Redirect with full path, but that is not the result, which i am expecting.
Can some body help me in this regard.

Thanks in Advance
Anuradha

Re: Opening different files from the browser

N a v a n e e t h19-Dec-07 19:57

N a v a n e e t h

19-Dec-07 19:57

I don't think that it is possible. Because decision will be taken by the browser, and ASP.NET can't control it. Why do you need such an option ?

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

My Website | Ask smart questions

Re: Opening different files from the browser

Anuradha61219-Dec-07 20:10

Anuradha612

19-Dec-07 20:10

Atleast the basic formats like word, excel, power point, pdf docs should be supported, is there any mechanism to do this

Re: Opening different files from the browser

N a v a n e e t h19-Dec-07 20:21

N a v a n e e t h

19-Dec-07 20:21

Anuradha612 wrote:
Atleast the basic formats like word, excel, power point, pdf docs should be supported, is there any mechanism to do this

AFAIK, NO. Operating system will be having file extension mappings, which maps file extension to applications which can read that. When a file is opened through browser, browser looks for this application mapping and loads it on the specified application. It is decided by the browser where to load the file, and how to show it. So you can't control it.

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

My Website | Ask smart questions

How to call a javascript function from App_Code class [modified]

Niya19-Dec-07 17:39

Niya

19-Dec-07 17:39

Hai

How can i call a javascript function from App_Code class.
i have a menu child dynamically created inside App_Code class.
i need to pass the navigate URL string to a javascript code.
i dont know where the javascript function is to write because in App_Code there is no aspx file. please help me.

Thanks

modified on Thursday, December 20, 2007 12:31:37 AM

Re: How to call a javascript function from App_Code class

N a v a n e e t h19-Dec-07 20:14

N a v a n e e t h

19-Dec-07 20:14

Niya wrote:
How can i call a javascript function from App_Code class.

You can't call a JS function from app_code. JS works on client and classes will be executed on server.

Niya wrote:
i need to pass the navigate URL string to a javascript code.
i dont know where the javascript function is to write because in App_Code there is no aspx file

You can make use of HTTPContext class. It provides static methods to get access to the current page object. Using that you can give RegisterClientScript() which registers a client script to the current page. See the following code.

System.Web.UI.Page p = (System.Web.UI.Page)HttpContext.Current.CurrentHandler;
p.RegisterClientScriptBlock("JSName", "JSScript");

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

My Website | Ask smart questions

Re: How to call a javascript function from App_Code class

Niya19-Dec-07 23:29

Niya

19-Dec-07 23:29

Thank you for the replay Navaneeth,

The RegisterClientScriptBlock is now working.
but now i cant access the elementID inside the javascript.

i need to collapse the frame when click on the treeview node,and the page loaded in to the main frame. means after loading the page in to the main frame,the frame with treenode should be in collapse mode. my treeview node is created dynamically in App_Code using data from the database.

Here two frames are in the frameset tag.

please help me

how to call a server side sub procedure through a javascript function

jagan12319-Dec-07 17:37

jagan123

19-Dec-07 17:37

iam writing code in button click event and iam calling this event through javascript is there is any way to call a code in the subprocedure using javascript.

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