22Pom's Q&A profile
SQL Server Unhandled InvalidOperationException
I have a database table called Qlinks, with two columns, URL and Name. This table is displayed on a form also called qlinks, in a details view. When I try to save data after i've deleted a row of the table, O get a yellow po-up telling me that the InvalidOperationException was unhandled. The error is " Update requires a valid DeleteCommand when passed DataRow collection with deleted rows." Please try to help, I am just a beginning programmer who doesn't know much. Code samples greatly appreciated. Thanks in advance. Ha, I didn't expect a reply after so long. I posted this last year. SQL 05 express doesn't seem to work very well on my computer. (I think it has something to do with the amount of memory I have.) I gave up on this one lon ...Show All
Visual Studio 2008 (Pre-release) How to return datatable from a typed dataset using WCF service and Jun CTP ?
How to return datatable from a typed dataset using WCF service/ Hi, In one of my application I am using the Typed Dataset that contains many tables. I want to return a particular Datatable form the dataset as following. -------------------------------------------------------------------------------------------------------- Case 1. The following code is working, but the problem is I can not use .EnforceConstraints = false property as this property only available with Dataset. (I want to use this property because I want to return only selected fields from the table and rest of the fields may have not null columns) mydataset.vemployeedatatable itypedstest.get ...Show All
Windows Forms How to prevent ComboBox auto DropDown
Hi, I'm writing a custom CheckedComboBox with a multiple item select future but when I select an item from the dropdown menu, the dropdown menu automatically closes. How can I keep it open to select more than one item thanks for any help. Hi Bluehunter, It looks like you are trying to make a custom combobox based on the System.Windows.Forms.ComboBox. Without access to the underlying code this might be difficult. Remember that a combobox basically presents a listbox after pressing on a button. So if you are making your own combobox, you can have your button present a listbox by your choice. Of course this can be a multiple select listbox. This way it's you that determines what happens on the listbox events. So yo ...Show All
Visual C++ Same verification messages popup twice
Hi, I set DDV_MinMaxInt with a range of values for an Edit box in my MFC based application. When I enter a value is not in the ramge, the verification message box will poped up. After I click "OK", the same message box will pop up again. Does anyone have a idea why that happends Okay..., I found the answer. The DDV_MinMaxInt is called both in UpdateData function and base class CDialog::OnOK(). So if you don't want same message popup twice, do update data yourself instead calling the UpdateData(true) function. ...Show All
Software Development for Windows Vista creating registry key in HKEY_LOCAL_MACHINE accessible by all
Hello, Basically I have an application (dll) that allows admins to configure a system wide configuration that is accessible (read-only) by normal users. The system wide configuration is stored in HKEY_LOCAL_MACHINE\Software. The code of course works on Windows 2000/XP but not on Vista because of, as I suspect, the fact that the information is stored in the virtual store under HKEY_CURRENT_USER. When the admin stores the new configuration and a normal user attempts to use the configuration (in a different security context) they receive a unknown registry key error as the information is, of course, not available. As I understand reading through the forum setting the "run-level" using a manifest file allows me to skip the virtualization and w ...Show All
.NET Development XPath finds no nodes
Hello again, I'm still having trouble getting XPath to work in my C# program. Here's my code: XMLquery = "/df:xtvd/df:schedules/df:schedule[@df:program='EP7079270103']" ; XPathDocument document = new XPathDocument ( @"..\..\zap2itxml.xml" ); XPathNavigator xpn = document.CreateNavigator(); XPathExpression query = xpn.Compile(XMLquery); XmlNamespaceManager manager = new XmlNamespaceManager (xpn.NameTable); manager.AddNamespace( "df" , "urn:TMSWebServices" ); query.SetContext(manager); XPathNodeIterator nodes = xpn.Select(query); while (nodes.MoveNext()) { XPathNavigator Nav2 = nodes.Current.Clone(); Nav2.MoveToFirstAttribute(); txtSelect. ...Show All
SQL Server Failed to launch 'osql'
I use one-way Transactional Replication on 38 servers with same configuration. On one server I have problem with OSQL.EXE path. On Publication properties -> snapshot -> Additional scripts -> Before applying the snapshot, execute this script: Is set preinit script (C:\ReplData\ReplPreInit.sql). On Distribution agent properties -> step "Run Agent" I set additional command for log problem. command= -Output C:\ReplOutFile.txt -Outputverboselevel 2 Here is part of ReplOutFile.txt: -------------------------------- The osql command is: "C:\Program Files\Microsoft SQL Server\80\Tool\Binn\osql.exe" -U"***" -P"***" -i " \\STROSBB\ReplData\unc\STROSBB_antikor_DataCDB\20060908104051\Rep ...Show All
Gadgets Sidebar Always on Top after loading
Just an observation, but if you exit Sidebar and then reload it. It goes into "Always On Top" mode until you've clicked on its transparent background! Sorry, it's a bit more complicated than I first realised. Using the Clock as an example 1. Detach it from Sidebar 2. Set it to "Always on Top" 3. Attach back to Sidebar 4. Exit Sidebar 5. Load Sidebar The Clock now remains "Always on Top" until you click on the Sidebar transparent background. If you want some real quirky behavour: 1. Remove all Gadget from Sidebar 2. Add Clock and my Media Player 3. Detach them both from Sidebar 4. Expand Media Player so you can see the playlist 5. Set Media Player to "Always on Top" ...Show All
Visual Studio Changing Datasource at runtime results in several errors
THe following applies to Crystal Reports for Visual Studio 2005 v10.2.3600.0 When I change the datasource of a report at runtime to anything other than my development machine, I am getting the following errors... "The field name is not known." "Error in File..." "Error in formula <Monday>" ' { @StartDate}' This field name is not known Note: **This paramter is created from the stored procedure used to create the report Failed to open a rowset, procedure expects parameter @LocationID which was not supplied. Note: **the parameter is supplied during runtime I have reproduced the following several times. 1. Created a report that gets data from a stored procedure having parameters on sql server 2. create a vb.n ...Show All
Visual Basic Calling ActiveX Dll From VB Exe
I'm writing a code where i have to call a method in an activeX dll using the "CALL" method. The problem is, an error occurs which says that "Entry point not found in dll". Can some1 plz help me with some info on "Entry point" for VB dll The Dll is also a custom one coded in VB and not a part of the windows API I can call the method by using the reference(Project | Properties | references | COM (tab) but i just wanted to know if i can calll it using the CALL method... I've already declared it as a function.....i.e Protected Declare Function GetAsyncKeyState Lib "user32" ( ByVal vKey As Integer ) As Integer How do i specify an entry point ...Show All
SQL Server Assigning default aggregate function to calculated member
Is there any way to assign a default aggregate function (e.g. SUM) to a calculated member just like we can do this with a regular measure What I need to do is assign a custom calculation in my calculated member at the lowest grain (e.g. scoped at Date.Members and Customer.Members). Everything above this should be summed by default, e.g. Sales Territory. Unfortunatelly, it is not possible to assign aggregation function to calculated members. If you need to aggregate them - you will have to do it manually with MDX. The workaround is to use regular dimension members without data instead of calculated members, and assign MDX expressions to them. ...Show All
SQL Server SSIS package
Guys I've migrated a SQL Server 2000 DTS package over to SSIS (which seems to have worked), its a really simple package with just one item, it first checks for a tables existance and deletes if necessary, then recreates the table and then inserts data from a selection of other tables, except its only creating the table no data is being inserted, yet the script to insert data works as I've tried it in a query. Any ideas Thanks inadvance Duncan-Countrywide wrote: Hi Jamie After some investigating I discovered that it was the drop object first option, technically the table didn't exist, I had thought it would have been a check statement like if it exists..... obvisouly not, anyway I've ...Show All
Connected Services Framework CSF 3.0 Lite installation error # 1609
I am trying to install CSF3.0 developer version on my XP box which is SP2. I have installed all the pre-requisite components. I am getting the following error message during the installation. "Error 1609. An error occurred while applying security settings. aspnet is not a valid user or group. This could be a problem with the package, or a problem connecting to a domain controller on the network. Check your network connection and click Retry, or Cancel". I have downloaded CSF lite from MSDN website. Did someone else also face the same problem while installing CSF lite on XP SP2 Please help. Thanks, Srid I am also try to install CSF 3.0 but I have following problem ...Show All
Windows Forms "datagridviewcomboxcell value is not valid" when i want to bind object to datagridviewcell
Have anybody have idea to solve my problem!! i have a class name clsProductUnit, have 2 properties, Unit and Price. (This Class represent Unit of Product) Assume that "A product have 2 Units" when user select product, i bind 2 objects of clsProductUnit to comboboxcell (I bound by using object, not string) PROBLEM OCCUR when user dropdown and select any Unit from combobox It will show "datagridviewcomboxcell value is not valid" I think problem occur because, grid try to convert my selected value (which .net determine in string to object(clsProductUnit)) PS! In this combobox column, i already set proerpty of "valueType","DisplayMember","ValueMember" ...Show All
Visual Studio MSDN in shared location
Hello there, I have installed MSDN library for VS.NET 2003 in a machine in the network. It should act like a web server. How can I view those documents from my development machine, Since it consumes more space I don't want to install the MSDN Library in my development machine. It is something like viewing a webpage on the browser. How can i achieve this Thanks in Advance, Sekar Hi Sekar, You can perform minimum installation on MSDN VS 2005 library if Visual Studio 2005 is installed. Minimum install option is only available if VS 2005 is installed and the limited set of documenation related to VS 2005 are installed. This is little different than MSDN for VS 2003. In VS 2003 in minimum installatio ...Show All
