GaltSalt's Q&A profile

• Visual Basic how to arrange the date?

  hi. how am i going to arrange the date in my database i have to display data from two tables in my database. these data will be merge and then be displayed in a listview. how am i going to arrange the date such that the latest will be the last. the user will input the date in this format: mm.dd.yy is there any way to sort these dates coming from two tables in the same database how Add the clause "SORT BY datecolumn DESC" to your query where 'datecolumn' is the name of a column in your table or query of type datetime. If you store dates in your tables as a string, you need to redo your table design... ...Show All

• SQL Server Named sets and Existing

  I have a very large Account dimension (> 2,000,000 members). I would like to create a named set for the top most profitable accounts. I plan to use this named set in the SSRS Report Builder to compensate for its lack of aTop N feature. The problem is that the user can change the fiscal period and SSAS needs to reevaluate the set. Using Generate function won't work for performance reasons. So, I'm trying to use Existing to force the set generation. e.g. CREATE SET CURRENTCUBE .[Top 5 Profitable Accounts] AS Order ( TopCount ( ( EXISTING [Account].[Account].[Account]. Members , [Period].[Period]. CurrentMember ), 5, [Measures].[Profit]), [Measures].[Profit], DESC ); However, this gives me " The Period hiera ...Show All

• .NET Development dispose method in a correct way

  Hi, Please help me with the following questions: 1. What is the difference between the managed resources and unmanaged resources Any examples 2. When i disposing an object, Do I have to set the object to nothing as well For example: Finally cmd.Dispose() cmd = nothing End Try 3. When disposing, do I have to set every instances to nothing For example: string, integer, etc 4. When disposing an object, do I have to check if the object is nothing For example: If not IsNothing(cmd) then cmd.Dispose() End If 4. If I create a new class, Do I need to implement the Dispose method 5. What should I do to properly clean up the resources 6. Sometimes I saw some object might have two ...Show All

• Software Development for Windows Vista how to change namespace of web methods

  I have endpoints of my statemachine workflow exposed as web methods. The starting element of my soap body looks like this: <VerifyIncident xmlns="http://tempuri.org/"> How can I change this so that the xmlns attribute = http://mydomain.com This is also causing the SOAP Action to be SOAPAction: http://tempuri.org/VerifyIncident You can specify the namespace using the Namespace parameter of the WebServiceAttribute in your web service class: [WebService(Namespace="http://mydomain.com")] ...Show All

• Visual Studio Team System More Continuous Integration problems

  I need to have my team builds which run on CI to build higher level applications if a lower level framework component is changed. For example, I have a framework Component and I have an application which has a binary reference to this framework component. If the framework component is changed, I would like this to be built. I would also like the application which has a binary reference (and any others which do) to be built. Is there a way which I can do this The dependency feature of TFS Integrator is interesting and something similar might end up in Automaton. TFS Integrator is a Windows Service only that triggers builds in the background, and it uses an XML based configuration that you have to setup ma ...Show All

• Visual Studio Express Editions Fill an array from a text file.

  Sir/Madam, I need to fill an array from a text file. My text file looks like this for different people. First Name|Last Name|Address|Phone First Name|Last Name|Address|Phone First Name|Last Name|Address|Phone First Name|Last Name|Address|Phone First Name|Last Name|Address|Phone Do you know of any way to put these into an array from a text file where the "|" symbol seperates the columns Any help would be greatly appreciated! Here is one way of doing it in c#. For small file this might be good enough. For larger files, however, this is not the most efficient approach. You may want to read up on Generics or build your own custom collection class. int i = 0; co ...Show All

• Visual Studio Team System Set the default lock type to "check-in - Allow users to check out but prevent them from check-in"

  Hi, in one of ours team project we allow multiple check out but we want the defaut lock type to be initialize with the third option : "check-in - Allow users to check out but prevent them from check-in". Where/How can i set this default option FI : Microsoft Visual Studio 2005 Team Explorer Version 8.0.50727.147 Thanks for your help Laurent At present, neither. (edit) anyone reading this -- if this is important to you, please enter a suggestion on connect.microsoft.com so that others can vote for it ...Show All

