|
Is it possible to give the end user on the web based application the cabapility of crystal report or any other tool editor inerface, where s/he can pick the fields they want, lignment, grouping etc. and generate report dinamically?
Thanks,
|
|
|
|
|
This is not really a C#/.NET question, since you're looking for design-time support for Crystal Report definitions, which is possible but VERY costly. See the Crystal Reports[^] web site for more information.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Currently, this doesn't have all of the capabilities you are looking for, but if you have a license of SQL Server 2000 on the server you would need this capability, you can use SQL Reporting Services[^]. Supposedly, you don't have to use this against SQL Server, but I haven't seen that done. As a free tool (with a SQL Server 2000 license) that is centered around .NET, I imagine this would be a very flexible option. Not to mention that I imagine this will be extended and included in Yukon. We'll see, tho.
Michael Flanakin
Web Log
|
|
|
|
|
Hello. I got ASP.NET project and I want to create custom setup project for it. I've done following steps:
1.I created a new WebSetup project in my solution.
2.I created a new Class Project in my solution. in thid project I've add a new Installer class which inherits System.Configuration.Install.Installer.
So I overrided some functions like Install, Uninstall etc.
Also in WebSetup project in UserInterface I added a TextBoxes(A) form. My WebSetup project writes some value to the Registry "HKLM\SOFTWARE\MySoft\WebAppliction"
After all, all I need it's just to read Registry and find out if there are my application was previously installed, and if it was installed earlier I need to write Registry values into TextBoxes(A) form TextBoxes.
If I try do that in Install method it not works, because TextBoxes(A) form is shown before the Install starts and TextBoxes in TextBoxes(A) form are empty, but I want to fill them values from Registry if my key exists...
|
|
|
|
|
The installer project uses Windows Installer - there is absolutely NO need to check to see if your product exists. If the ProductCode is already registered, it will prompt to repair or remove. If you want an upgrade, keep the UpgradeCode the same, change the version number, and set RemovePrevious to true. It is recommended that .NET applications and libraries DO NOT write to the registry as this cause portability and deployment problems.
Also, when you create a custom Installer class, you have to register it as a Custom Action otherwise it won't be executed. There's no magic here. Just go to the Custom Actions tab in the setup project, right-click, and and select "Add Custom Action...". It will create custom actions for each of the catagories listed in that tab. To pass parameters from your installer package, pass command-line arguments by customizing the custom action commands that are generated to send things like /myparam1=[PARAM1] /myparam2=[PARAM2], where PARAM1 and PARAM2 are properties defined in your installer package (which can be set using the custom dialogs). In your installer package, you can get these by querying the Context.Parameters property (a dictionary, or key/value lookup table) using the switch, like myparam1 and myparam2 like I used above.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Thank you for the your information. But this is not quite that I wanted to know.
When I lunch my msi file, Wellcome scrren appears and after Next click my TextBoxes(A) form appears, and EditBoxes in that TextBoxes(A) form I want to fill by the values from the Registry if such exists.
I added Custom Action as myinstaller.dll but if I trying to read values from Registry and fill EditBoxes in TextBoxes(A) form nothing happend, because Install process starts AFTER Wellocome screen and TextBoxes(A) form appears....
|
|
|
|
|
Custom actions can be run at any time, and even in response to user interaction. The problem is that the installer project in VS.NET is EXTREMELY limited unless you know how to manually edit MSI packages - trust me, I know. I've beta tested Windows Installer since before the beginning and also helped beta-test for Wise Solutions, maker of Wise for Windows Installer (the cheaper, easier alternative to InstallShield who allows FULL access to the tables LONG before InstallShield did).
You actually don't need a custom action here, and a .NET Installer custom action can't even help you here (without interop'ing the MSI automation server, getting the current session, and do a whole lot of crap that isn't necessary).
This can be, fortunately, done through the crappy UI. In the solution explorer, select your project. At the top is several buttons. The second to the last one (before the project config button) is the Launch Conditions button. Click it to open the interface.
Right click on "Search Target Machine" and select "Add Registry Search". Give it a name (any name - for your use only) and go to the Properties window. Type in a property name, preferrably in all capital letters (this allows for a secure property which can be passed from the command line to the execution sequence, meaning you could override this value if you wanted to). Select the registry hive from the Root and type the key (exluding the value key name, so just the "directories" that you'd see in regedit.exe) in RegKey. Finally, put the name of key in Value.
One of the first things that Windows Installer does (by default, this can be changed through some order is required for other actions to work) is check launch conditions and perform searches. This will read the value of that registry key into a property with the name you provided above. In the EditProperty# type the name of this property. That's it.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Thanx again. But I got some new problems, if registry key does not exists, my program just could not be installed, an error notification apperas that "Setup could not continue etc. etc."
Also I want to ask you one more thing:
If I have installed my program, and than in VS.NET I rebuild my project and lunch the msi file again, then error notification appears. In this message I have been told that:
"Setup could not continue because another version of my program was previously installed. Use Add/Remove programs to remove that program"
I guess it happens because I rebuild my Setup project and my build version changed.
So, I want be able to Install, Repair or Uninstall my program just by lunching msi file once again (without removing my program(previous version) through Add/Remove Programs).
It seems to me it would be perfect if I could overrid some function that allows me to UPGRADE my programm....
Thanx again for your advises.
Excuse my English
Regards, Alex.
|
|
|
|
|
dotnetdev@univ.kiev.ua wrote:
I guess it happens because I rebuild my Setup project and my build version changed.
No, it's because your installer version did NOT change. Windows Installer has full upgrade support built in to its core, but it isn't automatic. First, in your project properties set RemovePreviousInstall (or something like that) to true. Also, between versions change the Version number appropriately (it's only 3 numbers, not 4 which really isn't supported anymore for MSIs), be it a release, minor, or major version number change appropriate for your changes to your application. The file versions are only used when Windows Installer determines if a file should be overwritten (well, it's one way). When you change the project's version number, you're asked if you want to change the product and package codes, too. Click Yes. Your UpgradeCode remains the same so your product is still associated between versions, except that only one package with the same product code can be installed at a time. That's where your error is coming from.
That registry solution I told you would not produce an error. It would leave your property undefined (so you could actually use that in a launch condition by putting just the property name in there. If it was set, the condition is true; if it wasn't set, the condition is false). Something else is causing it. A better description of the error that doesn't include "blah blah" would be far more helpful.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Unfortunatly I did not find any property like RemovePreviousInstall or something else in my project options. Could you please tell me where I can find this option more detaily.
So, when I installing my program by launching msi file product installed correctly. And when I rebuild my Setup project and try to Install it one more time by lunching new (rebuilded) msi file again message with following text appears:
"Another version of this product ia already installed. Installation cannot continue. To configure or remove the existing version of this product, use Add/Remove Programs on the Control Panel"
And when I remove my program through Control Panel, and then instlling again from new(rebuilded) msi file all goes well. Can you tell me if there possible to remove my program just by lunching new(rebuilded) msi file, that no message appears, and I'll not have to remove old version through Control Panel.
Thanx.
|
|
|
|
|
thanx for your advise with Registry Search it works!
But now other problem occured: In Registry I keep value as string "User=www" and if I trying to get value from Registry through Registry Search it returns me "User=www" in my TextBoxex(A) form textbox value. And I want only "www" as my TextBoxex(A) form textbox value. So could you tell me how can I parse vlues from which I recieve from registry?
|
|
|
|
|
You normally don't store registry values like that. A much more common practice would be to name the key "User" and set the corresponding value to "www". Windows Installer has its limitations. If you insist on storing your values this way, then you're responsible for having to parse them and there's not an easy way of doing it. The only way possible would be to write a custom action (in C or C++, it'd be difficult and too inefficient to do so with a .NET Installer class) that gets a handle to the current session, gets the property and splits it into new properties, all before the dialog is displayed. Then you'll need another one to put them all back before the WriteRegistryValues action.
All this would also require manual hacking of the MSI since the VS.NET installer project will be of no help and won't let you do things like this. It is not meant to be a commercial deployment replacement.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Looking, it's RemovePreviousVersions. Honestly, it shouldn't have been that ellusive, should've it? 
Again, set that aforementioned property to true and make sure you increment your Version number. Trust me, it will solve the problem if you do it right. The VS.NET installer project makes this easier, though it's not hard even if hacking the MSI itself with Orca or something that I use a lot. Just make sure you NEVER change the UpgradeCode unless you really know what you're doing, since you'd have to hack the MSI to fix it.
When you install the newer version, the older one is removed automatically in a transacted process, so that any critical failures leave everything the way it was before you tried to install.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Well, I opened my Install project and I go to the Project->Properties and I just could not find any RemovePreviousVersions option...
Where is it?
|
|
|
|
|
Select your project then look at the Property Grid found in the bottom-right corner of VS.NET by default. There's lots of properties there, including RemovePreviousVersions that's been there since VS.NET 2002.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
THANX A GREAT! It's interesting to me how do you know all these stuff?  You must studuing during 24h a day? 
|
|
|
|
|
I love to learn (and by learn, I mean to truly understand) all that I can about many things, especially application development. It's a never-ending process.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Hi,
Just a quickie. I have created a flashy interface using Picture Boxes as buttons and want to have them make a 'click' sound when pressed for user feedback. Is there a simple call which I can use? Or any piece of code to do the job,
Regards,
John
|
|
|
|
|
See http://www.codeproject.com/cs/media/windowssoundevents.asp[^]. Just find the key for the navigation sound in the registry (the article mentions where in the registry to find these events) and call PlaySound (as documented in the article) with that key.
Support for system sounds will be added to the FCL in .NET 2.0 due out in early 2005.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
How I can show the contents of the control PC to other clients in the LAN?
|
|
|
|
|
If you're using Windows XP, click on Start-<Help and Support. There is functionality to view existing Windows sessions already built into Windows XP, along with an invitation system. You could also install VNC (free download from the web - just google to find it) which allows you to connect to existing sessions, IIRC, but the Windows Remote Desktop Client won't work because it starts a different terminal session with each connection so they won't see your desktop session.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
I'd like to create a form that contains a number of controls that can be moved, and behave like forms. Similar to the Access relationship view. I've figured out that I need to do the following:
* External Form style border
* Move function upon mouse down on header (thick title bar in forms).
* Resize function upon mouse down on sides or base.
* Lock mouse pointer internal to form when moving object.
I was looking to set the border style to form, and then hoping that the header and side parts of the border could be used to fire events.
As for the mouse, i was looking at tying the mouse handle to the inside of the form, but i'm not sure how to do it, and the thought alone makes me wonder what could go wrong.
So i'm not sure how to go about this, does anyone know where to begin?
Cheers
Cata
|
|
|
|
|
One way is to implement .NET's drag and drop features for controls. I've mentioned this several times in the forum, so try a search. Just use some custom clipboard format (like ".NETControl" or something) and you can reposition controls that way.
You could also handle the MouseDown event and mark a flag. In the MouseMove event update the control's Location as you move if that flag is set. In MouseUp, reset the flag so that just simply moving the mouse doesn't move a control when your mouse passes over it.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
[EDIT: Ah, did a google search for drag drop controls, and got a working example. It's perfect. Only problem I have now is figuring out how to implement a Form style border on a control. If you can offer any help into that, i would be grateful]
Ah, thanks for the ideas Heath.
The second one would cause problems with moving the mouse outside the area, and while i could lock the box to the perimiter, it would still look unproffsional.
How does this work with object borders?
I've tried a bunch of searches, but still haven't found anything. Sorry to be a pain, but i've done a whole bunch of permutations of Move, Control, Controls, Drag, Drop, but come up empty handed.
Cheers
Cata
|
|
|
|
|
Ok, I have the Drag Drop working, but i'm interested in a couple of other things.
How can i stop the mouse pointer from leaving the form / control / container while in the process of dragging?
How would i configure a form type border on a control? I know they are sperate objects, but i've no idea where to start to set them up. Not sure what i'm looking for in google tbh.
Cata
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
