Tania-chan's Q&A profile

• Architecture Creating DataBase

  I am re-writing a single-user, local application that supports MS-Access to a multiple concurrent user application that will support MS-Access, SQL Server, Oracle, DB2, and XML. In the current application, a Microsoft Access Database (*.mdb) file (with structure but no data) is distributed with the application. When the user wants a new database, the distributed file is copied. With a move to SQL Server, etc. most users will likely not have the ability to create databases on the fly (I assume most companies keep that in the hands of IT). What is the best or at least accepted method of distributing the database structure with an application Let me get this straight. You're going to build an application that will support multi-us ...Show All

• Visual Studio Team System running unit tests causing build to fail

  so i've looked at this for a while now, and i'm stumped. I am trying to run a set of unit tests as a part of my nightly build. When the build runs, everything works great until it gets to the point of running the tests. Then it fails, seemingly without explanation. The relevant portion of the build log looks as follows. Target RunTestWithConfiguration: TestToolsTask MetadataFile="c:\TeamBuilds\TruAssets\TruAssets Nightly Build v2\BuildType\..\Sources\TruAssets Solution\TruAssets Solution.vsmdi" TestLists="Unit Tests/Domain Unit Tests" SearchPathRoot="c:\TeamBuilds\TruAssets\TruAssets Nightly Build v2\BuildType\..\Sources\..\Binaries\Mixed Platforms\Debug\" PathToResultsFilesRoot="c:\T ...Show All

• Windows Forms How to kill horizontal scrollbar of treeview control.

  Now, I have treeview with Scrollbar properties is true, it mean that I will have two scroll (vertical scrollbar and horizontal scrollbar) . So, I don't want to use horizontal scrollbar, I want to kill this scroll. Please give some idea or solution for this problem. Many thank, You can get this by turning on the TVS_NOHSCROLL window style on the treeview control. Add a new class to your project and paste this code: using System; using System.Windows.Forms; public class NoHScrollTree : TreeView { protected override CreateParams CreateParams { get { CreateParams cp = base.CreateParams; cp.Style |= 0x8000; // TVS_NOHSCROLL return cp; } } } Build your project. You can now drop a NoHScrollTree from the top of your to ...Show All

