mm_ezzo's Q&A profile

• SQL Server Snapshots, DrillDowns, and Parameters

  I have several reports that are out on the report server to run a snapshot on a weekly basis. The snapshot is created using the default parameter values. When you go to view the report (the active snapshot) you can drill-down and see the data. When you change the parameter value and view the report, the drill-downs no longer work. It acts like it's going to drill-down but when the green bar at the bottom is finished, the same data is displayed without the drill-down. Is there some trick to this Some of these reports take a long time to generate and since the data is only updated on a weekly basis it makes more sense to use snapshots instead of having every report run on demand. Appreciate any help. Nancy ...Show All

• Visual Studio 2008 (Pre-release) Support for Group By, Having etc

  How sophisticated are the query capabilities for LINQ. Can a SELECT includes Group Bys, Aggregate Functions, Having Clauses. I have a sophisticated query which runs within the MS Access query designer, but running the same query using .NET OleDb provider results in an error. The query uses joins to selects which have group by and aggregate functions in them. The error message says there is an error in the Syntax after the From clause. So I'm thinking to return result sets back to VB.NET and use LINQ to further process the data into the final result set. The other alternative is use a lot more code to massage the data into the final result set which is going to be nasty. Actually LINQ doesn't a ...Show All

• .NET Development Accented Characters

  Hi, I have a question for accented characters. For example, when I am doing regular expression match, how can I match "A" against all accented characters "AAAAaaaaaaa" I have tried all possible options in RegexOption enum, but nothing works so far. I know in SQL Server full-text search you can setup accent insensitive, so I guess I can do the same thing .NET. Could someone please tell me how. Thanks, Ning You will need to break out all the characters you are interested in and place them into a set such as [A AAAA] to fulfill what you want to do. ...Show All

• .NET Development This Error Appears: Format of the initialization string does not conform to specification starting at index 0.

  I have saved the database connection string to a key named 'ConnectionString' allowing to access it by calling 'configurationSettings.AppSettings("ConnectionString") But a red line comes under the configuration in the part of the : 'configurationSettings.AppSettings("ConnectionString")'. When i run it this error appears: Format of the initialization string does not conform to specification starting at index 0. and says: Line 4: Public Shared Function GetCategory() As SqlDataReader Line 5: Dim connection As New SqlConnection(connectionString) Line 6: Dim command As New SqlCommand("GetCategory", connection) Line 7: command.CommandType = CommandType.StoredProcedure Line 8: connection.O ...Show All

• Windows Forms list box and datasets

  hey, how do you make it so that a list box shows the items on a dataset     Thanks :) Hey, ok after tying to figure it out, I took a break on doing that part of the program, I came back to it, but, I still can get it to do it from the form to the dataset, but I just realized that I should not do it thrue a dataset... becuase then how are you supposed to backup your bookmarks if you are going to do somthing that involves uninstalling the browser or doing somthing to your computer And that I need to make it a .html file like Netscape and Internet explorer do. I learned how to add column inside of a datesaet thoe :) So that helped a bit on somthing... But now the new problem: How do I make it so it stores it ...Show All

• Visual Studio Express Editions Visual web Developer 2005 Express edition configured with IIS

  Hello All, Is it possible to configure the WebDeveloper Express edition to make use of IIS when running, i dont want to make use of personal web server. If it is possbile can anyone provide me with the details of how to configure VS WebDeveloper Express edition to IIS. Thanks in Advance, Sriram 29. Do I need IIS to build applications with Visual Web Developer 2005 Express No. Visual Web Developer 2005 Express comes with a built-in Web development server that enables you to build and test applications without a dependency on IIS. The server only accepts local requests and is only for build and test. Web applications built with Visual Web Developer can easily be deployed to IIS or your fa ...Show All

• Visual Studio Visual Studio DVD Label

  Hello, I, know its an untypicaly question for this forum. I'm studying Science and we can download microsoft products for free at e-academy.com My question is, if someone could scan the labels for Visual Studio 2005 Pro, Sql Server 2005 Standard and SourceSafe 2005 perhaps someone has the time to do that :) greets from Germany! Dirk ...Show All

• Windows Forms Prevent datagridview showing glyphs when working with rows

  Hi @all! I'm currently working with the .NET 2.0 datagridview. I've overwritten the datagridviewrowheader class to display different icons in the rowheader. That's fine so far. But the grid still displays these glyphs in the background of the rowheader cell. With the property showeditinglyph it's only possible to disable the editing icon, but I don't want the datagrid to show any icons or glyphs. How can I disable this functionality in the datagrid   \Helmut   Hi Scott Row state is what you set in your class. See my example In my clinet page I double click to create new row . here is the code Private Sub dgvDocuments_RowHeaderMouseDoubleClic ...Show All

