QuantumMischief's Q&A profile

• SQL Server Invert rows and columns (PIVOT)

  Hi everybody. I have this table that contains how many items were sold (and their value) into two departments: SellerID(PK) Year(PK) ItemsSoldDPT1 ItemsSoldDPT2 ValueSoldDPT1 ValueSoldDPT2 1 2002 10 20 300.00 400.00 1 2003 13 71 450.00 320.00 1 2004 8 4 350.00 640.00 1 2005 2 15 110.00 680.00 2 2001 3 1 130.00 100.00 2 2005 1 7 190.00 200.00 2 2006 6 9 170.00 500.00 ... ... ... ... ... ... I'm trying to write a query that puts the data present in the "Year" column as if they were in a row (column definitions)..making sums of pieces and val ...Show All

• Internet Explorer Development nocache, refresh prompt, forms authentication

  ok, I don't think this is possible, but I hope someone can prove me wrong I have a .net 2.0 web app that contains personal health information, so i don't want to cache pages locally (person2 could use the back button after person1 logout and see info authorized for person1), so i'm using this in PageBase class HttpContext .Current.Response.Cache.SetCacheability(System.Web. HttpCacheability .NoCache); and this in the logoff routine Session.Clear(); Session.Abandon(); FormsAuthentication .SignOut(); Response.Redirect( ConfigurationManager .AppSettings[ "LoginPage" ]); I would like to be able to use the back button when the user is logged in, and NOT get a refresh 'page expired' prompt. The back b ...Show All

• SQL Server Problem - cannot connect; but I know this should work !

  Hello - I've setup SQL Server 2005 from scratch over half a dozen times now. I have remote connection down cold. Install the SQL Server. Run Surface config. Enable remote connection over TCP/IP and named pipes. Set up client alias. Restart SQL Server. (I install for mixed mode every time.) Every time this has worked up till now. Start up SQL Server Mgmt Studio, select the server to login to, enter the sa user name and password, boom, you're in. This time I cannot get in. Connection is denied both for sa and windows authenticated login as Administrator. This is the two line dump from event viewer - the first is an audit problem, the second is the error. Event Type: Failure Audit Event Source: MSSQLSERVER Event Category: (4) E ...Show All

