N_John's Q&A profile

• Visual Studio Express Editions dates and null values

  My column in sql is of a date data type. I have a textbox that a user can enter a date when certain parameters in the program are met. On occasion a date does not have to be entered in the textbox. This is where I have a problem. The column can accept null values but I am not sure how to program this part. I have a date variable = cdate(txtbox1.text). If nothing is entered in the textbox I get an error message of "can't convert "" to a date) Any help would be appreciated. just skip it in this case or just give a DBNull value to the datatime parameter in SQL when you are creating a parameter collection or in your INSERT/UPDATE statement. ...Show All

• Software Development for Windows Vista About Standby resume

  Hi.......I have a question about Standby Resume. The tool of PwrTest is very useful to developers. But to BIOS developers, it will be better if we can get a resume time measure of every single device in ' Device Initialization Phase '. There is only driver Init timing result in the S3 resume result matrix now. It will be harder to check which device cause the issue, if the timing failed to match the requirements. Is there any way to pick up the resume time seperately of every single device Thank you! Hello, PwrTest can be used with additional scripts to determine the driver delay for each device in the Device Initialization Phase. Please contact Microsoft at onnow@microsoft.com for addition ...Show All

• Windows Forms You cannot drop an item onto a button on the taskbar.

  You cannot drop an item onto a button on the taskbar. However, if you drag the item over a button without releasing the mouse button, the window will open after a moment, allowing you to drop the item inside the window. I get this messege when i try and drag and drop some of my controls with my panel container any help on how to fix this ...Show All

• Silverlight (formerly WPF/E) WPF/E vs. XBap

  Hello Community! I was recently trying to evaluate why there is seemingly two ways to write web-based applications with WPF. Am I way off Can anyone explain to me when I would use an XBap over a straight up WPF/E application Thanks, Alan XBAP cannot read or use the session cookies of the browser window that launched the XBAP application. The article demonstrates that it can hold onto the browser cookies of any child web services of the XBAP application, but this does not work for the parent window cookies. Consider a web application that uses forms authentication, then attempts to launch a secure XBAP application. The XBAP application cannot get the forms authentication cookies, and therefor ...Show All

• SQL Server Seperate one report from group

  I'm trying to import reports from MS-Access 97 to .NET. All the reports are in one forlder. I'm using Business Intelligence Developemt Studio to import report. How can I seperate one of the reports and migrate it to .NET ...Show All

• Visual C# Adding licensing capability to my app

  Good day. I'm looking for a way to add licensing to my application. By this I mean I want to be able to control how many users are able to work with the software. It would be best if they generated a license file, for example, and sent it back to me, where I could 'activate' the file and send it back to them, thus preventing unauthorized use of the software. What is the best way of doing this Surely there must be some MS tools that help you add this to your app Any help would be greatly appreciated. V. The Volume Serial Number way is a bad idea because if I format my drive, for example to re-install Windows, then it gets a new Volume Serial. Then, the application that is locked to it will fail to work. ...Show All

• SQL Server Calling stored procs based on a code table

  I need to run stored procs based on a list in a code table. In other words, it reads the name of a stored proc from a table and runs it and does this for all the rows in the table. I think the ForEach loop container will do what I need and there is an ADO enumerator option but the documentation does not tell you how to use this. From what I can tell, you need to get a dataset into an SSIS variable first and then you plug the variable name into the ForEach ADO enumerator. Is that correct If so, can someone tell me how to get a dataset into a variable Thanks Perhaps kirk's blog will help you: http://sqljunkies.com/WebLog/knight_reign/archive/2005/03/25/9588.aspx ...Show All

• SQL Server Package fails when I schedule it.

  Two scenarios, 1 worked, 1 didn't: First package I execute SQL (select top 10 * from MyTable) in my SQLServer2005 database. I scheduled it and it ran sucessfully. I changed the execute SQL to run against an external Oracle database. (Select * from SomeOracleTable where rownum <= 10). I preview to make sure the query works and it does return a result set. I execute the package in the Visual Studios IDE and it works. I save with encryptAllWithPassword to the SQL server. I go into the scheduler and select the package from SQL Server (as opposed to the file system). I set the step to execute the package off the server. I enter the security key by clicking on the configuration tab. I assume it saves the password to the package. I cl ...Show All

