Michael Gates's Q&A profile

• SQL Server Concatenate Input Columns

  Hi, In my data flow taks, The Source data is coming from AS400 has 4 columns, I need to achieve the followings and require your help. 1. Generate a new column which will be combination of concating these 4 columns. 2. Need to add an extra row for Header & Footer. Please Help. Concatenation is achieved using the Derived Column component. Adding your own header and footer rows is a bit more difficult because they need to have the same metadata as the data row. For this reason, concatenate all columns together so as to make a single, very wide, column. You can then use the UNION ALL component to put your header, data and footer together. The header and footer will probably be created using a source script component ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Cannot debug content pipeline

  I am having problems trying to debug the content pipeline. Following advice in other posts, I put System.Diagnostics.Debugger.Launch(); in my processor code (in the Process method) to launch the CLR debugger. The just-in-time debugging window pops up, prompting me to start the CLR debugger. But when I do, I get an error message saying 'Unable to attach to the process'. I can't manually attach either the CLR debugger or Visual Studion 2003 (enterprise) to any managed process - like to Visual Studio Express or my game. It's going to be difficult to work with the content pipeline if I can't debug my code, so any suggestions would be greatly appreciated! Here's how I debug my content pipeline code: Downl ...Show All

• SQL Server Case & Nested table selection and errors

  hi Here are the two tables again. 1)PATIENT(PATIENT_ID,NAME,CITY) 2) DISEASES(DISEASE_ID,NAME) I am trying to select patient table as case and diseases table as nested to create an association model. i m getting following error. Disease table cannot be used as a nested table because it does not have a many-to-one relationship with the case table. You need to create a many-to-one relationship between the two tables in the data source file. i have created a relationship by dragging Disease_id from diseases table on Patient_id in patient table. when i am trying to select Patient_id as key, City as input, it is not showing disease_id to choose as a predict column. please suggest me if i am doing anything wrong i have ...Show All

• Visual Basic in my richtext box i need to load a ms word document file content

  in my rich text box control i need to load the msword document file my word document file contain but it is accepting onely a text file can any one help me Hii 'You Can Use this Sample it works With Me 'Where OpenFile Is the name of OpenFileDialog 'and rtbTopic is the name of RTB OpenFile.ShowDialog() Dim SR As New IO.StreamReader(OpenFile.FileName) rtbTopic.Text = SR.ReadToEnd OpenFile.Reset() 'Note :and you can Refine the files showing in the Open File Dialog to Show the *.doc only files by the following Code Sample OpenFileDialog.DefaultExt = "Document Files(*.doc)" OpenFileDialog.Filter = "Document Files(*.doc)|*.doc|Text Files(*.txt)|*.txt|Rtf Files(*.rtf ...Show All

• Visual C++ doubt regarding type conversions.

  Hi all, I have a small and confusing doubt regarding the implicit and explicit conversion. I know this is not related to VisualStudio, but just need ur help. I have the following code. double d1 = 10.456; double d2 = 10.156; If I have a long expression like this.. ling l = (d1-d2)*10*10; What should be the value of long supposed to be According to my knowledge, it should be 0.3*10*10 that is 30. but strangely I'm getting 0. Since it is an assignment expression, right to left associativity, it should be 30.000 implicit conveted to 30. I'm using VC 6.0. -- Pratap Because of the way conversion from floating to integer is done. That helps when you want to convert the range [x, x.5) to x and ...Show All

• Community Chat Is MS trying to throw away menu bar?

  In IE7, classic menu bar is disabled by default. In Office 2007, there is not menu bar at all. Also the traditional toolbar is gone. I can't find a way to create my own custom toolbar too. What's happening I know menu bar is very classic and not pretty, but it is one single place that I am 100% sure that I can get all the features from a program. I don't want to lose it. AndrewVos wrote: Why does anyone need a live preview Are you joking are YOU joking WYSIWYG is useful in any number of environments or scenarios. ...Show All

• .NET Development VB.Net Datatables and Identity Fields problem...

  ok im adding a new row into a datatable , the table on the database has an identity field. When the row is added the database updates correctly and i get a new value in the identity field as expected. What doesnt seem to be happening is the new identity value isnt being reflected in the datatable. When i query the table later on in the application theres only a DBNull value where the new ID should be. Heres the code im using to update the datatable, how would i make the new identity field appear in it Theres no obvious datatable.refresh method and its a pretty large table anyway, id imagine it would be a bit wastefull to have to reload it all every time i add a new record to it. is there a way to get the new identity value set in th ...Show All

