Brian Ph's Q&A profile

• SQL Server How To Load Periodic SnapShot Fact Table With SSIS

  I need help from you data warehouse / SSIS experts out there! I have a Transaction Fact Table with dollar amounts as the measurements. The grain is one row per transaction. I want to roll this up into a Monthly Periodic Snapshot based on 5 keys. I am having no problem where there is transaction data for each month. However, the problem I am having is - how do I gracefully insert the Monthly rows for the five keys where there was no activity in the transaction fact table - I am sure there is a slick way to do this with SSIS but I am definitely having a mental block on how to accomplish this. Any help would be appreciated! ...Show All

• Windows Forms It seams I found part of the answer my self :)

  Oh components, I am writing one of them since a week, too much, I know :)  The last think that I was not able to solve is how to make the component discover where he is exactly during initialization, in other words, on what form is bean placed, and in which project. I used a similar code in the components to discover the project in  ...Show All

• SQL Server Triggers

  I am working in a database which tracks arrival and departure times for all employees. I am trying to create a trigger to warn an employee that his/her entry record is outside the working standard hours. For example: if the employee arrives before 8:15 AM , the system needs to show a message requiring an explanation for the employee’s arrival before the standard arrival time. If the employee offers an explanation, the system accepts the entry as the arrival time. If the employee doesn’t offer an explanation, the system must refuse the entry and then enter the standard time ( 8:15 AM ) as the arrival time. The code below is n ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNABuild.exe seems to have a problem opening normally

  I just downloaded this, and I'm getting this error from the WinZip Self-Extractor: Ecrofirt, thank you for letting us know. I am not sure why you're seeing that error. Did you try to open immediately from the Web or did you save locally first And do you know why your machine isn't letting it create a new directory (e.g. you're running it from a network share or where you don't have sufficient priveleges to create a folder or from a burned CD) Brian Keller ...Show All

• Visual C# How to encrypt a string in C#

  Specifically, I want the encrypted string to contain only numbers and letters (no special characters). Thank you! Veneta - There is an encrypt method in System.Web.Security in the FormsAuthentication class. http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/frlrfSystemWebSecurityFormsAuthenticationClassEncryptTopic.asp You can also see another example here: http://www.codeproject.com/dotnet/DotNetCrypto.asp HTH, Karen ...Show All

• Visual Studio Tools for Office Changes to App.Config not propagating to runtime in Excel VSTO 2005

  When I change a connection string in my App.Config for Excel VSTO 2005 the change is not being reflected at run time or in the debugger. Where is the runtime App.Config being kept It's not in the bin or obj\debug... My version also prompted me about updating the value in the .settings file and on the dialog it appears to have been changed but if you turn on show all files and check the actual method in .settings you will see that it has NOT been changed.  It still picks up the value from the app.config file. ...Show All

• SQL Server Reports as asp.net

  Hi, i'm new in sql server 2005 technology and i have a lot of questions in my head. Can i create a screen with the reporting services as i can create it with the asp.net, i mean, can i design a screen with 3 combo boxes that conditioned the results shown in the linked report . Thank you Manuel There's no control in the Report Designer that is similar to the combobox or dropdownlist controls in ASP.NET. Your best bet would be to create your report and have its data driven by the dropdownlist controls from your ASP.NET app. Basically pass in what you need from your .NET app to your report. ...Show All

• Windows Forms opening a paticular cell in editMode when dg row is highlighted

  hiya, When the user clicks on a dgRow, I want to be able to be open the 5th cell (in editMode) of the selected dgRow.Ideally, I want the underlying datable to be updated if the user subsequently enters data in this cell and then moves focus to a different control on the winform.(I can do the update no prob, but I'm not sure which dg ...Show All

• .NET Development .Net Sockets - Client Unable to read what the server sent

  I use .NetSockets in my ASP.NET appliation to connect to the PABX. PABX machine is the server while my application is the client. My software connects to the machine and logs in successfully. It also sends messages which the PABX receives. But my application is unable to read any messages that is being sent back from the server. It stays there in the loop waiting. I have confirmed that the PABX does send information back. I have tried testing my application with a model server, for which I wrote the code and the programs interract quite well with each other even on different pcs. What could be wrong Any thoughts/ideas welcome. I use II ...Show All

• Visual Basic Problem while install VB .NET Standard 2003

  Hello, I'm trying to install Visual Basic .NET 2003 Standard on my Windows XP Home machine. Just after running the Setup.exe program, I get the following popup message: Command line parameters: /L language ID /S Hide initialization dialog. For silent mode use: /S /v/qn. /V parameters to MsiExec.exe /UA<url to InstMsiA.exe> /UW<url to InstMsiW.exe> /UM<url to msi package> The setup program then doesn't continue. How can I fix this problem Thanks in advance. I found the installer for VB 2003, it was located at [CDROM]:\Setup\setup.exe. I had no problem installing VB by running that file. T ...Show All

• SQL Server Error 8152: "String or binary data would be truncated"

  I've been working with a sample database that the company is using for testing purposes. I (we) did not create the database - it was sent over to us by another company. I'm still a rank newbie at working with MS SQL Server, though I've worked with Access and MySQL in the past. There is one table that contains bank information. At the moment, it is filled with information on imaginary (fake) banks. I need to change one record so that it contains the information of a real bank the company is using. The problem is, I am unable to touch anything within this table. Any attempt to make changes gives me an error prompt that reads "String or binar ...Show All

• SQL Server Merge replication fails

  Hi all, Finally snapshot is generated. Then i create a pull subscription (i am using merge replication). But after executing 193 actions it gives following error Line 1: Incorrect syntax near 'No_' Details are as follow. 1. The subscription has been marked for reinitialization. Reinitialization will occur the next time you synchronize this subscription. 2. Category:SQLSERVER Source:  IM66\WM_MSDE Number:  170 Message: Line 1: Incorrect syntax near 'No_'. 3. Category:NULL Source:  Merge Replication Provider Number:  -2147201001 Message: The process could not deliver the snapshot to the Subscriber. 4. Line 1: Incorrect ...Show All

• Windows Forms publishversion vs productversion

  I am not really sure about publishversion (in clickonce) and (application.)productversion. When do I use each one Should these be identical for application releases if I want to display version information under help | about, I think it would be preferable to use publishversion. Is this right How do I do this Am I supposed to manually set them to be the same Thanks Don't forget to add system.deployment as a reference or you will have 'Application' is not a member of 'Deployment' But indeed, this is not so handy, because it will not work while debugging. ...Show All

• Windows Forms Filling Data in DataGrid Row by Row

  I want to fill the Datagrid without defining any datasource. I want to check some condition and according to that i want to fill the row. Is there any way to do this Hi, you can add rows:             dataGridView1.Columns.Add("car", "Car");             dataGridView1.Columns.Add("color", "color"); and fill them with values:              dataGridView1.Rows.Add(new string[] {"Ford","blue"});             dataGridView1.Rows.Add(new string[] { "N ...Show All

• SQL Server SQL Locking up

  Posted - 12/25/2005 :  10:54:44       My ADO based C++ application works fine for sometimes 15+hrs just fine. Im using SQL 2000. All of a sudden I dont know what happens all update operatins and insert operations start failing with 80040e31, timeout expired errors. It seems as though the whole database is locked up. And after 1hr or sometime 2 hrs everything is back to normal without any intervention. if i intervene and i stop all my app services. i run sp_who and there are no connections to the database. I restart my application services and still have those 80040e31 errors come up ...Show All