Dmac721's Q&A profile

• Visual Studio Switching from bundles Crystal Reports to full Crystal report 9

  I have the full version of Crystal Reports 9 on the computer I installed Visual Studio 2003 onto. When I check the About MDE it lists as using the bundles version of Crystal Reports When I installed Visual Studio I had it install the Crystal Reports plug-in thinking it had found the program and was asking if I wanted to attach to it. Is there a method to switch to the full program without reinstall visual studio I have tried reinstalling Cryst ...Show All

• Windows Forms Host Shockwave (flash 8) ActiveX in DataGridViewCell

  Hi all, I'm working on a CSharp software. I need a datagrid to list a folder that contain flash SWF files. In my datagrid i want a column to display those files. So i have created a DataGridViewShockwaveCell and a DataGridViewShockwaveColumn by following Microsoft samples. When i'm using this column i have some problems : -if i have more than one line in my grid, the flash don't want to display when the grid appear and the text "ADD ACTIVEX TO ...Show All

• SQL Server Combining Table and Matrix format in one Report in RS2005

  Hello, I am using RS 2005 trying to create the following report. My report consists of the following columns: Question, Sub Question, N as Number of Responses, All as Average for all responses per given question and sub question, and Ethnicity column which is presented here in a Matrix format with ethnic group as columns and average response as Data values. It looks like my challenge is to combine Matrix format report (Ethnicity column) wi ...Show All

• SQL Server Execute script from Stored Procedure

  I've been scouring the internet for hours looking for ways to execute a sql script file from within a stored procedure.  I found a way to do it with the following t-sql code:  select @cmd = 'sqlcmd -S SASHA2400\Erato -U cop -P xxxx -ic:\' + @Filename + '.sql' exec master .. xp_cmdshell @cmd But, I'm worried about security risks with using xp_cmdshell.  I would think there's be an easier way to do this.  ...Show All

• Visual Studio Express Editions Unable to add data connection. Key not valid for use in specified state.

  Using Visual Studio 2005, I am no longer able to add data connections to my projects. After testing the connection to an existing database and clicking OK, I get the 2-line message "Unable to add data connection. Key not valid for use in specified state." I am able to work with the databases using sqlcmd and SQL Server Express Manager. Even after three installs of visual studio and Sql server, no help. I er ...Show All

• .NET Development ssl hell

  I've made a self signed certificate and private key to use for ssl If I go by browser : no problem. When I want to do add webreference I get following exception: (it opens the page in the left window and in the right window the exception: The document at the url https://deftje/services/service.asmx was not recognized as a known document type. The error message from each known type may help you fix the problem: - Report from ...Show All

• Architecture Identity and Access Management

  Microsoft Architect Insight Conference, 22-23 March, Newport, UK This exclusive two-day retreat for senior enterprise, infrastructure and solutions architects, at The Celtic Manor Resort, will feature renowned industry speakers such as Ivar Jacobson, creator of the Rational Unified Process and Martin Fowler, Chief Scientist at ThoughtWorks, along with speakers from the event sponsors: Avanade, Capgemini, Conchango and ThoughtWorks. ...Show All

• Windows Forms Sorting DataGrid without GUI effects

  Hello - I have a DataGrid with many columns. I want to allow the user to sort the DataGrid based on a particular column. Vis Studio 2003 will allowing sorting by changing the DataGrid AllowSorting property to true. Unfortunately, when you click on a column header, the Control places a really wide Triangle graphic in the header to indicate sorting (ASC or DESC).  Since I have so many columns, I'd like my Column Widths to be just large enough ...Show All

• SQL Server Problem attaching a database using user instancing

  I have a database that I am distributing with my C# 2.0 application as an .mdf file meant to be attached at run time. I created the database on a copy of SQL 2005 Developer edition, and detach it and copy it to the test machine for testing. It has recently been complaining about not finding the .ldf file. According to the article here: http://msdn2.microsoft.com/en-us/library/ms165716.aspx I am not supposed to distribute the ldf. The only way I ...Show All

• Visual Studio data fields in header and footer

  Hi all Can someone tell me how to get data fields in the header and/or footer of my reports It appears I can only display these fields in the body as the ReportViewer gives me an error when trying to put them in the header. TIA Hi, Michael, You cannot do that directly. However, you can do it indirectly . Check out the following link provided by Rajeev and see if it can help. http://groups.google.c ...Show All

• SQL Server To Boost Performance

  We are designing the database for a high load web application . We used 4 techniques. 1.No outer joins,No Unions, > only in reports 2.No joins in main forms 3.Choose the smallest dataTypes possible. 4.Used a single instance for all users. Are there any additional MAJOR ones DId you had a look on www.sqlserverperformance.com Additional options would be to define the right indexes, use of index views, etc. You find all this ont his si ...Show All

• .NET Development XML nodes being re-ordered after a dataset.readxml() and dataset.getxml()

  I am reading an existing XML file into a dataset (I can not control the content or schema as it is defined by the requirements of my code). Then I randomly modify one value (I have a set of rows and columns saved in my code which maps to the schema of the xml after being imported) in the DataSet, and then write the XML to file. Everything is working as expected, except that there is an empty node which is being moved in this operation whic ...Show All

• Visual Studio Crystal Report.Net 9 to Crystal Reports XI for .Net

  We have developed reports for a windows application using cystal Reports which comes with VS.Net 2003.  We found that some of the issues we were facing were resolved in Crystal XI.  What exactly do we need to do in order to upgrade our existing reports in 9.0 to XI.  Please advise. Thanks, GTK. Hello, To upgrade the reports you will need to open and save each one using the Crystal Reports embedded report designer or the sta ...Show All

• Visual Studio Team System Date format in Team Build progress

  I'm based in the UK.  Today, whenever I run a Team Build from Team Explorer, it's telling me that the build is taking place on 1/3/2006 (1st March) instead of 3/1/2006. I know that the server regional settings are correct because the custom label being created for the build is correctly being set to 1.0.60103.x (built on 3rd day of 1st month of 2006). How can I configure Team Explorer to correctly display these dates ...Show All

• SQL Server DataRecordTypeToBufferType not declared

  When I try to use the DataRecordTypeToBufferType and ConvertBufferDataTypeToFitManaged helper functions in my SIS script it tells me they are not defined. According to the doc they are in the Microsoft.SqlServer.Dts.Pipeline namespace, which I have included and the reference is there. It has been a few years since I have worked with visual studio so I am a little rusty, can anyone tell me what I might be missing Thanks! Harry Harry, These ...Show All