MethMath's Q&A profile

• .NET Development Returning controlled SQL data

  I have a small problem with returning SQL data in a set order back to my C# program. I'm using Visual Studio 2005 and SQL server 2005 Express Edition (also the SQL Server Management Studio Express tool for testing my SQL commands). I have opened a Reader from my C# program to my database (works OK) and I now need to read back some data sorted in a specific way. My database has a table of depart times (stored as text, not strictly time formatted) which I need to sort in a specific way. I want all times (24 hour clock) that are >=0300 and in time sorted order. Afterwards, I want all times that are <0300 also in time sorted order. For example: SELECT * FROM MyData WHERE Depart BETWEEN 0300 AND 2359 ORDER BY Depart ASC, Arrival ...Show All

• Visual Studio 2008 (Pre-release) ServiceHost error from Beta2 to June CTP

  I had following text in the Service.svc file in Beta2: < %@ServiceHost language=c# Debug="true" Factory="WCF.Service.MyServiceFactory" %> The MyServiceFactory simply exposed the MyService service. And the configuration file in Beta2 was empty as shown below: <configuration></configuration> It has no configuration info. After upgrading to June CTP and reading the blog entry at http://hyperthink.net/blog/default.aspx , I modified Service.svc file to following: < %@ServiceHost language=c# Debug="true" Factory="WCF.Service.MyServiceFactory, WCFService" Service="WCF.Service.MyService, WCFService" %> The configuration file is still empty as before. It now th ...Show All

• SQL Server DTS 2000 Package Error(s)

  From MS SQL Server Management Studio 2005, I register and connect to MS SQL 2000 (SP4) running on another server.  I can see the list of 2000 DTS packages on the other server, but when I try to open them I first get: Error Source : Microsoft Data Transfformation Services (DTS) Package Error Description : The DTS host failed to load or save the package properly. I click the OK button and get: The selected package cannot be opened. The DTS Desiger has been closed. I click this OK button and get to now famous: SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer. ...Show All

• SQL Server Chinese garbled in MSSQL2000 - by ASP

  Hi experts, Here I got some problems with my application. (ASP & English Version SQL Server 2000) As we are using English MSSQL Server 2000, we got some new functions and we have to facilitate support of Chinese characters in the DB. I have set the collation for those Chinese fields already and those queries or Stored Procs for Chinese are working fine, ONLY if I execute them in Enterprise Manager. Chinese characters can be displayed in the relevant tables. However here comes the big problem and I got really frustrated. As we will provide user interface in ASP pages, we 'll let users to insert the information which will be sent to the DB. If there's Chinese characters in the query string, the Chinese characters added in the DB ...Show All

