Nick1435's Q&A profile

• SQL Server Upgrade query

  I wish to know if it is possible to upgrade SQL Server 2000 Standard Edition to SQL Server 2005 Enterprise Edition. I'm not sure what bit version I have of SQL Server 2000. I have just downloaded the X86 executable for SQL Server 2005 from the msdn downloads site. Thanks Vik Hi buddy U can upgrade from SQL2000 Std edi to SQL 2005 Ent Edi. Any way if U wish, can check for the upgrade path from : http://msdn2.microsoft.com/en-us/library/ms143393.aspx Thnks nd Rgrds Rahul Kumar Software Engineer ...Show All

• .NET Development Data Adapters vs Table Adapters

  We are upgrading from VB 03/SQL MSDE to VB 05/SQL Express edition. The code all upgraded fine. The point of confusion is the Data Set/data adapter (03) vs Data Set/Table Adapter (05). In the O3 version, we created many Data Sets (Some with multiple tables, some with multiple Data Adapters to handle different Queries), and Data Adapters in the Component Designer (there is no comparable component designer in Add, New Item in 05). During conversion, all Data Sets were automatically copied to the Data Source Tab. All Data Adapters and Data Sets were left in the Component Designer document. Many questions: Are Table Adapters going to replace Data Adapters as time goes on If yes, then it would make sense ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Porting a game to the 360

  Ok, so i want to test out this XNA on teh 360 thing. I have a game that i made that all one .exe file. I want to port it over so I can play it on my 360 now. How do I do this Thank you very much to anyoen that helps me. I am new to console developing, but not game developing Thanks, but that doesnt tell me how to port my .exe file. I have a game i made for windows running off C++ that is all in one .exe file and I need to know what to code into the XNA program so that I can run it on my 360. like that guy just opened up a pre-existing XNA file with the game encoded already ...Show All

• Visual Studio 2008 (Pre-release) Share screen between xbap Page and standalone Window

  We're building a standalone application using Window (not Page). However, a small subset of the application needs to be available to a larger user base via an xbap (i.e., Page) application. How can I effectively share code between the two applications I have a screen built with a DockPanel that I've copied between the two applications just to see how portable the code is. I can get it to display in either a Page or a Window. I believe using some of the techniques described in the Flexible Application template , I can determine if I'm running in an xbap or standlone for some minor behavior changes. At first I thought I could just put it in an assembly and access it from either application. However, the problem is that one is Page and ...Show All

• .NET Development Client Server Communication

  Hey all, I am investigating a system that will be comprised of two components: a Windows Forms application that will be installed on client machines, a Windows Service application that will be installed on a Windows server. The client will need to poll the service across a standard Windows network to check to see if the service has any data to send. If there is data available, the service must send it to the client so that the client can use it. The question is how do I implement this functionality I am wanting to keep the system complexity low and it needs to be fast. I was thinking about using TCP/IP sockets, but have little knowledge about this so any advice you guys have to offer would be great! Thanks in advance, St ...Show All

• Internet Explorer Development Image not being displayed ("Not found") >> Same thing works in firefox (BUG!?)

  I've written a html page which contains the following tag: <img src="icons/addmate.jpg" /> The html file resides in "C:\Documents and Settings\matt\My Documents\Visual Studio 2005\Projects\DaNetCli_Proto\Mods\default\tools.html" and the jpg file resides in: "C:\Documents and Settings\matt\My Documents\Visual Studio 2005\Projects\DaNetCli_Proto\Mods\default\icons\addmate.jpg" Now the strange bit: this html file works in Firefox, but not in IE. Anyone come across the same problem or know a workaround. I'd really like to avoid using an absolute path. AH! Found the problem! The reason this was happening is why most software running on windows (usually) isn't as good as softw ...Show All

• Windows Forms errorProvider not clearing icon

  I have a requied textbox. The problem is when I tab out of the textbox after entering data, the validation fires, but doesn't clear the error icon on the textbox. It still displays until I tab back into the textbox and tab out again. private void sUBJECTTextBox_Validated( object sender, EventArgs e) { HDDataSet . HELPDESKRow ticket = ( HDDataSet . HELPDESKRow )(( DataRowView )hELPDESKBindingSource.Current).Row; if (sUBJECTTextBox.Text.Length > 0) { ticket.SetColumnError(hDDataSet.HELPDESK.SUBJECTColumn, "" ); } else { ticket.RowError = "Error on ticket" ; ticket.SetColumnError(hDDataSet.HELPDESK.SUBJECTColumn, "Subject is required." ); } } ...Show All

• Visual C# SetDirty in Data Object

  i have 2 questions and they are best explained with an example. Lets say I have the following 2 properties on my data object class: public string name { get { return _name; } set { _name = value; SetDirty(); } } public List<MyObject> ListMyObject { get { return _listMyObject; } set { _name = listMyObject; SetDirty(); } } I want my data object class to mark itself as dirty whenever a field value is changed. Question #1: A user of my class can manipulate the generic list without triggering my SetDirty() method as shown below. Is the only way that I can guarantee safety of my generic lists is to expose the item collection through methods rather than exposing the list as ...Show All

