Kartit's Q&A profile

• Visual Basic Question about how to close whole program

  Hey guys i have another stupid question 2 ask, apologise for my ignorace once again as this myt seem like a really stupid question. I have multiple forms for my program. I was wondering how i would close the whole program in the third form ( closing all forms) Me.Dispose() This only closes the form that i put this code in. These are just the final touches to my project for school. Would appreciate it if you guys would reply me! THANK YOU!!! :D You guys have been really helpful to me all along. that is correct but 99% of the time it will exit. The times it will not exit is if there are things like threading happening in the background and its still running - once that is complete it will then ...Show All

• Visual FoxPro Sys(2600) and Apps

  Sys(2600) is the way to send or retrieve a String from a memory Address. Passing the memory address to another application as a parameter, can we retrieve the string in memory sended by the first application I try it, but it doesn't work, I think the GlobalAlloc() doesn't work any more as Global but as Local - according to MS info) Does anyone know how to do it DaCosta11 It is working if you put: _Cliptext = Sys (2600, hMem, lnSize, lcString) and on the "other" fox: _Cliptext ...Show All

• SQL Server Access functions to SQL Server

  I'm upsizing MS-Access to SQL Server 2005. I need to convert the following functions: TRANSFORM PIVOT FORMAT MID Are there any similar functions in SQL Server Also I have a query as follows: SELECT Mid$ ([AccountNumber], 3 , 8 ) AS [Account#], Format ([checkamount]* 100 , "000000000" ) AS Amount, IIf ( IsNull ([statusdate]), " " , Format ([statusdate], "yyyymmdd" )) AS [Date] FROM tblResult; How do I convert this in SQL Server query Please check out the following resources for migrating from Access to SQL Server. We also have a tool to help with that. http://www.microsoft.com/sql/solutions/migration/access/defaul ...Show All

• .NET Development Is it possible to calculate a column value in a DataTable using managed code in .NET 2.0?

  Hi, I have a requirement to populate an asp.net 2.0 GridView control with data, with some columns directly retrieved from a SQL Server 2005 stored procedure and others calculated from those columns using .NET method calls. I thought I could achieve this by using an ObjectDataSource calling a GetData method in a DataSet created using the DataSet Designer, then hooking into an event where I could calculate the values for the required extra columns of data, so that these would appear in the GridView. However, I can't find an appropriate event to hook into to do this. Does anyone know how to achieve the effect I require Setting DataColumn.Expression looks like it ought to do this, but that does not allow anything except SQL express ...Show All

• SQL Server Problems with performance when programmatically printing large amounts of pages

  We are using VB.NET 2005 to develop a WinForms application that uses SQL Server 2005 Reporting Services to produce reports. Originally we tried  using code found on Bryan's WebLog,  http://blogs.msdn.com/bryanke/articles/71491.aspx , but found that for reports of 300 pages it was taking about 2 minutes to render each page. When using RenderStream to render idividual pages, reports of about 20 pages printed without a problem, but for reports of 300 pages we recieved the follwoing error: "The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database." Is there some cache or something that we should be using Any ideas appreciated. -- Leah The ...Show All

• SQL Server 4 errors when using SSIS scripting component

  Hi guys, I got these errors when writing a scripting component. Anyone encounteer these errors before Warning 1 The dependency 'EnvDTE' could not be found. Warning 2 The dependency 'Microsoft.SqlServer.VSAHosting' could not be found. Warning 3 The dependency 'Microsoft.SqlServer.DtsMsg' could not be found. Warning 4 The dependency 'Microsoft.SqlServer.VSAHostingDT' could not be found. -Daren Excellent response. I had this error a while back and could not find a clear solution. Thanks for defining the solution so definitively. ...Show All

• Visual Studio Express Editions Making a static library to work across different solutions

  I’m trying to make a Solution that contains various functions and classes that I use regularly and compile it to a static lib file which could be then used in other projects and solutions. I got the example static lib project described in help working, but for that both the maker and user projects were in the same solution. He is the process I used to make it. Steps: Created a new console project in solution “Solution A” called LibMaker set as a static library set use no pre-compiled header create a new item called LibTest.h This class contained the code: void testFunction( int a, int b, double c); create a new item called LibTest.cpp This class contained the code: ...Show All

• Visual Studio Team System Merging From Branch to Branch

  I have the following TFS source control layout: $/Main/ $/Release 1.0.0.0 $/Release 1.1.0.0 $/Release 1.2.0.0 ... etc Let's say I have a bug fix for version 1.0.0.0. I write the bug fix and check the code directly into $/Release 1.0.0.0. I can label this changeset as version 1.0.0.1 or branch it again or whatever. Let's say this particular bug applies to all releases and to my current Main. I can easily merge the change from $/Release 1.0.0.0 back into $/Main. No problem. But what if I want to merge that same change into 1.1.0.0 and 1.2.0.0 As far as I can tell, I first need to merge the change into $/Main and then back out to the various release branches. There is no option to do a merge from one branch directly in ...Show All

