Noreykav's Q&A profile

• .NET Development How to retrieve info (messages) from the SQL Execution

  Hello. First, I hope I'm posting in the right forum. I'm developing av .NET application using ADO.NET. Everytime you execute SQL Queries the database returns information like "(1 row(s) affected)" etc, but I haven't found a way to get this info from the ADO.NET tools - eg. the SqlDataReader or OdbcDataReader. I need this information to get data returned by STATISTICS IO and STATISTICS TIME (ref http://www.vbcity.com/forums/topic.as ...Show All

• .NET Development How do I change the date format in a form? Havin a major nightmare!!!

  I have a DataTable with a column defined as a date type. The Data Table is not linked to a SQL database or MS Access but I read and write to it from text files.   This date column is databound into a Form as a Text Box.   The DataTable takes format   “Month DD, YYYY” e.g. "May 04, 2005"   This is displayed in the form as “DD/MM/YYYY HH(24):MI:SS” e.g. "04/05/2005, 00:00:00"   How do I chang ...Show All

• Visual Studio Team System CA1000 and Generic Singleton classes

  Hi everyone: I am developing a library that will provide persistence methods for business objects. The Persistence class is generic because it needs to know about the type of object it persists. (The type parameter to the class is the type of object to be persisted.) However, there is no need for the clients of the library to instantiate an instance of the Persistence class each time an object needs to be loaded or saved. So, I want to ...Show All

• SQL Server Escape character for /SET option of dtexec

  I have a problem setting some variables in a package using the /SET option of dtexec. Specifically when the value I want to set contains a semi-colon. I get an error like: Argument ""\Package.Variables[User::Delim].Properties[Value];^;"" for option "set" is not valid. I am guessing that I will have to escape the semi-colons somehow, but with what Regards, Lars You don't show the command but from the e ...Show All

• Visual Studio Team System Adding enhanced WIQL queries to "My Queries" in Team Explorer

  I am using Beta 3 refresh and the query builder for work item queries. However, the query builder is somewhat limited to field-by-field queries and does not provide me with enough structural control - like parenthesises and so on. What's nice, is that I am able to build WIQL queries myself - and the syntax itself supports parenthesises along with other control mechanisms - but I am not able to find a way to import the WIQL query back into Tea ...Show All

• .NET Development sql server 2005 express

  hello again, with the supplied sql server 2005 express from visual basic beta 2005 express can i; 1. make my newly created .mdf file have database password; 2. can i view my table contents like on access 3. i already have an access database i used as backend for my vb6 apps, can i convert my access dbf into sql server database thank you again sir thank you for your immediate response, im viewing your link r ...Show All

• Visual Studio Team System Problem with shelving

  I've encountered a small problem with shelving.   Here's a scenario I  Am working with studio 2003 and using TFS as source control . I have a console app project with 1 class (Class1) Lets say I add a new class (Class2) and then check in class2. Now ,I open the class for edit and do some code. I then do shelve to the entire project . after that I undo changes in order to get back to the last checked in version. T ...Show All

• Windows Forms Nox invasion

  Hi, I was just wondering what type of animal, and why the Nox 3.6 has totally invaded my ecosystem. Thanks  Well I am not sure about this, what I would really like to see is an advanced terrarium and a beginner terrarium. but& ...Show All

• SQL Server FTP Taks Fail

  Hi, sorry again, l've a package which call the FTP tasks. In design-time, it works fine. While l put it into SQLAgent to run in schedule. It fails. The package log file said, OnError,MAXIS-SYSOPT,NT AUTHORITY\SYSTEM,FTP Raw File Motorola,{b3b941f5-ebc2-4b38-b314-87ff4827c2a8},{E93D51C5-539E-4CEE-B616-BBCFF9FA813E},4/18/2006 3:18:23 PM,4/18/2006 3:18:23 PM,-1073573489,0x,Unable to connect to FTP server using "Metrica FTP". Does anyone ...Show All

• Audio and Video Development MF_ProtectedPlayback Sample doesn't work for Video on Vista Beta 2:

  1. Installed Vista Beta 2; 2. Installed Vista Beta 2 SDK; 3. Build MF_ProtectedPlayback Sample from provided samples; When starting both Release and/or Debug versions of MF_ProtectedPlayback Sample with both Adminitrative and not-Administrative priv. as well as with DRM and not-DRM Video content => getting complain in the form of 3 Message Boxes: "Windows -- Bad Image: X is either not designed to run on Windows or it contains ...Show All

• SQL Server Full Text Search of terms including asterisks

  I have a document containing the term *sosos Searching for this with different levels of wildcard placement results as follows: 1 CONTAINS ( [TargetField] , ' "*sosos"' ) results in 1 item 2 CONTAINS ( [TargetField] , ' "*sosos*"' ) results in 1 item 3 CONTAINS ( [TargetField] , ' "*soso*"' ) results in 1 item 4 CONTAINS ( [TargetField] , ' "*sos*"' ) results in 1 item 5 ...Show All

• Visual Studio Team System RandomSleep functionality in Web Test. How?

  Hi, I have a situation where I want the virtual users to sleep for a random amount of time.  Can I achieve this without using the WebTestRequest class, bcos in this situation there is no request at that point. Eg.  For a LoadTest (which has one web test), I set a constant load of 1000 users.  The first step all of them do is to login to the web site.  But I dont want all of them to log in at the same time.  So I want to ...Show All

• Visual Studio Team System Policy violations email

  How do I set up the email address(es) to which I send emails if there has been a source control check-in policy violation Thanks You can also look in the version control database and query it to find the policy violators...it can be quite a hoot what some people write as their excuse... ...Show All

• Visual Studio Different file types between Vss6 and Vss2005

  Hi, I'm currently evaluating Vss2005 client with some existing databases created with Vss6. I have detected a strange issue: a text file appears with Vss6 client as a text file (quite normal), whereas it appears as a binary file in Vss2005. In the same way a binary file appears in Vss6 as binary and has unicode8 in Vss2005 (please note that I have already tried to deactivate the automatic file file type recognition). It sounds like Vss6 an ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. winnt.h errors?

   I have just linked Direct X 9 to the new of Microsoft Visual Studio 2005 Beta 2. Trying to compile a program i know that works under Microsoft Visual C++ 6.0 gives me the following errors: c:\program files\microsoft visual studio 8\vc\platformsdk\include\winnt.h(222) : error C2146: syntax error : missing ';' before identifier 'PVOID64' c:\program files\microsoft visual studio 8\vc\platformsdk\include\winnt.h(222) : error ...Show All