Ben Taylor UK's Q&A profile

• SQL Server How to insert a lookup table row aftre lookup fails

  I want to do a a look-up, then if that lookup does not find a record I want to insert a new record into the lookup table, so that effectively the lookup now succeeds. How can I do that I can't figure that one out. TIA So you have you output from the lookup which is the input to the lookup along with a value that was looked up, i.e the lookup value. For rows found in the lookup this column will contain the key and rows not found wi ...Show All

• .NET Development Session timesout prematurely

  I am having an issue with session timing out early. I have sever web sites running on a single server. The timeout is set to 20 minutes but it will time out at different times as short as 20 seconds. What would cause this besides an exception. Is there a threshold for session state in the servers memory Please help!! Your session can restart because of lots of reasons. I believe Every single time the web.config o ...Show All

• .NET Development Data drops when reserializing XSD.exe-generated classes using 2.0 framework.

  I gen my XSD /classes with no reported errors, then deserialize my sample data using XmlSerializer. The data structure looks exactly as expected in the debugger. Then I reserialize with XmlSerializer and, again, no reported errors. The output is valid by the schema. I can reserialize it if I like using the XmlSerializer objects, for example. The output just happens to be missing a bunch of elements (it's a lax schema, minoccurs of everythin ...Show All

• .NET Development Logon, unlock detection

  I'm writing a tray icon program that needs to display a message when the user logs on or unlocks the task manager.  I've been looking for something that might help me in the .NET API.  Does anybody have any ideas or hints I could use. Thanks. JR Hi JR Have a look at the ISensLogon Interface.   (http://msdn.microsoft.com/library/default.asp url=/library/en-us/syncmgr/syncmgr/isenslogon.asp ) A ...Show All

• Visual Studio Extreme slow binary file check-in

  I'm using VSS2005, when I check in a binary file (6MB), it consumed over 5 minutes to check in the file, and VSS Explorer consume 100% cpu usage. However, it only consumed around 1 second when I check in the same file to VSS6. What's wrong with VSS2005 We have discovered a regression in the way VSS2005 checks in certain binary files. The fix wil ...Show All

• .NET Development Schema from COM?

  Is it possible to transform a COM model into a schema via some clever code You can annotate the classes with XmlSerializer attributes and generate the corresponding schema using the xsd.exe tool. For a list of the serialization attributes, see http://msdn2.microsoft.com/en-US/library/83y7df3e(VS.80).aspx Thanks, Priya ...Show All

• Visual C++ Region Resource leaks in C++ MFC project developed using VC7, Dotnet framework 1.1

  I am facing some resource leak problems with my application. During investigation i found that the app was leaking a lot of regions. I was suprised since we did not explicitely use any regions in the app. So just to find out more I built a sample wizard generated VC7 C++ MFC project, Dotnet framework 1.1 on Windows XP After invoking the application, Opening and closing the document window introduces approximately 6 GDI object(Region) leaks ...Show All

• Visual Studio Uninstall Express (release) to install Standard Edition

  Hi there, I apologize in advance that I'm probably asking a question that has already been answered: do I uninstall VB Express and other components before installing VS Standard Thing is, there are about a thousand posts dealing with uninstalling BETA's but I cannot locate the correct procedure for the final release Express edition. Do I uninstall SQL Server Express, VB Express, .Net 2.0 And in what order Or can I simply uninstall VB Ex ...Show All

• Visual Basic serialport control

  Hi, I am developing some software for serial port communication with an embedded devcie and am having problems getting the status of the ring indicator line. Part of my program shows the status of the COM ports lines which i update when receiving the .PinChanged event. The problem is  SerialPinChangedEventArgs only tells you that a change has occured it does not tell you what state the line has changed too. While this is not a pr ...Show All

• .NET Development OleDbCommand.ExecuteNonQuery "Insert Into Select From"

  Hello, I am working with OleDb to perform a bulk insert from a temporary table to permanent database table, both of which belong to the same database. I am wanting to use "INSERT INTO <permanent_table> SELECT * FROM <temp_table>". The query I run in MS Access to perform this bulk load does process correctly, but not in code using OleDb. After properly setting up my OleDbConnection object, opening it, and properly ...Show All

• Visual C# Where the picture that shows all of .NET classes

  Hi, Afew days ago, i saw a picture, which had shown all of .NET classes including 1.1 and 2.0, but now i lost the link of that picture. Does anybody know where that picture it Click ! ...Show All

• Visual C# VS.NET 2005 RC1 -- Is clipboard ring missing from IDE?

  It used to be one of my favorite features! Formerly, from the C# (for example) code editor in the IDE, open the 'Tool Box' tab, and there was a stack of all the things you'd put on the clipboard while editing.  I can't seem to figure out where it went too...hopefully not the bit bucket... TIA, Howard Hoffman I dont think the feature is completely off the IDE. All you need to do is switch back to Code Edito ...Show All

• Software Development for Windows Vista I am using Windows Vista 5270 and...

  I am trying to compile a simple program with VS 2005 professional. I set the option x64. It is compiled. but It can't be excuted... It show this message... Unable to start program 'c:\User\Vista\Document\Visual Studio 2005\Projrct\Test2\x64\debug\Test2.exe It is no problem in Windows XP64... Isn't beta version of the vista support x64      I had used Longhorn on someone's other computer (he ...Show All

• Visual Basic Weeknumber

  How do i get the weeknumber in Visual Basic 2005 Express edition Well that doesn't work for me. There's an interesting article about this here http://www.thecodeproject.com/csharp/GregToISO.asp msg=396665 The code is in C# but shouldn't be too difficult to convert ...Show All

• Windows Forms How to Populate the chunk of data (100 rows) each time to Datagrid when the user scrolls through the list of Millions rows?

  I would like to achieve this with Datagrid. I have a datagrid with a table and set of columns. The dataset I dynamically generate may contain 10000 through 1000000 rows. I wanted to populate 100 rows first, and when the user navigates to 100th row and then goes next record, i wanted to populate or add next 100 rows to the datagrid and so on like this. I also have a scroller. If the user uses to scroller to reach the bottom of the first 100 ro ...Show All