hazz's Q&A profile
Visual Studio Crystal Reports for Visual Studio Program Manager
Hi Everyone, As program manager, I'm a recent addition to the Crystal Reports for Visual Studio team. I look forward to contributing to this forum as often as I can, and I'm excited to hear any feedback, comments, or suggestions that you have. I encourage you to visit our Developer Resource Center as a great starting point for all of our developer products. It has links to sample code (118 C# and VB samples), our Developer Library online SDK documentation, our Developer Zone, and Business Objects Support Forums. Also, for those of you that are new to report design and using the Crystal Reports Designer embedded in Visual Studio, check out the "Creating Reports" docume ...Show All
SQL Server Sum of a TextBox, is this possible?
I have a text box in a group that displays a list of numbers. For requirement reasons, I need to set some of the numbers in this textbox to zero (0). I then want to get the sum of all the numbers in the textbox, but I can't simply take the sum of the value in the cell because of the numbers set to zero. Any Thoughts Can one do this Thanks If you want the zero's to carry over, just use the same expression that sets those values to zero in the sum. For example, suppose the expression you use to set some of the numbers to 0 is =IIF(<condition>, 0, Fields!field1.Value), the sum expression would look like this: =Sum(IIF(<condition>, 0, Fields!field1.Value)). ...Show All
Microsoft ISV Community Center Forums sending emails from MS Word with variable subject line
Hi, I've searched these forums but have not been able to find exactly what I need. I know how to send emails with VBA in Word, but the only problem I have is that as far as i'm aware the subject line is always fixed in the code ( .Subject = "New subject" ) What i'm trying to do, is send reports i have reviewed to an email address by clicking a button in the toolbar. The email address is always the same but the subject line shows the customer's name and his account number (so that's different all the time) Is there any way I can get the VBA code to copy the first line of the report (which has the customer's account number and name) and use that in the subject ...Show All
Visual C# CodePage detection
Hi, I have a program that needs to process documents from remote servers. Is there a possibilty in .NET to dectect the codepage of the document (It's a winform app) Thx Hi, If you don't specify the CodePage then the streamreader will open the file in UTF-8. This is not what i want, I want to detect the codepage. In java there's a library called CPDetector which does this. Is there a C# equivalent Thx ...Show All
Visual Studio Express Editions Sending Notification using Windows service
Hi, I am new to windows service. I have the following requirement. I am developing an distribution software application . In this application customer sends request for quotation to purchase items. My idea is to notify the user when ever new quote is requested. My windows service should notify it like the outlook email notification at right buttom of the window. Any idea or code is helpfull.. Thanks. Windows Service is different than a Client application, the service stays in the background with no interaction with the desktop. You need to build a Desktop client (GUI) and interact with the Windows service and some how get an alert from it (like raise event) and then show this icon in ...Show All
Game Technologies: DirectX, XNA, XACT, etc. question on classes in XNA
ok...this is a very basic question, but stopping me from doing anything useful. I'm trying to create a basic "Sprite" class, but the telesense doesn't even recognize the class object I am creating. Are classes somehow shut off in XNA or am I missing something simple here This code below makes C# angry Sprite mySprite; mySprite = new Sprite(); mySprite.x = 5; I could be wrong but I think he's trying to initiate an instance of a class that does not exist because he's assuming that Sprite is part of one of the existing namespaces... maybe ...Show All
Visual Basic Installer Failing to Upgrade App from 1.1 to 2.0
Hi, I have an application that I developed in 1.1; the application was delopyed to a large number of workstations via GPO (have used this process multiple times to upgrade the application); I have recently updraded the application to 2.0 and when installing the application on my test workstation (not using GPO at this stage) it fails to upgrade the previous version that was written in 1.1, I end up with the old version and new version sitting in the "Add and Remove programs" list. I can confirm that both applications have different product codes and the same upgrade code, I have also selected in the 2.0 installer to "RemovePreviousVersions". I have used Orca to check that the upgrade ID are the same even after the setup ...Show All
SQL Server JDBC connecting to Sqlserver2005 Problem
Hi, I am trying to connecting Eclipse to SQLserver2005 on Win2000, and the driver I use is JDBC. My problem is: No matter what kind of authentification I try, it always throws out the exception of: The user is not associated with a trusted SQL Server connection. I tried 2 ways for connection: one is the windows, and another is Sql server authentification To the window authentification, I appended Trusted_Connection=yes to the URL, and omit the user and password fields, and it failed. But even I used the user and password options, it didn't work, either. To the Sqlserver authentification, I tried with the user and password, but it failed. Before that, I also added the user account in the Security ...Show All
Microsoft ISV Community Center Forums messageBox not showing in current window
Hi,All I want to show a message box when user click my custome send button to sending a Mail Item. Everything is working fine but Messagebox in not showing in current window (that is Mail Item), but it is showing in parent window of OUTLOOK. To see this message I have to move into OUTLOOK's main window. There in no much coding , I don't know where the problem is Please help me out. my code is here please have a look Private Sub btnNewSend_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean) Dim mTo As String 'mailGo = "" Dim mCc As String Dim mBcc As String Dim msgstring As String mTo = Trim(newMail.To) mCc = Trim(newMail.CC) mBcc = Trim(newMail.BCC) If mTo = "" And mCc = "" And mBcc = " ...Show All
Visual Studio Express Editions Editing data thru Bound Controls
I am writing a program that cycles thru an Access database and asks quiz questions. I have a column that has a checkbox bound to it that indicated wether the question was answered correctly. How do I get the corresponding entry inthe database to reflect the change in the control To save the changes to the database you can call the Update function of the table adapter (assuming that you are using a dataset). Change the deployment of the db to copy if newer otherwise everytime the application is restarted, the database will be overwritten with the database file in the project. Charles ...Show All
SQL Server How does SQL Server 2005 work with old applications
Hello All, How does SQL Server 2005 work with all ready existing applications that ran on SQL Server 2000. Does SQL Native Client work backwards compatible to the old applications, And if it is, is there anything special I need to do. If it is not backwards compatible, do I need to use the old MDAC How would I use it in SQL 2005. Thanks all..... Nina I know this isn't a popular answer, but in our case it was not a smooth conversion. The major issues we encountered were: 1) Change in the ORDER BY clause. The column names in the ORDER BY clause are interpreted differently. In most cases you'll get a compilation error and it's easily fixed, but in some cases you'll ju ...Show All
Visual Studio 2008 (Pre-release) How to create drag effects in a Canvas?
.NETters, My Canvas based application displays family pictures. The user must be able to drag and rearrange these pictures anywhere on the Canvas. When the user selects a picture and starts dragging, instead of moving the actual Image element, I would like to create a drag image that would move with the mouse. Once the user releases the mouse, I can simply change the coordinates for the actual Image element. The question is, what is the preferred way to do this My thought is: 1. Create a temporary Image element (with Opacity=0.5) and add it to the Canvas collection. 2. With each mouse move, keep on changing the location of the Image element. This will automatically force a redraw. 3. When the user releases the mouse, ...Show All
Visual C# Calling methods across classes
How can I call methods in my main Form class from another class (that is in the same namespace). Basically I have a method in my main program class that writes to a multiline textarea. I want some functions in another class to be able to call that textarea method in the main program class. Is this possible czell wrote: How can I expose the method Im kinda new to c# When I say "expose a method" I mean create your own publicly visible method that is accessible to any types that reference your type, e.g.: // assuming this is your main form public class MyForm : Form { public void WriteToTextArea(string text) { _textObject.Text = text; &nb ...Show All
Windows Forms ClickOnce Workaround.
hey guys, I need help from you guys. Just a few questions if these can be dealt with. 1. Is it possible to use click once without its backward compatibility I mean would want the newly published files(all files) overwrite the old ones. Would it be possible 2. Just wanna hear your ideas on this guys. For example, we have multiple servers running. Considering a multinational compay that has employees on North America, Asia and Europe. Each continent is being represented by a server. The purpose of which is that every time theres an update, those employees from europe would just connect to the server on europe and so is USA and Asia with their assigned servers respectively. Would it be possible for ClickOnce to deploy to multiple servers ...Show All
Visual C++ Changing Static properties.. Is this impossible?
Hi there.. I have been trying for days now to change the property of visible on a static text control in my application to false during runtime. I have researched this and researched this, and even posted on Expert Exchange, but no one seems to know how to do this.... I'll post the answer I was given on EE.com, and hopefully someone here will know more about it. I have only been programming in C++ for a week now, so forgive me if this is a stupid question.... I have several static text controls setup in my application (DirectX pong game) to report various stats that assisted me in creating the game and diagnosing troubles that may arise setup in a console.rc resource in my project. These are displayed in a control panel beneath the ...Show All
