Runningdog's Q&A profile

• Visual Basic Simple Question on Datareader

  Hi, I want the datareader to load data in one table based on certain cretaria match in other table in which case both the tables are linked like this Both tables have pkid as primary key fields and compaddress is linked to compmast through cid field. cmd.commandtext="select pkid as cid, compname from compaddress inner join compaddress on compmast.pkid=compaddress.cid where compaddress.city like '%Bangalore%'" dr=cmd.execut ...Show All

• Windows Forms Data Binding to a simple entity object breaks after update from webservice

  Hi, I have a form that i am binding simple fields to my business entity object. The binding works fine on load, and changes to fields in the form are being pushed into the object. In addition i can update the objects properties in code&nbs ...Show All

• SQL Server linked server exec stored procdure results in Transaction context in use by another session.

  I am using sql 2005 beta Microsoft SQL Server Management Studio (expires in 355 days)      9.00.1116.00 Microsoft Analysis Services Client Tools      2000.090.1116.00 Microsoft Data Access Components (MDAC)      2000.086.1830.00 (srv03_sp1_rtm.050324-1447) Microsoft MSXML      2.6 3.0 6.0 Microsoft Internet Explorer   ...Show All

• SQL Server "certificate not found" for second receiver

  I am trying to test load balancing between multiple broker service instances. I have set up one sender and two receivers. When I tried sending a lot of messages from the sender, I noticed that all messages were being received by receiver 1 alone. While I am able to communicate between sender and receiver 1, I am not able to send message to the second receiver (I stopped the first receiver instance to find this out). I receive the "certifica ...Show All

• .NET Development using XML with Excel

  I have an Xml document that is quite strait forward. I can use a XSL document to format it correctly but I now have to add in 1 more element to the XML file that I do not want to show in the Excel document. How do I go about doing this My XML is as follows: < xml version="1.0" encoding="utf-8" > <AreasRoot>     <room name="Entrance Hall">         <item name="Doors">  &nb ...Show All

• .NET Development Fail to load .NET 2.0 COM registered dll from Word with both .NET 1.1/2.0 installed.

  Hi, I'm having troubles convincing my Word macro that the COM component that I reference, should be loaded using .NET 2.0. I have registered the dll with regasm /tlb /codebase, which used to work fine in .NET 1.1. But now I have both .NET 1.1 and 2.0 installed and on executing the macro it's using .NET 1.1 to load the assembly, which fails. Word reports a very uninformative "Can't find file or assembly name bla" (HR 80070002). But checking wi ...Show All

• SQL Server SQL Server 2005 Remote Connection Problem... Big Time.

  Hi, I installed SQL server 2005 express edition on my windows server and I had no problem with connecting it remotely through Management Studio, then I removed it and installed a full edition SQL server 2005. That's when it's gone all wrong. Now I can't remotely connect the server through Management Studio. The error I get is the same as some of the people in this forum has which is: "An error has occurred while establishing a conn ...Show All

• Visual C# global variable for windows application

  hello, how can i write and read a global variable for the entire application in C# Many Thanks, Jassim Rahma You can use a class with some public static members or properties. Here is a little example, or you can take a look to the Singleton pattern . public static class Globals { public static string MyString; public static int MyInt; public static double MyDouble; } ...Show All

• Visual Studio Team System SuppressMessage for .NET 1.1?

  Hi, In this GotDotNet thread (of the FxCop project): http://www.gotdotnet.com/Community/MessageBoard/Thread.aspx id=300724&Page=1 ...there is mention that  SuppressMessage was scheduled for removal from version 1.32 of FxCop. I have 1.32 and would very much like to mark-up my (.NET 1.1) code to exclude certain messages. What would you recommend   Thanks! - Oli Hi Joe,   J ...Show All

• Windows Forms Winforms datagrid sorting

  Hello Techies I want to implement sorting by a specific column in my datagrid, once when the user adds or Updates a row. I have used the RowChanged Event of the datatable to  accomplish this. It works fine except for the reason that there  ...Show All

• Visual Basic Bug of the century?

  Maybe not... but how do you set the font for form components Thanks. I was able to change the editor's fonts but they don't reflect the same on the forms. Most components on a form have a font property. These can be set either in the properties window on the designer or at run-time in code.  If you chnage the font on the form.   Every control added to the form with inherit this font ...Show All

• Windows Forms Two DataGridViewComboBoxColumn one of which is filtered by the other's value

  Let me give you the scenario first. I want to setup a datagridvew connected with database, for example Products table in Northwind. I wnat to display the fields in this order: CategoryID, ProductID..... First: I have a DataGridViewComboBoxColumn. This combobox fetches all the category ids from the Category Table. Second: I have another DataGridViewComboBoxColumn. This combobox displays only those products that match the CategoryID selected ...Show All

• Visual Studio Team System Identifying 'using' (C#)

  I'm trying to write a rule to check a certain object type is always used as part of a 'using' code block. I get the impression that the only way to do this is by doing some source walking - I find no 'VisitUsing' method. Looking at my source in ILDASM, it appears that using blocks are compiled to try --> finally blocks, with object initialisation before the try. I assume, therefore, that there is no explicit way to identify this in FxCop ...Show All

• Visual Studio Express Editions How to Reset Form and Delete DataSet

  Hi everyone, I have a form that gets filled with all kinds of goodies (listboxes, treeviews, textboxes, labels, etc). A dataset also gets created programatically with a single table (6 columns and probably 100 rows). I'm looking for a way to quickly reset the form back to its original state and delete the dataset. I found: Application.Restart() which looks like it resets the form like I want it to. Two questions: Any repercu ...Show All

• Windows Forms Can you run a seperate process as a child form?

  We'd like to write some functionality in a child MDI window that can be "plugged into" several different applications but we don't want to have to recompile those container apps when the child changes (nor vice-versa). Is there a way to run a different process (exe) as a child MDI window in other exes I would probably use a class library for a similar situation what you describe. You can distribute ...Show All