Michael J Brown's Q&A profile

• SQL Server Trying to Populate a Name Column

  I am trying to update a name column in the following way: (I wrote a description, but I think this visual is easier to understand). This is what I have: name1 name2 address etc Bob null 123 street Sue null 123 street Jack null ABC circle This is what I want: name1 name2 address etc Bob Sue 123 street Jack null ABC circle I'm just trying to get 2 names on the same row if they have the same address and get rid of the spare row. Name2 is currently null. Seems simple enough but I don't know how to do it in SQL. I can do it in FoxPro, but that doesn't help me here. Thanks for any ideas. ...Show All

• SQL Server Soulotion for the problem

  Becouse no one has written the answer here yet, I'll do it: browes to the site folder, then press properties on app_data directory. go to security tab, and press Add. then press Advanced, then press Find Now, choose the ASPNET user, and give him full control. thats it. For what question Seems that you did not reply to the message, you created a new one. Please post the message Url here, we will merge the thread to the actual question. ...Show All

• SQL Server How to pass database and server info dynamically via code vb 2003 with sql 2005

  I am calling reports via url and also using the reporting services 2005 asmx webservices render option to download the report stream. How to pass the database information dynamically for a report, when i created a report project i gave the server, db and username and password info. But i have 4 sites all of the sites are identical but using different databases, databases are also identical. i don't want to create 4 different identical report projects is it possibel to pass the server, db, user, password info via code. Thank you very much.   IMO, passing user credentials around is an invitation for a sleazy hack. Instead, consider: 1. Using a private data source with an expressi ...Show All

• Software Development for Windows Vista Where did the support for the Summary property page go?

  We have developed an application that uses compound documents and the summary info property set. In Windows 2000 and XP, there is a "Summary" tab for our files when you select Properties in Explorer. This is no longer available in Vista. Is this by design Can we reenable it somehow We are testing on Vista RC2. It used to work in Vista Beta 1 (or maybe it was Beta 2). In that version you also got information in the Details pane in the Explorer. /Thomas Ben Karas has now answered my question of where the properies went in Vista. See the comment section of this post . ...Show All

• Software Development for Windows Vista How to get the list of Running Instances?

  Could you please let me know if there is any way to get the the list of Running Instances and their Type without using the Tracking or the Persistance Service Just something as simple as RunningInstancesCollection ic = WFRuntime.GetRunningInstances()! Thanks 1°WorkflowRuntime::GetLoadedWorkflows() returns a ReadOnlyCollection<WorkflowInstance> 2°You loop through all instances , and for each instance you call: 3°WorkflowInstance::GetWorkflowDefinition()::GetType() Hope this helps Serge ...Show All

• Visual C# TAPI 3.x C# use problem

  I need to use TAPI in C# but something is wrong. First I add TAPI3, Next Ide generate Interop.TAPI3Lib. So I create some code after. It's hard to me. Some method arguments changed by IDE generated lib. I have Problem in Config dialog part. Code is given bellow; ---..... public ETInfo(TAPI3Lib.ITAddress ActITAddress, IntPtr hWnd) { TAPI3Lib.ITAddress pITAddress; TAPI3Lib.ITLegacyAddressMediaControl2 Mcont; TAPI3Lib._RemotableHandle Han=new TAPI3Lib._RemotableHandle(); pITAddress = ActITAddress; Mcont=(TAPI3Lib.ITLegacyAddressMediaControl2)ActITAddress; Han.fContext = hWnd.ToInt32(); Mcont.ConfigDialog(ref Han, "comm/datamodem"); } --- ...... When I try to execute Form button & ...Show All

• SQL Server Hi Greg , Any Solution for Alter tables on publisher and subscriber end as well ....?

  Hi Greg Y and seniors ones, I am working with replication on sql server 2005 (standard edition sp1).There is scenario that some time one of the team of coders want to alter objects mostly tables being replicated on publication database but unable to do that due to error on adding column "Cannot add columns to table 'table1' because it is being published for merge replication.." in sql server 2000. While other one want to alter replicated objects on subscriber end (like name of objects, add columns in replicated table etc). We was working on sql server 2000 and for implementing this scenario I always use mechanism disabling/reconfigure the replication setup by the mean of long exercise. After that, In ...Show All

