ASP.NET Discussion Boards

export data to excel creating multiple worksheets

bonokoot26-Mar-07 9:39

26-Mar-07 9:39

Hello all,

I've been searching all day for an article or tutorial on how to get data from a SQL Server 2000 database and export the data to excel 2003 so that multiple worksheets are created, and information is displayed in these worksheets. Data will be coming from multiple tables, and I'm using C# and asp.net 2.0. User will click on an asp.net button to pull the data and put it in an excel spreadsheet.

Thanks

Not able to view Web Application Project

duaatul26-Mar-07 8:30

duaatul

26-Mar-07 8:30

I am trying out VS 2005 for the first time.
Didn't really like the website project, and installed the update for 'Web Application Project' to try it out.
But I am NOT able to view the Web Application Project in the project types when I try to create a new project?
Any help, what could I be missing?

Thanks in advance,
atul

Re: Not able to view Web Application Project

ToddHileHoffer26-Mar-07 8:43

ToddHileHoffer

26-Mar-07 8:43

Did you reboot?
Wep application project appears under the C# templates when I create a new project.

GameFly free trial

Re: Not able to view Web Application Project

duaatul26-Mar-07 9:28

duaatul

26-Mar-07 9:28

Hey,

Thanks for the reply.
Its really embarrassing for me to admit but I had not installed a pre-requisite!!!
Its working now for me.

On a side note, do you know why there isn't a namespace for the code behind when I create a new web page in WebSite project in .NET 2.0 ?
(its there for web app project)

Thanks,
Atul

Tutorial for GridViews ?

digsy_26-Mar-07 7:57

digsy_

26-Mar-07 7:57

Can anyone recommend a tutorial for GridViews ?

Specifically I want to highlight a row when the cursor hover over it. And I want to be able to select a row by clicking anywhere on it.

Re: Tutorial for GridViews ?

ToddHileHoffer26-Mar-07 8:26

ToddHileHoffer

26-Mar-07 8:26

http://asp.net/learn/dataaccess/default.aspx?tabid=63#formatting

The above link should have help with formatting. As for selecting the row. If you use template columns, you should be able to put code behind any control in the row that is clicked in the grid.

GameFly free trial

Re: Tutorial for GridViews ?

digsy_26-Mar-07 8:51

digsy_

26-Mar-07 8:51

Thanks for your help - Digsy Smile | :)

Re: Tutorial for GridViews ?

error140826-Mar-07 10:22

error1408

26-Mar-07 10:22

I'd recommend Ajax Control Tookit for that special need.
http://ajax.asp.net/ajaxtoolkit/HoverMenu/HoverMenu.aspx[^]

How to access a treeview control from another .aspx file

r_jaz26-Mar-07 7:56

r_jaz

26-Mar-07 7:56

Hi,

i'm using and i need to refer to a treeview control from another .aspx , any help would be appreciated..

Thanks Smile | :)

Re: How to access a treeview control from another .aspx file

varshavmane26-Mar-07 22:22

varshavmane

26-Mar-07 22:22

in the frameset drag ur aspx page....and ur problem is solved..

Using GridView and In Memory Data Stores

Stephen Adam26-Mar-07 7:12

Stephen Adam

26-Mar-07 7:12

Heya guys and girls,

I am writing a CMS page for a quiz and want to use the new GridView control along with an in memory data store as a datasource.

Here is is how I would like it to work.

The user logs onto the CMS quiz page to add or edit a quiz. The quiz can contain any number of questions and answers and once the user has added a title for the quiz and as many questions / answers as they want they then move on to the next page to preview / confirm results.

The problem with using a GridView in the classic way would be that I would set it up with a SQLDataSource. this however would mean when I updated or added a row then the database would imedietly be updated. I need a way of storing an off line represention of the data and only applying the changes if the user confirms the preview of the data on the next page.

I have tried using a DataTable but I get told it does not implement IDataSource. I also need to GridView to handle a sitation where there is no data and we only need to add rows (in the case of adding a quiz).

Has anyone come across this problem before?

Cheers

Steve

"Gödel proved that any formal system that defines the primitive recursive functions must be either incomplete or inconsistent. In particular one could not prove from within the system that the system itself was consistent even though the question could be formulated within the system."

Re: Using GridView and In Memory Data Stores

ToddHileHoffer26-Mar-07 7:34

ToddHileHoffer

