Helen Drijfhout's Q&A profile

• .NET Development Transaction locking locks whole table!

  moved here from http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=32&SiteID=1 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Hi, I'm having a problem with transaction locking. I need to BeginTransaction, read each line from a file and insert it to a table, then either Rollback or Commit the txn if all the inserts work. This is how I'm declaring the BeginTransaction... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ xConn = New SqlConnection("server=XXX;database=XXX;user id=xxx;password=xxx") xConn.Open() xConn.BeginTransaction(IsolationLevel.ReadCommitted) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Then I read each line from a file, cre ...Show All

• Visual C++ [ATL] does ATL has any collection tool lik CMap in MFC?

  like the title... I thought those containers were merged in VC2005 Anyhow, CMap and the MFC containers are rubbish. The container you want to use is std::map, which, unlike CMap, is part of the C++ language. http://www.sgi.com/tech/stl/Map.html ...Show All

• Visual Basic Cycling through textboxes

  Using Microsoft Visual Basic 2005 Express Edition, I have got a row of textboxes named T1 up to T9, and I am  trying to find a way to cycle through them. So if the starting text box was T1 then the pattern would go T2, T3, T4, T5, T6, T7, T8, T9 and say if T5 was the starting textbox it would go T6, T7, T8, T9, T1, T2, T3, T4. Is this possible With your code what happens if I have lots of textboxes but just want to search nine of them called T1 up to T9. ...Show All

• Visual Basic TEST DLL PROBLEM

  Made Changes to dll and did build. Registered dll with C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\regasm.exe TEST.dll /tlb Why wil regsvr32 not work with this DLL Try to test… create a whole new project solution. Select Project | References | Browse. Select TEST from COM tab. ERROR - test.tbl was exported from a .NET assembly and cannot be added as a reference. What am I doing wrong TEST.DLL <ComClass(True)> <ComVisible(True)> Public Class TEST_MODULE Public Function Process(ByVal Session As Object) As Boolean 'Dim posSession As QSRules.SessionClass ...Show All

• Windows Forms Type.GetType and Colors

  I have a code editor where I use reflection to lookup types descriptions. If I have code like this: Type type = Type.GetType("System.Drawing.Color, System.Drawing"); the variable "type" is null. Does anyone know how to use the Type.GetType function to get the Color's type I cannot simply use Color.GetType() because this is for a generic code editor that does not already have the type definition for all classes in all loaded assemblies. Thanks, Greg The type name is incorrectly set. Try this: Type type = Type .GetType( "System.Drawing.Color" ); ...Show All

• SQL Server UK Datetime parameter problem SQL 2005 RS

  Hi, I am having a problem with the DateTime parameter option in SQL 2005 reporting services. Note that Server, workstation and database are set to British/English (UK) date/time localisation (dd/MM/yyyy) for example 25 th December 2005=25/12/2005. I create a simple query with a parameter on a datetime column and set the report parameter to Data type: DateTime in the report parameters dialog. On preview or after deployment the following behaviour is observed. Selecting 1st February 2006 in the datetime picker control populates the date parameter entry field with 01/02/2006 = 1st February 2006 (the c ...Show All

• Visual Basic Question in VB.NET database programming

  Hi, I need to know couple of questions in database programming with VB.NET which are listed below: How to locate records In Borland Delphi I do something as: Table.Locate('<Which Field to Find', 'Values to find', []<Options>]); and hope something similar would b there in VB.NET I need to create a Lookup Dialog Form. How can it be done in VB.NET to pass values from one form to antoher Looking forward for your replies. Regards, OK - to answer them may require some more infomation from you. 1. To locate records, you can use the a table adapter and provide a SQL select command which will retrieve the ...Show All

