bestin's Q&A profile

• Visual Studio Tools for Office How to do this in C#

  I am trying to create PivotTable in Excel using c# The full code for the funtion is as follows; public void stgPivot() { Xl.Application xlApp; xlApp = (Xl.Application)System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application"); Xl.Workbook wb = xlApp.ActiveWorkbook as Xl.Workbook ; Xl.Worksheet ws = xlApp.ActiveWorkbook.Worksheets["Sheet2"] as Xl.Worksheet; Xl.PivotCaches pch = wb.PivotCaches() ; pch.Add(Xl.XlPivotTableSourceType.xlDatabase,"Sheet1!R3C2:R28C9").CreatePivotTable(ws.Cells[8,3],"PivTab1",Type.Missing, Type.Missing); Xl.PivotTa ...Show All

• Visual Studio Express Editions No Export Template menu

  Hi, I use VS Express 2005 C++ (not the beta version). I cannot see the export template File menu options. I checked in the Customisation but there is no "Export Template" command in File Category. I try Import/Export setting to reset the setting to basic standard VC++ setting but it changed nothing. I read about difficulties to export from VC++ but at least I should have the greyed option, shouln't I What is this problem Thanks in advance ;) Daes wrote: Hi, I use VS Express 2005 C++ (not the beta version). I cannot see the export template File menu options. I checked in the Customisation bu ...Show All

• Visual C++ ML64, PROTO and INVOKE

  I'm trying to compile the following example code with ML64 version 8.00.40310.39 (I think this is the last version): ExitProcess PROTO :DWORD .CODE main PROC invoke ExitProcess, 0 main ENDP END But the compiler returns an error: error A2008: syntax error : invoke It seems that INVOKE is not supported in ML64, even though PROTO seems to be working, because OPATTR ExitProcess returns correct informations. According to INVOKE description, I would be rather optimistic about support the new FASTCALL calling convention in win64, because it seems that INVOKE is capable to pass the arguments to registers: Calls the procedure at the address ...Show All

• Visual Studio Express Editions Problem with array

  I have this code but it doen't work there is a problem on this huidigegeg = geg(i).Split(("|--|")) Somebody now how this come Dim huidigegeg(7) As String Dim teller As Integer Dim i As Integer Dim geg(i) As String Dim strGegeven As String Dim strAlles As String Dim intNr As Integer = FreeFile() FileOpen(intNr, accijns, OpenMode.Input) Do Input(intNr, strGegeven) 'strAlles &= strGegeven & vbCrLf ReDim Preserve geg(index) geg(index) &= strGegeven & "|--|" If teller Mod 7 And telle ...Show All

• Windows Forms Can't get images on toolbar buttons when running

  Hi everyone,  I have a VB.net application that has a toolbar with several buttons.  The first two buttons are the standard "save" and "print", with those typical images.  My problem is they show up and work fine in the form designer, but when I run the application the images assigned to the buttons do not appear.  Can anyone tell me  ...Show All

• Windows Forms extendeding the TextBox control

  I get the feeling we aren't supposed to extend the TextBox control very much because there seems to be a lack of functionality available that I want and cannoy find. Either that, or I'm looking in the wrong place. One things that I want to do is find out where the caret is in the text box because I want to implement an INSERT and OVERWRITE mode for the textbox. There are ways to see what is selected, but no way to see where the cursor position is. I also want to manipulate the text in the textbox through special input rules such as filler characters, right or left justification and letting data "fall off" the ends of the text buffers. ...Show All

• Software Development for Windows Vista DVD Subtitles

  Hi, Does anyone know how to configure the MPEG-2 demux to enable subtitles to be displayed from a ripped VOB file (we have a legitimate reason for this). I have spent a long time on this and it's driving me nuts! The graph is pushed from a network receiver filter which configures the Demux in CompleteConnect(). I am using pMPEG2StreamIdMap->MapStreamId(0xBD,MPEG2_PROGRAM_ELEMENTARY_STREAM , 0x20, 0x04); And tried various combinations of media types e.g mt.majortype = MEDIATYPE_Video mt.subtype = MEDIASUBTYPE_DVD_SUBPICTURE; mt.formattype = FORMAT_MPEG2Video; ... For some media types the MPEG-2 Video d ...Show All

