ASP.NET Discussion Boards

sarang_k2-Jun-09 17:52

2-Jun-09 17:52

Hi all,

Can any one tell me how to export the data from datatable to excel without using Microsoft.office.tools.....
and formating the cells in the excel like in one cell entering 2-3 values etc.

Thanks in advance..

Re: Export data from datatable to Excel

Abhijit Jana2-Jun-09 18:41

Abhijit Jana

2-Jun-09 18:41

sarangkhandare wrote:
Can any one tell me how to export the data from datatable to excel

Have a look

sarangkhandare wrote:
formating the cells in the excel like in one cell entering 2-3 values

I don't understand this point. Can you be please more specific?

Thank you!

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

Re: Export data from datatable to Excel

Kapil Thakur2-Jun-09 22:01

Kapil Thakur

2-Jun-09 22:01

give a linkbutton "export to excel" and do the following code on its click event

Dim Grid As New System.Web.UI.WebControls.GridView
Try

      Grid.AutoGenerateColumns = True
      Grid.RowStyle.Wrap = True
      Grid.AlternatingRowStyle.Wrap = True

      Grid.DataSource = [YOUR DATASET]
      Grid.DataBind()

      -- header style required by you for excel
      Grid.HeaderRow.Cells(0).Width = 200
      Grid.HeaderRow.Style("font-family") = "Verdana"
      Grid.HeaderRow.Style("font-size") = "12px"
      Grid.HeaderRow.Font.Bold = True
      Grid.HeaderRow.ForeColor = Color.White
      Grid.HeaderRow.BackColor = Color.Blue

      For Each row As System.Web.UI.WebControls.GridViewRow In Grid.Rows
            -- row style required by you for excel
            row.Cells(0).Width = 100
            row.Style("font-family") = "Verdana"
            row.Style("font-size") = "12px"
            row.Style("text-align") = "left"
      Next

      Response.Clear()
      Response.AddHeader("content-disposition", "attachment;filename=" & [YOUR PREFERRED FILE NAME] & ".xls")
      Response.Charset = ""
      Response.Cache.SetCacheability(HttpCacheability.NoCache)
      Response.ContentType = "application/vnd.xls"

      Dim stringWrite As New System.IO.StringWriter()
      Dim htmlWrite As New HtmlTextWriter(stringWrite)

      Grid.RenderControl(htmlWrite)
      Response.Write(stringWrite.ToString())
      Response.End()

Catch ex As Exception
Finally
      Grid.Dispose()
      Grid = Nothing
End Try

