AMSS's Q&A profile

• SQL Server INSERT and SELECT in one SP

  I've used this Insert into MyTable (fname,lname)values (@fname, @lname); Select 0 as retval; but the SELECT in not working , how can i do both in one sp Thank you all Kob_Kob IF EXISTS ( SELECT * FROM  MyTable WHERE .......  )      Select -1 as retval   ELSE     begin       Insert into MyTable (fname,lname)values (@fnam ...Show All

• SQL Server sql select

  I am trying to use the SQL " SELECT * FROM machines", this retrieves all records(rows) fine when I use the "sqlcedatareader" I want just to access 1 record from the table but the code keeps breaking on the "executereader" line SELECT * FROM machine WHERE mc_no = 12345 Why is this SQL syntax not working Where can I find an SQL syntax reference Please post your co ...Show All

• Visual Studio Express Editions Unable to download vwd and .net framework 2

  Unable to re-establish connection to server (atempt 5 of 5) - for about 3 days now.  Any news on this anyone TIA, Vogue   Sandhya wrote: Could you send the log file dd_vsinstall80.txt from %temp% of the machine Thanks! I've got the same problem doing an install on Win XP Pro SP2 on Virtual PC 2004. Can you provide an address to send the txt file to ...Show All

• Visual Studio Express Editions Create forms in code but can't 'paint' them

  I can create forms in code OK but if I draw graphics on them they don't refresh automatically.  If they are resized or another form is displayed over them then the graphics are wiped out.  If I could put the code in the form's paint method I know it would refresh automatically but I can't access the paint method because the sub form_paint() doesn't exist.  Is there some other way of making a form created in code repaint   ...Show All

• Visual C# Extracting a .zip file compressed with winzip using .NET 2.0

  Does .NET 2.0 support extraction of .zip file which is zipped using Winzip I use zlib or infozip (search for them via google). These are open source C libraries which you can call from .Net using platform invoke. ...Show All

• Visual C++ Dispose in C++/CLI

  I know that there is a lot of articles about this, but it is still not 100% clear. Suppose that I have the following classes: Client (C#, uses Server class) Server (C++/CLI) Helper (C++/CLI, reference of this class is kept in the Server class). Running FxCop on my project, I get the following message about Helper instance: http://www.gotdotnet.com/team/fxcop/docs/rules.aspx version=1.35&url=/Usage/DisposableFieldsShouldBeDisposed.html ...Show All

• Visual Studio Express Editions Where are the registration benefits

  Have just installed and registerd VB Express. I received an email with a link to the registrations benefits page ( http://go.microsoft.com/fwlink/ LinkId=52054 ). This link leads however to Microsoft Connect, not the registration benefits page. The link given in the Express Registration FAQ  is the same incorrect link. Judging from this forum, this seems to be quite common. has anyone got a working link to the page Chee ...Show All

• Visual Studio Team System Working with Visual Studio .NET 2003

  I have Nokia Developer's Suite which has an add-in only for Visual Studio .NET 2003. Can I use TFS with Visual Studio .NET 2003 Thank you, Sammy Daniel is correct.  Additionally, we will be making a VS 2003 plugin for TF version control available as a download near the time version 1 of TFS ships. Buck ...Show All

• Smart Device Development TCPClient Connection Emulator vs. Device

  Hello, I am working on a project which enables a Pocket PC device (Pocket PC 2003) to connect to a server via a TCP/IP connection. Running the program from the emulator displays an error message about not being able to connect. The errror code is 10065. The error message is: System.Net.Sockets.SocketException: A socket operation was attempted to an unreachable host If I run the same program on the device itself then it works as expected. ...Show All

• Visual Studio Express Editions Need Help

  hi, i know it might seems silly and even i don't expect answer but anyway since Dec 2005 i starting to learn programming with .net i have learned lots of stuff but every thing i try to learn will be like i open a door for hell, every thing even small controls have tons of properties and methods and lots of stuff you need to learn , i know its natural thing to happend when you start to learn new things, and i know i'll not be able to memorize ...Show All

• Visual Studio Tools for Office Automation executable consumes 100% CPU

  Hello!!! I have developed and automation executable to druve Excel and I'm poretty happy with it apart from the fact that it consumes 100% of the CPU while it's running - even when the app should really be idling. The problem is caused by this piece of code while (close == false ) System.Windows.Forms. Application .DoEvents(); I got this pattern from my VSTO book ( )and it's abviously going to cause the CPU hogging that I'm expe ...Show All

• Windows Forms DataGridView with using BindingList<Decimal> does not show values!

  Hi all, I have a some simple data stored like this: List<Decimal>^ values = gcnew List<Decimal>(); values->Add( Decimal(1.0) ); values->Add( Decimal(2.0) ); Which I pass along to a form that has a DataGridView to which I bind (in the constructor after the call to InitializeComponent()) like this: BindingList<Decimal>^ bl = gcnew BindingList<Decimal>( values ); BindingSource^ bs = gcnew BindingSource(); bs->Da ...Show All

• Visual C# Automatically install and start service

  All the help stuff I have read, mentions using the command line InstallUtil.exe to do a service installation, followed by a manual start. Is it possible to have the service exe itself do the install and start-up to make distribution and handling a bit easier for non-techies (after all, users are used to just double clicking an exe file to have an app run, and it would be good to have the same functionality with a service.) Hi Russ, A li ...Show All

• Visual Basic math function

  Hi, I was looking for a Polar to Rectangular math. function but could not find it. Is there such thing Thanks, Dietmar Such a thing does not exist, however it is not too hard to do. Public Function RectangularToPolarMagnitude(ByVal pt As PointF) As Single Return CSng(Math.Sqrt(pt.X * pt.X + pt.Y * pt.Y)) End Function Public Function RectangularToPolarAngle(ByVal pt As PointF) As Single Return CSng(Math.Atan2(pt.Y, pt ...Show All

• SQL Server How to split a delimited column into mulitple rows in the dataflow?

  I'm sure there is probably a very easy solution that I am just not seeing or can't Google... I have a DataFlow that includes a column of Delimited values (i.e. Value1,Value2,etc..). As this DataFlow is populating a parent table, I need split the values into their own dataflow and populate a child table. I've tried a script transformation and couldn't figure out how to accept 1 delimited input row and output multiple rows after a split. Any id ...Show All