Cool Screen Name's Q&A profile

• SQL Server GetDate() in Constraint using user's system time, Stored Proc using Server's.

  All, I have a table that has a Default Constraint for setting a DateTime field. I have a stored procedure that calls data from the table where the date field is <= GetDate(). I performed the following test: 1. Called insert stored proc and checked date field for recently added entry by query window ( 2007-03-01 11:09:44.000 ). This matches my (user) system date and time. 2. Immediately call GetDate() from the query window (2007-03-01 11:07:47.727). I assume this is the Server system date and time. *note: These servers are on separate domains and therefore could have different system times. This causes my select stored procedure to NOT return the values I just entered. Any ideas on why this might occur Does GetDate() ...Show All

• SQL Server Proxy Class is fine when used in C# project but returns error when Used with SSIS

  My proxy class returns web service responses well if I use it in a C# code.  I compile it with CSC and put it in GAC to use it with SSIS. Then I get web service response with some field values populated with "Exception of type :{System.InvalidOperationException "' occured. Here is the part of web service response received by the C# program: Name Value Type mainAddress {Address} Address city Metuchen string cityField Metuchen string country USA Country countryField USA Country state NEW_JERSEY State stateField NEW_JERSEY State Here is the same objec ...Show All

• SQL Server Parameter in calculated member of MDX datasource

  Can you put a parameter in a calculated member I have tried: SUM({NULL:@ToDate},[Time Charged] )  -- Obviously doesn't work AND SUM({NULL:' + STRTOMEMBER(@ToDate, CONSTRAINED) + '},[Time Charged] ) The latter sort of works but I get an error saying that the @ToDate parameter has not been declared... but it has been because it is being used later in the mdx statement with success.  This leads me to believe that parameters are only injected for the select statement and not anything else. Is this true   Are parameters restricted to only where the designer lets you put them Based on this post I tried the following: SUM({NULL:STRTOMEMBER(@ToDate, CONSTRAINED)}, [Time Charged] ) However I received the following err ...Show All

• Visual C# Monitoring Suspicious System Time Change

  I'm at a lot as what to search for but heres my problem. The current application I am writing depends heavily on specified dates. The program will compensate for any computations it may have missed since it was last ran. So the program doesn't have to run continuously. Each time the main loop executes I store a LastTick DateTime into a database. So if the System Date is set back I can catch this. But is there a way to tell if the system clock was purposely pushed forward w/out quering a web service The problem arises if a user pushes his clock forward by accident or on purpose and runs the application (or if the application is already running). The app will think that it just hasn't ran in X days since lasttick and compute and store vario ...Show All

• .NET Development Delete a File on FTP Server

  I try to delete a File form a FTp Server. The example from the MSDN page not work for me. Here My example: Dim reqUri As String reqUri = String .Format( "ftp://{0}:{1}/" , "ftp://xxx.xxx.xxx/transfer/delta/input/test" , 21) Dim req As FtpWebRequest = CType (WebRequest.Create(reqUri), FtpWebRequest) req.Credentials = New NetworkCredential( "ftpuser" , "ftp_pass" ) req = CType (WebRequest.Create(reqUri), FtpWebRequest) req.Method = WebRequestMethods.Ftp.DeleteFile Dim resp As FtpWebResponse = CType (req.GetResponse, FtpWebResponse) The error is: The remote name could not be resolved: 'ftp' Thanks ! ...Show All

• Windows Forms multi column in table need add combobox

  hey me to 2 column( ex:id,code) in student table.Need Add ID,Code column this in Combobox help me thanks I use the following for a multicolumn-combobox: MultiColumnComboBox.cs using System; using System.ComponentModel; using System.Collections; using System.Diagnostics; using System.Data; using System.Windows.Forms; using System.Drawing; namespace Toolkit.Controls { /// <summary> /// Summary description for MultiColumnComboBox. /// </summary> public delegate void AfterSelectEventHandler(); public class MultiColumnComboBox : System.Windows.Forms.ComboBox { /// <summary> /// Required designer variable. /// </summary> private System.ComponentModel.Container components = null; private DataRow sel ...Show All

• Visual Studio Vs Studio 2003 Update

  Hi,I would like to know if I can get an update of Ms Visual Studio .NET 2003 like updating it to 2005.I got a genuine key,please someone answer me. there an upgrade option but you will still have to pay for the upgrade Either purchase the full version of VS.NET 2005 or download for free and install the Express editions of VS 2005. These are lightweight VS 2005 products which are aimed for hobbyists/students mainly. ...Show All

• Visual C++ How to avoid Busy Waiting?

  Hey everyone :) I wish to know how can I translate a "busy waiting loop" approach into an event driven approach Lets say I have a queue of tasks, whenever there are elements in the queue, a process has to treat these elements Now I do it like this: while(1){ if(MyQ.Size()>0){ My.Q.RemoveHead .... } } This approach causes the cpu to work on full load, even if there are no elements in the queue. Is there a way to avoid this loop and somehow to create an event driven approach. Something like OnQueueHasElements... Thanks in advance :) As I understand it you don't want your infinitive loop to hug all the cpu time. You said this approach "causes the cpu to ...Show All