• Windows Forms URGENT HELP - Combobox Problems

  C#: Windows Application --> VS 2005 (OLEDB Connection) ------------------------ Hi, I need help on how to use a combobox to extracted list of value from A Database and use the value selected to Update to B Database. A Database (Product ID) --> Bind to combobox --> Selected value --> Update Dataset --> B Database (Product ID)  there are many examples here on how to databind to a combobox, here is one link which Im sure will help you: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=785552&SiteID=1 ...Show All

• SQL Server Can I have replication between two completely different schemas?

  Hi SQL guys, I have 2 different databases and an import tool that reads from one and fills the other one and then whenever we run it, it should synch the two databases and its kind of a heavy task. I was wondering if i can replace it with replication between these databases. I defined publisher and subscriber, but i cannot find anywhere that i can say which field in source maps to which field in destination. Is it possible at all to have a replication between 2 databases with totally different schemas If so, please let me know how. Thanks, Sina hi Armando... can you please brief the steps of making the matches between source and destination for transformable subscription. Thanks in advance ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Optimal WaveFormat's Properties for VOIP

  I am using DirectX DirectSound's WaveFormat for capturing voice from microphone. What are the optimal properties of WaveFormat (AverageBytesPerSecond, BitsPerSample, SamplesPerSecond and etc.) for VOIP (using UDP transfer protocol). And what the optimal datagram of voice to be sent using UdpClient.Send What I meant, is that I don't want to use any codecs for the voice. ...Show All

• Smart Device Development Error while connecting to Web Service.

  While i am trying to connect to Web Service in disconnected mode. i.e. internet is not available. I am getting the following error description from ex.Message. "An error message cannot be dispalyed because an optional resource assembly containing it cannot be found." With stack trace as follows :: at System.Net.HttpWebRequest.finishGetResponse() at System.Net.HttpWebRequest.GetResponse() at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse() at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse() This make the PDA freeze and i have to reset it to operate. If I am connected to the internet everything seems to be working fine. Please suggest By definition ...Show All

• Visual Basic Changing the color of a point using GDI?

  I'm trying to change the color of a single point with GDI without affecting the colors around it. I'm new to GDI, but I miss PSet! *sniffles* Anyhow, my code: Language: Visual Basic .NET (.NET Framework 1.0) OS: Windows XP Home SP2 Dim B As New Bitmap ( 2 , 2 ) Dim E As PaintEventArgs Dim G As System . Drawing . Graphics = E . Graphics . FromImage ( B ) Dim P As New System . Drawing . Pen ( Color . Black ) So my Graphic looks like this (for the sake of simplicity, I assigned a letter to each of the four points): A | B ------- D | C Goal: Change the color of Point "A" only G . DrawLine ( P , 1 , 1 , 1 , 1 ) 'This fills in none of the points G ...Show All

• Visual Studio Tools for Office Inactive event handler on custom toolbar

  Hi, I am using Word 2003 and VSTO 2005. I have a .doc solution deployed by the Publish Wizard. When I open this .doc file there is a custom toolbar with different buttons on it. When I click on the buttons the corresponding event handler is called and executed. So fare everything works perfectly fine! Then I reopen an other instance of the same .doc file (so now I have two Word windows open which are customized by the same assembly). If I click on a button on the custom toolbar in the second Word window, nothing happens at all…. as if the event handlers have been de-activated! Can anyone help me on this Thanks a lot! Claudia Hi Cindy, Thanks for your tip. I h ...Show All

• SharePoint Products and Technologies reference to a listitem into a list folder

  Hi all, I'm looking into WSS 3.0 lists. I'd like to know if I can create a "link" list item, that represents a reference to an existing list item into another list folder. I'm going to explain myself with an example. I'd like to create a structure like this: List1 Folder1 ListItem1 Folder2 ListItem1 (this is a "link" list item) In this way, I can create a ListItem, and then put a reference to it into other folders in my list folders structure. When I edit ListItem1, changes should be immediately applied to ListItem1 links in the folders structure (because links are simply references to the same list item). And... if I enumerates items of Folder2 (or through SPQuery or SPView), I should be able to ...Show All

• Visual Basic End if markers

  For a for next loop it is possible to add the variable after the word NEXT. If it is the wrong variable then there is an error message. Is there something similiar for If EndIf statements that helps to flag with EndIf goes with which IF. In addition to what SJWhitley said, if your code is so complicated that you have many If/Endif's nested together, then it's time to think about moving some of that code into its own sub or function. ...Show All