WalangAlam's Q&A profile

• SQL Server @@IDENTITY in code

  Hi all, I encountered a problem with SQL server mobile. I am inserting a row inside a database table through C# code and need to obtain the ID of the last inserted row if successful. I have the following in my code: SqlCeHelper.ExecuteNonQuery(connectionString, "*INSERT STATEMENT*"); Int64 id = (Int64)SqlCeHelper.ExecuteScalar(connectionString, "SELECT @@IDENTITY"); The variable id always ends up NULL. Is this the correct approach to this Is there anything else I can use to obtain the id of the last inserted row in SQL server mobile -- The class SqlCeHelper is a wrapper that I wrote, it works 100%. Thanks Hi, No...unfortunately SQL mobile doesn't support the function. I though of the two ...Show All

• .NET Development Detecting remove lock event on file

  I have the following problem: We have to write an application that acts on changes on files. For example editing a word - file. We achieve this using the FileSystemWatcher from .NET 2.0.  When the word-file is saved the events correctly trigger, but the files are locked, which causes our action to fail, but this is not the problem. But when the user closes the word-application. The application release the lock,but  we can't seem to catch this event so we could run our actions then.   Does anybody has as solution Thx, gert So if there is no explicit windows way to detect a lock, we are back to an old-school trial and error approach to find out whether there is a lock ...Show All

• Smart Device Development No modules loaded for debugging-PDB files cannot be found.PLease Help

  Hi, I'm developing a app through vb.2005 using compact framework2.0. But when I run the application it doesnt let me do any debugging. After hours of research I found out that the pdb files dont get loaded..On the modules window it says: mscorlib.dll mscorlib.dll N/A N/A Cannot find or open the PDB file. 1 5/9/2006 12:59 PM 4FA00000-4FADE1C8 [8e2939e6] Warehouse (PPC).exe: Managed Warehouse (PPC).exe c:\localsymbols\Warehouse (PPC).exe N/A N/A Symbols loaded. c:\localsymbols\Warehouse (PPC).pdb 2 2/1/2007 5:11 PM 4FB00000-4FB11A00 [8e2939e6] Warehouse (PPC).exe: Managed System.Windows.Forms.dll System.Windows.Forms.dll N/A N/A Cannot find or open the PDB file. 3 5/9/2006 12:59 PM 4FC00000-4FC ...Show All

• Smart Device Development Remove underline of LinkLabel

  Hi all Is There a way to remove the underline of LinkLabel control on Compact Framework 2.0 (Smartphone) I need to create more buttons on screen but this links can't be with underline and, when I click on one of this buttons, preserve the color. Regards Mauricio HI Dan Thanks for your help. I don't see this option when I was built my Form But, I have another question. I am panting a JPG file on Form backgroung using OnPaint form event. How can I set, on the LinkLabel, the background color to be transparent Regards Mauricio ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. myFirstGame sprite flicker - anyone else?

  i completed the first tutorial to make a sprite bounce around the screen. My sprite is 2kb at 87x61 pixels. Tutorial said to use a small sprite ... maybe that's a relative term, but i'd call that small. When my sprite moves around the screen, it looks like my computer is thinking really hard about redrawing it. i get a very noticeable flicker as it cruises around. Does anyone else have this problem i don't know what specs to feed you ... i'm running a dual-core system w/ 2GB RAM and a ATI X1300 vid card that has 256MB memory. i didn't think pushing a 2k image would bring it to its knees ( ) - MrSock I am seeing the same flicker during the SpaceWars program as well as the MyFirstXNAGame program. ...Show All

• Windows Forms Drawing parts of an Image

  Hi - quick question. I need to use DrawImage/DrawImageUnscaled to draw certain source areas from a certain Bitmap, using a Graphics object, many times. I've tried many variations of the call and they all are very slow... 30~50 iterations takes almost a second. There's nothing I can do about the size of my image file either, unforunately. Making it a small-size PNG doesn't help at all. Also, I really want to avoid using DirectX here for the reasons of simplicity, load-up speed, and also the fancy advanced features like gradient brushes, etc. that I really need. So, to my actual question - is there any other way to greatly improve my speed without using another technology than GDI+ Thanks in advance... P.S. I should add that I can't reall ...Show All

• Windows Forms Invoke a controls property

  I’m struggling with a thread that should update a TreeView. I’ve started to use the Control.Invoke method when for e.g. adding nodes and so on. I now wonder how I “Invoke” a property. (I got the “Cross-thread exeption…” when I try to set the TreeView.ImageIndex property) take a look at this: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=564275&SiteID=1 ...Show All

