Paul Yau's Q&A profile

• Microsoft ISV Community Center Forums Data access layer generating software approach

    Hi Everybody, I am evaluating on various optimistic locking mechanisms for implementation in a Data access layer code generating software. First Approach : All column based locking .I see following demerits: 1.Can't compare CLOB and BLOB columns 2. Every column of the database entity(table) should have a value set.Means we should have values of all column before update or delete regardless of we need to update one column or more. 3.We have to preserve the old values so extra memory overhead. Second Approach: Timestamp column based locking : I see following demerits: 1.If we go for timestamp based locking ,then we have to create an extra column or an extra table for timestamp of all tables..I th ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. What is the best way to distribute components?

  What is the best way to distribute our Components Should we just throw the source files in a zip folder and sent them out or is there a better way That doesn't sound so bad - but do I get to choose where they go I don't mind for @finsihed@ components, but for stuff still being developed, I'd rather know where it is :) That said, it was more games and stuff I was bothered about - it's nice to see what other people are doing with XNA, but I don't really need a start menu entry, and a folder in Program Files. The build folder zipped up is more convenient (especially at work!), as it can be unzipped, played with, and deleted very easily (which is what I usually do with the little Pong clones being posted ;)) ...Show All

• Visual C# BeginInvoke and resource leaks

  From Jeffrey Richter's "CLR via C#": "You must call Endxxx or you will leak resources. CLR allocates some internal resources when you initiate asynchronous operation. If Endxxx is never called, these resources will be reclaimed only when the process terminates." This is written about functions like BeginRead and EndRead. Is this correct also for delegates For example: public delegate void SomeDelegate; ... SomeDelegate someDelegate; ... someDelegate += subscription; ... someDelegate->BeginInvoke(); If I never call someDelegate->EndInvoke, does this create resource leak, as written in the book According to Richter, the only Beginxxx function which doesn't require Endxxx is Control.BeginInvoke. I can use Control.BeginInvoke ...Show All

• Visual Studio Express Editions Help Needed

  Hi folks, I need to locate a tutorial for a craps dice game for learning purposes can someone help with a link or something any other information will be helpful. Thank you for your support.   DKB Spotty I originally asked for a tutorial I understand now that I should have worded my original request better and thanks for the help to understand how to communicate in these forums better.   DKB ...Show All

• Visual Basic Opening csv files through web

  Hi, I'm using the following code to open a csv (comma separated values) file over the web. The problem is, when Excel opens the file, it puts each line in the first cell of each row, completely ignoring the commas. I tried using other content types, but they all do the same thing. Any help would be great. Thanks. <% Response.buffer = TRUE Response.ContentType = "application/x-msexcel" Dim vntStream Set oMyObject = Server.CreateObject("MyObject.BinRead") vntStream = oMyObject.readBinFile("c:\temp\tempcsv.csv") Response.BinaryWrite(vntStream) Set oMyObject = Nothing Response.End %> Function readBinFile(ByVal bfilename As String) Set oFSO = CreateObject("Scripting.FileSystemObject") ...Show All

• Visual Studio Express Editions Web Browser Pop-ups

  Hi all, why WebBrowser blocks pop ups and how do i prevent it prevent it I have a web Browser which i am making for a company and they have a special popup to record the sites each user is going on. They use IE right now and my software is meant to replace it without blocking the popup. How do i do that The popup might be javascript or php or any other codes... Plz Help! the WebBrowser control uses the IE engine as the core engine. The way you could prevent the popups is to configure the popups in the Internet Explorer options. Any settings set there applies to the WebBrowser control also since it uses IE's engine I believe ...Show All

• SQL Server WHERE clause does not work. Why?

  I am asking for help to resolve this simple problem. It is a stored procedure. It is supposed to return a single row from a table. The table may have max 300 rows but now there is only one row in it. When I execute the query in SQLEXPRESS in the New Query Editor Window with the correct parameter it returns empty row . set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[CentrCtrl_SelectStats] @symbol varchar (10) = 0 AS BEGIN SET NOCOUNT ON; SELECT * FROM dbo.CenC_stocksStats WHERE symbol = '@symbol' END Now, I varied this simple statement this way and that way. I changed it into SELECT * FROM dbo.CenC_stocksStats WHERE symbol = @symbol with the same negative result: empty rowset . If I remove the WHERE clause ...Show All