• Visual C# Analog Clock algorithm?

  Hello, I have a lot of source code for how to create an anlog clock but i cant understand the algorithm, esp use of 'sin' and 'cos', so please any one can help me with a tutorial for the understanding of the algorithm, Thanks and regards I'll take this chanllenge... All these kind of algorithms draw lines from a point (center of your clock) with different length/width/color (hour arm, minute arm, second arm), towards different angle (different time). Assume your clock center is at (x,y), the length of the arm is r, and the angle is a, then you need to calculate a second point (x1, y1) so you can draw a line between (x,y) and (x1, y1) to paint a clock arm. If you have difficulties with 'sin' and 'cos', you can just use ...Show All

• .NET Development Why do we use XSD's?

  We are developing a 3-tier application and we are new to .NET , we need to know what is the actual benefits of using xsd's   IT URGENT Please!!!!!!!!!!!! Thanks in advance...........   By XSD, I presume you mean the W3C XML Schema Definition Language There are a number of reasons to use XML schemas, including: - To define a "data contract" between producers and consumers of XML data so that each knows what to do and expect. The tighter the data contract you can come up with, the simpler the code. For example, "RSS" is a very loosely specified XML format, so RSS aggregators have to do a lot of work to figure out what to do with different tags that may show up. If you have a tighter ...Show All

• Visual Basic Keyboard sendkeys

  Hello, In a windows Form I have two buttons : One to navigate on the Web The other one to send to the active page ( in my example : "google"), a string (in my example : "test".) I do not see on the Google welcome page the "test" indication arriving !. What is wrong Thanks for your help ! Public Class Form1 Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click mybrowser.Navigate( "www.google.fr" ) End Sub Private Sub Button2_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click My .Computer.Keyboard.SendKeys( "test" , Tru ...Show All

• Visual Studio Team System Documentation bug (I think)

  I've just spotted the following in the .chm file in a page entitled "An Overview of Database Build and Deployment": MSBuild /target:Deploy /property:TargetDatabase=UpdatedTargetDatabase;ConnectionString="Data Source=(local)\SQLEXPRESS;Integrated Security=True;Pooling=False" MyProjectName.dbproj This example demonstrates how to build and deploy the database project, overriding the target database name and connection string. I may be wrong but is that the correct target I thought it was "SQLDeploy"/ Thanks Jamie Jamie, thank you. The msbuild line is incorrect, the options now are TargetConnectionString, not connection string, etc. We logged a bug to fix documentation for thi ...Show All

• Visual Basic Problems with dataset designer

  Hi I am not really sure where to post this, so I will post here and see what happens - sorry if it's in the wrong forum! I am having real problems with the dataset designer in VS2005. I start a VB project, go to Add a Data Source, select a SQL Compact Edition database, and select some tables. I then go into the Designer, make a few simple changes (for example changing the field names in one of the tables, or changing the name of the table adapter) and the VB Compiler crashes - almost every time, certainly enough times to make this totally unuseable. I have VB2005 Prof installed with the SP1 Beta, with SQL Server 2005 SP1, and with the RC1 version of SQL Compact Edtion. I just cannot get ANYTHING done with this. I have reinstall ...Show All

• .NET Development .NET HttpRequest timeouts

  Hi, I am new to the .NET world and am having problems. I have create a simple HTTPWebRequest and am using the GetResponse method to see the result. However, this ALWAYS timesout. I have even downloaded the MS example and that app doesn't seem to have access to the web either. My browsers and stuff works .. do I have to explicitly give .NET accesss to the NET I am using Windows XP SP2. Many thanks, BinCoder. Problem solved. I had set IE up to use my little app as a proxy. I didn't release that the app would use the same proxy settings that IE had. So, setting the req.Proxy to null solved the issue. Thanks for all your suggestions. Regards, MArk ...Show All

• Visual Studio Team System cpt 7 fails to install - claims team suite required

  even though I run team suite studio, the install fails claiming team suite is required. note: i only run team client (unit test and coverage), no team server even though i have a license (as we use source safe) here is the visual studio info: Microsoft Visual Studio 2005 Version 8.0.50727.42 (RTM.050727-4200) Microsoft .NET Framework Version 2.0.50727 Installed Edition: Enterprise Microsoft Visual Basic 2005 77642-113-3000004-41771 Microsoft Visual Basic 2005 Microsoft Visual C# 2005 77642-113-3000004-41771 Microsoft Visual C# 2005 Microsoft Visual C++ 2005 77642-113-3000004-41771 Microsoft Visual C++ 2005 Microsoft Visual J# 2005 77642-113-3000004-41771 Microsoft Visual J# 2005 Microsoft Visual Studio Tools ...Show All