• Visual Studio Express Editions how to creat a dll in vb.net

  hello all i have a project, selected and new class from the add in file menu. i copied a peice of code from my first project and pasted it to my new class . in the new project many items come up with squigglies to say they are not defined kind of, or not recognised. I am doing something wrong for sure, any siuggestions would be appreciated. many thanks this could be due to the fact that from the "old" project, the items needed are not in the new project you have copied your class into, such as custom classes made or perhaps namespaces needed to be imported. Compile it, it should throw some errors and follow the errors, correcting them by doing as what the compiler may suggest, su ...Show All

• Visual Studio VS2005 Addin problem - main menu bar stops working

  Hello, Over the past few months I've created a development tool for my job. At first it was really small, but once I got used to the kind of power the VS2005 addin interface has, I started expanding it a lot. My newest version has about 25 different mini-tools in it, and I made it so that the user of the tool can customize at runtime which commands will be placed in the VS2005 main menu bar "Tools" menu (usually the most frequently used tools, so that you can bind keys to them or have a handy button on a toolbar at the top of the development environment). Now the problem is that about 30% of the time, when a user updates the tools he/she wants to use, the VS2005 main menu bar (file, edit, view, project, build, etc) just stops res ...Show All

• SQL Server Foreign Key Constraint enforcement question

  If I have an composite Foriegn key on a table, say like this: CREATE TABLE FKTable ( ID INT NOT NULL, ID2 INT NOT NULL, PRIMARY KEY (ID,ID2)) CREATE TABLE OtherTable ( OID INT NOT NULL, ID INT, ID2 INT, PRIMARY KEY (OID), FOREIGN KEY (ID, ID2) REFERENCES FKTable (ID, DI2)) ) Other than the fact that the above probably isn't correct SQL Syntax but you get the idea of the structure. Am I wong in believing that an INSERT into OtherTable should fail the Foreign Key Constraint test, if either ID or ID2 is null when being inserted into OtherTable ie INSERT INTO OtherTable (OID, ID, ID2) VALUES (1, 123, NULL) or INSERT INTO OtherTable (OID, ID, ID2) VALUES (1, NULL, 123) Your assumption that the insert statement ...Show All

• Visual Studio Express Editions Very simple help needed

  I apologize for asking this but I couldn't find any help. I wanna put a button on my form that will assign a number to a frame, it needs to be uneditable by the user but editable by the computer. I need to put something like a frame in there. I've looked up and down the list in my copy of 2005 Visual Basic Express Edition but I couldn't find a frame control to put on my form, so what do I choose to generate a random number: Dim randGen as new Random() Dim theNumberChosen as Integer = randGen.Next( min, max ) this will generate a random number for you between min and max. Now this will give you the number you need perhaps but you need to obtain that "frame" you need. perhaps b ...Show All

• SQL Server Unreadable Server Dashboard report elements

  I noticed on a SQL 2005 production machine that the Server Dashboard report CPU Usage and Logical IO Performance elements that the listing is squished to the point that it is unreadable. Is there another way to get access to this data Thanks, Colin All of the information contained in the Management Studio "Standard Reports" can be obtained through the Dynamic Management Views, Catalog Views, and Default Trace. You can download the reports from my blog: http://blogs.msdn.com/sqlrem/archive/2006/08/30/SSMS-Reports-3.aspx After getting the report, you can open it up in Business Intelligence Development Studio to inspect the queries used to generate the chart in which you're interested. Paul A. Mestemaker II Program ...Show All

• SQL Server Named sets and Existing

  I have a very large Account dimension (> 2,000,000 members). I would like to create a named set for the top most profitable accounts. I plan to use this named set in the SSRS Report Builder to compensate for its lack of aTop N feature. The problem is that the user can change the fiscal period and SSAS needs to reevaluate the set. Using Generate function won't work for performance reasons. So, I'm trying to use Existing to force the set generation. e.g. CREATE SET CURRENTCUBE .[Top 5 Profitable Accounts] AS Order ( TopCount ( ( EXISTING [Account].[Account].[Account]. Members , [Period].[Period]. CurrentMember ), 5, [Measures].[Profit]), [Measures].[Profit], DESC ); However, this gives me " The Period hiera ...Show All

• .NET Development Exposing .NET Framework Components to COM

  Hello everybody, I am trying to execute the "nice" example taken from ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.VisualStudio.v80.en/dv_fxinterop/html/a219cb2c-9fa2-4c90-9b26-939e0788f178.htm, unfortunatelly , in the file ConLoan.cpp which contains the following code: #include "stdafx.h" #import "..\LoanLib\LoanLib.tlb" raw_interfaces_only using namespace LoanLib; the compiler doesn't recognize the namespace LoanLib even although I imported the tlb file, and although the dll is in the same directory where the main is located,; also , when I am writing the line that is written there ILoanPtr pILoan(__uuidof(Loan)); the compiler doesn't recognize that, (by the way , shouldn't they write ILoan pILo ...Show All