Roboss Liu's Q&A profile
.NET Development SQL StDev and TOP aggregate functions
Problem: I have to get some statistical values from a DataTable included in a DataSet; not from a table stored in a database. For instance, let's say I have to get the maximum , minimum and average values contained in a certain column. Question: What is the best way, in terms of performance, to obtain those values I am using the Net Framework 1.1. Some other possibilities: I think it is possible to use SQL to obtain this values from tables stored in a database but in this case I need to obtain the values from a DataSet because it is a requirement to calculate them before the user updates the database. Looping through the entire Da ...Show All
Visual Studio 2008 (Pre-release) Why are the ClientBase<TChannel> ctors protected?
With the service contract in a separate assembly it is really nice to be able to share the same assembly between the client and service. Then you can create a generic proxy client without the need for svcutil. (The same way you should share an interface for .net remoting). Unfortunately this requires writing a generic helper class that derives from ClientBase<TChannel> because all it's ctors and InnerProxy property are protected! Why oh why Please make this class more accessible for this scenario. The client base is a class you should inherit from when creating your typed client proxy. If you wa ...Show All
Smart Device Development How to build the LAP sample code?
Hi, I am trying to implement a custom password applet that displays instead of the standard builtin password screen. This was possible using pre-WM5 by creating an applet and setting (amoungst others) the Redirect registry setting for the password control panel applet. Using the letmein msdn example (which i have digitally signed to allow it to load at boot-time), this functionality no longer appears to work - the standard builtin password screen always displays. I have successfully managed to get other signed files to load at boot time. Is there any way to load a custom password applet, or has this functionality been removed in Windows Mobi ...Show All
Visual Studio Team System TFS beta 3 installation
So where is TFSQL2005AnswerFile.ini referred to in the installation guide And is /inifile: actually supported for unattended install of TFS http://blogs.msdn.com/robcaron/archive/2005/09/29/475530.aspx For Beta 3, there was supposed to be an .ini file in the Team Foundation Server image for installing SQL Server 2005 silently from the command line. As fate would have it, that file never found its way into that image. I just finished posting it to the same download page as the Installation Guide. You can download it here: Long: http://download.microsoft.com/download/c/a/d/cadd2e76-38aa-4b61-9921-8acb710 ...Show All
.NET Development xml to csv conversion
Hi, I would like convert XML file into CSV or TXT file. How to do it programmatically in VB.NET If anyone knows the realted links or sample codes or ideas, Kindly share with me Ur help will be appreciated! Thank U! Hi, The simplest way is to use an XSL stylesheet and the .NET XslTransform class. Best regards Martin ...Show All
Visual Studio Express Editions Encryption of files on USB drive
I am trying to create my own program that will encrypt files on my USB drive and decrypt them only when a password is entered, and only when logged on as certain users. Sorry if the code is a bit long. So far I have managed to achieve all but the encrytion / decryption. So can anyone out there help me with this My code so far is: Imports System Imports System.IO Public Class Form1 Dim allDrives() As DriveInfo = DriveInfo.GetDrives() Dim d As DriveInfo Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If TextBox1.Text = "-----" O ...Show All
SQL Server Updating DB Schema at the publisher
Here's a quick question for you: I'm looking at merge replication in Sql2000 at the moment and I have found that you can't change the schema an a published database without removing the subscribers and then removing the publication first. After the schema change the whole publiishing process has to start again. In Sql 2005 does it allow (in merge replication) a published database schema to be updated whilst it has subscribers Failing that is there a better story for updating a published db schema Regards Graham Hi Graham, In SQL Server 2000, you can add/drop columns using sp_repladdcolumn/sp_repldropcolumn ...Show All
Visual C# VS 2005 conversion: Removed the id attribute from the <form> tag in file
When I have converted my web app to .net framework 2.0 using Visual studio 2005 pro, I see this the conversion report: "Removed the id attribute from the <form> tag in file ..." This prevents my java scripts on my pages to work, and need to insert the id tag again. Why does VS 2005 remove the id tag in the <form> tag when converting to .net framework 2.0 Thanks for participating on the MSDN Forum, but this forum section is reserved for C# General questions ...Show All
Smart Device Development Cannot install VPC Network Driver!
I installed VS 8 and WM PPC 2005 SDK to run PPC2005 emulator. But it would not allow me to do File->Configure->Network->Enable NE2000 PCMCIA network adapter and bind to: which led to an error dialog window "Failed to open the VPC Network Driver. Verify that the driver is installed, or install the driver from the Web download location at http://go.microsoft.com/fwlink/ linkid=46859" When I followed the link and tried to install the driver, the installer just quit without any furthur message. Nothing changed afterward. I need this connection because ActiveSync does not support UDP. I am running Windows XP X ...Show All
Visual Studio Integrating help with MSDN 8.0
Is there any way to integrate aditional docs (ie. DirectX SDK help) with the MSDN 8.0 MSDN Express has a Collection Manager (ms-help://MS.VSExpressCC.v80/dv_vsexpcc/local/CollectionManagerExpress.htm ) so you acomplish this task easily. But I haven`t found a way to do the same with full MSDN that comes with VS2005. Archive Manager was stripped as I understand. So as I see it, full MSDN has less functionality than Express Correct me if I`m wrong I was able to find the Visual Studio 2005 Combined Help Collection Manager (ms-help://MS.VSCC.v80/dv_vscccommon/local/CollectionManager.htm) in my installed copy of Microsoft Visual Studio 2005 ...Show All
Software Development for Windows Vista Opening a derived workflow in workflow designer
Hi, I've been creating a base workflow class SequentialWorkflow1 based on SequentialWorkflowActivity. Then I derived another workflow class called WfWorkflowStarter1. On opening this workflow in designer results in the following error message: Error loading workflow. An error occurred loading workflow. Please correct the following error and try reloading the document to view the workflow. Unable to load one or more requested types. Retrieve the LoaderExceptions property for more information. here is the source code: public class SequentialWorkflow1 : SequentialWorkflowActivity { } public sea ...Show All
Visual C# Detecting Devices Using C#
Hello, I'm attempting to determine several things from within my code: 1) Does a laptop have a SD Card slot 2) If so, how do I detect if a Card is present 3) Does a laptop have a USB port 4) If so, how do I detect if some other type of storage device is present I have searched quite a bit on these topics and have not found anything that seemed useful. Can anyone give me some hints, pointers, examples.... anything, please Thank you in advance. Hi, if you really need the gory details, I'm afraid you need to use the API's. There is a nice article here . If instead you only need to locate the remo ...Show All
Visual Studio 2008 (Pre-release) PropertyGrid and SqlMetal genearted classes
Hello, I have used SqlMetal to generate the Dlinq classes for my database schema. I have created instances of those classes and then tried binding them to a PropertyGrid object through it's SelectedObject property. Whenever a Dlinq object is bound, and a particular EntityRef object within that class cannot be obtained from a query, it throws a EmptySequenceException. This is really not an issue from a "get" perspective, i.e. when an object is bound to the PropertyGrid object. However, this becomes a problem when you attempt to modify a property on the Dlinq object through the PropertyGrid object. For example, if I try to chan ...Show All
SQL Server Data Transfer from Active Directory to SQL Server
Hello, How can I transfer data (for example the list of all the users, groups) in the active directory into a SQL Server Where can I find information on how to do this Thank you. This might be something you can accomplish with "SQL Server Integration Services" in SQL Server 2005. This looks like a good site on the product http://www.sqlis.com/ and here's the link to the MSDN forum http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=80&SiteID=1 . Hope this helps, Vaughn ...Show All
Visual C++ Error including queue.h
When I include queue.h I get the following compiler errors in list.h c:\program files\microsoft visual studio\vc98\include\list.h(37) : error C2146: syntax error : missing ';' before identifier 'Length' c:\program files\microsoft visual studio\vc98\include\list.h(37) : error C2501: 'DWORD' : missing storage-class or type specifiers c:\program files\microsoft visual studio\vc98\include\list.h(37) : error C2501: 'Length' : missing storage-class or type specifiers c:\program files\microsoft visual studio\vc98\include\list.h(53) : error C2146: syntax error : missing ';' before identifier 'GetPrevLink' c:\program files\microsoft visual studio\vc9 ...Show All