wgaspk's Q&A profile

• SQL Server Frustrated: Error Output in Source and Destination Editor.

  Hi Is there anyway I can multi select rows when I'm changing the value for either Error or Truncation    I'm finding it frustrating having to change 2 values for each row in the output.  for example redirect row, when I have 10,20,30 columns. It would have been nice to have a global drop down at the top of each column so that I could then selectively change rows back. Any hints and tips on making this easier would be gratefully appreciated. Thanks Hi doug, I'm using The June CTP downloaded from MSDN and that doesn't have aany buttons.  What release are you running And thankyou for your re ...Show All

• .NET Development BindingNavigator Exception Handling

  How do I handle exceptions that are thrown during a move method of the BindingNavigator For example, the BindingNavigator is bound to a BindingSource that is based on a DataTable that has a required column.  If that required column is DBNull when the BindingNavigator.MoveNext is called, NoNullAllowedException is thrown.  The exception is thrown within the BindingNavagator, and makes it's all the way back to the applications unhandled exception handler.  By then, it's too late and the forms is forced closed. BindingSource.DataError does not catch the error DataTable.RowChanging does not fire before the exception Bin ...Show All

• Visual Studio 2008 (Pre-release) Dynamic type loading

  I'm trying to dynamically load types from a dll and pass the newly created objects through WCF. Is there any way to do this Dynamically load data contracts KnownType attribute I suppose the main issue is the actual method call itself. Since the type isn't known at compile time, I've been using Object, but testing reveals that specifying "Object" then passing a type with a data contract still doesn't work. Any help would be appreciated! Followup: I've done some testing, and it looks like the big problem is deserialization on the receiving side. I need to somehow know the type of the object to loa ...Show All

• Visual Studio 2008 (Pre-release) Animate a DrawingVisual

  I'm need to animate a bunch of DrawingVisual objects that I hold in a VisualCollection but something like the following doesn't seem to work: ((DrawingVisual)_children[_currentPointIndex]).SetValue(Canvas.LeftProperty, p.X); If I need to animate the DrawingVisual's location, how do I properly do that Thanks! Visuals don't have support for layout so I think the only solution is to set the transform on them: DrawingVisual dv = new DrawingVisual(); ... dv.Transform = new TranslateTransform(x,y); ...Show All

• Visual Studio Express Editions Publish Can't Find Redist Files

  I've checked SQLExpress, .Net Framework, and Windows installer  and checked "Download prereq from same location an as my application" and get several errors.  Here is a sample:  Error 4 The install location for prerequisites has not been set to 'component vendor's web site' and the file 'DotNetFX\dotnetfx.exe' in item '.NET Framework 2.0' can not be located on disk. See Help for more information. TOPKPDFServer What do I need to do to tell the publisher where to find the files on my machine hi, i'm not sure that i understood what you have said very well but i gues ...Show All

• Visual Basic Tricky one for you all. WMI and CPU Utilisation.

  Hey all, I have created the following class to get CPU Utilisation data using WMI as follows; Imports System.Management Public Class WMIProcessing # Region " Definitions " 'WMI Objects... Private mManagementScope As New System.Management.ManagementScope Private mObjectSearcher As System.Management.ManagementObjectSearcher Private mCollection As System.Management.ManagementObjectCollection Private mObject As System.Management.ManagementObject 'Data Storage... Private mOldData As RawData Private mNowData As RawData Private mResult As Double 'Flag to indicate first run... Pri ...Show All

• Windows Forms Measure String

  I need to measure a given string using a given font.  However, I have no desire to ever draw this string to any surface.  How can I go about creating a graphics object to get access to the MeasureString function   Or is there another way to measure a string I would be doing this several hundred times in sequence, so speed could be& ...Show All

• .NET Development Windows application built for Framework 1.1 does not run with Framework 2.0

  I have an application developed with VS 2003 for the Framework version 1.1. I do not distribute the framework with my installer for obvious reasons. When people download and install my software, the installer directs the user to the Microsoft site where the framework can be downloaded. Here is the problem: Currently, MS offers version 2.0 for download, but the installer demands version 1.1 of the framework. Can anyone help me how to change the setup in such a way, that it installs and runs with both version 1.1 and version 2.0 of the framework In advance, many thanks, if you can offer some help. Ruud. There ...Show All

