Folder Viw, File View ???

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Winforms
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - DataGridView Scheduler Hi, Can anyone help me with the following? Using the new DataGridView in .NET 2.0, can the look be configured so that the days of the week are headers and the rows are subdivided into 30 min. time intervals much like Outlook allows you to schedule appointments. I'd like the same look and feel. As an option, I'd like to be able to add multiple "Customer" objects to any given cell and click on a single customer to bring up his history/appointments, etc... For example, cell at location 5,4 may contain 4 "Customer" objects, and clicking on one of the objects in that cell would bring up another for with customer information, etc... Regards, Giovanni Tag: Folder Viw, File View ??? Tag: 94318
  - 2
    - How to change color of title bar? Hi, How can I change the color of the title bar on my winform application? (without regard to the desktop display settings) Any suggestions? Thanks. Tag: Folder Viw, File View ??? Tag: 94317
  - 3
    - Application window gets smaller than MinimumSize Hello, I am writing an application in Visual Studio .NET, C#. Application is set to maximize after start. I set in Form properties MinimumSize to 800; 600. Everything is OK - I can't resize application window to be smaller than 800 x 600. But, when I set screen resolution to 800 x 600, set task bar to be always visible (and also has height of a few heights of standard task bar height - that working area of the desktop is maybe 800 x 500), application window is smaller than 800 x 600 (which was set as minimum). Application window fit working area of screen (screen size minus area of always visible task bar) which is smaller than minimum size set in Form properties. When I click on Maximize Box, application window gets bigger and fits all the screen size (some area of my application's window is then under task bar) -- it is what I want. I tried to manually set form Height to 600 on Resize event, but it did not help. How to cause that application window is always not smaller than 800 x 600 ? Thanks in advance, Robot Tag: Folder Viw, File View ??? Tag: 94316
  - 4
    - TimeLine Control Greetings, Anyone have a good suggestion for a timeline control for .NET? This is something which should be zoomable in and out and fully customizable for the various entries which would be displayed on the horizontal bars (such as responding to click events on the various items, etc...). Michae Tag: Folder Viw, File View ??? Tag: 94314
  - 5
    - Load form in a tab panel? Hi there, Is there a way to display a form onto a tab panel dynamically? I am trying to supply a form from within a referenced component to the main application dynamically at runtime. I want the same tab panel to be able to display any form residing within or outside its assembly. Is there a way to do this? Thanks in advance! AM Tag: Folder Viw, File View ??? Tag: 94310
  - 6
    - How would I persist a DataGridView's selected row after a sort? (Using VB .NET 2.0 release) Does anyone have a suggestion for the subject question? Looking at the MSDN2 documentation for the DataGridView.Sorted event I found the note "the current cell is not automatically persisted when sorting". I have unfortunately not been able to find any reference on how to change this default behavior. Thanks, Nate Tag: Folder Viw, File View ??? Tag: 94308
  - 7
    - creating a property in a Class to avoid DBNull Hi guys, I created a Class to my program, and it runs fine except one little detail... when the Database Value is Null I always get an Error when using it user.name = trim(reader.item("tName")) How can I avoid this? I have public class user (...) private strName as string = "" property name() as string get return strName end get set(byval value as string) strName = value end set end property (...) end class how can I test the value for System.DBNull ? I always get error messages saying that I can't use If Value.IsNullorEmpty Then (...) -- Bruno Alexandre (Sintra, PORTUGAL) Tag: Folder Viw, File View ??? Tag: 94306
  - 8
    - "invalid attempt to read when no data is present" Hi guys... I'm stuck! I'm devoloping this program and everything was doing fine, until now! This is what happends. <my VB.NET 2.0 code> Sub getUtenteIntoVariables(ByVal idUtente As String) Dim conn As New SqlClient.SqlConnection(connString) Dim cmd As New SqlClient.SqlCommand Dim reader As SqlClient.SqlDataReader Dim strSQL As String Try strSQL = "SELECT tnome FROM utiUtentes" With cmd .CommandText = strSQL .CommandType = CommandType.Text .Connection = conn End With conn.Open() reader = cmd.ExecuteReader() ' Data is accessible through the DataReader object here. Uten_Nome.Text = reader.Item("tnome").ToString conn.Close() Catch ex As Exception MsgBox("Error: " & vbCrLf & ex.Message & vbCrLf & vbCrLf & "SQL Query: " & vbCrLf & strSQL & vbCrLf & vbCrLf) Finally 'Beep() End Try End Sub </my VB.NET 2.0 code> When it gets into this line Uten_Nome.Text = reader.Item("tnome").ToString the program breaks and shows me this message: "invalid attempt to read when no data is present" I know that I have date in it, I can see with GetOrdinal("columnname") method.... What am I doing wrong? -- Bruno Alexandre (Sintra, PORTUGAL) Tag: Folder Viw, File View ??? Tag: 94301
  - 9
    - Controlling/running Excel from a vb.Net App I know you can do it. Just need some slick code to 1. Create an excel App, WorkBook worksheet or range 2. Post amounts to a cell 3. Print 4. Save the sheet 5. Exit the excell App. Thanks in advance jwc *** Sent via Developersdex http://www.developersdex.com *** Tag: Folder Viw, File View ??? Tag: 94299
  - 10
    - CCeDocListDocTemplate on Windows Mobile 5.0 Problems Hello all, I am currently using the CCeDocListDocTemplate class, however, I'm having problems with it on a Dell Axim 51, which uses Windows Mobile 5.0. When the widget is used, it displays the list of files in a mangled format. The format appears to be the first character of the filename followed by the creation date of the file: So for a file named "survey.srv" it would show up as: "s11/12/17". This works fine on the Dell Axim 50, which does not use Mobile 5.0. Are there any known issues with this? Should I be using something else for the Dell Axim 51? Here's the relevant snippet of code: CString m_strDefaultFolder = CString(_T("All Folders")); CString m_strFilterList = CString(_T("Survey Data|*.srv")); pDocTemplate = new CCeDocListDocTemplate( IDR_MAINFRAME, RUNTIME_CLASS(CFSDoc), RUNTIME_CLASS(CMainFrame), // main SDI frame window RUNTIME_CLASS(CFSView) // ); ,m_strFilterList, m_strDefaultFolder); Any help is much appreciated! Thanks, Ryan Tag: Folder Viw, File View ??? Tag: 94296
  - 11
    - ClickOnce Install returns XML .... I have deployed an application with ClickOnce Publish wizard to a web site. But when I click web page Install button the web server just returns the content of the .application file as XML to the browser on my own client. I made a quick try on two other clients and it seems that they are capable to interpret the web page correct ..... My Client: Win2000 SP4 well patched, VS2003, VS2005 Server: Win2003 version 5.2, .application MIME type added, directory configured as virtual directory or application. NO Framework 2.0. I followed instructions on: http://www.windowsforms.net/FAQs/default.aspx?PageID=3&CategoryID=24&SubCategoryID=26&tabindex=2 But the second advice I'm afraid I don't understand: "..... Second, you may need to configure your server to unblock any restricted file extensions used by your app, such as .exe, .dll, .config., manifest, etc. ...." Should I add more MIME-types? This article on changes in VS2005 Beta 2 mentions four MIME-types: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/ClickOnceVS05.asp Tag: Folder Viw, File View ??? Tag: 94294
  - 12
    - Send RTF formatted e-mails with outlook Hello, I want to send an RTF formatted e-mail with Outlook. I read somewhere that just assigning some rtf-code to the Mail.Body property won't work. So I tried the code that I found on http://www.outlookcode.com/d/formatmsg.htm#wordmail (I added this code at the end of this message) Making a new RTF-formatted e-mail works just fine, but the receiver of the message always sees the e-mail as plain text (no matter which e-mail format (plain text, rtf or html) he/she selected). Does anyone know how to send RTF e-mails, so that the receiver also sees the e-mail as RTF? Greetings, Chris Code: Dim objSession, objMessage, objMessageFilter As Object Dim MessageID, cRTF As String Dim bRet As Integer Set objSession = CreateObject("MAPI.Session") objSession.Logon ' Read the first message in the Inbox Set objMessage = objSession.Inbox.Messages(1) objMessage.Update ' to get a permanent Entry ID MessageID = objMessage.ID ' We must initialize the string variable we are passing ' to a string of the maximum length we want to read cRTF = Space(500) bRet = ReadRTF(objSession.Name, objMessage.ID, _ objMessage.StoreID, cRTF) If Not bRet = 0 Then MsgBox "RTF Not Written Successfully" Else MsgBox "RTF Text: " & Chr(13) & cRTF End If Set objMessage = Nothing objSession.Logoff Set objSession = Nothing *** Sent via Developersdex http://www.developersdex.com *** Tag: Folder Viw, File View ??? Tag: 94285
  - 13
    - Drawing Vertical Text Does anyone know how to render text vertically? I need text to appear on the left of my screen reading from bottom to top and on the right reading from top to bottom. Tag: Folder Viw, File View ??? Tag: 94280
  - 14
    - Picture click event Hi all, How to set the specific area in the picture to become a click event? What control i need to use? In vb 6, i can use image control because it's transparent when no src is attached. In vb.net, i have out of ideaa.. My objective is to develop a interactive map. For example, user click on the specific area, it will shows data. Please advice.thank you in advance. Best regards, Ocurnos. Tag: Folder Viw, File View ??? Tag: 94272
  - 15
    - Toolstripmenu and -items don't use menu system color setting I've got a customer who has set his menu text to white on black. When using a new VS2005 toolstripmenu (tsm) we run into all sorts of problems, because the tsm doesn't automatically use the menu system backcolor. The menu's all have white text on light grey backgrounds and are totally unreadable. Is this a bug? Seems like it, since they *do* take over the menu text system color as forecolor. I've tried using a small routine to walk over all toolstripmenuitems (and since they're not members of the forms controls that's tedious as well) and set their backcolors, and it works, but now the highlight color and the checkmarks remain stubbornly purple. It looks awful and annoyingly there are no properties available to set those. This way the entire toolstripmenu becomes utterly useless. Has anybody got a clue how to fix this? Tag: Folder Viw, File View ??? Tag: 94264
  - 16
    - TabPage Alignment property change at runtime problems/bug Hi! When TabPage.Alignment property is changed at runtime tabs are not displayed correctly i.e. text is not displayed and visual style changes to something not seen with any of the available styles. It has been reported many times by different users. After googling for some time (can I use this word on MS forums?) I found short explanation for a reason. Setting Alignment property causes control to be destroyed and recreated with new handle and setting it with container causes the whole mess. However, I have not found any hints on solution to this problem. Are there any KB articles describing this issue or is there any solution to that problem? Tag: Folder Viw, File View ??? Tag: 94260
  - 17
    - Question about IComponentChangeService - OnComponentAdded() I am trying to create a service that will hook to the events fired by the IComponentChangeService. I will use this new service to automatically position controls based on their size and location, the controls have to stay for example within an area of 300, 300. So if anyone created a control outside this area the control will automatically be moved to the new location within the 300, 300 area. When you listen to the event ComponentChanged of the IComponentChangeService you get the components name, the property that changed, the new and the old value of the property. Thus when a user changes the location of a component or the size and its bounds are outside the 300, 300 area I can successfully roll back to the old property value. But now for new components you can hook to the ComponentAdded event but there is one big problem. When this event is fired the component does NOT have the location property set yet. Therefore I am wondering where or when is the Location property actually set? And why doesn't the ComponentChanged event get fired when the location property is set afterwards because that would have also fixed my problem. Gabriel Lozano-Morán Real Software Tag: Folder Viw, File View ??? Tag: 94259
  - 18
    - Master/Detail Binding TabControl hallo! kann mir jemand sagen wie ich detaildatens=E4tzen von einem dataset in einem TabControl(Tabpages) darstellen kann. ich m=F6chte eine Form erstellen mit der ich die Kundenstammdaten verwalten kann (Name, Adresse usw.). Beim Programmstart f=FClle ich ein dataset mit den entsprechenden Tabellen und Realtionen. Klappt auch alles soweit, nur da in der anwendung vorgesehen ist, dass jeder Kunde mehrere Adressen angeben kann, wollte ich die Adressdatens=E4tze zu einem ausgew=E4hlten Kunden der =FCbersichthalber in einem TabControl darstellen. Sprich, die Tabpages werden zur Laufzeit generiert und die Textboxes erhalten alle ein Binding in der Art: txtOrt.DataBindings.Add("Text", this._ds.Tables["tblKunde.KundenAdressen"], "Adr_Ort"); - es gibt ein Tabelle Kunde mit Name und eine Tabelle Adressen mit 1:n beziehung. KundenAdressen ist die Relation - wird jetzt eine Tabpage selektiert setze ich die entsprechende Position mittels CurrencyManager fest, sodass der richtige datensatz angezeigt wird. alles ok, aber beim zur=FCck schreiben der daten in die datenbank mit der methode Update() wird nur der Datensatz gespeichert der zu dieser zeit sichtbar ist. Ich hoffe es gibt hierzu eine sinnvollere L=F6sung mittels Binding oder =E4hnlichem. habe gestern den ganzen tag damit verbracht ein ensrechendes posting zu finden. aber leider ohne erfolg. w=E4re super, wenn mir jemand helfen k=F6nnte, ihr wisst ja wie das ist. gr=FC=DFe pato Tag: Folder Viw, File View ??? Tag: 94258
  - 19
    - How do you limit a Form's container area without changing the sze? Basically I have a form that is 400w and 400h in pixels. I want all children added (either by the designer or programatically) to be layed out within say a 300w x 300h sub area, so that the outlying 100x100 pixels are ignored as a container but still available for me to paint on. Make sense? I basically want to create the concept of client size but within the client area, so a sub-client area.. Tag: Folder Viw, File View ??? Tag: 94250
  - 20
    - Use Running App All - I have used mtux to check for a running app and close it down if it a previous app instance is running. Now, when a user double clicks on one of the saved application files, I'd like for the existing instance of the application to come to the front and use the file the user double clicked. I have no issues doing this when no instance of the app is running but if it is already running, how do I go about this? Thanks, Brian Tag: Folder Viw, File View ??? Tag: 94246
  - 21
    - Every 5th Datagrid Line a different colour Hello, Can someone tell me how to change the 5th datagrid line colour? I can change all of them, but not only the fifth ones. Any help much appreciated! Cheers G Tag: Folder Viw, File View ??? Tag: 94245
  - 22
    - How do I simplify this code I have a select case which opens various forms as ShowDialog. Notice the repetition; \\ Case "btnManageJobs" Dim f As New f010Jobs Me.Visible = False f.ShowDialog() Me.Visible = True Case "btnSeqOfOper" Dim f As New f050SqOO Me.Visible = False f.ShowDialog() Me.Visible = True Case "btnViewer" Dim f As New f060View Me.Visible = False f.ShowDialog() Me.Visible = True // How can I take the code... \\ Me.Visible = False f.ShowDialog() Me.Visible = True // ... and put it after the select case block? IOW is there any way to declaire "f" before the select case block and give it the form name within the select case and then run the "f.ShowDialog" after the block. Orrrrr is there a simpler way to do this? thank you, dbuchanan Tag: Folder Viw, File View ??? Tag: 94244
  - 23
    - listbox multiselect madness Hey all, On a windows form, I have a databound listbox with multiselect. All I want to is spin through the selected items and find the value for each. I've been everywhere and still haven't found a way to do this. Please don't show me thee xample with listitem. There are no listitems in windows forms. Little help... Tag: Folder Viw, File View ??? Tag: 94239
  - 24
    - How do I determine which button was clicked I have added handlers handlers to direct all buttons to one method like this; 'Add handlers for buttons AddHandler btnManageJobs.Click, AddressOf Button_Click AddHandler btnSeqOfOper.Click, AddressOf Button_Click AddHandler btnViewer.Click, AddressOf Button_Click AddHandler btnScfmCalculationTool.Click, AddressOf Button_Click AddHandler btnAdminSetup.Click, AddressOf Button_Click How do I determine which button was clicked? I think I use "sender" but do not know how. Can someone help me? Thank you, dbuchanan Tag: Folder Viw, File View ??? Tag: 94235
  - 25
    - windows.Forms.Application.CompanyName is blank Hi Everyone, I am using Visual Studio 2005. I have converted my solution from VS 2003. I am set and everything is working. However, the code that ran fine under VS 2003 throws a run time error. The system.Windows.Forms.Application.CompanyName and ProductionName are empty. They worked find under VS 2003. Has anyone run into the same problem? I would appreciate anyone's insight into this. The code is below. Thanks, Craig Adams Vivus Software, Inc. Public Shared Function DefaultFileName() As String Dim fn As String = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) fn &= "\" & System.Windows.Forms.Application.CompanyName & "\" & System.Windows.Forms.Application.ProductName & "\Preferences.dat" Return fn End Function Tag: Folder Viw, File View ??? Tag: 94220
- Next
  - 1
    - System.Drawing - SafeNativeMethods . GdipFillRectangleI method causes a lot of page faults We just profiled our application and noticed that SafeNativeMethods.GdipFillRectangleI method (called by Graphics.FillRectangle) in System.Drawing causes 88% of all of our -soft- page faults. We are soft faulting on an order of 2000 spfs/sec with 10 charts - with one charts we are to 600 SPFs/sec. Both numbers are high. We are a charting intensive, real-time trading .NET application that plots real time trading data on a high frequency basis. Does anyone know of any performance issues with GDI drawing functions in .NET framework...? Tag: Folder Viw, File View ??? Tag: 94218
  - 2
    - PropertyGrid painting Is there a way to paint a different color for the title of each property in a property grid -- i.e. to have the title background be different from the edit field background for the property? Tag: Folder Viw, File View ??? Tag: 94215
  - 3
    - PropertyGrid Is there a way to programmatically set the location of the PropertyGrid's splitter bar. Often there is too much white space to the right of my property titles and I would like to be able to move the splitter bar over. Tag: Folder Viw, File View ??? Tag: 94214
  - 4
    - DataGridView Update Hi All, I am using VS 2005 and would like to accomplish the following: Assuming I have 3-4 grids on a given Windows Form. I would like to update these grids individually on a specified timer interval without blocking the UI thread. When the info is available for a specific grid, it is updated with the latest values from the SQL Server 2000 database backend. What would be the best way to do this? I think I'd need to start a new thread for each grid's Update/Refresh method or maybe even use the new BackgroundThreadWorker object. Any ideas, hints, code tips (VB.NET). Regards, Giovanni P. Tag: Folder Viw, File View ??? Tag: 94212
  - 5
    - Handling the Windows "No Disk" MessageBox I have a Windows application that reads images from a CD or DVD. If the media is removed from the drive and the user selected an image to in the DataGrid, then Windows will display a MessageBox informing the user that no media exists. This MessageBox also prompts the user to Cancel, Retry, or Continue. I don't know anything about this MessageBox except that my application crashes a horrible death if the user selects Cancel or Continue. I would like to be able to handle a Cancel selection if possible. Does anyone know what this MessageBox is that Windows (XP) displays automatically? If so, do you know how to read the DialogResult from it? The crash comes when my application proceeds with trying a call that will absolutely NOT work without the media. Here is my stack trace from the resulting crash: <type>System.ArgumentException</type> <message>The Win32 handle you passed to Icon is invalid or of the wrong type.</message> <caller>.ctor</caller> <stack> at System.Drawing.Icon..ctor(IntPtr handle) at System.Drawing.Icon.FromHandle(IntPtr handle) at DCDLibrary.IconTool.GetLargeIcon(String filename) in C:\Documents and Settings\clfenley\My Documents\Visual Studio Projects\InspectionViewer\DCDImaging\IconTool.vb:line 138 at InspectionViewer.ViewerMain.GetPlans(String resultsId) in C:\Documents and Settings\clfenley\My Documents\Visual Studio Projects\InspectionViewer\InspectionViewer\ViewerMain.vb:line 864 at InspectionViewer.ViewerMain.GetImages(String resultsId) in C:\Documents and Settings\clfenley\My Documents\Visual Studio Projects\InspectionViewer\InspectionViewer\ViewerMain.vb:line 758 at InspectionViewer.ViewerMain.ShowDetailsObjects(String resultsId) in C:\Documents and Settings\clfenley\My Documents\Visual Studio Projects\InspectionViewer\InspectionViewer\ViewerMain.vb:line 1161 at InspectionViewer.ViewerMain.DataGrid_CurrentCellChanged(Object sender, EventArgs e) in C:\Documents and Settings\clfenley\My Documents\Visual Studio Projects\InspectionViewer\InspectionViewer\ViewerMain.vb:line 464 at System.Windows.Forms.DataGrid.OnCurrentCellChanged(EventArgs e) at System.Windows.Forms.DataGrid.set_CurrentCell(DataGridCell value) at System.Windows.Forms.DataGrid.OnMouseDown(MouseEventArgs e) at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.ComponentManager.System.Windows.Forms.UnsafeNativeMethods+IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.Run(Form mainForm) at InspectionViewer.AppState.Main() in C:\Documents and Settings\clfenley\My Documents\Visual Studio Projects\InspectionViewer\InspectionViewer\AppState.vb:line 86</stack> Regards, Carl Tag: Folder Viw, File View ??? Tag: 94207
  - 6
    - Transparent label flicker when drawn on form I am having troubles with forms that have a large number of labels with transparent backgrounds causing a good deal of flicker while originally drawing the form. I have created a new label class which inherits from Label and has UserPaint and DoubleBuffer set in the control styles, and this makes no difference. In 2.0, I set double buffering on the form and this also made no difference. Anyone have any suggestions on how to deal with this? A form with 100 transparent background labels should not flicker the way it does on my PC (Athlon 64 3500, 512MB) - you can see each label being drawn individually. I have tried my test case on numerous computers and the same thing happens on each. Thanks, Bob Dankert Tag: Folder Viw, File View ??? Tag: 94206
  - 7
    - RadioCheck Menu options Hi, I have an application (written in c#) where I am using a context menu for some custom objects on the screen. The context menu has a sub-menu which consists of 4 options, on which I have set the RadioCheck option to true, as I want these items to function as a group of radio buttons. Since I couldn't find any option to set which group each of the items was in I assumed it would work as it is. However, when I test it, selected an item on the menu does not de-select the one that is currently selected. Surely I don't have to do that myself do I? Have I missed something? Do I mis-understand something, or is there some basic functionality missing? Thankyou. Paul Tag: Folder Viw, File View ??? Tag: 94202
  - 8
    - Question about Form appearance... Ok, I know this is a silly question, but why don't form created by VS .NET (2003) look the same as form in other MS apps like IE and Office? The buttons are different and the tab-controls etc. etc. Is there a way of getting them to look the same? Tag: Folder Viw, File View ??? Tag: 94200
  - 9
    - Another CreateObject C# question My question is how can I in C# call methods on a COM object without having an interface or a RCW referenced. I have a COM component that I cannot import into .NET, it throws a bunch of errors. In VB.NET I was able to do the following: Dim instance As Object impromtuApplication = CreateObject("Impromptu.Application") impromtuApplication.DoSomething("Paramters") In C# I have somewhat the equivelant code: string progId = "CognosImpromptu.Application"; Type comType = Type.GetTypeFromProgID(progId, true); appInstance = Activator.CreateInstance(comType); appInstance.DoSomething("Paramters"); // this line fails because it says no method like this exists So I know I have to cast this object to an Interface or COM object, is there anyway to do this WITHOUT having the RCW or Interface. I don't want to start writing VB.NET code to get this to work <shivers> Thanks in advance Tag: Folder Viw, File View ??? Tag: 94198
  - 10
    - Propery - DataColumn As I can create a property in which they appear them name of the columns of a datatable object and when selecting selects the name of the column I have tried with the following code but when selecting it selects to the object column instead of the name of the column. Also I have proven has to use to typeconverter but I have not obtained anything. Thanks. private DataColumn formCampoClave = null; [Category("Datos")] [Description("Set o get the name of field.")] [DefaultValue(null)] [TypeConverter(typeof(TVector))] public DataColumn FormCampoClave { get { return formCampoClave; } set { formCampoClave = value; } } Tag: Folder Viw, File View ??? Tag: 94196
  - 11
    - MSVS Forms Design View Problems Hi I am getting some unusual problems with Visual Studio design view and I assume that as an inexperienced user I am doing something wrong: 1) tabPage control page order randomises after edit -- no matter how hard I try to get the page order I want it keeps jumping back to a random order. This seems to occur only after a reasonable number of pages and added controls on each page but I have done quite complex tabPages without any problems also. 2) intermittent deletion of custom user controls from the main form after edit (usually graphical edit in the surrounding area of the user control -- even simple things like nudging adjacent standard controls for better alignment can have this effect). The worst part is Designer does this without warning and sometimes the code will build but throw an exception on run. 3) Design view lock up - on certain windows forms apps Ive attempted the design view locks for up to 60 seconds on opening the solution in VS with the form in design view or after edit + change to selected viewed document. I would be grateful of any suggestion for any of the above -- Im pretty sure Im not editing any Designer generated areas of Form1.h, however there may be other stupid little things that Im doing wrong. Cheers Steve Tag: Folder Viw, File View ??? Tag: 94191
  - 12
    - Large treeview scrolling I have a large treeview with more than 100,000 items. When i programmatically select a node it will not always be visible node = jumplist(0) CatalogTree.SelectedNode = node node.EnsureVisible() ' Doesn't do anything useful. Node might scrolled away I would like to programmatically scroll the selected item to the top of the viewable area. Tag: Folder Viw, File View ??? Tag: 94190
  - 13
    - textBox as a scrolling trace buffer Hi I would like a text output control (such as textBox) to have a fixed number of lines and operate in a similar manner to the old DOS console i.e. text lines added to the bottom, previous lines shift up and when the area is full the topmost lines that get shifted up are discarded. Basically Im looking for a non-persistant trace buffer on an ASCII data stream so that the text can be viewed in real-time but without a permanent history building up. Can the standard textBox control be made to function this way or is there some other standard control I could use. Cheers Steve Tag: Folder Viw, File View ??? Tag: 94189
  - 14
    - Workaround for TextBox AppendText 32767 character limit Hi Ive seen plenty discussion about the textBox AppendText signed 16-bit character limit and I presume that it has not been fixed as I am getting it in a noddy project I am working at the moment. What I have not seen is a suitable work around that is both efficient and simple enough for me to grasp -- if there is one I would be grateful of the help. Cheers Steve Tag: Folder Viw, File View ??? Tag: 94188
  - 15
    - RE question on visible and hide Thank you . Tag: Folder Viw, File View ??? Tag: 94187
  - 16
    - Move a form while shown Hi, I'm trying to move a form while shown changing it's location or top,left properties without results. I'm doing a simple loop like this (VB): Dim r as integer dim frm as new Form1 frm.top=600 frm.left=100 frm.show() for r= 600 to 0 step -1 frm.top=r application.DoEvents() Next This code executes from a button in other form and don't works. I have tried insertting a delay inside the loop without success. Sometimes I get strange behavior, like the form doing partially a movement, then dissapearing... How should I do this? TIA Pucara. Tag: Folder Viw, File View ??? Tag: 94185
  - 17
    - Test Driven Development with Windows Forms I've just released an article on using Test Driven Development with C# and Windows Forms. GUI's are often difficult to test, so I thought it might be of interest. The article along with the example source code can be downloaded here: http://www.blogitek.com/timhaughton/archives/files/User%20Interrogator%20And%20TDD.zip The article text is below. Not sure what it will do to the formatting when it hits Usenet world. Downloading the zip might be easiest. -- Regards, Tim Haughton Agitek http://agitek.co.uk http://blogitek.com/timhaughton ********** After a conversation on the TestFirstUserInterfaces list on Yahoo regarding TDD'ing forms that handle events and launch dialogues, I've gathered my thoughts and put fingers to keyboard. By happy coincidence, the topic coincided with some work I was doing, so I was able to spend some time looking at the problem. At Ron Jeffries' request, I thought I'd write a little 'thing' showing how this might work in practice. For this little example, we're going to write an application whose main form displays some text in a font the user specifies. Just to make sure we're close enough to the original post, we'll have a button that when clicked, launches a font selection dialogue. Naturally we'll proceed test first. House keeping: I'm writing this using VS2005, C#, NUnit and a modified version of NMock, the modifications to which I'll include in the source code to this example. I'm not going to test drive the initial layout of the form as it's just not interesting from the perspective of this example. So we'll start from here: using System; using System.Drawing; using System.Windows.Forms; namespace TestApp { static class Program { [STAThread] static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault( false ); Application.Run( new MainForm() ); } } class MainForm :Form { private Button button; private Label label; public MainForm() { button = new Button(); label = new Label(); this.Width = 400; this.Height = 250; button.Location = new Point( 5, 10 ); button.Text = "Select Font"; button.Width = 75; label.Text = "FooBar"; label.Location = new Point( 85, 10 ); label.Width = 300; label.Height = 200; Controls.Add( button ); Controls.Add( label ); } } } OK, so the first thing we'd like to see is a font selection dialogue be shown when the user when the button is pressed. Straight away we're into murky water. Showing a dialogue during a test is not generally considered a helpful thing. We need some way to prompt the user for some information, and we also need a way to test. What areas do we need to test? 1.. When the button is clicked, some action is taken by the form to solicit the user input. 2.. A font selection dialogue is displayed. 3.. If the user accepts the change to the font, the change is applied to the label. 4.. If the user rejects the change to the font, no change is applied to the label. This is where the User Interrogator steps in to lend a hand. We will separate the notion of requesting information from the user, and the UI mechanisms used to achieve this goal. I'm going to create a new interface to help with this task, so, to the tests: [TestFixture] public class MainFormSpec { [Test] public void FormShouldCallGetFontFromUserWhenButtonIsClicked() { DynamicMock mock = new DynamicMock( typeof(IUserInterrogator) ); MainForm form = new MainForm( (IUserInterrogator)(mock.MockInstance) ); mock.Expect( "GetFontFromUser" ); ControlTester ct = new ControlTester( form ); ct["Button"].Events["Click"].Fire(); mock.Verify(); } } I'm cheating a little here by using some useful lightweight Control testing classes, which I've included in the example source code. Naturally this doesn't compile, so we need to do a smidgeon of work to get a build: public interface IUserInterrogator { } A change to the MainForm's constructor: public MainForm( IUserInterrogator interrogator ) { button = new Button(); label = new Label(); ... And a tweak of the entry point method: Application.Run( new MainForm( null ) ); We now have a build, and a red light. Time to go for green. All we're interested in at this stage is showing that when the button is clicked, the form calls the GetFontFromUser method on the interrogator object. So, a little tweak to the form's constructor, hook up an event handler for the button's Click event and have it call the GetFontFromUserMethod. public MainForm( IUserInterrogator interrogator ) { this.interrogator = interrogator; button = new Button(); label = new Label(); this.Width = 400; this.Height = 250; button.Name = "Button"; button.Location = new Point( 5, 10 ); button.Text = "Select Font"; button.Width = 75; button.Click += new EventHandler( button_Click ); ... and, void button_Click(object sender, EventArgs e) { interrogator.GetFontFromUser(); } Groovy! We have our first green light. This tells us that we're heading in the right direction, but it's not terribly useful as the GetFontFromUser doesn't actually return a font - let's put that right. We'll add a new test to ensure that the form uses the returned Font correctly. [Test] public void FormShouldGetFontFromUserAndApplyToLabelWhenButtonIsClicked() { DynamicMock mock = new DynamicMock( typeof( IUserInterrogator ) ); MainForm form = new MainForm( (IUserInterrogator)(mock.MockInstance) ); Font wingDings = new Font( "WingDings", 10F ); ControlTester ct = new ControlTester( form ); Label label = ct["Label"].control as Label; Assert.AreNotEqual( wingDings, label.Font ); mock.ExpectAndReturn( "GetFontFromUser", wingDings, null ); ct["Button"].Events["Click"].Fire(); Assert.AreEqual( wingDings, label.Font ); } So, we need to name our label "Label" to satisfy the ControlTester, label.Name = "Label"; change the interface to return a font, public interface IUserInterrogator { Font GetFontFromUser(); } and wire up the event handler properly: void button_Click(object sender, EventArgs e) { label.Font = interrogator.GetFontFromUser(); } Green light. OK, but we've got some duplication here between the tests. Our new test method is implicitly doing the job of the first test, so let's remove the first test. The next step is to provide a real implementation of IUserInterrogator for the form to use. We've already tested the interaction between the interrogator and the form by using a mock, so when we've TDD'd our concrete interrogator, it should just plug straight in. Earlier on, we swam out of murky water by delegating the displaying of the font selection dialogue to the interrogator. It's finally caught up with us, so what are we going to do? Let's write a test. [TestFixture] public class UserInterrogatorSpec { [Test] public void ShouldReturnCorrectFontWhenUserSelectsWingdingsAndAccepts() { Form form = new Form(); UserInterrogator interrogator = new UserInterrogator( form ); Font f = interrogator.GetFontFromUser(); Assert.AreEqual( new Font( "Wingdings", 10F ), f ); } } That basically encapsulates what we want to do, but at the minute we don't have a build, so let's write a stub. public class UserInterrogator : IUserInterrogator { public UserInterrogator(Form owner) { } public Font GetFontFromUser() { return null; } } Now we've got a build, and a red light. In going for green, we'll write a naïve implementation just to crystallise our understanding of the problem. public class UserInterrogator : IUserInterrogator { private Form owner; public UserInterrogator(Form owner) { this.owner = owner; } public Font GetFontFromUser() { FontDialog fd = new FontDialog(); fd.ShowDialog( owner ); return fd.Font; } } Running the tests now results in a FontDialogue popping up. This is just no good at all. We need to separate construction and operation. In order to do this, we'll need to add a new interface. Looking at the implementation has also brought to my attention the need for the current font to be sent to the GetFontFromUser method, so lets make the necessary changes now. [TestFixture] public class MainFormSpec { [Test] public void FormShouldGetFontFromUserAndApplyToLabelWhenButtonIsClicked() { DynamicMock mock = new DynamicMock( typeof( IUserInterrogator ) ); MainForm form = new MainForm( (IUserInterrogator)(mock.MockInstance) ); Font wingDings = new Font( "WingDings", 10F ); ControlTester ct = new ControlTester( form ); Label label = ct["Label"].control as Label; Assert.AreNotEqual( wingDings, label.Font ); mock.ExpectAndReturn( "GetFontFromUser", wingDings, new object[] { label.Font } ); ct["Button"].Events["Click"].Fire(); Assert.AreEqual( wingDings, label.Font ); } } [TestFixture] public class UserInterrogatorSpec { [Test] public void ShouldReturnCorrectFontWhenUserSelectsWingdingsAndAccepts() { Form form = new Form(); UserInterrogator interrogator = new UserInterrogator( form ); Font f = interrogator.GetFontFromUser( new Font( "Arial", 10F )); Assert.AreEqual( new Font( "Wingdings", 10F ), f ); } } and, public Font GetFontFromUser( Font initialFont ) { FontDialog fd = new FontDialog(); fd.Font = initialFont; fd.ShowDialog( owner ); return fd.Font; } with, void button_Click(object sender, EventArgs e) { label.Font = interrogator.GetFontFromUser( label.Font ); } I'm forgoing the red green refactor mantra for this in the name of expediency. Now, we need to delegate the showing of the dialogue in a way that allows us to test, so I create this interface: public interface IDialogLauncher { Font ShowAndReturn(FontDialog fontDialog); } And inject allow for injecting this dependency in to the UserInterrogator: public class UserInterrogator : IUserInterrogator { private Form owner; private IDialogLauncher launcher; public UserInterrogator(Form owner, IDialogLauncher launcher) : this( owner ) { this.launcher = launcher; } ... This now allows us to make some headway. Firstly, let's change the test, [TestFixture] public class UserInterrogatorSpec { [Test] public void ShouldReturnCorrectFontWhenUserSelectsWingdingsAndAccepts() { DynamicMock mock = new DynamicMock( typeof( IDialogLauncher ) ); FontDialog fd = new FontDialog(); fd.Font = new Font( "Arial", 10F ); And constraint = new And( new IsTypeOf( typeof( FontDialog ) ), new NotNull() ); mock.ExpectAndReturn( "ShowAndReturn", new Font( "Wingdings", 10F ), constraint ); Form form = new Form(); UserInterrogator interrogator = new UserInterrogator( form, mock.MockInstance as IDialogLauncher ); Font f = interrogator.GetFontFromUser( fd.Font ); mock.Verify(); Assert.AreEqual( new Font( "Wingdings", 10F ), f ); } } giving us a red light, and now we can change the GetFontFromUser method to delegate showing the dialogue: public Font GetFontFromUser(Font initialFont) { FontDialog fd = new FontDialog(); fd.Font = initialFont; return launcher.ShowAndReturn( fd ); } giving us green. In the event of the user clicking on 'Cancel' on the font selection dialogue, we'd like our ShowAndReturn method to return null and we want our GetFontFromUser method to return the initial font. So a new test looks like: [Test] public void ShouldReturnInitialFontWhenUserCancels() { DynamicMock mock = new DynamicMock( typeof( IDialogLauncher ) ); FontDialog fd = new FontDialog(); fd.Font = new Font( "Arial", 10F ); And constraint = new And( new IsTypeOf( typeof( FontDialog ) ), new NotNull() ); mock.ExpectAndReturn( "ShowAndReturn", null, constraint ); Form form = new Form(); UserInterrogator interrogator = new UserInterrogator( form, mock.MockInstance as IDialogLauncher ); Font f = interrogator.GetFontFromUser( fd.Font ); mock.Verify(); Assert.AreEqual( fd.Font, f ); } The trivial change to GetFontFromUser yields: public Font GetFontFromUser(Font initialFont) { FontDialog fd = new FontDialog(); fd.Font = initialFont; Font newFont = launcher.ShowAndReturn( fd ); if ( newFont != null ) return newFont; return initialFont; } A little refactoring of the tests here leaves us with [TestFixture] public class UserInterrogatorSpec { [Test] public void ShouldReturnCorrectFontWhenUserSelectsWingdingsAndAccepts() { SetUpAndCall(new Font( "Wingdings", 10F ), new Font( "Wingdings", 10F )); } [Test] public void ShouldReturnInitialFontWhenUserCancels() { SetUpAndCall( null, new Font( "Arial", 10F ) ); } private static void SetUpAndCall(Font mockReturn, Font returnFont) { DynamicMock mock = new DynamicMock( typeof( IDialogLauncher ) ); FontDialog fd = new FontDialog(); fd.Font = new Font( "Arial", 10F ); And constraint = new And( new IsTypeOf( typeof( FontDialog ) ), new NotNull() ); mock.ExpectAndReturn( "ShowAndReturn", mockReturn, constraint ); Form form = new Form(); UserInterrogator interrogator = new UserInterrogator( form, mock.MockInstance as IDialogLauncher ); Font f = interrogator.GetFontFromUser( fd.Font ); mock.Verify(); Assert.AreEqual( returnFont, f ); } } We're still on green, so we can move on to developing our concrete class DialogLauncher. We need to specify a couple of pieces of behaviour; firstly, that the ShowAndReturn method calls ShowDialogue on the font selection dialogue passing in the parent form as an argument. Secondly, that if the user clicks OK, the method returns the currently selected font, otherwise it returns null. In order to do this, we're going to need one of our mods to NMock, namely MarshalByRefMock. This is similar to the DynamicMock class with 2 differences, it can mock only those object which derive from MarshalByRefObject, but can mock all methods, including non-virtual ones. This makes it ideal for mocking Controls and Forms. First, we'll specify the behaviour in the event the user clicks cancel. [TestFixture] public class DialogLauncherSpec { [Test] public void ShouldReturnNullWhenUserClicksCancel() { Form parent = new Form(); DialogLauncher dl = new DialogLauncher( parent ); MarshalByRefMock mock = new MarshalByRefMock( typeof( FontDialog ) ); mock.ExpectAndReturn( "ShowDialog", DialogResult.Cancel, parent ); Assert.IsNull( dl.ShowAndReturn( mock.MockInstance as FontDialog ) ); mock.Verify(); } } The implementation seems obvious, so let's go straight for green. public class DialogLauncher : IDialogLauncher { Form parent; public DialogLauncher(Form parent) { this.parent = parent; } public Font ShowAndReturn(FontDialog fontDialog) { fontDialog.ShowDialog( parent ); return null; } } We can now spec the case of the user clicking OK. [Test] public void ShouldReturnSelectedFontWhenUserCLicksOK() { Form parent = new Form(); DialogLauncher dl = new DialogLauncher( parent ); MarshalByRefMock mock = new MarshalByRefMock( typeof( FontDialog ) ); Font expectedFont = new Font( "Wingdings", 12f ); mock.ExpectAndReturn( "ShowDialog", DialogResult.OK, parent ); mock.ExpectAndReturn( "get_Font", expectedFont, null ); Assert.AreEqual( expectedFont, dl.ShowAndReturn( mock.MockInstance as FontDialog ) ); mock.Verify(); } And the corresponding change to the ShowAndReturn method, public Font ShowAndReturn(FontDialog fontDialog) { if ( fontDialog.ShowDialog( parent ) == DialogResult.OK ) return fontDialog.Font; return null; } With that green light, we're just about done. All that remains is to ensure that when the MainForm and UserInterrogator are instantiated without an injected dependency, they avail themselves of concrete implementations of the UserInterrogator and DialogLauncher respectively. [TestFixture] public class UserInterrogatorSpec { [Test] public void ShouldCreateADialogLauncherWhenOneIsNotSpecified() { UserInterrogator ui = new UserInterrogator( new Form() ); Assert.IsNotNull( ui.interrogator ); } ... leads to public class UserInterrogator : IUserInterrogator { private Form owner; internal IDialogLauncher launcher; public UserInterrogator(Form owner, IDialogLauncher launcher) { this.owner = owner; this.launcher = launcher; } public UserInterrogator(Form owner) : this ( owner, new DialogLauncher( owner ) ) { } ... and [TestFixture] public class MainFormSpec { [Test] public void ShouldCreateAUserInterrogatorWhenOneIsNotSpecified() { MainForm mf = new MainForm(); Assert.IsNotNull( mf.interrogator ); } ... leads to class MainForm : Form { private Button button; private Label label; internal IUserInterrogator interrogator; public MainForm() : this(null) { this.interrogator = new UserInterrogator( this ); } ... There we go. Job done! At this point, I recommend that developers do the victory dance. If you don't have one, get one, it really makes you feel good. Summary The solution I arrived at here after this coding experiment is different to the solution I arrived at originally on the TFUI list via a thought experiment. It once again serves to remind me to question the value of thought alone. Thinking is good, testing and coding is often better. As to the solution, there's a clear pattern here that should be reusable. Whenever a UI has to respond to an event, and query the user for some interaction, the way to test drive this is by separating the 3 concerns: 1.. Responding to the event and conceptually asking the user for input. 2.. Creating the UI elements to present to the user. 3.. Displaying the UI elements. Hopefully, this strategy should help in the noble pursuit of TFUI. Usually, descriptions of test driven user interfaces suggest a thin layer of untestable GUI code at the top. This approach has 100% test coverage of the GUI. Key to this is the mocking of user controls and forms. Tag: Folder Viw, File View ??? Tag: 94184
  - 18
    - Hierarchical structure in config file? appSettings in Framework 1.x had the limitation of being "flat". I was just wondering if the section structure of config files in Framework 2.0 has overcome this. Is it now possible to define your own hierarchical structure in the app.config file so that it will be readable in the My.Settings object? I want to use it this way: dirExport = My.Settings.Directories.Export dirImport = My.Settings.Directories.Import I tried to play around with sections and section groups in the config file, but didn't find any working solution. Tag: Folder Viw, File View ??? Tag: 94183
  - 19
    - question on visible and hide Hi All, what is difference between Hide and visible=false ? TIA Tag: Folder Viw, File View ??? Tag: 94176
  - 20
    - ClickOnce + extra ConfigFile? I developed a WindowsForms application that i want to distribute with ClickOnce. I usually develop my applications with a three-layer structure: Presentation, BusinessLogic, DataAccess. So far I have always put them in seperate projects. In VisualStudio2005 I found out that I can have a config-file in the BusinessLayer and reach it with typed properties through the My.Settings object. This is really nice since most config values are used in the Business layer! The problem arises when I want to use the inbuilt ClickOnce publishing wizard. It will not include the config file of the Business project. If I copy the config file manually and rename it, then everything works fine, so distribution is the missing part here. So what do you recommend: 1) Is there a way to force the wizard to include a specific file in the manifest? 2) Should I use MageUI.exe to create manual manifests? I really want to avoid this since it is seems quite complicated. 3) I tried to reach the My.Settings of the Presentation layer from the Business layer, but only succeeded to retrieve it with GetRawXML which gets quite complicated and untyped. Is there a better way that you know? 4) Should I skip the My.Settings typed properties and go for the old style appSettings which means BusinessLayer can reach values in the Presentation config? 5) Should I avoid the whole problem by populating a BusinessLayer Settings object from the Presentation layer on application start? 6) Should I restructure my code and put all classes in the same project, only separating them with namespaces and seperate folders? That means the My.Settings object would be reachable all over. In this particular application there is really no need for seperate DLL-files. Any suggestions from all you experts out there? Tag: Folder Viw, File View ??? Tag: 94173
  - 21
    - Maintain Information About Code created tabs All - I am working on a project that will use tab pages instead of MDI interface. Each tab will be created from code when a user creates or opens an application file. On each tab, will be a usercontrol with my controls. Where can I find information about maintaining information about each tab and the name of the usercontrol on each tab? If a tab is created and my usercontrol added, what's the way to store the name of the tab and usercontrol so that it can be accessed elsewhere in my app? Regards, Brian Tag: Folder Viw, File View ??? Tag: 94172
  - 22
    - How do I bypass this status dialog in PrintPreview? I am using the PrintPreviewDialog for preview document but status message dialog box shows up which displays the page # being printed. But, I want this status dialog only while printing not while previewing. I have tried setting the PrintDocument.PrintController to StandardPrintController. But the status windows is still popping up. What is the recommeded way to bypass this status dialog in PrintPreview? My code is PrintPreviewDialog objPrintPreviewDialog = new PrintPreviewDialog(); StandardPrintController pc = new StandardPrintController(); objPrintDocument.PrintController = pc; objPrintPreviewDialog.Document = objPrintDocument; objPrintPreviewDialog.ShowDialog(); BLM Tag: Folder Viw, File View ??? Tag: 94162
  - 23
    - Combobox text remains selected In my VB.NET 2003 1.1 applicatioin, I'm setting SelectedIndex = 1 on several comboboxes at formload. This works fine, however, the text in the combobox text portion remains selected (blue), and is very annoying. This only started happening when I began setting the SelectedIndex via code. What am I doing wrong? Michael Tag: Folder Viw, File View ??? Tag: 94161
  - 24
    - error in exporting to excel... I have exported the contents of a datagrid to excel.. i used the following code...it was working fine for sometime..but now this error pops up whenevr i try exporting t excel..."""Error Alert !!! Access to this page has been Denied""" Code: '**Declarations for Excel Com object Dim oExcel As New Excel.Application Dim oBooks As Excel.Workbooks Dim oBook As Excel.Workbook Dim oSheets As Excel.Sheets Dim oSheet As Excel.Worksheet Dim oCells As Excel.Range oExcel.Visible = False : oExcel.DisplayAlerts = False strTempName = strQSActiveID & "_Reports" strFileName = String.Format("Excel\{0}.xls", strTempName) '**file is created in the server sFile = Request.PhysicalApplicationPath & strFileName '**a template file has been put in the server sTemplate = Request.PhysicalApplicationPath & "Excel\MyTemplate.xls" '**details about the verticals under this active id is put in the dataset dsVerticalList = fnVerticalDetails() 'Start a new workbook oBooks = oExcel.Workbooks strStatusText = "Before Open" oBooks.Open(sTemplate) 'Load colorful template with chart strStatusText = "After Open" oBook = oBooks.Item(1) oSheets = oBook.Worksheets '**for each vertical fetched in the dataset For intCount = 0 To dsVerticalList.Tables("tblVerticalList").Rows.Count - 1 Dim strVerticalID As String Dim strVerticalName As String Dim strVerticalName_sheet As String strVerticalID = RTrim(LTrim(dsVerticalList.Tables("tblVerticalList").Rows(intCount).Item("Vertical_Id"))) strVerticalName = RTrim(LTrim(dsVerticalList.Tables("tblVerticalList").Rows(intCount).Item("Vertical_Name"))) & "(" & strVerticalID & ")" strVerticalName_sheet = fnReplace(strVerticalID) '**if datatable is empty, nothing is saved '****otherwise a new worksheet is created in the name of the vertical '****details about each vertical is put in a new worksheet If dtClientDetails.Rows.Count <> 0 Then oSheet = oBook.Sheets(1) DirectCast(oSheet, Excel.Worksheet). _ Copy(After:=oBook.Sheets((1))) oSheet.Name = strVerticalName_sheet oCells = oSheet.Cells fnCreateTable(dtClientDetails, oCells, strVerticalName) 'Fill in the data oSheet.SaveAs(sFile) 'Save in a temporary file intCntSheets = intCntSheets + 1 End If Next oBook.Close() 'Quit Excel and thoroughly deallocate everything oExcel.Quit() ReleaseComObject(oCells) : ReleaseComObject(oSheet) ReleaseComObject(oSheets) : ReleaseComObject(oBook) ReleaseComObject(oBooks) : ReleaseComObject(oExcel) oExcel = Nothing : oBooks = Nothing : oBook = Nothing oSheets = Nothing : oSheet = Nothing : oCells = Nothing System.GC.Collect() Catch ex As Exception fnCallError("Problem in Generating Excel : " & ex.Message.ToString & " " & strStatusText) Exit Function End Try '**control is passed to this file to open the just created .xls file Server.Transfer("ExportToexcel_WindowOpen.aspx?strURL=" + Server.UrlEncode(Trim(strQSActiveID))) Loads of data is prsent so i need to use different worksheets.. pls help me out!! Tag: Folder Viw, File View ??? Tag: 94160
  - 25
    - space keys I'm writing a custom Text editor. My idea was to override ProcessDialogKey to handle command keys, such as the arrow or delete and to override OnKeyPress to get char typed. Now I discover a few weird issues: - the space key don't trigger OnKeyPress - the backspace key does trigger OnKeyPress (with '\b') is it something normal (why is that) and stable (I could rely on next version to be like that as well)? Tag: Folder Viw, File View ??? Tag: 94159

I need to display a treeview with a checkbox to allow me to select certain
folders / files. Is there no folder view or file view in Studio .NET 2005?
How can this be accomplished without a third party control?

Thanks.

Top

Re: Folder Viw, File View ??? by Truong

Truong
Mon Nov 14 20:34:42 CST 2005

I think you could use the TreeView control and populate it using
System.IO namespace.

Top