Pparl0627's Q&A profile
SQL Server Select - 4 hours
Hi, I need to make a select getDate() subtracting 4 hours... How can I make it Thanks SELECT DATEADD(hh, -4, GETDATE()) -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 -- < ZopoStyle@discussions..microsoft.com > wrote in message news:4d9c1334-3210-4fbc-968f-2b55c4b6ec84@discussions.microsoft.com ... ...Show All
Visual Studio VS Common IDE Package failed to load
I have been using Visual C++.net standard version 2003 on a Windows XP Home. It has worked quite well, so I decided to upgrade to Visual Studio 2005 Standard to get additional features. I uninstalled C++.net and installed VS 2005 upgrade. Now I get the "Visual Studio Common IDE Package failed to load" error (5 times) on startup. I have looked through the posts in this forum, and have tried just about everything I could find to ...Show All
SQL Server Parameter Validation for Floats
Why is the validatation of parameters of type float not working properly. I keep getting the error: An error occured during local report processing. The value provided for the report paramter 'EstimatedAmount" is not valid for its type. Sure. I am using Visual Studio .NET 2005 with SQL Server 2005 Reporting Services. I have a report parameter called "EstimatedAmount" that I set the Data Type to "Float". The a ...Show All
Software Development for Windows Vista Beta 2 problems with any workflow & designer
Hello, I have a Windows Vista CTP December 05 machine on which I had installed the WinFX RTC CTP December, the Windows SDK CTP December, the Orcas VS Extensions CTP December and the WWF Extensions CTP December. All of them worked OK. I'm using the RTM Visual Studio 2005 Team Suite and RTM SQL 2005 Developer Edition. Now I uninstalled them in the reverse order and it seemed that the machine was clean. I could not see the the WinFX ...Show All
.NET Development Help getting started on serial comms
Hello All I need help in starting to experiment with serial port comms. I have a device ( a gas analyser ) that I would like to read the output from via the serial port. I dont know what data it sends so my attempts to read text and byte data have not been succesfull. It has a row of LEDs showing ppm ( part per million) . What I would like to do is emulate those LEDs on the PC monitor. Where do I start Thanks ...Show All
Windows Forms Flickering a lot
I am using tablelayout panel on a form.At run time,I add controls to it as well as rows..whenever i add a control..the whole table flickers..i dontt know why It seems to adjust hieght,width etc..maybe.. Generally,when there is too much flickering it is best to say this .SetStyle( ControlStyles .AllPaintingInWmPaint | ControlStyles .UserPaint | ControlStyles .OptimizedDoubleBuffer, true ); in the constructor of the Form. ...Show All
Windows Forms custom textbox that draws the Text highlighted when the control is disabled.
Hi folks, I have a custom textbox that draws the Text highlighted when the control is disabled. And here is the code snippet that I have used.However,the TextAlignment property does not change to center and right when property is set.It always seems to show the default alignment. public class txt:System.Windows.Forms.TextBox { public txt() { this.SetStyle (ControlStyles.UserPaint ,true); } protected override void OnPaint( PaintEventA ...Show All
Visual Studio Team System Beta2: Cannot create a Team Project
I am not able to create a new team project. I'm logged in as a domain user with local administrator membership. On the last screen of the wizard I get this Process creation failed with error: "Initializaton failed for plugin(s): "Microsoft.Pcw.wss"" Here's the log content: 04/22/2005 01:48:54.478 | Module: ELeadServiceMediator | URL for eLead web service retrieved as " http://syd-3rtest:8080/bisserver/EleadWebService.asmx " from the registr ...Show All
Microsoft ISV Community Center Forums DataGridView and ComboBox Column Problem
Hiii all I have a problem in DataGridView, and i need help. I use DataGridView has column its "column type property" is ComboBox ok..., i want to add items into every cell of type comboBox, i want to add items in a cell of type comboBox different from items in another cell. this line adds items in all cells of type ComboBox Column1.Items.Add( "value" ) please help me Thnx Hi, I'm just wondering wha ...Show All
SQL Server Proactive caching - Polling interval
Hi, If a cube partition is set to custom settings in Proactive caching, and setting only rebuild interval of 1 day in General tab and in the Notifications tab if scheduled polling with incremental updates and 1 day interval is given, what does that mean Does the polling setting bring only data into molap or does it do cube processing also If there is a polling interval of 15 mins with incremental updates and rebuild interval of 1 d ...Show All
Visual Studio Team System Team Project Creation Failed
I installed beta 3 server and connected. I then went to create the project "test3" which fails. Here's what i get (see below). I connected/logged in as administrator user on the team foundation server (TEAMSERVER) machine. Is this the problem Should i have logged in as tfssetup or someone else As a side note, i can't login as anyone (i've tried all of the users - i think) into my sharepoint site on the server now. Thanks, Ted Error Insufficien ...Show All
.NET Development Using and Calling method name
Hi, Is this possible to call method name dynamically here is some code to explain that. string modulename; string methodname; modulename = "Mod1"; methodname = getMethodName(modulename); myClass myobj = new myClass(); myobj.methodname(); I don't know my method name till I call the method. Method name can have paramters but that I can get from tables. So I need to call method which I can get at run time not compile time. How is it possible Tha ...Show All
Visual Studio Team System The DoNotCatchGeneralExceptions rule
The above rule documentation indicates that the rule should not be excluded, this is Ok in the case of a general Exception or catch being present without any other exceptions. The problem I have is that we have several Exceptions in place to catch the likly exceptions then a general catch(Exception) block at the end in case we have missed any exceptions. It is this general catch(Exception) that FxCop is complaining about. We cannot put a throw s ...Show All
Visual Basic oading folder in a treeview
how do i browse my computers folders, and able to drag and drop into a nother treeview which moves the file. Also im using FTP for the the web browser and eveytime i open the folder it opens a window explorers window, so instead of having a new window come up it keeps veiwing in the web broswer on the form ...Show All
Software Development for Windows Vista How to make a StateMachine which show the terminal user to see the status of Squence workflow
In my case, the second step is from a main table to entry a sub table, however, the main table page does not close. The system can keep this page and reentry into sub table by different option. (It means that, my workflow can go back last state). I think the we should use StateWorkflow to achieve the functionality. However, there a problem. I wish the follow a simple order processing which always from main table to entry the sub table, to show ...Show All
