psyjon's Q&A profile

• SQL Server Store the output of executesq

  hi I am trying to store the output of sp-executesql into a variable to implement it as a user defined function later The function is ALTER function [dbo] . [UnitsAvailable] ( @id int ) returns int as begin declare @sql nvarchar ( 100 ) declare @params nvarchar ( 500 ) declare @count nvarchar ( 10 ) set @sql = N 'Select count(*) from units where projectid=' + convert ( varchar , @id ) + 'and sold=0 and displayunit=1' set @params = N '@countOUT nvarchar(10) OUTPUT' ; exec sp_executesql @sql , @params , @countOUT = @count OUTPUT ; return @count end The r ...Show All

• .NET Development CodeDOM - Reflection question

  I want to read a type from an assembly using Reflection. I want to use this information to map it to a CodeDOM representation. My question is this: Is there any way to get the information about what namespaces the type references e.g. assume : namespace X { using namespace Y; interface ISimple {/* whatever you want goes here*/} } this will get compiled into a library. I use Reflection to inspect the library, find interface ISimple and rebuild a CodeDOM representation of the interface. Accessing the namespace in which ISimple is declared is easy through the namespace property on System.Type but how do I get the information about the us ...Show All

• Smart Device Development C# calls Native DLL: Class not registered. Please help...

  I am just trying to call COM Object from Windows Mobile 5.0 Device from Visual Studio 2005 using C#. I have a native com dll and I can  call it from Windows application. But when I tries to call the same dll from smart device, it doesn't work. It breaks in the com object. However, when I add the dll, it get all intellisense. The error is like: An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in CEHarness.exeAdditional information: COM object with CLSID '{1B103B23-1243-11D5-94C4-00062999C513}' cannot be created due to the following error: Class not registered . After that I went trying the M ...Show All

• Visual Studio Report is opened and displayed on development machine but not on the production server?

  The report, a part of ASP.NET application developed in VS 2005, opens on development machine but does not open on the production server. The process goes up to the oracle database login screen. After providing the credentials, nothing happens on production server. Please help. Tariq ...Show All

• Smart Device Development Popup submenu not working correctly (eVC4 project imported to VS2005)

  I have a popup submenu "Preferences" as an item in the "File" menu in the command bar. The command bar also contains a "Function" menu. In the eVC4 built application, when the user taps on the "File" menu, then selects the "Preferences" popup submenu, a new menu appears alongside, with a set of preference items to select. However, in the VS2005 built application, when the user taps the "Preferences" menu item, the menu that appears is not the preference items, but the "Mode" menu. I have no idea what is going on, and would appreciate some help in finding and fixing the cause of this problem. I haven't made any changes to the menus sinc ...Show All

• .NET Development Using partial trust client with fully trusted assembly

  I'm trying to understand what happens when a web client set to medium trust calls a fully trusted assembly in .Net v2.0.  I have a simple assembly that is signed with a strong name, and has been granted full trust using: caspol -af fulltrust.dll.  The fulltrust code has an assembly level attribute to allow partially trusted callers:  [assembly: AllowPartiallyTrustedCallers]. In most cases, this works as I would expect.  That is to say the web client can access methods in the fulltrust assembly without any problem.  However there is one case where it fails, and I'm trying to understand why.  The method in questio ...Show All

• Visual Studio ReportViewer background WebForm problem

  Hello all, I have a webform with a ReportViewer control in ProcessingMode= Local. I put a BackgroundImage on my rdlc with the Source=Embedded and some textboxes. The ReportViewer loads at runtime this rdlc correctly ...the background appears but the problem is that when I try to scroll down or to zoom, only the data from the textboxes are 'scrolled' or 'zoomed'...am I missing something What can I do to scroll and zoom in/out the background, too I've tried to put an Image on my rdlc with an embedded source with the option Send To Back and the textboxes over the Image. I've seen that at runtime the image is scrolled and z ...Show All

