mumle's Q&A profile

• Visual Studio 2008 (Pre-release) NetTcp with RM not being kept alive

  Hello all, I have been trying to get a client/server channel in WCF that is kept alive even when inactive. Basically, I want to have a pool of connections open that will be shared on my application. I have written some sample code that looks like the following: Service: [ServiceContract(SessionMode = SessionMode.Allowed, Namespace = " http://tempuri.org/Services/IServiceContract ")] public interface IServiceContract { [OperationContract] string DoSomething(string arg); } [ServiceBehavior(Namespace=" http://tempuri.org/Services/ServiceImplementation ")] public class ServiceImplementation : IServiceContract { #region IServiceContract Members public string DoSomething(string arg) { return str ...Show All

• Microsoft ISV Community Center Forums Sum of hours for month following submission date only

  Hi - im a little stuck on one part of my system. Thanks to the help of others i can now get users to enter a submission date into the activity system that then restricts them from editing any activities prior to that submission date ( a field called 'datelastsubmitted'). However on that end of month submission form i also need to show the sum of all hours for the month that is to be submitted next. By this i mean that if a user last submitted on the 31/10/2006 then the next time he comes to submit he will see the sum total of activity hours he /she has entered for November 2006 i.e 01/11/2006 to 30/11/2006. The field is called 'availablehours' and the code i have written does sum up the availablehours for the user but im unsure as to how t ...Show All

• Visual C# accessing private methods !

  Hi i have class A and class B as seperate classes. i am creating an object of class B from class A.[ A->B ] how can i access private method of class B from class A. please help you need to make the method public, that is if you created the class yourself. as it states in the title/keyword "private" is private, only visible to itself whilst public means it is visible to anyone from within and outside the class who have a reference to the class (exception being static methods, which you dont need a reference, an instantiated reference that is) ...Show All

• Visual Studio Express Editions Cant compile directx or win32

  Hello, i am posting this because i have been reading a directxtutorial at riemers.net, and i cant proceed because i cant get code to compile. I followed the instructions on how to setup the windows sdk, and everything worked fine. I even got the code from the win32 template to work (when u select new project, win32 console, windows form application) But however, when it comes to compiling my own basic win32 api code, like showing a messagebox, i get annoying errors. This is the project code. #include <windows.h> #include <d3d9.h> #include <d3dx9.h> int int_AppRunning = 1; LRESULT CALLBACK OurWindowProcedure(HWND han_Wind,UINT uint_Message,WPARAM parameter1,LPARAM parameter2) { swit ...Show All

• .NET Development which .net classes are serializeable ?

  I have a class library that none of the classes are marked Serializable or directly implement the ISerializable interface. If I want to use asp.net session storage with sql server, any object that is stored in session this way, must be serializable. However, since they all are based on System.Object, dont we get serialization automagically Hi, The System.Object class doesn't implement the ISerializable interface so not all objects are serializable. The easiest way to view if an object is serializable is by using Reflector ( http://www.aisto.com/roeder/dotnet/ ). In Reflector perform the following steps to get a list of all the serializable objects: go to View \ Search ... search for ISerializable right click IS ...Show All

• SQL Server Language support for full text indexing SQL Server 2005

  2 queries about FTI language support: Question 1: We need to search using different languages and find the official supported list of language support for word stemming a little limited - is there any news on this I need support on Hindi, Bengali, Arabic, Vietnamese and Russian for a start. I know I can use the neutral word breaker but this doesn't help us a lot at times. I've heard that many were not tested adequately enouogh to go first time but is there any news on the future Question 2: If I am storing different language records in the same table - but a language code distinguishes each row along - it would be great if I could 'partition' the index by this field so I could place the appropriate record given it's language ...Show All

• Windows Forms Unable to cast COM object of type 'mshtml.HTMLDocumentClass' to interface type 'ICustomDoc'

  This operation failed because the QueryInterface call on the COM component for the interface with IID '{3050F3F0-98B5-11CF-BB82-00AA00BDCE0B}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). public virtual void DWebBrowserEvents2_DocumentComplete( object pDisp, ref object URL) { try { do { IWebBrowser2 pWB = ( IWebBrowser2 )pDisp; if (pWB == null ) break ; object oDoc = pWB.Document; if (oDoc == null ) break ; IHTMLDocument2 pHTMLDoc = ( IHTMLDocument2 )oDoc; if (pHTMLDoc == null ) break ; UnsafeNativeMethods . ICustomDoc pCustomDoc = ( UnsafeNativeMethods . ICustomDoc )pHTMLDoc; if (pCustomD ...Show All

• SQL Server XML task and excel spreadsheet

  Hello, I have some XML that I'm passing through a variable into the XML task in SSIS. I also have an xsd file that I'm using and I want to validate (I think) that XML and have the XML task output an excel document. I've got the xsd file all set up in the "second operand" part of the XML task and the XML I'm passing in as a variable and that's in the "input" part of the XML task. My question is are there any tricks to make an excel document with these two things Is there something I need to do in the xsd file to tell it that I want excel Below is my XML and xsd: XML: < person > < person_id > 117 </ person_id > < last_name > Von Neumann </ last_name > < first_name > Ma ...Show All

• SQL Server xml data source, not sure why i'm losing data

  I created a SSIS package, it calls for web service which creates an .xml file, then I use XML source to point to the xml file and want it to be imported to a table, but data won’t go into the database table. I believe it’s something wrong with the xml file format, but don’t know how to change it. Here is what the .xml file like: < xml version="1.0" encoding="utf-16" > <DataSet> <xs:schema id="NewDataSet" xmlns="" xmlns:xs=" http://www.w3.org/2001/XMLSchema " xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true"> <xs:complexType> ...Show All

• SQL Server UNIQUE constraint on VARBINARY column

  Hi, I have a table with one of its column VARBINARY(MAX). I want to make sure that the values in this VARBINARY(MAX) column is unique. SQL Server doesn;t allow to create Unique Constraint over VARBINARY fields - whats the best workaround for ensuring uniqueness on VARBINARY columns. Thanks, Loonysan Actually, it is the (max) types that you can't create an index on. Index key have to be less than 900 bytes. If you can live with it being unique below 900 characters, you can do something like a calculated column: create table test ( varbinaryColumn varbinary(10), varbinaryMaxColumn varbinary(max) ) go alter table test add unique(varbinaryColumn) go alter table test add unique(varbinary ...Show All

• SQL Server unable to connect to Oracle in DTS

  Hi, I am trying to move some data from Oracle 8 to SQL server 2000. I am using a DTS package to do that. Now the problem is I am not able to create connection to Oracle DB. I tried creating with "MS ODBC connection for oracle", but it didn’t work. I then tried other connections, then it connected, but when i tried to create a task it only show list of table in "Query build", but doesn’t give me any drag drop facility or show me any field. I then tried with paste query and then "transformation" doesn’t work. I am new to DTS, Can anyone help me with these questions. 1. How to move data from Oracle DB to SQL server2000. 2. Is it possible to have result of one query/table to be exported to multiple ...Show All

• SQL Server Help with the matrix report

  Hello All! I developed a matrix SSRS report for a specific scenario, and the results look something like the example below. The result set is grouped by the date value, so for all records on that date in the first column I have just one value - 2/5/2007. The client would like to see a value for each cell in every row in the date column, so they can sort the results and do other manipulation in Excel. I tried to make it happen but I doesnt seem to work using the matrix. I would really appreciate if anyone has any suggestions on how to make it work. btw, it really has to be a matrix report :) Thanks, everyone! 2/5/2007 Value 1 3604 Value 2 5250 Value 3 1281 ...Show All

