Bodybag

Public Shared Sub DataGridToExcel(ByVal dgExport As DataGrid, ByVal response As HttpResponse) 'clean up the response.object response.Clear() response.Charset = "" 'set the response mime type for excel response.ContentType = "application/vnd.ms-excel" 'create a string writer Dim stringWrite As New System.IO.StringWriter 'create an htmltextwriter which uses the stringwriter Dim htmlWrite As New System.Web.UI.HtmlTextWriter(stringWrite) 'instantiate a datagrid Dim dg As New DataGrid ' just set the input datagrid = to the new dg grid dg = dgExport ' I want to make sure there are no annoying gridlines dg.GridLines = GridLines.None ' Make the header text bold dg.HeaderStyle.Font.Bold = True ' If needed, here's how to change colors/formatting at the component level 'dg.HeaderStyle.ForeColor = System.Drawing.Color.Black 'dg.ItemStyle.BackColor = System.Drawing.Color.White 'dg.BorderColor = System.Drawing.Color.White 'bind the modified datagrid dg.DataBind() 'tell the datagrid to render itself to our htmltextwriter dg.RenderControl(htmlWrite) 'output the html response.Write(stringWrite.ToString) response.End() End Sub

It is for a automation process at the company that i work. O yes it is for a seperate application

How do i simulate a mouse click. Ex If a mouse cursor is over a button and i want it to click the button automaticly through code.

I am starting get realy worried by the security issues in .net. I did a little test. I downloaded four trial version .net applications. I decompiled and cracked all four of them. I then downloaded a trial version dotfusicator and decompiled it and cracked it as well.I am no cracker so this is scary. I deleted them afterwards of course. :)

a Friend of mine specialized in delphi and the strange thing is that he is now using vb.net. I can use either C# ot vb.net and i like them both.Alot of people using vb.net can do C++ as well.I used to program in vc myself and lectured borland c++(dos). You are insulting people who know what they are doing. VB.net rocks!!!

How exactly do you mean dynamic?

It is up to you. I have been checking the web so far i haven't found anything .If i do find a solution i will let you know.

Thanks, Still slow but much beter.

I also ran Windows xp pro when i had this problem. It happened after a incorrect shut down. But it seems it can also happen on windows 2000 server as i was told by a network administrator friend of mine.He says he had to restore a systems backup to fix the problem.So beter pull out that xp cd and reinstall.

One question. Are you running xp Prof and did you move your pc recently without shutting down properly.

I have the following problem one of my pages has to contain seven datalists. One for each day. It is a scheduler. Now everything runs fine but the speed is the problem.The reason for this is that for each line in the datalist i need apply different style and javacript rules. So i loop through each row in each datalist.Is there a way to dynamicaly apply different javascript to a row without looping through each row. Thanks

Had the same problem.Tried everything from meta data editors to Uninstalling iis 4 times.In the end i reinstalled windows.Couldn't find anything on the web.If you find a way to get pass this please post it.

Check your event viewer .The error should either be in your system or application log. If says anything about meta data not being found your screwed. You say this happens when you start a new project?

Did install iis before vs.net. if you did not.You need to register asp.net by using the Aspnet_regiis - i command in dos prompt.Search for the file on your drive.

This is beter Public Class Class1 Sub New() End Sub Public Function run() As String Return HttpContext.Current.Application("test") End Function End Class

Sorry that first part is done in a webfrom

Dim c As New Class1(Application) Label1.Text = c.run() Public Class Class1 Dim appweb As Web.HttpApplicationState Sub New(ByVal app As Web.HttpApplicationState) appweb = app End Sub Public Function run() As String Return appweb.Item("test") End Function End Class

There is no real off times for these databases.If changes happen then they are usualy live.Sometimes data on these databases needs to manipulated to draw specific reports or query certain transactions.What i gave above was an example.Being the person that manages the db , Adminstrate the programs and write new software makes it difficult to sit all day and test changes.

Exactly.What can go wrong will go wrong and probably on the same day you go live and lets not forget the joy of making a change on a live database. Oops should have left that field a varchar.

I am not talking about the programming part.I am talking about the rolling out part , progress meetings and beta meetings.I work for a big company and any mistakes on our side could cost alot of money.Some of the programs i have written now has over 90 users working from the same SQL server so if there is any problems guess who they phone.

Am i alone in the feeling that programming must be one of the most stressfull jobs. Usualy you have terrible deadlines.Users with only the basic skills on computers.People wanting to know every 5 minutes where you are with the program and in my personal opinion people don't know what they want.You ask for a spec and you get a strange dazed look.

for windows apps: Crystal Reports for Visual Studio .NET provides merge modules to ensure the correct report components and component versions are installed with your application. The Crystal Reports merge modules need to be included in a setup project to deploy reports. These merge modules are located in the following default location: C:\Program Files\Common Files\Merge Modules. Merge Module Description Crystal_Managed2003.msm The Crystal_Managed2003.msm merge module installs all the Crystal Reports for Visual Studio .NET managed components such as: CrystalDecisions.CrystalReports.Engine.dll CrystalDecisions.Web.dll CrystalDecisions.Windows.Forms.dll Crystal_Database_Access2003.msm The Crystal_Database_Access2003.msm merge module installs all database drivers the report uses to connect to various types of data sources. This merge module also installs export destination and format drivers, which are used to save reports to different file formats such as RTF and HTML. This merge module is also used to install all non-managed runtime components for Crystal Reports for Visual Studio .NET, including charting components. Crystal_Database_Access2003_enu.msm The Crystal_Database_Access2003_enu.msm installs language-specific (localized) components. Some of the localized charting and exporting components are installed by this merge module. Each language the product is released in will have a specific version of this merge module. Crystal_regwiz2003.msm Crystal_regwiz2003.msm configures registration information on deployed computers (server or client) in order to track licensing information. When Crystal_regwiz2003.msm is added to a setup project, it exposes a LicenseKey property that must be set before building the setup project. The license key is emailed to you when the product is registered. This key is also available from the About Microsoft Visual Studio .NET dialog box from the Help menu. Enter this license key into the LicenseKey property for the Crystal_regwiz2003.msm merge module. Note If the license key is not set for the Crystal_regwiz2003.msm merge module, an error will occur when building the project. If the setup is installed on a target computer without specifying the license key for the merge module, various keycodedev2.dll errors will occur. HY MOET NET ONTHOU OM SY LICENCE KEY IN THE TIK IN DIE Crystal_regwiz2003.msm MERGE MODULE...

http://www.CrystalReportsBook.com/DownloadEbookPDF.asp Download this book. Look at page 45.Hope it helps.

Nee boet , dalk moet jy maar in dos prompt in gaan en tik format c: /q dan sal hy nie meer op kom nie.

Talking about the users becoming idiots.What about the programmers.Life has been made easy for us. We have have nice ide's to work with .Nice database systems and so on.We don't have to suffer making our forms or own components like in the older days.I remember my old days in Turbo c++ 3. Now making a form in those days was a mission. a Lot of data was stored in flat files and quering those files was no breeze. So life has become a lot easier.