• Visual Studio Express Editions Check Database for category name

  I am trying to figure out how I can make an if then that will check to see what the name of the category is inside my database. if categoryname = "cat name1" Then something will happen End IF dustinto, According to you question, I suggest you to use the PerformanceCounterCategory class in System.Diagnostics namespace. There is a property called PerformanceCounterCategory.CategoryName Property that gets or sets the name of the performance object that defines this category. The following code example creates a PerformanceCounterCategory with the PerformanceCounterCategory. It prompts the user for the PerformanceCounterCategory and computer names, then sets the CategoryName and MachineName properties from the entered val ...Show All

• Windows Forms Appending Rows to Datagrid

  Hai i want to append rows to datagrid. I am using dataset as the datasource of datagrid. But when i set the datasource as dataset ..only the new rows are displayed ..existing rows are removed I want to see the added rows plus the new rows ..how is it possible Thanks Ratheesh how are you adding the new rows in the dataset usually you would do this: object[] theNewRows = new object[] { " field1Value" , " Field2Value " }; theDataSet.Tables[0].Rows.Add(theNewRows); this.theDataGrid.DataSource = theDataSet.Tables[0].DefaultView; does this not work for you ...Show All

• Visual Studio Team System Get latest version vs get specific version

  Im getting some feedback from users who have complained that they are not seeing the latest version of source files or in some cases if a person has created a new file and checked it in to source control it cannot be seen unless a Get Specific Version (force get) is issued. Im just wondering if this is how Get latest version and Get specific version are supposed to work and how should users approach bringing down files especially when they start their day in a shared environement. Thanks Aaron I have to say that it's very scary that this basic functionality is missing!! We have ALOT of weird things happen with this product constantly. To not have new files added visible to others is disturbing to sa ...Show All

• SQL Server How can I catch all errors of the stored at the same time?

  I have a stored prcedure . In the stored I wrote 3 SQL statements, one is OK but 2 other statements have error as: 1. Invalid column name 'F2' 2. Invalid object name '##_152008049' . I put the stored inside try block and catch error in catch block as the following. But I always catch only the first error : invalid column name F2 . How about the second statement How can I catch all the errors when I put the stored in try block. Now I don't want to add try..catch inside the store for each statement. Begin try exec mystored End try begin catch ERROR_NUMBER () AS ErrorNumber , ERROR_SEVERITY () AS ErrorSeverity , ERROR_STATE () as ErrorState , ERROR_PROCEDURE () as ErrorProcedure ...Show All

• Windows Search Technologies Add-in for UNC/FAT for Win 2003 Server x64

  Does anyone know if there is a Win 2K3 x64 version of " Add-in for UNC/FAT " for WDS 3 or when will it be released I have lot of data on our network drives that I need to index. I use to be able to do that with WDS 2.x on my x32 Win 2K server. But not since I upgraded to new x64 machine. I really miss this feature. Thank you in advance for your help. hsshah Same Issue will install but the UNC tab does not show up in the advanced menu for the desktop search options. Using corporate my document redirection does not work with 3.0 since it is a UNC path where the default is to only index the documents and settings folder and emails from email client app. any update on the eta for the x64 re ...Show All

• .NET Development how to clear cache in System.Net.Webclient

  I use an Webclient to connect and check for update software: Dim client As New System.Net.WebClient updateVer = client.DownloadString("http://www.mydomain.com/update.txt") First time it work ok ! then went i change update.txt and run it again it always download old string. How do i clear catch and download new string in update.txt Thanks for all but i use it in VB.NET not webproject. And i saw in some threads that code: client.CachePolicy = New System.Net.Cache.RequestCachePolicy(System.Net.Cache.RequestCacheLevel.NoCacheNoStore) It Okie for me. ...Show All

• Windows Forms Drag Drop Outlook MailItem onto Form?

  I see that this question has come up a couple of times on the web since 2003, and there still seems to be no answer available yet.  Any help or direction please The question: How do you drag an drop an Outlook MailItem onto a form control so that you can store the object as an '*.msg' file   I got to the point where I actually want to know how do you get the MailItem object from the DragEventArgs object  on .Net 2.0   Below are some sample code. Is this a bug or just behaviour that is not yet implemented Code snippit: void textBoxLink_DragDrop( object sender, DragEventArgs e) {     s tring [] fileNames = new string [5];    // the first step here is to get the ...Show All

• .NET Development Visual Studio 2003.net Databases Connection not working

  I am using Visual Studio 2003.net and trying to get connected to SQL 2005. Is this even possible to do and if not what is the best way to connect to a database with Visual Basic 2003.net. Before I was able to make a connection with VB 2005 express edition and SQL 2005 express edition but this is seeming to be a “no way hosa” kind of thing. . You may be using Visual Studio Standard Edition. If this is the case I believe Visual Studio Standard Edition database tools will only work with Access and MSDE. If you try to connect Visual Studio Standard Edition Database tools to SQL 2005 or SQL 2005 Express edition it will display an error message stating that: It is only possible to connect to SQL Server Desk ...Show All