Another CreateObject C# question

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
    - 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: Another CreateObject C# question Tag: 94196
  - 2
    - 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: Another CreateObject C# question Tag: 94191
  - 3
    - 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: Another CreateObject C# question Tag: 94190
  - 4
    - 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: Another CreateObject C# question Tag: 94189
  - 5
    - 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: Another CreateObject C# question Tag: 94188
  - 6
    - RE question on visible and hide Thank you . Tag: Another CreateObject C# question Tag: 94187
  - 7
    - 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: Another CreateObject C# question Tag: 94185
  - 8
    - 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: Another CreateObject C# question Tag: 94184
  - 9
    - 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: Another CreateObject C# question Tag: 94183
  - 10
    - question on visible and hide Hi All, what is difference between Hide and visible=false ? TIA Tag: Another CreateObject C# question Tag: 94176
  - 11
    - 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: Another CreateObject C# question Tag: 94173
  - 12
    - 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: Another CreateObject C# question Tag: 94172
  - 13
    - 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: Another CreateObject C# question Tag: 94162
  - 14
    - 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: Another CreateObject C# question Tag: 94161
  - 15
    - 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: Another CreateObject C# question Tag: 94160
  - 16
    - 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: Another CreateObject C# question Tag: 94159
  - 17
    - Mybase.New() in VS 2005 In VS 2003, if I overloaded the New() method of a WindowsForm, I always included a call to Mybase.New(), the same way this method was called in the native New() method. In VS 2005, the New() method in WindowsForms are not visible in the .vb or Designer.vb files. If you add a New() method to the .vb file of the WindowsForm, a formatted Sub is created for you, however, it is missing the call to Mybase.New(). If I create WindowsForms that require an overloaded New(), should I add the call to Mybase.New()? It seems logical that if you create a new WindowsForm that Inherits System.Windows.Forms.Form, you should call the constructor of its base class. -- Michael Hockstein Tag: Another CreateObject C# question Tag: 94156
  - 18
    - Refresh fontfamily.families I use the following code to fill a combo box with the installed font names. I added a button next to it, to refresh the list in case someone added some new font. I use the following code to build the list. PROBLEM IS, the "new InstalledFontCollection()" never picks up the new fonts. Only the ones that were there when my app started. private void FillComboBoxFontName() { comboBoxFontName.Items.Clear(); InstalledFontCollection fonts = new InstalledFontCollection(); foreach(FontFamily family in fonts.Families) { comboBoxFontName.Items.Add(family.GetName(0)); } } Tag: Another CreateObject C# question Tag: 94154
  - 19
    - ShowDialog has own taskbar button Hi all, Why is it that when I create a new windows form and show it in my application it has it's own taskbar button? Is there a way around this? Regards Gav Tag: Another CreateObject C# question Tag: 94151
  - 20
    - DLL References (New developer) I have two projects. Project A and Project B. In project A I have added Reference of Project B. And in Project B I have added Reference of Project A. It was not possible in framework prior to Framework 2.0. It works great for me. My question is, is it ok to add reference like this. Is this against any programing standard. Please give me some suggestion or advices, as I am very new to software development. Thanks Green Tag: Another CreateObject C# question Tag: 94149
  - 21
    - richTextBox with the style I'd like to display a set of data in the following format in a richTextBox, could anyone of you tell me how to do it? data1 value1 data2 value2 ... datan valuen where data1, data2, ...datan are supposed to be in bold font, and value1, value2, ... valuen are in non-bold font. All data is coming from a dataSet object. Thanks for the help Tag: Another CreateObject C# question Tag: 94147
  - 22
    - SQL data base connection Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{6D5140C1-7436-11CE-8034-00AA006009FA}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). Tag: Another CreateObject C# question Tag: 94145
  - 23
    - Visual Inheritance Hi, I would like to put on all my Forms a BackgroundImage. Because it is the same one I want to use Visual Inheritance. I am not sure why I have to create a DLL-Library for my base Form in VS2005, but this is what I did. So somewhere in my base form I want to load the image, which should be a relative path from Application.StartupPath. Since I find myself in a DLL-Library I have no access to Application.StartupPath. My next thought was okay then I make my base class abstract (mustinherit) and force the derived class to set the path with a mustoverride method. Unfortunately I cannot set this class to mustinherit, because the Designer has problems to create the form. Can somebody tell me what is the best way would be to solve this. Thanks, Sebastian Lampka Tag: Another CreateObject C# question Tag: 94144
  - 24
    - Drag Form without border I am writing a WinForms app that can be used, if wanted, on a touch screen. When used in this manned, I supply an on-screen keyboward to enter data. I want to display the keyboard form borderless and also allow the user to drag it around the screen. I have a dedicated button on the form to use to drag the form but for the life of me can't figure out how to actually drag the form when the user touches the button and keeps it pressed and drags. Suggestions anyone? Tag: Another CreateObject C# question Tag: 94143
  - 25
    - How do I obtain Form.Close() result? This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C5E601.C4B48D90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable My WinForms application can have any number of top level forms open = at a given time. If the user selects File|Exit, all of the forms are = closed. The loop to close the forms looks something like this: foreach(MyForm form in AllMyForms){ form.Close(); } Application.Exit(); The OnClosing method [aka OnFormClosing in .NET 2.0] is overridden = in MyForm. If the user has made changes to his form, this method asks = him if he'd like to: a) save his changes b) forget changes and proceed to close the form c) cancel the form closure loop and keep working on the form In the event that the user chooses (c), OnClosing will cancel the = closure operation. What I don't understand is why Form.Close() returns = void. It seems like it should return a bool indicating whether or not = the Close() operation was completed. Am I missing something? Given a = call to Form.Close(), how can I tell if the form closure actually = succeeded. The only idea I can come up with is to check the Form.IsDisposed = property immediately following the Close() call, with the assumption = that if my modeless Form truly did close, it should also be Disposed. Is = this the recommended approach? Jules =20 In the ------=_NextPart_000_000A_01C5E601.C4B48D90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.3790.2541" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>   <FONT face=3DVerdana> = My WinForms=20 application can have any number of top level forms open at a given time. = If the=20 user selects File|Exit, all of the forms are closed. The loop to close = the forms=20 looks something like this:</FONT></FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3D"Courier New" size=3D2>foreach(MyForm form in=20 AllMyForms){</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>   =20 form.Close();</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>}</FONT></DIV> <DIV><FONT face=3D"Courier New" = size=3D2>Application.Exit();</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>    The OnClosing = method [aka=20 OnFormClosing in .NET 2.0] is overridden in MyForm. If the user has made = changes=20 to his form, this method asks him if he'd like = to:</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2>    a) save his=20 changes</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2>    b) forget changes = and proceed=20 to close the form</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2> </FONT><FONT face=3DVerdana=20 size=3D2>   c) cancel the form closure loop and keep working = on the=20 form</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>    In the event = that the=20 user chooses (c), OnClosing will cancel the closure operation. What I = don't=20 understand is why Form.Close() returns void. It seems like it should = return a=20 bool indicating whether or not the Close() operation was completed. Am I = missing=20 something? Given a call to Form.Close(), how can I tell if the form = closure=20 actually succeeded.</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>    The only idea I = can come up=20 with is to check the Form.IsDisposed property immediately following the = Close()=20 call, with the assumption that if my modeless Form truly did = close, it=20 should also be Disposed. Is this the recommended approach?</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>Jules</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>    </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2></FONT><FONT face=3DVerdana=20 size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>    In the</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_000A_01C5E601.C4B48D90-- Tag: Another CreateObject C# question Tag: 94138
