Quirk's Q&A profile

• SQL Server Programmatic generation of History snapshots with varying parameters

  When you call CreateReportHistorySnapshot it generates a snapshot of the specified report with only the default parameter values. How would I generate snapshots based on parameters specified at runtime I've done this before using a Linked Report. If you first call CreateLinkedReport() you can pass in the properties for the Report. Then Create a Snapshot of that. If that is not enough to get you going let ...Show All

• Visual Basic System.IO.FileNotFound

  A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll   This error occurs whenever I start my program - and it eventually crashes.  No other error present (VBX is busy). Using F8, the error occurs instantly and stops in the DIM section at : Dim FBD As New FolderBrowserDialog This routine works fine locationg the directory... I also have present Imports System Imports Sys ...Show All

• SQL Server Problem in executing Stored Procedure with temp table returns result sets

  Hi, we are facing problem in executing a stored procedure from Java Session Bean, coding is below. pst = con.prepareStatement("EXEC testProcedure ", ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); pst.setString(1, "IN"); // rs = pst.executeQuery(); rs.last(); System.out.println(" Row Number "+rs.getRow()); rs.beforeFirst(); while(rs.next ...Show All

• Windows Forms How to bind 2 columns of data table to one datagrid column

  Hi, I have 2 datatable columns, firstname and lastname, and I want to bind them to a single column of datagrid. How can I do this Also, if I want to do some formatting, like adding a comma (,) after the last name such that the datagrid column rows look like "LastName, FirstName" how can I do that Thanks, Create a new aggregate datacolumn and bind that to the datagrid   ...Show All

• Visual Studio Create CR in runtime in C#.net or alter a CR in runtime

  Like the subject says, i need some help, because i need a cr that changes over the time, diferent things will be "printed" on the CR so i need some help how to do a thing like that. Midet. Hi, I want to use crystal reports to make users able to design the report at runtime. Possibly creating new fields of all types available, modify existing fields. Do I have to purchase developer edition of Crystal reports XI to be able to use that ...Show All

• .NET Development Is there not one single example like this in the WORLD?

  Hi all, Examples are usually the best way to learn. So what I don't understand is why there isn't an example of what I need anywhere in the world! Or is there What I need is this: A *complete* (end-to-end) example of a database driven Windows application. It can not be based on datasets as they are slow and not built for object oriented programming, nor are they suitable for large applications. I need an OR mapper tool to help out. The exa ...Show All

• SQL Server 100% stacked bar chart labels not formatted as expected

  I have a horizontal 100% stacked bar chart. If I select Show labels and do not specify any format code, I get the integers from 0 to 100 (intervals of 20) displayed on the axis. I want to have them formatted as a percent, i.e. 20% instead of just 20. If I put P0 or p0 as a format code, the labels show correctly on the preview screen inside the chart properties window, but when rendered they are displayed as a power of 100 (2,000% instead of 20%) ...Show All

• Visual Basic Cannot open existing form in Designer HELP! - VB 2005 Express Edition Beta

  This is so aggravating because I'm sure it's a simple thing! Using the new Visual Basic 2005 Express Edition Beta. Created a project, form, controls, etc.  Worked great.  Love it, compiled perfectly. Saved everything, closed the program, went to bed.   Woke up, opened the project, but now CAN NOT open the form (form1.vb) in Designer mode!!  I can open the code, it's all there, exactly as I left it, but can ...Show All

• .NET Development .Net Framework 1.1 vs 2.0

  Hello all, I have been spending a good deal of time trying to figure out the implications of the .Net Framework 2.0.  Unfortunately, most of the resources I have found do a great job of talking around the subject, without really talking about it.  One of the most common statements made is that 1.1 was a Rapid Application Development (RAD) environment while 2.0 is more of a platform.  What does this actually mean to ...Show All

• SQL Server View Modify in Server Management Studio

  In Server Management Studio, when you right click on a view and select Modify , you get four windows on the right side in a vertical stack. The top is the view diagram. The second one down is the grid where the view design elements are listed, i.e. Column, Alias, Table, Output,... . The Output column is a check box and, if the design element is written to the view's output, there's a check in the box. When I look as some views, the very bo ...Show All

• Windows Forms How to : make sort types of DataGridViewColumn when click HeaderColumn

  Dear all, In my application have many types of DataGridViewColumn such as : Comboboxcolumn, MasktextBoxColumn (this type i customize), checkbox Column ... without DataGridViewColumn is make sort but other is not. Please help me my problem. Thank for your collaboration. Khiem Vo. Set the column's SortMode to Automatic. -mark Program Manager Microsoft This post is provided "as-is" ...Show All

• Windows Forms Why is VS 2003 Designer Mode so slow in loading some forms?

  On my forms with many (50+) controls it takes many MINUTES to load the form in designer view. The problem is magnified with forms using UserControl derived formss. I'm using a more than adquate system too. Is there a fix or a workaround to address this or at least improve it because it really hinders rapid development when you have to wait minutes each time the designer needs to be re-loaded, which is basically every time the header file i ...Show All

• SQL Server Upgrading mirrored databases

  I am in the process of architecting SQL 2005 HA options and of course mirroring is at the top of the list. Does anybody know what the requirements are regarding upgrading mirrored databases, for example, applying hotfixes and service packs Is it a requirement for the principal and mirror (and witness if applicable) to be at the same build level Is there any requirement to upgrade one first and then the other as there is with replication topologi ...Show All

• Windows Forms "File Open" Dialog Box

  Hi, I want to use a File Open Dialog Box to allow users to select a directory on our network where certain Excel and Word documents are, in relation to a person they are entering details for in my application. The File Open Dialog Box insi ...Show All

• .NET Development How do i obtain an MCSD

  I was interested in obtaining my certification in Software Developing and was wondering how could i get started on this particular event Hi Vikram, Can you please give the differences between MCAD and new generation certs like MCTS,MCPD. I think in MCAD or MCAD we have develop some applications using visual studio, is this the same case with with MCTS and MCPD Thanks in Advance Regards, Sri Harsha ...Show All