You need to export as .xls instead of .xlsx. .xlsx is more of an xml format but .xls can support html format, which is essentially what you are doing. There are only 10 types of people in the world, those who understand binary and those who don't.

Try here "It's true that hard work never killed anyone. But I figure, why take the chance." - Ronald Reagan That's what machines are for. Got a problem? Sleep on it.

Change the ForeColor property of the Label or TextBox that you use to display the string value. myLabel.ForeColor = System.Drawing.Color.Blue Steve Jowett ------------------------- Real programmers don't comment their code. If it was hard to write, it should be hard to read.

If you are talking about a control, Sure. Private Sub Button1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Button1.KeyDown End Sub or you could just trap the keypress for the entire form with: Set KEYPREVIEW on the FORM to TRUE and then you can do: Private Sub Form1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyDown End Sub Or Private Sub Form1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles Me.KeyPress End Sub I hope this helps. If not, just let me know.

If the event isn't exposed to you but is only handled internally in the code, you can't handle the event. You'll never see it. Otherwise, you'll need the signature of the event handler that the code is expecting you to implement. After that, it's a simple matter of writing the event handler and wiring it to the event using the AddHandler statement. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

We can do this in two cascaded steps: 1. Replace all occurrences of Char(10) with Char(13)+Char(10) 2. Replace all occurrences of Char(13)+Char(13)+Char(10) with Char(13)+Char(10) Note that Step 1 replaces some unwanted occurrences also (i.e. Char(13)+Char(10) occurrences), but the second step fixes those unwanted wrong replaces. Have fun with this piece of code: declare @myTestString varchar(50) set @myTestString = char(10)+char(13)+char(10)+char(10)+char(13)+char(13)+char(13)+char(10) set @myTestString = replace( @myTestString, char(10), char(13)+char(10) ) set @myTestString = replace( @myTestString, char(13)+char(13)+char(10), char(13)+char(10) ) Cheers, Syed Mehroz Alam My Blog My Articles

You allready got answer from error message. I Love T-SQL "Don't torture yourself,let the life to do it for you."

Please do not post the same question to different forums. Ballita wrote: error "Cannot insert duplicate key row in object with unique index if you bother to read what its says it blatently obvious you Cannot insert duplicate key row in object with unique index Bob Ashfield Consultants Ltd

Your question is a little too broad for anyone to be able to answer. The performance of your reports is directly coupled to the performance of the queries used to supply the data for your reports. So the improve the performance of any report you could tune your query. If you've already tuned your query look into the administration options which allow you to schedule the report to run every so often and cache the output, for example you could have it run every night. As long as you don't need real-time data, which most reports don't absolutely need, then your users will not have to wait so long for the report and it won't bring down your database when you have multiple users running the same report. Mark's blog: developMENTALmadness.blogspot.com Funniest variable name: lLongDong - spotted in legacy code, was used to determine how long a beep should be. - Dave Bacher

Ballita wrote: Could you please describe how can i use that. Did you look it up? What did you find? Where are you stuck?

How did you solve it? Share your solution pleae. "More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF "This time yesterday, I still had 24 hours to meet the deadline I've just missed today."

Ballita wrote: are getting removed from the gridview. Looks like viewstate issue. ASP.NET won't maintain viewstate for dynamically created controls/columns. So you need to reconsider the event where you are creating dynamic columns. Dynamic columns created on page_load/button click events won't keep viewstate. Try to do this in Init() method. My Website | Ask smart questions

Hi Ballita, For your problem I think using the RowDataBound event of the GridView will be a better idea. While each row is getting bound you can dynamically decide which cols will be visible. You can also do other stuff like clear the content of the cells of that row before binding. Pankaj Chamria, Software Programmer.

Your button click event fires before the grid databinding has taken place. The controls you had added dynamically have not been recreated yet. You should wait until the grid databinding has taken place before attempting to reference any controls you have created dynamically. Paul Marfleet

Try something like this: foreach (GridViewRow rec in this.gvsqldesc.Rows) { string str = (DropDownList)rec.FindControl("ddlvalidation").SelectedItem.Text; } Here am assuming that the name of you gridview is 'gvsqldesc'. All the Best.

Hi Ballita, Do One Thing as u r functional requirement. once ur template column created, then go to the presentation logic and change the portion of the template colunn to the last place of the grid view control. like . . . . Hope to drop a mail if functionality has done. Thanks & Regards Tarun Singh tksingh@zentagroup.com Sr. Software Engineer. (IT) ZENTA

Imran Khan Pathan wrote: Response.Write("opener.document.getElementById('"+Request.Qeurystring["ID"]+"').value='" + Calendar1.SelectedDate.ToShortDateString() + "'; self.close();"); It isn't good practice to use Response.Write to inject Javascrip code into your ASP.NET web page. Use the functionality exposed by the Page.ClientScript object. Regards Paul

Go to Properties of Grid View and Set Allow Sorting as TRUE