- Next
  - 1
    - Transforming Controls? Hi, I'm trying to draw a standard windows forms control onto a form with a transformation. Before drawing the control I'm applying a world transformation to the graphics object, but the results seem to be unpredictable. Depending on the control my transformation seems to be applied incompletely. For example, buttons are translated as I'd expect but not scaled or rotated. The easiest way to demonstrate this is to extend Bob Powell's excellent animation demo from http://www.bobpowell.net/animation.htm To see what I mean, add this class to Form1.cs in the demo: public class ButtonShape : Shape { private class MyButton : Button { public void Draw(Graphics g) { PaintEventArgs args = new PaintEventArgs(g, new Rectangle(0, 0, Width, Height)); base.OnPaintBackground(args); base.OnPaint(args); } } private MyButton mb = new MyButton(); public override void RenderObject(Graphics g) { mb.Draw(g); } } And modify the Form1 contstructor to add some ButtonShapes: switch(r.Next(4)) { // ... snip .... case 3: s = new ButtonShape(); break; // ... } After making these modifications I get some buttons floating around with the other shapes, but they do not rotate as the others do. Anyone have any suggestions? Is it just not possible to apply a transformation to a control because of the way they are drawn? Thanks, -Merit Wilkinson Tag: Another CreateObject C# question Tag: 94132
  - 2
    - hide datagrid column .net 2.0 I am using c# express RTM. I have a datagrid with attached to a dataset. I have set the primary key (identity seed) column's visible proeprty to false. The column is hidden in design view but when I run the form it appears. Not sure if this is a bug, or if because the field is a primary key field with an identity seed it cannot be hidden. Another question, how can I set the default value of a column to the identity field of the parent form? The datagrid is in a parent-child relationship. Tag: Another CreateObject C# question Tag: 94128
  - 3
    - Keeping a form on top of its application I'm trying to keep a form on top of all other windows in its own application, but not on top of all windows in all applications. I can get it to be on top of all applications by setting "TopMost = true", but can't get it to only be on top of its own application (i.e. when I select another application the form I've made TopMost is still on top of everything). I've tried setting the MdiParent to be the application, but then the "TopMost" property seems to have no effect (the code I was using for this is shown below). DebugControl debugCtrl = new DebugControl(); debugCtrl.MdiParent = this; debugCtrl.TopMost = true; debugCtrl.Show(); Has anyone any idea how I can do this? Thanks in advance, Steve Tag: Another CreateObject C# question Tag: 94121
  - 4
    - MainMenu competability (1.1 vs. 2.0) Hi, I have an MDI application written using framework 1.1 with a mainMenu. Installed framework 2.0 on the machine and now the main menu doesnt appear... any suggestions? thanx, Picho Tag: Another CreateObject C# question Tag: 94117
  - 5
    - how to change color of specific row in datagrid ??? Hi, how can you change the color of a specific row in a datagrid ? thanks Christian ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: Another CreateObject C# question Tag: 94116
  - 6
    - Hosted Winforms control in Internet Explorer Hi All, I've got a WinForms control that I host in IE to allow certain people to upload a directory structure to my Intranet. The control is signed, strongly named and the web site it's running from is Trusted and Trusted sites have been given full permissions in the .Net configuration tool. It works perfectly if I only have Framework 1.1 installed, as soon as I install 2.0 - it stops working entirely, the placeholder on the page never disappears. It's the same behaviour that I get when I try and run it from a non-trusted sites, but I've made sure that it's setup in 1.1 and 2.0 I've tried it on my bosses machine so he doesn't have Visual Studio installed and it's the same, install 2.0 it stops working, uninstall 2.0 and it starts working again. Any ideas please ? Tag: Another CreateObject C# question Tag: 94113
  - 7
    - Text looks bold when i manually double buffer to a bitmap Hi Thanks for taking the time to read this post and offering any suggestions/advice. I have an owner drawn control that uses the standard setstyle method to double buffer my painting. Everything works fine and looks as intended. I am now in the process of expanded my rendering class to support internal scrollable sections. I decided to do this by creating a wrapper class to handle the painting. The wrapper class creates a new bitmap and passes the graphics object from it to the original paint event of the renderer. It then works out what section of the paint needs to be blitted onto the real canvas and does so using the drawimage method. It all works great apart from any text that is rendered to the new bitmap looks really bad. It almost looks like it is bold but it is also nowhere near as smooth as a bold font would be. I believe I have ruled this down to the new bitmap being created with a transparent background using black pixels. If I change the background to white using the setpixel method and make it transparent using this colour (a straight fillrectangle and anything other than white does not work) then everything looks like it should. Obviously this is a very slow method and totally unacceptable in the final product. Can anyone shed any light on the standard practice used to eliminate such problems? My current code in the paint method of the scrolling wrapper class is as follows .... 'create canvas for child to paint on. we will extract the applicable portion of the 'canvas and blit the render to the passed graphics object Dim canvas As New System.Drawing.Bitmap(rect.Left + rect.Width, rect.Top + h) canvas.SetResolution(g.DpiX, g.DpiY) Dim gphcs As System.Drawing.Graphics = System.Drawing.Graphics.FromImage(canvas) Dim rect2 As New System.Drawing.Rectangle(rect.Left, rect.Top, canvas.Width, canvas.Height) Dim srcRect As New System.Drawing.Rectangle((rect.Left + _XOffset), (rect.Top + _YOffset), rect.Width, rect.Height) '***** this is the bit that corrects the problem, but it is very slow ***** 'Dim x, y As Integer 'For x = srcRect.Left To srcRect.Right - 1 Step 1 ' For y = srcRect.Top To srcRect.Bottom - 1 Step 1 ' canvas.SetPixel(x, y, System.Drawing.Color.White) ' Next 'Next 'canvas.MakeTransparent(System.Drawing.Color.White) _renderer.Paint(cp, gphcs, rect2) g.DrawImage(canvas, rect, srcRect, Drawing.GraphicsUnit.Pixel) gphcs.Dispose() canvas.Dispose() Tag: Another CreateObject C# question Tag: 94108
  - 8
    - Usercontrol in a Listview? Hi I would like to add a number och usercontrols (cotaning a pppicture and a couple of lines of text) to a listview(?) or something like that. I need to be able to mark my controls, use drag and drop and so on. The finished product will look simular to Windows explorer in thumbnail mode. Any suggestions? /Jimmy Tag: Another CreateObject C# question Tag: 94107
  - 9
    - Whidbey - Custom Control I have created custom control that inherits from a control type toolstrip to which I add several buttons to him, when using this control appears to me a control toolstrip but without ningun button, which I can do so that these appear in the control. Thanks. Tag: Another CreateObject C# question Tag: 94106
  - 10
    - Smart Client - always slow Hello, I'm facing a problem with the smart client technology. We have a smaller application (around 5mb) which we want to deploy with smart client technology. This works but the problem is, the exe and dll are downloaded each time the applicaiton is started. It's logical that the very first time the whole stuff has to be downloaded. But without any assembly change, the exe and dll are downloaed every time the applicaiton starts. The tool 'gacutil /ldl' shows the correct version of the exe and dll and the entries are there before I start the application for the x. time. What's the problem? ANY help is appreciated. Thanks a lot for helping Markus Tag: Another CreateObject C# question Tag: 94103
  - 11
    - asynchronous method calls hangs/takes time with other workstations i have this windows app running smoothly at our development and test machines which suddenly hangs/takes very long time to process on client workstations. the culprit is a routine which calls the same method asynchronously. client workstations are running windows 2000 sp3 and windows server 2003 (no service pack). could this be a problem with their OS and this issue has been fixed with their latest service packs? anyone? Tag: Another CreateObject C# question Tag: 94102
  - 12
    - Adding a common componet to multiple pages... Hi, I have a common control that I want to add to two tab control pages. When I do this it only shows up on one tab page (ie. the last page it was added to). I've noticed in the C# code that the control count for the page is correct when added to the first tab page, however when I add it to the second tab page, the control count is decremented, which is why I am not seeing my common control on both pages. Can anyone explain why it can only belong to one page? and is there a simple way to achieve what I am trying to do? Thanks, Dave Tag: Another CreateObject C# question Tag: 94093
  - 13
    - Why won't Tabs in WindowsForms 2.0 render with XP style? Supposedly the tab control in VS.NET 2005 can be rendered with the same style as the menu and the toolbar. But when I put one on my form it shows up as the old style. Even happens after doing a call to: Application.EnableVisualStyles(); What's going on? Tag: Another CreateObject C# question Tag: 94088
  - 14
    - Treeview Focus problem I have a problem with MyTreeview.selectedNode = MyNode. I have a large tree and sometimes the selected node ends up out side the viewed area and I have to scroll to find it. Is there a way I can program the selected node to always be visible? Tag: Another CreateObject C# question Tag: 94086
  - 15
    - Alt+T How do a process Alt+N on a windows form? Can I connect Alt+N to a button with the caption 'Add&New' Tag: Another CreateObject C# question Tag: 94085
  - 16
    - treeview automatically selects first node, even when a different one is clicked on If I set up a treeview with two node in it, and then click on the second one, the AfterSelect fires _twice_ - once for the first node, once for the second node. Can anyone explain why it fires for the first node, and how I can make it stop? Cheers, Andy D Code to show it happening (presumes a button called button1, a treeview called treeView1 and a textbox called textBox1): private void button1_Click(object sender, System.EventArgs e) { TreeNode n = new TreeNode("Test1"); treeView1.Nodes.Add(n); n = new TreeNode("Test2"); treeView1.Nodes.Add(n); } private void treeView1_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e) { textBox1.Text += "/n" + e.Node.Text; } Tag: Another CreateObject C# question Tag: 94080
  - 17
    - Display deleted rows in datagrid Hello, I'm trying to make the System.Windows.Forms.DataGrid to display all rows from a DataTable (even deleted ones). I'm using the following code snippet: dataGrid.SetDataBinding(myDataSource, myDataMember); DataView dataView =(DataView)( (CurrencyManager) dataGrid.BindingContext[myDataSource, myDataMember]).List; dataView.RowStateFilter |= DataViewRowState.Deleted; The code works as I a expected (I mean it keeps deleted records in the datagrid), but it always remove the last row (exactly like the bug described here http://www.dotnet247.com/247reference/msgs/29/145143.aspx ). When i click the column header, all deleted rows reappear, and everything looks fine. I'm using .NET Framework 1.1 with Sp1. I'm wondering if this is really a bug, or am I just missing something? Is there another way of keeping deleted rows visible in DataGrid? Tag: Another CreateObject C# question Tag: 94079
  - 18
    - Exception Running App under NTD I have a .NET 1.1 Winforms application I am running via no touch deployment (HTTP link from web app). On some workstations we get the following error at launch: "Application has generated an exception that could not be handled." I have already increased Intranet trust to Full, and even signed the assembly and granted it Full trust as well (via .NET wizards). The app does work if the currently logged in user is given admin privileges on the domain, so this issue seems to be permissions related. What else can we do, short of making users admins, so they can run this application? Thanks, Krip Tag: Another CreateObject C# question Tag: 94077
  - 19
    - Hide MenuItem Hi, I have the name of a MenuItem in a string variable strNombreMenuItem = "MenuItem1" I know this MenuItem1 was declared an instaciated in the form as a part of a Mainmenu. Now, I need to disable this object (MenuItem1) but I only have it's name. How a get a reference to this object? I neede the reference buecause I need to disable it. Thanks in advance.... -- Eusebio Tag: Another CreateObject C# question Tag: 94074
  - 20
    - Alpha blended, Double buffered non-client areas. How? Please help! Hi, I am deriving from Panel and I paint the client and non-client area of the panel myself. I am drawing a bitmap in both the client and non-client area. The bitmap has an alpha channel so the edges are neatly anti-aliased. I am using the WM_NC* messages to distinquish between the client and non-client area. I set the ControlStyles to both OptimizedDoubleBuffered and SupportTransparentBackColor and set the BackColor to a transparent color. All of this works fine, except for the fact that the non-client area does not use double buffering or transparency. It seems that the control styles are used for the client area only? I have read Bob Powell's faq on Windows Forms and he also has a section on transparent forms. However, if you set the WS_EX_TRANSPARENT style, you will never be able to use double buffering, since Bob's technique will invalidate the parent's window, causing flickering. Microsoft's approach for copying the parent's background into an offscreen surface, and then copying your own graphics over it sounds like the only possible way to deal with double buffered transparent controls. The frustrating thing is that .NET has everything in place with the background painting. I've checked reflector and OnPaintBackground indeed paints a piece of the parent control into the graphics object, when SupportTransparentBackColor is set and the backcolor alpha is not opaque. Great, but it seems that OnPaintBackground only paints the client area and not the non-client area... Did I miss something? Bottom line is: does anybody know how to handle double buffered, transparent, alpha blended non-client area's? I'm counting on you, Bob :). Regards, Jelle van der Beek Tag: Another CreateObject C# question Tag: 94071
  - 21
    - propertyGrid display filedialogbox Hello all, I am trying to use a propertyGrid control which will display custom made properties. I have therefore created a class (properties.vb) that i have assigned to the propertyGrid.selectedObject property and that keeps the properties that i want to display. What i am trying to accomplish is the following: I'd like to have a property (in the propertyGrid) that when clicked it would open an openfiledialog box (like the one that is used when we select an image for a control) but i want it to be able to select any type of file. A second thing is that i want to have a property that would be a collection so when the ellipsis (...) is clicked an add/remove collection items box is shown. This is easy to do (declare the public property to be of collection type). But i'd like ,when pressing the Add button (on the add/remove collection items box) an openfiledialog box to appear and the item selected to be added to the collection. It would also be great if i could create the properties that appear on the right side of the add/remove collection items box. Any ideas ? thx a lot ,theodore Tag: Another CreateObject C# question Tag: 94069
  - 22
    - Getting NullReferenceException setting ReadOnly property of a DataGridViewCell Using .NET 2.0 Release: I get the subject exception when performing the following sequence of events. 1. I manually select a cell in a DataGridView. 2. via a ComboBox I change the cell's column's state to ReadOnly=False. 3. this causes the selected cell to enter edit mode because I've set the grid's edit mode to EditOnEnter (which is the mode I want to use). 4. Before anything is seen I handle the CellFormatting event where I color and set the ReadOnly property of cells base on their value and other cell values in the row. Result: If the selected cell is to be read-only, I get a NullReferenceException when trying to set ReadOnly=True because the cell is apparently in edit mode. Does anyone know another work-around for this when my edit mode is EditOnEnter? Thanks, Nate Tag: Another CreateObject C# question Tag: 94067
  - 23
    - How to show read-only DataGridViewCheckBoxColumn CheckBoxes as Grey'd out. I want read-only DataGridViewCheckBoxColumn CheckBoxes to be drawn Grey'd out. For the DataGrid, I made a custom CheckBox column where I painted Grey CheckBoxes when the column was in ReadOnly mode. Do I have to do something similar for the DataGridViewCheckBoxColumn class or has some style been provided to do this? Nate Tag: Another CreateObject C# question Tag: 94066
  - 24
    - Getting Caret Position from another process Does anyone know how I can get the caret position in terms of screen position from the currently active window? By currently active window I don't mean just mine, rather any window. Basically the end result I want is to position a floating tooltip style window next to wherever the user is typing (their caret) regardless of what app they are using. I've tried calling GetCaretPos, however this only seems to work when my app currently has the focus. At all other times the POINT returned by GetCaretPos is 0,0. I think this is due to other windows destroying their Carets when they lose the focus. Does any smart cookies out there have any ideas? Tag: Another CreateObject C# question Tag: 94063
  - 25
    - Exporting data, how to set output order, ala View Tab Order My app has to export data from SQL Server tables, along with other data (data about the data being exported) into a text file. I have several checkboxes on my VB.NET 2003 Winform, which allows the user to select wether or not to export that peice of data, ie, Export Sum Total. I also have a user control that allows the user to select SQL Server columns in one list box and move them to a "selected columns" listbox. This allows selection of the data from the SQL Tables to export. I need to be able to allow the user to select the order in which the items should be exported to the text file. I was thinking about some mechansim similar to Visual Studio's UI where you can set the tab order of the controls on the form. Any ideas, solutions, sample projects would be greatly appreciated. Michael Tag: Another CreateObject C# question Tag: 94057

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

Top

Re: Another CreateObject C# question by Jason

Jason
Fri Nov 11 15:52:39 CST 2005

Homer,

Read up on .NET Reflection. Not ideal but it answers your question.

object[] args = null; // Could be populated depending on Method Signature.
yourobject.GetType().InvokeMember("MethodName",
System.Reflection.BindingFlags.InvokeMethod, null, yourobject, args);

Jason Newell

Homer wrote:
> 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

Top