Garethvdl's Q&A profile

• .NET Development How can I get as a table name by naming a query in the Stored Procedure ?

  Hi All, I have written a stored procedure which has multiple SELECT statement. So it is supposed to return multiple tables of rows. It is got as set of DataTables ( DataSet ) when retrieved through SqlDataAdapter. By default those resultant tables of the queries, have their table name as Table, Table1, Table2 etc. So to access a particular table, I've to do as, dataSet.Tables [ 0 ] or dataSet.Tables [ "Table" ] Is there any way to name the query and get the table by mentioning the name If any one knows a way, Please let me know . . . Thanks & Regards, K a n n a You can easily use the Dat ...Show All

• Visual Basic Partial Class for a Form?

  I have a form named frmStockDetails which host numerous tab controls. There’s bunch of code written to make each tab perform specific task. With the amount of code sitting behind, isolating code into Regions is not making it better. How can I isolation code into various Partial Classes for the form I tried adding a class and adding Partial Public Class frmStockDetails, but it create a separate node for it and also creates a form for it as well. Please help. Thanks VB uses the Expands keyword to define partial classes: Public Class MyForm    Public Sub MyMethod()    End Sub End Clas ...Show All

• SQL Server Interpolating a line for missing data points in line / bar graph

  I know I'm not the only one with this problem.  I have a set of data values I want to display as lines from left to right, grouped by month, and a series is specified.  There is no aggregation as the series/month combination is unique.  However, sometimes there is no data for a given series and month.  When this happens, my line  breaks at the previous month and starts again on the next month.  I tried using a column chart and specifying plot data as line, but I still get the same result.  Is there a way to get SQL Server Reporting Services 2000 to connect the dots with the existing data or do I h ...Show All

• Windows Forms Modify assemblies before MSI packaging

  Hi, I'd like to modify (obfuscate) my assemblies before they are packaged in the MSI by the Visual Studio Setup Project. However, it looks like it always builds before it packages the files. Is there a way to force it to take the already existing files from the primary output and use those for packaging without rebuilding them Thanks, Tom Hm, how would that help I need to build the application then obfuscate it manually and somehow get the installer project to use the obfuscated assemblies as primary output. ...Show All

• Smart Device Development "the new connection uses a data provider that is not supported"

  When attempting to estbalish any form of data connection in my mobile device project I get - "the new connection uses a data provider that is not supported" That's in designers, right (there's no such message in NETCF runtime). Which data base you're trying to connect to NETCF only supports SQL Mobile and SQL Server 2000/2003; you'd need 3rd party provider for other DBs. ...Show All

• Windows Live Developer Forums How to call a web server asyncronously without ActiveX

  My article at http://www.codeproject.com/jscript/MSNMessengerActivity.asp shows how to call a web server from your MSN Messenger Activity without using ActiveX. When the update gets added by tomarrow hopefully then it will also show how I simulated a mouse pointer so that each user can see the others mouse movements without using ActiveX.   Check them out if you need either of these techniques for your activities. With the help of DevToolbar http://www.microsoft.com/downloads/details.aspx FamilyID=e59c3964-672d-4511-bb3e-2d5e1db91038&displaylang=en   I was able to see your DOM and indeed you got the and ...Show All

• SQL Server System.Web.Services.Protocols.SoapException: The item '/foldername' cannot be found

  I am trying to figure out how to correctly reference the directory to my subscriptions: Dim subs As Subscription() = rs.ListSubscriptions( "/SSS" , Nothing ) System.Web.Services.Protocols.SoapException: The item '/Hedi' cannot be found. ---> FYI: I replaced sss for privacy purposes only here Does /SSS exist in the catalog For ListSubscriptions() to work, the item must exist in the catalog and either be a report or a linked report. If /SSS exists, but is not a report, then you should see a WrongItemType exception. ...Show All

• Visual Studio Team System Set new field - Owner inside of WI and pull values from Active Directory

  Hi, I'm trying to have on my WI field name Owner and to pull values from the Active Directory the same way as Assined to field get his own  values  from the Active Directory I Couldnt find a way to do it except of importing all the values from the active directory inside of a global list and then use the global list as optional values inside of my owner field. There must be a better way to do it Thanks in advance, Shmulik. The list of allowed values may include groups of the following types: AD group: <LISTITEM value="domain\group" /> ...Show All

