osfa's Q&A profile

• SQL Server complex stored procedure on history table

  Hi All, I have a table that hold status history records for cases. In this table is a status field with values, opened, assigned, or complete. Each case can be assigned a number of times before it is complete, and can be reassigned. I have the need to run a query that will get each case that is still assigned, and not yet complete. I wrote a stored procedure that contains a cursor containing each case, and get the last status history record for each case and puts it into a temp table to return to the user, but is hurting performance as there are .5 million records here. Does anyone know of a better way of doing this Thanks in advan ...Show All

• .NET Development Help to a function about DataSet?

  Hello out there I code in the Visual C# 2003 .NET and MySQL database. I have found this function a have found and would try, but it don't works correcly when I try get it in my program: private int lf (DataSet ds, string TableName, string ColumnName) { int maxlength = 0; int tot = ds.Tables[TableName].Rows.Count; string straux = ""; int intaux = 0; Graphics g = dataGrid1.CreateGraphics(); int offset = Convert.ToInt32(Math.Ceiling(g.MeasureString(" ", dataGrid1.Font).Width)); for (int i=0; i<tot; ++i) { straux =  ds.Tables[TableName].Rows[ i ][ColumnName].ToString(); intaux = Convert.ToInt32(Math.Ceiling(g.Measure ...Show All

• Windows Forms How to change row color in DataGrid?

  How can I conditionally change the color of a row in DataGrid  I have a column named “MonthClosed” in my DataGrid. If the value of in this column of a row is True then I want to set the color of entire row to Green otherwise as Blue.  Thanx  ...Show All

• Visual Studio Express Editions Visual Basic 2005 Express, MS Office 2007 Beta, and Excel .Net Reference

  I downloaded and installed Microsoft Office 2007 Beta and have discovered a problem with the Excel .Net references when working with VB 2005, but can't find where to report it. The 2007 version causes overload errors in the part of my code that accesses Excel. I had to reload the Excel 2003 .Net advanced option and load Excel 2007 without the .Net advanced option to get rid of the errors. This is my first experience using a Beta product from Microsoft and I thought I woud be able to find a link easily to report things like this, so if I'm just looking in the wrong spot, I would appreciate being redirected. Thanks! Cindy ...Show All

• SQL Server Problems adding MS access datasource in VB studios 2005 enterprise

  I am running Visual Studios 2005 enterprise edition and I am creating a mobile application to keep track of some receipts. The problem I'm currently having is that even though I can connect to the MS Access Database with Server Explorer that I'll be aquiring data from; Everytime I attempt to use the Data Configuration Wizard to add a new data source that namely the database I get this error message: The new connection uses a data provider that is not supported. (end of message) There is no username or password necessary to access this database and it is an Access 2003 database. Any help would be greatly appreciated. ...Show All

• Visual Studio Team System AvoidUninstantiatedInternalClasses

  Just ran a newly converted solution through FxCop and am seeing several of these warnings: AvoidUninstantiatedInternalClasses Cause: An instance of an assembly-level type is not created by code within the assembly. There is one for each of the following classes: MyComputer MyApplication Normally I would just exclude these form my solution but the 'When to Exclude Messages' portion of the warning states: It is safe to exclude a message from this rule, but there are no known scenarios where this is required. ...so this leads me to believe that there is a way to remove these 'My...' classes from my project. Any ideas or pushes in the pro ...Show All

• .NET Development unzipping files in a ZIP file

  I need to read in a ZIP file (WinZIP file) and write out the files contained to a folder, can I use System.IO.Compression I've looked at the deflate stream method, and this looks easy enough to decompress to memory, but how do I write out the files from this point thanks Not sure if the compression namespace supports ZIP Compression or not, but you could try this out: http://www.icsharpcode.net/OpenSource/SharpZipLib/ I've been using it since the 1.1 framework and it works rather well. Thanks Wayne ...Show All

