My Vizai's Q&A profile

• Visual Studio Tools for Office Using VSTO Beta 2 - Excel template issues

  I am trying to use VSTO (from within Visual Studio 2005 Professional) for the first time and want to create an excel add-in. When I create the project (c# or VB) and choose excel template I don't get any excel specific documents added in. For example, there is no ThisWorkbook.cs nor is there a dialog box that allows me to choose "Create a new document" on project creation. I clearly am doing something wrong - any help would be much appreciated. Thanks, Kevin Correct, VSTO 2005 SE is an add-on to VS (or VSTO, or VSTS) and as such it only has new project types. It doesn't include anything that shipped as part of VSTO 2005 (e.g. document-level projects). Note that the Second Edition is ...Show All

• SQL Server Need help with indexes and query optimization.

  Here is the scenario: SQL Server 2005 I have a table with about 63 million records. This table is many a data warehouse. There are about 50,000 new records added every day (done via SSIS on a scheduled basis). Users query these results. I have several indexes setup on the table. If I execute the query: SELECT TOP 200 Field1, Field2, Field6 Field 15 FROM myTable I get almost instant results. If I use SELECT Field1, Field2, Field6 Field 15 FROM myTable --return all rows It takes several minutes (as expected). I have a stored procedure that creates a dynamic SQL statement based on input. I don't know what fields the user wants to work with, so I have to create the query on the fly. The creation part is fast. In add ...Show All

• SQL Server Issues passing Table Name as a parameter to a Stored Procedure

  Hi Friends, I use the stored procedure pr_Set_Min_Max_Ind to set some indicators in certain type of tables in my databases. CREATE Procedure [dbo].[ pr_Set_Min_Max_Ind ] ( @t SysName, @k1 SysName, @k2 SysName, @r1 SysName, @r2 SysName ) ................ ................ ... ... ... ................ End The procedure pr_Set_Min_Max_Ind takes five parameters ( @t, @k1, @k2, @r1, @r2 ) of which @t is the table name in which I want to set some indicators and the rest of the parameters (@k1, @k2, @r1, @r2 ) are column names in the table @t Say, I have this procedure stored in database A . Then to execute the procedure on table TestTable_A in database A , I write the statement as: exec pr_Set_Min_Max_Ind TestTable_ ...Show All

• Visual Studio 2008 (Pre-release) ADO.NET vNext : System.Data.DataRowView defined in two assembly

  If I try using a System.Data.DataRowView object in my code I get this error: Error 15 The type 'System.Data.DataRowView' exists in both 'c:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Reference\System.Data.CTP.dll' and 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.Data.dll' [...] I'm using the new ADO.NET vNext and the LINQ preview Thanks forn any idea or help Lorenzo Soncini Trento - Italy In addition, the documentation that comes with the CTP specifies that adding certain references or controls to your project will cause the reference to System.Data be added again. Remove it each time it is added. Such frustration is the norm for those of use living on the bleeding edge. Jim Wooley http://devauthority.com/ ...Show All

• Visual Studio Team System How do I get this product working?

  I am attempting to evaluate VSTS for use in our environment and have run into problems before I have begun. What I have so far: The VSTS server is installed and running Visual Studio enviroment has been installed from En_vs_2005_vsts_180_Trial.img I am going through the Introduction to VSTS Guide (Walk-Through Only).doc and heven't been able to get past the first step with Excel, How do I enable the "New List" button and the VSTS toolbar I am using Office 2003 SP2 and have just run through Windows Update applying all patches associated with Office. Any help would be extremely appreciated at this point. My two main areas of concern are project management and defect tracking, if anyone can point me to the ...Show All

• SQL Server SQL Server 2005 Installation Failure on Vista

  Help! I'm trying to install SQL Server 2005 on 32-bit Vista RTM. Have tried several editions (Developer, Standard, Enterprise). Have tried installing while logged in as domain user account in machine administrator group as well as built-in Administrator user. Running SETUP program with elevated privilges. Certain portions (Analysis services, Notification services) install correctly, but never the database engine. Always fails consistently with the same error reported. Machine has Visual Studio 2005 installed already, but NOT SQL Server 2005 Express Edition. Error logs reports are below ({computer name} is the name of my machine) UI error reported: TITLE: Microsoft SQL Server 2005 Setup ------------------------------ SQL Server Set ...Show All

• Visual Studio Team System Could not find part of the path ... DatabaseUnitTest.vstemplate

  I create a new SQL2005 project and then create a new test for a stored procedure. The new project with the test seems to create OK (I haven't run it yet) but I get the following error "Could not find part of the path C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\ItemTemplatesCache\CSharp\2057\DBUnitTest.zip\DatabaseUnitTest.vstemplate" I have a C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\ItemTemplatesCache\CSharp directory but the subdirectory within this is 1033 not 2057 - should I be concerned Sorry it's taken awhile to get back to this. Thanks, that's fixed the problem. One other thing, each time I create a unit test I get a dialog asking me if I trust the template, is there a way to say 'yes' permane ...Show All

• Visual Studio Tools for Office Infopath 2007 - Odd Problem with Decimal seperator

  Hello... I am currently having an odd problem with infopath 2007... Setup: 1. German Server Now I am creating a simple Form with a tablerepeater control. Inside the table I define 3 Fields (all fields are double)... and the footer contains a sum of the 3rd fields. When a user enters something into field1 it is multiplied by field 2 and stored in field 3... Now the odd thing that happens is the parsing of the data. The Values for Field1 & 2 are stored correctly, but the calculated field gets messed up. Inside the XML the 3rd field will be stored with a german decimal seperator(,), but the other 2 are stored with an english one (.). Infopath also complains that field 3 should contain a number, even though i ...Show All

• Visual C# Terminating a process using WMI

  Hi, I have been told that this is possible but I can't seem to find any sample code anywhere. Anyone know how to do this Thanks. pretty much how Sven posted, either doing it this way: Process[] theList = Process.GetProcesses(" machineName ") foreach(Process curProcess in theList) {    if (curProcess.ProcessName.Equals(" ProcessName "))    {       curProcess.Kill();    } }   or this way:   Process[] theList = Process.GetProcessesByName(" machineName ", "ProcessName " ) foreach(Process curProcess in theList) {    curProcess.Kill(); } ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Post-Processing Shaders and Layers?

  I want to create 2D sprite scenes in GSE the way you work with layers in Photoshop. This is an example of a scenario of what I would like to achieve: Say, I have 2 layers of background and 1 layer of foreground. The first background layer is a sky with a sun. I want to blur this layer with a PixelShader. The second background layer is trees. This layer I also want to blur, but not as much as the layer beneath it, for a Depth of Field effect. The foreground layer contains the grassy ground and the player sprite. On top of all layers I want to put a glow effect from the sun also with a PixelShader. The glow effect should use a Glow Alpha texture that will be "deformed" by the layers, if something is covering the sun those pixel in the Alpha ...Show All

• Visual C# Compare 2 Strings of Diff Length

  I am looking for the fastest comparison which will start from the left of one string, and return true if ALL the characters of the first string match the first x characters of the 2nd string where x is the length of the first string. For example: String s1 = "YI" ; String s2 = "YIPES" ; String s3 = "Y" ; s1 = s2 would return true s1 = s3 would return false This would be part of a larger loop, so I am looking for the fastest comparision method. Regex maybe Many thaks Mike Thomas ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Snake Game released

  I posted a link on my blog to a quick Snake game I whipped up to test out game services. Hopefully it'll be of use to someone. I'd like to finish it some time down the road. aka_Big_Wurm wrote: kind of easy without ending game on hitting walls Agreed, but it wasn't meant to be a challenging game (at least not in its current version ). ...Show All

• SQL Server clustering and db mirroring

  Hi I know there was a previous thread on setting up DB Mirroring and Clustering where DB Mirroring would failover first because its faster than clustering. But is there a way to set up servers to allow clustering to failover first and then use DB Mirroring failover if the cluster node fails. thanks P Not with HA operating mode. Any cluster failover will cause a failover of Database Mirroring if you have high Availability operating mode configured. You can accomplish this with High Performance or High Protection operating mode, but then the failover is manual. ...Show All

• Windows Networking Development Vista RTM can't open new socket.

  Started here . Due to (stupid) limitation in TCP/IP driver (10 half-open connection) sometimes Vista loosing ability to access an internet (open new socket for communication). It happens when user uses P2P applications (BitTorrent, eMule). But in could be caused even by too busy IIS. BUT all existing internet-connected programs (WLM, Skype) are running. PC even is accessible via RDP. No any entries in EventLog relating to any problem with sockets. "Event 4226" appears in absolutely different time, not in time when connection was blocked. Only reboot or (sometimes) "Network Connections" (and ICS) service restart can help to revive network back to live. This problem is accepted by many people (see post on Channel9). Any settings in registry ...Show All

• SQL Server Editing in Querry Analyzer not in EM

  Hello, In SQL if we want to edit a row in a table then we have two ways to do the same, 1. Execute a command to Update the records in sql through querry analyzer. 2. Go to enterprise manager and then open the table and update a new row. But can't we do the editing in the querry analyzer is there any way to do this. That means i select all the records from my table using the following querry. Select * from MyTable and then performs editing in the querry analyzer without executing any update command and without using the Enterprise manager. Can we do this Bye and TC Yes. You can do this. In the Query Analyzer, expand the Object Browser (left side pane of your QA window) upto your desired table. ...Show All