fordguy67's Q&A profile

• SQL Server 101 convert does not convert?

  Hi, I am trying to convert a datetime to a date and get a rid of the time or set it to 00:00:00. I use the convert like BOL says will trunc the time, but it does not. I must miss something. See example bellow. The first formula should trunc the datetime as per BOL but it does not so I have to use the second formula which I feel is somewhat bad even if it works. I have the same problem on both 2000 and 2005. I am sure I missunderstand somet ...Show All

• Windows Forms Change cursor to hand on context menu

  Hi, How to change mouse cursor to hand on context menu Thank's Alexei Hi Alex, If you are usingVS2005 you coulld achieve your need. just put contextMenuStrip1.Cursor = Cursors .Hand; Regards Joy ...Show All

• Smart Device Development x86 native code support

  Hi, I have several solutions made for x86 targets with eVC4. I wonder if they can work with VS8... Hugs, Kleber Yes, VS8 supports x86 targets when you install CE5.0 or later SDK's that support the x86 CPU. The new platform will show up as a target in the wizards platform page and allow you to select the desired SDK. The VSD Team. ...Show All

• SQL Server Routine crashing of Visual Studio 2005 when running or editing SSIS

  We have found that it is common for Visual Studio 2005 to crash when editing or running SSIS packages -- from CTP versions through beta versions and including the release version. Of course we kept hoping that newer releases would become more stable, or at least more robust -- and now I'm hoping there will be a service pack, which might make it more robust Please consider this the bug report then -- this is all I know -- it very often cra ...Show All

• Windows Forms Am I doing this right?

  Hi!, I'm kinda new to .NET and I'm trying c# 2.0, I'd like to know if my approach on this is correct or not, please review: partial class Form1 : Form {     private Form childForm;     private Form1 holder;     public Form1( ...Show All

• Visual Studio Express Editions publish registry entries

  I am using Visual Studio C# Express and i want to know how can i publish my application's registry entries to make it automatically creates the keys on the destination PC. Hello Jassim, If you're using an MSI to install this application you can define the registry entries in the MSI itself and they will be created upon installation. If you aren't using an MSI you might want to just add some code in the project's main entrypo ...Show All

• SQL Server Migration Maint Plns SQL Server 2005 ==> SQL Server 2005

  Hello all, Has anyone been able to migrate a maint plan from one server to another and have it work I can do the migrition by doing a package export but when I go into the package on the new server and change the connection information I get a guid should contain 32 digits with 4 dashes error message. Does anyone know a work around Hi I'm having the same problem did you ever find a solution for it ...Show All

• Visual Studio Choosing Visual Studio 2005 DirectX Help Source

  Hi all, I have a little troubles setting up my VS 2005 help. I installed DirectX SDK April 2006 and every time I search for something by pressing F1, it brings up DirectX Managed help. Is there a way to set it to use non-managed DirectX help files instead As managed dx help is kind of a useless to me... Thanks in advance. LOL, I found this microsoft forum as useful as their help files :) ...Show All

• Visual Basic VB6

  Hi It's been a while since I've done any VB programming, and I need to get back in to it for work purposes. I've quite a bit of experience at VB 6 programming and have lots of code and examples that I need to use again. Is the latest VB development package backwards compatible with VB6 I'm sure all of these questions have already been answered so appologies for that. Thanks John VB.Net is NOT backwards comp ...Show All

• Visual Studio Tools for Office VSTO Excel Binding a dataset from a webervice

  Hello,  Can someone point me to some sample code on how to get a dataset from a webservice and bind it to a sheet via the code If the dataset is quite large is there a way to parse it out onto different sheets Thanks in advance. John To make a method on Sheet2 callable from Sheet1, make it a Friend method and use the Globals class provided in VSTO.  Code in btn_PostData will look like the following:1 G ...Show All

• Visual Basic entering default data into a database table record

  I am using vs 2005 and sql 2005. I am using a webform to insert records but I want to automatically add the current time and the user id in addition to the data that the user enters. Is it possible to do it with the detailsview control and hidden fields If not what is the best way to do this Hi, When dealing with default values its better to be specified in your table directly. You can dothis by editing yo ...Show All

• Visual C# about vs2005 ! give me a hand! waiting on line!

  vs2005 help！！！！ a textbox ，a button ， a sqldatasource ,a dataview when click the button execute sql: select * from authors where name=‘+textbox.text+’ the dataset returned list in dataview , just like c/s 。 I feel it very hard to contral sqldatasource, code is holpful 2! HI Thank you very much ! I solve it by myself ! that is very simple query interface , ...Show All

• .NET Development Installing SQL Express and .Net for IIS in Setup Project

  I have a web service that uses SQL Express. I have looked at web setup projects and Web Deployment projects. Under the setup project properties prerequisits I've selected .net framework 2.0,windows installer 3.1 and sqlserver 2005 express edition. After I run the install on a new virtural machine (clean) there is no asp.net available in IIS and sql express is not installed. How do I get these services installed durring my install proces ...Show All

• Visual Studio Express Editions How to set a date field to null

  I have a bound text box showing a date field and I can enter a date into this no problem and save the changes. I have spent the past two days trying to find a way to allow the user to delete the date i.e. set the field back to null! I have found several articles on the net but nothing that provides an answer or explains why something that should be simple should be so hard!! I guess what you're asking is, ...Show All

• SQL Server Microsoft’s SQL Server Version support

  Does anybody no where Microsoft publishes a listing of supported SQL Server versions with final support dates   Thanks, Dave Here you go: http://support.microsoft.com/lifecycle/search/ sort=PN&alpha=sql+server&x=8&y=10 Peter ...Show All