• Visual Studio 2008 (Pre-release) XAML RSS Reader problem

  Trying to get into WPF by re-creating one of the several RSS Reader's out there. But I have one MAJOR problem. Creating the XAML app exactly as shown in the demos/tutorials but when I run the app or redering it in XAMLPad NOTHING happens... Is there anything i need to be aware off I've tried both online and local stored rss/xml files. Also when trying to add an rss feed as a Data Source i Interactive Designer i get this error "Error reading the XML data source file. The data source could not be cerated." I'm using the June CTP. -- SparreZ Does the app run properly within the IDE like VS or Expression Interactive Designer Are you able to load simple XAML file by double-clicking on ...Show All

• SQL Server Topcount for a period.

  I want to get the 10 best xxx in a period (i.e. this quarter, last quarter, this year, last year...) I have used topcount to get the top customers but it includes all the data from all years. For example in foodmart to get top brands by sales I have: set [TenBest] as 'TopCount( [Product].[Brand Name].Members, 10, [Unit Sales] )' I assume I somehow use the [Time] dimension in the query to get the top brands for 1997, 1998, Q1 1998, Q3 1997... Then I can use the same syntax for toppercent, bottom.... Thanks, Chris Chris, The simplest method is to just use a tuple in place of the measure: Using your example: set [TenBest] as 'TopCount( [Product].[Brand Name].Members, 10, [U ...Show All

• Visual Studio Express Editions CType Trouble

  I am trying to make a small amount of code save me from having to manually write everything out. What I have is this so far Dim Box As CheckBox = CType (sender, CheckBox) Dim W As Integer = 1 For W = 1 To W = 7 If CType ( Me .Controls( "rC" & Box.Name.Substring(W)), CheckBox).Checked = True Then CType ( Me .Controls( "rW" & Box.Name.Substring(W)), CheckBox).Checked = False ElseIf CType ( Me .Controls( "rW" & Box.Name.Substring(W)), CheckBox).Checked = True Then CType ( Me .Controls( "rC" & Box.Name.Substring(W)), CheckBox).Checked = False End If Next W I want it to check if rW1 is checked, and if it ...Show All

• Windows Forms Connecting to a Web Service

  Our Client Application needs to connect to a webservice, which is in the same solution, different project though. I can do it perfectly on my box, and it works, however, it's defauled to "localhost". All of our customers have their own sub-domain for their site. Example: Customer1.OurSite.net Customer2.OurSite.Net ... Customer532.ourSite.net And so on. So... When they first run this application, I ask them to input their website address, which I save to an XML file. This way that client will be set to lock-onto that website. How do I tell my application to point the webservice to Customer1.ourSite.Net instead of localhost Theoretically I want to change the settings in that XML file 10 times in 10 minutes and have the application hit each ...Show All

• SQL Server unable to create Integration services project

  Hi, I've installed with success Visual Studio 2005 team edition for software developers and SQL SQL Server standard edition, but when I've created a new IS project and click on "No Data flow tasks have beed added to this package. click here to add a new DataFlow task" I receive the following message : Registration information about the Data Flow task could not be retrieved. Confirm that this task is installed properly on the computer. Could not enumerate the registered tasks. (Microsoft.DataTransformationServices.Design) Does someone experience this before is there any work around Thank you for your help Silly question - but where did you uninstall/remove SSIS from I don't see it seperately in add/re ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Using Xbox 360 Controller with my PC (newb)

  I am to understand that you can use a 360 controller to develope games with XNA. I have plugged my wireless controller in via the play and charge cable, but all it does is turn my xbox on in the next room. I assume I need a driver, as my computer did recognize new hardware, but do I also need a wired controller The wireless controller for PC will also work with your 360. Yeah but if you already have 2 perfectly good wireless controllers from when you bought yourxbox 360 why do I have to go buy 2 more for my PC.... just let me by the usb dongle thingy-ma-jig ...Show All

• Visual Studio 2008 (Pre-release) Adding Web Reference in VS 2005 to WCF Service

  Hello, As I’ve found out yesterday, it’s important to create a proxy class for ‘WCF web service’ using svcutil.exe even though it uses 'basicHttpBinding'. If one does it through VS2005's 'add web service' routine, the created proxy allows passing string fields only. All value types doesn't go through. I mean the proxy class looks correct with all fields having correct types. But when I attach the debugger to the WS I see default values only for types like int, short, DateTime etc. Am I doing something wrong nefis i've just noticed that the 'add web reference' routine creates the proxy class with additional set of properties with same names as mine with 'Specified' suffix added. All t ...Show All