• .NET Development Adding a new row to an existing table

  Hi, I am attempting to to add a new row to an existing access database using parameters. Here is my code (i am a bit of a noob so if you've got any suggestions on cleaning up the code please feel free to critisise!!):         private void addData()         {             try             {                 // Build SQL command for all form input fields using parameters              &nbs ...Show All

• Visual Studio Team System Sharepoint Portal server 2003 - Security and access log

  I have questions concerning the security and access log of sharepoint portal server 2003 Q1. I am a portal administrator. I have assigned a user to have the permission on document upload to a document library. Can we disallow this user to delete the files in this document library If yes, how Q2. Is there any access log to keep track and show user who has performed file uploading, file deletion, .... Please help ! Thanks a lot Henrylau Please forward your question to http://www.microsoft.com/technet/community/newsgroups/server/sharepoint.mspx Thanks Bruce ...Show All

• SQL Server launch report builder from C# app

  Hi friends how can i launcg report builder from a C# app i know i can use following url but need to know how to execute that url to bring up the report builder http://<localhost>/reportserver/reportbuilder/reportbuilder.application Thanks for your help finally i found how to do that WebBrowser wb = new WebBrowser(); wb.Navigate(" http://<localhost>/reportserver/reportbuilder/reportbuilder.application "); that works nicely. one more question on this one ,does anybody know how to select report model also by default instead of user choosing after launching report builder ...Show All

• Visual C++ C in Visual Studio

  Hi,  I am a bit of a newbie and I am wondering, if I want to program in C with either Visual Studio 2003 or 2005, can I just open up a new C++ project   Or if not is there some add-in I can use to allow me to develop C programs using Visual Studio   I've tried searching on the web but it always comes back with C++ or C# with visual studio.  If I can't do it in Visual studio (other than using it like a text editor) is there a good C IDE someone can recommend " VC++ doesn't currently support C99, and I'm not certain they ever plan to do so at this point in time" -- not exactly true. We ar ...Show All

• .NET Development Drag and Drop between text boxes

  Hello,   I have a .net application that is generating several text boxes of data. That data lets say is in the form of a column on the right side of the form. On the Left side of the form I have several labeled text boxes in the form of another column.   In some situations there are an equal number of text boxes on both sides of the form. In other situations there could be More on the right side then the left.   The objective here is the user is to pick from the boxes listed and place them in the boxes on the left. This can be done in any order, and any combination.   In some cases there is one box to ...Show All

• .NET Development preventing erasing background

  Hi, I am developing an application using .NET 2.0, in which, when I invalidate client area, I dont want its background to be erased. I couldnt find any overloaded invalidate() method, which allows me to do so. If anybody can help me achieve this, that would be great help. Eager to receive any comments, in this regard. Thanks, Ronak Thanks Michael. Deriving from panel class solved my problem. But it seems that by not having Invalidate(bool) overload, the way it used to be, things are difficult. Its impossible without using one extra indirection (for eg deriving class from Panel), which seems quite strang ...Show All

• .NET Development Programatically embedding resources (a la self-extracting zip archive)

  Hi, first, I'm not sure if this is the most appropriate forum for my question, I did try to consider this but I'm just not sure, so I apologize upfront if it is not. I want to make a program with a feature similar to WinZip's ability to create a self-extracting archive, i.e. I want my program to generate an executable with embedded resources. The executable code in the assembly will always be the same, so I believe this is a matter of embedding resources programmatically. I've figured out that the Assembly Linker offers the functionality I need, but I am a little doutful about whether I can legally distribute this with my program. I'm ...Show All

• Windows Forms Hide certain standard control's properties from designer

  Hi, I created a custom control which inherited from Forms.Button. There's no problems to create & expose custom properties but... I cant find anyway to hide the standard Button's properties... Note that I'm using J# Thanks override the property, apply the Browsable(false) attribute. . . call the base property to access it. this is c#, but the approach should be the same: public partial class MyTextBox : System.Windows.Forms. TextBox { [System.ComponentModel. Browsable ( false )] public override string Text { get { return base .Text; } se ...Show All