hello frns's Q&A profile

• .NET Development The identity field problem on ADO .NET 2.0

  After a lot of search on internet, coding, testing and trying new code I concluded that ADO .NET 2.0 despite the very good features like tableadapters has the lack of a very very important feature that ADO .NET 1.0 had. This feature is the automatic updating of the identity field of a table when inserting or updating a record. On ADO .NET 1.0 in case of using an Access database you could achieve this using the event OnRowUpdated of DataAdapte ...Show All

• SQL Server AspNetSessionExpiredException error handling

  I have a custom reporting application that displays Sql Server Reporting Services reports on an ASP.NET page using Microsoft's report viewer control. The SSRS reports are local reports (they have an rdlc extension). When a report is left inactive for a lengthy period of time it generates an AspNetSessionExpiredException when the user attempts to move to a new page. The thing that is surprising is that the formatted exception display is con ...Show All

• Visual Studio Express Editions Searching a data base in visual basic 2005

  l need to be able to search for a word or part of a word. as well l need help to code a button to add a record to the data base as well one to delete and one to save. Anyone able to help me with this. it would be most helpful. To search for part of a word use a LIKE clause in your SQL. Have you tried msdn.microsoft.com Sites like www.codeproject.com also have lots of articles on this sort of commonly asked stuff ...Show All

• .NET Development Using DataReaders

  Im currently trying to retrieve info from the database so that i can eidt it. I have declared my reader as follows: Dim objReader As OleDbDataReader = objSelectCusDetails.ExecuteReader However when it compiles, it doesnt come up with any errors but jsut as the form is about to load, theres an unhandled exception at the line in blue above. anyone see why this is the case You are ...Show All

• Visual C++ why can't find the .h file!

  I begin a Blank solution that named AllInOne.ADD a C++ Win32 project named Math Library and change the Application Settings to a static library. Next,Select a C++ Win32 Console application and name it Harness. MathLibrary project in Solution Explorer add a Generic C++ Class that named Arithmetic. In Solution Explorer, right-click the Harness project and choose Properties. Under Configuration Properties on the left, expand t ...Show All

• Visual Studio 2008 (Pre-release) Export Canvas Contents to Office Applications?

  Hi. Part of our WPF application draws trees on a Canvas, and we'd like to be able to export those drawings for use in Word, PowerPoint, etc. Is there a way to export the contents of the Canvas to the clipboard, preferably as some sort of nicely rescalable format (e.g., not BMP) Thanks. Dave I asked this some time ago. The only answer from MS is that they are not doing anything to enable this. The office product team ap ...Show All

• Visual Studio Exception "miracles" in IDE

  Hi.. Somehow I feel that I'll still have to struggle a lot before fully understanding exception mechanisms in .NET For now I just have one appeal to help me understand the following: When this app is run from the IDE and FIRST button is clicked, why IDE jumps to completely irrelevant line number (case clause for the SECOND button!) the code: www.david13.com/temp/exceptions_demo.zip This code is actually from here: http://msdn.microsoft.com/msdnm ...Show All

• Visual Studio 2008 (Pre-release) WPF Feb CTP 2006, XAML Designer not available in VS 2005

  Hi, I installed the WPF Feb CTP 2006 version. Apart from the namespace bugs, i have run into a peculiar problem where the xaml designer is not shown in the VS 2005. Is this by design or is it a bug Any help in this regard would be highly appreciated. Thanks & Regards Susheil Kumar System Analyst You should give Microsoft Expression Interactive Designer a shot - http://www.microsoft.com/expression T ...Show All

• Visual Basic 2005 .Net Nightmare

  As a visB programmer who has been happily coding very successful applications for many years, I have been shocked at the verbose incomprehensibility of the .net framework. Where is the wonderful Basic language that has served so well for so long Is there a way to disable all the garbage in VisB 2005 in order to just write simple single thread applications in the Visual Basic language I have been unable to get even the simplest microsoft SDK exa ...Show All

• Windows Forms Delete Key DataGrid

  I'd like for users to be able to select a row in a datagrid and press the delete key on the keyboard and have the row deleted. I've got the code written to detect what row they're on and update the dataSet... but I don't know how to handle it when they click the delete key Thanks D-Man. That code works some of the time. When I highlight a row in the datagrid, and then press the delete key, the event isn't captured. Seems like I need to ov ...Show All

• Visual Studio Tools for Office InfoPath Regular expression and white space

  Hi, If I create a simple form with a textbox bound to to a simple text element and put the following Datavalidation 'matches pattern' [1-9][0-9]{3}\s [a-zA-Z]{2} why is the following input wrong 1000 AA 1234 GZ 9099 ZZ I expect 4 digits, whitepace, two letters I'm out of any clues. Tnx Rene Rene, I wonder if the problem could be as simple as changing the rule to "does not match ...Show All

• SQL Server Problem adding new Database in Smart application

  When I try to add new sql ce database to smart solution in vs2005 I have the following msgbox cannot obtain provider factory for data provider named 'microsoft.sqlserverce.client' what can be %SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config Open this file in NOTEPAD, and search for "SQL Server CE Data Provider".  If it is not there then, you may try adding the following line AS IT IS in Data Provide ...Show All

• SQL Server Delete subreport at runtime?

  Is it possible to delete a subreport from a main form at run time I am trying to find a work around for the inability to conditionaly format a page break. I have a main form that has 10 subforms. Some of the subforms won't have any data (depending on the parameter values). When I export the main form to excel each subform needs to be in it's own excel tab. Obviously, I don't want a tab if there is no data. Any suggestions ...Show All

• SQL Server 'Incorrect Syntax near' Error in Create Type in 2005

  This is getting really frustrating. I've searched and tried about everything I can think of. I have an assembly added to my database by using Sql Management Console. The assembly is called TestUDT. I have defined 4 structs within that assembly, Person, Transaction, Payment, and Seller. The assembly was added to SqlServer 2005 with dbo as the owner, the permission set is SAFE, and the assembly is signed. The structs are within the Test ...Show All

• SQL Server What accounts for this performance difference?

  As mentioned in a previous thread, I've got a single Transaction Scope style transaction surrounding a number of DDL style changes. This usually takes ~1.5 hours to complete. What I noticed is the same sort of query starts to take longer the closer to the end it is. I.e. Create Table after the first 1 min takes 150ms, after an 1 hr it takes 2 secs. Is this a problem with SQL Transaction handling or DTC To prove the point I set my root transactio ...Show All