cplusplus1's Q&A profile

• SQL Server help

  hi i have table with folowing columns (subid,itemid) i want to write select stmt to get subid where itemid =all group of value('1','2') like this Select subid from subscriptionItem where itemId in all('1','2') but this stmt not work help me Hi, If you mean you want those SubID that have both ItemID 1 and 2, then the above will not work. what you should is.. Select SubID From subscriptionItem Where ItemID in (1,2) group by SubID Having count(0) =2 Assuming that the combination SubID and ItemID is primary (unique). If they are not unique, which I doubt, then try: Select SubID FROM (Select distinct SubID, ItemID from SubscriptionItem where ItemID in (1,2)) si Group by SubI ...Show All

• SharePoint Products and Technologies Problems with Site Content Type Template using PDF

  I am working in MOSS 2007 and am creating new site content types. I have used word documents here and also InfoPath forms. However I also want to use a .pdf file as a template here as well, it is actually the standard government W4 form. I have created a new Site Content Type in the Site Content Type Gallery, named it W4, set the parent content type to Document Content Type / Form. I have also tested using the Parent Content Type of Special Content Type / Unknown Document Type. Then I go Advanced Settings on my new Site Content Type and Upload a new document template and hit OK. The new template that I upload is the W4 form. I then go to my document library and add a New Content Type from Existing Site Content Types. I selec ...Show All

• Windows Forms How to add foreign key automatically

  Hi, I'm a novice ADO.NET programmer I have two tables - Company & Persons Company table fields are - company_id(autonumber,Primary key), company_name, address_1,address_2,city,state,pincode,phone_number. Persons table fields are - company_id, person_name, email_id (here person_name and company_id forms the composite key) Both tables are related through company_id. I have already set the relation with referential integrity applied. Now on my main form I have a combobox for company_name, and textboxes for the rest. Also below i need a datagridview for the related records in the contact table, with only the contact names and email (no company_id should be shown there), I should be able to insert, delete and update the details in it. My ...Show All

• Visual Basic VB for repair center installer disk?

  Hello All: I am tring to find out if Visual Basic is the best tool I can use for a project I have in mind. I am not a programmer, but this seemed to be a good place to start. My project is to create a multi installer disk for the repair center I work for, that can do the following: - Run off a DVD - Be Bootable - Create a temporary storage area (ramdisk ) for a text file containing customer data and authorization codes. - offer partition and format options for FAT and NTFS, one and 2 partitions on a primary disk (I would probably include the fdisk and format utilities, then just create menu options for them) - Allow unattended installation and configuration of the following : XP Pro OEM XP Home OEM XP Pro or home w/ NAV XP Pro o ...Show All

• Microsoft ISV Community Center Forums Deleting Macro

  I want to delete the macro recorded in my excel file but the "delete" button is disabled. Is there another way to delete all macros thanks... Hi Your macros will have been recorded in a module. Right click the module and select remove module, say no to export unless you want to save the code to a file. ...Show All

• Visual Studio Team System TFS without VS Team System edition?

  I'm a dev manager for a small shop (8 web and 5 desktop developers) and we have been using Visual SourceSafe for the past 6-7 years. I've been wanting to change our version control software for some time now and am interested in what TFS might do for us. The web devs are all on VS 2005 Pro now and the desktop devs are still using VS 2002 for now. In everything I have read about Team Foundation Server it seems to assume that the developers are all using Team System editions. The pricing seems to be a significant jump in going to Team System and I'm really not sure how much benefit it will add. What I want to know is can we use TFS for version control with VS 2005 and VS 2002 by purchasing individual CALS instead of upgrading to Team System ...Show All

• .NET Development Problem with format of xml file created from dataset

  HI I have a connection to excel that retrieves data to a dataset. Its working fine, my problem is organizing the data so that I can record it to the data base. I’m trying to do it by converting the data to xml, so that I can ask the user to relate the column name (in the excel file) with the correct place in the database. And parse to the retrieved data. The code so far is: Dim cn As System.Data.OleDb.OleDbConnection Dim cmd As System.Data.OleDb.OleDbDataAdapter Dim ds As New System.Data.DataSet() cn = New System.Data.OleDb.OleDbConnection( "provider=Microsoft.Jet.OLEDB.4.0;" & _ "data source=C:\2.XLS;Extended Properties=Excel 8.0;" ) ' Select the d ...Show All

