Steveiwonder's Q&A profile

• Visual Studio Print a report when it is hidden?

  How do you print a report/form when it's hidden I am using reportViewer and I don't know how to access the printButton. What I want to happen is someone clicks a button on one page, which calls the report page without the user knowing, and the report would automatically print, any printDialog. I know how to hide the form, just not how to have it print automatically. Any suggestions I figured since I figured this out I could share this information with anyone else who has this porblem. All you have to do is access the reportViewer_RenderingComplete event.. private void reportViewer1_RenderingComplete(object sender, Microsoft.Reporting.WinForms.RenderingCompleteEventArgs e) { this.reportV ...Show All

• .NET Development Selecting / Update records - Concurrancy

  I'm new to Visual Studio 2005 (Visual Basic). I'm an Oracle guy but I do allot of development in MS Access. I don't want to use ADO.NET's generic behaviour for record locking, etc. What I'd really like to do is to have the same behaviour as Access has where if a user changes a field, the database locks the record. I was wondering if you had any sample code that would allow me to set up a form that has a combo box on the top of the form where the user selects a record. Then the database fetches the row and displays the data on the screen. If the user changes the data, the form locks the record. What's the best way to accomplish this I've heard that this can be accomplished using transaction control but I haven't found any form / ...Show All

• Visual C++ Can not connect to a DDE server through a Win32 console

  Hi, I created a Win32 console to test the simple C code for Excel/Word DDE available in http://support.microsoft.com/default.aspx/kb/279721 . To make the code go through the compilation under VS 2005, I did minor modification on the original code. The modified version is list as below: #include "stdafx.h" #include "windows.h" #include "ddeml.h" #include "stdio.h" #using <mscorlib.dll> using namespace System; using namespace System::Runtime::InteropServices; // Declare the function that is exported from unmanaged dll (shell32.dll). [DllImport( "shell32.dll" )] extern "C" int _cdecl ShellExecute( int hwnd, // ...Show All

• .NET Development 64bit Office Interop ...

  Hi all I have some trouble with Office (Excel) Interop integration ... I have a x64 Windows Server System. I have some applications and they are written in C# 2005 and some of them use excel Interop. The applications wont run the Interop.Excel Code on this system. Error message: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154. I guess I need a 64bit Interop.Excel.dll. Am I right If yes, where do I find it Thanks for any comments! Best regards Frank Uray Hi all I have now tried to install Excel on the x64 server. It seams to be a joke but now it works ... I would say it cannot be the goal to install Excel on Serve ...Show All

• .NET Development Anyone has a solution about it?

  I have question here.I can access paradox database using c# with oldeconnection which has connectstring as "this.connect.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Application.StartupPath +@"\table;Extended Properties=Paradox 5.x;";",but I couldn't 't access a paradox database with password protection.Anyone has idea to solve it thanks in advance! " I believe that the password needs to be specified in the SQL statement. Below is an example: SELECT * FROM [Paradox 3.x;DATABASE=C:\MYDATA;PWD=ABC].[Table1#DB] ...Show All

• .NET Development RPC call

  How to make RPC calls to mainframe from vb.net That depends a lot on the type of software running on the mainframe. If your mainframe exposes RPCs, you can usually purchase software that makes the RPC available to a Windows machine as an ODBC call. You can then use ADO.NET ODBC provider to call the RPC. There are several 3rd party software packages that expose RPCs to Windows or more specifically .NET, but again, it all depends on the software your mainframe is already using. ...Show All

• Windows Forms Bindingsource.Filter fails

  When I filter a bindingsource that is the data source for a grid I get no records even though applying the same filter to a regular query gives the expected results. barCodeJobsBindingSource.Filter = "Job='" + sJob + "' AND Task='" + sTask + "'" ; this.barCodeJobsBindingSource.Filter = "Job='CS-3229' AND Task='201'" The grid shows nothing and this.barCodeJobsBindingSource.List.Count = 0 If I run Query Analyzer with SELECT * FROM barCodeJobs WHERE Job='CS-3229' AND Task='201' I get the correct number of rows. Any ideas Thanks! Paul If you bindingsource is bound to a DataTable try using the DataTable.DefaultView.RowFilt ...Show All

• Windows Forms Best Component for the job?

  Hi, I'm not sure if the header is the right one, so if it's confusing, I'm sorry. I come from Sun's Java world and don't know my way around the GUI programming in C# yet. When I want to display a tabular data structure in Java, I use the JTable object, which is suitable for any type of tabular data, and can be provided with a 2 dimensional array of objects that can be placed in the table using the toString() method, regardless of the data source that is used for that table. I'm trying to do something similar in c#, and I'm having trouble working with the DataGridView, which is simple only if you connect it to a datasource. I have a TCP server program written in c# that needs to display data about connected clients. I need to ...Show All

• SQL Server Having Problem with Report Parameters

  i am trying to generate a report based on 3 parameters age, location, ethnciity every thing works fine in data and layout tab, when i run the preview tab, it give me the option to input paramaters and then when i hit veiw report, it shows processing report.... (indefinite) time. i tried executing the query in data tab, it takes less than a sec. any ideas am i doing somethign wrong in parameters Yes, I checked it with the QAnalyzer, Profiler, ReportingServices Data Tab. everything takes less than a sec to execute the 15000 records. This is one thing i noticed now after some weird research. when i hit the preview tab and input parameters its not showing an ...Show All

• Windows Forms DateTimePicker focus on the day part

  I am building a form for rapid data entry with keyboard only. the second control is a DateTimePicker and as is it will focus on the month whenever the control gets the focus. I tryed to SendKey({Left}) in the Enter event, but it is not working right most of the time. Is there a way to make it first focus on the month part My mistake! It works fine if there is an event handler method that does something. BTW I am on .NET 2.0 Got it to do exactly what I wanted! Thank you much! ...Show All

• Visual Studio VS 2003 Webservice with VB 6.0 Com+ Dll Debugging problem

  Hello Mt Webservice use a interop dll VB 6.0 and i like to debug this DLL in the VB 6.0 IDE or better in the VS 2003 IDE but how i can do this. Thanks Roman Hi Roman, What kind of web service are you using Is it an ATL or ASP.NET web service Assuming that the dll is loaded in-proc by the the web service worker process, you can debug it by attaching the VS2003 debugger (from the Debug | Attach To Process menu) to this worker process (aspnet.wp.exe (on XP) or w3wp.exe (on Win2k3) for ASP.NET web service, or dllhost.exe for ATL) and select both .NET and Native in the sElect Code Type dialog. Once you are attached and assuming you have symbols (.pdb file) for your dll, you should be ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Second series (13 parts) of 3D XNA tutorials finished +flightsim

  Hi all -- I have finished porting my second series of tutorials to XNA final code! You can find it here: http://www.riemers.net/eng/Tutorials/XNA/Csharp/series2.php Some of the XNA concepts covered in this second series include: textured triangles, importing a Model and using a custom effect to render it, first-person camera positioning, basic 3D position updating mechanism, basic boundingsphere collision detection, point sprites, alpha blending, textured model loading with storage of its textures More basic stuff is shown in the first series. Readers are combining all concepts to build a basic, but working flight simulator. The code of my 3rd chapter (a detailed introduction to HLSL) has already been converted to XNA final code ...Show All

• .NET Development Use unsafe for win32 api even if data types are managed?

  I'm debating if the P/Invoke methods require me to use unsafe depending on how I declare the extern. I'm thinking not if the declarations for the externs already contain managed types such as IntPtr and Byte[] but I could be wrong. Does anyone know for sure Thanks in advance for your feedback. Oh.. would be helpful if I posted an example of one such extern, eh [DllImport("kernel32.dll", SetLastError=true)] private static extern Boolean ReadFile ( IntPtr hFile, [Out] Byte[] lpBuffer, UInt32 nNumberOfBytesToRead, out UInt32 nNumberOfBytesRead, IntPtr lpOverlapped ); I've seen examples where the extern used pointers for the lpBuffer parameter, but that seems to be only for if the extern is declared with pointers and not with byte[] ...Show All

• SQL Server SQL Server 7 seems to hibernate

  I am running SQL Server v8.00.194 on Windows Server 2003, Standard Ed. v5.2.3790 on a 3 GHz P4(Hyper-Threaded) with 1GB of RAM. I have a table with 325,000 rows with 60 columns averaging length=50. When I stop running queries for more than 15 minutes the server seems to hang or hibernate. Any ASP pages accessing the table will timeout, even with a timeout setting of 20 minutes. When I run a query directly from Query Analyzer on the server it takes about 3-5 minute and then the results are returned. Then I am able to run Query Analyzer or ASP pages and results are returned in a few seconds. After 15-20 minutes it has the same issue and stops returning until Query Analyzer is run on that table. Thank you for any assistance, Stev ...Show All

• SQL Server Log Shipping : Out of Sync

  I set up log shipping, after a while the log shipping pair in LogShip Monitor is out of sync. what cause this & how to solve this problems. thx After setting it up successfully, monitor what is happening. You can check out my blog on my share of experiences with log shipping at http://bassplayerdoc.spaces.live.com ...Show All