mcbsys's Q&A profile

• Visual Studio 2008 (Pre-release) Insert statement generated in a one-table-per-class inheritance

  Hi. Referring to the scenario explained here http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=858062&SiteID=1 I'm trying to do some test. Read, delete and update operation works well, so let's focus on insert. Using the model above I wrote try { SciFiBook sfb = new SciFiBook(); sfb.ID = 10; sfb.Title = "SciFiBook"; sfb.ISBN = "123465789"; sfb.ExtraProperty = "Description."; BooksContainer.AddObject(sfb); BooksContainer.SaveChanges(); } catch (Exception exp) { } I obtain an exception on the SaveChanged method call that says The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SSciFiBook_SBook". The conflict occurred in database "Books", table " ...Show All

• Software Development for Windows Vista Used of AddAutomationFocusChangedEventHandler in WPF application

  When I used AddAutomationFocusChangedEventHandler function into a WPF Application, my application freeze. If I create another console executable just for using AddAutomationFocusChangedEventHandler, I have not problem. Example when I use WPF menu from my application, this application freeze. Have some people have problem with this function into WPF application Thanks. public ComponentAutomation() { ThreadStart threadDelegate = new ThreadStart(ThreadOfFocus); workerThread = new Thread(threadDelegate); workerThread.Start(); } public void ThreadOfFocus() { focusHandler = new AutomationFocusChangedEventHandler(OnFocusChange); Automation.AddAutomationFocus ...Show All

• Microsoft ISV Community Center Forums ADO Recordsets

  I have a routine in Excel, which pulls data in from a SQL Server database into two ADO Recordsets using two seperate queries. These recordsets contain only 1 field, being customer ID, each with in excess of 65,000 records. I need to compare these two recordsets to establish how many customer IDs are present in one, but not the other and vice versa. Is there some clever way of looping I could use to achieve this The only other thing I can think of is a local query within my module on the two datasets, but is this possible Cheers for any help! Keith Cheers for that! Is there a private messaging facility on the forum which I can use to send you my email The only thing I can think of tha ...Show All

• SQL Server Cannot find the queue 'SqlQueryNotificationService-{guid}'

  I am trying to get my application running on a customer site. They are being very picky about security on the database.  What are the correct permissions to setup to allow my sql user to use the Service Broker. Currently I am receiving the following error: Cannot fin the user 'owner', because it does not exist or you do not have permission. Cannot find the queue 'SqlQueryNotificationService-<guid>', because it does not exist or you do not have permission. If I make my user db_owner it seems to work on other installs. Thanks so much, ~ Steve Based on the service name, this seems to be a SqlDependency case, isn't it Can you explain which command do you run when you're getting t ...Show All

• Visual Basic Com Library overloaded methods with optional parameters

  I am trying to export some data from a datatable to a new Excel document via the Microsoft Excel 12 COM library. I have had a few problems trying to get this to work: 1. The EXCEL.exe process would stick around long after excel itself and the running application closed down. I have gotten around this issue by releasing all of objects created using the Marshal.FinalReleaseComObject() method. 2. The Excel.WorkdBook.SaveAs method is overeloaded 3 times. Each one of these methods contain ONLY optional parameters. I have tried to access this method using Type.Missing for the parameters I do not require, but I continually get a COMException thrown with "HRESULT: 0x800401A8" when it hits the SaveAs method. Visual Studios 2005 does not ...Show All

• SQL Server Logging difference between Designer and SQL Agent package executions

  After fine-tuning my package logging, I built a query against SYSDTSLOG9 that uses the combination of the OnPreExecute events and any subsequent event for each task to build a nice view of a package in progress, including the duration of each event. (Running tasks would have a row with a NULL EndTime.) When running the package within the Designer, everything works as expected. Events are logged at the task level and everything bubbles-up to the package level. However, when I run the package from SQL Agent (using the SSIS job step), none of my OnPreExecute or sub-component events are written. That is, I only get package-level OnInformation, OnPostExecute and OnError events. This means when the job/package is executing, I can't directly see ...Show All

• Visual Studio Team System Automated Testing in VSTS

  Any suggestions on a test language to use for regression testing I understand VS2005 has automated unit testing, but I am looking for the best tools to create automated box level tests. Thanks, integration is important. I'm assuming more tools will integrate as time goes on, but we're trying to plan our automation now. ...Show All

• Smart Device Development How to suspend and resart a particular thread.

  In my application there are three thread runing.I have assign Name to all of them.Let Say Name are A B C Now in one of the method of thread A i want's suspend the thread B then resume it. How Can I do it While there currently exists methods outside of CF that can suspend/resume another thread they will be made obsolete and only debuggers will be able to suspect another thread or the thread itself can suspend itself. It's not safe to arbitrarily suspend another thread: you don't know the state of any of the invariants the thread is modifying and could leave data the thread is modifying in a indeterminate state or leave locks locked that cannot be unlocked (both synchronization and file-system based) resulting in deadlocks. The ...Show All

• Visual Basic FlowLayoutPanel

  Hello All, I am trying to use the FlowLayoutPanel control, but I'm having a real challenge. I am dynamically (at runtime), trying to add text boxes and NumericUpDown controls to a FlowLayoutPanel. Formatting is my problem. In one cell, I want to add a textbox followed by a space or 2 and then the NumericUpDown control. I can’t seem to come up with the right combination to format this. Any ideas Thanks very much. As an alternative, you may want to check out the datagridview. The table layout panel is a great tool, but depending on what you are trying to do, the datagridview may be a better match... Best regards, Johan Stenberg ...Show All

• Visual Basic updating totals

  I have a form which shows total sales from an Access database, via a SQL string, when it is loaded. My form also allows me to add additional sales, however, I am unable to update the total sales field without closing and reopening the form - could anyone help me please Happy Christmas. I am using VB2005. you have to requery the database table.  Just because you linked a control to a query doesn't mean that query re-runs after table changes.  Place the query logic in a function.  Call the function on the form load event.  Then call the function after each time you add/modify information in that table. ...Show All

• Visual Studio View Pending Checkins

  I am creating a custom source control.Is it possible to populate and display the View Pending Checkins window in the Visual Studio with my custom source control If yes, hw do i do it pls help. Thanks Carlos.But how do I obtain a reference to the DTE object in a VS integration package Do i have to create a seperate addin for this Is there any other way in which I get a reference to the DTE ...Show All

• Visual Studio 2008 (Pre-release) Problem in running WPF Application

  Hi guys, I have developed one sample WPF Application. And i wanted to run the sample WPF application in other client machine. I installed the .Net Framework 3.0 in that system. .Net framework 3.0 includes WPF, WCF. After the installation and i run the application it didnt run properly. Because the WPF is not installed. But once i installed it seperately (which i download it separtely from some other site) the WPF got installed properly. And after that the sample application run properly. So my doubt is whenever .Net framework WPF not installed automatically is it manually be installed seperately Why the problem occurs Can anyone pls help me Thankfully, cssjm Could you gather the setup logs from the client machin ...Show All

• .NET Development Parsing double value from a string

  Hi all, I need to parse a string which is in the following format (example): -0.0004 USD/Tonnes Basically, it will be a double value, might be preceded by the negative (-) sign and followed by <Currency>/<Unit of Measure> . The result should be just the double value (with the sign if its there), as in the above example, it should translate to -0.0004 I wanted to know if there is an easy way of doing it in C#, like using the Double.Parse() or the string.Format() methods (I tried them both but couldn't get them to work) Or do I have to parse the string character-by-character to get the required result Thanks in advance, MadMonk P.S.: Apologies if its a silly question, I'm still a newbie in .NET ...Show All

• Visual Studio Team System Schema compare adds existing role memberships

  Hi, We've got a recurring problem with Schema Compare. I can do a schema compare which picks up a new role membership, click 'Write Updates' and then click Refresh and it offers up the same new role membership. As such my RoleMemberships.sql file now looks like this: 1 2 EXEC sp_addrolemember N 'db_owner' , N 'ct\sysminerva-deploy' 3 GO 4 EXEC sp_addrolemember N 'db_etl' , N 'ct\sysminerva-etl' 5 GO 6 EXEC sp_addrolemember N 'db_svc' , N 'CT\svc-ifdsql-ppdm' 7 GO 8 9 10 EXEC sp_addrolemember N 'db_owner' , N 'db_etl' 11 12 GO 13 14 EXEC sp_addrolemember N 'db_owner' , N 'db_etl' 15 16 GO 17 18 EXEC sp_addrolemember N 'db_owner' , N ...Show All

• Visual Basic FTP server question

  I need to retrieve jpeg's from a server. Let's say the ip is \\123.45.67.89 This server has say 200 jpeg's on it. When I double click in my listbox the name of the jpeg I'd like it to go out and get that file from the server and place it into a picturebox. I have this working locally. Thanks Thanks Spotty, that worked ; however, is there a way I can load it directly into the picturebox without having to save it to the local disk first ...Show All