arcoant's Q&A profile

• SQL Server Update Datetime

  Question How can one update a DateTime field when the change request may alter any of the attributes of the time (Day | hour | hour & minute). WHY Of course the whole point of a timestamp is to stamp the time of the record. The problem comes in when the user wants to tweak that timestamp. I am not interested changing anything about the time at the seconds point. The user will only change major time factors. Platform .Net 1x C# SQL Server 2000 Eventually this will be in a Stored Procedure. advTHANKSance Just string concatenate the pieces of the date back together and pass it on to the stored proc as a datetime by Convert.ToDateTime(stringvalue). I assume there are textboxes for each piece of the datetime in the UI (e.g ...Show All

• Software Development for Windows Vista Appverifier and VB6

  Hello, we are currenty in the certification process for the "Certified for Windows Vista" Logo Program. One Test Case is: "Verify application does not break into debugger with the specified AppVerifier checks". We discovered that the Debugger (WinDbg 6.6.0007.5) stopps when a VB6 application uses the "On Error Resume Next" Exceptionhandling (I know that this is not good coding, but it is valid). At runtime, the exception is handled by the VB6 Runtime and everything is OK. When using the debugger, it reports an error at the exception handling of the application. Sample: Private Sub ExceptionTest() Dim myRecordset As ADODB.Recordset On Error Resume Next myRecordset.Close ' Debugger breaks here! ...Show All

• Windows Forms Autocomplete combobox

  Hi, I am using autocomplete combobox of MTGC. My problem that when I press keys it fire selected event becouse the text is same as one of items in combobox. I don't need this event for keys except of Enter and Tab. This event is same as mouse selection event and it couse to my function to do that I don't want. So: 1) How can I catch mouse click in dropdownlist in combobox 2) How can I set that when it match the item by key it doesn't fire event of selected Thank's Alexei Do you need the autocomplete function or do you want to disable it Do you maybe want the combobox to autocomplete only when the user hits enter/tab ...Show All

• Gadgets Simple lookup gadget?

  Hi All, I've got a concept which I'd love to turn into a gadget by have very little coding experience and as such find myself a bit lost... The purpose would be to put a postcode into an input box, take the first 2 characters of the postcode and from those identify from a table of data which sales rep looks after that particular postcode region. My current solution, to make it a bit more real, is a simple excel sheet with a vlookup function - simple but effective! Could anyone point me to a tutorial which might take care of this type of thing, or even have a bash at something basic for me in exchange for a warm fuzzy feeling ;) Thanks Dave ...Show All

• Visual Studio Team System TFS compatibility with Surround SCM in raising post check-in event

  Hi There, Can somebody please let me know if there's any compatibility issues between the Team Foundation server and the 3rd party version control systems I'm finding the following error when i try to get an CheckinEvent notification (through BisSubscribe utility) from the SurroundSCM version control system. The error displayed when assigned the version control system to "Surround SCM" from Tools -> options -> Source Control -> Plug-In Selection (Current Source Contol Plug-In) "There was a failure while initializing the Surround SCM source control provider. You cannot use this provider to perform source control operations." My objective here is to trap the check-in event ...Show All

• Visual Studio 2008 (Pre-release) Loading SamlAssertion from Xml

  I am working on a scenario where I need to load in a SamlAssertion object from an Xml stream. I have written the following code to achieve this. XmlReader reader = XmlReader .Create(file); List < SecurityToken > tokens = new List < SecurityToken >(); tokens.Add(FindX509SecurityToken( "Saml Authority" , StoreName .TrustedPeople, StoreLocation .LocalMachine)); tokens.Add(FindX509SecurityToken( "John Smith" , StoreName .TrustedPeople, StoreLocation .LocalMachine)); SecurityTokenResolver outOfBandTokenResolver = SecurityTokenResolver .CreateDefaultSecurityTokenResolver( new ReadOnlyCollection < SecurityToken >(tokens), false ); SamlSerializer saml = new SamlSerial ...Show All

