Exporting an ASP.NET table to Excel - ASP.NET Discussion Boards

First Prev Next

Re: Asp.Net Problem

enjoycrack13-Apr-07 14:05

enjoycrack

13-Apr-07 14:05

Ajeet mittal wrote:
I have a problem

So what is the problem when you do that?

<< >>

8x Solutions Ltd

Re: Asp.Net Problem

Christian Graus13-Apr-07 20:14

Christian Graus

13-Apr-07 20:14

Ajeet mittal wrote:
Asp.Net Problem

Wow - not an ASP.NET problem ? Here in the ASP.NET forum ? ( in other words, not a good choice for a header )

Ajeet mittal wrote:
is it possible and how i do it.........

Yes, it's possible. Any book on ASP.NET should give you the info you would need to at least try to do this. If, when you've done that, you're still stuck, let us know what you tried, and we'd love to help. As it stands, your question is so vague that the only way to answer it is to create a DB and a project with two pages, and write it for you.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Asp.Net Problem

Atif Ali Bhatti14-Apr-07 12:29

Atif Ali Bhatti

14-Apr-07 12:29

hi,
yes its possible n its easy. due to lack of time i m not going to write the code but if u need send me email at "kabhi__kabhi@hotmail.com" i'll send u code. anyways
do one thing,
O-O on click event of the form, save your data in the database n put an id, or value in session using "Session("DesiredValue")=txtDesiredvalue.text", which can be used to fetch data (e.g. id, name, father etc.). after words on the next page call tht value using "lblDesiredVal.Text=Session("DesiredValue")".
now use this lblDesiredval in ur query to select data from database while making data adapter.n make dataset,define datasource of the datagrid,datamember and in the last, bind id. thts it. Cake is Prepared.
Hope It Works.
Regards.
Atif Ali Bhatti.

Dropdown lists

hahii13-Apr-07 8:19

hahii

13-Apr-07 8:19

I have a problem. I have two dropdown lists in my web page. named ddlApplication and ddlPermission and I have a button. I have two items in each dropdown list but when I choose second item and click on button and debug by using
these lines of code it always gives me value of first item. How should I fix this problem.

string str2 = this.ddlApplication.SelectedItem.Text;
string str3 = this.ddlPermission.SelectedItem.Text;

hahii

Re: Dropdown lists

Sujit Gupta13-Apr-07 9:14

Sujit Gupta

13-Apr-07 9:14

This is solution for you Check it on your system

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DropDownList1.SelectedIndex = 0;
DropDownList2.SelectedIndex = 0;
}

}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
Response.Write(DropDownList1.SelectedValue);
Response.Write(DropDownList2.SelectedValue);
}

Sujit

Storing User Information

packerfan190413-Apr-07 6:01

packerfan1904

13-Apr-07 6:01

I've got a site using the default membership provider, works great. Need to store additional information like first name and last name AND have it available to all users. What's the best way (and the easiest way) to do that?

Example-
I have approximately 250 users set up on my site. Need to be able to display a full user list to all these users on demand, but rather than displaying the username, I want to show users by Last Name, First Name and Department/Location.

in multiview

prabhu dot net13-Apr-07 4:26

prabhu dot net

13-Apr-07 4:26

hey guys ,
i am using multiveiew control for two seperate form where i am placed textbox and button controls in the separate table.
i am allowing the users to view only one form at a time with the help of activeviewindex property,in that am using autopostback property for one of the textbox,while running the application
i got the exception error that is "javascript runtime error objects or property does not support" like that so guys i want
ur advise for the above

thanks
prabhu

coding makes me interesting in dot net

Exporting an ASP.NET table to Excel

Rohde13-Apr-07 4:13

Rohde

13-Apr-07 4:13

Hi!

I'm trying to export an ASP.NET table control to Excel. But the Excel document is empty.

My code is (tblCommission is the ASP.NET table):

Response.Clear();<br />
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");<br />
Response.Charset = "";<br />
Response.Cache.SetCacheability(HttpCacheability.NoCache);<br />
Response.ContentType = "application/vnd.xls";<br />
System.IO.StringWriter stringWrite = new System.IO.StringWriter();<br />
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);<br />
tblCommission.RenderControl(htmlWrite);<br />
Response.Write(stringWrite.ToString());<br />
Response.End();<br />

Why is the Excel document empty? Any help or info is greatly appreciated; so far Google hasn't helped me so I hope some of you can.

"When you have made evil the means of survival, do not expect men to remain good. Do not expect them to stay moral and lose their lives for the purpose of becoming the fodder of the immoral. Do not expect them to produce, when production is punished and looting rewarded. Do not ask, `Who is destroying the world?' You are."

-Atlas Shrugged, Ayn Rand

Re: Exporting an ASP.NET table to Excel

RichardGrimmer13-Apr-07 5:09

RichardGrimmer

13-Apr-07 5:09

Not sure what this code is trying to achieve...you seem to think that RenderContol will somehow know the format of an excel document?!?!?

In order to export to excel, you'd need to hook into the excel object nodel, and iterate through the table's rows / cells collection, setting values in appropriate cells in the XLS, then send the resulting document down the wire...

