Manish Agarwal's Q&A profile

• SQL Server How to use tableadapter wizard with vendor specific keywords?

  Hi.  I really like the new tableadapter wizards and how they can speed up development.  However, I'm running into a problem I need help with.  I am using the table adapter against DB2 and there are special keywords that the designer isn't allowing.  i.e. Select field1, field2 from table for fetch only with ur ; When I enter this into the query wizard and then move off the SQL pane to another pane, the wizard quotes the sql so it looks like so: Select field1, field2 from table FOR "fetch" "only" "with" ur ; Hence my predicament.  When I try to run this or press the ok button to save the query, it won't run becau ...Show All

• Visual Studio MSBuild & Website

  Hi all, I am new to Msbuild and trying to get a script working for our solution. After some reading on Msbuild I had some basic question. 1. If the build box is different from development box and if the solution has websites with virtual directories then to successfully compile/build the solution on the build box do we need to explicitly create websites in IIS with similar virtual directory structure on the build box. 2. If not, then how do we compile the websites in the solution. Thanks MRI Hi, In addition to question above, is there a way where we can just compile the cs files below the website and not aspx or ascx files As f ...Show All

• Software Development for Windows Vista How to get WorkflowInstance from Workflow Runtime

  When I get the Workflow Instance from Workflow Runtime I am getting the following exception. Can anyone please help. WorkflowInstance wi = workflowRuntime.GetWorkflow(workflowInstanceId); This is the syntax used. This I am doing in the second form where as my Runtime is created in the first form. I declared the Runtime as a static member and so I am able to get the reference in the next form. Please help. A first chance exception of type 'System.IndexOutOfRangeException' occurred in System.Workflow.ComponentModel.dll System.Transactions Critical: 0 : <TraceRecord xmlns="http://schemas.microsoft.com/2004/10/ ...Show All

• Visual Studio Report footer not printing in landscape A4

  I am printing landscape on A4 (width=11.69in, height=8.27in). My page number in the footer shows fine in preview mode in the designer but does not print. What am I doing wrong Tia ...Show All

• Visual Basic getting files from FTP

  Hey, I got a Windows application that processes Excel files and transfers all data to a DB. These Excel files at the moment are being sent to Malta from Germany via FTP........ the user copies the files to another location (as the FTP directory is not accessible) and then browses for them using an Open File Dialog.... the application then does the processing needed! I would like to automate this a bit more. 1. How can I access the FTP server (NOT anonymously!) 2. How can I check if the folder is empty 3. How do I retrieve files (preferably removing them from the FTP server and placing them in another location) Thanks for your help ...Show All

• Visual Studio Team System Link Work Item to document on project portal

  Is it possible to attach a link to a Work Item that points to a document on the project portal For instance, if you have the work item Create requirements document, you would want to have the finished document in TFS. Either attached to the work item or in some document folder on the project portal. The latter one is the better location, I would say, but then I would want to link the work item to the document on the portal. However, it is only possible to link to a document if it is a Source Code File. The target item seems to point to the sharepoint portal, but I can't find my uploaded documents. What am I doing wrong Thanks, this ...Show All

• Windows Forms Moving controls between Split Containers

  Help - I'm going bonkers I have a windows form with 6 Split Containers, however I cannot manage which control resides in which split container. What is the best way to move controls between containers. EG I have a CryReportViewer in one container which I now want to move to another container.I have tried the Move-to-Top and Move-To-Bottom but with little success. Regards Each SplitContainer has two panels, access through the SplitContainer.Panel1 and .Panel2 properties.  Remove the control from its current parent panel, and add it to the new parent panel. For example, on a form with 2 SplitContainers, ...Show All

• SQL Server Problem with Client Side Printing

  After the Cumulative Security Update for Internet Explorer (912812) the client side printing doesn't work any more. Almost each client get the error: "Unable to load client print control." Other clients get an error with code '0x8007F304'. What can i do Will SP1 solve the issue Client Print is an Active X control. The security update may have disabled the ability to run Active X controls. Check your IE properties to see if Active X controls are allowed to run. In the patch notes I read the following. Compatibility Patch – To help enterprise customers who need more time to prepare for t ...Show All

• Visual Basic using savesettings

  Hi, does anybody know, how i can use saveSettings in a VB Smart Device Project Do i need to declare a sub to any PLL It seems that this is not built in although stated on the MSDN Webpage here is a blog about using saveSetting on a toolStrip http://spaces.msn.com/jvervoorn/ ...Show All

• Visual Studio Visual Studio RTM recompile

  I have fixed and re-compiled the code for VS2005RTM. Some references were missing and non-existend interface to unit-test generation was left out. You can download it from the Netron Project website:   http://netron.sourceforge.net/wp/ p=154 Incomprehensible these 'toys' were not included in the final Visual Studio release, they seem vital to me to work fluently with the class designer. Well, nicely done anyway, only wished Netron had been used for it Kind, F. _______________________________________ Francois M.Vanderseypen The Netron Project - Generic diagramming, graph-drawing and graph-layout kit for .Net http://www.netronproject ...Show All

• Visual Basic Passing a structure with arrays of fixed length strings to a DLL

  Hi, I need to be able to pass a structure to a DLL that has arrays of fields of fixed length in it. In old VB6 this could be done by having types with types type repeatingRecord field1 as string * 2 field2 as string * 5 end type type maintype field1 as string * 7 records(10) as repeatingRecord end type In .NET types become structures and fixed length strings no longer exist. However the attributes 'VBFixedString' and MarshalAs will solve this problem for simple structures. However it still does not solve my problem for arrays. .NET will not allow fixed length arrays ...... How do I pass the equivalent in .NET to un ...Show All

• Visual C# how can I detect device in C#

  Hello everybody, For this moment I have only one question: "How can I detect if my webCam is connected to my computer" Is there any classes, that I should know thanks I think this can help you: http://www.codeproject.com/dotnet/wiascriptingdotnet.asp ...Show All

• Visual Studio Start Page and Proxys

  How can I make the visual studio 2005 RTM Start page work through an authenticating proxy server I'm not really sure what proxy technology is being used where I work, but it only requires basic authentication (eg: http://username:password@proxy:3128 as the http_proxy/https_proxy environment variables, allows me to run curl commands). I'm kind of baffled as to why the devenv.exe.config defaultProxy fix has no effect. I've also noticed that when I use System.Net.CredentialCache in my web requests, they work fine when called from the Visual Studio ASP.Net debugging server but fail with a proxy authentication er ...Show All

• Windows Forms subreport

  hello i have two reports. The datasource of the first report is stored procedure called sp1 and it takes one parameter called @month. The datasource of the second report is stored procedure called sp2 and it takes one parameter called @month. The second report is a subreport in the first report. I have a crystalreportviewer called crystalreportviewer1 to make hosting for the&n ...Show All

• .NET Development Best Practice Architecture Question (Distribued Application Cache)

  Hi, Im in the process of developing a distributed application that has dynamic web menus and other components that are stored in my sql database. the menu is set at load time on the master page, and as you can imagine this will become a big problem having to query the db everytime I load the page. So I have created a cache to store the menu to save on db access. The question I have is: In which of my application layers should I place the cache query code basic overview of my app is as follows:         ---------User Interface---------------------     Web App     SoapProxies   ...Show All