• .NET Development GetElementById

  Is there any way to use GetElementById on a string which is in XML form. Currently when I try to use GetElementById it return null as the string is not in DTD form. This sample works using VS 2005: XmlDocument doc = new XmlDocument (); doc.LoadXml( @"<!DOCTYPE foo [     <!ELEMENT foo (item)*>     <!ELEMENT item EMPTY>     <!ATTLIST item id ID #REQUIRED>]>     <foo>         <item id='test'/>         <item id='xyz'/    &nb ...Show All

• SQL Server Remote Connection to SSIS

  Hello. I am trying to remotely connect to SSIS from my PC using windows authentication in SQL mgmt studio and I keep getting the following error message: --------- Cannot connect to <server> Additional Information: Failed to retrieve date for this request. (Microsoft.SqlServer.SmoEnum) Connect to SSIS service on machine "<server>" failed: The RPC server is unavailable. --------- I do not get the same error when I connect to the database engine, just SSIS. I don't have a firewall inbetween the machines either so it can't be that. Has anyone else had a similar problem if so, I would be grate ...Show All

• Windows Forms Virtual ListView (.NET 2.0)

  Greetings, I'm having performance problems with ListView control from .NET Framework 2.0 working in virtual mode. I wrote simple test program (see bellow), and  I see that framework many times repeatedly calls OnRetrieveVirtualItem method for each item (In my case sometimes it can call OnRetrieveVirtualItem ten times for each item). Is this normal Why even so simple program run too slow How can I speedup everything   My code: using System; using System.Collections.Generic; using System.Windows.Forms; public class MyClass { public class MyListView : ListView { const int ItemCount = 1 ...Show All

• Visual C++ DECLARE_DYNAMIC and IMPLEMENT_RUNTIMECLASS macros in VC8

  I have migrated one project from vc6 to vc8. In MFC they have added GetThisClass function under RUNTIME_CLASS now my project is not building. #define RUNTIME_CLASS(class_name) (class_name::GetThisClass()) static CRuntimeClass* PASCAL GetThisClass(); //////// VC8 afx.h file #ifdef _AFXDLL #define DECLARE_DYNAMIC(class_name) \ protected : \ static CRuntimeClass* PASCAL _GetBaseClass(); \ public : \ static const CRuntimeClass class# #class_name; \ static CRuntimeClass* PASCAL GetThisClass(); \ virtual CRuntimeClass* GetRuntimeClass() const ; \ #define _DECLARE_DYNAMIC(class_name) ...Show All

• Visual Studio Tools for Office VSTO 2005 Hands on Excel Lab Problems

  I'm having some trouble with trying to run through the Hands-on Labs for Excel 2003 which I downloaded from the MS VSTO 2005 site. Not sure if my problem is an installation problem with VSTO 2005, VS 2005 or Excel 2003. I can create the Hands-on project using the Excel Workbook template. However when I run the project in Debug mode I receive the following error message. Problem #1: A call to PInvoke function 'WRDomainSetup!WRDomainSetup.EverettPolicy::GetRequestedRuntimeInfo' has unbalanced the stack. This is likely because the managed PInvoke signature does not match the unmanaged target signature. Check that the calling convention ...Show All

• Visual Studio PrinttoPrinter doesn't print subreport

  Hi! I have a crystal report (that contains a subreport on demand) on a VS2003 window project. I want the user to set the page before sending it to the printing so I've created a window where I get this options, such as paper orientation, paper size and margins. I disable the print button on my CRViewer, and create a new print button that calls the report PrintToPrinter metod. it works fine when printing the main report, but it doesn't work with the subreports. How can I make this button behave as the one on the CRViewer toolbar. I don't care if I cannot have the select printer dialog, but I would like to print only the "active tab& ...Show All

• Visual Studio Team System You are not authorized to view this page

  Hello, After installing tfs I found the team foundation server admin site at port 8080 but while trying to access that page from another system always give the forbidden http error 403  I configured teamserver to allow anonymous access and I invited the person trying to access the page from another system. (the basic teamserver webpage is also unreachable from the server itself). the same goes for the sharepoint server which was installed as the default webpage on the system. Can I try to reinstall sharepoint and/or team server to correct this problem greetings, Rudy   I received this same err ...Show All