Tilfried Weissenberger's Q&A profile
.NET Development coarse exception granularity
I'm struggling with what I perceive to be a very coarse level of exception definition in the framework. Even though my example is related to a database, I think it's probably more appropriately asked here, since I think the issue is wider than ADO. If not, I'll repost in the appropriate forum. Doing the following, the same exception is thrown, though the error is actually two very distinct things. dim sSql as string = "" dim DS as DataSet dim adaptor as OleDbAdaptor = new OleDbAdaptor(sSql, dbConnection) adaptor.Fill(DS) throws System.Data.OleDb.OleDbException, with a message that says " Command text was not set for the command object." However, sSql = "select * from foo" where table foo d ...Show All
Visual Basic Copy Folder to new location
Help. I am trying to setup a sample application code I got from someone to copy a folder of a persons choosing from a dialog box, to a new location that is chosen from another dialog box. Currently this application works, but does something I don't want to happen. When the files are copied, it recreated the entire root structure to the folder instead of just coping the folder selected. Example: folder selected was c:\documents and setting\user\my documents\labels Copy to: c:\documents and setting\user\desktop The application created the file structure documents and setting\user\my documents\labels on the desktop instead of just the "labels" folder. Any insite would be grateful. The code at the top wi ...Show All
Visual J# Vj# control not working in IE 6.0.2900.2180.xpsp_sp2_gdr.050301-1519
we are hosting vj# control in IE which is not working in particular version of IE 6.0.2900.2180.xpsp_sp2_gdr.050301-1519 which seems to be the latest and greatest version of IE which we upgraded by isntalling it through the windows updates (both high priority and optional updates ). please advise how to make it work in the latest version of IE. pleas advise, Here is the sample code. homepage.htm <HTML> <BODY> <IFRAME name="leftframe" src=" http://www.google.com " APPLICATION="yes"></IFRAME> <IFRAME name="webwindowsframe" src="Page1.htm" APPLICATION="yes"></IFRAME> </BODY> </HTML> page1.htm <HTML> <BODY&g ...Show All
Visual Basic Passing a Byte Array to a COM object expecting a variant
I'm trying to pass a byte array to a COM object, SHDocVw.dll, which expects a variant variable. VB.NET won't let me do this. I understand that the variant type is no longer supported in VB.NET, and I have come accross several references to marshaling, but none that make any sense to me. Anyone have any ideas [my appologies, but as this is an urgent issue for my project, I posted this issue (sort of) on another thread with a subject meant to attract a different knowledge base - sorry for the duplication] Are you now getting the POST information on the web page If not, then take a look at the dissasembly (IL using ildasm) for the Navigate method and send me the declaration. "FName%3dJoh ...Show All
SQL Server Unable To Commit UPDATE CUBE via Excel VBA
Hi, there, I have a SSAS 2005 cube. I write enabled the fact partition in the cube. I can see the writeback table created in the relational database. Next, I run the Excel vba that performs writeback. I can write back but the writeback is not permanent. I know I need to commit the update transaction but whenever I tried to commit using ADODB's .CommiTrans, I got the following error: "Run-time Error '-2147467259 (80004005)'" The writeback fails at the commit statement. FYI, I have full control (Administrator) over the cube. What will be the possible causes Thank you. Regards, Yong Hwee Couple of things: Install SP1 of Analysis Services 2005. Try and find ...Show All
Visual Basic Time Zones / Time Formating
Hello all, I have a string with a Date and time, which looks like the following: Fri, 28 Jul 2006 15:26:40 +0200 Fri, 28 Jul 2006 15:26:40 -0200 Fri, 28 Jul 2006 15:26:40 UT Fri, 28 Jul 2006 15:26:40 EST... The +0200 says the time is UT+2, the -0200 says the time ie UT-2 etc.. I need a function, which will convert the time to UT time zone. The problem is that I don't know which one of them I got..:( Can anyone help me Thanks. Use the built in function: Dim TheUTCTime As DateTime = Date . UtcNow TheUTCTime . ToShortDateString () TheUTCTime . ToShortTimeString () TheUTCTime . ToLongDateString () TheUTCTime . ToLongTimeString () TheUTCTime ...Show All
Visual Basic Raise SaveFileDialog's FileOK event?
Let say my application have two buttons, button to open file and save file. When the open button clicked, the open dialog will open and let user select a file, after selected, user will need to click the save button to save the opened file to given (coded) location, I do not want the save dialog to open, instead, I wanted the file to be saved when user click the save button, is it I need to raise the FileOK event of SaveFileDialog or is there any other better way Thanks in advanced. Stephen, I have not used any of the previous versions of VB. But as NoBugz pointed out, just skip using the save dialog if you wish. Just save the path/filename from where you got it in the OpenFileDialog into a ...Show All
.NET Development How to Manage Transactions
Hello, I have 2 different class.Each of them inserts 1 Row in 2 different Tables in my DataBase. Means Class 1 inserts 1 Row in Table 1, and class 2 inserts a row in Table 2. Now I want both of the queries must be fired. If single query is failed to insert row there should not be the effect of other. So I need to User Transaction with my Connection Object. But how to Use it when my Both classes are Different. And I can not mix both queries into one class as per the structrural design of my Application Thank U..... Examples from MSDN 1. Using CommittableTransaction //Create a committable transaction tx = new CommittableTransaction(); SqlConnection myConnection = new SqlConnection(& ...Show All
Visual C# Lanch specific PDF documnet page
Hi...I have a 100 page PDF document. I need to lauch a specific page in that document. I can launch the document with: System.Diagnostics. Process .Start(PDFpath.....) but it starts with the first page on top. Help! and Thanks! There are some command line parameters that you can pass to the AcroRd32.exe program to do what you are looking to do. Try something like this: ProcessStartInfo pInfo = new ProcessStartInfo(); pInfo.FileName = @" <Path to AcroRd32.exe> "; pInfo.Arguments = @"/Apage= <pagenum> "" <FULL_PATH_TO_PDF> """; Process.Start(pInfo); Hope this helps. ...Show All
Software Development for Windows Vista Pan, Zoom Level and Print Preview buttons in re-hosted designer
Hi, I have implemented a re-hosted designer using the Workflow Designer Control sample as a basis. I am trying to get the 3 buttons on the right - hand side underneath the scroll bar to work in the same way that they work in Visual Studio. I can't seem to get them to fire any event - I have tried overriding in the WorkflowMenuCommandService. Does anyone here have any ideas on how to get them to work as this issue is really bugging me!! There must be a way to get them to work as if there wasn't they wouldn't work in Visual Studio!! Answer from my c olleague Sergey Chub : The user would need to implement IMenuCommandService .ShowContextMenu () to show the context menu for the correspondi ...Show All
Visual Studio Team System TF26000: Could not connect to the Team Foundation Server (UDF WorkItemWordsContains does not exist)
I am unable to search on the 'Description' field with the criteria as contains <search_text>. I tried to capture the actual SQL though Profiler and the query fails because it could not find the UDF 'WorkItemWordsContains'. I have myself confirmed that the UDF is missing in the related database. Can someone please help me in resolving this problem Is there anyway to create this UDF again Please note that the Team Foundation Server installation went fine without any errors. I have got TFS SP1 installed on the server. I have tried repairing the Team Foundation Server installation but it didn't help. I have both the application tier and the database tier on the same server. Sameer The UDF 'WorkItemWordsContains' w ...Show All
Windows Forms Viewing Desktop icons as thumbnails
Ive been trying to figure out how to view my desktop jpg's as Thubnails similar to the folder options of VIEW>THUMBNAILS. Preferably, I would like to leave most things on the Desktop as they are, BUT for images, I wish to show them as thumbnails or have the ability to have just that paticular image file shown as a Thumbnail, (BUT give the user the ability to view *ALL* JPGs placed on the Desktop to be shown as Thumbnails.) FOR EXAMPLE: I would like to right click on the JPG file (on the Desktop) and select "View JPG as Thumbnail, Tile or Icon on Desktop" BUT aslo has the option to "View *ALL* jpgs as Thumbnails, Tiles or Icons placed on Desktop" if the user so chooses. Any Ideas -:NOTE:- ...Show All
Visual Studio 2008 (Pre-release) serviceModel/Bindings error
I am testing a clickonce deployed, Internet app on newly installed Vista Ultimate and newly installed .NET 3.0, XP systems. The app tests fine on the development machine (XP, .NET 3.0) The error message is: An error occurred creating the configuration section handler for system.serviceModel/bindings: Could not load type 'System.ServiceModel.Configuration.BindingsSectionGroup' from assembly 'System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. (C:\Windows\Microsoft.NET\Framework\v2.0.50727\Config\machine.config line 102) Any ideas Thanks John Thanks Jeff Sorry, I gave you a bit of misinformation. I have resolved the .NET 3.0 + WinXP issue - it was an ...Show All
Visual Studio Tools for Office VSOT and word - bookmark, range, selection and fields
Hi I have been playing with action panel. I am having dificulty trying to insert text into the document itself. From the action panel I could search the database for the client and jobs. Then I want to insert the address into the main document and the attention name and salutary name. How do I specify the position in the document to place the text, is my main problem, first line for the name and newlines of each line of addresses. I had read about bookmark, range, selection and fields. I am at a lost as to how to use them. Am I in the right direction. Is there a simpler way or is there a simple example. I had gone through the wordcontrol sample and worddynamiccontrol. These are simple problems but I am stuck. I can create text boxes ...Show All
Visual Studio Start Page not functioning
I logged in as an admin and installed VS Pro 2005 on my machine. Everything looks good and seems to be working properly in the admin account. But when I log in as a standard user, the Start Page's Visual Studio Developer News area shows this message forever: "There is no content available yet. Content will be downloaded once a connection to the internet is established." Why is this I need to use my machine as a non-admin. Does anyone know how to correct this Yes, I see it's mapped to http://go.microsoft.com/fwlink/ linkid=45334&clcid=409 in Tools > Option > Environment > Startup. ...Show All