helsingfors's Q&A profile

• Visual Studio Team System Design and Documentation

  Hi again, Currently, we first always design any db-changes in Visio EA and only after the changes are approved, they are incorporated into the schema. We document all fields and tables within Visio. Unfortunately this documentation is not being transferred to SQL in the correct way for other documentation software like innovasys document-x) to pick it up. It seems also this DB project has no support for documenting the schema, nor for creating/maintaining DB diagrams for design and overview. You gave us a bunch of tools for messing around with databases, but Visio is definitely not integrated and DB project does not seem to care much for documentation either ! What's your recommended way of designing (before schema changes) ...Show All

• Visual Basic Spilt

  Hi suddenly i can't find out how to get the last caracters from a string if my string contains "/" like : string = vewc/user and i just want to get user hope someone can help Alvin Hi, you can try retrieving the last part of the string with the following code: Dim myString As String = "vewc/user" Dim lastPart As String = myString.Substring(myString.LastIndexOf( "/" ) + 1) If the string contains more parts you'd like to retrieve, look at string's Split() method. Andrej ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. C# and Managed DirectSound reading samples from mic and writing samples to speakers

  My apologies, I've seen many references to this on the web. However, I have not been able to find complete enough documentation to make it work. I would like to read raw samples from the microphone, e.g. 16-bit PCM samples. I would like to be able to read them into a byte[] buffer or short[] buffer or something like that. I would also like to be able to take a byte[] or short[] buffer of PCM samples and write them to the speakers. I'd like to be able to do this using DirectSound under C# if possible but if I need to use some API under C# that wraps some underlying dll functions, thats ok too. I just need documentation or better yet, a well documented, COMPLETE example on how its done. Oh, and one last thing, I'd like to be able to do this ...Show All

• Visual Studio Team System Data Quality testing.

  I have a database project that has a handful of sql scripts written to find data quality errors in our system. Is there a way to automate the execution of these queries from a test project using unit tests that reference the .sql files in the database project Hi cwest, You should check out the new VSTS client for Database Professionals. It uses the same test infrastructure that you get in Team Test, but they've added on functionality specifically for database work. There is a community technology preview (CTP) download available for trial. You can find more info about it here: http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/default.aspx . Cheers, David ...Show All

• .NET Development Connecting to SQL Database using Enterprise Library's Data Access block

  Hello, I am creating a windows forms application in C# and I'm trying to connect to my SQL database using Enterprise Library's Data Access application block using the following code (btw, I'm sort of new to these forums and wasn't sure if there's specific way to mark code in a post, so i just changed the font and color): ConnectionStringSettings s = ConfigurationManager.ConnectionStrings["myConnString"]; Database DB = DatabaseFactory.CreateDatabase(s.ConnectionString); So I've created an App.config file defining my connection string, as seen below: < xml version="1.0" encoding="utf-8" > <configuration> <configSections> <section name="dataConfiguration" type="Mic ...Show All

• .NET Development StringBuilder COM marshaling across COM apartments

  I have the following interesting problem: I am using COM interop to work with an SDK, where one of the methods I call has the following signature: HRESULT GetName([out][in] WCHAR *pName, [out][in]DWORD *pcchName); The way it works is that the client first passes a NULL as pName and gets the number of characters in the name as the second out parameter (pcchName). Afterwards, the client can allocate the required memory and pass in the array and the capacity. I am using this method from C# and I have the method signature as follows: [MethodImpl(MethodImplOptions.InternalCall, MethodCodeType = MethodCodeType.Runtime)] public virtual extern void GetName([Out, MarshalAs(UnmanagedType.LPWStr)] StringBuilder name, ref int nameCapa ...Show All

• Visual Studio 2008 (Pre-release) Getting XAML parser output to develop a XAML viewer

  Hi, I am trying to find a utility converting a XAML file to c# code, which could then be re-used to implement an "advanced" XAML viewer (essentialy implementing a zoom function which is not curently available in IE or Xaml Pad). So here are my questions: - Does such a viewer already exist - If not, how can I use the XAML parser to read a XAML file and convert it in objects in my c# viewer project Thank you, David That blog entry discusses how you can bind to XAML embedded inside of a regular XML document.  The sample XML uses the arbitrary <Graphics> and <Graphic> tags just to contain the XAML.  If you want IE to load a XAML document, it cannot be embedded within non-X ...Show All

• Visual Studio Tools for Office How to add caspol security settings for referenced assemblies

  I'm building an Outlook add-in using VSTO 2005 targeted at Outlook 2003. I've successfully added the SetSecurity project (from the MSDN "Deploying VS2005 Tools for Office Solutions Using Windows Installer" 2 part series) to my solution, which appears to properly configure security for my primary dll when my add in is deployed to another machine using my setup project. However, the SetSecurity project sample doesn't appear to set up permissions for the com objects referenced in my add-in and my add-in throws an error when I run it. Specifically, my add-in uses the CDO and web browser com objects, so I'm guessing I also need to add Caspol calls for the Interop.MAPI.dll and the Interop.SHDocVw.dll to my setup project What's ...Show All

