Keehan's Q&A profile

• .NET Development Delete node in XML

  Hi, I am newbie parsing XML. I have the following XML: < xml version="1.0" encoding="utf-8" > <books> <book> <id>id1</id> <value>value1</value> </book> <book> <id>id2</id> <value>value2</value> </book> </books> My question is, how can I delete one of the "book" node and it’s childs Thank you! If you are using System.xml and DOM you can use removeChild method to remove a child and its content. See the documentation at http://msdn2.microsoft.com/en-us/library/system.xml.xmlnode.removechild.aspx ...Show All

• Software Development for Windows Vista Expense Reporting Demo (June CTP)

  Hello I am getting error when I am try to excute Expense Reporting Demo (June CTP) version. the error is "The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the <serviceDebug> configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework 3.0 SDK documentation and inspect the server trace logs." vijil : What kind of an answer is that You are MSFT and you answer a question with a question Well, here the answer: YES IT' ...Show All

• Visual Studio 2008 (Pre-release) "FOREIGN KEY SAME TABLE" Constraint

  Hi all, I have a table that self-references itself that contains items that are effectively a doubly-linked list. When i attempt to save one of the entities I get a FK Violation, because the rows are added one at a time and the ptr to the next entity doesn't exist yet. My question is therefore, how can I control the insert/update of these entities in order to insert the record with a null ptr to the next object and then update it once the next object has been inserted Many thanks in advance, DaveW I'm assuming that you are creating a list of items and trying to do SubmitChanges. If so, you can override the InsertMethod and do whatever you want. It will require some extra logic to check and see if the item being inser ...Show All

• .NET Development Update requires a valid UpdateCommand when passed DataRow collection with modified rows

  I m coding with VB.Net. I have a datagrid on my form with a dataset as its datasource. The dataset contains rows from a joined two tables: Feature table and Price table. Feature table contains the customers'features. It has the ID of the features, the date the feature was added, the expiry date, the employee who added it.... The Price table is a look up table that contains the ID,price, Code, description and name of each feature. So my SQLquery is: SelectFeature_ID,Feature_DateEfect,Feature_DateExpiry,Feature_Employe, Price_Name, Price_Code, Price_Name... The reason why I use that joined query is that I need to display all the columns on my datagrid including the values from the Price look up table. But I update only the Feature table wit ...Show All

• SQL Server Adding Row Numbers to Flat File Source

  Hi, I was wondering if it was possible to add an identity column to a flat file data source as it is being processed in a data flow. I need to know the record number of each row in the file. Can this be done with the derived column task or is it possible to return the value of row count on each row of the data Any help on this is greatly recieved. Cheers, Grant Rafael, Jamie, Thanks for both your posts on this matter. I'm looking into Rafael's suggestion at present and see that the only way to access variables in the data flow section is within the PostExecute phase. That problem with this is that it doesn't seem to update the variable as i move through the rows in the dataflow. Is this because of how SSI ...Show All

• SQL Server Virtual Labs - No Connection message

  A couple of us are trying to use the SQL Server 2005 Virtual labs at http://msdn.microsoft.com/sql/  .  We complete all the prelim steps successfully but when we click on "Start the Lab" we get a blank page with "No Connection" in the middle.  The clock ticks and the system thinks we are doing the lab.  How can we get a connection   or is the server down   or are there no available resources left Hi, I tried to send an email to majewett@online.microsoft.com but I got the following message: 5.1.2 - Bad destination host 'DNS Hard Error looking up online.microsoft.com (MX): NXDomain' Has the email address changed Thanks, Reza ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Game and GameComponent Feedback

  We've been combing the forums and the Connect database for bugs, feedback and suggestions around the application model. We still have a small amount of time to consider any other feedback you may have. So this is the thread that you post your latest likes or dislikes with Game, GameComponent, services, etc. Please scan the other threads before posting here, I'd like to just gather things that haven't already been discussed or reported elsewhere. Thanks! I think that the XNA Framework must include basic components, but useful, with the same philosophy that Windows forms.   I believe that an necessary component is a SceneGraphComponent, is as basic as it is it the Form class for Windos Forms. Matias ...Show All

• SQL Server Cannot add publication

  Hi! I have a strange error, when I try to create publication Msg 3933, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 1222 Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction. What is it P. S. The error arise with all types of replication. Hi Alexey, One possible cause is that you have server configuration option 'remote proc trans' turned on. Could you try to turn this option off and add publication again Thanks, Peng ...Show All

