SamSmithnz's Q&A profile

• Windows Forms Smart Client Very Slow SqlConnection.Open() on some clients

  We have a smart client that uses ADO.Net to access SQL Server.  On some machines the initial call to open a SQLConnection  can take up to 2 minutes to return.  Subsequent calls take <1 sec.   On other clients the call returns in < 1 sec. If the application is run locally (not HTTP deployment) then the call executes in < 1&n ...Show All

• Visual Studio Team System Estimating time and assigning scenarios...

  1- Isn't a scenario always broken down into one or more tasks for developers to impelement 2- If the above statement is true, then why do we assign scenarios to individuals Why do we assign scenarios to anyone at all, since implementing the scenario would actually mean implementing each of its individual tasks 3- Is it correct to estimate a time for a whole scenario Shouldn't we actually estimate the time for each task requried to be done to acomplish this scenario 4- Isn't a scenario just another name for a use case (with alternative courses, exceptions and all) or am I confused Thank you, Sammy Hi Sammy, ...Show All

• Visual Basic checking properties of folders

  Hi all, I am trying to run some processes to tidy up our SAN storage.  A couple of the things I am struggling with are : 1)   Checking the security of the folder properties to check who the owner is 2)   Checking the security of the folder to check if "Inherit" is ticked 3)   Search a text file for specific text I already have a process to run SETACL to fix ownership and permissions, however this will run regardless.  What I want to do is first check the Ownership and permissions before I run the process. With regards to the 3rd point, the SETACL pipes the results to a text file, so I wa ...Show All

• SQL Server how can i use The "Use Database" statement >>>

  the question is how to use use database statement if the name of the database contain spaces please help me Thanks If I offended you, please accept my apologies! My links were intended only to be fun, nothing more. They are neither related to you nor your question. -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de ...Show All

• SQL Server New Guy Question 2: SQL on-the-fly at package runtime?

  Here I go again...thanks for your patience... I'm trying to create a single, all-purpose SSIS package that would move data from a source database table to a matching target database table. The requirement is to create the package such that the SQL statement used by SSIS could be supplied at runtime. This would allow a single package to be used for different SQL statements, representing different tables, rows and columns, etc. as needed. The data movement combinations are highly variable, so I'm hoping to find a flexible one-size-fits-all solution with a single package. I've looked at setting up a string variable for the SQL statement, and p ...Show All

• Windows Forms Record Selector... :( Please Help!

  I have spent way to much time looking for this variable. Where in the gridview can I turn off that horriable record selector - the first column that shows you the arrow. I look and can't find it. If someone can help I would appreciate it... I'm working in vb .net (window forms - not asp .net) 2.0 Visual Studio 2005 Pro... thanks -rjp I must have read that 5000 times and you know the word header made me think it was show the header. Thanks for shed'n some light on the matter. I think I'm spending to much time in front of the computer. -rjp ...Show All

• Visual C# Keep getting exception message that Type is not marked as Serializable

  Hello, I a pretty sure that I am on the right track. I am trying to serialize a object which has a multitude of member variables. Some are collections of graphics based objects ie objects which are drawn in a view (TabPage derived). The object to the serialized also is drawn in such a view. It is like a parent object that contains other objects. I have separated code from data so that I am not trying to serialize anything like the TabPage view or Pens, Brushes.... Despite this, I am continually getting an exception when trying to serialize the object. I am being told that a view of mine OpeningsView is not marked as seriali ...Show All

• Windows Forms Adding listbox like control to Outlook Calendar Look and Feel Sample

  I would like to add a listbox like control to the Outlook Calendar Look and Feel Sample by Dinesh Chandnani; I like the project but think it would be nice to click on appointments to edit them; and display a fly over tool tip; all of which would work better if it was another control added to the DataGridView with events like OnClick; not sure how to go about though; don't see much I can do in the Paint function to achive this; any help would be helpful. Thanks Referring to http://www.windowsforms.net/Default.aspx tabindex=4&tabid=49#WinForms%20V2%20Demo%20App Sample app; What I'd like to do is add a con ...Show All

• Visual C# Reopening form2 from form1 (after it was closed once) for 2nd time causes error

  Hi i have problem with reopening form2 from form1 after form2 have already been closed once. Problem occur when i press button2(on form1) to open 2nd form for second time (after it was already open and closed with X) Error msg: System.ObjectDisposedException was unhandled   Message="Cannot access a disposed object.\r\nObject name: 'Form2'." I have set controls on form2 to public becouse I need to update values on 2nd form after each keypress on form1 while 2nd form is open in other words if both forms are open user should see numbers updating on form 2 instantly as he press button on form 1. button2 on form ...Show All

• Windows Forms get the current TabPage from a PropertyPage

  I have a PropertyPage which contains a TabControl with multiple TabPages within. The PropertyPage has an Apply button. I want to know how I can determine which TabPage is in present use when the Apply button on the outer PropertyPage is selected. So an editable cell in the TabPage is changed, an event changes the Dirty Flag on the PropertyPage to true and the Apply button is enabled. Now I want the PropertyPage to know which TabPage the cell was edited in, how can this be done I want to know the title of the TabPage. To answer your first question... within the apply button’s event handler... check the SelectedTab property of your TabC ...Show All

• Visual Studio 2008 (Pre-release) Use of OperationContext.Current for duplex

  Hello In all the samples of duplex the callback is set using OperationContext.Current inside a method called by the remote application. However, this approach requires the client to initiate a call a method on the service before the service can use the callback to send messages to the client. How can I enabled the service to send messages to the client using the callback after the client connects, but BEFORE the client sends anything The transport connection is made usually when you call a method on the proxy. You can change that somewhat by doing the following:     IClientChannel clientChan ...Show All

• SQL Server Query 2 tables - each in a different database

  Is there any query code that will allow joining tables that are in different databases running on the same server If yes, how is the connection to each handled That is no problem. SELECT a.Field, b.Field FROM dbo.myTable a JOIN OtherDatabase.dbo.myTable b ON a.myKey = b.myKey ...Show All

• SQL Server What's the easiest way to copy tables from one 2005 DB to another 2005 DB?

  I've tried creating a simple SSIS package but I get the error: [Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..". THis is a known bug and while we wait for SP1 to fix this error, is there another way to simply copy tables (with indexes and without having the identity column renumbered) Any help is appreciated! Scrip the source table and use this script to create the destination table. Then use the import-export ssis wizard and allow identity insert. (in the solution explorer, right-c ...Show All

• Visual C# Enum in class library

    I have an enum as constructor in one class library. I would like to give the user facility to add enum members at runtime. How can I add enum members at runtime. Please reply as soon as possible. Thanks in advance I saw the below code somewhere: Can anything be done with this code AppDomain domain = Thread .GetDomain(); AssemblyName name = new AssemblyName (); name.Name = " Enum Assembly"; AssemblyBuilder asmBuilder = domain.DefineDynamicAssembly( name, AssemblyBuilderAccess .Run); ModuleBuilder modBuilder = asmBuilder.DefineDynamicModule(" Enum Module"); Enum Builder enum Builder = modBuilder.Define Enum (" ...Show All

• Windows Forms is there any way to force a control to receive focus?

  i have a custom control inherited from panel and i need to be able to handle Enter/Leave events for it..any idears First off, yes, nested controls should raise Enter and Leave events all the way up the parent hierarchy.  If this isn't working for a given scenario, it is a bug. Secondly, in your drag scenario, you would want to h ...Show All