Dorian Dechant's Q&A profile

• SQL Server Bug in SELECT IN SELECT?

  Hello, we had a performance issue with our application. The application executed a lot of SELECT IN SELECT-Statements. Because SQL-Server was at 100% the whole time we started the profiler and had a look. A single one of these SELECT IN SELECT-Statements had a duration from 4 to 6 seconds. That looked strange, so we tried it without our application. Executing the SELECT IN SELECT-Statement directly: 4-6 seconds. Very strange about this is, that the second SELECT (the one after IN) returned only one or two items. So we splitted it: Executed the second SELECT first. Then executed the first statement with manually changed IN-clause. Both selects didn't need any noticable time. So, back in our application we did the same. The result was ...Show All

• Windows Forms Minimize Form Together with Parent Form

  I have made use of the MDI, I realized that the children forms called from the parent form is minimized together with main form and however when i call a new form from a children form, a design problem which this new form can't be minimized together with main may appear How to make their minimize and maximize properties to be consistent Thank you. I have one Main Windows which consists of ToolStripMenu, i can link to another form called form2 from the ToolStripMenu. There is another button in form2, which it is used to link to form3, but i want to set the form2 as a child under Main Windows so it can be minimized and maximized together under one form. I tried to achieve it using the following code but it d ...Show All

• Visual Studio MRefBuilder recursive dependencies

  My target dll, t.dll, depends on d1.dll and d2.dll. d2.dll depends on d1.dll. Using the /dep parameter, MRefBuilder can find d1.dll to satisify t.dll depending on d1.dll, but reports Error: unresolved assembly reference ... d1.dll required by d2 You didn't say in your post. Did you specify both d1.dll and d2.dll with the /dep switch That should let it work. Eric ...Show All

• SQL Server Fix matrix column and IF-ELSE statement

  Hello. I have to questions - 1) I have a matrix in my report and I want The group column to be fix so if I have a lot of columns and I scroll left the Header column will stay in the left of the screen and only the result column will be scrolled. How can I do it 2) How can I use a IF-ELSE statment or a CASE in the expression I want one of my column to be red if the value is "1", green if the value is "2" and blue if the value is "3". Is there a way to do it Thanks in advance. Hi Andy. Thanks for your reply. The FixedHeader is good only for table but I'm more intresting in Matrix. In matrix you also have column that you define and I want those column to stay fixed on the left w ...Show All

• .NET Development Code access security question

  I am helping a friend who has a .NET 2.0 Windows forms application that generates an error when installed on our Intranet. I'll paste the error at the end of this message. I can solve the problem by installing the .Net Framework 2.0 SDK on the client machine and running the .NET Framework 2.0 Configuration tool and getting into Configure Code Access Security Policy/Adjust Zone Security and setting the Intranet Zone to Full Trust. This is OK for us to do, but I'd like to find out if there's a simpler way to implement this setting using caspol or something like that without having to install the SDK on client machines, or maybe we can modify all machines on our network to have this setting by default. Thanks for any help, errors below.. john ...Show All

• Software Development for Windows Vista How to get assemlies in "Browse and Select a .NET Type" dialog box

  Hi The following code is in one of my assemblies: namespace Roles { public partial class SequenceRoleActivity : SequenceActivity { private int rolesRights; public int RolesRights { get { return rolesRights; } set { rolesRights = value ; } } public SequenceRoleActivity() { InitializeComponent(); } protected override ActivityExecutionStatus Execute( ActivityExecutionContext executionContext) { return base .Execute(executionContext); } } } No I would like to derive from SequenceRoleActivity in another assembly. When I click the ...Show All

• SQL Server accessing two databases from a single Stored Procedure

  Is it possible to access another database from a single stored procedure of another database. If it is possible, please show how. If both the DBs are on single Server and the current user have access permission on both database then you can use the following query.. Select SomeColumns From CurrentDBName..TableName Select SomeColumns From OtherDBName..TableName If the other database on different database Server then you have to use the Linked Server.. EXEC sp_addlinkedserver @server = 'SERVER', @provider = 'SQLOLEDB.1', @srvproduct = '', @provstr = 'Privider=SQLOLEDB.1;Data Source=TargetServer;Initial Catalog=Database' go Exec sp_addlinkedsrvlogin @rmtsrvname = 'SERVER', @useself = true, @locallogin = null, @rmtuser = 'Use ...Show All

