GreenSleeves's Q&A profile

• Visual Studio Getting the physical page total during Print Preview in local ReportViewer

  Hi all, Thanks for your time in advance.  I'm trying to get the physical page total in local ReportViewer print preview, as it's not always the same as the logical page total and I have my own page navigation control. Is this possible Cheers, Jeremy ...Show All

• .NET Development Excel and OLEDB: selecting a row by row number

  Hello, I'm using OLEDB to access Excel data, I want to be able to select a row by a row number. Is there a way to do it Thanks, Hi, Yes, I believe there is a way to do this. This is what I ran and returned a value: command.CommandText = @"select City from [Cities$] WHERE ID = 1" ; connection.Open(); string strCity = command.ExecuteScalar().ToString(); ...Show All

• Visual C# Detect Close via X button in Console App

  Good day, We have a VS2005 C# Console Application and are trying to detect the user closing by hitting the X button in the top right corner of the app. As you can see by the following code, we have tried hooking up a variety of event handlers, but in all cases the event handler never gets called. What are we missing Thanks in advance... static void Main( string [] args) { // get notification of close AppDomain .CurrentDomain.ProcessExit += new EventHandler (CurrentDomain_ProcessExit); //Application.ThreadExit += new EventHandler(Application_ThreadExit); //Application.ApplicationExit += new EventHandler(Application_ApplicationExit); //Process.GetCurrentProcess().EnableRaisingEvents = true; ...Show All

• Audio and Video Development How to query if we are in Pause state?

  API's provided by MFSession is very limited. I want to know whether the playback is in Pause mode (by MFSession->Pause()) or not but I can't find any API's to retrieve current status. The only method I can figure out is to listen MESessionPasused events and to "save" state. Is this the only way to achieve this Yup, listening for MESessionPaused is the standard way to do this. Here's another idea, though: You can obtain the presentation clock from the Media Session via IMFMediaSession::GetClock and calling IMFClock::GetState, which will tell you the state of the presentation clock. Two caveats: 1) While doing a state transition, the Presentation Clock's state will change a split second before the ...Show All

• SQL Server multiprocessors

  HI If the machine running SQL Express has multi-processors  (2) - does it have an adverse affect on it's peformance, heavens forbid - do we need to make any settings changes via the Enterprise Manager tool   Thanks bruce Hmm that might be the OS not being as smart as we would like, you could try setting the processor affinity (if its supported in Express which I can't remember right now). 60 MB does seem a little low, I'm testing a new sample against adventureworks right now and its using 1.2GB on my desktop with a single user... The memory usage is very workload dependent. If perf does not become more predictable try posting back. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. "Indie" Game Development on Xbox 360 and PC

  (This is my first (technically second, I commented on something else) post on these forums) Alright, as a high schooler looking to get into game development after college (or possibly even nixing the college and going straight in) I was wondering if Microsoft was planning on doing anything at all with the XNA Framework that would support low budget game development. How available will tutorials and books about the code be available How much money will the tools and such cost How easy is this code going to be to learn Will it be easy for people to test on PC and a (normal) Xbox 360 with this code I've questioned Nintendo (through their website) about whether or not they'd be supporting "Indie" development, and I was given an aff ...Show All

• Visual Basic Preventing main form showing before splashscreen closes

  Hiya, How do you stop the main form showing whilst the splashscreen is still open I've seen a few posts about this, but none that seem to work, well for me anyway! (Using VB2005) Many thanks John Thanks for that. On reflection it seems I'm really fighting against how the splashscreen and application startup works. I've put the initialisation code into MyApplication_Startup Sub and it seems to display the splash screen just right. Thanks for the code in the attached URL. It will be useful too. Cheers John ...Show All

• SQL Server Issue with DTS from Sql25k

  Hi everyone, I understand that this is an issue. Microsofts doesn't inform anywhere When you've got in your workstation both Sql2k and Sql25k clients and try to install the package for design dts 2000 from Sql25k then you'll not be able to re-start your Enterprise Manager from MMC. Appears this error: ProcessExecute@@YAXPAUHWND_@@PBG1@Z dynamic link library procedure start point is not founded (SEMSFC.DLL) Query Analyzer starts as usual, without problems but you lose your EM. TIA If you have both 2000 and 2005 client tools installed, you do not need the "SQL 2005 Compatibility DTS tools" installed. First, uninstall them. Then figure out what i ...Show All

