|
Hi,
I have written a stored procedure in SQL Server which uses temp tables and returns the rows of a temptable.
When i try to use this sp as datasource for Crystal report(Add Database), the fields are not listed.
Why is that? If this wouldnt work how do i implement this.
Am using a custom version of crystal report bundled in VS .NET.
Any help would be appreciated.
Geetha
|
|
|
|
|
Hello there
I have built a setup for the project. in which I included couple of image files to be displayed when user will run the setup. I want those files to be deleted after the installation is completed.
can any one tell me how ?
|
|
|
|
|
How exactly are you originally installing and displaying these images? If you add an image to a setup dialog, it can be embedded in the MSI itself, and does not need to be "installed". You can also add a custom action to delete the image files at the end of the setup, however if the image files are originally installed by the MSI itself, you must be careful how the atributes of the files are set, because deleting a file that is marked as required will trigger a repair to run automatically.
Robert
|
|
|
|
|
well thanks for both the replies. in this scenario I am putting the image on SetupDialog. But the problem is when I click browse to assign the image to a dialog page it asks me the location of file according to the project... means file in Application Folder or User Desktop... etc. the folders exist in the project. so if the file is not there then you cannot assign. and if I add the files in application folder then it remains there after setup runs..
|
|
|
|
|
In order of easiest to hardest, also in order of least elegant to most elegant solutions:
1) You can just leave them, a couple of image files are no big deal.
2) You can write a custom action to delete them at the end of the setup. See MSDN for creating custom actions. Test it to make sure it does not triggera reinstall. If it does you need to adjust the file attributes.
3) If you have Orca you can do a lot of things not supported by VS IDE. By manually editing the msi package, you can embed each image as a binary stream, and you can set the dialog properties to display the image in the particular dialog by loading it from the msi itself rather than fropm a disk. This is not exactly hard to do, but it is not trivial either.
Depends on how much effort you want to put into the problem.
Robert
|
|
|
|
|
Please don't do number 1. There is nothing I hate more than installers that leave temp stuff used only during installation on my computer when they finish. Therefore, I'm glad to hear that you are looking for a solution to get rid of them.
Brian Van Beek
My Blog is Awesome, ok maybe not, but is still fun!!
|
|
|
|
|
Thanks for the solutions. I am going for solution 2 and 3 to test both. as far the point 3 is concerned I have seen your article as well. good job. I found the URL for orca over there but it says that page has been moved and then they moved me to page
http://www.microsoft.com/downloads/details.aspx?FamilyId=A55B6B43-E24F-4EA3-A93E-40C0EC4F68E5&displaylang=en[^]
which doesnt look orca. I have searched at google and it took me to same place. Can you just check and confirm the url so that I can download the right thing.
thanks alot for the support
|
|
|
|
|
Yes, it is the correct link. They call oit the Platform SDK, but it includes the Windows Installer SDK. Let me know if you have problems once you start working with Orca.
Robert
|
|
|
|
|
well Robert I was trying to download it but it is of 370 MB + so will take time. secondly I need to install windows 2003 server and I have winXP professional. so it will take time to do so.
thanks for the support. I might bother you after some time when I shall have the required settings for this.
|
|
|
|
|
I am making a tile view control, but have a couple of snags. I am using a custom control for the tile and adding it to a panel control. I have made a semi transparent control to act as a selection box. Problem is that the selection box doesn't paint over the controls that are added to my user control..ie pic box and leabels. I looked at trying to inherit the listview control and make my own items, but haven't found much to help with the problem. Any ideas?
TIA
|
|
|
|
|
Hi all programmers,
I need a code which converts the XML file to Excel file. I have xml file and a xsl file is related to xml file.
Please help me with it.
Regards, all
|
|
|
|
|
There're two forms running on the MDI Form. From 1 form, how can we process another one?
Thanks!
|
|
|
|
|
<font color=blue>Dim</font> Frm As Form2
Frm = <font color=blue>New</font> Form2( <font color=green>set constructor parameters here</font> )
Frm.ShowDialog() <font color=green>' if you want it modal...</font>
Frm.Show() <font color=green>' Non Modal child frame...</font>
TOXCCT >>> GEII power [toxcct][VisualCalc]
|
|
|
|
|
No, both forms've already running. The way i want is from the first form, we update some controls of the second form (add a new item to a combobox etc..)
Can you help me?
Thanks!
|
|
|
|
|
add a reference of form2 into form1...
TOXCCT >>> GEII power [toxcct][VisualCalc]
|
|
|
|
|
How can I cancel the Form_Unload event? When the user clicks the red X at the top of the screen I want to capture the event and ask if they want to save first. If they do then I want to stop the Unload call. Thanks!
|
|
|
|
|
Private Sub Form_Unload(Cancel As Integer)´
''''If You want to cancel the exit just...
Cancel = 1
End Sub
|
|
|
|
|
|
Hi,
For my multiuser vb.net application i DONT want to use any commercial DBMS.
How do i use flat file system for a multiuser application.
Regards
|
|
|
|
|
Very painfully - it's called Access. You can use your own files too, but...
I abhore using Access, or any other file-based database, for any multiuser system, but some other people have a different opinion. It can be done, but performance stinks, severly limiting scalability.
If your system has an unknown upper limit on the number of users, save yourself the trouble and go with the DMBS up front. You won't have to convert your Access "SQL" to Real "SQL" code later.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
MSDE is free, although it doesn't scale as well as SQL Server 2000. But Dave is right, do it properly, or don't do it at all.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Google for Sqlite. Its completely filebased, only some kilobytes in size and faster than Access. It has its issues but it can work very well (there is even a native .Net provider for it).
|
|
|
|
|
There is also MySQL wich is becoming widely used and Free.
|
|
|
|
|
I am sure we are all faced with SOX (Sarbenes & Oxly). I am looking for a program that will let me enter a date range and path, then it will create a report that provides me with a list of files that were created and/or modified during this date range. Ideally I would also like to be able to control what file extension the program looks for. Any help is appriciated ... I a newby to .NET.
THANKS!
GuateGerman
|
|
|
|
|
this code is write by vb6 and it convert to vb.net, when I run it, it gets me error. is anybody knows hot to fix this or what should I code it in vb.net? Thanks!
Private Sub clearTextboxes()
Dim txt As System.Windows.Forms.Control
'Set each textbox's value to ""
For Each txt In frmMain.DefInstance.Controls
'UPGRADE_WARNING: TypeOf has a new behavior. Click for more: 'ms-help://MS.VSCC.2003/commoner/redir/redirect.htm?keyword="vbup1041"'
If TypeOf txt Is System.Windows.Forms.TextBox Then txt.Text = ""
Next txt
End Sub
Lisa
|
|
|
|