AlistairMacdonald's Q&A profile

• Visual Studio Express Editions Newbie question: DB Connectivity

  Hi, I'm comming from Delphi world, and learning from 0 the VB 2005 Express. Is it possible to connect this product with DBMSs like PostgreSQL or MySQL, using ODBC or JDBC Thank you, Guillermo Sure, shouldn't be any problem at all provided you have ODBC drivers for the desired connectivity installed and configured. Do a search in MSDN Help on ADO.NET... if you're interested mainly in ODBC, a sample Visual Basic ...Show All

• .NET Development enum question

  Hi. I am new to this and find it exciting but confusing at the same time. I have been told, from a great source, that enum is the best way to say, handle/manage error codes or let a method expect a type of Enum - it allows it to be more readable/managable and prevents any errors from occuring during development/testing. So you got to tie it down tightly, which I completly agree with.   The way I used to do things was, if a method r ...Show All

• SQL Server Calculated Member Formatting

  I'm running Panorama Novaview 4.5 against AS 2005 April CTP (Panorama doesn't work against June CTP yet, but I tested the MDX against June CTP and the same problem occurs).  In my cube, I have a Metrics dimension with several associated calculated members.  When I run a query where I'm not slicing or slicing by one member per attribute, the calculated members formatting works as expected.  However, when I run the query and slice b ...Show All

• Visual Studio Team System Unable to connect to TSF server

  Hello, I created 2 VCP. One server (tsf-server): 1. Windows 2003 std + sp1 2. Sql Server 2005 Ctp Apr 3. Sharepoint services v2 sp2 4. Teams Foundation server When I run on http://myserver.mydomain.local I open a sharepoint portal. On http://myserver.mydomain.local/reports I open the reporting services management console and http://myserver.mydomain.local/reportservices the report services. Then I installed the client: 1 Windows XP sp2 (the clie ...Show All

• Visual Studio Express Editions Why Is It Evil For Some To Use Data Bound Controls?

  Thanks Excellent Reply..... I've only been around Here since Nov/05... I take it if one holds these Evil Beliefs it's like the Guy down the Street that doesn't have a TV............Thanks ...Show All

• Windows Forms Printing Multiple Pages in C#

  Hi Gang! I am working with the code posted below to print the text from a textBox.  The amount of text in the textBox varies, and can be multiple pages.  When I click OK in the printDialog, the page count window begins climbing up&nbs ...Show All

• .NET Development RSACryptoServiceProvider & Bad Key Exception

  Hi, I'm hoping somebody can help me with this one. I encrypt a simple string with the RSACryptoServiceProvider, export the RSAParameters and then Serialize the exported RSAParameters, together with the encrypted string, to a file using a BinaryFormatter. Later I deserialize the whole lot, import the RSAParameters into a newly created RSACryptoServiceProvider, and try to decryp the string, but I keep on getting a 'Bad Key' exception. What am ...Show All

• Visual Studio Team System Changing transition rules, only reason to be changed

  Here is the scenario: Person A opens a new Bug (State: Active , Reason: New) and assigns to Person B(Bug Manager) and Saves Person B(Bug Manager) wants to reassign this to Person C. We want the State to be Active and Reason set to Reassigned (custom) Im unable to create a transition rule of Active to Active. Is there a way to do this I could only do it by creating another state Active2 with Reason of Reassigned. Thanks, Staf ...Show All

• SQL Server Stored procedure issues...

  Hi, I have a table set up in SQL Server Express with the following columns: PartNumber (PK, smallint, not null) PartName (nchar(50), not null) Status (nchar(10), not null) Price (decimal(8,2), not null) What I want to do is create a simple .Net form where the user types in a search key and the key is matched against the PartName field to provide matches. This was easily done in the .aspx file itself: SELECT * FROM dbo.PartsTemplate WHERE PartNam ...Show All

• Windows Forms copy file from CD

  i'm want to copy file from CD to HDD and my code works fine 1st time but when i try to copy the same file 2nd time it doesn't work because the file is "read only" so how can i fix it  my code   Try    &nb ...Show All

• Visual C++ how to read exe file

  Hi all I have a problem. i have situation where i need to send a complete C program made in .net 2003 to another pc using socket. Now rather than sending individual files CPP and .h files(since there can be more than 2 or 3 files), i deicded to make an exe file and then send exe file to other pc. Now i am able to create the exe file but i am not able to read it using c++ file handling. here is the code #include<iostream> #include<f ...Show All

• Visual Studio Team System Installing TFSB3R As Workgroup Then Adding To Domain

  Hi, I have tried everything to install b3r on a standard win2k3sp1 virtual server, but i keep getting the dreaded 28100 error loading event web service error. i followed the install instructions to the letter on a clean image and googled for every known possible cause for this error (blank passwords, permissions on windows\temp, adding all 3 accounts to local admin group etc etc) but it was no good so i gave up and tried something different ...Show All

• Visual C++ Can't get static data member imported from DLL

    I'm having trouble importing a static data member from a class in a dll.   I reduced the problem to a very simple example consisting of a DLL implemented in 2 files (lib.cpp and lib.h) that exports the class and the static data member, and a console application (main.cpp) that imports and tries to use it. They are listed below: // === lib.h =========================== class __declspec ( dllexport ) GeoTransform2 { p ...Show All

• .NET Development Select limited records from SQL Server

  hello all, I have a situation inwhich I have to pick up Top 3 records for each main category. But I have to also restrict that Only 20 records should return whether the record count is greater than 20. I have the following query where two tables are being used. Parent table is 'DirectoryMainCat' and child table is 'DirectoryLinks'. I have done picking up 3 records for each main category but if total records are more than 20(record count&nbs ...Show All

• Visual Studio Express Editions Graphics questions in VB

  Hi there, I'm planning to make a graphics program in Visual Basic. Although I used Visual Basic a long time ago, and have somewhat of a knowledge of programming, I am by no means expert (you might say barely past beginner) and have been more of an enthusiast in the past (my real job is design and animation). Recently, I downloaded VB Express and decided to take the plunge again. Before I start cramming all the information that is out there ...Show All