• Visual Studio Express Editions extreeeem noob

  how do you run a program after you compile it Press F5. If you need more ways for running your application, please search the forums first since you will find more details there. Thanks, Ayman Shoukry VC++ Team ...Show All

• Visual Studio Express Editions Where Visual C++ Express Edition is after that downloaded into hard drive.....

  I downloaded Visual C++ Express Edition from microsoft's site.It is automatically downloaded and installed...Where it is in my hard drive Hmm... you should know where you have downloaded it ! It's not like there is a default download folder for VC++ Express. And what exactly did you download The full 400 megabytes image Or the just the setup If it's just the setup go to the download site again and press Run when the download finishes. ...Show All

• Windows Forms get pictures from server in windows form

  Hello, I would like to get several pictures (depending on user input) from a web server and display them in one of my windows forms. I will have the absolute path to the pics on the server. Can anyone tell me how to connect and bring them across to the user's machine so that I can display them in my form Thanks! RC You could create an instance of the WebClient class and use its DownloadData method not unlike this:                 string url = "http://forums.microsoft.com/library/toolbar/3.0/images/banners/msdn_masthead_ltr.gif" ;               System.Net. WebClient w ...Show All

• Visual C# System.ArgumentException: ContextMenu cannot be shown on an invisible control

  "System.ArgumentException: ContextMenu cannot be shown on an invisible control" Again, one of the computer running the program pops this error at the time the program starts... all other computers don't have such problem... What can be the possible cause It's difficult for me to post the code because it's too long and I don't know which segment of the code is likely to cause the problem... I searched Google but most related results are not English..... It seems .NET has lots of this weird problem or just my programming problem Thanks... I try my best... Details of the exception System.ArgumentException: ContextMenu ContextMenu cannot be shown on an invisible con ...Show All

• Visual Studio 2008 (Pre-release) Distance between lines in RichTextBox

  Hi. How can I change distance between lines in RichTextBox Thank you. Thank you! But in my case right answer was myRichTextBox.Document.LineStackingStrategy = LineStackingStrategy .BlockLineHeight; I had very big distance between lines & no results after setting padding with thickness = 0. ...Show All

• Internet Explorer Development DoFileDownload (/Related)

  I'd like to use the IE API to download updates for databases. I'm looking for a Lo Fat download/progress bar solution. DoFileDownload is just the sort of thing I like. The problem is the "Save As" dialog. Is there anyway to charm a download-location into DoFileDownload, skip "Save As" and go straight to the progress interface Can anyone suggest an approach to accomplish this with this or another API I'd like to keep code as simple and elegant as possible. Hey there, I would also like to implement the same thing. I have the source URL and download destination, I want to skip straight to the download process and progress dialog. What exactly does DoFileDownloadEx do and would this work If you know a ...Show All

• Visual Studio Express Editions Problem to save a table

  Hi, I've a problem when creating a table, it creates the table and it includes the registers, but when I leave the application the table isn't saved in the database. I've already modified the property of the database to Copy if Newer. Dim nome As String = "TESTE"         Dim cmd As Integer         Dim query As String         Dim sqlComando As SqlCommand         connBD = New SqlConnection(strcon)         query = "CREATE TABLE " + nome + " (CodTeste Integer, Nome nvarchar(50))"         sqlComando = New SqlCommand(query, connBD)  & ...Show All

• Visual Studio Tools for Office CommandbarCombobox Problem

  Hi, I am developing a COM add-in using C#. I have a CommandbarCombobox and a button on my outlook Add-in. I am opening a windows form when a user clicks on the button. I have implemented the CommandbarCombobox change event and opening the same windows form in the change event. My problem is that, When user types in something into the combobox and tabs out and hits enter on the button, two forms are opened. First one is opened because of the button click event and the second one is opened because the change event of the CommandbarCombobox is getting fired. I just want to open one form for the button click event. Any hints on how how to go about this Thanks, Hrishi One way would be to create a local varia ...Show All