Hang Lam's Q&A profile

• Visual Studio MS Development Environment

  I have used the same installation of Visual Studio .NET 2003 on the same computer for at least 6 months and never had a problem with the application. When I open it I get the following popup message. "MS Development Environment has not been installed for the current user. Please run setup to install the application." I have never had this problem before. I ran the setup again without uninstalling VS .NET 2003. I still get the same message. I already know that you're going to tell me I need to uninstall the app and reinstall it again (redundant). But tell me anyway. Thanks, Jeff Green Hello, I just started having the same problem and am now looking for a solution. Do you remember how you resolved this issue Pleas ...Show All

• SQL Server CrossTable - SQL Server 2000 Help me

  Hello, sorry for my English.. i have this problem two tables TABLE_A Import 65 132 244 165 TABLE_B FromValue ToValue 0 100 101 200 201 1000 i'd like a query that have to result this Field1 Field2 Field3 (Count of table A) 0 100 1 101 200 2 201 1000 1 and if i change the table B this query automatically change.. thank's very much Try SELECT FromValue ToValue, (SELECT COUNT(*) FROM TableA A WHERE A.ImportBETWEEN B.FromValue AND B.ToValue) AS Cnt FROM TableB ...Show All

• Visual Studio 2008 (Pre-release) Could I use SqlMetal.Exe with C# 2.0

  Is there any possibility that i can use SqlMetal.Exe (produce DAL) and C# 2.0 (it uses output classes of SQLMetal.exe) And extra question : Is it safe to install C # 3.0 to Production Server (not development server)  I will develop LINQ ASP.NEt project on my own computer than i will publish it to Production Server (it includes ASp.NET 2.0 projects) .. SqlMetal output is really designed for use with DLinq so even if you can compile the entity classes with C# 2.0, that is not going to help much for building a DAL. You will still have to populate objects yourself using DataReader and submit changes back using SQL commands. As the name indicates, May 2006 LINQ CTP is a " ...Show All

• SQL Server default values in SQL Server 2005

  I'm running the September CTP of SQL Server 2005 and I noticed that the way default values are scripted and displayed in the tools has changed. In SQL Server 2000, if I create a table with an INT field with a default value of 0, it gets scripted as FIELDNAME INT DEFAULT (0) Enterprise Manager also shows (0). If you type in 0 for the default (no parentheses) and save, it converts it to (0) in the UI, and it will be scripted with one set of parentheses. In SQL Server 2005 it seems to add an additional set of parentheses. Hence, if you type in 0 for the default in Management Studio, it changes it to ((0)) Furthermore, if you script the table you get FIELDNAME INT DEFAULT ((0)) Is this change intended I couldnt find any references in BOL. ...Show All

• Visual Basic Create Install Project

  Hi all I know how to create a basic Install/Setup Project to create the install exe that will be used to install my program. But i need to run certain code before it runs. The Install file needs to be installed from within another application, i need to run this check, i have the code for this. But where in my install file can i write code that will run before the install file will. I also need to set the installetion directory, normally we just change it in the properties, but i need to change it when my first code runs. So basically i need to know if we can place code in our install file that interacts with the install at install time. Thanks in advance :) :) Regards Louis ...Show All

• Visual Studio Express Editions Parallel Port access... At the end of my rope!

  HEEEEELLLLLLPPPPPP!!!! This is getting silly now. I have tried everything i can find on the net about Parallel port I/O but just cannot get my head around it. All the tutorials and guides are great up to a point but then say "just do this" and it is one or two steps above my level of knowledge. Ive played around with WinIo.dll / .sys etc but just cant get it to work. WinIo keeps giving my loads of errors about default-int, missing ; and syntax errors when i havn't even writting any code - just #include "winio.h"!!! Ive tried using inpout32.dll as well but got no where with that. Please!!! If anyone can point me in the direction of a step by step, beginners / dummy / simpleton's guide to sendi ...Show All

• Visual Studio Team System Unit Tests Timing Out

  I am writing Unit Tests for an ASP.net web site. I have created a table in a seperate database on my PC for Data IN, and I configured the web site (the web site is actually compiled and run on the fly from source by VS) to use a copy of its database also on my PC. Whenever I run tests with a few hundred rows of data I get time outs which in the details say they are waiting for a connection from the pool. So I went into advanced properties and set the Max to 5x the number of rows in my source table with a minimum set 1.3x the number of rows in source. So I am pretty sure its not actually the number of connections. What else should I be checking for Am I forgetting about a setting somewhere This seems like one of the more simple use cases an ...Show All