• Windows Forms DataGridView CellValidated not fireing when expected.

  When is the cell validated event suppose to be fired I have a simple form with a DataViewGrid and a button (among other things). Sometimes when the user edits a cell then clicks the button, the CellValidated event is called After the button event is called. In this case the Button_Click event is called, which saves the data and clears the grid and apparently after the grid is cleared, then it calls CellValidated. This of course is a problem because the cell in question no longer exists. The order of events in the trace is basically Button_Click(...) DataGridViewRowCollection.Clear() DataGridViewRowCollection.ClearInternal(...) OnClearingRows() OnClearingRows() set_CurrentCell(...) SetCurrentCellAddressCore(...) EndEdit(...) CommitEdit(... ...Show All

• SQL Server Report Subscriptions <-> Scheduled Reports

  This question is in regards to using the ReportingServices2005 WebService classes with C# .net 2.0. What I am having trouble with is how to relate a schedule to a subscription. The piece of functionality that I am trying to duplicate is adding a report's subscription to a schedule (on the Subscription:{report_name} page's subscription processing options under the asp.net "Reports" app). How can I programmatically set a report's subscription's "subscription processing options" to use one of my existing Schedules Some things I have tried: - use ListSchedules to get a list of reports, use ListScheduledReport(scheduleId) to get a list of reports related to a schedule (this is great, it gets me the reports, but I ...Show All

• Software Development for Windows Vista A little help needed...

  This maybe a silly question for you all, but i am very frustrated about this >< Whenever a run a DOS program(like pascal) in Vista, it cannot be displayed in full-screen mode.... I have been doing researches in this and i found nothing.... can anyone help me hellow matthew Braun I wana just ask you .. how to make cmd go full screen I tried to do what you talken about  in properties of cmd.exe and I can't .. because there is no options tab .. but when I click right click on a dos program and properties .. and then I select screen .. and then I select full screen and apply it .. I click ok .. and when I run the program I encountered an error .. this system does not ...Show All

• SQL Server Query with another query input parameter

  Dear Friends, I have a long query with an input parameter. I want this input parameter be all teh values returned from another query. SELECT DIR FROM DIRECCAO BIG QUERY with DIR input parameter. How can I do Thanks. IT WORKS AND THE QUERY IS: ALTER PROCEDURE [dbo] . [GD_SP_FACTURA_GLOBAL] AS DECLARE @DIR nvarchar ( 10 ) SELECT @DIR = DIR_NOME FROM Direccao EXECUTE dbo . GD_SP_FACTURA_ValorTotal @DIR BUT How can I SUM all the values returned by the BIGQuery THANKS!! ...Show All

• Visual Studio Express Editions system date install date ect dates

  basic simple thing I hope here please don't refer me to the shareware starter kit I am not interested in it what I would like to do is set a date after a button click event that I can reference to at a later time in my code to turn certain functions off after a set amount of time 30 days for example. if I could be pointed in the right direction that would be great thanks for helping ;-) :-) well, you would be surprised at the lengths people go in to avoid such limitation - they can implement a filesystem watch or something - simple app whipped up in .NET for example to see what file system changes have been made by other software. ...Show All

• Smart Device Development smart device project creation failed!

  Hi all, I'm using VS2005 Team Edition and WM5 Smartphone SDK. The problem is I cannot create any smart device project, but I can open existing solutions. I've reinstalled the SDK and ActiveSync, But the problem still exist. So how to solve this kind of problem Thanks doyoucy I am experiencing the same problem trying to create C# projects. I can open existing projects and create C++ projects. I have the MS WinFX Runtime Components 3.0 and Windows SDK for Vista installed. Do you think that your workaround will work Thanks, John Z ...Show All

• Visual Studio Team System Web Proxy Authentication

  Our TFServer is behind a reverse proxy. SP1 was installed both on TFServer and on Clients. The ISAPI filter was set on TFS site to rip the integrate authentication from request sent by the reverse proxy, and basic authentication was allowed. All worked fine to the extranet (with a 401 response for each request although) when the client has directly on the internet When the client itself was behind a web proxy, which requires authentication, it can't pass trough it. Whiten the browser it can access to the web service: https://site:443/VersionControl/v1.0/Repository.asmx How can this information be set for Team Explorer Proxy issues are hard to fix. When we setup TFS internal we make sur ...Show All

• Visual Studio Generate documentation under .Net 2.0?

  I really need to generate some documentation under .Net 2.0. I know that this issue has been raised in a previous post few month ago, but no explicit solution has been provided. Also the NDoc project seems dead (as suggest the broken wiki). Does anyone has a practical (even minimal) solution to generate documentation for .Net 2.0 Thanks in advance, Joannes I found this article (Japanese only) http://blogs.wankuma.com/yaneurao/archive/2006/02/23/21472.aspx and he said, just create NDocGui.exe.config file inside bin folder where NDocGui.exe is located. < xml version="1.0" > <configuration> <startup> <supportedRuntime version="v2.0.50727" /> <supportedRuntime version="v1.1.43 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. anamation & png images

  Hi i am a complete newbie to the xna framework. i want to know how to anamate sprites. i think there is a way to do this by rotating sprites in a "loop" --blackley1-- Yes, there is a way to do this by rotating sprites in a "loop." And I'm just going to assume we aren't referring to actually rotating the sprite itself, as that is done differenty. I'll assume we're talking about rotating through the images that the sprite is composed of. First, make sure all of your animation frames are on the same png image. You can do this with all of them on different images too, but its a pain in the neck. Keeping all of your sprite animation frames on the same sprite sheet helps quite a bit. This way you can load one t ...Show All

• Visual C# GetEnumerator question

  I have a class that has a list containing another class. I need to get at the data members inside of the class inside of the class. I didn't think this would be a problem a simple foreach should take care of this right Wrong! I have the following for each foreach ( FileList F in driverEntry) { FileName = F.Name; } and I get this error foreach statement cannot operate on variables of type '_Default.DriverEntry' because '_Default.DriverEntry' does not contain a public definition for 'GetEnumerator' I have never written a GetEnumerator function before and frankly I don't know where to start. Could some one help give me a head start or is there a easier way to get at this P.S. If you need to see me class definitio ...Show All

• Windows Forms Signing multiple dlls of third party for deployment

  Hi, Suppose I have third-party controls used for development. Now I want to deploy my desktop based app. I want all third-party dlls to go into GAC. Say I have A.Charts.dll, A.Editors.dll, A.Graph.dll, A.Grid.dll etc. I have atleast 15 such Dlls. How do I sign all dlls My objective to then create .MSI package using these dlls. Secondly, do I have to make any changes to my AssemblyInfo.vb file Regards, VNJ ...Show All