• Software Development for Windows Vista SHGetSetFolderCustomSettings

  I'm using the shell32 SHGetSetFolderCustomSettings function in one of my apps in order to change a folder's icon. Vista 5728 returns NULL when I call GetProcAddress . I know that this function is not guarantee to maintain in Windows versions other than XP SP2 and 2003 Server (although only the online version of Library warns it :( How can I change a folder's icon in Vista TIA Jesus Guinda ...Show All

• Visual Studio Express Editions Make Your Software Expire WITHOUT the Shareware Starter Kit

  Does anybody have some kind of code example to make the software expire after a certain amount of time and then have the user enter a registration code I have tried the Shareware Started Kit with no success. Does anybody else have another solution or option I would greatly appreciate it. Thanks. That sound good, but can't the user just change the creation date of the exe by installing to other directory and then copy the newly created file to his first directory Grtz, Tom. ...Show All

• Visual Basic Free S.O. for VB2005 ?

  Hello. A question please. Is there a free S.O to run VB2005 For example linux... Thanks... NetPochi wrote: Hi spotty. You are right, but the most popular OS with SP2 is not free. Hi, You can get Windows free if you become a student through the MSDNAA (AcademicAlliance) programme though, I've even got Vista Business Edition , thanks to our favourite sponsor, MICROSOFT. Thanks Bill!! Regards, S_DS ...Show All

• Visual C# How to catch the exception of duplicate values appearing in a file?

  Say, there are a number of username entires in a file. While reading the entires (line by line), exception is expected if duplicate names appear. How to catch that exception In the command line, a friendly error message should indicate this duplicate error Thanks! My first thought is to have a List<string> object. When you read in a line, check .Contains(). If the list already contains the string, throw an exception. If the string doesn't already exist, add it. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Content Builder - Build you content without Game Studio!

  I've made simple framework and app to build content without Game Studio, find it here . Thanks to Shawn about hint how to do it and thanks RSDN Magazine about great article about how MSBuild works. wow, great work. This is exactly what I need. A friend of me wants to help with creating some assets (anims/models) for my little game, but he shouldn't have to install GSE, get my whole source project, and build everything by hand each time just to do some testing/evaluating. If I understand correctly I can either have him use your XCB GUI, or with a bit of effor I can even create a standalone, easy to use, tool myself using your XCB framework. That's really cool, and flexible. Good job :) ...Show All

• SQL Server Median function in T-SQL for SS2005?

  Hello! I have been trying to find a T-SQL function that would calculates a Median statistical value for me. I am runnnig on SS 2005 Any examples of using this function would be greatly appreciated. Thanks for any responses! Itzik's solution for 2005: SELECT (( SELECT MAX(col1) FROM (SELECT TOP(50) PERCENT col1 FROM Table1 ORDER BY col1) as m1) + (SELECT MIN(col1) FROM Table1 ORDER BY col1 DESC) AS m2))/2. AS yourMedian ...Show All

• Visual C++ Newbie getting C2352 error

  I get this error, error C2352: 'System::IO::DirectoryInfo::GetFileSystemInfos' : illegal call of non-static member function, when I try to compile this line: array <FileSystemInfo^> ^fi = DirectoryInfo::GetFileSystemInfos( "*.txt" ); GetFileSystemInfo returns a handle to an array of filesysteminfo objects. I think I'm defining fi as a handle to an array of these objects. Any help is appreciated! Johnny Did you try to look up in MSDN for that error Here is a sample from MSDN about there error: // C2352b.cpp class MyClass { public: void MyFunc() {} static void MyFunc2() {} }; int main() { MyClass::MyFunc(); // C2352 MyClass::MyFunc2(); // OK } Should help you understand th ...Show All

• SQL Server Embedded 2000 Package Question/Issue

  Hi All, I am facing with a very intersting question here. I have an embedded DTS 2000 package inside my SSIS 2005 Package. This DTS 2000 package just execute a transfer from a DB2 server to the 2005 server. Its a very simple transfer, without any transformation ( just column to column ). Well, when I edit the DTS 2000 and save it, the package size increases about 100/200kb. It sounds like the package version ( the same as we have in the 2000 environment ). But i dont know how deactivate this "auto-increase". Anyone can help me with this auto-increase or just explain me what is happening Today I have packages with 9mb and just 3 or 4 embedded DTS 2000 packages inside. Thanks in advance. Thiago DTS 2000 keeps every ...Show All

• Windows Forms Passing CustomActionData as arguments to Custom Action MFC Exe

  Hi, I want to achieve silent setup from command line. I have created a MSI installer with MFC custom action exe. Now I want to pass command line arguments to this exe from my MSI installer. I have added two internal Properties from following command. msiexec /i setup.msi /qn /l* out.txt Everyone=2 License="xxxxxxxxxxxxxxxxxxxx" I can use these properties in CustomActionData property of my custom action exe. But how can I use them as arguments In .Net framework, we can use "InstallContext Class". But my exe is MFC based. I am poised whether I need to use C# custom action exe or there is way to pass command line arguments to MFC exe as well. Thanks in advance for your help. ...Show All

• SQL Server Getting SQL result in a variable

  Hi there I have a global variable say cnt in SSIS package, now I want to get total number of rows from a table say emp in that variable cnt. how do we achieve that thanks and regards Rahul Kuamr Hello, found this post and am hoping that you can help with assigning a variable with an Execute SQL Task. My task runs, but the variable doesn't get a value, stays blank. I'm trying to retrieve a string value from a SQL table called tblSys_Config. There's only one row in the table. The column I want is called is an nvarchar(3) field called Config_Code. I've defined a user variable called TestVar with type as string. I've set up my Execute SQL Task with a SingleRow result set, and the SQL ...Show All

• Visual Basic Printing many different reports (what would you do)

  Hi If have a lot of different reports to print in my application, how would you do this best My first solution would be something like: dim report as integer ... ... print1_printpage(....) if report= 1 then for.. next e.draw and so on.. exit sub end if if report = 2 then .... But this is a bit anoying when you have more than one page i think. Otherwise i could put another printpage dialog on the form (one for each report) Or are there any better solutions Are there any way og calling another sub in the printpage event and be able to draw on the page from this sub Personally I would use a reporting component such as Crystal Reports and simply do my report ...Show All

• Visual Studio 2008 (Pre-release) Adding Web Reference in VS 2005 to WCF Service

  Hello, As I’ve found out yesterday, it’s important to create a proxy class for ‘WCF web service’ using svcutil.exe even though it uses 'basicHttpBinding'. If one does it through VS2005's 'add web service' routine, the created proxy allows passing string fields only. All value types doesn't go through. I mean the proxy class looks correct with all fields having correct types. But when I attach the debugger to the WS I see default values only for types like int, short, DateTime etc. Am I doing something wrong nefis i've just noticed that the 'add web reference' routine creates the proxy class with additional set of properties with same names as mine with 'Specified' suffix added. All t ...Show All