• .NET Development Using managed C++ DLL in a C# console application on Windows Server 2003

  I am trying to use a Managed C++ dll in a C# application, simply creating an object of c++ class in the C# class constructor then there is an error saying the c++ dll cannot be loaded when this is running in Windows Server 2003 OS. But the same is working fine in Win XP SP2. what could be the problem. C++ class in the C# class's constructor C# class is Sample() Sample() -- constructor { C++ class:: cppclass = new CppClass() } I am pasting the error message here: Unhandled Exception: System.IO.FileLoadException: Could not load file or assembl y 'cplus_dll, Version=1.0.2460.31783, Culture=neutral, PublicKeyToken=null' or o ne of its dependencies. This application has failed to start because the applica tion ...Show All

• Software Development for Windows Vista WinFX Runtime Components 3.0 Beta 2 installation problems

  Hello, I was using the February CTP until Beta 2. I’ve downloaded the new WinFX Runtime Components 3.0 Beta 2 and I can’t install them. I’ve uninstalled older version using the tool Microsoft has provided ( the MSI file ) and I’ve also removed several other components that I thought could cause the problem. I’m still receiving the following error: [05/24/06,00:29:52] VS Scenario: [2] CPrevProductInstalledCheck failed : <font face=Verdana size=8pt> Thank you for participating in the Beta program. You must uninstall all pre-release products in a specific order before you can continue with setup. For detailed information, see the <a color=#3F4F7F HOVER-COLOR=#C3120C href="http://go.microsoft.com/fwlink/ LinkId=54981">u ...Show All

• Internet Explorer Development Still another report on this...

  Having an intermittent problem printing To: From: CC: Subject: Attachments: headers on emails. Usually happens with larger emails or emails with large attachments or emails that have been replied to or forwarded from other people. Have installed Generic/text printer and sent the email to this printer but sometimes the headers are still missing even printing this way. I have if I open the offending email and highlight just one or two words in the text of the email eg Dear John and then print the email using my HP printer (not as text on Generic printer) - the headers then print and so does the selected words. Don't suggest using Outlook as often we only print the first page of emails as we already have the rest of the email on file especial ...Show All

• SharePoint Products and Technologies ListItem Update Failure

  Hi I'm trying to create a dynamic list and filling it with items of already created fields... ////Code is something like this guid = web2.Lists.Add( "ViewHistory" , "Desc" , SPListTemplateType .GenericList); SPList combine_List_web2 = web2.Lists.GetList(guid, true ); foreach ( SPListItem item_history in invoiceItems_history) { SPListItem newItem = combine_List_web2.Items.Add(); newItem.Fields.Add( "InvoiceID" , SPFieldType .Text, false ); newItem.Fields.Add( "Status" , SPFieldType .Text, false ); newItem.Fields.Add( "Author" , SPFieldType .Text, false ); newItem.Fields.Add( "Time" , SPFieldType .Text, false ); newItem.Fields.Add( "Text" , SPFieldType .Text, false ); newItem[ "Inv ...Show All

• Visual Studio Tools for Office Help need with Infopath 2003 toolkit for Visual Studio 2003

  Hi i am using infopath 2003 toolkit for visual studio .NET 2003 and i am programming on that, but i m new to this application so no where i get any sample simple applications like how to hide menus and how to add menus and how to bringing up dialig.... can u please guys give me the path where can i get samples with programming with infopath solutions in .NET 2003 Thanks & Regards There's lots of content created by the InfoPath team. Start here: http://www.msdn.com/infopath ...Show All

• SQL Server Newb question

  If I am using Ado.Net from a .Net Class library hosted outside SqlServer to do Sends and Receives do I have to use anything else other than queues The reason I am asking is because I already have an abstraction layer for a couple of our queueing systems and I was hoping to put SSB in there as well but the abstraction layers' primitive is the Queue not Conversation/Dialog/Service, etc. Thanks Costas Rushi, thanks, I think that's where my ability to comprehend the service broker external call breaks down. All samples, articles, etc discuss it from the point of view of internal services talking to each other through dialogs which is not what I want to do or is it Are you implying that my "from" serv ...Show All

• SQL Server Novell

  I have not read anything about SQL running on a Novell server. Does any one know if SQL will run on a Novell Server ...Show All

• Visual C# How to diplay HTML data from DB in grid view ?

  I have saved data in sql server 2000 table with HTML. Like this: <a href=’abc.apx’>ANY TEXT</a><br/> But when I bind dataset to Grid View server control, text appears same as it is in DB. What is the solution Please note that requirement does not allow me to set columns(template) at design time. Hi, Zeeshan The Grid View just show the data in the DB as string format, it knows nothing about the HTML code. Why not use DataGridViewLinkColumn or (DataGridViewLinkCell) to create a column that have link property. Reference to: http://msdn2.microsoft.com/en-gb/library/system.windows.forms.datagridviewlinkcolumn.aspx Thanks ...Show All