• Audio and Video Development Windows Media Encoder 9

  I hope someone can help me. Im broadcasting using Windows Media Encoder 9. Im doing a screen capture off of another computer. But today, its only using black and white screen. Its allways been color. Anyone know how to switch this back Thanks for your time guys. ok, somehow i got that problem fixed but now i have another one. When im switching sources, while encoding, sometimes the sound bugs out, and goes to a complete screeching sound. If i switch to another source, then back to the live source im using, sometimes the screeching sound goes away. Any idea what is causing this ...Show All

• SQL Server Logging the control flow hierarchy

  Hello, I am using the event handling mechanism to do my custom logging. This works fine. Using the OnPreExecute and OnPostExecute my log tables fill up with the start- and enddates of all the containers and tasks in the complete package hierarchy. However, what I am missing (e.g. in a system variable) is the source ID of the parent container that started the task or container. In other words, in my logging reports, I would like to build up a tree starting with the topmost package, like the progress indication in the IDE. The built-in Logging features do not log this information either as far as I can tell. Does anyone know how to do this Kind regards, Jeroen Hi Jeroen, If you enable logg ...Show All

• .NET Development How many CLR Instances is created when multiple windows application is running on single OS ??

  Hi, I have seen many sites for dotnet that say all the AppDomains are created in single OS process and AppDomains hosted in the same Windows process share the same resources such as the CLR,the base .NET types, the addressing space and threads. So my question is how many instances of CLR will be created when multiple windows application is invoke in a single OS. and how many Garbage Collector will work in this case Thnk.. Fey Thank you Michael, I am very much satisfied with your answer now and my query is also solved .. but can you please explain the same scenario for the multiple ASP.net web applications running under single Web Server. Because .. what I know in ASP.net is that all the application ...Show All

• SQL Server SQL Server 2005 License issue

  Hi all, We have installed the SQL Server 2005 Enterprise trail version for 180 days. As it specifies in the documentation that it exprires after 180 days and in the mean time we have actually made a purchase of the License. Now...do we need to uninstall the trail verision and reset/restart everything again Please advise. Thanks. Refer to Sam's blog http://blogs.msdn.com/sqlblog/archive/2006/09/17/upgrade-eval-edtion-to-full-blow-sql-2005-editions.aspx to upgrade and also KBA http://support.microsoft.com/kb/914158 for information if you have struck with the problem. ...Show All

• Visual Studio Team System TF14043: An error occurred computing the delta. Not enough storage is available to process this command

  We're attempting to migrate a fairly sizeable SoruceSafe database into a dual-tier TFS server configuration using VSSConverter. After running analyze.exe, VSSConverter Analyze, then half-way through VSSConverter Migrate we start seeing errors in the EventLog. The app-tier server had been running for about 3 weeks, so we've restarted it and are starting a fresh VSSConverter Migrate. Searching for the win32 error "Not enough storage space is available" seems to indicate that it's run out of memory. However this is a Dual Xeon hyper-threaded box with 3.5Gb of memory and plenty of free disk space. The 2.0 Framework machine.config has <processModel autoConfig="true" /> Can you provide any clues as to wha ...Show All

• SQL Server Retrieve List of SSAS 2005 KPI Names using MDX?

  I this actually possible All my research to date suggests that it is not. I know it can be done using XMLA or AMO but these are not available from Reporting Services right My goal is to retrieve a list of KPI Names to Reporting Services. These names will then be used as the allowed values list of a paremeter for a KPI report. I previously managed to do it for calculated measures using EXCEPT([Measures].AllMembers, [Measures].Members). I can currently think of three options, none of which I like! 1) Create SQL CLR Proc and use AMO to retrieve KPI Names and return result set 2) Create SQL CLR Proc and use XMLA to retrieve KPI Names and return result set 3) Periodically run some app which uses one of the above methods to popula ...Show All

• Smart Device Development CameraCapture

  I have tried code samples of Windows mobile-CECamera, and CameraCapture for C++. But I can not execute these programs.. I think the problem is my camera is not integrated in PDA. These sample codes are really for integrated camera My device is HP IPAQ 2790, and Camera is Photosmart camera SDIO Type.(not integrated in IPAQ 2790) I have tried CECamera, CameraCapture for C# and C++. Thanks. Yes, I have tried Veo camera SDK. But It can just handle still image. Veo SDK supports just still image, not video. I need to capture video.. ;;It seems very difficult..I think all my problem is SDIO camera for WM2003, not WM5. ...Show All