• Architecture Solution Design?

  I was wondering if anybody could give me a few pointers on designing a large solution. We have a rather large application written in a legacy codebase that we are rewritting from the ground-up in C# 2.0. One of the problems I constantly face is the fact that I would like to break things up into separate projects to group common things together but then I always face the problem of "circular references". Can some of you folks who are developing large applications give me some insignt in how you structure your solution(s) I have thought about having separate solutions, but that seems to defeat the purpose of having multiple projects in the same solution! Here's one example of a problem that I face. I want to segregate al ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 3D picking with the mouse combined with a moving camera...

  Hi all, I'll get right to the point. My camera is defined using the following code... cameraworld = Matrix .CreateTranslation(xplane, yplane, 0) * Matrix .CreateScale(zoom) * Matrix .CreateRotationZ(angle); view = cameraworld * Matrix .CreateLookAt( new Vector3 (0, 0, 100), Vector3 .Zero, Vector3 .Up); projection = Matrix .CreatePerspectiveFieldOfView( MathHelper .ToRadians(45), ( float )graphics.GraphicsDevice.Viewport.Width / ( float )graphics.GraphicsDevice.Viewport.Height,1.0f, 1000f); effect.View = view; effect.Projection = projection; I've also got code to allow me to place objects in the game world, after unprojecting the mouse points and finding the point of intersection with my XY plane. Only probl ...Show All

• Visual Studio Express Editions Copy, Cut, and Paste commands with any text box

  Hi Everybody, The following code can run in VB6.0 to cut a text: Private Sub mnuCut_Click () Clipboard.Clear Clipboard.SetText Screen.ActiveControl.SelText Screen.ActiveControl.SelText = "" End Sub Can any body please help me and suggest a corresponding code for VB Express I would be really thankful. Vishal you can use the textbox Cut method to cut the selected text, so be sure to select text in the textbox, then do a Cut() method call which will store it in the clipboard. Me.theTextBox.Select(0, Me.theTextBox.Text.Length) Me.theTextBox.Cut() Same thing also applies for copy and paste   Alternatively you could also do this to copy to clipboard: Clipboard. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Workaround to make XNA GSE work on Vista RTM?

  It is not supported of course, but since Vista is locked down and shipping, is there a workaround to install Beta 2 of XNA GSE on Vista Repro steps: On Vista RTM Install C# Express Launch XNA GSE Beta 2 When it is "registering templates", an error message about C# Express closing down appears XNA GSE Installation app errors as well, saying that something went wrong Installer reverses all the installation... Yes, as always, Vista is not supported on vista in any way right now. Anyways, to get it to work you could either run from an elevated command prompt, or what I neglected to mention, create a shortcut to the MSI, which will allow you to run as Administrator. Also no ...Show All

• Visual Studio Express Editions missing debug setting "start external program"

  Hi, now that I'm able to enter debug-mode I'would like to actually debug my DLL-project which is an MMC snapin-extension. To do so, the SDK-documentation tells me to edit the project properties, debug settings , select the radio button "Start external program" and enter the full path to mmc.exe However, there is no such radio button. =:-| Resetting all settings to default-settings via "Tools | import export settings" didn't help. Even worse, I had to re-enable "Show Advanced Build Configurations". Thanks for your help. Best regards, Holger. Ok. Good to know. So far I always trusted the documentation which is included in the Express Edition. ;-) Thank you. Regards, Holger. ...Show All

• SQL Server Changing ASP Application to use SQL Native Client

  I am attempting to change an ASP application we've got to use SQL Native Client instead of MDAC and running into a problem. If I use ODBC driver our application runs without problem, but if I try to use the OLEDB provider certain pages are throwing the following error: Item cannot be found in the collection corresponding to the requested name or ordinal. The pages that are not working are using ADODB.Command object to execute a Stored Procedure and populate ADODB.Recordset object. The error is thrown when I try to access a field (by name or index) in the recordset. I am using recordsetname(0) or recordsetname("fieldname") to access the data in the recordset. I have other pages that are working that use this same technique, ...Show All

• Smart Device Development regarding the storage of permanent values

  hi all, since i am new to C# programming , i had the following doubt . in J2ME there is RMS to store permanent values like game scores , settings etc . is there any option available in c# for smartphone . if not what are the ways we can store the permanent value . thanks sadiq hi WyteNite, thanks for replying . is there anyother way to save such that the value remains persistent . in java supported phones we have Record Store Management . is there any option like that . thanks sadiq ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Unfortunate Name: Shader

  This is probably a stupid question, but I'm going to ask it anyway. I've been programming computers for almost 20 years, so I'm not new to this, but I am new to 3d game programming. I downloaded RenderMonkey, and Nvidia FX Composer, and I see that really cool effects can be made with shaders...but the gap in my knowledge is...why, and when. I see that ATI has a shader demo where they take a flat disc and mod it into a speaker shape and then make it pulse like a real speaker using shaders. So...here's the question...is it more processor-friendly to make a flat disc and then shader it to the shape I need than to make model in the right shape in the first place In their demo, they take a flat disc and "shader" it to a speaker shape ...Show All