26-Mar-07 7:34

You can use a dataTable and persist the datatable in viewState or Session state. You can also use a blank table and add a new row to the dataTable easily enough. As for the IDataSource, I don't know what that is.

GameFly free trial

Please Help Me Soon

Mkanchha26-Mar-07 6:01

Mkanchha

26-Mar-07 6:01

I have 2 Forms
1. Display Employee Details( Like Employee Id, Name etc) in DataGrid.
2. Employee Edit Form.

When I click Edit Image on DataGrid, I passe the Employee Id using javascript code to the Popup window(Edit Employee Details) and Received all details . I done some Change and click Update botton. It's Update the details in database.

I want when I click update botton. The popwindow should close and Refresh the Datagrid on Previous Page(Display Employee Details)

I'm Using .NET2003 and VB.NET Backend code

Mohan Balal

Re: Please Help Me Soon

Naveed Kamboh26-Mar-07 6:15

Naveed Kamboh

26-Mar-07 6:15

Dear I'll suggest you to use multiview and view controls and use show hide tricks. make your life easy.

Multiview1.activeindex=0 or Multiview1.activeindex=1 or so on

For closing window you need to use javascript window.close() i guess. and when you are closing your window redirect user to your employee detail page using response.redirect(url). as you have to reconnect to database to fill the values into a grid. this is what i guess.

Naveed Kamboh
Complexity kills, Write easy code for your self.
isolutionteam

Re: Please Help Me Soon

Mkanchha26-Mar-07 18:53

Mkanchha

26-Mar-07 18:53

Thanks for your Kind suggestin

Any other Good way to some this problem

Mohan balal

Re: Please Help Me Soon

_AK_26-Mar-07 19:45

_AK_

26-Mar-07 19:45

I think this[^] article will give you a fair idea how to refresh the parent page from a pop up page.

Best Regards,
Apurva Kaushal

SQL Database Connections

Sarfaraj Ahmed26-Mar-07 5:12

Sarfaraj Ahmed

26-Mar-07 5:12

Hi All

I have added a NewItem (SQL Database)in my Project where I added some table.

Now I would like to run some query, how can I connect with the database or whta will be the

Dim _Con as SqlConnection = New SqlConnection( ; ; )

Thans

Sarfarj Ahmed

Re: SQL Database Connections

Naveed Kamboh26-Mar-07 5:43

Naveed Kamboh

26-Mar-07 5:43

Check
www.connectionstrings.com

Naveed Kamboh
Complexity kills, Write easy code for your self.
isolutionteam

Can I generate a .txt or .csv dynamicly and provide a link for it to be downloaded/streamed?

Red_Wizard_Shot_The_Food26-Mar-07 4:55

Red_Wizard_Shot_The_Food

26-Mar-07 4:55

is it possible to have a link/button/etc that when clicked creates a CVS from a dataset (that bit i can do) then presents it as a download without having to write the file to the server?

So basicly when they click the link/button it streams the data from the dataset into a text file that is being downloaded.

Thanks

Re: Can I generate a .txt or .csv dynamicly and provide a link for it to be downloaded/streamed?

Naveed Kamboh26-Mar-07 5:40

Naveed Kamboh

26-Mar-07 5:40

Yes it is possible dear
follwoing code may be help full

//HTMl Document
public void Create_HTML_Document(string strBody,string filename)
{
try
{
string header = "<title>News letter";
header += strBody;
header += "";
header += "";
StreamWriter sw = File.CreateText(Server.MapPath("../NewsLetters/") + filename +".txt");
sw.Write(header);
sw.Close();

}
catch (Exception)
{

}
}

Naveed Kamboh
Complexity kills, Write easy code for your self.
isolutionteam

Convert int to bool while binding

error140826-Mar-07 4:13

error1408

26-Mar-07 4:13

Hi,
i have a table with an INT column. The value is either 0 or 1. (It is a flag).
Now i'd like to bind it to an checkbox. 1 for checked. 0 for unchecked.
I tried this:
<asp:CheckBox ID="chkOutIn2" runat="server" Checked='<%# Bind("flag_out") %>' Text="Out" />
But i get an exception.
How do i get this checkbox checked?
(The update is no problem, i can convert the bool i get)
Thank you.

Re: Convert int to bool while binding

Naveed Kamboh26-Mar-07 4:43

Naveed Kamboh

26-Mar-07 4:43