• Visual Studio Tools for Office How can I load VSTO project from Winform Application?

  It may sound like a silly question: "How can I load Excel Workbook in VSTO from Winform Application " I'd like to use VSTO for the statistical report on data. When I build and debug the workbook, it works fine; however, I'm having trouble loading the workbook from another application. Loading dll file with showdialog() only shows the class file associated to the excel project instead of entire VSTO project. Please help~~~ well Jan,you hav used Com , i want to create a VSTO Word object, so i can pass it to some other class, perform some action, and then show it, just like we do in Com Word ...Show All

• SQL Server Cannot get the Service Broker work

  Some months ago I was playing with Service Broker and everything was ok. But now I just can't get it work. I opened a sample "helloworld" project and still cannot get a message in a target queue. No errors, just empty queues. We have two SQL servers sept CTP on different computers and both give the same issue. It looks like it should have a very simple solution that I cannot come up with. The following script initializes service broker and sends a message, then selects both target and initiator queues. On my environment it just returns two empty selects. --Initializing service broker objects use master GO S ...Show All

• SQL Server Passing rc:Toolbar=False in URL causes report to render incorrectly

  I have a report that just displays different status images based on some data. I use an expression to choose an embedded image in the image property of the image. This report needs to be displayed in Sharepoint. I have tried using the report viewer web part, a page viewer web part, and a content editor web part, but whenever I try to view the report without a toolbar, none of the images are displayed. I pinned this down to the rc:Toobar=False parameter. How can I display a report without the toolbar Is this a known bug that is being worked on Thanks, Scott Does the report behave as expected out ...Show All

• Windows Forms Multithread

  I' ve got a winform with 12 datagrids and I tried use multithread for populate datagrids simultaneously. I know that it's need use method invoke, but I don't can do this yet.   Anyone can help me Hi Kamako, Can you explain the problem in detail. How are you filling the dataset.If possible post the code. Thanks, Manish  ...Show All

• Windows Forms replacing char during digit on datagridview

  Hi all :) Here is my problem: private void dataGridView1_EditingControlShowing( object sender, DataGridViewEditingControlShowingEventArgs e)         {             dataGridView1.EditingControl.KeyPress += new KeyPressEventHandler(EditingControl_KeyPress);                     }         void EditingControl_KeyPress(Object o, KeyPressEventArgs e)         {      &n ...Show All

• Visual Studio Express Editions vb.net build a program now.

  The vb.net build a program now! Is never shown in the regesteration benifits Link. The C# version is there but not the VB version. Here is my linkfor VB: http://go.microsoft.com/fwlink/ LinkId=52054 It is the same as the C# link. These express packages are great! Thanks!! Hey Arnie, Thanks for the feedback Both eBooks should be there if you registered both VB and C# Express. Did you register both products Thanks, Dan Fernandez Product Manager http://blogs.msdn.com/danielfe/ ...Show All

• Visual Studio Team System Changing passwords. Beware! :)

  If you change the pasword of your TFSService/TFSSetup/TFSReports accounts, beware. You need to change the password on the following components: Services: ====== TFSServerScheduler Sharepoint Timer Code Coverage Analysis Service Application Pools (IIS) =============== Check them all : You should change the passwords which use the TFSService, TFSSReports or TFSSetup accounts. Shared Data Sources on Reports Server ========================== Change the passwords for the OLAP and DS shared data sources, and for any other Shared Data Sources, Models or other objects as the case may be. Any other places   Please post There is a T ...Show All

• Visual C# Multicast delegates with IEnumator and yield return?

  Hello, I am trying do set up a multicast delegate to split my yield returns for a WebTest I am writing, but only the last delegate is firing.  Is this a known problem, by design, or am I doing something wrong Thank you, --ben hii all, First time I am just learning Delegates in c#. I have faced a conceptual problem. In books it is written that A Multicasting Delegate should have a return type of Void unless it will throw a run time exception. But i am written a code snippet with a Multicasting Delegate with a string return type .But it is not throw any exception at all. Can anybody tell me what is ...Show All