Paul Randal - MSFT's Q&A profile

• Visual Studio Express Editions Problem writing to database

  I have a problem writing data to a database that I hope someone here can help me with. I have a program whose main function is to record daily measurements. The measurements are saved in a database. This piece works just fine. Another piece I am working on is the ability to add new users with passwords etc to the program. When I open the window I can add a new user and then review all users with the new user shown. However, if I close this window - not the whole application - and then reopen the add user window the new user is no longer there. The user's names, passwords etc are saved in a second database. Any help will be greatly appreci ...Show All

• .NET Development New request is not allowed to start because it should come with valid transaction descriptor.

  I have a C# windows service that uses MSMQ, DTC Transactions, SQL server 2005 and Notification services. I am doing the following in the service: OnStart Create the queue set the Peek Complete event call Begin Peek PeekComplete WaitHandle[] waitHandle = new WaitHandle[] { new AutoResetEvent(false) }; ThreadPool.QueueUserWorkItem(ProcessMessage, waitHandle[0]) Call End Peek WaitHandle.WaiteAll(waitHandle) queue.BeginPeek ProcessMessage(object stateInfo) AutoResetEvent are = (AutoResetEvent)stateInfo; Create DTC Transaction try Message msg = callResultQueue.Receive(MessageQueueTransactionType.Automatic); ...Show All

• Visual Studio Express Editions Designer view won't work!

  When I try to switch to designer view I get an error report dialog::: "Microsoft (R) Visual Basic Compiler has encountered a problem and needs to close.  We are sorry for the inconvenience." After the error report dialog, I get a messagebox that says "More data is available" I can still compile projects and they work fine, but I can not view the designer. I have tried reinstalling Vb.net express but the error still occurs. Anyone know how to fix this The program creates no logs. (the program doesn't crash) I can write code and compile, but I can not use the designer... ...Show All

• Visual Studio Tools for Office Can I use outlook 2003 PIAs for Outlook 2000

  Hello I have pretty big solution in C# 2005, which works with Outlook 2003. I have to make it working with Outlook 2000 and Outlook XP. I do not want to build 3 different solutions for each Outlook version. Can I distribute Outlook 2003 PIAs on client machine with Outlook 2000 Will this work correctly I plan to determinate Outlook version in runtime and do not use classes and properties, which are not available on machines with Outlook 2000 or XP. Hi, I don't see why this will not work. We too have a similar solution in mind though we haven't implemented it as of now. Regards, Pavan ...Show All

• Visual Studio Express Editions Download MSDN Express and DX SDK compatibility

  I'd like to know: - It will be downloadable the MSDN Express , I don't want to download it in all computers and everytime that I uninstall the VS Express. - It will be compatible with DX SDK (or XNA) . Thanks. Sorry. I talked about this link : http://www.microsoft.com/downloads/details.aspx FamilyID=b8704100-0127-4d88-9b5d-896b9b388313&DisplayLang=en which is, I think, not the full MSDN distribution... ...Show All

• Windows Forms Update Data With EndEdit and Validate

  Friends, Two questions, hopefully both easily answered. First, here is a small piece of code I pulled from MSDN to add records to a data source from a form. this .Validate(); this .myBindingSource.EndEdit(); this .myTableAdapter.Update( this .fleetDataSet.myTable); First question is: What is the Validate() method supposed to do I can find nothing on this one. Second, what do I need the EndEdit method for The pathetic little description of this method in MSDN library says, "Applies pending changes to the underlying data source". Isn't this actually accomplished by the update() method in the third line My particular ...Show All

• Windows Forms problem with code

  i have a crystal report, and i'm trying to binde it to dataset object, but it's not working. i see no results. if someone can look at the code and find out what is the problem, it will be greate. thank's         Dim S As String         S = "SELECT ItemStyle, ItemShortDescription  FROM InvoiceRow "    & ...Show All

• Windows Forms Where to install winapp-application and sqlexpress

  I have a winform application. It works with a sqlexpress database. When I have a single box there is of cource not a problem. But how to install this for multiuser Usually I installed the application on the clientmachine. The datafiles I copied to the network. Those files could be shared. (I talk about dbf-files). Now I' using sqlexpress. Let's say I have 3 computers connected in a local network. One of them is the server. Do I install sqlexpress only on the server computer I guess so. And the winapp Do I install the winapp on both client systems (included the .net frameform) thanks Klaas Netherlands Sorr ...Show All

• Visual Studio Tools for Office Outlook PST file extraction

  Does anyone know how to open outlook pst files and extract the contents to another format.  For example, a database. I need to periodically receive pst files, extract the contents from them and store them in a database. Outlook automation is not the best option because it prompts you to allow anonymous access before letting you process and email.  I would like no use interaction if possible. Hi The automation is the best way at present, what is the email source is this exchange If so you could look at using CDO and or if you need to extract, you can use MSACCESS and import the data from clicking Imp ...Show All

• Windows Forms Sockets and SQL

  I am trying to write a class using the Sockets Class. I would like this class to check for new entries in a SQL database. If there is a new entry in the database, I would like a message box to pop up stating so. Does anyone have any examples that can help me out I am doing this in VB, but if your examples are in C#, I'll& ...Show All

• Visual Basic Uninstall file

  Hi, Can someone tell me where to find the uninstall file for any given program Where is it normally located Or else, if it has to be created, then how can I go about doing that Thanks a lot. The uninstall file's name isn't standard for all programs, it's usually Uninstall.exe , if you are sure what is its name use this code : Private Function UninstallFilePath( ByVal ProgramPath As String ) As String UninstallFilePath = ProgramPath.Substring( 0 , ProgramPath.LastIndexOf( "\" )) & "\Uninstall.exe" 'To run this file call Process.Start(UninstallFilePath) End Function ...Show All

• Windows Forms Date Time Picker

  Hi, Anyone know how to format the Date Time Picker in C# to shows MONTHS only Hi, Sorry, please allow me to ask more, can you guide me more details on how to traverse the list view items and create the loop Thanks. ...Show All

• Windows Forms WinForms with Large Datasets

  Hi Experts, I'm looking for some good, simple books on 'best practices' use for creating WinForms Apps to maintain data whilst maintaining concurrency with other users... To explain, I come from an Access background and I think I'm having to work too hard to get and keep data concurrent, though I think know the ADO.NET building blocks alright. Unfortunately, I'm still on .NET 1.1 and will be in the foreseeable future, so any material out there for the 'real-world' data-centric apps builders, please let me know... Book recommendations are welcome Ta James PS I have seen all Practices & Patterns, it's a bit dauntingly ...Show All

• Visual Studio 2008 (Pre-release) IRequestChannel or custom ChannelFactory?

  Hi, Some context first: I'm in the process of upgrading an existing framework to WCF. This framework is being used in 500 enterprise applications. From the client side, this framwork receives a Sw.Request message. This base message will contains the Action. You can also create a typed message deriving from this class. One of the requirements is continue to use this message infrastructure. What I need to do.. So now I need to replace that framework with WCF. I started from the client side because the service side won't be the problem. There is no notion of a typed proxy with operations in the client because everything tr ...Show All

• SQL Server Filter Records returned on report builder based on User LogOn

  Dear Anyone, Is there a way to filter the records returned by a report model in report builder depending on the actual user that is logged on the report If so, how do we go about this Thanks, Joseph This has been vexing me as well for quite some time as well. At times, it seems like I'm getting real close to an answer just to get shot down by restrictions on what entities are available when inside the Expression Editor. In my case, all data goes through our web services and users have no direct access to the database, so that leaves making filtered views out of the question. ...Show All