ropley's Q&A profile

• SQL Server Sql2000 and C# express

  Hi, I'm experiencing a very strange problem I setuped sql2000 and c# 2005 express edition, and i created a database application, i create the sqlconnection inside the code dynamically, using ConnectionStringBuilder after i used System.Data.Sql. SqlDataSourceEnumerator .Instance.GetDatasources(); but it doesn't return instances, even when i disabled the firewall on my pc, but after i install sqlexpress it returns all of them, but in both cases i cannont access database in any instance when i try to addconnection from the wizard, the default data source is ./sqlexpress, and it's also in config files, why , and what changes i shall make so i can access sql2000 Thanks in Advance Whas is the edition of the SQL Server ...Show All

• Architecture "Unique ID" server for multi-server app

  I'm building an ASP.NET app that I hope will scale to need multiple servers. For certain objects, I'd like to provide users with an "External ID". This would be either a user entered or randomly generated string, like "Fred's Data" or "q1g52xTK". This external ID would be associated with a GUID, and would allow the user to get at the object without having to know the GUID (such as at log-in). (They will also be able to select via more complete names, titles and descriptions.) For each new external ID, I'll have to do a lookup against all existing external ID's for that object type, to make sure it's not been used. It's like when you sign up for a Hotmail or Yahoo email, and enter a ID, and they say &q ...Show All

• SQL Server Floating Point Error - Order By Mystery

  I'm having a problem that I think is due to corrupt data. Depending on the column I use in my order by clause two problems are occuring. 1. No results are returned and I get this error: A floating point exception occured in the user process. 2. Results are returned but there are a different number of rows depending on which columns I use in my Order By clause. Examples SELECT * FROM SymbolStats ORDER BY calc_date, symbol Returns - 12207 rows but only includes one of the 25 dates in the table. ---------- SELECT * from SymbolStats ORDER BY current_hv Returns - 0 rows. ---------- SELECT * from SymbolStats ORDER BY average_hv Returns - floating point error With more conditions in the WHERE clause the number of results returned varies gre ...Show All

• Visual Studio Express Editions how to use a dll

  i want to use microsoft.sqlserver.smo.dll in my c++ program . can somebody help me. Look at the first link i posted, it contains a pretty good example of using smo, at the foot of the page you can download the source to the example and examine that in more detail. ...Show All

• Visual C++ Simulating Left Mouse Button Click

  Hi, At the moment, I am running into a problem which is this: Every time I right-click on a TreeView item in my application, the selected item remains the item prior to right-clicking rather than changing to the right-clicked item. While this isn't exactly a BUG, it is quite an inconvenience. The most obvious solution to the problem, to me, is to simulate a left-button click in the right-click NM_RCLICK event that will in turn select the item prior to any further actions. Is there a better way to accomplish this If not, how can the left-click simulation be accomplished Thanks in advanced. ---Dan To simulate mouse clicks, you can use mouse_event and SendInput. However, I think it will be better to use ...Show All

• Windows Forms how can we have a datagrid with vertical header ? (webform)

  hi i am webdeveloper and i wanna to know how can we have a datagrid with vertical header in webform. thanks ! Here is a example in WinForm. Hope it is helpful. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=686296&SiteID=1 ...Show All

• Visual C++ compiler switches

  I am working on a new project that has a lot of regular DLLs. I wanted to find out when and where a particular DLL got loaded. Is there a compiler swicth that would list that in output window If not, where should I set my breakpoint to iterate the flow Is there an easy way of doing it BTW, It got loaded in the very beginning. My guess is that there are some global variables. But I don't know which one since there are too many classes in this particular DLL. Thanks The error is "Error loading type library/DLL". I guess it is still a managed DLL even though regasm created an entry in the registry. My question is that how do I use it in C++ program after I regasm the C# Dll into COM ...Show All

• SQL Server Child Package Fails when called from parent

  So I have a parent package that calls another package using the Execute Package Task. When I run the child it runs fine but when I run it from the parent i get this msg...Any ideas Error: 0xC00220E4 at Execute VR Account Load: Error 0xC0012050 while preparing to load the package. Package failed validation from the ExecutePackage task. The package cannot run. Wenyang, Thanks for the reply but the solution did not work. I might have found a bug here because the child package uses package configurations and even though I have disabled the package config on the child when I execute it from the parent the output window says that it is trying to load the package configurations. Not sure if this has any ...Show All

