Jaygboy's Q&A profile

• SQL Server SCD and populating dimensions and facts

  Hello, This is my first task in attempting to populate a fact and dimension table from SSIS. I have a Fact table Sales and dimension tables Customer and Location. The data I am getting to fill this structure is in one file. where each record contains the sales information as well the customer information and location details on the same row. I am using the SSIS to fill this structure by using the slowly changing dimension for the Customer dimension. I am filling the customer dimension by using the slowly changing dimension. If I have 2 records having same BusinessKey but each with a different first name, where first name is set as a ...Show All

• Windows Forms ToolStrips & Mirroring

  Hi WindowsForms use Gdi+ For drawing. But Gdi+ dosn't support mirroring like Gdi32 when window has WS_EX_LAYOUTRTL extended style. Now if ToolStrips draws with Gdi+ we can not use theme with WS_EX_LAYOUTRTL extended style. Toolstrips support RTL without Mirroring - the layout changes when you set RTL. There are bugs in this support in Beta1 mark ...Show All

• Windows Forms cannot open scheduled tasks on windows 2003 server

  hi all Everything was working fine until I installed windows 2003 SP1 on a windows 2003 server which is also a domain controller. After service pack installation was successful and the server restarted,i cannot open the scheduled task option in the backup.i tried to restart the task scheduler service but it is hanging.it doesn,t stop.i want to schedule my monthly backup but i cannot start the scheduled tasks. Before the installation of Windows 2003 SP1, I could open the scheduled tasks.i dont, know what went wrong. need your help Regards Fasahat. These forums are for posts containing programming questions on ...Show All

• Visual Studio Team System Problems with Debug and FxCop

  Hi All, Sometimes when I starts the debug process, it do not stops in my breakpoints. I do the same thing with all my rules, but sometimes all my breakpoints do not work in all my rules.... When it happens, I am forced to create a new project and import all my rules to this new project. It is not a good idea and I'd like to know why it happens and if there is a solution. It happenned 4 times up to now.  I am using fxcop 1.312 with Visual Studio 1.1 Regards, Marcelo. Hi Michael, Thanks... I really do not know how the name do not changed to 'Check', as all command in vb code. But, thanks God and You that you ...Show All

• Windows Forms Drag and Drop exception using design surface

  Martin, I have an application that I created that has a design surface. I am getting an exception when dragging and dropping a component on the design surface. The component is already on the design surface before dragging it. The exception locks up the GUI thread and it is not easily repeated. Here is the exception: System.NullReferenceException: Object reference not set to an instance of an object. at System.Windows.Forms.Design.Behavior.BehaviorService.AdornerWindow.StartDragNotification() at System.Windows.Forms.Design.ControlDesigner.OnDragEnter(Object s, DragEventArgs e) at System.Windows.Forms.DragEventHandler.In ...Show All

• Visual FoxPro can i just use sql to get this?

  date           transfer 20050101    200.00 20050103   -100.00 20050530     95.30 ... SQL to get： date         transfer          balance 20050101   200.00         200.00 20050103   -100.00       100.00 20050530   95.30            195.30 Wrong. See my previous reply. It might work but open to errors ( ...Show All

• Visual Studio Tools for Office Running a Word VSTO Project - What steps must be accomplished?

  Greetings! I have developed a Word VSTO Project based on a template: my Oracle Forms application launches MSWord and creates a new file from that template, with a custom actions pane and with a mail merge. It is working fine, but only in my PC. This feature must be shown in an important presentation and it must be installed in a colleague's mobile computer. Unfortunately, they have tried this afternoon and have not succeded! I would like to confirm what steps must be fulfilled in order to make it work! First, he needs to install Office2003 and the .NET framework in his computer. Then, he must give full trust permissions to the ...Show All

• Windows Forms Reading really BIG text file ~ 2GB. How to do it?????

  Hi. I need to read 2GB text file and then need to search on evey line the corresponding line (Like same ID number) in another 2GB text file. The 2 files don't have the same data order, that's why I need to search through whole the second file. It's impossible to do it the standard reading way cause it'll take ages! Do you have any clue h ...Show All

• Windows Forms Creating A Duplicate Check

  I am new to Visual Studio.Net... I have created a windows form application... I need to create a duplicate check so when a user inputs data that is already in the database it lets them know that the value is already in the database.. Can anyone help... For example I have a Social Security Field... If the user enters a SSN that is already ...Show All

• Windows Forms DateTimePicker and DataBinding, 2005EE, VB

  Hi all, I have a database with a date field. Automatically 'Details' insert it to a form like a DateTimePicker_Ctrl, bound to the field. The property Value is set to the today's date from VS2005EE. But unfortunely if I save a new record with the Navigator_Save_Button the DateTimePicker deliveres Null, so an error appears (Null not allowed, I need the date). Only if I select a date - not the shown today's date - the date will correct transferred to the database. The user should not need to pick up a date every time he enters a new record, cause in 99% it is the today date. What have I to do All other fields of ...Show All

• Visual Studio Express Editions Display names of computers on a network in a combo box

  I know that this must be posted somewhere, but I can't find it. Hopefully this won't make you mad as this has probably been asked many times: I need to display the names of computers within a network in a combo Box. I have recently restarted to do a bit of programming and I have forgotten nearly everything, so please excuse me if I don't know what you mean. It wont be OK in the 2nd one as when you would change the combobox1 it would clear the items in combobox1 thereby causing a another selectedIndex change because the currently selected item would now not exist in the combobox1. The reason I had put it ...Show All

• SQL Server Incorrect results from FTS on multiple columns

  I'm writing a FTS query which needs to search on two different columns. E.g. Table contains "Location" and "LocationDescription" columns. Both columns are FT indexed. The query also uses AND/OR operators to filter out the results. I found the following article which gives the solution to the same problem. Link: http://support.microsoft.com/default.aspx scid=kb;en-us;286787 Is this problem associated with SQL Server 2005 also Making a third column which hold data from first two column is the only solution or is there any other way to acheive better results Shailesh Patel... My database ...Show All

• Software Development for Windows Vista Virtual Folders Default List

  Do you have a default list of Virtual Folders that will ship with the OS.  Also within these Virtual Folders is their a way to find out their search criteria For example, I see you have "Albums" which I am assuming will list all music according to "Albums".  Is their technical information on what "all music" encompasses etc. Thanks. Virtual Folders are persisted in XML form. You can always open up a .vfolder file using notepad, you can see what the persisted form of a virtual folder is. In those files we specify: * The view information (under viewInfo). This includes info such as viewMode (detail ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. .X and multi uvs and texture layers.

  I have been using the Microsoft .X exporter for 3d Max and notice that it still doesnt support multiple uvs or multiple texture layers. This is very irritating for me and countless others. There are .X exporters made by third parties which support multiple uv sets, but not multiple texture layers per mesh. I have read that this is all because of X file limitations. My question is when will the Direct X 3d format support these two basic features and when will they be implimented in the Microsoft Direct X exporters Thanks for any information. I think this limitation is bec ...Show All

• Windows Forms Graphics question

  Ok my problem is with Graphics class //------------------------------------------------------------------------------------------------ private void Form1_Paint(object sender, PaintEventArgs e) { Graphics g = e.Graphics; g.DrawLine(new Pen(Color.Black), new Point(30, 30), new Point(30, 100)); g.Dispose(); } you see i declare Graphics g=e.Graphics where 'e' is the PaintEventArgs and then draw a line //---------------------------------------------------------------------------------------------- private void button1_Click_1(object sender, EventArgs e) { Graphics g = CreateGraphics(); g.DrawLine ...Show All