Tryin2Bgood's Q&A profile

• SQL Server Need help designing the Cube

  Hi, I've been trying to design a cube (and a proper MDX query) that will meet my requirements but I'm yet to be successful. The situation is as following: There are a number of Options that can be selected for each Project. The database lists all Options for each Project. So, Options Project OptA ProjA OptB ProjA OptA ProjB OptC ProjB OptB ProjC .. and so forth. I'm trying to create my cube, so that I could find say, the number of Projects that have BOTH OptA and OptB. My inital thought was to create a SQL Named Query in DSV to get the total number of Projects for each distinct Option. (ie OptA would be 2) That worked if I only wanted to display the number of Projects for OptA OR OptB. However, it seemed impo ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA content pipeline importer questions

  Hi, I am new to XNA and C# as well. I am using the code from here ( http://andyq.no-ip.com/blog/ p=16 ) to get a bounding box information. However it crashes at when I do the following -> box = ( BoundingBox )myModel.Tag; I have added the custom importer dll to the properties tab under the content pipeline tab. I cant figure out why its giving this error saying object reference not set to an object. It's pretty much the same idea. In your custom Content Processor, override the Processs() method. In there cast the NodeContent input to MeshContent. The following snippet returns a List<Vector3> of each of the positions of the mesh. Then you can do whatever you want with the vertex soup. private List < Vector3 ...Show All

• .NET Development Where's the WinForm event for AFTER a form has finished loading?

  I need to fire an event AFTER a form has finished loading and is displayed to the user. Currently, I'm initializing my MapPoint control on my form in the form_load event. But, if the connection to the MapPoint server is down, the form never really finishes loading before an exception is thrown and it's very slow. I want to put my MapPoint initialize inside an event that fires AFTER the form has finished loading and is displayed to the user. How can I do this Hello All. _Quimbly_: You could use either Shown (as ahmedilyas said) or Activated, depending on your situation. Shown fires once when the form is first created, and never fires again. Activated fires each time the form is made the active form. Whichever one best fits your ...Show All

• Visual Basic Table Adapter Command Text VS 2005

  When adding a query to a table adapter using an existing stored procedure with the TableAdapter Query Configuration Wizard the commandtext is no longer generated correctly. This commandtext used to list all of the parameters when I would add a new query but now I get command text that looks like this.{ = CALL dbo.InsertReferral( , , , , , , , , )}. When I select the stored procedure in the config wizard it show's all of the parameter names in the parameters: list. Any help would be greatly appreciated Thanks, Brett I realized I was also having problems with the ReportViewer control sticking at the "Report Being Generated" screen on reports that previously worked. I restored my computer ...Show All

• Visual FoxPro buffering, Rlock() and FLOCK()

  Hi; I think I don't understand the concept of buffering. Can someone explain the following behavior I have a form which uses opt. table buffering. While that form is open by a user, I manually rlock() one of the records. Then, I ask the user to change the same record. The change, including the =tableupdate() goes through fine. I try the same with FLOCK(), and the change still goes through fine. Shouldn't FLOCK prevent the user from comiting a change thanks. Why It's the same user (session) doing rlock()/flock() and tableupdate(), no If I didin't understand it wrong, tableupdate() needs a lock during write and you already have it. ...Show All

• .NET Development Missing Schema Information of Base Tables in SQL 2005 Views

  Hi! I have a problem, because in SQL 2005 my views does not provide the schema information of the base tables. I mean neither the identity behavior of the columns nor the primary key are reachable. In details, in my .Net application I use DataAdapter.FillSchema method for querying the schema information of the views. The trouble is that the application is a finished software and it is developed and tested for SQL 2000 and it is working correctly on this version. Now I’m about to migrate the application to SQL 2005, further, I have to support both SQL version: SQL 2000 and SQL 2005. I tried to switch the database option to be compatible with SQL 2000, but it didn’t work. What should I modify in the d ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Original textures along side XNB files in bin folder?

  For example, when you build your project, it looks like the textures are converted to XNB format but the original textures are also copied into the bin folder with them. Is that what is supposed to happen Only if you've changed "Do not copy" to "Always copy" or "Copy if newer" in the "Copy to Output Directory" drop down for the textures' properties. ...Show All