• Visual Basic Excel Import problem. Columns with text and numbers return blank fields

  I have two columns of data and when the import gets down to the rows where the ID field has characters in it then the import stops pulling in the data from that field but the other column which is money keeps being retrieved. Dim MyConnection As System.Data.OleDb.OleDbConnection = Nothing Try MyConnection = New System.Data.OleDb.OleDbConnection( "provider=Microsoft.Jet.OLEDB.4.0; " & _ "data source='" & PrmPathExcelFile & " '; " & "Extended Properties=Excel 8.0;" ) ' Select the data from Sheet1 of the workbook. ''''''' Fetch Data from Excel Dim DtSet As System.Data.DataSet Dim MyCommand As System.Data.OleDb.OleDbDataAdapter MyCommand = New System.Data ...Show All

• Software Development for Windows Vista Unknown error in workflow1.xoml

  Hi, I've developed a loan application that uses workflow for business logic. Everything was working fine when an error occured from nowhere. The error in the workflow1.xoml file says " A namespace does not directly contain members such as fields or methods". on double-clicking, it takes to the xoml design mode. Please help. Hi, I'm using the Beta2 version. The solution consists of a sequential workflow project & a windows application. the code beside file i.e. workflow1.xoml.cs is : using System; using System.ComponentModel; using System.ComponentModel.Design; using System.Collections; using System.Drawing; using System.Workflow.ComponentModel.Compiler; using System.Workflow.ComponentModel.Serializatio ...Show All

• Visual Studio Express Editions Error message "non-generic method" using ObjectDataSource and GridView

  Here is my process: (all with visual web developer 2005 Express, April version.) 1.  create new dataset in the app_code folder, called interaction.xsd.  (right-click on the app_code directory and select new...) a.  Step through the TableAdapter Configuration Wizard. b.  Select the data connection (ManagementConnection String (Web.config) c.  Create new stored procedures d.  sql statement "SELECT Interaction.* FROM Interaction e.  new stored procedure names:  InteractionSelect_sp, InteractionInsert_sp, InteractionUpdate_sp, InteractionDelete_sp f.  Fill method: FillInteraction, Get method:  GetInteraction g.  Checked Create methods to send updates directly... h.  I now have Interac ...Show All

• Smart Device Development Deploying CABs to a device via ActiveSync using an MSI with installer class

  I'm trying to deploy CAB files from my application to a device using a MSI project using ActiveSync. This method requires the CAB and ini files to be in a sub directory of ActiveSync. So I'm using an installer class to copy the CAB and ini files from the default c:\programfiles etc to the ActiveSync dir. The default dir is hard coded. This method is described in the msdn "Deploying >NET Compact Framework 2.0 Applications with cab and msi file" After a bit of tweaking this method works ok as long as the user does not change the installation folder from the default to something else. If this happens the installer class fails to find the cab and ini files and consequently the deployment fails. Is there any way of ...Show All

• SQL Server Detailed description on creating a dynamic excel file

  Is it possible that i can create a dynamic excel file (destination) ex, i want to create a Dyanamic Excel destination file with a filename base on the date this will run on jobs. Is this possible 11172006.xls, 11182006.xls Ravi G wrote: Jaegd, Not sure if that will work. I am working on a similar problem now. I am trying to load the contents of a table into an Excel file every week with a datestamp in the filename. I've tried a few approaches but haven't found a good solution yet. But here's what I found so far. 1. The first approach was to dynamically configure the connection string or filename property of the excel connection to generate a unique name every week. In design t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Can I play video files with XNA GSE?

  I'm not so much looking at writing a game as using this tool to develop some media applications, if possible. I've grabbed C# Express Edition and installed it, and I've watched a number of the C# tutorial videos. I'm going to have to learn C# - I've done Delphi, and Java, and some C ages ago - but I'm looking for something new, and this looked interesting. But I'm not sure I fully understand the limitations of this development tool/environment, particularly when it comes to multimedia capabilities. I like the idea of being able to target an application to a fairly well-known, easily available, consistent hardware platform. Having software that could run on an Xbox 360, with the option of using some of the Live facilities for information ...Show All

• Windows Forms Module msxml6.dll failed to register.

  I have a Windows Forms solution with many managed projects, and a few unmanaged projects. I have a deployment project that works, except that it gives an error "Module (app directory)\msxml6.dll failed to register. HRESULT -2147023782..." If I hit continue, the installation finishes, and the application works fine. How can I get rid of this error The MSXML6.DLL file does not appear in the list of files for Application Folder, although it is a dependency of one of my unmanaged projects. The target machine has the XML6 Parser installed, so I don't need Visual Studio to deploy that file. Dave I believe you should be installing MSXML6 with the proper redist: http://www.microsoft.com/downloads/ ...Show All