• .NET Development How to generate ADODB.dll from cdosys.dll

  I need to make MHTML from HTML. I searched google and found following link http://wiki.ittoolbox.com/index.php/HOWTO:Create_HTML_Multipart/Related_Email_in_.Net_Framework_1.0_or_.Net_Framework_1.1 sp=CM#Introduction which converts HTML to MHTML. It uses following code to generate ADODB.dll and CDO.dll C:\{path to project}\lib>tlbimp %systemroot%\system32\cdosys.dll /namespace:CDO But,When I am run the above command, I get only CDO.dll and no ADODB.dll is generated in the lib folder. I am using VS2003 and Windows 2000 . rticle clearly mentions to use ADODB.dll generated from above command. When I am using ADODB.dll shipped with .net framework, I get exception when html to be converted to MHTML gets big.Please provide some h ...Show All

• Visual Studio 2008 (Pre-release) Having serious issues with LINQ/VS2005/.NET Framework 2.0 and 3.0

  i decided to check out LINQ, so I downloaded .NET 3.0, WWF AddIns for VS2005, LINQ (May 06 RTC), AJAX Control Toolkit 1.0 and installed all of them. Then I downloaded the code for dropthings.com, compiled it, found a few issues because dropthings was written with AJCT RC and though the site would run, I kept getting this series of .NET 2.0 Error (I installed the site in IIS 6 on a W2K3 Ent Server): Event ID: 1101 .NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002 For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. --------- ...Show All

• Windows Forms Custom Menu's

  Hi Folks, I'm using MS Visual Studio with Managed C++ and I'm curious to know how I might go about trying to get Menu's that look similair to the fancy ones in MS Outlook 2003 Any ideas -Zero There's no "out-of-box" control in VS2003 to do this as far as I know. You can play with DrawItem/MeasureItem events in order to customize the painting, but in VS2003 this functionality is not provided by default. ...Show All

• Visual C# Modify form attributes of the main app from extern class

  Hi to all, I've this little problem that I can't resolve from my own, in a windows application created using VS2005. As you know I've a principal class, called program.cs, where the main create and launch the principal form application, which class is called form, as this code: static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new Form()); } Now, I've another class called Thread, that I create and run from the Form class. In this Thread class, I want to execute a method that add object to one listbox in my Form. I've created a public method in Form class but I can't call it from the Thread class because I don't know the name of the instance ...Show All

• Visual C# Passing Message from unmanaged dll to C# windows service

  Hi all, I have an unmanaged dll written in VC++ 6.0. I want to pass my custom messages from dll to C# application. C# application should retrieve this message from its message queue. My problem is that i want to run that C# application as Windows Service without UI and i need a mechanism of Message loop without UI so that i can receive the messages posted by the dll inside that service. Thanx. Rashid Mahmood Michael: Your idea in using a COM server in the C# service is a good idea. One problem I found in .NET Framework 2.0 is that the "Register for COM Interop" in the project build settings is greyed out or disabled. To get around this peculiar issue, I manually register the COM components with " ...Show All

• SQL Server Fail to execute store procedure in OLD DB Source in Data Flow

  Hi. I am trying to extract the data returned from a store procedure to a flat file. However, it fail to execute this package in the OLE DB Source. I select the SQL Command in the Data Access Mode, then use: USE [SecurityMaster] EXEC [dbo].[smf_ListEquity] It runs ok in the Preview, but not in the Run. Then the system returns during executing the package: Error: 0xC02092B4 at Load TickerList, OLE DB Source [510]: A rowset based on the SQL command was not returned by the OLE DB provider. Error: 0xC004701A at Load TickerList, DTS.Pipeline: component "OLE DB Source" (510) failed the pre-execute phase and returned error code 0xC02092B4. Please give me some helps. Thanks. I'm having the same problem. P ...Show All

• Visual C# Static Class Overhead

  Hi, We were doing some refactoring here and had a discussion concerning static classes. Basically we have a set of classes with a bunch of methods in them that refer to strings. Now I have recommended that all strings should be defined as constants at the top of each class so that if a string needs to change we only change it in one place and not have to go through every method finding every instance of it. So basic good practice. Now with C# 2 came static classes. So the debate is to whether we should drop the constant strings out into a seperate static class and then refer to them in the method like a property of the static: i.e string myVariable = MyStaticClass.MYSTRING; as opposed to string myVariable = MYSTRING; W ...Show All