• Visual Basic how to hide a Process From (Process.start("",a))

  Hey All, I try to figure out how to hide the porcess when using process.start() .Cause,when invoke this method which takes in a .exe and an argument.They will produce a result by displayuing a html page in an IE.So how do i prevent the result from showing. Thanks For Helping. Yah..its still display the IE.I think i cant do anything cos the IE html page came from the server itself.So do you think i can prevent from automactically display it.Anyway,i try your code just now,its work by not displaying the loading page of the Knexus.exe. Thanks Again ...Show All

• Windows Forms Program Warning problem

  Hey, I found this really cool Example on The Code Project website that was a MS Word/Exel like program, and for the recent documents list thing I have to have this line of code: private static extern bool PathCompactPathEx ( StringBuilder pszOut, string pszPath, int cchMax, int reserved); I highlighted green the part that has the warning...Below is the warning and this warning wont let me run my project until it is fixed...: Warning 1: Method, operator, or accessor 'Notebook_Pro.Form1.PathCompactPathEx(System.Text.StringBuilder, string, int, int)' is marked external and has no attributes on it. Consider adding a DllImport attribute to specify the external implementation. What do I do to fix this T ...Show All

• SQL Server Determining what columns are all Null

  Does anyone have a suggestion for how to efficiently determine what columns in a table are NULL for all rows - Shean You could do something like below: select min(case when col1 is not null then 0 else 1 end) as col1_is_all_null , min(case when col2 is not null then 0 else 1 end) as col2_is_all_null ... from tbl ...Show All

• SQL Server SSIS bulk insert task

  i need to do a bulk insert for every csv file from a particular folder & i wish to do this programatically. i hav tried a "foreach" loop & using variables for the filenames but it doesnot seem to be working & i just cant figure out why !! Here are some links that should help, whilst not the Bulk Insert Task, the concepts are the same- Looping over files with the Foreach Loop ( http://www.sqlis.com/default.aspx 55 ) SSIS Junkie : SSIS: Enumerating files in a Foreach loop ( http://blogs.conchango.com/jamiethomson/archive/2005/05/30/1489.aspx ) ...Show All

• Visual Studio Express Editions Dataset and Crystal reports

  Hey guys ...I have a little problem and i need your help... Well i have a dataset that i fill from the oracle db .That dataset is modified by myself in the code.By modification i mean i have updated some of the cells values .Now i have to create a report using that dataset how can i do that .The problem is that i didnt make an external dataset by drag and drop from the data menu but manually defined it in the code .Now i need to access that dataset once the program runs and the dataset gets filled so that i can apply group by on the dataset and get some info on my crystal report....Please reply soon thanks alot ...Show All

• Software Development for Windows Vista Windows SDK Documentation

  Hello,   If you have the Windows SDK and Visual Studio installed, you can help me.  Please tell me if your Windows SDK documentation is integrated with your Visual Studio 2005 documentation.  Thankyou. Because mine isn't.  Assistance appreciated. I did a clean installion of Visual Studio on Vista RC2, and I installed the following additional items in the order shown. installed VS2005 sp1-KB918525-X86-Beta-ENU installed MicrosoftR WindowsR Software Development Kit for RC 1 of Windows Vista  and .NET Framework 3.0 Runtime Components installed Microsoft Visual Studio Code Name Orcas Community Technology Preview  – Development Tools for .NET Framework 3.0 - vsextw ...Show All

• Visual Studio Tools for Office Problem using ServerDocument.AddCustomization

  Ok, here's the situation. I am creating a system modeled closely to this: http://msdn.microsoft.com/library/default.asp url=/library/en-us/odc_vsto2005_ta/html/OfficeVSTOBenefitsRegistration.asp I am at the point where I am adding the customization to an uploaded word document. But I'm getting an error, and I can't make sense of the error, so I can't proceed to fixing it. I hope someone here can help. Here is the error I'm receiving (I've put this together in a catch, if you need the raw error, I can post that): An error occurred while saving the form. at Microsoft.VisualStudio.Tools.Applications.Runtime.IAppInfoDocument.SetDocument(String fileName, Byte[] bytes, FileAccess access) at Microsoft.Office.Tools.OfficeAppInfoDocume ...Show All