Problems in Connection pooling: Urgent

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
    - two-way databinding radio buttons on a windows form? Hi, How do I get the data in the dataset to update when the radio buttons change? Do I need to add code for this, or shouldn't it happen automatically? Strangely, I have a situation where the radio buttons update the dataset when they get set, but not when they get unset - so all the fields in the ds end up with true values - which cause problems when the form refreshes the data. So I isolated the code in a mini sample and this doesn't update the datasets at all... Thanks! Heidi Tag: Problems in Connection pooling: Urgent Tag: 54825
  - 2
    - VB.NET command line question How can I tell my VB.NET application to return info to the command line that called it? For example, if I run c:\myvbnetprogram.exe from the command line, how can I get it to put something back on the same command line like "hello world"?? thanks Tag: Problems in Connection pooling: Urgent Tag: 54811
  - 3
    - Toolbar buttons Hi, If I set a very long text string on a toolbar button, the string is truncated. Even if I make the button higher, the text does not get displayed on several lines as it would if I had ordinary button. How can I fix this (short of making the button very wide)? Thank you Tag: Problems in Connection pooling: Urgent Tag: 54806
  - 4
    - Finding TEXT of DataGrid Column I am trapping the MouseDown event and am looking to get the value of the cell and also the Column name. I can get the value of the cell with the code below. I can also get the Column name if the DataGrid has a TableStyle. The problem comes when the DataGrid uses the default TableStyle. Using the debugger I walked down the class structure and could find the information at this point dataGrid1.Controls[hti.Column].dataGrid.defaultTableStyle.gridColumns.List._items I can't seem to find my way there at design time, programmatically. Any help would be appreciated. Dave DavidElliott@BellSouth.net ======================================================= if (e.Button == MouseButtons.Right) { DataGridTableStyle ts1; gridBoxText = ""; if (hti.Type == DataGrid.HitTestType.Cell) { gridBoxText = dataGrid1[hti.Row, hti.Column].ToString(); ts1 = dataGrid1.TableStyles["JobRecordCollection"]; if (ts1 != null) gridHdrText = ts1.GridColumnStyles[hti.Column].HeaderText; else gridHdrText = dataGrid1.Controls[hti.Column].Text; } else if (hti.Type == DataGrid.HitTestType.ColumnHeader) { gridHdrText = dataGrid1.Controls[hti.Column].Text; } } } Tag: Problems in Connection pooling: Urgent Tag: 54805
  - 5
    - Detecting DragDrop target when dropped into Explorer I have an application which i need to allow a user to perform drag & drop of a "virtual file" into explorer. Upon dropping the file into explorer, my app would create a blank file at the location and begin downloading data into it. I can get the app to create an empty file for use with the DoDragDrop(), which essentially moves a blank file (e.g. "%TempFolder%\foo.txt") into the proper destination, but there doesn't appear to be any method of retrieving the location of the FileDrop where explorer has moved this file to. Any ideas? Tag: Problems in Connection pooling: Urgent Tag: 54800
  - 6
    - ComboBox : display different string than the selected list item What I'm trying to do : - Add a form to a new project - Add a comboBox to the form with DropDownStyle = DropDown - In form load : ComboBox1.Items.Add("01 - USA") ComboBox1.Items.Add("31 - Holland") ComboBox1.Items.Add("33 - France") ComboBox1.Items.Add("41 - Switzerland") The desired behaviour is that when a user selects a list item only the number is displayed in the textbox part of the comboBox. So if "01 - USA" is selected only "01" should be displayed. Roughly translating the way this would be done in VB6 I tried the following code : Private Sub ComboBox1_SelectionChangeCommitted( _ ByVal sender As Object, ByVal e As System.EventArgs) _ Handles ComboBox1.SelectionChangeCommitted Dim listItemText As String If ComboBox1.SelectedIndex >= 0 Then 'Calculate and store the value we want to display listItemText = ComboBox1.SelectedItem.ToString If listItemText.Length >= 2 Then listItemText = listItemText.Substring(0, 2) End If 'Cancel the selection ComboBox1.SelectedIndex = -1 'Update the textbox part ComboBox1.Text = listItemText End If End Sub However this doesn't work. I've also tried experimenting with the SelectedValueChanged, SelectedIndexChanged and TextChanged events, with no better results. It seems that changing the selectedIndex in any of these routines always cancels out changes made via the text property, whatever the order the operations are carried out in. I've finally resorted to using a timer to update ComboBox1.Text after all these events have finished firing, but it's a very shoddy solution. Surely there must be a way to do this properly? Tag: Problems in Connection pooling: Urgent Tag: 54795
  - 7
    - How to select a group of cells? Hi. I need to allow my users to select groups of adjacent cells, instead of selecting a row. For example, if my row has five cells I need to be able to select cells 2,3 and 4. I can only find ways to select entire rows but not groups of cells. Thanks, Robert Scheer Tag: Problems in Connection pooling: Urgent Tag: 54794
  - 8
    - How to sync combo's selected item to the field's value of the current record I'm running win2k and VB.NET (.net 1.1) I have a data entry form and one of the fields is a combo who's datasource is a dataview. The dataview has 2 columns, an ID column - integer, and a name column - string. The form is not databound so the form gets populated with data for the selected reocord via values from a business class. When the use selects an item from this combo's dropdown list, it writes the ID value to the business class, and desplays the name value in the combo.text property. When I navigate to a different record, the ID value changes for this field. How can i get the combo to syncronize to this ID value, or at least set the combo's text to the correct Name? Only the ID values are persited in the business class and not the name values. In MS Access and some 3rd party combos for VB6 all you had to do was set the combo's value to the ID and it automaticly scrolled to the correct item in the dropdown. Thanks. -- George Padvorac georgep@dontspamme-nwis.net Tag: Problems in Connection pooling: Urgent Tag: 54792
  - 9
    - Help: Exception using Threads and AxSHDocVw.AxWebBrowser I have created an application that loads assemblies (plugins). These plugins are windows forms that have an embedded browser. private AxSHDocVw.AxWebBrowser browser; If I comment out this.browser = new AxSHDocVw.AxWebBrowser(); and associated code to avoid exceptions like this.browser.Dock = System.Windows.Forms.DockStyle.Fill; this.browser.Enabled = true; from my plugin, then I don't get the exception. I only receive the exception when using Threads. If I don't use threads then I don't get the exceptions. The exception is generated --=> AFTER <=-- exiting main(). It is NOT caught by the catch(). Any thoughts? Dave DavidElliott@BellSouth.net ============================================================= EXCEPTION: An unhandled exception of type 'System.NullReferenceException' occurred in system.windows.forms.dll Additional information: Object reference not set to an instance of an object. ============================================================================== CODE main() { try { plugin = (IPlugIn)assembly.CreateInstance("AJB.Plugin"); plugin.PluginID = 74; thr = new Thread( new ThreadStart(plugin.Execute) ); thr.ApartmentState = ApartmentState.STA; thr.IsBackground = true; thr.Start(); thr.Join(); } catch (Exception e) { string s = Application.ExecutablePath.ToString() + "\n" + e.ToString() + e.Message + e.StackTrace; MessageBox.Show(s, "ExecutePlugin() Error"); } } public void Execute() { InputForm ajbInputForm = new InputForm(); ajbInputForm.ShowDialog(); ajbInputForm.Close(); } Tag: Problems in Connection pooling: Urgent Tag: 54791
  - 10
    - Toolbar Floating / Docking I have been unable to find any info on how to accomplish toolbar floating & docking in C#.Net. Has this not been implemented in .Net yet? I'm trying to model my application usability (menu layout, features) based on existing windows apps which to toolbar docking & floating. Any help would be great Thanks, Glen Tag: Problems in Connection pooling: Urgent Tag: 54790
  - 11
    - Databound Combo - How to format date values Im running win2k and .net 1.1 I have a combo who's rowsource is a dataview. The data being used are date values and this is what it looks like in the dataset thats used for this dataview: "2003-06-14T00:00:00.0000000-05:00" And the dates in the combo's list looks like this: 6/14/2003 12:00:00 AM How can i format the dates in the dropdown list to look like this: 6/14/2003 Thanks. -- George Padvorac georgep@dontspamme-nwis.net Tag: Problems in Connection pooling: Urgent Tag: 54789
  - 12
    - Specifying relative path for AxWebBrowser.Navigate Hi, I want past a relative path information to my AxWebBrowser.Navigate method. It should be something like AxWebBrowser1.Navigate("..\temp.html"). If relative path name cannot be specified, is there a way that I can pass my application path to here? Thank you Gos Tag: Problems in Connection pooling: Urgent Tag: 54787
  - 13
    - Help & the HelpProvider -> Showing Topics??? I am trying to display a RoboHelp HLP file using .NET Help and the HelpProvider. All of the commands display the help file, but none preselect the Index or Seach tabs. Nor can I display a preselected topic. What is the Keyword supposed to be set to? Help.ShowHelp(this, helpFile); Help.ShowHelpIndex(this, helpFile); Help.ShowHelp(this, helpFile, HelpNavigator.Find); Help.ShowHelp(this, helpFile, HelpNavigator.Topic, 8025); WindowsAPI.WinHelp(this.Handle, helpFile, (int)(HelpNavigator.AssociateIndex), 8025); helpProvider.HelpNamespace = helpFile; helpProvider.SetHelpNavigator(this, HelpNavigator.Topic); helpProvider.SetHelpKeyword(this, "8030"); helpProvider.SetHelpString(this, "The Select Items window provides a central location for report generation and watch window item selection."); Anyhow, any working examples would be helpful. THANKS! Steve Tag: Problems in Connection pooling: Urgent Tag: 54784
  - 14
    - Exception blocked in Application.Run() Hi, I have a very strange strange problem. All the exception that are thrown in my Windows Forms do not thrigger the display of the traditional exception dialog box that is usually shown. Instead, it seems that the Application class, or any other class that manage the unhandled exception in Windows Forms, catch it and silently continue program execution. Three questions: 1) Is there anyone here that had the same problem? 2) How can it be corrected? 3) Am I missing a property or a setting somewhere? Etienne Fortin Tag: Problems in Connection pooling: Urgent Tag: 54777
  - 15
    - How to make Win32 controls transparent? Hi, I found that checkbox, label and groupbox have painting problem with their background. I create simple frame with background picture and add checkbox, label and groupbox on it. I set transparent background on controls to see whole picture. Yes, it works. But, if I set controls style to System (to get correct XP Visual Style): checkbox and label background lost transparency!!! groupbox doesn't repaint background (group box is like window throw the frame) So, I think that these three controls in not implemented correctly in .NET. So I start to implement my own Win32 controls. I create the "static" control (label is based on it). But the problem is the same: "static" control is not transparent. So, question is: "How to make Win32 controls transparent?" I think, that it could be done successfuly, because checkbox and radiobutton is the same Win32 class, and radiobutton is painted correctly, but checkbox is not. Thanks for any advice. Leo Tag: Problems in Connection pooling: Urgent Tag: 54776
  - 16
    - How to Insert Header and Footers into Richtextbox Hello everyone I was wondering if someone could help me with a eazy way to add header and footers to a richtextbox. I am generating a report into the box and whant to see how it looks with the Headers and footers. Regards Gretar Tag: Problems in Connection pooling: Urgent Tag: 54774
  - 17
    - How can I do this? Hello, I am using a AxWebBrowser control in a VB.net windows form. In the form, I also have a TextBox where the user enters the URL he would like to navigate to. I want the TextBox to change it's display (to reflect the new page address) when the user clicks on an hyperlink on the web page (like in Internet Explorer). I have been looking at the events and methods of the AxWebBrowser object, and I can't find it! Any help on this would be very appreciated. thanks, Ross . Tag: Problems in Connection pooling: Urgent Tag: 54773
  - 18
    - Shared properties across instances I have a console app running that references an Class Library. The console app runs fine, but I want to be able to run a windows form that will let me poll properties of the Class and reset them. As my console is running, it checks these properties, if one of the properties gets set, then my console app knows that it is supposed to do something, like shut down. I have setup a Shared property in my class: Private Shared sTest As Integer Public Shared Property Test() As Integer Get Return sTest End Get Set(ByVal Value As Integer) sTest = Value End Set End Property As I understood it, Shared properties are available to all INSTANCES of a class. Granted that the Windows form is probably a different process than the Console...is there anyway to create a truley shared property across all instances in all processes? IS there another way to do this? My console App is running through records in a DB, so I could just update the record it is working on, but that would be tedious since it would require me to poll the DB way to often. Any help would be appreciated or clues on another way to do this... Tag: Problems in Connection pooling: Urgent Tag: 54771
  - 19
    - DataGrid Updating DataSource I have a datagrid that displays a few columns from a table. I need to be able to update a process date on each row if any of the displayed columns get updated. The process date ("UPDT_DT") is not in the datagrid. I put an event handler on the textboxes in the grid so I can capture when a change occurs, but I can't seem to get the process date column updated. Here is the code I tried: CType (Me.BindingContextdgLists.DataSource, "UW_LISTS").Current, DataRowView).Row.Item("UPDT_DT") = Date.Now The line of code executes but when "UPDT_DT" is updated it resets the row in the data grid. Any ideas of how to accomplish this task ? Tag: Problems in Connection pooling: Urgent Tag: 54769
  - 20
    - app.config I have a solution with 2 projects: a class library(my.dll) + a windows application (mine.exe). In exe project I have a reference to the dll. In both I have app.config files, BUT only mine.exe.config file is generated in \bin\Debug\ folder of exe app. What can I do to generate my.dll.config from app.config ? Thnx for any advice. Tag: Problems in Connection pooling: Urgent Tag: 54768
  - 21
    - How do I enable Add button in custom collection editor? Hi all. I am developing PropertyGrid runtime support for a custom class. One of my attributes in this class is an ArrayList that holds instances of another custom class. I have derived a custom collection editor for this list attribute. When this collection editor is invoked, it does display the correct caption which I assume means it knows the type of objects it is managing. My problem is the Add/Remove buttons are still disabled. From all the research I have done, I believe it is necessary for me to derive this custom collection editor because I am not working with a collection that provides access to an Item attribute for type discovery, right? I have no further enhancements that need to be made to this collection editor, so do I need to be overriding the EditValue method? If so, what should my implementation of EditValue be doing? Also, I do not have a custom TypeConverter written for the EmbeddedObject type. Is this a problem? If anyone out there can help me, I would be more than grateful. As it sits right now, I am as clueless as top management at a software design conference when it comes to collection editors. MSDN is of no help. There are a few article for the picking out there, but none explain the inner workings of the CollectionEditor in any detail. If anyone can point be to some good articles, I would love to see them. I feel like if I could better understand the CollectionEditor class, I might not be as clueless when trying to use them in real world scenarios. Thanks in advance! Casey Chester MIS Director Hirschfeld Steel Co., Inc. public class BrowsableObject { ... ... [Editor(typeof(EmbeddedObjectCollectionEditor), typeof(UITypeEditor))] public ArrayList EmbeddedObjectList { get{ return embeddedObjectList; } } ... ... } public class EmbeddedObjectCollectionEditor : CollectionEditor { public EmbeddedObjectCollectionEditor() : base(typeof(EmbeddedObject)) { } protected override Type[] CreateNewItemTypes() { return new Type[] { typeof(EmbeddedObject) }; } protected override Type CreateCollectionItemType() { return typeof(ProjectPolicy); } public override object EditValue(ITypeDescriptorContext context, IServiceProvider provider, object value) { // // If custom implementation is required, what should it be??? // return base.EditValue (context, provider, value); } } Tag: Problems in Connection pooling: Urgent Tag: 54766
  - 22
    - NullReferenceException NullReferenceException? I receive this exception when i run my application: ******** Begin Exception ******** "System.NullReferenceException: Object reference not set to an instance of an object. 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 CO.Win.MainModule.Main() in C:\CODev\Utveckling\CO\CO.Win\Main.vb:line 128" ******** End Exception ******** It's impossible to find out where in my code its been fired. I've got try-catch statements everywhere but the exception appears only in my main module: try . . Application.Run(startForm) Catch ex As System.NullReferenceException End try There is a datagrid on my form. Thanks in advanced! Tag: Problems in Connection pooling: Urgent Tag: 54762
  - 23
    - How can I do that: Datagrid and textboxes? Hello all. So, I have some textboxes (txtName, txtAddress,txtCity,etc) in a form and a datagrid (grdCustomers) populate of a customers data table. I need this: after I populate (fill) the datagrid, the user click the datagrid row who´s selected, make an search in the database, if necessary, and the customer data appears in the respective textboxes.´ Am I clear? Well, I hope so. I´m use C#. Please, help me and sorry my poor English. Fernando Lopes Brazil. Tag: Problems in Connection pooling: Urgent Tag: 54759
  - 24
    - ListBox within TextBox / CodeCompletion Hello out there, lang: csharp topic: ListBox in RichTextBox / sql / db / editors i am developing an sqlclientshellsystem, that makes it possible to connect to various sqlservers ( ms sqlserver, oracle, db2, ... ). Basic functionality is completed. Now i want to implement wordcompletion for different things: for example, if a user types in a tablename in order to specifiy the columns, i want to suggest the columns to him in form of a listbox popping up beneath the tablename. ( like it is known in many IDEs ( Codecompletion or Intellisense ). I know that i have to maintain keword database, schema information and a like. The problem is, how do i put a listbox into a textbox ?? i tried to TextBox.Controls.Add( ListBox ), but it doesn't have the wanted effect. Any hints ? ( I'm relatively new to .NET and haven't studied the ComponentModel yet, but perhaps you might tell me how i can accomplish my task ) Greetings and thanks in advance. Ole Viaud-Murat Tag: Problems in Connection pooling: Urgent Tag: 54755
  - 25
    - How to disable the Windows form? Dear Friends, How to disable the Windows form? In VB6.0 Form1.Visiable = false; is there equivalent in VC# if so, how do to this? I need continuously running the form. Thanks, Joe Tag: Problems in Connection pooling: Urgent Tag: 54744
- Next
  - 1
    - Datagrid navigation I have a datagrid bound to a datatable that has two relations defined on it. I enabled the 'AllowNavigation' so that I have that little '+' sign to navigate to child records. I wish I could disable one of the relations to be shown when I click on that '+' sign. Tag: Problems in Connection pooling: Urgent Tag: 54740
  - 2
    - Initially focused control Hi! I designed a windows forms dialog with some controls on it. When it loads I want to set the control that has the input focus when the form is displayed. Somehow calling the Focus()-method of the control that I want to have focus in the Form.Load-Eventhandler does not work. Does anyone know a solution? TIA, Markus -- ########################################## Please do not send replies to msdngroups@syska.de. Mails sent to that adress will be deleted without being read. Tag: Problems in Connection pooling: Urgent Tag: 54730
  - 3
    - DataBinding DataSet PrimaryKey Hi, I have a Strongly typed DataSet with a Primarykey which Iam binding to a textbox control on the windows form. In order to create a new row, iam creating a new Data row with dummy values. Up to now everything ok. But, once I change the primary key textbox value on the UI, the same is not reflected in the DataSet. I even tried EndCurrentEdit(). How to reflect the change in the DataSet?? Regards, Srikanth. Tag: Problems in Connection pooling: Urgent Tag: 54723
  - 4
    - LVM_SETINSERTMARK message in .NET Hi: Anybody knows how to use insertion point in ListView in .NET? the message in Win32 is LVM_SETINSERTMARK, but i donno how to use it. Is there any good listview component other than windows'? Thanks Tag: Problems in Connection pooling: Urgent Tag: 54717
  - 5
    - Evalute String If I have a string such as "1=1" or "True And False And True Or True", for example, is there a way in VB.Net to evaluate this into a true or false boolean? I have been using the script COM control with the Eval statement to do this, but is there a way to do this purely in .Net? Maybe using reflection or some other technology? Derek Tag: Problems in Connection pooling: Urgent Tag: 54714
  - 6
    - MainMenu and MenuItems Hello, I am developing a security component for a windows forms application for my company. I want to be able to apply security to MainMenu objects and their associated MenuItems using a generic function. My problem is that I cannot seem to get access to the collection of MainMenu objects on any given form. I generally have 2 or 3 MainMenu objects on each form. However, I can only can access to the one that is currently set as the Form's Menu object using the Menu property of the form. How can I do this??? Please help ??? regards, Felicity Tag: Problems in Connection pooling: Urgent Tag: 54711
  - 7
    - How to size the form onOpen Hi, I would like to open the form with the maximum amount of screen available without setting it to maximized. In other words, I would need to know what is the resolution of the screen to properly resize the window to fill the screen. I was thinking in using the win32 api "GetDeviceCaps" and figure the resolution this way. Is there another way to do it with the .NET FRAMEWORK? Thank you, Ernesto Tag: Problems in Connection pooling: Urgent Tag: 54709
  - 8
    - Request for book recommendations Anyone know of any books that tell you how to do cool stuff with Windows applications? I'm talking things like: How to make your interface look like Microsoft Money. How to make your application run like Outlook. How to make your windows dock like Visual Studio. How to make controls slide across your screen when you click on something. I don't care about the "this is how you add a menu to the form" stuff. Any suggestions are welcome. Thanks! Tag: Problems in Connection pooling: Urgent Tag: 54707
  - 9
    - Selecting field from DataGrid when using a Context Menu I created a context menu and bound it to the data grid this.dataGrid1.ContextMenu = this.contextMenu1; This works fine when I right click. What I am trying to do is to capture the data that is in the specific DataGrid box that the context menu was created on. I am then going to pass it to another winform. The functionality that I am looking for is if you left click on some code in Visual Studio and then right click and select copy. Do a paste somewere else . Whatever line you were on was selected for the copy. Any thoughts would be appreciated. Dave DavidElliott@BellSouth.net Tag: Problems in Connection pooling: Urgent Tag: 54706
  - 10
    - Drag/Drop question I have an MDI app where I'm trying to drag things from one MDI child to another. The problem is that the drop target never gets any event notifications because it never has the focus. What I'd like to do is drag over this item, and then when the mouse moves over it, give it the focus. But I can't figure out any way to have the MDI parent handle MouseMove events. Is there a better way? Thanks Tag: Problems in Connection pooling: Urgent Tag: 54705
  - 11
    - Thread Question -=> System.NullReferenceException after exiting main() I have created an application that will dynamically load other DLLs (plugins). The new plugin is a winform with an embedded IE Browser. I am wanting to have the form to run in its own thread. This would allow for other plugins and the main application to be free to do other work. I have written a little TestDriver for the plugin and am having some difficulty. If I don't use threads everything works just fine. If I do use threads, upon finishing the thread.Join() loop, I step to the end of main and I receive the same exception 3 times. Any help would be appreciated. Dave DavidElliott@Bellsouth.net ============================================================= An unhandled exception of type 'System.NullReferenceException' occurred in system.windows.forms.dll Additional information: Object reference not set to an instance of an object. ============================================================================== [STAThread] static void Main() { IPlugIn plugin = null; Assembly assembly = null; Object obj = null; String s = null; Thread thr = null; try { assembly = Assembly.LoadFrom("..\\..\\..\\bin\\Debug\\AJB.dll"); Type[] types = assembly.GetExportedTypes( ); foreach (Type t in types ) { Type interfaceT = t.GetInterface( "IPlugIn" ); if( null != interfaceT ) { plugin = (IPlugIn)assembly.CreateInstance(t.ToString()); obj = assembly.CreateInstance(t.FullName); s = obj.GetType().ToString(); plugin.PluginID = 74; thr = new Thread( new ThreadStart(plugin.Execute) ); thr.ApartmentState = ApartmentState.STA; thr.IsBackground = false; thr.Start(); //plugin.Execute(); } } } catch (Exception e) { s = Application.ExecutablePath.ToString() + "\n" + e.ToString() + e.Message + e.StackTrace; MessageBox.Show(s, "ExecutePlugin() Error"); } thr.Join(); } Tag: Problems in Connection pooling: Urgent Tag: 54703
  - 12
    - Unable to delete controls. Hi, For some reason I appear to have lost the ability to delete controls in the designer (VS.net 2003) When I right click on any control all the options are blanked out apart from 'View Code' at the top. The Del key doesn't work either. I can still drag controls around the form but deleting them is impossible. I don't really want to go hack out all the definitions from the code... Any ideas? Thanks, Russ Tag: Problems in Connection pooling: Urgent Tag: 54702
  - 13
    - Form, CancelButton, Escape, prevent Form close Hi, I have a form that has a Close button. I set this close button to be the CancelButton for my form. When the close button is pressed, if there have been any changes made to the form, I popup a MessageBox asking the user if they wish to save their changes, using the YesNoCancel message buttons. If the user hits cancel obviously I do not want to close the form. If the user hits close I call Close on the form. This works fine for when the user clicks the close button, but when they hit escape the form closes whether they hit cancel and I call Close or not. How can I get around this? I've pasted code sample below. Thanks, Adam private void bClose_Click(object sender, System.EventArgs e) { FormClose(); } protected virtual void FormClose() { bool close = true; if (myDataPanel.HasChanges()) { DialogResult dr = UIHelperController.Instance.ShowQuestionMessageBox(this,"Changes Made","Changes have been made to this panel. Would you like to save these changes before closing?",MessageBoxButtons.YesNoCancel); switch (dr) { case DialogResult.Yes: close = myDataPanel.Write(); break; case DialogResult.No: close = true; break; case DialogResult.Cancel: close = false; break; } } if (close) { Close(); } } Tag: Problems in Connection pooling: Urgent Tag: 54701
  - 14
    - System.Threading.ThreadStateException I have a form with a grid. When a user selects some text in the Grid and presses Ctrl-C to copy the text, .NET throws an Exception with the description: "The current thread must set to Single Thread Apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it." However, I already have System::Threading::Thread::CurrentThread->ApartmentState = System::Threading::ApartmentState::STA; in my _tWinMain. Thanks for any suggestions, Bumbrlik Tag: Problems in Connection pooling: Urgent Tag: 54700
  - 15
    - Printer Settings Dialog?? Is there a way to directly access the printer settings dialog which is normally available by clicking the "Properties..." button on the PrintDialog? Tag: Problems in Connection pooling: Urgent Tag: 54698
  - 16
    - Is there a simple way to change the DateTimePicker style. It looks sloppy. I want to use the DateTimePicker, so the user can pick the date from the calendar. Is there a way to choose a different calendar style? I see that I can change some colors, but what I do not like most is the red kind-of circle that circles the current date. The control looks sloppy and non-professional. Is there a simple way to clean it up? Thanks... Tag: Problems in Connection pooling: Urgent Tag: 54697
  - 17
    - How-to create user control replacing main application form Hello all, I'm wading my way into .net by writing some custom controls. I would like to provide a parent class to these controls to give them easy access to common information. Initially tried this as a panel, but find that I can't drop non-visual components onto panels (they fall through to the main form). So now I am wondering is it possible to override the main application form with a user-authored form? I tried to do this by inheriting from System.Windows.Forms.Form, but when I instantiate such a control in the IDE, it actually appears to spawn a new thread consisting of an independent windows form which can't be accessed using the normal designer interface. Unrelated question - anyone know of a good online reference on Attributes? Thanks, Markus Tag: Problems in Connection pooling: Urgent Tag: 54692
  - 18
    - Select row in datagrid I would like to find a row in datagrid with criteria and show the part of datagrid with the row selected Thanks for help Tag: Problems in Connection pooling: Urgent Tag: 54691
  - 19
    - Simple problem with the AxWebBrowser control Hello, I am using a AxWebBrowser control in a VB.net windows form. In the form, I also have a TextBox where the user enters the URL he would like to navigate to. I want the TextBox to change it's display (to reflect the new page address) when the user clicks on an hyperlink on the web page (like in Internet Explorer). I have been looking at the events and methods of the AxWebBrowser object, and I can't find it! Any help on this would be very appreciated. thanks, Ross Tag: Problems in Connection pooling: Urgent Tag: 54690
  - 20
    - Using Control.Invoke I want to programatically invoke a KeyDown event to a control that has the focus. Maybe you guys know a better way to do this anyway. In my MainMenu I have an Edit sub-menu that has Copy and Paste items. Each of these menu items I setup to use the Shortcut keys Ctrl+C and Ctrl+V. However, I want the Form window that is handling the main menu messages to be stupid about it and just notify the ActiveControl of a KeyDown event to let the controls handle copying to the Clipboard themselves. Going with this scenario how, in C#, do I invoke a KeyDown event to another control programatically? Or is there a better way to notify the ActiveControl? I've tried the following, but I get a compiler error. ActiveControl.Invoke( KeyDown, this, new KeyEventArgs (Keys.Control|Keys.C)); Thanks for your help, Aaron Tag: Problems in Connection pooling: Urgent Tag: 54686
  - 21
    - Child Form Enter Event Fires Twice Can someone please tell me why a child form event fires twice? I've got an MDI windows app (C#) that has several child forms that a user can select via an Infragistics tab strip. Axe Tag: Problems in Connection pooling: Urgent Tag: 54679
  - 22
    - Master-Detail DataGrids / WEB Services I have a form with 2 grids that participate in a master- detail relationship. I have a web service that supplies the dataset which populates the grids. The following code works great to load the data into the grids: Private Sub LoadGrids() 'instantiate the web services dim oWebService as new uwEngine.uwEngineServices 'call the GetListData service uwData = oWebService.GetListData() 'bind to the dgLists datagrid dgLists.DataSource = uwData dgLists.DataMember = "UW_LISTS" 'bind to the dgListValues datagrid dgListValues.DataSource = uwData dgListValues.DataMember="UW_LISTS.UW_LISTSUW_LISTS_DATA" End Sub Now I need the ability to trap the datatable events (columnChanging, rowChanging, etc). How do I create code to handle the events being that I am not dimming the datatables in my client code ? (the datatables are coming from the Web Service) thanks for your time Tag: Problems in Connection pooling: Urgent Tag: 54667
  - 23
    - how to check if a form is already open Hi, How do I check that a form is already open? I think I have to check how many instances of that form class are initiated, but how do I do that? Thanks, Rainer. Tag: Problems in Connection pooling: Urgent Tag: 54665
  - 24
    - .NET thin client I want to develop a "thin client" using C#. The idea is that most possible information to dynamically create and show forms comes from a server. Dynamic data to be shown on these forms should also come from a server. The forms must contain many windows controls (user controls) which are not statically known by the client assembly (preferably). I think that using aspx is not a good solution due to the poor user interface without complex scripts to show the controls. I want to use web services both for loading info to create the forms and for accessing dynamic data to be shown in the forms. Is this at all practical ? (due to bad performance, caching would help), anyone has an idea about architecture, formats etc Tag: Problems in Connection pooling: Urgent Tag: 54662
  - 25
    - Shaped Form (TransparencyKey) problem on some installations Hi I have been using the combination of the BackgroundImage and TransparencyKey properties of a form in order to create an interesting splash screen. This is working on some machines but not others (All Windows XP). Is anyone out there aware of any problems regarding shaped forms at any framework release? Thanks in advance Andrew Wiles Tag: Problems in Connection pooling: Urgent Tag: 54644

Hello All,

My windows application has a form that needs to display fresh data to the
user at short intervals (say every 10 seconds). For this purpose, I have
included a timer. On every timer tick, I perform the database related
operations to display the result to the user.
Note: Multiple instances of my application will be running at the same time
and hence the timer running in each instance and initiation database
operations.

With this approach, I started receiving errors like: Connection timed out.
The connection pool has reached its maximum size because every request to
the database opened and closed a connection. I changed the approach to:
Creating a single connection for the entire form so that all operations use
the same open connection. The connection is closed when the form closes.
Even then, I now get the following type of errors:

a) 8/11/2003 3:21:40 PM SqlUtility Execute Error: Transaction
(Process ID 73) was deadlocked on lock resources with another process and
has been chosen as the deadlock victim. Rerun the transaction.
TimeTic Calling sp_ProductionTestBackgroundTask at
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior,
RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at IMD.OM.Database.SqlUtility.Execute(SqlParameter& prmOutParam,
SqlConnection cnnCommon) in
d:\khyatis\work\projects\imd\imdom\misc\sqlutility.cs:line 595
8/11/2003 3:21:40 PM SC Status Start NSC Monitor Error: at
OM.Database.SqlUtility.Execute(SqlParameter& prmOutParam, SqlConnection
cnnCommon) in d:\xyz\work\projects\\misc\sqlutility.cs:line 608
at IMD.OM.SC.SCStatus.StartNSCMonitor(SqlConnection commonConnection) in
d:\xyz\work\projects\scstatus.cs:line 564System.Data.SqlClient.SqlException:
Transaction (Process ID 73) was deadlocked on lock resources with another
process and has been chosen as the deadlock victim. Rerun the transaction.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at IMD.OM.Database.SqlUtility.Execute(SqlParameter& prmOutParam,
SqlConnection cnnCommon) in d:\xyz\work\projects\\misc\sqlutility.cs:line
595

I need to get rid of the above problem.

Regards,
Mithun