Douglas McClean's Q&A profile

• SQL Server Date question

  I currently get a date in the default format in my stored procedure. Up until now converting the date to type 101 was acceptable. Now they want the date to read something like Wednesday, November 8, 2006 or November 8, 2006. How do I do this convert in a single select statement I found the types that add the time but I have to make sure that the time isn't included for merge reasons. Help Jeff Mookey wrote: I currently get a date in the default format in my stored procedure. Up until now converting the date to type 101 was acceptable. Now they want the date to read something like Wednesday, November 8, 2006 or November 8, 2006. How do I do this convert in a single se ...Show All

• Visual C++ strange linking error with operator overloading

  Hello everyone, I am meeting with a strange linking error regarding to operator overloading. I am creating a C++ static lib, and then linking it with a C application. Here is the error message and source codes, I am using adapter.cpp, adapter.h, foo.cpp and foo.h to create a static lib called foo.lib, then link it with a C application (goo.c). There is no problem to generate the static lib foo.lib. Any comments to solve this link error error LNK2019: unresolved external symbol "private: class FooNameSpace::Foo __thiscall FooNameSpace::Foo::operator=(long)" ( 4Foo@FooNameSpace@@AAE AV01@J@Z ) referenced in function "private: __thiscall FooNameSpace::Foo::Foo( long)" ( 0Foo@FooNameSpace@@AAE@J@Z ) fatal error LNK1120: 1 ...Show All

• Smart Device Development mobile applications..............how to start???????????????

  how can i create mobile applications using .net technology I think you should start by looking at the .NET Compact Framework http://www.microsoft.com/downloads/details.aspx FamilyID=9655156b-356b-4a2c-857c-e62f50ae9a55&displaylang=en , and look through their blog http://blogs.msdn.com/netcfteam/ and forum http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=33&SiteID=1 for hints. If you have specific .NET CF questions, you'll find more expertise on that forum than this one. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. error when loading 3D model

  Hi, I'm new to XNA. I tried exporting a simple model like a cube using 3Ds max 9 ( fbx format ) yet when I try to debug I get the following error: "Node has more then one bonecontent child. Unable to determine which one is the skeleton root". When I load the P1_wedge model, it compiles just fine so my guess is the problem has to do with the way I export the file. Can anynbode help me thanks Well, I don't know how to directly help you with loading a model, but I can show you the way I am doing it temporarily on my engine (until I implement texturing). public void Render( GraphicsDevice myDevice) { Matrix [] transforms = new Matrix [model.Bones.Count]; model.CopyAb ...Show All

• SQL Server MCTS Exam 70-431 Database Administration Study Documementation and Samples ?

  Hi, I am looking for good documentation and examples to use to 'study' for Microsoft exam 70-431. This has everything to do with nuts-and-bolts Database Administration of SQL Server 2005. The December BOL examples, do not cover enough topics. The topics that are covered are not in enough detail. The 70-431 exam requirements are very detailed. This seems to be a nuts-and-bolts test. I am looking for nuts-and-bolts study material. No books are published yet. Does anyone have any good ideas on where to find 'good' samples and tutorials meant for a person who is studying for the new Microsoft SQL Server 2005 Database Administrator Exam MCTS 70-431 All answers and ideas in 'any form' are appreciated. Thank you very much. ...Show All

• Visual Studio Express Editions Using SQL SVR 2000 with VS2005 Express

  I've installed the new VB for a look-see, but didn't install SQL Express. On our network I have three SQL 2000 servers and lots of databases to play with. I tried to create a simple app to bring back some data from one of these, but the Data Providers shown are either Access or SQL Express and needs a file to talk to. I tried to add in my SQL 2000 servers but couldn't find out how. 1) Have I got a bad installation of VS/VB 2005 It's slow, flakey as hell and crashes. Can't tell if this is because of the installation or it's like that. 2) Is VB Express limited to talking to SQL Express only 3) Should I install SQL Express to see if that fixes things 3) How the heck do I get VB 2005 Express to talk to my Sql 2000 servers if th ...Show All