Regards,
Kapil Thakur
(Where's there is Kapil , there is a way) - thakur.kapil@gmail.com

problem

battulga_dddddd2-Jun-09 17:43

battulga_dddddd

2-Jun-09 17:43

i have windows server 2008 R2 webserver edition, SqlServer 2008 enterprise and PowerShell 2.0. But this is Sql C# code can't connect. But can connect offical components. Exam: SQLDataSource.

cs = "SERVER=.\\SQLEXPRESS;Initial Catalog=arch;Integrated Security=SSPI";
con = new SqlConnection(cs);
querystring = "SELECT user_name, password, user_type FROM [users]";
cmd = new SqlCommand(querystring, con);
con.Open();

I thing block code PowerShell. Help!

battulga

Re: problem

Christian Graus2-Jun-09 18:12

Christian Graus

2-Jun-09 18:12

You say you have SQL Server 2008 enterprise, yet your connection string is for SQLEXPRESS. Is your SQL Server 2008 a named instance, named SQLEXPRESS ?

Christian Graus

Driven to the arms of OSX by Vista.

Please read this[^] if you don't like the answer I gave to your question.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

Re: problem

battulga_dddddd3-Jun-09 15:39

battulga_dddddd

3-Jun-09 15:39

This is code can run before time on Windows Server 2008, SQLServer 2008.

battulga

Can I expand an ajax collapsiblepanel from a button in a different user control?

Goalie352-Jun-09 16:17

Goalie35

2-Jun-09 16:17

I have 2 user controls:

-1 contains my collapsiblepanel control.

-My other contains a button I want to click to expand my collapsiblepanel

How can I pass the value of my button click in my 2nd user control over to my collapsiblepanel in my 1st user control?

Can this even be done?

Thanks.

Re: Can I expand an ajax collapsiblepanel from a button in a different user control?

Herman<T>.Instance2-Jun-09 22:05

Herman<T>.Instance

2-Jun-09 22:05

In your designer.cs file (if it is a webapplication) you can change the protected global:: into public global:: for you button.

In that case the OnClick Event can be reached from your second control.
In your second control you add

Control1.fromOhterControl.OnClick += new EventHandler(fromOhterControl_OnClick);

and you create the method
protected void fromOhterControl_OnClick(object sender, EventArgs e)
{
}

That should work

In Word you can only store 2 bytes. That is why I use Writer.

Menu Items on hover clickable area

compninja252-Jun-09 11:01

compninja25

2-Jun-09 11:01

Hello everyone! I have an asp:menu item in which the background color changes during a static and dynamic hover style. Everything looks great, however I have noticed that many of my users are mislead into thinking the whole area is clickable when in reality the anchor will only work if the mouse is over the text of the link. Is there a trick to changing the clickable area to take up the whole "background" that is changing rather than just the text? I've googled around but can't seem to find what I'm looking for.
Thanks in advance!

"You're damned if you do, and you're damned if you dont" - Bart Simpson

Re: Menu Items on hover clickable area

Goalie352-Jun-09 16:28

Goalie35

2-Jun-09 16:28

It sounds like you need a CSS fix for this. Here's some code I have for a CSS button. I'm not a css expert, but I believe it's the "display:block;" that does what you're looking for:

ASPX:
<asp:Hyperlink ID="lnkDefaultButton" runat="server" CssClass="defaultButton" Text="Button" Width="200" Height="20"/>


CSS:
a.defaultButton { background-color:white; width:200px; height:20px; display: block;outline: none;}
a.defaultButton:hover { background-color:black; width:200px; height:20px; display: block;outline: none;}

Does this work?

-Goalie35

Re: Menu Items on hover clickable area

compninja253-Jun-09 3:24

compninja25

3-Jun-09 3:24

Hi Goalie35,

no, that didn't seem to do the trick. I'm wonder if there's something within the asp:menu item that's overriding the css class?

<pre> <asp:Menu ID="Menu1" runat="server" DataSourceID="siteMapDataSource"
DynamicHorizontalOffset="2" Font-Names="Tahoma" Font-Size="11px"
StaticSubMenuIndent="10px" style="background-color: transparent;
font-weight: bold; vertical-align: top; margin-bottom:30px;
background-image: url(/designElements/interfaceImages/menubkg_new.jpg);"
Width="152px" ForeColor="#666666" DynamicEnableDefaultPopOutImage="False"
DynamicPopOutImageUrl="~/designElements/interfaceImages/menuarrow.gif"
StaticPopOutImageUrl="~/designElements/interfaceImages/menuarrow.gif" Height="275px"
CssClass="pointer" EnableTheming="False">
<DynamicHoverStyle BackColor="#8E8E8E" ForeColor="White" />
<DynamicMenuStyle CssClass="adjustedZIndex" BackColor="#D1D1D1" />
<DynamicSelectedStyle BackColor="#D1D1D1" />
<DynamicMenuItemStyle HorizontalPadding="5px" VerticalPadding="5px" />
<StaticMenuItemStyle HorizontalPadding="5px" VerticalPadding="3px" ItemSpacing="1px" />
<StaticMenuStyle BackColor="#D1D1D1" />
<StaticHoverStyle BackColor="#8E8E8E" ForeColor="White" CssClass="pointer" />
</asp:Menu>

the pointer cssclass just has cursor: default; in it, but that's where I was adding the display:block and then creating a.pointer{ display:block;} but still not doing the trick.

"You're damned if you do, and you're damned if you dont" - Bart Simpson

publish web site

hahii2-Jun-09 10:53

hahii

2-Jun-09 10:53

Hi,

I created a Virtual directory for my web site. Now I want to publish it at http;//localhost/test2. How can I do that.

Re: publish web site

Abhishek Sur2-Jun-09 10:59

Abhishek Sur

2-Jun-09 10:59

http://localhost belongs to default port 80, so just install IIS and right click on the Default WebSite of the IIS console and make one virtual directory named test2.

Now publish your website to the folder you choose.

You also need to configure your website a bit.

http://www.codeproject.com/KB/aspnet/VSDeploy.aspx[^]

might help you...

Thumbs Up | :thumbsup:

Abhishek Sur

My Latest Articles
Basics on LINQ and Lambda Expressions

Create .NET Templates

Re: publish web site

hahii2-Jun-09 11:10

hahii

2-Jun-09 11:10

Yes, I created the virtual folder. e.g my website is in the folder C:\project\NyWebSite

Now I treated virtual folder in C:\Project and named it as test2. But when I go to window explorer C:\project my test2 is not there. So,. How can I publish it. I have no idea where I am doing wrong

Re: publish web site

N a v a n e e t h2-Jun-09 15:31

N a v a n e e t h

2-Jun-09 15:31

hahii wrote:
I have no idea where I am doing wrong

It should be "I have no idea what I am doing".

hahii wrote:
Now I treated virtual folder in C:\Project and named it as test2. But when I go to window explorer C:\project my test2 is not there

test2 is virtual directory name. It will not exist physically. It is referring to location C:\project and that will be the root of your website. Copy/publish all your files to this location.

If you are using ASP.NET 2.0 or above, just copying all files to this virtual directory will work. VS provides several publish options which can also be used. Refer to MSDN for using the publish feature.

Smile | :)

