JPeterson's Q&A profile

• Visual Basic Excel Recordset

  Hi! I want to make a excel recordset with an sql comand but my "sheet" can have several names because i'm reading multiple excel files in a path. How can i refer to the active sheet in the select command What i have now, is: RS = CONN.Execute("SELECT * FROM [Name_sheet$] ") But so it works only if the name of sheet is "Name_sheet". Recordsets are ADO, datasets are ADO.NET are you trying to do this with VB.Net or an older version of VB. ...Show All

• .NET Development How can I save dataset as an xml file???

  Hi I am trying to save the dataset as xml file (one row from the table).Saving xml is fine but it look like the following (the below is flat xml file without root nodes and child node) But I want the data to go under xml Root Node, child node, children node and so on. My question is How can I save the dataset as xml file with Root Node, child node, children node and so on Please help !!! Urgent!! < xml version="1.0" standalone="yes" > <MS> <SDLTID>1</SDLTID> <UTRN>303783jMJ</UTRN> <TransPropertyType>01</TransPropertyType> <TransInterestCreated>FP</TransInterestCreated> <TransEffectiveDate>2006-04-05</TransEffectiveDate> and so on..... ...Show All

• Visual Studio Team System Migrate data from TFS Beta 3 Refresh to Released version of TFS

  I need to get all of my data for a specific Team Foundation Server (TFS) project out of a Beta 3 Refresh instance of TFS and into a Released version instance of TFS that is on a completely different network and server. Is there a guide/blog/post out there that would explain the correct steps to take to do this or can anyone advise on the best approach Thanks much, Andrea The only route we support to do that is to upgrade the server from beta3 to RTM first (there were schema changes, so you can't just move the data) and then do a "restore-based move" to the different network/server. ...Show All

• Software Development for Windows Vista Disabling autoplay

  I have one problem when my removable disk (which doesn't have a file system but only drive letter) is attached in Vista. (Especially in home basic edition) Whenever the removal disk is attached, one explorer popup comes asking for format. Is there any API function to programmatically disable/enable this behavior Similarly is there any control panel option to control this behavior Hi, Thanks for the reply. From the debug traces I got thru' WinDBG, it looks like the event is neither autoplay or autorun but arrival of a new volume mount point to the system that causes explorer to make an attempt to open the mount point. Since the volume doesn't have a file system, the message 'do you want to format'... is popped up by the win ...Show All

• .NET Development Help with CLR Profiler

  I have been asking a different question previously on this same project, but I have two different testing approaches I'm using. The second one is attempting to use the CLR Profiler to gauge memory usage and method calls. However, the problem with this project is, the entire project, which runs from a DVD for production, is initiated by a COM object before calling the .NET application. Consequently, I've tried to run the profiler from the beginning, I've tried initializing the app and then starting the profiler, and I've tried setting the working directory to my hard drive in case it is for some reason trying to cache to the DVD (which wouldn't work). The profiler is not working with this application pretty much at all. I could sure use ...Show All

• Visual Studio Tools for Office ImportXML hangs in VSTO application

  Hi, We have VSTO application for excel and using Oracle DB as database. Now for one requirement we need to insert data into local MSAccess file. For doing so we are using importxml facility of dataset as follows: Access. Application accessApplication = new Access. Application (); accessApplication.OpenCurrentDatabase( MSAccessDataManager .LocalDBPath, false , MSAccessDataManager .LocalDBPassword); accessApplication.AutomationSecurity = Microsoft.Office.Core. MsoAutomationSecurity .msoAutomationSecurityLow; string filePath = localFilePath + \\AD_RESIDUAL_PRODUCTS.xml ; dataSet.Tables[ "AD_RESIDUAL_PRODUCTS" ].WriteXml(filePath); accessApplication.ImportXML(filePath, Access. AcImportXMLOption .acAppendData) ...Show All

• Visual Studio Team System unixUserPassword 566

  Hi! Since loading the R2 Schema in our production forest, we are experiencing multiple Audit Failure 566 events from users AND workstations against the unixUserPassword attrib on Users and Group objects. Since we upgraded from 2000 - 2003, we have anonymous logon, everyone and auth users in our Pre-Windows 2000 compatible group (which still has read access to every object/attrib in the domains). I have verified that one of the error generators has read access to the specific object/attrib. This is occuring in other (maybe all) Domains within our Forest. Currently, we are not using this attrib, so it is blank/not set. Obviously, the security event log on the Domain Controllers is the source of the event. So, any pointers ;-) Thanks G For Ex ...Show All

• Software Development for Windows Vista "A network error occured while attempting to read from the file... drvupdate-x86[1].msi"

  Hello, When Iattempt to install the Windows Mobile Device application (the Vista version of ActiveSync, the steup goes half-way through the "Gathering required information" part, and then reads: A network error occured while attempting to read from the file: C:\users\Alex\Downloads\drvupdate-x86[1].msi Since I'm new to Vista, and using the Enterprise edition, what is the solution to this issue Is it not compatible with Vista Enterprise Thank you, Alex Hello Alex Te., Since this is an installation issue, I would suggest posting your question to the TechNet Vista Beta Forums located here http://forums.microsoft.com/TechNet/ShowForum.aspx ForumID=722&SiteID=17  Also I wou ...Show All

• Visual C++ Learning MFC

  i want learn vc++ (1) Doc\View Architecture (2) Knowledge of MFC (3) DLL (4) COM\DCOM (5) Device Driever Can you please guide me how can i start. i am beginner. i have not much idea about vc++ specially MFC. which book/certification course will help me in this regards Regards Hemant Joshi hem_kec@yahoo.com You should consider reading a book, such as Programming Windows by Charles Petzold. See http://www.amazon.com/gp/product/157231995X/sr=1-1/qid=1155901766/ref=pd_bbs_1/002-5043776-5890412 ie=UTF8&s=books . ...Show All

• Windows Forms Webservice return: open a PDF

  Hi, I want to know how I can do for open a pdf in my windows form. I code in C#. The situation: In one of my webservice I send a PDF as return: response.contenttType="application/pdf"; response.writefile(filename); My pdf is save on the server. If I query my webservice in a web browser that launch Adobe and I can see my pdf. Is it possible to do the same things in a winform With the same webservice Thanks a lot for your help. Use a WebBrowser Control(shwdoc.dll) then navigate to the URL\location using axWebBrowser1.Navigate( \\servername\documents\filename.pdf ). You can also use the URL that allows you to request the PDF. ...Show All

• Windows Forms items list in combobox

  how do i specify the list of choices in the combobox A list of choices are dataset from database. Please help.   You can apply this by Using property panel or by codeing it. In property panel of your ComboBox you must set the DataSource property to your table in dataset (it's a simple browsing). Then set DisplayMember property to your Field Name that should display as a list.   P.S. If you need the coding way, let me know about it.   ____________________________________________________ May the God blessings be. LotraSoft Ltd. ...Show All

• Visual Studio Team System 0 error(s), 47 warning(s) --> Failed Compiling sources

  Hi! I have no errors, but the build failed Where can I set that option Thanks! Regards Simon release.txt Solution: Betting.sln, Project: Betting.csproj, Compilation errors and warnings BettingOfferGroup.cs(375,17): warning CS0168: The variable 'ex' is declared but never used Event.cs(481,17): warning CS0168: The variable 'ex' is declared but never used KindOfSport.cs(100,17): warning CS0168: The variable 'ex' is declared but never used Solution: Logging.sln, Project: Logging.csproj, Compilation errors and warnings Log.cs(16,18): warning CS1591: Missing XML comment for publicly visible type or member 'Interwetten.Web.Logging.Log' Log.cs(41,28): warning CS1591: Missing XML comment for publicly visible type ...Show All

• Visual Studio Tools for Office Type Mismatch error when using Find method in excel

  I know that I had posted this before, but no one responded and I still can't find the answer :(.... Can anyone help me out with this I'm trying to open an existing excel file, search for some text, write some text to the document, and save the document. Here is my code: Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); xlApp.Visible = false; String DocumentLink = "whatever.xls"; if (!System.IO.File.Exists(@DocumentLink)) { Console.Write("\t*DOES NOT EXIST*"); } else { Workbook wb = xlApp.Workbooks.Add(@DocumentLink); Worksheet ws = (Worksheet)wb.Worksheets[1]; Microsoft.Office.Interop.Excel.Range RangeOfText = (Range)ws.get_Range(" ...Show All

• .NET Development WCF Installation Error

  [08/29/06,16:03:00] ========== Logging started ========== [08/29/06,16:03:00] ===================================== [08/29/06,16:03:00] No language specified in ini file default to OS language [08/29/06,16:03:01] Set lang to 1033 [08/29/06,16:03:01] Pending Reboot Table state : Logging start [08/29/06,16:03:01] _________________________________________ [08/29/06,16:03:01] (, ) c:\641d25ecce0074d39296aa2498 ( ---- ) ( Tue Aug 29 16:00:47 2006 ) Delete [08/29/06,16:03:01] Pending Reboot Table state : Logging end [08/29/06,16:03:01] _________________________________________ [08/29/06,16:03:01] Logging property values [08/29/06,16:03:01] PROPERTY ProductName Microsoft Indigo Beta 2 Runtime [08/29/06,16:03:02] PROPERTY c:\dd5a351bb9df65c ...Show All

• Visual Studio Team System Working folder confusion???

  Hi, I have a team project A set up with a source control tree and one of its projects has a working folder eg. c:\workingfolder. I have team project B setup and created its solution and projects in c:\workingfolder. When I go to add the solution to source control it automatically adds the solution and project files to the source control folder whose working folder is c:\workingfolder in Team Project A. Whats going on with this... surely different projects can share the same working folder. Thanks Donal Workspace mappings are a 1 to 1 relationship. Each server folder can be mapped to no more than one local folder and each local folder can be mapped to no more than one server folder. However, ...Show All