• Visual C++ cannot debug "Hello world!"

  Hi, I created a win32 console application starting with an empty project using Visual Studio 2005. I then added a cpp file and typed in the following code: #include <iostream> using namespace std; int main() {      cout << "Hello world!\n";      return 0; } When I try to run the program by pressing "Start Debugging" (F5), a console window appears then I get a popup saying : "There is no source code available for the current location." I then have an option to "Show Disassembly". I can see my output in the console window if I click "Start Without Debugging" (Ctrl ...Show All

• Visual C++ Function overloading problem?

  I'm not sure if this is a bug in MS (using VS 2003) or if an oversite in the C++ standard.  But, when I have multiple functions in a base class using the same name with different signatures and I override one of the functions in a derived class, the remaining functions in the base class become invisible. This is part of an annotation module for an image viewer. class line{ protected:     POINT _pt; public:     // returns the end point     virtual const POINT& end() const{         return _pt;     }     // sets the end point &nb ...Show All

• Visual Studio Team System TF42057: build request is not from the configured team foundation server

  Hi, I installed TFSBuild on the application tier of my team foundation server. When I try to execute a build, I receive the following error: "TF42057: The build request is not from the configured Team Foundation Server. Please contact your Team Foundation Server administrator for help." This occurs whether I do it from the VS2005 IDE or if I log in to the application tier and run it from the command line. I took the steps outlined by Kishore to turn on logging and restarted the service, but nothing is showing up in the logs. Thoughts Each build machine is only allowed to "talk" to one TFS - an attempt to start a bu ...Show All

• Smart Device Development Storage program

  I've created an application for compact framework 2.0 and sql mobile. When the device need a cold boot i lose all my files. My device can't use an storage card but the device has built in storage cards when i put my program on a built in storage card an the device needs a cold boot, all files are there but i can't run my application because compact framework and sql mobile are missing... how do i solve this problem thanks I found the wceload.exe file in my \Windows folder - but I am using PPC2003 SE . It's a ROM file. Note that this is a HIDDEN SYETEM file, so perhaps if you're just using File E ...Show All

• Visual Studio GAT on Visual Studio Release Candidate

  Hello do you guys know when is there going to be a release of GAT that works on the VStudio release candidate distributed in PDC last week The framework is really cool and we are looking forward to use it but we need to know when you estimate a Release Candidate version to do our internal planning. Thanks Gabo I second that motion! I've got the NJ Code Camp coming up on Oct. 15th and would love to do a presentation on GAT, but using RC1 not the old Beta 2. ...Show All

• Software Development for Windows Vista 3 layered architecture - Where to house rules?

  In my business layer I have a business components (BC) assembly and a business workflows (BW) assembly. I plan to have validation rules such as mandoatory field, range validation etc. in the (BC) and business rules/poilicies such as 'calculate order discount' in the BW assembly. All CRUD operations are also implemented in the BC assembly. All services in both assemblies are exposed to the presentation layer through a Services Interface. (To help visualise http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnpatterns/html/ArcThreeLayeredSvcsApp.asp ) 1. When I call one of the crud opeartions (in the BC assembly) such as cr ...Show All

• Visual C++ Loading dll from another folder

  In my application, I need to use dll A that depends on another dll B. A.dll is in my application folder and B.dll is in a subfolder of the application folder. What can I do so that A.dll can load B.dll from its present location I can not change the location of these dlls or their source code - I can only change the code of the application. Any ideas Simply change the PATH environment variable for your process just befor loading the library A. You can restore it to the old value after LoadLibrary is done. ...Show All

• Visual Studio Available values (ValidValues) from query in VS 2005

  Hello, i am trying to create a report in Visual Studio 2005 (format .rdlc). The report needs some parameters. I would like to set the "available values" for each parameter. The values should be find out by a query. In VS 2003 it is possible to set a property to get the validvalues from a query: How can i do this in Visual Studio 2005 I didn't find any solution in this screen: Thanks for your help. Local report processing (.rdlc files) does not execute queries. It is the responsibility of the host of the reportviewer control to execute queries and supply both the dataset and any report parameter ...Show All