Maxhec's Q&A profile

• Visual Basic SQL round/decimal problem

  my problem is I'm not able to round my number to 2 decimals first my query was SELECT dbo.T_Employee.FirstName, dbo.T_TimeRegistration.EmpId, dbo.T_TimeRegistration.ShopDocCode, SUM(DISTINCT dbo.T_TimeRegistration.TotalTime) / 3600 AS "total time" FROM dbo.T_TimeRegistration, dbo.T_Employee WHERE dbo.T_TimeRegistration.EmpId = dbo.T_Employee.EmpId GROUP BY dbo.T_TimeRegistration.EmpId, dbo.T_Employee.FirstName, ...Show All

• SQL Server convert int to money without decimal and cents

  I am doing the following to change an int into money (I want the commas) but it is adding a decimal and 2 zeroes at the end: convert(varchar,convert(money,m.[FirstTier]),1) as 'First Tier', m.firsttier = '1583456' after conversion = '1,583,456.00' Is there any easy way to not have the '.00' Thanks. Note that PARSENAME returns unicode string so you need to be careful when using that expression in WHERE clause for ...Show All

• Windows Forms ComboBox Data Binding Question

  I am creating a "learning" app.  I have successfully connected to Sql Server 2000, created a  dataset containing a single table,  "mytable" with several columns.  I am trying to bind this  data collection to a combo box cboPlantId&nbs ...Show All

• Visual Basic read text

  I am making a program that will need to use a configuration file. it will be a simple text file. I need to know how i can tell it to use the text in a file as a value in a hidden textbox in my app. I am not taking a programming class, I am making this on my own for use in the school. I also would like to have an answer. The text file is just a single string. ...Show All

• Visual Basic Bad generic method overload resolution?

  Hi, I've come accross the following situation which seems to cause an infinite loop in the code: Public Sub ArgumentNotNull( ByVal argumentValue As Object , _ ByVal argumentName As String ) ' Check for null parameter If argumentValue Is Nothing Then Throw New ArgumentNullException(argumentName) End If End Sub Public Sub ArgumentNotNull( Of T As Class )( ByVal argumentVal ...Show All

• Windows Forms datagrid problem

  am making a datagrid in c# (vs 2003) and i wantto make a time colum (only time , not time and date) the problem is that when i add a time colum (using access (make a date/time field and using short time fromating)) the datagrid shows day and time but i don't need (don't want) day i want only houres how can i do that   thanks   You should be able to do it like this: // get the curr ...Show All

• Visual Basic Dragging the form without using the title bar

  I have a problem on my splash screen, i set the borderstyle to none. How can I drag the form without having the title bar. I am using Visual Basic Express Thanks. Forgetting the eccentricity of the toolstrip for a minute, I think you are saying that we set a timer when the mouse enters the form area, at each timer event check the mouse to see it is still over the form, and if it is and the left mouse bu ...Show All

• Visual Studio Team System TFS on Domain Controller?

  Can TFS Beta 3 be installed in Single-Server Deployment on a server that is also a domain controller   The documentation appears to suggest this is OK (in "How to:  Install Internet Information Services for Team Foundation Server") but I am having some permissions problems relating to asp.net "temporary asp.net files" folder and wondered if it was to do with the asp.net process account on a domain controller Kind regards, Ian I ...Show All

• SQL Server how can I add a unique key column to a table and generate its values automatically?

  Hi, all, I have a question about adding a unique key column to an existing table. what i trying to do is that: I have already created a table, now i wanna add a ID column to this table, and generate the values for ID column from 1 to the existing row number. How can I get this done Thanks a lot in advance for any guidance. Order is never guaranteed for a table, use ORDER BY to get the rows back in the order that you want ...Show All

• SQL Server MSDE SP4 install problem

  I attempted to install MSDE SP4 (file SQL2000.MSDE-KB884525-SP4-x86-ENU) on a WinXP Pro SP2 machine. Command used: setup SAPWD="ourpw" SECURITYMODE=SQL /L*v c:\MSDELog.log Install log shows successful install. MSDE appears to function properly, service starts automatically after reboot, etc. I can open and work with DB's with a freebie 3rd party GUI called DbaMGR2K, through which I have added the necessary DB user for ou ...Show All

• Visual Studio 2008 (Pre-release) Problem with ContentPresenter

  Hi All, I want to draw a TextBox including two Rectangles, one on the left and one on the right side. If I use the the ControlTemplate like: < Setter Property = " Template " > < Setter.Value > < ControlTemplate TargetType = " {x:Type TextBox} " > < Grid > < Border CornerRadius = " 2 " BorderBrush = " {TemplateBinding Property=BorderBrush} " BorderThick ...Show All

• Visual Basic Update tables with one-to-many relationship

  Hi All, Does anyone know how to update the primary key in tables with one-to-many relationship ( Customer has many Orders ). I use the code OrderTableAdapter.UpdateCustomerID(newCustomerID, OldCustomerID)CustomerTableAdapter.UpdateCustomID(newCustomerID, OldCustomerID)   It does not work. I can delete but not update. Thanks. ...Show All

• Visual Studio Team System Major Pain point with Pending Changes Dialog

  There is no select all/invert/deselect all  option.  I have been working on moving artifacts into VSTFS Source Control (Hatteras) all weekend and not having that feature has cost me at least 2 hours of checking or unchecking checkboxes. This is just a variation on the same technique using the keyboard, but in my own usage, i typically use the mouse to select the items i want to toggle the checkbox state on (click + shift-click, an ...Show All

• Visual Studio CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.

  I am trying to access a Crystal Report through an ASP.NET page.  The access works just fine until the page is refreshed.  Then I receive the following error: CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed. I have tried the push and pull methods.  I have read other posts that people getting this same error had success with datasets.  I get the same error.  I have checked permissions in SQL, IIS, and ...Show All

• Visual Studio Using NAnt RC4 to build .Net 1.1 Code

  Hi I am in a conversion project of Code from .Net 1.1 -->.Net 2.0 . 1. I am going to build all my projects with NAnt RC4 version and also with VS2005 to check the affected Areas. 2. I have both the Versions of my code in my machine, 1.1 and 2.0. 3. My requirement is to use NAnt RC4 version for building both my 1.1 and 2.0 code ad RC4 supports both. 4. I am able to Build both the 1.1 and 2.0 code with NAnt RC4. Here is my problem and ...Show All