ar_pad's Q&A profile
SQL Server dev to UAT to Live using linked server catalog to default the database
Hi all, Im trying to have one set of TSQL code that uses global settings in 'linked servers' so code can migrated from development, to test to UAT and finally to live without change. e.g. select * from [oursystem].ourDB.dbo.table join [linked_server_othersystem] .. dbo.tablename ... By using no database name (and expecting the catalog set at the linked server to be used) the same code is equivilent to : select * from [oursystem].ourDB.dbo.tablefrom [oursystem].ourDB.dbo.table join [linked_server_othersystem]. developmentDB .dbo.tablename select * from [oursystem].ourDB.dbo.table join [linked_server_othersystem]. testDB .dbo.tablename ... select * from [oursystem].ourDB.dbo.table join [linked_server_othersystem]. UATDB .db ...Show All
Smart Device Development Sample Applications/Projects that use Data Access & Business Logic Layers
Hi all, I am after some sample C# (.NET 2.0) sample applications for Smart Devices that make use of Data Access (for SQL Server mobile ) and business logic layers so that I can make use of them as references for when I'm developing layered applications for Smart Devices. Hope you can help me. Thanks Tryst Checkout MSDN How To page here http://msdn2.microsoft.com/en-us/library/ms184404.aspx that has lot of information and samples about Smart Devices database programming. Manav ...Show All
Visual C++ CWebbrowser object and IE 7
I am getting a strange error from the scripts of this object when ran on IE 7.0. When I step into the debugger, I get the message: "Object expected" and I get this listing: <html><head><script src="res://mshtml.dll/objectembed.js"></script> <script language="javascript">var objectSource="http://www.photosphere.fr/sedonline_anim/entree_nor.swf"; </script> </head><body onload="ObjectLoad();" leftmargin=0 topmargin=0 scroll=no> <form id="objectDestination"></form> </body></html> With ObjectLoad() highlighted in yellow. This of course works like a champ with IE 6.0 and former. Nor do I have any problem ...Show All
Visual C++ Compile C++ code To .Bin File
Hi. can I compile C++ code with VC++ or VC.Net to a BIN file How thanks. I don't remember a bin format for DOS, but there might have been. If there was, then the format probably was not defined. Also, anything compiled by the C compiler would need either Windows or DOS; the C compiler never generated code that could execute stand-alone without an operating system. I know that there is an embedded version of the VC compiler, and it might create the format you need. Look in the VC documentation for the embedded version to see if it can create a bin format. I suspect it won't do it for your microcontroller; I assume that the embedded version of VC creates executables for the embedded version of Windows. ...Show All
Visual Studio Tools for Office Replacing XLA with COM Automation Add-In
Hello all, We've got a bit of a problem here that we hope you can help us with. We've just developed a COM automation add-in in Visual Studio 2005 (C#) to replace an XLA add in. To ease the conversion, we named most of the functions exported by the COM library to the same name as those in the XLA file. However, our problem is that on removing the XLA file and adding in the COM automation add-in to a workbook, the excel spreadsheets cannot reference the new method calls which have the same name as the old calls in the XLA. If we create a new worksheet and add in the automation item, then the calls work fine. For example, the UDF call CBSpot existed in the XLA. When we remove the XLA and add in the automation DLL CBSpot can't be resolve ...Show All
Smart Device Development How do I read/write a binary key in the registry on a pocket pc?
Here is my test code buy I get a error every time. I have been able to reas and write dword and string keys with the basic same code with no errors but I am stumped on this. Dim test As Byte test = Microsoft.Win32.Registry.GetValue( "HKEY_LOCAL_MACHINE\Software\Microsoft\Color" , "SHColor" , Nothing ) If test = &H1B Then CheckBox2.CheckState = CheckState.Checked CheckBox2.Enabled = False End If If CheckBox1.Enabled = True And CheckBox1.CheckState = CheckState.Checked Then Microsoft.Win32.Registry.GetValue( "HKEY_LOCAL_MACHINE\Software\Microsoft\Color" , "SHColor" , &H5a ) End If Thanks in advance, Mark ...Show All
SQL Server Itens of the report in lines and not columns
Hi, It would like that my report was in the following way, for example: Product A 10 Itens 00001 00002 00003 00004 00005 00006 00007 00008 00009 00010 Product B 5 Itens 00020 00021 00022 00023 00024 This is possible Thank you Sandro Borsatto Look at this blog entry. http://blogs.msdn.com/chrishays/archive/2004/07/23/HorizontalTables.aspx ...Show All
.NET Development Table Adapter update problems in Strongly Types Dataset
Updating dataset tables in parent child configuration: I'm using a fill method with parameters to load data into a "ParentTable" and if it is empty after the fill() I insert a new row. I assume that the new row then gets rowstate = "Added". All tables in this dataset has an auto inc primary key. In a child table I also fill with it's fill method using parameters and if it is empty I fill it with valid data and using the ParentTable's PK to maintain a FK constraint and my valid data for the rest of the fields. After inserting data into the tables in this Strongly Typed Data Set I am issuing a TableAdapter.Update on only Added Rows along with an AcceptChanges on each table . I expect the FK fields in the DataSet to be ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Whats finaly in and out?
Hellooo there... Anyone have an Idea which features are finaly in or out with the upcomming GSE What about fonts and ui, are there more api changes. I found an post to give a wishlist at connect for the next release but how could we do that without to know whats in this time... Oke... to say the truth: i'm just excited... I can't see anything being added that's not in the current beta, as it wouldn't be properly tested. There's a couple of font rendering classes that the community has released. I'd bet a GUI library would pop up soon (not that I'm working on one or anything ). I'm sure the XNA team is going to put out ver. 1.1 with all kinds of new stuff soon after the RTM. ...Show All
Visual Studio Tools for Office Create .xls file and export all open worksheets
Hi, I have been trying to write a method that creates a new .xls file and exports any open worksheets to it. What is the best way to do this I have been trying using an instance of Excel.Application. But so far have been able to do it. Thanks. Ben. Hi Ben Questions concerning general Office application automation should be addressed to the office.developer.automation newsgroup. When you post, please specify the software versions and programming language you're using. Also, please describe in more detail what you're trying to do; for example, it's not clear what you mean by "any open worksheets" and what you mean by "exporting" them. Do you mean you want to copy all the worksheets i ...Show All
Software Development for Windows Vista Is there any way (API) to turn off Aero to enable video overlay?
My application uses hardware overlay that can not display on Aero. So I want to turn off Aero Grass by my application. Is there any API for killing Aero ( SystemParametersInfo ) Or any other way ( stop some services. ets... ) I found a solution to my problem on Friday on how to disable the Vista Aero theme prior to initiating our desktop sharing session and then re-enabling it once the desktop sharing session is complete (we had some severe performance issues during the desktop sharing session while the Vista Aero theme was active on the client's computer). Anyway the solution was found on the blogg site of a fellow by the name of Kenny Kerr: http://weblogs.asp.net/kennykerr/archive/2006 ...Show All
Visual C# Updating PictureBox Image
I m initializing the picturebox with an image like Image img = Image.FromFile("c:\\image.gif"); picBox.Image = img; Now, the image image.gif is being updated by another process. I want the picturebox to reflect this updated image file every few seconds(I can put a timer control 4 this).But, what really causes the problem is that the image handle is owned by the picbox and I m unable 2 update it. What I have done temporarily is alternately write the image in img1.gif and img2.gif and m referencing the images alternatively in the picbox also to avoid conflict. Thnx in advance for any suggestions or tips. Happy C#ing The problem is not with the picture box but with the image. Yo ...Show All
Visual Studio 2008 (Pre-release) TCP URL?
I have a web service that is listening on an HTTP port and a TCP port. I can see that this is happening with netstat -a. I try to test the TCP connection using the ChannelFactory like: EndpointAddress address = new EndpointAddress ( "net.tcp://localhost:8005/Services" ); ChannelFactory < IServices > factory = new ChannelFactory < IServices >( "WSHttpBinding_IServices" , address); and I get: The provided URI scheme 'net.tcp' is invalid; expected 'http' Any idea what I am doing wrong Thank you. Kevin hi, The scheme must match the binding. It looks like you're using wsHttpBinding instead of netTcpBinding. your scheme is indicating tcp (net. ...Show All
.NET Development NetworkStream.Length Property
Hi All, I want to use this property but in MSDN it says "This property is not currently supported and always throws a NotSupportedException.". When will it be supported Can you suggest any other method or property Its means that Property exists but there is not any implementation in it and when you call it it raises NotSuported exception because its somehting like: public long Length { get { throw new NotSupportedException(); } } Tell me what your scenerio and why do you need to get length of the stream, there may be many alternates to get your work done without this property. Best Regards, Rizwan ...Show All
Visual Basic will the stuff in this book work with VB2005 express edition?
that is the book, it talks of visual basic 5.0 and 6.0, will VB2005 express edition run the code right if not where can i download VB6 (free edition) EDIT: the book doesnt seem to be comming up, but it is called microsoft cisual basic game programming with DirectX by Jonathan S. Harbour NO, VB5 and VB6 code will not work in VB.NET versions. And VB6 is no longer released by Microsoft and there never was a free version of VB6! I would suggest downloading Visual Basic Express for free and try upgrading the VB6 code with an upgrade wizard ...Show All