• Smart Device Development Infrared capability on .net compact framework

  Hi, After researching infrared capabilities I can't locate how to accept incoming infrared signals from stnadard tv/dvd remotes to be able to play them back. I have seen and read plenty of articles eg. godotnet but can't seem to find what servicename or endpoint is required to be set in vb.net or c# to work with standard tv/dvd remotes eg. to associate with the client/listener classes. I'm starting to think that the .Net Compact Framework doesn;t support this capability and only embedded c++ will work I would be grateful for any leads.... Thanking you Hi, After researching infrared capabilities I can't locate how to accept incoming infrared signals from standard tv/dvd remotes to be abl ...Show All

• SQL Server get timezone specific date

  Hello, I am struggling with one algo i.e. I want to retrieve the date according to time zone I have table called TIMEZONe in which i have the information about the hours difference (+12 to -12) from GMT... now my scenario is that I want to get the date, using information from timezone area table (time difference from GMT), of any particluar time zone can any one tell me, how will I able to achieve this task. for example: it 4:00 AM in the mornign in GMT TIME and date is 11-08-2006 but in US it 11:00 PM and date is 10-08-2006 Note: Server date is set to GMT (System date) regards, Anas Where is the problem If you have a TimeZone table you could use a query like this select dateadd ( hour , T ...Show All

• Architecture Where can I find older versions of Microsoft Products?

  Hi All, I don't know if this is the right place to post this question, if the moderator thinks it's not, please move it to the right one. I wanted to ask you guys if you can post some urls where I can download older versions of ALL microsoft products. (DirectX, Windows Media Player, MS Office, etc ...) I need these to test my apps that it would be backward compatible to older releases of the products. If you can point me to an archive site where microsoft keeps their older (even unsupported) products (if there is one), I would gladly appreciate it. You will find that if you have an MSDN Subscription you should be able to get hold of the older products that are still active, As to older versions you mi ...Show All

• Visual Studio Generic types are not displayed in method declarations

  If you create documentation using the August CTP of the following code, then the declaration of the GetItems-method does not show the generic types used by this method. using System; using System.Collections.ObjectModel; using System.Text; namespace Overloads { public sealed class GenericTest { /// <summary> /// yep /// </summary> /// <returns></returns> public ReadOnlyCollection < string > GetItems( ReadOnlyCollection < string > value ) { return null ; } } } If you go to the page in the documentation describing the GetItems-method, you'll notice the following syntax: public ReadOnlyCollection <> GetItems ( ReadOnlyCollection &l ...Show All

• Software Development for Windows Vista Transactions - ensuring consistency between WF and MSMQ

  Apologies in advance this might be quite a complex one! I should say at the outset that I don't want someone to write my solution for me, just am trying to understand a bit more about how to achieve transactionality in WF. I'm currently trying to pilot an STP engine using Workflow Foundation to prove its suitability. Everything in the engine is driven using transactional MSMQ queues. It's essential that no information is lost, and that the workflows remain in a consistent state with the contents of the queue. These are the scenarios I'm trying to tackle at the moment: 1. A message arrives on a queue and triggers the creation of a new workflow. 2. A message arrives on a queue and is passed into a waiting workflow. 3. A workflow ...Show All

• SQL Server Help!

  Message cannot be sent whith Outlook Express! Why Do you use Outlook Express stand alone or do you try to send mails from within SQL Server What did you configure how What error did you get -- SvenC ...Show All

• .NET Development Creating a NewFolder using c#

  Hi, I am writting a textfile to c:\ Temp folder. I want to check whether there is Temp folder available in c: , before i save the files in c:/Temp.If there is no folder called Temp in c:,then i want to create a new folder[Temp] dynamically. Can somebody give me an suggetion to do it My existing code is: public void TextWrite() { string logPath = (string) (new System.Configuration.AppSettingsReader()).GetValue( "DataAccessLogPath", typeof(string)); ////////////////////"DataAccessLogPath" is <add key="DataAccessLogPath" value="c:\Temp\"></add> given in App.Config file. DataTable dt= Context.QueryDataTable(Sql.Select( RootSystem.Bills.WOWJ_NO, R ...Show All

• SQL Server Report Builder functionality in a Browser-based scenario

  I am planning to use SQL Reporting services in a new remote hosting centre and must provide ad-hoc reporting to a small number of users plus the access to running of previously prepared reports to a wider user base. User access must be thin client, browser based. The client workstations are locked down to a particular security configuration and there is no possibility of installing .Net Framework on them. Normally, only browser-based applications can be used at the desktop client. Apart from using Reporting Services (Citrix), what options do I have to provide users with the Report Builder in this scenario please Are there any COTS packages that would provide this functionality TonyB Have a look ...Show All