• Visual Studio Express Editions Graphics Manipulation

  Hi All, care to share if it is possible to zoom in and out on bitmaps/JPEG images just like when we are using other software like photoshop or Adobe PDF under the Form environment Pls advice. Thanks in advance. Well, this seems to zoom a bit. ANd negative numbers should shrink things. Public Class Form1 Private Sub Button1_Click( ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Button1.Click Dim ns As Size = Drawing.Size.Add(PictureBox1.Size, New Size(10, 10)) PictureBox1.Size = ns End Sub End Class ...Show All

• SQL Server How to Add a column by getting value from a lookup table

  Hello, I have few columns at some level, and now I need to add a column from another database table based on the values from one of the existing columns. It seems that Lookup Transformation doesnt support parameterized query. Any clue Thanks Fahad Are you sure you need a aprameterized query in the the lookup trasnform you can write a query; the join the columns of the lookup table/query with the columns available in the data pipeline. Keep in mind, that you could have an aditional source component and then combine them using a Merge Join transform. ...Show All

• Windows Forms Listbox refresh

  I have Windows Forms Listbox which contains custom items. When I change these items, I need to redraw listbox: foreach( MyClass c in listBox1.Items ) { c.ChangeSomething(); // MyClass.ToString function gives new result after this change } Now I need to show new state, but using Refresh, Invalidate, Update etc. doesn't work and items are not updated immediately. Removing all items and adding them again works, but this is not nice. Is there better way One way to achieve this is to use data-binding. First, you need some notification mechanism to let your MyClass inform the UI it should refresh. You can add your-property-name Changed event or implement the INotifyPropertyChanged interface: pub ...Show All

• Visual Studio Complex Business Objects

  I have a problem with my report. My desire is to create a report using a complex business object like this: Object +--ID +--Customer (this is an object) +--CustomerID +--CustomerName +--Items (this is a collection of objects) +--Item0 +--Item.ID +--Item1 +--Item.ID Is it possible to create a report with an header (containing ObjectId and CustomerName), and a document detail (containing the list of items) I have already seen the samples on gotreportviewer site, and I tried to use nested data regions (the recommended approach) but with spare results. Can someone help me Thanks manu There is an example on this page to use a subreport for displaying collections: http://www.gotreportviewer.co ...Show All

• Visual Studio How to find out what command caused an memory exception?

  Hi, I have the following question. My application is working when I start the release exe from the inside of the VS (MFC, C++). But when I start the exe from the windows explorer I get an unhandled Win32 exception and the JIT debugger shows me address 0x10032B4A in an assembly language window. How can I find out, what command in my C++ source code matches to this address (especially in release mode) Thank you, Bernd I'm using Visual Studio Standard Edition 2005. There must be a difference between starting the release exe from the inside of the VS and from the Windows Explorer. When I compile the release version and stard debugging, everything is working fine. But without VS it evokes th ...Show All

• Windows Forms Webbrowser preventing enter firing

  I have created an MDI which can display 2 types of child windows: a) windows form with textbox control (to display text files) and b) windows form with embedded axWebBrowser. If I only display multiple child windows of the file type, then I can click on any part of the window to bring that child window to the front. However, as soon as I also display a webBrowser type window, I can only change which child window is on the top by clicking on the window title bar, regardless of what "type" of window it is i.e. clicking on any other part of the form will not bring that window to the top although I can input data into that child window, even though it remains at the back. Once I have shown a webbrowser type window, the other child wi ...Show All

• .NET Development Returning data contained in Ienumerable<type> as type[]?

  Hi there, Does anybody know how to return the results of an IEnumerable<type> as an array of the same type i.e type[] in a web service call without first having to collect all elements in the IEnumerable<type> and storing it in memory first This question is really about optimizing large collections of data returned by web services. If it is possible to loop through the IEnumerable<type> with a "foreach" and somehow start formatting the soap response already, there should be a fair amount of memory and time saved. We are currently running into timeouts and outofmemoryExceptions because building up a collection of types in a list<type> cannot handle the load. I tried to do this usin ...Show All

• Windows Live Developer Forums Writely

  Is it possible to post in Live Space with Writely I tried to post using the following parameters: My own server / custom API: MetaWeblog API URL: https://storage.msn.com/storageservice/MetaWeblog.rpc User name and Password as usual The test response is: (xmlrpc) unespected response type. After some days the test response is changed: Server returned HTTP response code 403... Any idea ...Show All

• Visual Studio Extending Add Reference Dialog

  I found this walkthrough in the September CTP SDK on adding a custom page in the Add reference dialog. The walkthrough is in C++ and I was wondering if this is possible to implement in C# (managed package) and any sample code available to supplement the "Next Steps" section. Here is the link from VS SDK help: ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.VSSDK.v80/dv_search/html/24a4a8b2-79b2-4621-9243-23a0bcbdc942.htm " IVsComponentSelectorProvider interface is implemented to add pages to the Add Reference dialog box. This walkthrough guides you through the steps of adding the code and registry entries necessary to implement IVsComponentSelectorProvider with the Visual Studio Integration Package wizard as a starting point. At the end of the wa ...Show All