• Visual Studio Express Editions registration key, invalid e-mail

  hi! I'm trying to get a registration key after I downloaded Microsoft Visual Studio c# Express Edition, and it alway writes when I try to register Invalid e-mail, can someone help me thanks Check this thread, jluca777's solution seem to work for others. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=567005&SiteID=1 Found a solution. Goto profile.microsoft.com, signin and make sure all info is correct especially the email address. When the profile is successfully updated, try registering again. should work. ...Show All

• .NET Development Can you pls Demystify Debug.Assert, Debug.Write and Trace.Assert for me

  1-When I use Debug.write() I see the Output window with tons of code there, how do we take advantage of debug.write, debug.assert and so on with all that code in the Output window at the same time. And in what contest and which development need we need it pls. 2-Also, they say we can use Trace.Assert to halt execution. I put that in my page_Load but the execution didn t halt, it continued, is there any thing else I need to put in my code. Thank you let me ask u about the second case, when we have a problem. that assumes the solution s already been deployed. so do we go and change the code by inserting assert statements in the places that we suspect or we should n t modify code since it s been deployed and all the ...Show All

• Windows Forms Form to form data passage.

  I have two forms. The first form, Form1 has a read only text box on it. The second form, Form2, has a editable text box on it. The user will click a button on Form1 that launches Form2. In Form2, the user will enter some data into the text box. They will then hit the "Apply" button that is on Form2. What I want to do is send the text of the editable text box on Form2 to the read only text box on Form1. I was wondering if there was a way to access the control itself from another form. Meaning: IN FORM2: Form1. textBox1 .Paste(this. textBox1 .Text); Where the text box in blue is the read only text box in Form1, and the green text box is the editable text box in Form2. The second method I was thinking of using was a way for Form1 t ...Show All

• SQL Server The Problem 800a0ea9 absolute recipe what ?

  Windows X64 - IIS6 The Problem 800a0ea9 absolute recipe what conn.asp <% set Bag = Server.CreateObject("adodb.connection") strConn = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=" & Server.MapPath("db/vt.mdb") & ";" bag.open strConn %> ADODB.Connection error '800a0ea9' Provider is not specified and there is no designated default provider. /test/ vt. .asp , line 16 http://blogs.msdn.com/david.wang/archive/2005/09/23/HOWTO_Diagnose_one_cause_of_503_Service_Unavailable_on_IIS6.aspx Changing IIS6 to run W3WP.EXE as 32bit allows the 32bit ISAPI DLLs installed by .NET Framework 1.1 for ASP.NET to load and run inside of it. This is done by r ...Show All

• Visual Studio VS .net crashes when modifying crystal report

  I have an existing application that works. However, I have tried to modify some of the Crystal Report files (.rpt) by adding additional formula fields using the report designer. When I save the report or try to build the project, VS.net 2003 crashes immediately. I get the message to the effect that MS is sorry for the inconvenience, and would I please send them an error report. All to no avail. MS is still sorry the next 50 times it happens, but doesn't offer a solution. I don't know whether the problem is in Crystal Reports or in Visual Studio .net 2003. I think it's a .BUG that needs to be fixed .ASAP. What's happening here Ulrich ...Show All

• SQL Server Conditional SQL Insert Query

  I have a simple ms access table with no primary key. I want to check if the value exists before it exists. I know there is way to do that directly using a insert clause without having a select statement but cannot seem to get it right. Any help would be greatly appreciated. Regards, Vibhu Bansal. Hi there, From experience, you cannot insert WHERE clause into an INSERT statement. Period. I discovered this in the early days when I was just learning SQL and tried using an INSERT statement instead of an UPDATE statement and got an error kicked back at me. I think there is an IF statement for SQL but am not sure - anyone else know Thanks, medicineworker ...Show All

• SQL Server Displaying Details of a group

  I have two groups. I want to do this: Group 1 Group2 Group2 Summary info Group2 Details Group2 Details Group2 Details Group2 Details I don't know how to get the table details row to only show my group 2 details. Thanks Patawa, You can do this by creating a Table that has two groupings for Group1 and Group2. From the layout described, remove the Table Header and the Tables and grouping Footers. For the Group2 summary information, add a second header row to the Group2 grouping and add the appropriate aggregates. Then, you can place the detail fields in the detail section of the Table. Ian ...Show All

• Visual Studio rounding off

  i have a problem with the computations made by crystal reports specifically the rounding of values. what i do is i round the result to 2 decimal places. the problem is that sometimes the values do not match the values that i get when it is computed in the webform (as not all values are stored in the database). what i found out is that vb uses that bankers rule when rounding off while crystal doesnt. that is why sometimes the value in the report is rounded up while in the form, it is not. what can i do to address this issue any help is greatly appreciated. thank you! ...Show All