Shyam Manohar's Q&A profile

• Visual Studio Team System Work Item Fields Max Length

  Hi guys, Anybody can tell me what is maximal length for each Work Item Field Type (String, PlainText, HTML) We are migrating items from Clear Quest to TS and receiving "Invalid To Long" errors when trying to save WI. Thanks, Leon What's max length for help Text Is there a way I can increase it. I'm getting the following error, while importing the bug form.. Exception Type: System.Xml.Schema.XmlSchemaValidationException Exception Messa ...Show All

• SQL Server How to do this ?

  I want to do a win app or web app that has many reports, I do not want to use CR Service, I want to try SQL Server 2005 Reports, please is anyone who can tell me how to do this, or can send me any link telling me anything in this directon I really appreciate your help ! Sincerely The first place to start is the Microsoft site. http://www.microsoft.com/sql/technologies/reporting/default.mspx ...Show All

• SQL Server Database with empty name

  I somehow managed to get a database object with an empty name into one of my instances of SQL Server. I can't delete it or otherwise work with it (I've tried renaming it so I could delete it) without getting an error message because of the empty name. I've tried these things (as well as a "Drop Database" query with no name, which I didn't expect to work and it didn't) from both the SQL 2000 and 2005 environments. Has anyone come across ...Show All

• Visual C# Cast generic to derived type

  Hi, I'm hoping someone could help solve this problem I've run into. I'm trying to cast a GenericCollection<Car> to a derived class which is essentially the same thing. The compiler seems happy, but I get a runtime error saying that its not possible, but it doesn't make sense. Surely CarCollection would have all the methods/properties/structures that its parent has I've cut down the code to make it as basic as possible. To run it, ...Show All

• SQL Server Cannot delete Sequence Container -- details

  I have a Sequence Container with an Exec SQL Task in it. I can't delete the task or the container. I can't disable them. Here's how I got there: I put a Dataflow Task and the Exec SQL Task in the container, then set a precedence constraint. Lots of complaints moving either of them. Managed to delete the Dataflow Task, but now can't do anything. Any dieas Laurence Collection cannot be null. Param ...Show All

• .NET Development FTP usage

  Hi. Using .NET 2.0 and its the first time im using the FTP protocol in development. I am trying to issue a few commands, firstly it works fine such as listing a directory however if i wish to disconnect from the server using, lets say "QUIT" or perhaps I wish to upload /download a file, I get an error saying: "This operation cannot be performed after the request has been submitted." Am I doing something wrong or must I create another Ftp ...Show All

• Visual Studio 2008 (Pre-release) Editing progressbar

  hello, is it possible to edit a progressbar in that kind of way that it's like the progressbar when windows is being started up Just 3 rectangles that keep on going. Or is it just possible to make a bar that fills itself, like in IE ...Show All

• SQL Server Insert / Update Trigger based on a column's value

  I am new to triggers and surely could use some help. I can create a trigger to insert related records based on the main tables ID and insert that value into other related tables fine... but... How do I create a trigger that can insert a record into one table for a columns given value and then insert a record into another table for another given value For instance: New row... Table1, Column1 (PK) has a value of 101 Table1, Column2 has a value of ...Show All

• Visual Studio Tools for Office How is this code (VBA6.0 with Excel Application) to C#

  Hi How is this code (VBA6.0 with Excel Application) to C# : Dim intValue01 as Integer intValue01 = sheet1.cells(1, 1) 'READ DATA FROM CELLS intValue01 = intValue01 + 2 sheet2.cells(1,1) = intValue01 ' 'WRITE DATA IN CELLS Thanx for any idea. sheet1.cells[1,1] this looks like an article you may be interested in: http://msdn.microsoft.com/library/default.asp url=/library/en- ...Show All

• Visual Basic How to set a control's visible property.

  I have a form that has a combo box with 7 items and also has 7 group boxes. Basically, I would like the user to click an item in the combo box and have the corresponding group box appear. If the user clicks a different item in the combo box, then I want the visible groupbox to become invisible, and the new corresponding groupbox to become visible. Could someone help me out with the code Instead of a hardcoded T ...Show All

• SQL Server Id getting generated differently

  Hi, I created a PDA application with a database, which has a table with a uniqueidentifier field and primarykey. While doing the bulk insert from dataset into sql mobile database, It is inserting the record but it is not inserting the id which was entered into the sql server 2005 database, instead the id by creating a new id and the code is as below. conAdap = new SqlCeDataAdapter (strQuery, conSqlceConnection); SqlCeCommandBuild ...Show All

• SQL Server Query runs long in profiler but quickly in Query Analyser ?

  Hi There I have the following from a sql profiler trace. declare @P1 int set @P1=28 declare @P2 int set @P2=180150014 declare @P3 int set @P3=8 declare @P4 int set @P4=1 declare @P5 int set @P5=0 exec sp_cursorprepexec @P1 output, @P2 output, N'@P1 varchar(5)', N'SELECT BUSINESS_UNIT, DESCR, DEMAND_DATE, ORDER_NO, OLD_ORDER_NO_XX, CUST_ID, SHIP_CUST_NAME2, SHIP_CUST_NAME1, ADDRESS1, ADDRESS2, ADDRESS3, CITY, DESCR100, ORDER_INT_LINE_NO, INV_ITEM ...Show All

• Smart Device Development Custom WinCE 5.0 and VS 2005 Beta2. Connection question.

  So, I have a custom board and windows ce 5.0 built to our needs. I have active sync built into the image. Now, comes the problem. VS 2005 Beta2 asks for an tcp/ip (transport) and to have activesync (bootstrapper). Then I try to connect and get "Connection failed. The current version of ActiveSync is not supported. Install the latest version from www.microsoft.com.". Well, I got activesync 3.8. That is the latest I found. As a component for PB ...Show All

• Visual Studio Question on Versions of VSS 2005 vs VSS 6

  I am rather confused and hope someone can set the record straight. The VSS road map states: "Microsoft is updating the version control technology of Visual SourceSafe. A new product release with a continued focus on version control, Visual SourceSafe 2005, will update and improve this popular system. For individual developers or small teams who need a lightweight, client-only, file server application for source code control only, Microso ...Show All

• SQL Server Search Outlook (*.msg) files within SQL Server using full-text serach

  Hello, I have a table within SQL Server 2005 which conatins a physical documents in it. Its datatype is varbinary(max). I am doing a full-text search on that column and can search office documents and even pdf documents via a filter. But, I am also saving outlook messages (*.msg) files in the table but am unable to search it. Any suggestions on how this could be achieved will help Thanks Anshuman Singh Ansh ...Show All