Pgr's Q&A profile

• SQL Server Open table + NULLs

  In SQL Management studio, if I right-click on a table and click "Open table", it brings up the table, similar to return all rows in 2000. But if I go to the last row, and edit data in a cell and the word " NULL " is that cell because there is a Null value there, it actually keeps the word null in there as in "NULLnewdata". Am I doing something wrong My first suggestion would be to use an UPDATE statem ...Show All

• Software Development for Windows Vista View

  If a person dosnt want images and text documents to show in a thumbnail preview mode can you switch to icons I think it be neat to switch from Text Mode which is just text icon scaled to 0x0px preview mode shows the images and text documents and icon mode is icons and you can set the scale of the preview mode and icon mode, im not sure if thats how it works now cause i havnt beta tested Vista but I do gather and study the screenshots. ...Show All

• Windows Forms DateTimePicker (.NET 2.0) and Null values

  I've drop a DateTime field from Data Sources window to my form. When the form is displayed, if user do not change the default value of the DateTimePicker, the underlying field's value is DBNull. I've found no way to determine if the DateTimePicker's value is null or not, 'cause it always return a valid value. How can I determines if a DateTimePicker's value is DBNull or not, and any better way to show the user a DBNull value The problem, i ...Show All

• .NET Development "Stored Procedure" or "Query"?

  Hello, me again! I found myself a bit confused about "query"  and "stored procedure" in access. Are they the same thing However, I do suspect this is ture as after some googling I found that varies articals mentioned "stored procedures" are actually created in MS Access for Sql server. So what you are doing when calling a "stored procedure in Access" is actually invoking the stored procedure stored in the ...Show All

• Visual C++ dialog closing problem

  Hello friends, I made a DLL in VC++, WTL/ATL. this DLL attach a toolbar to the Internet Explorer window, when we start IExplorer. This toolbar contains menu items , on click of these menus, some dialog opens. Now problem is that, when i am going to close IExplorer window then it doesn't close. for closing it first i have to close the dialog window. Is there any way , so that i can close IExplorer without closing dialog, My dialog is modeless. M ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Broken Link to MechCommander 2 Shared Source Release

  Microsoft XNA Build March 2006 Community Technology Preview featured at http://www.microsoft.com/downloads/details.aspx FamilyID=868fe562-5ded-4bb1-8648-708d3481bda3&DisplayLang=en has a link to the MechCommander 2 Shared Source Release download. The link is http://www.microsoft.com/downloads/info.aspx na=40&p=2&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=868fe562-5ded-4bb1-8648-708d3481bda3&u=http%3a%2f%2fgo.microso ...Show All

• Visual C# Retrieving from a DataRow

  Can I retrieve a field from a DataRow wtihout having to cast it to the correct type I have a class that contains a DataTable member. The default constructor fills it from a table on an SQL server. Once created, getters return lookup items from the table, based on received criteria. The getter methods accept a string or set of strings, apply a Select on the member tables, and set a result string from the data table. For example: public strin ...Show All

• Visual Studio Team System Avg. Response Time

  Hi, I am running a load test containing webtests. Each webtest has one webservice request. The avg. response time of each request is aroung 12msec(0.012sec). I see a counter "% Time in Webtest Code" which shows around 45%. My question is if the avg. response time also includes the time spent in the webtest code . If this is the case, is the actual response time 12msec - 5.4msec(45% of the total avg. response time) Please ad ...Show All

• Visual Studio build error with devenv

  Hi all, I created a setup project and tried to compile it as below using devenv.      devenv c:projects\src\Setup.sln /build release but this gives the error " Unable to open project c:projects\src\Setup.vdproj " This is when i use 2005. But this process was successfull in 2003. I want to know whether this is a known issue in 2005. Thanks in advance. Bimali, There was a bug in devenv.exe in ...Show All

• Windows Forms call window login dialog in window form

  may i know how to call window login dialog that contain username, password and domain name in my window form application Thank You Have a look at the following article: http://www.developerfusion.co.uk/show/4693/2/ ...Show All

• Visual Studio Team System "Hidden" reports in RTM ..

  In MSF4/RTM, there are some useful reports like "Work Items", "Work Items with Tasks", "Load Test Detail" etc which are marked "hidden" in the process template's ReportTasks.xml file. Therefore, they don't appear in MSF Agile team projects. These reports were available prevously. Any problem if I unhide these reports Thanks. The hidden reports are not sh ...Show All

• SQL Server Plug-in algorithm documentation and sample code

  I've read in at least one book (and heard firsthand at the SQL Server launch event) that there's a plug-in framework for adding new algorithms to Data Mining. However, the book was apparently written against a Beta version, and the location it suggests for the plug-in sample code doesn't exist in the shipping version. I haven't been able to locate any documentation about the plug-in framework in the SQL Server Books Online, and I haven't been ab ...Show All

• Visual Basic VB.NET 2005 RC - Datagrid issue

  I have an application which uses a datagrid to display a property listing.   The list will contain around a quarter of a million records so I need the user to have a simple way to search. I have built a search routine which allows the user to type some text in to a toolstrip bar and then performs a search through the dataset.   The issue I have is when the routine finds a match, I need it to highlight the row on the datagrid.   ...Show All

• .NET Development Updates through OleDbCommand are not written to database

  Hi, i am trying to update an access database with the OleDbCommand.ExecuteNonQuery function. ..... lintRows=lobjOleDbCommand.ExecuteNonQuery("UPDATE TableX SET ColumnValue=9 WHERE ColumnId=1") ..... The function returns value 1, indicating that 1 record have been updated. After closing the OleDbConnection and requerying however, it looks like the update has been rolled back or has never been written to the database. Any sug ...Show All

• SQL Server Does Full-text extract searchable metadata (Properties) from documents?

  When I create a full-text index on a word document for example. I want it to load metadata (property) fields that can be search independently from the word list. For example, queries like: cat and dog and (Author <contains> 'Mary Jones') This quarantees that Mary Jones only occurs in the word docs author metadata field and not within the document itself. The property fields for an email document would be: to, from, cc, bcc ...Show All