Mike Wasson - MSFT's Q&A profile

• SQL Server how to connect sql server 2005 cube using visual studio 2005

  May i know how to connect sql server 2005 cube using visual studio 2005 May i have some examples and source code to solve this problem Thanks a lot. Please direct these types of questions to the SQL Server Analysis Server forum: http://forums.microsoft.com/msdn/ShowForum.aspx ForumID=83 ...Show All

• Visual Studio Team System Feature request - column datatypes visible in project

  Greetings, In the project tree view each column, in a table, is visible but the data type of that column is not displayed. It would be desirable for the data type to be either visible next to the column name (like SSMS and Query Analyzer) or alternatively displayed in the property grid for that object. -- Regards, Neale NOON Dear noonie, Thank you for your suggestion. I will relay it to the ...Show All

• Visual Studio Team System TFS on WS2003 complete configuration tutorial

  Hi I am a VS programmer that was interested in testing TFS. My problem is that I don't know how to configure windows server 2003 (i don't know how to CORRECTLY configure things like AD, DNS etc). I have virtual pc 2004 in my computer, so I created the WS2003 installation in a virtual pc but I really don't know how to proceed from then. Is there a tutorial or a guide to do all these things (configure AD, install SQL Server 2005, TFS, etc) Than ...Show All

• Microsoft ISV Community Center Forums Reading data dll into excel

  I have recompiled a Visual Foxpro table into a DLL using VFP9. It is registered and VFP reads the DLL correctly. The DLL is just a table with code that performs a lookup based on two values and returns a value for use. In Excel, the following code is in a module: Declare Function spec_Field_Value_Function Lib "spec_search" (cThisSize As String, cThisValue As String) Public Function spec(Shape As String, Property As String) As Variant ...Show All

• Visual C# How to store list using Settings Designer (in 2.0)?

  Using the Settings Designer I can easily store individual items (string, int, double, etc...), but how do I store a list of items.  I used the Browse... selection to set the Type to ArrayList, but I couldn't figure out how to set the default value.  So, in the constructor of my main form, I added the following code... Settings.Default.MyList = new ArrayList(); Settings.Default.MyList.Add( "abc"); Settings.Default.MyList. ...Show All

• SQL Server Tracking Changes

  I have been ask to create a trigger that tracks the addition of objects to all of our databases. I have a method to track the changes to the sysobjects table, however I have not been able to create the trigger on sysobjects table. Is there a way to do this in SQL 2000 Hi, Triggers on system tables are not allowed.  DML modifications to system tables like sysobjects is *strongly* discouraged and will not ...Show All

• Windows Forms c# getting crazy with a simple insert into....

  Hi all :) Here is my problem: myCommand = new SqlCommand("insert into myTable values("@field1")", myConnection); myParam = new SqlParameter(); myParam.ParameterName = "@field1"; myParam.Value = myTextBox1.Text; myCommand.ExecuteNonQuery();   Whatever i write in myTextBox1.Text, in database i obtain ever a "null". If i modify my insert like:"insert into myTable values('" + myTextBox1.Text + "')"; it work...but we know that it ...Show All

• Visual Studio Team System BetaExperience

  I'm trying to sighn up for the visuall studio beta 2 experiance, but when I submitted my detail, I recieved a confirmation email, when I verified and clicked next I got a page saying "We’re sorry, but we were unable to service your request. You may wish to choose from the links below for information about Microsoft products and services." any idea why this is, and how I can sighn up Can you let us know if you co ...Show All

• .NET Development Loading UserControl from code without @reference

  Hi, I would like to use LoadControl (in ASP.NET 2.0) to load a user control as described in http://msdn2.microsoft.com/library/c0az2h86(en-us,vs.80).aspx , without using the @Reference-directive. Is that possible and how This is because I'm working on a generic framework with a class that describes the flow, loads the usercontrols and sets their properties. So I don't want to use @reference-directives in my aspx-files. Please help! I' ...Show All

• Visual Studio Crystal Report Login Code

  Hello THere ... I have Crystal Reports in my Project .. I Use the Following code to Programmatically apply Login Security to the Reports.     Private Sub ApplySecurity( ByVal MyReport As Object )         Dim crtableLogoninfo As New TableLogOnInfo         Dim crConnectionInfo As New ConnectionInfo       ...Show All

• Windows Forms Autofit printed text

  I am printing a large amount of text from a textbox. I am using the DrawString method in a Rectangle so that it wordwraps the text. This all works great. I want to be able to autofit the txt on the page. In order to do this I would like to know when the DrawString is printing beyond the size of the Rectangle. If it is, I will reduce the font size and try again. Is there any way to determine this or is there a better way to do this   ...Show All

• Software Development for Windows Vista How to bring up Infopath form on a task of the workflow

  Hi, I want to know how to show an infopath form when a task is edited in a workflow. Please let me know what steps to follow to do the same. Regards, Ketaki Hi, You can get it in http://msdn2.microsoft.com/en-us/library/ms550782.aspx just go through the document.Its good. can anybody tell me how to populate a checkbox using Itemmetadata.xml ...Show All

• Windows Forms Error MS.vbe.interop verison 11.0.0 must be installed in the global assy cash(gac)

  What is this i can not find any info on this Error MS.vbe.interop verison 11.0.0 must be installed in the global assy cash(gac) A little more info might help, but it sounds like this: On your Dev machine you either have MS.vbe.interop in the GAC or in Application Files dialog, it is set to "Prerequisiste". So, ClickOnce is checking the GAC for that file on your installation machine and not f ...Show All

• Visual C# VS 2005 My things that I don’t like list…

  VS 2005 My things that I don’t like list… November 5, 2005 Updated by November 6, 2005   In my opinion VS 2005 is the best IDE ever; still I like to make some comments.   Like to share the following with everyone with the hope that I be clarified or corrected on the presented “My I don’t like list”… I will keep updating the list by adding, modifying or removing issues along the way.   Top thi ...Show All

• SQL Server How to optimize data import with huge volumes and joins across data sources not all SQL Server based?

  I need to periodically import a (HUGE) table of data from an external data source (not SQL Server) into SQL Server, with the following scenarios: Some of the records in the external data source may not exist in SQL. Some of the records in the external data source may have a different value at different imports, but this records are identified univocally by the same primary key in the external datasource and in SQL Server. Some of the records i ...Show All