• SQL Server DB_ID() Replacement

  In the BOL, it states to replace DB_ID() with a valid database name when the compatibility level is 80 or below. The original statement is: SELECT object_id AS objectid, index_id AS indexid, partition_number AS partitionnum, avg_fragmentation_in_percent AS frag INTO #work_to_do FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, 'LIMITED') WHERE avg_fragmentation_in_percent > 10.0 AND index_id > 0; I replaced DB_ID() as follows but none worked: DB_ID(N'pubs') pubs What should the syntax look like I tried to run the following and it worked for me: SELECT object_id AS objectid , index_id AS indexid , partition_number AS partitionnum , avg_fragmentat ...Show All

• Visual Basic Multiple Instanced Unmanaged DLLs

  In VB.net unmanaged DLLs are implicitly shared using "declare" and must be explicitly shared using "dllimport". Is it possible to access unmanaged dlls through an instance rather than as shared routines Currently, the API doesn't return anything about the array to VB. The array is completely contained in the DLL. I hadn't thought about returning the array to VB and letting each instance of the VB form have its own array. That would probably work very nicely. I'll try it out. ...Show All

• Visual Studio Express Editions Trouble downloading enu?

  When it is trying to download it, it says: The fowllowing items have failed to download. Microsoft Visual C# 2005 express edition - ENU I know it has nothing to do with my disk space. I have 5 gb of free space and im pretty sure i meet all of the system requirements. Can anyone help me I wouldnt understand why it would say it failed to download when as you stated you downloaded the iso image and it still produces the same error when installing after burning the image/mounting it ...Show All

• Smart Device Development Problem with OpenNetCF SoundPlayer/Player Classes

  Hello, I want to play a .wav file using the SoundPlayer Class(OpenNETCF.Media) and right afterwards a video file. The problem is that i cannot find a mechanism to control whether the .wav file is completed or not in order to start playing the video file so the video starts while the sound file is still playing. I didn't find any event in the SoundPlayer Class that could be fired when the sound file is completed and i didn't find also a property that holds the state (playing or stopped) of the file. The Player Class (OpenNETCF.Media.WaveAudio) provides the above event and property but takes a stream as an argument and not a file which i think is easier to handle than streams. Should i work with the Player Class and define str ...Show All

• .NET Development Internet Connection State

  How can i get state of internet connection (Online or offline) with C# Managed Code (No use Win API) You can use Ping class to ping some Uri like www.google.com ....... I hope it'll help. Best Regards, Rizwan aka RizwanSharp ...Show All

• Visual Studio 2008 (Pre-release) Good resources for advanced control authoring - where?

  I'm trying to write a custom control which will support templating in a similar way to an ItemsControl. My control is highly-structured as it presents a fixed hierarchical data set. I'd like to be able to support templates for specific lists that I'm displaying, in the same way that an ItemsControl has an ItemTemplate that allows the user of the control to supply the template for only this small part of the control, rather than having to create a complete template for the whole control. I'm having problems finding documentation and resources on how to do this, e.g. how does ItemsControl use its ItemTemplate All the examples I can find about templates show how to *replace* templates on existing controls, rather than how to author a control ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Infinite projection matrix

  Hey guys. I've the last couple of hours tried to implement an infinite projection matrix without succes. So I took a step back to see if I could even make some sense of the "normal" perspective projection matrix used by XNA. Normally I used the CreatePerspectiveFieldOfView() method to create the matrix. Here is what I've tried so far. What is XNA left-handed or right This code works but the view aspect is fu**ed up. Anyone who can clearify or better show how it's in XNA The infinite matrix that is. float Q = drawParameters.Far / (drawParameters.Near - drawParameters.Far); float yScale = 1 / ( float ) Math .Tan((drawParameters.CameraFov) / 2.0f); float xScale = drawParameters.ViewAspectRatio * yScale; infinite.M11 = xS ...Show All

• Microsoft ISV Community Center Forums I want to create a "search" engine within my Excel spreadsheet.

  'm the type of person that likes to teach myself, BUT i'm having difficulties understanding the VB manuals. i figured their would be someone out there that could break it down for me, possibly at a high school level. lol I have a spreadsheet that has many tabs. In one of the tabs it lists client names and information, approx. 260 lines, starting in cell A15 and continuing down so forth. I want to create a "search" feature/engine within this one specific tab that fuctions much like the new media player 11 search engine (as you type the name, the names begin to appear with all the info as well). i want the "search" feature/engine in cell A5, kept seperate from the rest, I have frozen the panes so the search engine doesn ...Show All