SOAC's Q&A profile

• SQL Server How to search for a Stored Procedure?

  Hi, Could anybody please tell me how I can search for a stored procedure in SQL Server 2005 I know the name of the stored procedure and I want to find in which database that stored proc is located/stored and I want to see the code of it. (I have all the necessaary previleges.) Please tell me how I can I do this. Thanks in advance. Regards, Ram. Hi, you can check for existance of stored procedure as .. declare @name varchar (100) declare @spname varchar(100) declare cu1 cursor for select name from master..sysdatabases open cu1 fetch next from cu1 into @name while @@fetch_status =0 begin exec ('select * from ' + @name + '..sysobjects where xtype = ''P'' and name = ''' + @spname +'''') if @@rowcount> 0 begin select @name as ...Show All

• Visual J# JDK1.4 to J#

  What are the compatiblity issues that one face while recompiling the java code base (written using JDK1.4) in J#. Can somebody point to the classes that are not supported in J# and supported in JDK1.4. Thanks in Advance. Please see if this can solve any of your problems: http://www.dotnetit.org/index.html ...Show All

• Visual Basic computing a mean and standard deviation

  hi guys firstly i am new to all this as i am currently a student and i am studying visual basic.net so here is my problem i have to write a application in visual basic that computes the mean and standard deviation how do i write the code for this and how do i set up the sullotion explorer window please could some one help me i have been stuckon this for a week now. thanx I'm not expert in Statistics so I can tell you how you can calcualte standard Deviation. I studied it But forgotton long time ago but I can give you an Idea and tell you how to calculate mean you can Extend this example further to implement Standard Deviation: Dim num1 as Decimal ' Get value of num1 in this Dim num2 as Deci ...Show All

• Windows Live Developer Forums Filtering Address based on Country in Virtual Earth

  Hi, I am working with Microsoft Virtual Earth. I want to show Adresss. I used VEMap.Find() method to find the address. I passed street name,houseno,city,zipcode,county,state and country informations to find the address. The problem is I got the address throughout the world which matches the address. But I want to filter the address based on Country entered. So pls kindly assist me to sort out the problem. Is there a method to filter the address based on country in Virtual Earth Help me. Thanks in advance. Hi derek, Still it is not filtering based on country. I placed a DropDownList to select the country. I entered a city name that is not in the selected country. But still the map searches that city and shows t ...Show All

• Software Development for Windows Vista NTSetInformationProcess (ProcessAccessToken) fails with STATUS_NOT_SUPPORTED

  I had just created a new method to implement setuid() on Cygwin, which doesn't just call ImpersonateLoggedOnUser, but instead tries to replace the process token using NTSetInformationProcess (ProcessAccessToken). The problem with using ImpersonateLoggedOnUser is that the effect of calling setuid() can be reverted by a call to RevertToSelf(). This is contrary to how setuid() is supposed to work. For security reasons, a setuid() call must not be revertable when called from a privileged user account. So, to accomplish this, I re-implemented setuid() by replacing the process token. This works fine on all systems until Windows 2003. Guess what happens on Vista. The NTSetInformationProcess call returns with STATUS_NOT_SUPPORTED. I'm rather dis ...Show All

• Smart Device Development Enabling Phone in POCKET PC 2003

  Hi everyone, I am using Visual Studio 2005 for C++ and I wrote a program which uses tapi and sms functions. But to use them, I have to open the phone manually on my pocket pc. Is there a way to enable the phone by a function I mean, when I run my program, it should enables the phone feature of the pocket pc. I tried phoneOpen but it does not help. Thanks. ...Show All

• Windows Forms how can i determine if the current record has been EDITED & changes have been saved to database ?

  In VB 2005, 1) how can i determine if the current record has been EDITED & changes have been saved to database 2) how can i discard changes to the current record that has been EDITED Alex ...Show All

• Visual Basic VB Date to Access database - specified cast is not valid

  I have two date fields being inserted into a table in an Access database. In Access the format is set up as date/time (general). In VB it is the usual: Dim DateIn As Date Dim DateOut As Date They each store a value of DateTime.Now . The data actually gets into the database but everytime I hit submit I get "specified cast is not valid". I should note when I changed the format to text in Access and String in VB the error message went away. Below is my SQL to insert the fields into the database. Any help is greatly appreciated. Dim myInsertQuery As String = _ "INSERT INTO Test (DateTimeIn, DateTimeOut, PGMSSN, Batch) VALUES ('" & DateIn & "', '" & DateOut & "', '" ...Show All

• Visual C++ Suspected with Rational Clearcase problem when using Visual Studio 2005

  Hi, I have posted on this problem I am having before, but I have learned more about the problem so here is an updated post on it. I am trying to build an application using Visual Studio 2005 on Windows XP SP2. The build is taking place on the Clearcase drive (M drive) in a normal view. The binary is built but fails when I try to use it with the following error: The system cannot execute the specified program. Using the depends.exe facility on the binary, I have found that the problem is that the dll MSVCP80.DLL is missing. Since the binary is being built using VC 8, this DLL is contained in the side-by-side Assembly Microsoft.vc80.crt, which is itself referenced by a manifest embedded within the binary. If this manifest cann ...Show All

• Visual C# WYSIWYG HTML Editor

  Hi All I'm looking to create an application which enables the user to create PHP/MySQL (and eventually ASP/MSSQL) driven websites with just a few simple steps. Part of the application will obviously be some kind of WYSIWYG Editor for the look and feel of the website. I know there are already quite a few open-source HTML editors out there, but I need to customise this quite a bit, and I also feel it would be a good exercise for me to improve my programming skills if I program it myself. What I need is someone to tell me roughly how to start off and what steps to take. I'm not asking for detailed descriptions of every little step (and I'm sure most of you out there don't have the time to give them). I'm assuming to write the control, I'll ...Show All

• Visual Studio 2008 (Pre-release) Uri + Pack

  Hello, I've created a WPF Browser application within Visual Studio using the latest .NET 3.0 framework and Visual Studio extensions. In my project I have a single WPF Page as well as a single .htm file.  My .htm file simply states: "Hello World".  I'm trying to create a "Frame" element that displays the .htm file.  Everytime I attempt to display the .htm file, I receive an "InvalidOperationException" which states, "Cannot navigate to application resource 'pack://application:,,,/test.htm' in web browser. Am I trying to access my web page completely incorrectly   If so, how do I display/access a simple .htm file   I have attached my XAML code below.  Thank you so much for your help: <Page x:C ...Show All

• SQL Server 404 Error On http://localhost/Reports/Pages/Folder.aspx

  Setup: Sql Server 2000 Reporting service installed on separate IIS server on windows 2000 server Current issue is when going to the report manager we currently get the following error: The request failed with HTTP status 404: Not Found. I looked into the threads and check settings that said to check properties of the virtual directory and the coinfiguration and all is looking good. This was working without issue, and then it just stared to act up and not allow anyone to go to the manager. We can go to the //localhost/Reportserver and browse and get the reports to run, but the main report manager does not work. Home.aspx is there in the directory and it appears everything is go ...Show All

• Visual C# Problem to Build a project in C#

  Hi friends! I have this problem when i try build a project. Error Message Missing partial modifier on declaration of type 'type'; another partial declaration of this type exists But i can't fix the problem :( public class Formu : System.Windows.Forms.Form { private System.Windows.Forms.Button button_Send_Bits; private System.Windows.Forms.CheckBox checkBox_Pin1; private System.Windows.Forms.CheckBox checkBox_Pin2; private System.Windows.Forms.CheckBox checkBox_Pin3; private System.Windows.Forms.CheckBox checkBox_Pin6; private System.Windows.Forms.CheckBox checkBox_Pin5; private System.Windows.Forms.CheckBox checkBox_Pin4; private System.Windows.Forms.CheckBox checkBox_Pin8; private System.Win ...Show All

• Windows Forms Count Gridview rows...

  How can I get a count of the rows within a gridview Say if your Grid is GV1 and Label is lbl1 VB.Net: lbl1.Text = GV1.Rows.Count.ToString() C#.Net lbl1.Text = GV1.Rows.Count.ToString(); ...Show All

• Windows Forms setup options

  hi.. i need to add some configeration to my setup .. im developing a video conference application and i want the user to set his bandwidth when he installs the app.. and some other variabels.. how do i do that thnx The best example I can point you to would be the Passing Data to a Custom Action walkthrough: http://msdn.microsoft.com/library/default.asp url=/library/en-us/vsintro7/html/vxwlkWalkthroughPassingDataToCustomAction.asp It shows how to collect data from the user using Custom dialog boxes, and then passing them to a custom action that can then configure or set values for the application based on those values. ...Show All