• Visual Studio Team System How to spawn Team Explorer

  Is it possible to launch Team Explorer client from a web page Something like URL to link from Team Project Portal. Preferably pointing directly to the related project. obs.: I've tried to do that using a script with shell command, but my users have VS2003 installed in their machines too, and in some cases it gets launched instead of VS2005 (when running DevEnv.exe). Thanks, Max You could tweak "Content Type" to something IE does not understand, like "application/devenv" and it will open the file in devenv after the usual warning.  Nearly all of the VS registered content types are text/plain or ...Show All

• SQL Server SQL syntax to sum fields from two SQL statements

  I have two SQL statements that return sum(pcs) and sum(amt) from two differnt conditions. How do I get a total sum of pcs and amt from these two SQL went I union them SQL1: return columns value, SUM(pcs), SUM(amt) where amt is value*pcs $2 , 4pcs, $8 $5, 5pcs, $25 SQL2: return similar columns value, SUM(pcs), SUM(amt) FROM another condition giving: $2, 3pcs, $6 $5, 1pc, $5 If I use (SQL1 union SQL 2), I get $2 , 4pcs, $8 $2, 3pcs, $6 $5, 5pcs, $25 $5, 1pc, $5 I want to get the final result as: $2, 7pcs, $14 $5, 6pcs, $30 How to write the SQL statement to get the result OR it is not possible at all Vincent ...Show All

• Visual Basic DataTables??

  I need to figure out how to take data from one table and create a table in memory with my own columns. How do I create this table in memory and pass the data to it Hi, Here is code snippet to create a datatable in memory. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim dt As New DataTable("MyTable") Dim dc As New DataColumn("ID", GetType(System.Int32)) dt.Columns.Add(dc) dc = New DataColumn("Name", GetType(System.String)) dt.Columns.Add(dc) Dim dr As DataRow = dt.NewRow dr(" ...Show All

• SQL Server Problem with ODBC access in a thread

  Hi guys, I'm using SQL 2005 Express with an ODBC connection. I've created a thread to fill a listctrl with the data of a table. At the end of the thread there is cicle to check for some lines value in another table. When I try to close RecordSet linked to the second table to ReOpen with another SQL Statement the thread ends. Using SQL Server 7 I've no problem. What's wrong ...or what I'm not doing Thank you in advance Do you get the same behavior with both SQL Server and SQL Native Client ODBC drivers Any chance you could supply sample code so we can get a clearer picture of what you'r ...Show All

• SQL Server Questions about data mining programmality

  Hi, all here, I have a question about having data mining progammability. I mean is there any functions we can not realize through data mining graphical user inteface Otherwise cant see any point to use data mining programmability which is a harder way compared to available graphical user interface for data mining. (it is just like because you can do things in a hard way dose not mean you have to ) Thanks a lot in advance for any guidance and help. There are lots of different reasons to use the programmatic interfaces. In general, you use them because you want to embed data mining into an application. If all you are doing is ...Show All

• .NET Development Assign strong name to third part DLL

  Hi, I am using third party dll like companentart.web.ui.dll which is not assigned as strong name. I can't have any code for modification so how can assign strong name to third party dll. So please help me by providing solution for third paty strong name. See the documentation on the Strong Name Tool (Sn.exe): http://msdn.microsoft.com/library/default.asp url=/library/en-us/cptools/html/cpgrfstrongnameutilitysnexe.asp ...Show All

• Visual Studio Team System TF2006: Could not connection to the Team Foundation Server.

  After i installed the team foundation server, i can access to work items in team explorer by Administrator account. However, i could not create any other accounts to access work items. When i double click to queue thw work items, it will display the following message.   "TF2006: Could not connection to the Team Foundation Server. Check that you have a network connection and that your team foundation server is avaliable."   Can anyone tell me what's the matter and how to solve it I think it is the permission problems. Since if i grant local administrator account to new account, it can queue work items. Thanks ...Show All