• Visual Basic Using Folder Browsing Control in ASP.NET

  Hello everybody I have made a User Control in VB.NET 2005 that displays folder browsing control when clicked on button i want to use control in my ASP.NET page as we use activeX control previousl. Is anybody can help Gaurav... Could I suggest that you ask the question on the ASP.NET forums Forums.asp.net these are dedicated to ASP.NET questions and your more likely to get a pertinent answer to Web applications quickly from those folks. ...Show All

• Visual FoxPro using INPUTBOX()

  hi guys...is there a way wherein i can make the text in the input box to be hidden like in password i need it asap..thanks I think he meant show what the user types in the textbox as asterisks just like a password entry. I don't think that's possible with the INPUTBOX() function, you could create your own form to simulate this though. ...Show All

• SQL Server Feedback on Microsoft Connect Site

  I don't know how many folks here log into the Microsoft Connect site occasionally to check suggestions and bugs submitted to Microsoft for SQL Server and SSIS (still called DTS on their list). A small pecentage Almost everyone  (Possibly in this group.) Anyone can vote for feedback they think is important. Theoretically issues with the most votes will get Microsoft's attention first.   Links to a couple new submissions that look interesting:   1. SSMS/QA Style Message Logging for SSIS Execute SQL Tasks 2. ForEach SMO Enumerator Filtering   I vetted these issues in the forum first, so hopefully they're legitimate enough to warrant some useful feedback or even a few high ...Show All

• Visual Studio Express Editions Form Size. Preventing re-sizing on Form blue bar double click

  Hi, How can I prevent a form re-sizing if the forms blue bar is double clicked ron Hi, Does the above code work for you I have used it but fails to resolve the issue. Option Srtrict on disallowsimplicit conversions from'System.Drawing.point' to 'System.Drawing.size so above code now: Me .MinimumSize = CType ( New Point( My .Computer.Screen.WorkingArea.Width, My .Computer.Screen.WorkingArea.Height), Drawing.Size) Ron ...Show All

• SQL Server SQL Table valued function as Partition Data source. How?

  Hi, How can I use table valued function as data source for a partition Is it possible Thanks a lot Deepak! Your answer was on time. ...Show All

• Visual Basic ADO.net dataadapter.fill

  Hi, I have two tables in my database: tb1 and tb2. tb1 will be inserted into tb2 with these conditions: 1.) if primary key to be inserted is already existing in tb2, then the data in tb2 will just be updated using values of tb1 2.) if primary key to be inserted is not yet existing in tb2, a new recorded will be created in tb2. I used a dataadapter to fill the datatable and a bindingsource. Also, I used execute non-query command to insert/update the data in tb2. everytime i update/insert a record in the database, my datatable still contains old table records (it doesn't have the data i inserted and contains old data before updated). in this case, i have to issue another da.fill(mydatatable) to refresh.... which is so slow espe ...Show All

• Visual Studio Visual Studio Pro Trial Installs with Warnings

  I finally achieved a successful download using DownloadManager and a successful DVD burn using DeepBurner. At least I think so... is there a verification checksum available for the download MD5 or a CCITT-CRC32 Well, assuming the DVD burn is correct, the installation seemed to succeed, but with warnings. I have tried to uninstall and reinstall several times. Each time I uninstalled everything and restarted my computer. I disabled Norton Internet Security each time. My OS is XP Pro SP2. I have previously installed VS 2003 Pro, and VS 2005 Express with no problems. I have already ordered the trial DVD and submitted a purchase request, but I need to continue work to avoid falling behind on my project. Please help! terr ...Show All

• Visual Studio Express Editions Yeah another hotfix!!

  So I've run into my 3rd bug that requires a hotfix and yet again I have no way to get it. The support site doesn't list Visual Basic Express in the products so it won't let me contact support. I'm running into this bug http://support.microsoft.com/kb/915038/ . It says there is a hotfix, but as usual, Microsoft won't actually provide a way to download it. I'm hoping somebody here can help so that I don't have to pay to contact support about a known bug. Maybe someday Microsoft will just post the hotfix rather than have me jump through a bunch of hoops. you would have to phone the PSS - Product Support Services to request for the hotfix. If you can reproduce the problem, they won't charge you for the ...Show All