• Visual C++ ATL Stock Properties

  Hi. I'm developing an ATL Control, (Composite Control), and now I want to add a stock propertie, ie BackStyle. How could I do that . Because there's not options for stock properties right clicking in the class view, (I'm using VC 6.0). At the time of add an ATL Object, there is a wizard that offer to add some stock propertie, but I did'nt in that moment, and now I need some of them. Thank you. These forums are specific for VC2005 issues. For VC6.0, please use the newsgroups at http://msdn.microsoft.com/newsgroups . OTP Thanks, Ayman Shoukry VC++ Team ...Show All

• Visual Studio 2008 (Pre-release) Wire Dump?

  How do I do a wire dump of the SOAP request/response on the client side using WCF and not any kind of sniffer/proxy tool You can enable message tracing/logging on your client configuration file. Here's a good description of the options available and how to configure it. ...Show All

• Smart Device Development Missing WYSIWYG editing

  I opened my project today (after a week vacation) and attempted to do development for my .Net compact framework project. When viewing the design of a form/user control, all I see are icons of the controls currently being used. It used to show the form factor of the control/form. How do I get that back Not sure what has happened while I was gone. ...Show All

• Visual Studio Express Editions Users Name Space help

  I always get good advice here so thanks in advance. I am writing a password keeper in vb2005 express as a learning experience. I have it saving encrypted passwords on a thumb drive and want to expand it so anyone who signs on to XP machine will have access to their passwords only. Can anyone give me an idea of the name space I need to explore to get the XP users info and setup accounts on the thumb drive Dave not exactly sure what you mean and how this will work. you shouldnt really be having a password keeper as it can easily be stolen or hacked into or whatever but understand its more for your experience/learning. ...you can obtain the current logged in user by doing... System.Security.Principal.W ...Show All

• SQL Server how to tell expiration date of eval version

  First question: I have sql server 2005 enterprise eval edition installed. is there a query, command or tool can tell me the exact expiration date I understand it is 180 day but I still want some way to query the exact date. Second question: does sql server log any warning message before eval expires Simply look at the creation date of the SQL folders. There is a message in the event log telling about the expiration date of SQL Server. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual C++ Converting System::String to LPCWSTR

  I've been looking for a long time as to how to solve this, and eventually just thought I'd ask. I've been told of A2W, which apparently cannot convert from System::String (so says the compiler error), I've tried converting to a wchar_t first, but the method won't accept it, and I'm running out of luck. Here's what my code looks like now. pin_ptr<const wchar_t> wch = PtrToStringChars(fileName); IAVIFile *aviMedia = NULL; IAVIStream *aviStream = NULL; AVISTREAMINFO *aviSInfo = NULL; AVIFILEINFO aviFInfo; LONG bufferSize = NULL; DWORD length = NULL; wchar_t wcFileLoc; Single vidLength; AVIFileInit(); wcFi ...Show All

• Visual C++ Unmanaged C++ and VS2005: Hidden .NET Requirements?

  Hi everyone. While developing some unmanaged C++ DLL that uses COM and ATL, I've been having issues with deploying the DLL to other machines - those without .NET Framework v2. I've found out after some digging that changing the runtime library from its default to one of the debug libraries (and none of the DLL ones) removed this dependency, but introduced some crashes that im not entirely sure are related to my own application's logic. What is the proper way of creating unmanaged c++ DLLs in VC++2005, Who use ATL and COM Thanks in advance. Thanks for your answers, I've marked the one more relevant as the 'answer' for this post. I hope that its the source of the issues i was having. Just to be sure i'm doi ...Show All

• .NET Development access table row of html from server side code if vb.net

  how to access table row of html from server side code if vb.net altamash.... you have to place the runat="server" in the table in the html so you will be able to access the table in the server-side. (this will create a server variable with the table name in the page). Then you can access the table in the server and navigate through its rows using the Rows property.... Here you have an example: http://msdn2.microsoft.com/en-us/library/system.web.ui.htmlcontrols.htmltable(VS.80).aspx Rgds Rodrigo PD. Remember to post asp.net questions in http://forums.asp.net ...Show All

• SQL Server SELECT Query duplicating rows

  Hi, I have a small problem that i cant seem to get my head around regarding the results of the following SELECT query. The result set contains two rows for every Employee - one for Annual (EntitlementID = 1) and one for Long (EntitlementID = 2) Where have i gone wrong Thanks in advance. --Tables: Employee (EmployeeID, EmployeeCode) -- EmpEntitlementValue (EntitlementID, EmployeeID, Balance) -- Entitlement -- Department -- Position -- Contact (FName, LName USE Employees go SELECT EmployeeCode As 'Employee Number', FName + ' ' + LName As 'Employee Name', Department .[Name] As 'Department', Position .[Name] As 'Position', CAST(DAY(DateStarted) ...Show All

• Visual Basic convert hexadecimal number to floating point

  Hi How can I convert hexadecimal number to floating point For example: convert &H 41E0F5C3 to 28.12 Please advice. Thanks in advance. Doron <StructLayout(LayoutKind.Explicit)> Structure conv <FieldOffset(0)> Dim f As Single <FieldOffset(0)> Dim i As Integer End Structure Dim c As conv c.i = &H41E0F5C3 Debug.WriteLine(c.f) ---> 28.12 ...Show All

• Visual Basic help please on print dialog

  how on the push of a button do i bring up a pring dialog for pinting the contents of a text box. that does not work. I have a menu and one of the options is print and when you press it i want it to bring up a dialog to print and the text i wnat it to print is the test inside my text box (text1). Thinks. ...Show All

• Visual Studio Team System Inheritance of Test Classes

  My problem is: I have got a quite long list of test methods and I want to execute this list twice, with different preconditions. With NUnit I solved this problem by creating a base class (Base) containing all test methods. Then I derived from Base two classes,let's say Condition1 and Condition2. Both derives classes are tagged with [TextFixture] (TestClass in VS), while the Base class is not. Both classes only implement the different precondition in a [TestFixtureSetup] (ClassInitialize in VS) method. That worked fine: NUnit listed two test classes: Condition1 and Condition2. In VS it seams to be not allowed to have test methods in a class that is not tagged with [TestClass]. Tagging the base class is no solution: Then the Base class is ...Show All