(apologies if I've missed the subtlety of your code above!)

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

Re: Exporting an ASP.NET table to Excel

Rohde13-Apr-07 8:33

Rohde

13-Apr-07 8:33

Hi,

Thanks for your answer. Well, I was working with an MS article as basis (How To Export Data in a DataGrid on an ASP . NET WebForm to Microsoft Excel[^]), but I must have misunderstood something somewhere.

I don't assume that the RenderControl knows the Excel format, I simply assume that I extract the HTML and get Excel to show it in a workbook.

Discussion thread creation

marky77713-Apr-07 3:58

marky777

13-Apr-07 3:58

Hi all.

I need help creating discussion forum threads as the ones here in code project.
A set of questions will be posted on a site. A user will login and post a reply to the question and submit it. The reply should immediately show as a branch off from the question. In turn, replies can also have sub replies and should show as a sub branch from the previous reply.

I need help with this in c#(asp.net)please. Any URL's,documentation,source code,etc will be of great help.

thanks
Marquin Smile | :)

Re: Discussion thread creation

enjoycrack13-Apr-07 14:08

enjoycrack

13-Apr-07 14:08

Search RiversideInternetForum project here...that's great in ASP.NET,C#

<< >>

8x Solutions Ltd

Save dialog Control

EEmaan13-Apr-07 3:41

EEmaan

13-Apr-07 3:41

i wanna know how to use open file dialog control in C# aps.net web application.as i have to save the downloading attachment file on my system through my application. i want help in C# coding instead Asp.I m using Vstudio 2003
Thanx

Re: Save dialog Control

enjoycrack13-Apr-07 3:58

enjoycrack

13-Apr-07 3:58

Do you mean you want to show open/save dialog in web application as windows form application??

<< >>

8x Solutions Ltd

Re: Save dialog Control

EEmaan13-Apr-07 9:08

EEmaan

13-Apr-07 9:08

Ya exactly i wanted to do that in the same manner Smile | :)

Re: Save dialog Control

Vasudevan Deepak Kumar14-Apr-07 3:52

Vasudevan Deepak Kumar

14-Apr-07 3:52

You can manually trigger Save Dialog. You can rather stream the file and set the Content-Disposition header.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

cmd.addInparameter

siddisagar13-Apr-07 3:01

siddisagar

13-Apr-07 3:01

Hi All,

What is cmd.Addinparameter() which taking four parameters in .Net 2005.If anyone knows abt this pls explain me.what are the four parameter.

Thanks.

Re: cmd.addInparameter

_AK_13-Apr-07 3:03

_AK_

13-Apr-07 3:03

siddisagar wrote:
cmd.Addinparameter()

What is cmd.Addinparameter ?

Best Regards,
Apurva Kaushal

Re: cmd.addInparameter

siddisagar13-Apr-07 3:51

siddisagar

13-Apr-07 3:51

Generally we use cmd.parameters in 2003 version of dotnet ,But i saw cmd.addinparameter in 2005 version it is taking 4 parameters .so that i am asking.I need what parameters it will take actually?

Thanks.

Re: cmd.addInparameter

RichardGrimmer13-Apr-07 5:10

RichardGrimmer

13-Apr-07 5:10

Lazy....VERY LAZY.....[^]

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

Help in DotNetNuke ( its very urgent )

Faisal Khatri13-Apr-07 1:57

Faisal Khatri

13-Apr-07 1:57

Hi,
I have created few pages using DotNetNuke. These are just Home , ABout Us & Contact us.
Now i want to deploye these pages on a server so that i can view as a website.?

How should i do it?

Any one please help me..its very urgent.

KHATRI

How to Multiview control on clientside

vvijaykrishna13-Apr-07 1:52

vvijaykrishna

13-Apr-07 1:52

Dear All,

I am using a multiview control , with three views in it. I can switch the views through server side by simply setting the property ActiveViewIndex. But I want to change views on client side. Please help me in this regard.

vijaykrishna v

Re: How to Multiview control on clientside

Jaiprakash M Bankolli13-Apr-07 2:00

Jaiprakash M Bankolli

13-Apr-07 2:00

Certainly this is not possible as these are server controls and you need to do a post back at the server change the view.

Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com
http://jaiprakash.blog.com/

Re: How to Multiview control on clientside

kubben13-Apr-07 2:03

kubben

13-Apr-07 2:03

You can not do this. The multiview control is a server control. It only sends the client the current view. So there is no way for the client to switch to a different view without going back to the server.

Ben

retiveig columns

yuvachandra13-Apr-07 1:31

yuvachandra

13-Apr-07 1:31

hi all....

plz let me know how to retrieve the column names of a given table.....without content(data),just only column names

not like select * from sometable and sp_help sometable

Plz help me,,thanqs in advance Rose | [Rose]

Last Visit: 31-Dec-99 18:00 Last Update: 25-Apr-24 5:30

Refresh

ᐊ Prev 1...5084 5085 5086 508750885089 5090 5091 5092 5093 Next ᐅ

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