hover hyperlink's Q&A profile
SQL Server Insert code in report
Hi! I want to use methods from Visual Basic into Reporting Service, for modify fields. Fo example, I want to use a method for to round a number. Thx!! VB function can be referenced from the report's code object. Here is an example: If you want to use the Math.Round function, place code similar to this in report's code block : shared function RoundNum( byVal Number as Decimal ) as Decimal 'round to one decimal place return Math.Round( Number, 1 ) end function Then, to reference it in the report, simply use an expression like this : =Code.RoundNum(Fields!Current ...Show All
Visual C# SQL lookup
I am a new user to Visual Studio and SQL Server. This is probably a question that has been asked before but I can't seem to find it anywhere. I have an SQL database with two tables. One has a primary key and the second has a primary key with a foreign key referring back to the first table. I display the fields that are of interest in about 9 text boxes. My question is how do I use the text box containing the key for the second table and derive the rest of the information to display in the other text boxes I type in the number and should be able to get the rest of the information but I'm just plain stuck. I know that I can use the views and ...Show All
Visual C++ Converting System::String to Int32 and back again in hex in C++
OK, I have a simple question: I have a window where a user can enter a hex value, like 10BF00D1. Another one where the user can enter a pure binary number like 1000011101101001. I want to grab the String and put the data into an integer, manipulate it and turn the result back into a String. How do I do this with the managed System::String class in Visual C++ 2005 It was easy to do back in the "C" world, why is it so hard to find the new way Thanks, Dale Thanks for the list. I already have some of the books on the C++ list, so I know they are good. I would like to get some of the others. ...Show All
SQL Server SQL Server 2003 Time Drift, NTP Server went down.
Our SQL Server 2003 at work is no longer syncing to NTP Server (ntp server has not been syncing time for 2 weeks, we just happend to notice today). The time drift at the moment seems to be somewhere between 10-30 seconds. We do hundreds of thousands of real-time transactions all day long (Banking). If we bring the NTP server back online and it adjusts the time on the SQL Server, what (if any) problems would be be looking at Thanks Carl Obviously, it would be anything that could be time-related. If that's an issue in your system is impossible for us to say, it all depends on what possible confusion it ...Show All
Visual C++ Indenter etc. for VC++ 2003
I have been handed almost 15,000 lines of C and CPP code (almost 350 functions) that are left justified and no spaces within the lines other than the necessary ones. I'd like to have the code indented and have it also spaced about to make the code easier to work with. Is there a free or very inexpensive indenter/beautifier/prettier available that works inside VC++ 2003 (as tool etc.) that will indent and also pretty the code with spaces etc. If not internal to VC++ 2003, one that works on all of the files in one pass I appreciate your help. Thanks, RON C Have you tried Ctrl K, F ...Show All
Visual Studio Comparing a local file to a previous file version in VSS
"isdifferent" wont work coz it only compare the most recent version of the file against my local.. i need to know any alternatives for solving my problem.. thankyou very much/// i need to compare an old version of a VSS file to my local if they are identical... I think you may be able to get an IVSSItem for the previous version by using IVSSItem.Version() or by obtaining it from a IVssVersion, then call IVSSItem.IsDifferent for it. Alin ...Show All
Windows Forms Keyword is "mari"
Congrats David !! I can do nothing !!! Well, it looks like my original plan has worked after all. The aggressive behavior of asgard32 towards mari was able to drive them out gradually. Now I can see more varieties of other herbivores back into play. Now let the game begin! Due to some unknown reason, asgard32 seems to also periodially clean&nbs ...Show All
Windows Forms Displaying Flash with webbrowser control res protocol...doesn't work....why?
I'm not sure where to ask this question....but had to pick somewhere... I embedded my website in a resource file...all files embedded using RC.exe. Unfortunately, now I discover that the swf files don't display. Just an empty box. Assuming you're using VB6 or VB.net, simply add the webbrowser control to a form. Add all your css, js, and htm files to a ...Show All
Smart Device Development scrollbar in Compact framewok windows form
how can we make the form scrollable in a windows form in compact framework Glad to have helped. Please try to start new threads for new topics and do understand that every topic is urgent/important to the original poster. May I suggest you check this out: http://www.danielmoth.com/Blog/2005/03/please-read-before-posting-to-ng.html The serial/rs232 story in relation to .NET is here: http://www.danielmoth.com/Blog/2004/09/serial-rs232-communications-in-net.html Printing is an FAQ that has been addressed in the NETCF newsgroup. Please see previous threads there: http://groups-beta.google.com/group/micros ...Show All
Visual Studio SourceSafe Info and MS CMS
Hi, Wonder if anyone can help me. I'm starting up a new MS CMS project and have SourceSafe installed for the maintainance of the project source. Just wondered if theres any instructions of how to set it up, i.e. creating a new project in sourcesafe preferably with CMS. Any guides or help would be good. Thanks, Michael Thanks. Just got a problem with sourcesafe creating a new copy of the solution evertime i connect. so got solution, solution_1, solution_2, not the ideal solution. I'm working on the machine that hosts the solution and visual sourcesafe server, but its really messing up my templates in MS CMS as i have to change the refere ...Show All
Visual Basic fun with oop
I would like to be able to pass a string into a method and have that method decide which kind of object to return. For example, I would like to pass the "woof" string into a method like the one illustrated below and have it return a "dog" object. Is such a thing possible I know that I can set the function return type to "Animal" since all three objects are derived from animal, but if I do that I will lose functionality in the "Parrot" object which inherits first from "Animal" then from "Bird". For example, I would lose the ability to write "a.Wings" to the console (illustrated below) because the base class "An ...Show All
Windows Forms How to make it so an app installs for ALL users, not just the current one?
I noticed when I create a setup.exe and install it, the app goes into \Documents and Settings\myUsername\... etc. How can I make it go into \Documents and Settings\All Users\ And have the shortcut available for all users as well, on a global level BUT still have the application settings on a per-user basis. This version of ClickOnce does not support control of All Users vs. Current User, you can only go to the current user. It's something that's being considered for future versions, but we wanted to get the Current User model right with this release. ...Show All
.NET Development Application Settings in Class Library called via COM, how to set them?
Hi, I've written a small Class Library that I call from classic ASP, the problem is that as far as I know the only way to set the settings is from the .exe.config file of the app where the class library is used (windows forms, console apps, etc), my question is, how can I make this work if I call this library via COM Thanks I see. Try using the ConfigurationManager type w/ ConfigurationFileMapping type, to explicitly point to your config file and read it. ...Show All
Visual Basic Whats wrong with this?
Im using this code to save: Dim app_path As String Dim nFileNum As Short app_path = My .Application.Info.DirectoryPath FileOpen(nFileNum, app_path & "\" & "SortingApp.data" , OpenMode.Binary, OpenAccess.Read, OpenShare.LockReadWrite) I put this code in the form1 load But when i run the program it highlights the whole last line in yellow and says 'bad file name or number' Could someone please tell me whats up with that! OK, Here's how we're going to proceed. Waxing a bit philosophical for a moment, I'm not going to "help" you. I'm going to assist you. If I help you, what that really means is ...Show All
.NET Development Urgent Problem - Receiving 0 bytes when sending bytes to remote socket
Hi, I'm having a real urgent problem that only started to show in production. We're using async SSL sockets broadcasting packets to several clients. However, some clients reply with 0 bytes when the packets are sent to them, whereas this problem never showed on our internal network. This only happens for clients connected via the internet. Any idea what could be going on here Tom What do you mean by SSL Sockets Are you using System.Net.SSLStream Could you provide a short code snippet showing the send code and receive code Thanks ...Show All
