Chris7432's Q&A profile

• SQL Server sql statement from webform with dynamic join, how?

  In my application the user can enter form textfields and check checkboxes to dynamically generate the SQL SELECT. Most searched values com from one table but some come from other tables with a 1:n relation. So, if needed INNER JOIN them by writing the FROM statement in a variable, that I use in the query. Like this: " INNER JOIN tCmsElementCustomProdspecArtikelZusatzStoff ON tCmsElementCustomProdspecArtikel.artikel_ID = tCmsElementCustomProdspecArtikelZusatzStoff.art_zus_artikelid " This works fine for some cases but in some cases I need to select all articles with "art_zus_artikelid = id1 AND art_zus_artikelid = id2" and for both "art_zus_v ...Show All

• .NET Development The connection's current state is Closed??

  Hi all, I'm trying to use a sqlDataReader to load data into a DropDownList on a .aspx page, but get the following error: Server Error in '/YLCPDTdb' Application ExecuteReader requires an open and available connection. The connection's current state is Closed. But havn't I opened it with the conn.Open(); statement Here's my code: private void Page_Load( object sender, System.EventArgs e)         {             / Load country names into countryCboBx             try          &nbs ...Show All

• Visual Studio 2008 (Pre-release) Interactive pages like .asmx?

  Will there be a feature in WCF that allows invoking of web service operations similar to how .asmx pages allow you to invoke WebMethods This is a very convenient feature, and useful for quick testing of services, where writing a full-blown client app is time-consuming. There is not a test page available currently, but we're working to make one available with 'developer tools' asap. Please bear with us while we get it integrated into the dev tools releases. Thanks, Ford McKinstry WCF Program Manager ...Show All

• Visual Studio 2008 (Pre-release) Smart Client: Embedded Database Or XML?

  i am undertaking research work for a smart client project. The idea is that the smart client will have offline data capabilities and will synchronise with a central server when online over a web service. i am unsure of the best way to store the data in the smart client i.e. whether to use an embedded database or pure XML. i am fairly confident that an embedded database is the best route, for data integrity and speed purposes. however if anyone could offer me any useful URL's or bits of advice on this crucial issue then i would appreciate it. as i am not 100% certain. thanks. You can read about the cachin ...Show All

• Visual Studio Team System witimport TF26177 with custom field (RTM)

  I have a template with a custom field in the Task work item type. The process template loads fine. It creates a new Team Project fine with the appropriate field performing as expected. I make a change to the Task.xml file to change the allowed values on the custom field and run a witimport against the existing project created from the same template with the new Task.xml The following error is provided: Error: TF26177: The field CBMI.VSTS.Scheduling.PercentComplete cannot be renamed from 'Percent Complete - CBMI Process Template V 1_0' to 'Percent Complete'. Team Foundation Server does not support renaming fields.   ...Show All

• Windows Forms transfer unmanaged memory to Bitmap object

  I have a program which reads raw image data from audio hardware. I am reading the data in unmanaged C++ code. In a managed C++ routine, I have a pointer to an unmanaged unsigned char array.  I would like to load a bitmap object with this data so I can display the data by calling the DrawImage method on a Graphics object. How can I t ...Show All

• Windows Forms Is a seperate DLL required for Designer support

  Hello- Some simple WinForms questions. 1) Whats the difference in the Toolbox  between the "Components" and "Windows Forms" sections 2) If I Derive a simple class from the DataGrid and wish to have it display somewhere in the Toolbox and editable at design time - like the base DataGrid - must I compile it into a DLL Or can I simply add  ...Show All

• Software Development for Windows Vista Is there any Comprehensive guide for Windows Workflow Foundation?

  Hi All, I've just started working on Windows Workflow Foundation. I need a detail guide of How to on the subject. May be something like chm files. msdn does'nt help me in the cause. If anyone has a resource as such please let me know. I agree with you that the help is not very good. I have readen a book that it is quite good to start: Presenting Windows Workflow Foundation, that you can find at: http://msdn.microsoft.com/winfx/technologies/workflow/default.aspx And now they have presented another one: Essential Windows Workflow Foundation ( Bob and Dharma's book now has a page at Amazon . ) http://wf.netf ...Show All

• Visual Studio Team System Team Project Creation Failed with Soap Exception

  This is the content of the logs. Any ideas 07/08/2005 02:54:41.607 | Module: Engine | Thread: 4 | Running Task "WSS.WssPortal" 07/08/2005 02:54:45.075 | Module: WssSiteCreator | Thread: 4 | Exception: System.Web.Services.Protocols.SoapException: Exception of type Microsoft.SharePoint.SoapServer.SoapServerException was thrown.    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)    at Microsoft.Visua ...Show All

• Visual Studio Tools for Office How to detect item class in outlook object model

  I'm working on this outlook automation in visual basic and I need to dynamically figure out what type of folder (mail, contacts, tasks, etc.) the current folder is. I tried both olFolderInst.Class and olFolderInst.Items.Class and they always return the same value of olfolder and olitem respectivly regardless of what the folder is. How do I go about doing this (1) The 'least code' way is to not cast the outlook type unless you have to, as this will work wherever the item shared common properties and/or methods i.e. use a 'helper' function to call the COM object with a late bound method, like this: &qu ...Show All

• .NET Development Update Dataset

  I have a program that uses the same database for each computer the program is run from. The program uses datasets but the problem I am running into is storing (updating) the new data. For example if program one stores a record with the primary key of "A". But Program two already stored a record with the primary key of "A" after program one's dataset was filled. When the 2nd record is added with the same primary key NO exeption is thrown, and records with the same PK are in the DB. How do I prevent that from occuring you should use autoincrement or unique fields for PK and relations. ...Show All

• Visual C# editing resource files

  I am using a ResourceManager to retrieve values from a .resource file. I would like to be able to update the values in the file from within the application. Can this be done How Thanks. Ok. That tells me where to place the data, but is there a ResourceManager like class for dealing with config files ...Show All

• Visual Studio Express Editions VWDeveloper 2005 / Password error message

  Hello! I installed the VWDeveloper 2005. Started the Personal Web Site Starter Kit and ran this a few times. When trying to create an administrative user (Web Site Menu -> ASP.Net Configuration -> Security), it says (in dutch, translated in english it is about as follows:) Minimal password length: 7. Non-alfanumeric signs demanded: 1. But whatever entered, conforming to these rules, this error-message keeps coming. Help is really appreciated. Hi Andreas, Thanks for the response. On second thoughts, before getting that far, how do I Run the site at least once before proceeding ...Show All

• Visual Studio Tools for Office Manipulate Bookmarks @ Server Side

  [Using VSTO 2005 Beta 2] I am looking for a way to change text within Word Bookmark controls at the server. I am aware of accessing the Cached objects within the Word Manifest and for instance fill a Cached Dataset with the information that I want to show in bookmarks. What I would like to know is if it's possible to change bookmark information directly using a ServerDocument. The Other thing, is it possible to databind Bookmark controls to a cached data object so that changing data in the cached object is enough to change de bookmark contents The reason for all of this is that the information is at hand at the serverside and it is needed t ...Show All

• Windows Forms name of selected listbox item

  I've tried about everything without success. It seems like such a simple question, but msdn doesn;t provide an answer. Neither did a search here. If I have selected an item in a databound listbox, and the item says 'Strategic Commentary', how do I capture that I tried any number of things, including Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim instance As String = listConcepts0.SelectedItem.ToString() MsgBox(instance) End Sub but the answer I get is system.data.datarowview Any help out there dennist685 Dim str As String = Yo ...Show All