• Visual C# Getting started with Business objects

  Hi guys, i m trying to get started with Business Objects, but i m a little bit lost here.. hope you guys can help me out. So far all the tutorials i read on the internet just show you how to make an "employee" or a "product" class, coding that is very simple, and i don’t have any problems using them and even binding them to Windows Forms using BindingLins<T>, etc... i ve been testing it out and it works fine. But right now i m trying to make something that have some relations, and i cant figure out how i am supposed to do it, what i m trying to do is a simple "Order" class that is related with a customer and some products... something like: Order Customer Products So, could you guys help me out with this ...Show All

• Visual Studio Feedback on Prototype Style in Sandcastle

  I am looking for customer feedback on the "Prototype" style in Sandcastle. It will be great if you provide me with input on redisign of member pages with tabs and our use of language filers in this style. Also should we adopt this "Prototype" style for our official documentation shipped in future versions of Visual studio Waht do you think I will blog about the details on "Prototype" style seperately. Cheers. Anand.. Hi Anand, I think the current presentation.css stylesheet needs some changes. I didn't like the font size (too big), it uses bold in too many places, didn't underline hyperlinks when the mouse hovers over them, and the spacing on many of the elements just didn't look right t ...Show All

• Visual C# Is there a collection that acts like a dictionary and arraylist?

  HI, I'm looking for a collection that acts like both a dictionary and an arraylist. When I add to the collection, I'd like to use a key that is a string, and the value is an object. Then I can simply use the IDictionary Contains() method to see if the key exists. But I also need to preserve the order that items are inserted into the collection, like an arraylist, so I can enumerate over the collection and the items (or values in the dictionary) come out in the order inserted. If I just use a Hashtable, then I get an order I suppose specified by the hashcode. If I use a SortedList, then the order is specified as alphabetical by the string key. Is there a standard collection that already has this behavior Or do I need to write my own ...Show All