• SQL Server How To Execute an Oracle 10g Stored Proc thru ODBC using VS 2005, for Reporting Services

  Good day! :-) Anybody who knows the syntax for executing an Oracle Stored Proc thru ODBC connection using VS 2005 for Reporting Services I am having a problem about this. I am using the ODBC connection because VS 2005 does not support Oracle Database 10g in its Oracle Database Connection feature (only 7.3, 8i, and 9i), that's y. While using MS SQL Server 2000, I never encountered any problem. But using Oracle Database 10g, I find it hard to call the stored procedures, an error is generated everytime. Please click the link below for the screenshots: http://www.geocities.com/vrcode2/oraError.JPG http://www.geocities.com/vrc ...Show All

• Software Development for Windows Vista Breakpoints not working

  I'm running the February CTP on WinXP SP2 and Visual Studio Pro. I'm running my development environment inside of a Virtual PC VM. The problem that I'm having is that I can create workflows fine, but breakpoints set up on a workflow activity do not work. I see the hollow circle with the warning when running in debug mode. Breakpoints set on the code beside code such as a CodeActivity handler work. I've looked at the other posts on the forum about the same problem, but the solution doesn't appear to be valid for my issue. I'm not running workflows from another library. I've built a console application and have the workflows in the conso ...Show All

• Visual Studio How can I grow windows form to size of crystal report

  I am using Visual Studio 2005 VB. I have a very simple program that calls a report of comments from a SQL database. Depending on the selection I want the windows form to change size to view all the data that is available. So if I only had three lines on the report the window would fit to those three lines but if there where 20 lines the form would be longer to view all 20 lines. I don't want a default size to be used it should change based upon how many records are returned. And I would imagine that if the records had multiple pages it would just maxamise the window and show the records. I am a nov ...Show All

• .NET Development payment integration using orbital gateway(paymentech) -- its urgent

  Hi All, Can anyone help me out in integrating payment server to my application using paymentech (orbital gateway). I have never worked with payment integration. Actually this integration is for when the user subscribes for something through my site, then he has to pay the amount to the merchant of the site. This has to be done using paymentech orbital gateway. Please help me. Its urgent. Awaiting for the reply. Thank you in advance ...Show All

• SQL Server Can't run reports in Report Builder

  I've followed the Adventure Works tutorial for Report Builder, but when I click Run Report I get this error message: Report execution error The report might not be valid or the server could not process the data. Input string was not in a correct format. ---------------------------- Remote GDI stream version: 10.0.1. Expected version: 10.0.1. Any ideas Hello I have a similar problem, but when I create a pivot table connecting to an OLAP cube in SQL2005. This does not work and I get an error message saying: XML for analysis parser: The lovalidentifier property is not overwriteable ..... If I change my settings from swedish to American En ...Show All

• SQL Server Can't Access Cube Templates

  Hello, I appreciate this is probably a noddy question but I can't find the answer in any of the normal resources. I'm working through Brian Larsons Business Intelligence with SQL Server 2005. Chapter 6 requires me to set up a Cube from a Template. I've chosen the Cube Wizard from the Project Explorer and then clicked next on the welcome page. Problem is when I select the second radio button (the option that indicates that the source is not a data mart) the chose template checkbox that activates the template drop-down is disabled. This obviously means I can't chose the template I need. I've continued with the book anyway ...Show All

• SQL Server debug

  Hello guys! I am trying to debug a sql procedure inside Server Explorer but I can seem to step into each line. When I run the procedure it doesn't stop in the breakpoint I set. By the way I am running in a client pc.. Please help guys! Are you trying to debug a stored procedure in SQL Server 2005 using VS 2003 That is not possible. Thanks, -Vineet. ...Show All

• Visual Basic Dynamically Changing Button Properties

  I am writing an application where I have a 5x5 array of buttons that I want to dynamically update some of the properties. I have created all of the buttons in the editor and have given then names that reference their position in the matrix (i.e. btnGrid11, btnGrid12, etc.).  Based on the button that a user presses, I would like to update the image that is shown. I would like to do this in a loop and the problem that I am running into is that I cannot figure out how to dynamically reference an existing resource.  This is an example of what I think the code should look like.  I was thinking that I could create a button resource ...Show All