qt1h00's Q&A profile

• Visual Studio Parameter help needed

  Hi I am generating a report using a stored procedure. The stored procedure requires a date parameter. When the report is generated reporting services displays the datetime picker, which is fine except for the fact that I only want the user to go back until a certain date. Is there anyway to set the date range in a stored procedures parameter in reporting services Owt The built-in parameters area does not currently have any extensibility for custom date ranges or other business logic. This is something we are looking at for the future however. You can implement this functionality on your own however. You can turn off the built-in parameters area entirely (ReportViewer.ShowParameterPrompts) or hide ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Deployment / strange Network Problem

  Hello I have a problem with deployment of a xbox 360 game. Okay the problem seems to be the network connection, i get the message that the host (my xbox 360) cannot be reached. I tried a PING to the IP Address of my XBox 360 and it fails. So i checked the Subnet, the IP Address, everything looks fine. And than i figured out something really strange: I started "PING -t 192.168.0.2" (the IP of my XBox) and i got timeouts as before. Than i started the network diagnostic tool on the XBox - still PING timouts. From the moment on where the network diagnostics reached the ICMP test, the PING succeeded and i receive an answer. Unfortunatly when the network test is over, the PING fails again. Can someone help me Greetings, Ber ...Show All

• Visual FoxPro ceiling to the nearest nickel

  Dear Friends, How to round a number in foxpro like the ceiling function in Excel does, giving the number to be rounded as parameter 1 and the multiple we need as parameter 2 eg ; ceiling(4.20,0.05) = 4.50 Is there a possiblity to do the same in foxpro, because the ceiling in foxpro rounds up to the nearest integer eg: ceiling(4.20) = 5.00 there is noway of specifying the multiple we need as in the case of Excel Any help would be greatly appreciated. Thanks satish Check the ROUND() function It will round values to the specified number of decimal places. (i.e. ROUND( 4.24, 1 ) = 4.2, while ROUND( 4.25, 1) = 4.3  To handle special requirements, (how does 4.20 rou ...Show All

• SQL Server General issues concerning Data Mining with SQL server 2005

  Hi I am just starting to learn how to use data mining with SQL server 2005. I have some general questions which I hope someone out there can help me with. Each month I have approx. 100.000 customers who buy a product. I want to contact 10.000 of these with a letter for cross-selling some additional products. Currently I choose these 10.000 randomly from the 100.000 customers. I now want to use SQL server 2005 data mining to choose these 10.000 better, to receive a better response rate. How do I transfer this knowledge to the 100.000 (potential cross-selling customers) I understand that it could be set up in SQL server like the following: case table: customer_id, gender, age, city, etc. nested table: customer_id, produc ...Show All

• SQL Server Trying to delete a bad SSAS DB

  Hello, I had a SSAS DB on a SQL Server EE, and then the need for a development machine arouse. The current EE version was backed up and then likely restored to a Standard version. The DB does not work, however, I cannot remove the SSAS database. The error I get basically states that "The installed server editions allows not more than 3 partitions and not more than 1 writeback partition". I understand that, and now just want the DB to go away. Please help. Try opening an XMLA Query window in SQL Management Studio and running the XMLA command to delete the database. This should by-pass the validation causing you problems. Below is an example of such an XMLA database delete script. (The Database ...Show All

• Visual Basic How do I build a query for a column = True using ADO and SQL

  Hopefully this will be an easy answer. I do not seem to be able to get the syntax for a query using a true/false column. In DAO it was "where colName=True" or simply "where colName". These do not seem to work in ADO/SQL/VB.NET. What is the proper syntax. And while I'm asking, is "where dateCol = #01/01/2007#" going to work here or does it also have a different syntax Thanks for the help Rich I finally went in to the SQL Studio and built a query. I found that the syntax it needed is "where colName = 1" to find a true in a bool column and " = 0" to find a false. Also the date syntax is "where dateCol = '01/01/2007' ", which I thought was strange, but it works s ...Show All

• Software Development for Windows Vista Windows Workflow Foundation - Install Problems?

  Hi, I have installed .NET 3.0, I have downloaded “Orcas” Development Tools for for .NET Framework 3.0 I have then downloaded samples from below site. http://wf.netfx3.com/content/WelcometoNetFx3.aspx When it try to open any Solution file I get a message stating "The application for project C:\MyWorkflow.csproj" is not installed. Make sure the application for the project type (.csproj) is installed." Any ideas why I get this. On my machine I also have NET 1.1, .NET 2.0, Visual Studio 2003 and Visual Studio 2005 installed. Please help! I have the RTM .Net 3.0 and have downloaded the WF ext. from here but it just starts the windows sdk EXE and when I click repair it does not seem to effect my visua ...Show All

• SQL Server reference member in user hierarchy

  hi, I have a user hierarchy in my Date Dimension such as [Calendar]->[Years]->[Quarters] And I can access the member by directly call the memeber name, for example: select [Date].[Calendar].[Years].[2006].[Q2] on columns, ................................... The results will be correct. However, if I use reference to call the member, for example: select [Date].[Calendar].[Years].[2006].&[2] on columns, ................................... There will be nothing in my results. Would you please tell me what shall I do to enable the reference call to my hierarchy member Thanks. Hi, Thomas Thanks a lot for your answer. I have also tried "[Date].[Calendar].[Y ...Show All

• SQL Server Creating a database from script - permissions problems

  We deploy our app via ClickOnce. Rather than shipping the .mdf and .ldf, the app detects whether the database is there and creates it via script if it's not. The script was originally generated from SQL Exrpess Mangement Console, etc. In the past, we've made the stipulation that the user must have administrator access to the machine. However, we now need to find a workable solution for users who are not administrators on their machine. Currently, we use the following connection string before attempting to run the db creation script: conn.ConnectionString = "Server=.\\sqlexpress;Integrated Security = true;User Instance=false"; The script fails when trying to execute "CREATE DATABASE [myDatabaseName] ON PRIMARY " ...Show All

• Visual Basic Runtime Reflection

  What are the steps of creating a runtime reflection here is what i would like to do. i would like: using aspx.vb file, include a class in that class, have a procedure with parameter of HtmlForm evaluate the Attibutes of the controls with in that form. I'm able to send the form but not able to get the attributes error with LiteralControl. Would this be possible and point me to the right directions. Group, please help. Thanks in advance Ros http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/frlrfSystemReflection.asp ...Show All

• Visual C# Passing an inherited class as 'T' to a generic container.

  I'm having trouble finding out how to use a general purpose generic container I wrote as a member of another class which wants to hold any class type based on a common base class. The first set of code below shows 4 seperate classes, RNode is a generic class, TreeControl has an RNode<TreeItemBase> member, and a "Root" property to access it, TreeItemBase is a control (not really important to this), and TreeItemHeader is derived from TreeIItemBase... Public class RNode<T> {} public partial class TreeControl : ScrollableControl { private RNode<TreeItemBase> root = null; public RNode<TreeItemBase> Root { get { return root; } set { root = value; } } } publ ...Show All

• Software Development for Windows Vista Bug!? global transaction with SQL Server connection + TransactionCompleted event

  This is an example of a problematic behavior that we encountered during trying to trigger an action after a successful database commit. It took a while to find characterize the behavior and to bring it down to an example like this. I am pretty sure it is a bug! Just to outline the global scenario: The application has several objects which may open a database connection and select or manipulate data. As some of the calls are expensive the data should be cached in a cache. On database updates the cache should of course be synchronized so an obvious idea is to have objects which manipulate such cached data to hook up to the TransactionCompleted event and check for the transaction outcome to do something. Another idea is to use e.g. Juval L ...Show All

• SQL Server iif inside iif

  I'd error message on this expression , It is written in hidden property of an image Can you help me to correct it thanks all. =iif(Parameters!Direction.Value = "none", True, iif(Parameters!Direction.Value = "Ascending",True,False ) You are missing a closing ")" and when comparing strings I would use the "equals" method. Here is what the statement should be: =iif(Parameters!Direction.Value.equals("none"), True, iif(Parameters!Direction.Value.equals("Ascending"),True,False )) ...Show All

• Visual Basic how to invoke method in a class from a C++ dll in vb.net

  I know we can invoke a global method from a dll( written by C or C++) in vb.net like you invoke windows APIS, but I want to know if i can reuse classes that implemented in a Dll written by C++. thanks in advance I wonder that if we can use a dll that typically already built in VC++6.0 rather than rewrite directly in VB.NET. By now ,i haven't found the right way to make this work. ...Show All

• Software Development for Windows Vista How to programmatically perform searches in Vista?

  I want my application to be able to allow the user to specify queries for files for which I can just used the saved-search machinery in Vista to execute. Basically, I'm looking for the Windows equivalent of this: http://developer.apple.com/documentation/Carbon/Conceptual/SpotlightQuery/ i.e., an API to build queries and execute them in Vista. Google searches have revealed nothing relevant. - Paul http://msdn2.microsoft.com/en-us/library/bb266517.aspx ...Show All