narukrish's Q&A profile

• Visual Studio Team System system.state

  Is it possible to customize system.state for a work item type to add state values (example, instead of just active -> resolved -> closed, I want to add two more states to make the following transaction: active -> triaged -> resolved -> verified -> closed) Also, how can I get a list of the supported state values Thanks, Maggie Yes, you can add any number of states with any names you like. For syntax, see "Defining Work Item Workflow" section in http://msdn2.microsoft.com/en-us/library/ms243849.aspx ...Show All

• SQL Server SQL parameter Syntax

  Guys, Wahts the right way to specify a parameter in an Execute SQL Task when the param is a varchar should I use apostrophe's around the or not I have two SQL tasks .. one where the query is specified like : WHERE FIA.BaseCurrency = Which SSIS likes and doesn't complain about...(the but then I have another query.. [below].. which SSIS complains about unless I have apostrophes around the So its like: AND FIA.BaseCurrency = ' ' So.. which should it be The problem for me here is that when I DO put the apostrophes around the I get no results back from the query... PJ The problem query: SELECT ForeignCurrency, RateFromFile AS YesterdaysRate --The ISNULL just protects us from situati ...Show All

• Visual C++ Loop not working

  when i run the program through the second time it just spazzes out and keeps outputting would you like to run it again here is my code note: task means homework assignment also for the program to work you need to create a file called todo.txt in the program file of the project folder thanks for the help #include <iostream> #include <fstream> using namespace std; //This program reads data into a file //Created by Wesley Neary int main() { char again; ofstream out; char task[50]; char due_date[50]; //sets variables char classnumber[50]; do{ out.open("todo.txt",ios::app); //open file if (!out) cout<<"error"<<endl; //check for opening error ...Show All

• SQL Server Reporting Services Migrating to 2005

  Is there a way to migrate over 900 of deployed reports (RDLs) from an old RS reporting server to new RS 2005 reporting server very quickly A migration tool or something. You can just point your new RS2005 install to use the old catalog (using the configuration tool), and it will update on the fly. ...Show All

• SQL Server XML Schema with imports

  I have a quite complex xml schema with 2-3 import statements. Each import has different targetnamespace. How is possible to enter this schema in SQL2005 using the CREATE XML SCHEMA COLLECTION and make sql validate the xml before inserting to the database Is it possible to overcome the xml import limitation that SQL2005 seems to have by modifying the xml schema So far my attempts were to use the Create XML SCHEMA COLLECTION for the first schema and the ALTER XML SCHEMA COLLECTION ADD for the rest that have import statements. However, the validation fails with an error message like the one below : XML Validation: Declaration not found for element 'MyFunds'. Location: /*:MyFunds[1] Thanks I'm not aware that SQL Server h ...Show All

• Software Development for Windows Vista While loop only executes once

  Hi I want to use the While activity in a workflow I'm developing, however I have the following problem. The the first time the while loop condition is evaluated it returns true so the contained activity should be executed (I have a code child activity that just writes to the console). However the code activity is not executed. The workflow is persisted and then nothing else happens. I've been looking at the WhileAndParallel sample program to see if I'm missing anything. This runs fine as supplied. However if I move the workflow into my host and execute it there, the same thing happens - the loop condition evaluates to true and then the child activity is not executed. Is there something obvious that I could be doing in my host t ...Show All

• Windows Forms Format columns in the .NET Winforms Datagrid

  Hello, I used a tableStyle to format my columns in my datagrid. DataGridTextBoxColumn dcFinalDate = new DataGridTextBoxColumn(); dcFinalDate.HeaderText = "Final date"; dcFinalDate.MappingName = "UGFNDT"; dcFinalDate.Width=100; dcFinalDate.NullText=""; dcFinalDate.Format="####/##/##"; tableStyle.GridColumnStyles.Add(dcFinalDate); It works good if there is a string entered, fe: 20060202, it will be 2006/02/02. But when there is no string (because the field is not required), then I'll get // .... How can I get rid of that Greets, Dirk protected override object GetColumnValueAtRow(CurrencyManager source, int rowNum) { DateTime ...Show All

• Software Development for Windows Vista Unable to find certain columns when searching

  I have a search example that looks like this: string connectionString = "Provider=Search.CollatorDSO;Extended Properties='Application=Windows';" ; OleDbConnection conn = new OleDbConnection (connectionString); string searchQuery = "SELECT \"System.Title\" " + ", \"System.DisplayName\" " + "FROM systemindex..scope() "; conn.Open(); OleDbCommand dbCommand = new OleDbCommand (searchQuery, conn); OleDbDataReader reader = dbCommand.ExecuteReader(); Unhandled Exception: System.Data.OleDb.OleDbException: Column does not exist. IErrorInfo.GetDescription failed with -2147221231(0x80040111). The problem is with the System.Display ...Show All

• Visual Studio 2008 (Pre-release) Where to Download XAMLPAD?

  Hi, I am looking for XAMLPAD, does anyone knows the link to download it The closest I could find is XamlPadX v2 at http://blogs.msdn.com/llobo/archive/2006/12/30/xamlpadx-v2.aspx Not sure if this is the correct one Thanks Ponnu xamlpadX is basically an extension of Xamlpad in response to customer requests. In effect its the same as xamlpad. ...Show All

• Visual C++ BUG: No files were found to look in.

  I keep getting this, so time to post it. I've just installed VS2005 SP2, and still see the problem. It doesn't happen that often, but I hit it every couple of weeks. The only solution that seems to work is a reboot of the machine. Today I had two instances of VS2005 running when I hit it. The way to fix this problem is actually amazing: just press Control + Scroll Lock and all is fixed! See the original post here: http://blogs.ugidotnet.org/franny/archive/2005/12/08/31303.aspx#32391 ...Show All

• SQL Server Limited Functionality on Side-by-Side Install

  We are testing our SQL 2000 db on a test box in which we loaded SQL 2000 first and then installed SQL Server 2005 Enterprise Trial edition side by side. I am trying to execute new functions in SQL 2005 against the Northwind db to test and these functions are not recognized. What am I missing Older sample databases like pubs, northwind are in 80 compatibility mode. So newer keywords or certain syntax of statements or functions behave differently in that compatibility mode. You can either change the compatibility mode of the northwind database by running "sp_dbcmptlevel 'Northwind', '90" or create a new database which will automatically be in 90 compat mode or use the new AdventureWorks sample database. For more details on ol ...Show All

• Smart Device Development Connection Manager Behaviour !!

  I was wondering, how exactly does the connection manager work. Let me describe a scenario. My application was using GPRS to connect to internet and do its business. Now the user enables WiFi and is connected to a WiFi network. so what will happen now. The connection that my app used was made with GPRS, and now that we have WiFi up, new connections will be made with WIFI and my old connection made using GRPS will also live, am i right or is this not the way connection manager will work regards When you request a connection you pass a Guid of the network to connect to - if this is the standard internet destination guid then both the GPRS and WiFi connections should provide a route to this network. Therefore if WiFi is actively connect ...Show All

• .NET Development ManagementException="not found" when creating a website with SecureBinding

  Hi, in this snippet, I'm trying to create a website. It works just fine if I take out the lines below in which I configure a SecureBinding (and of course changing the bindings array size). Only stack trace is: at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode) Ideas appreciated, thanks -ariel //Create the website using (ManagementObject w3svc = new ManagementObject(IIsScope, "IIsWebService='W3SVC'", new ObjectGetOptions())) { w3svc.Get(); ManagementObject[] bindings = new ManagementObject[2]; ManagementClass mc = new ManagementClass(IIsScope, "ServerBinding", new ObjectGetOptions()); bindings[0] = mc.CreateInstanc ...Show All

• Visual Studio Express Editions Data Grid Question

  This is from the help Private Sub ResetSource() DataGrid1.SetDataBinding(adoPubsAuthors, "Authors") End Sub I would like to set my Data Source to be based on the results of two combo boxes in my form. I guess my question is, can it be set on a query vice a table. SELECT * from Ply WHERE LN = '" & cmbL.Text & "' and TN = '" & cmbT.Text & "'" not quite, almost there. take a look at this on passing parameters (variables for example) from one form to the other. This is what you need to do if you are needing to access "ds" from the other form http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=700821&SiteID=1 http:// ...Show All

• Architecture story about architect designing sidewalks

  I hope this is not too annoying a question. I remember story (perhaps apocryphal) about an architect who had designed a building that had a grass courtyard. Having finished the building, the architect was asked by an associate where the sidewalks would be placed in the courtyard. The architect answered to wait a year, see where pathways were established by people who walked the courtyard, and use those pathways to guide the design of the sidewalks. If this is a real story, can anyone point me to the architect and the source of the story. Thank you in advance. >>>bill<<< Just a message bump. Still wondering if anyone knows the source of the story. Thanks. >>>bill<<< ...Show All