• Windows Forms Using addingnew with bindingsource

  I have a table with an autoincrement field as primary key and a few other fields. I have successfully created data binding it works fine. I s possible to have a value filled in one of the fields whenever i click the plus(+) button on the toolstrip of the binding navigator. The field which i want to fill is not the primary key field. I tried using addingnew event of the binding source but its now working well. Thank you. Actually I found my answer. I used the code below and its working successfully. But i donot know hw to cancel the operation if the user click the No button of the message box Private Sub AppMasterBindingSource_AddingNew( ByVal sender As Object , ByVal e As System.ComponentModel.AddingNe ...Show All

• .NET Development Login Function

  I'm looking at creating a login function for my application that decides what level of access you get to the application. The input will be the staff no and password, which are saved in the database under the same table. I also need to get the access level from the same table. How do i go about doing this Thanks for any help in advance Hi, First of all, you should never concatenate sql commands like you did above for security reasons (sql injection) Second, If TextBox2.Text = objRead.GetValue(1) & objRead.GetValue(2) = 1 Then should probably be If TextBox2.Text = objRead.GetValue(1) andAlso objRead.GetValue(2) = 1 Then The error you get is because you do not call the Rea ...Show All

• Visual Studio Team System How to add web tests ?

  I installed Team system for SW Developers. I cannot seem to find a way to add Web tests. The documentation says that there should be a menu item for adding web test ... The problem is I dont see a menu item like that. has any one experience similar issues. You don't have this functionality in the Sofware Developer Edition. Your edition includes: unit tests with code coverage support, statical code analysis and a code profiler. The web test you're looking for is available in the Tester Edition, which lets you record a test using your browser, define additional rules (for example - validate against the response time) and in case you need a finer level of control - generate sources for the recorded test. The Tester Edition also ...Show All

• SharePoint Products and Technologies where to store a unique ID?

  Hello,   I want to store a unique ID to use in a webpart. In a aspx page I would do it with a database field and a stored procedure, but with webparts i don't know. I want to give all my documents a unique ID, but not use the ID from sharepoint itself. Thank you. So it is possible then to connect to the database and put the unique ID there in my webpart Thx. ...Show All

• Visual C++ Help: C2679: binary '=' : no operator found which takes .......About CAutoPtr

  class definition: class CFGManager  : public CUnknown  , public IGraphBuilder2  , public IGraphBuilderDeadEnd  , public CCritSec { public:  struct path_t {CLSID clsid; CString filter, pin;};  class CStreamPath : public CAtlList<path_t>  {  public:   void Append(IBaseFilter* pBF, IPin* pPin);   bool Compare(const CStreamPath& path);  };  class CStreamDeadEnd : public CStreamPath  {  public:   CAtlList<CMediaType> mts;  }; //more... }   When I use CAutoPtr<CStreamDeadEnd> psde(new CStreamDeadEnd()); in my code, I got c:\Program Files\Microsoft Visual Studio .NET 2003\Vc7\atlmfc\include\atlcoll.h(101) ...Show All

• SQL Server Prompt page in SSRS

  Hi, I checked in SQL Server Reporting Services and it has the option to create only the reports. How do I create any prompt page from SSRS Is it possible to do it Thank You. Regards, Das. What do you mean by prompt page Asking for some parameters before rendering the report That can be done by clicking in the background of the report and navigating through report parameters. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 3D Playing Cards ?

  How would I approach a 3D representation of a playing card(s) If using a model, would 52 different models be required so that each card has it's own texture Can user primitives (i.e. 2 triangles to make a card shape) have different textures on each side What would be the best method for this hmm well I am by no means an expert and I could only direct you to some of the shader books I have, which will not immediately help you. ...Show All

• Software Development for Windows Vista Workflow sample compilation

  I've downloaded Win SDK for Wista, and try to compile a sample Workflow project. I get messages that "an assembly is missing" and so on. Why I can't compile it I've succeded in installing full redist package found at: X86: http://download.microsoft.com/download/1/D/A/1DA1A5D6-4DF6-45AA-9C2F-E87EFF6F6F78/dotnetfx3.exe ...Show All

• Software Development for Windows Vista SequenceActivity inheritance

  Hi! I have a few custom activities which all inherit from my base class which inherits from sequenceactivity. Is is possible to use the designer in both my base class and the other custom activities Specificaly, I would like to add a ifelse to my base class which should be run after the flows that inherit from this base class have completed. Is this possible Thanks for your help! Thanks for your help, Tom and Elif, I'll look into the custom designers and see what happens. ...Show All