• SQL Server OLE DB provider "MSOLAP" linked svr "Errors in the back-end database data provider does not support support preparing queries

  Is it that I have a syntax error in the nested OPENQUERY or is there another issue Do I need to specify a different provider in the Server Link such as OLEDB Non-nested OPENQUERYs work fine. I'm generally following theTips and Tricks article. "Executing predictions from the SQL Server relational engine". One problem is the sample doesn't actually complete the example query after the second nested OPENQUERY call. e.g.    SELECT * FROM OPENQUERY ( DMServer , 'select … FROM Modell PREDICTION JOIN OPENQUERY …' ) The SQL Server server link's provider is configured to allow adhoc access. I appears that the inner OPENQUERY cannot be prepared by Analysis Server or the Server link provider but I need to return a ke ...Show All

• .NET Development DbConnectionScope... HELP!

  Hi! I've been trying to use the DbConnectionScope class provided by Alazel Acheson [http://blogs.msdn.com/dataaccess/archive/2006/02/14/532026.aspx] in .NET 1.1, but I'm having some problems.. To the class works in 1.1, I've had to change the Dictionary objects by Hashtables and change DbConnection objects by IDbConnection ones.. Ok, it's work great at compile-time, but at run-time, the DbConnectionScope.Current has <undefined value>.. I cannot test it on 2.0 'cause I don't have it! My question is: Is changing the Dictionaries by Hashtables my problem This is the structure of my application: Web Project Base/DAL Class Library Business Class Library In Business CL, I have methods that call DAL methods.. Example: void SomeMethod() { E ...Show All

• Software Development for Windows Vista Help me!

  I am install the Windows XP SP2 clean.And then install dotNetFramework 3.0 successfully. I can display the xps document with IE. But After I install some software such as Office System 2003,Symantec AntiVirus 10.0.1.1001,Lotus Notes 6.5,Lotus 1-2-3 Office,Visual Studio 6.0,Eclipse 3.2.1, I cann't display the xps document with IE.There are some errors as follow: ID: 10010 Source: DCOM Component: System Event Log Message: The server {7DDA204B-2097-47C9-8323-C40BB840AE44} did not register with DCOM within the required timeout. The same as xaml document and xaml browers applications: ID: 10010 Source: DCOM Component: System Event Log Message: The server {CF1BF3B6-7ADD-4410-996B-C78EAFCD3269} did not register with DCOM within the re ...Show All

• .NET Development "The remote server returned an error: (409) Conflict."

  I am getting "The remote server returned an error: (409) Conflict." error when trying to call HttpWebResponse response = (HttpWebResponse)request.GetResponse(); . Am using this to upload a document to a SPS document library. I have more than one document libraries, but everything is working fine accept one libraty. I would really appreciate if some one help me with a solution for this issue. Code below: public void Upload(Uri destUri, Stream sourceStream, long contentLength) { try { // Put request HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(destUri.AbsoluteUri); request.Credentials = this.TargetCredentials; //CredentialCache.DefaultCredentials; request.Headers.Add("Translate",& ...Show All

• Windows Forms TabControl problem

  I have a form with a tabcontrol(with 2 tabpages) and I add a new TabControl at runtime using this->Controls->Add(gcnew TabControl()); Its been created at top left corner of windows and not visible fully..how to control its location/size etc how to access it Thanx in advance sorry it's a typo, it should have been: TabControl myTabControl = new TabControl(); you can do as many instantiation of controls at runtime like for(int i = 0; i < MaxCount; i++) { TabControl myTabControl = new TabControl(); myTabControl.Size = new Size(100, 100); this.Controls.Add(myTabControl); } btw: are you sure you need TabControls and not TabPages for yout TabControl ...Show All

• Visual Studio Team System Missing references..

  Good afternoon, I have a .sln with three projects, two are C# and one is VB. I have migrated the code from VSS and converted from .NET 1.1 & VS2003 to .NET 2.0 & VS2005 with Team Foundation. I open the .sln and all three projects seem to load without issue, however my references for the VB project are missing and I'm unable to add them. Has anyone run into this issue and found a resolution Thank you! Mario, Thank you for the tip! I will try adding the references in the project file using Notepad. I will provide updates as progress is made. Thanks again, Peter ...Show All

• .NET Development Installing Windows App 2005 on Windows 98

  Does .Net Win Apps installs on Windows 98 Is there any compatabilility issues Urgent Thanks in advance You can install the .NET Framework 1.0, 1.1 and/or 2.0 on Windows 98, and once you install that, you should be able to install and run .NET applications as well. Thanks! Aaron ...Show All