Navaneeth

How to use google | Ask smart questions

Re: publish web site

Abhijit Jana2-Jun-09 18:50

Abhijit Jana

2-Jun-09 18:50

hahii wrote:
Yes, I created the virtual folder. e.g my website is in the folder C:\project\NyWebSite

Now I treated virtual folder in C:\Project and named it as test2. But when I go to window explorer C:\project my test2 is not there. So,. How can I publish it. I have no idea where I am doing wrong

I don't understand what are your doing? If you have published your Web sites from VS, then Open IIS and Create the Virtual Directory and Give the Path Reference of your Published Folder, that all. Now you can access from you web site from Localhost or IP address.
For more details, Please look into this article, Deploying Web Sites in IIS

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

web.config values before install

DCHAND2-Jun-09 8:36

DCHAND

2-Jun-09 8:36

I am developing an install package for the web application (ASP.NET, VS 2008, C#) using "Setup and Deployment" project in VS 2008.
When the user is upgrading the application (by installing the next release), I need to save the web.config file to restore some settings from the previous install.
How do I do this ?
Frown | :(

Re: web.config values before install

Manas Bhardwaj2-Jun-09 10:29

Manas Bhardwaj

2-Jun-09 10:29

Well, you need to write some logic for this. You may take a look at Custom Actions and use an installer class to read the previous web.config before it is overwritten by the new file. Rose | [Rose]

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: web.config values before install

DCHAND2-Jun-09 10:33

DCHAND

2-Jun-09 10:33

Well I am using Installer class : OnBeforeInstall event, but that fires after the old web.config file has been replaced by the new install !

ASP.NET Documentation.

Baeltazor2-Jun-09 2:44

Baeltazor

2-Jun-09 2:44

Hey everybody... Smile | :)

Does anybody know where I can obtain a downloadable version of the ASP or ASP.NET Documentation? I don't care what format it's in. I've not been able to find it anywhere on MSDN or Google. I've been searching for weeks.

Also, I have Visual Web Developer, But it doesn't seem to want to position elements properly. One second they're where they're supposed to be, then I click "..Sync view thing" and then the controls on the page are in a slightly different position... Any ideas, anyone?

Thanks
jase

Re: ASP.NET Documentation.

Vasudevan Deepak Kumar2-Jun-09 3:33

Vasudevan Deepak Kumar

2-Jun-09 3:33

It is part of MSDN documentation. You can download the same from the following URL:

http://www.microsoft.com/express/download/msdn/Default.aspx[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!

Re: ASP.NET Documentation.

Baeltazor2-Jun-09 4:40

Baeltazor

2-Jun-09 4:40

Thank you sir Smile | :)

much appreciated.

regards
jason

Asp.Net / SQL2005 Stored Procedure Update Problem

munklefish2-Jun-09 2:23

munklefish

2-Jun-09 2:23

Hi,

Im using a stroed procedure to update records in a SQL2005 DB. To send info to the procedure i run something similar to this:

cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@email", tbxUsername.Text);
cmd.Parameters.AddWithValue("@password", tbxPass.Text);
cmd.ExecuteNonQuery();

Under certain circumstance i wont want to update the @password field. Is this possible, if so how? Or do i need to use a seperate stored procedure which doesnt mention the field(s) which shouldn't be updated?

Thanks.

Re: Asp.Net / SQL2005 Stored Procedure Update Problem

Colin Angus Mackay2-Jun-09 2:29

Colin Angus Mackay

2-Jun-09 2:29

The logic is entirely up to you, since I don't know the detail I can't guide you on what is the best course of action. I would say that if the code will do different things then it should be in a different sproc.

Does the current sproc do more than update the password? If so what? And what circumstances don't you want to sproc to update the password.

And this question belongs in the database forum.

Man who stand on hill with mouth open wait long time for roast duck to drop in

Re: Asp.Net / SQL2005 Stored Procedure Update Problem

Abhishek Sur2-Jun-09 10:53

Abhishek Sur

2-Jun-09 10:53

Hey...
you are not running a query. Just check the value of password, send DbNull.Value from here and check in the stored Proc :

If @password IS NULL
BEGIN
 -- Update only the UserName
END
ELSE
BEGIN
 -- UPDATE both username and password.
END

Abhishek Sur

My Latest Articles
Basics on LINQ and Lambda Expressions

Create .NET Templates

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