Joey.Liang's Q&A profile

• SQL Server How can i get the first day of the month and the last day of the month?

  Is there a function that do id or i need to calculate it by myself Hi, there is no built in one, but you can use these ones here which is just wrote for you: CREATE FUNCTION FirstDayofMonth ( @InputDate DATETIME ) RETURNS DateTime AS BEGIN RETURN ( SELECT LEFT( CONVERT ( VARCHAR ( 10 ), @Inputdate , 112 ), 6 ) + '01' ) END GO SELECT dbo . FirstdayofMonth ...Show All

• SQL Server Backup databases programatically.

  Hello 1. Sql Express supports SMO 2. If so How can I make a backup of a database programatically Thanks You do know that you can overload the Server instantiation to direct it to the server you want to connect to, don't you Example: Dim srv As Server srv = New Server("MyLapTop\Express") In VB.Net you can also set the property in the ServerConnection object: Dim srv As Server Dim srvConn As ServerConnection srv = ...Show All

• .NET Development WSE 3.0 problem

  I am developing a web services app in compact framework and want to use only MTOM feature of WSE 3.0 for dending data but if possible would love to use other features also I enabled WSE 3.0 in my web services app but as soon as i built my code I got a lot of errors. So I tried msdn and found foll article . This did a great work and most of the errors were removed except one "The type 'System.Web.Services.Protocols.SoapHttpClientProtoc ...Show All

• Windows Forms DataGridView: column provided does not belong to this DataGridView control

  Hi all, I've this exception sometimes with some DataGridView. The DataGridView DataSource is linked to a table from a DataSet and I've this issue if I set the 'AutoSizeColumnsMode' property to 'DisplayedCells' or 'AllCells'. But if I put 'None' to this property I don't have the exception... Any Idea how to solve it I would like to have 'DisplayedCells' on the 'AutoSizeColumnsMode' of the DataGridView. Thanks in advance for your help :) ...Show All

• .NET Development How to pass a structure to a web service?

  Hi all - This is a simple problem that I'm having all sorts of trouble with.  Web Services all work fine while I'm passing standard data types, but when I try to pass a structure, one end or the other always acts like it doesn't know what I'm talking about! I realise I probably have to serialize myStruct somehow, and maybe put xmlInclude in there, like I had to when I was returning an arraylist from a service, but how (Before even starting ...Show All

• Visual Studio Team System Problem accessing Performance Counters

  I'm running some load tests and I'm getting errors when trying to access SQL stats. I see several msgs like the following at the start of the run: Exception LoadTestCounterCategoryNotFoundException The performance counter category 'SQLServer:Access Methods' cannot be accessed on computer 'sqlsrvname (Category does not exist.) ; check that the category and computer names are correct. Needless to say, the computer name is correct and it i ...Show All

• Visual Studio Team System "Forcing rollback" error saving Work Item via API

  I get the following exceptions even though wi.IsValid( ) returns 'true'. Any idea what may be wrong here I looked at the data before performing wi.save( ) and all looked good. Any help will be appreciated.   ex {"TF26212: Team Foundation Server could not save your changes. There may be problems with the work item type definition. Try again or contact your Team Foundation Server administrator."}     [Microsoft.TeamFoun ...Show All

• Visual Studio Tools for Office Create a store and assign it a name (Outlook)

  Hello world! I would like to know how to create a store in C# and assign it a name other than Personal Folders. I try this: this.Session.AddStore("c:\\test.pst"); Now I need to change it name. Thank you very much! Hi, You can specify the name of the new store instead of the store path: e.g.: this.Sessions.AddStore ("Work Folders"); ...Show All

• Visual Studio How do I debug Web Apps on a remote machine ?

  Hi, I am trying to develop a web app that uses COM objects that only reside on a server where I cannot install VStudio. I have, however, installed .netFW 2.0 Beta and the remote debugging tools. Now I cannot find a way to tell VStudio to run the app on the remote machine when pressing F5. Is this by design The samples for remote debugging don't touch web apps, and the settings for web apps don't let me specify remote debugging. A little hint wo ...Show All

• Visual Studio Tools for Office Capture Word Document Keyboard events from Visual Basic

  Hai,    i would like to capture the altered text in the word document from the Visual Basic. Is there any way to do this                 Thanks in advance.   Bye.  Suresh. You have a couple of options: 1) You can use the Revisions collection of the ActiveDocument 2) You can use a smart tag (all keystrokes are captured, and you can hav ...Show All

• Visual Basic Using Namespace in vb.net is not as good as in c# why?

  I was wondering why ms decided to have the way they set up the namespaces differently between the language. c# when creating a new projects it adds the namespace to the code as well as the property. in vb it only adds to the property of the project and if you try to add it to the code it will create a double one. eg MyCompany.Application.Employee Namespace MyCompany.Application.Employee public class stuff end class end namespace calling the ab ...Show All

• Windows Forms User control properties : Drop down list?

  I have created several user controls, and I know it is easy to make properties of the control that the designer can show in the properties view. What I want to know, is how to make the property a drop down list or enum type value ...Show All

• Visual Studio Team System Synchronizing Predecessor Info between VSTS and Project

  Since developers will probably not look at MS Project and will look at VSTS, we feel that predecessor information needs to be captured for Tasks, since tasks frequently have dependencies. Hence, we added a custom field in the process template to specify task predecessors. However, the predecessor information specified in VSTS does not get synchronized with MS Project. Also in VSTS, the predessor info contains VSTS-ass ...Show All

• Visual Studio How to clip shape text?

  I have a shape text decorator position on the top center of the shape and if the text is longer than the shape width, the text does not clip. How can I make it clip and put ellipses at the end And also, there is an icon on the top left. Is it possible to make the text start after the icon so that they do not overlap Thanks. ...Show All

• Smart Device Development Picture Box / Image Button ?

  Hi, I need to create Image button for my CF 2.0 application. The PictureBox supplied with Visual Studio 2005 has click event. What is the difference in Look and Performance if I use PictureBox instead of Creating ImageButton Thanks, Vijay An ImageButton lets your specify two images, one for when the button is up and one for when the button is pressed down. A PictureBox is only supposed to display ...Show All