• Visual Studio August CTP

  Hello I am using Eric Woodruff's sandcastle helper and i get the following error. Can anyone tell me how to overcome this. MRefBuilderStatic (v2.0.2397.42473) Copyright Microsoft Corp. 2005 Info: Loaded 8 assemblies for reflection Info: Wrote information on 14 namespaces, 128 types, and 700 members ------------------------------- Removing duplicate topics from reflection.org 0 duplicate topics removed ------------------------------- Removing attribute information from reflection.org 93 attribute nodes removed ------------------------------- Transforming reflection output... [C:\temp_radhika\DownLoads\Test\Working\TransformManifest.bat] UnrecognizedOption: /xsl:C:\Program Files\Sandcastle\ProductionTransforms\AddOver ...Show All

• Visual C# Immediate window in C# VS2005 - how to loop through collection

  I've got an error during loading data into DataTable - "Constraint violation...Relax constraints.". I need to loop in immediate window to find DataRow that HasError. I tried: foreach(DataRow dr in dtab) if(dr.HasErrors) Console.WriteLine(dr["ID"]); but it failed: Invalid expression term 'foreach'. Is there any way to achive it Billberry Use conditional breakpoints. http://msdn2.microsoft.com/en-gb/library/7sye83ce.aspx ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. What kind of data will invoke the excution of a GS

  GS provides a flexible way for users to generate new primitives. We want it is more flexible. If we emit some new primitives without use any input data such as position or color. This case supported by current DX10 MS SUPPORT: void GS(inout TriangleStream<PSIn> stream) { PSIn element; element.pos = float4 (0.0f, 0.5f, 0.5f, 1.0f); stream.Append (element); element.pos = float4 (0.5f, -0.5f, 0.5f, 1.0f); stream.Append (element); element.pos = float4 (-0.5f, -0.5f, 0.5f, 1.0f); stream.Append (element); } ...Show All

• .NET Development Reflection and GetMethod when generic parameter

  Hello All, I have a class with the following methods void Sort(int) void Sort<T>(IList<T>) I want to have access to the second one by reflection. When I use GetMethod("Sort"), I receive the AmbiguousMatch exception so I was thinking to specify the parameters with GetMethod("Sort", new Type[] {typeof(IList<>)}) but I receive null --> The method is not found. When I change the name of the first one and that I use the GetMethod("Sort") method, it works and if I look then the parameters I receive IList'1[T] when typeof(IList<>) gives me IList'1 What can I do to access my mehtod by reflection Thanks, Pierre-Emmanuel The basic problem is that you need to ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. From Express to Pro

  First off, let me say that this news about being able to develop and test my code on my 360 for an amazingly low price sounds excellent. I do have a quick question though. Will there be some established way to go about trying to get a game on Live Arcade that was developed with Express I know that I will definitely grab Express as soon as it's available and also have the subscription to be able to test my games on the 360, but I'm curious what my options would be if/when I write a great game :) Will there be some way to use the completed game as a pitch, or would it first be necessary for me to buy the Pro version If I had some sort of confirmation that the game would be put on Live Arcade then expenses for the Pro version wouldn't be a ...Show All

• SQL Server What persmissions to give to the application account to the Certificate

  Hey guys. I've an application which uses an account named Uaccount1. I've given it db_datareader and db_datawriter permissions to the tables. I've given it execute permissions to all sp's I've given it reference permissions to the symmetric key. And I gave it reference permissions on the certificate. At this point, it can't see the certificate. If I give control permission to the account for the certificate, it works perfect. Is it necessary to do that or am I missing something. Our security is based on symmetric key and certificates... Thank you Tej. Hey Sung. Thank you for the reply. I tried giving all different permissions to it but it doesn't work. It works only with the co ...Show All

• .NET Development MMC 3.0 Custom Snapin - How can I programmatically activate a node?

  Hello, I'm developing a snap-in for MMC 3.0. On the view for my root node I display a welcome screen (win form) with several link buttons which I would like to use to activate other nodes in the snap-in when the user clicks on them. I cannot find a way to programatically activate nodes within the snap-in in any way. I've poured through the entire Microsoft.ManagementConsole namespace. Has anyone any insight here Thanks, Tony Hi! Try this! selectionFormView (My startupForm) is set in the Initializing event of the control. foreach ( ScopeNode sn in selectionFormView.ScopeNode.Children) { if (sn.DisplayName == "System Properties" ) { selectionFormView.SelectScopeN ...Show All