MylesR's Q&A profile

• SQL Server Pros and cons with table lock

  I use an ole db destination which I simply use to insert data into database. If it's configured to use Fast Load as access mode, then it is possible to switch on/off the Lock table  property, which is set to true as default. Are there any drawbacks with switching off the Lock table property What do I gain when using it Thanks for your help! Its a performance issue. Having a table lock means that the load process doesn't have to worry about lower level locks, and so the load should be quicker. But it does mean no one else can use that table ...Show All

• Visual Basic How to draw a line on an image in a picture box?

  I want to draw a line on an image in a picture box. How do I do The picture box is placed as the only item in a standard form. The following doesn't work: Private Sub PictureBox1_Paint( ByVal sender As Object , ByVal e As System.Windows.Forms.PaintEventArgs) Handles PictureBox1.Paint Dim TestLine As System.Drawing.Graphics TestLine = PictureBox1.CreateGraphics Dim TestPen As New System.Drawing.Pen(System.Drawing.Color.Red) TestLine.DrawLine(TestPen, 10, 10, 50, 50) TestPen.Dispose() End Sub The corresponding method for the paint event works fine in a panel, but the picture box doesn't seem to support it. What am I ...Show All

• Visual C# Aligning in RichTextBox

  I have a richTextBox in my form and I append some text into it. richTextBoxPrintCtrl1.AppendText(rtbVerse.Text + "\n\n");   How can I make that text centered Hi - To center the text, you can use the Selection Alignment property. richTextBoxPrintCtrl1.SelectionAlignment = HorizontalAlignment .Center; HTH, Karen ...Show All

• Visual Studio Uninstalling VS 2005 RC1

  I have an issue with uninstalling SQL Express Edition CPT as part of uninstalling VS 2005 RC1. I have used both the Add/Remove programs and the vs_uninst.exe tool. In each case, I am leaving some residue of the program which triggers an error which does not allow VS 2005 install to configure SQL Express Edition. Any ideas Thanks. Just the framework. Its under \wcu\dotnetframework on your RC media. ...Show All

• SQL Server Non-logged insert... select

  Hi, Is there any way in either sql2k or 2005 to do an "insert ... select" without writing to the tran log, similar to a non-logged bcp from a flat file It seems crazy that I should have to go outside the engine and back in again just to avoid this logging. Or am I mistaken, and this is already what happens when you do an insert... select when the db is in bulk logged or simple mode Thanks! Mike Hey Mike. You can make use of the 'select...into' statement to perform this type of operation in bulk, of course that means the target table can't already exist. There is no way to perform an 'ins ...Show All

• Windows Forms Serialization between different apps

  i want the data that i save from application1 to be used from application2 as far as i know serialization is the way to go and it worked excellently saving and loading inside the first application, but now i cant load the data into a second program. this is the saving code: ===============================================       If SaveFileDialog.ShowDialog() = Di ...Show All

• Visual C# SQL Date Format

  Hi, How do I get the SQL Server Date format from my Application And is there a way to ignore it I'm already converting to datetime but it depending on the server asks for mm/dd/aaaa or dd/mm/aaaa   Thanks the format "dd mmm yyyy" works as well. (but parameterised queries are definately the way to go) ...Show All

• Visual Basic System.DllNotFound Exception

  I'm migrating from VB 6.0 to VB.NET 2003. There is a particular file abc.dll that I'm not able to add reference to, though its a dll file. When I try to reference it, the error is 'This is a not a valid assembly or COM component. Only assemblies with extension 'dll' and COM components can be referenced. Please make sure the file is accesible, and that it is a valid assembly or COM component' How can I reference this file If this is not being seen as a COM component you likely need to do a P/Invoke against it. In your old VB6 project, did you have a few ‘define function’ statements that reference ...Show All

• .NET Development SqlConnection and thread safety

  I believe I know the answer to this, but I would like confirmation. I have been experiencing NullReferenceExceptions being thrown from a call to ExecuteScalar(). The occurence is intermittent, but only happens when two separate threads try to use the same pooled SqlConnection on synchronous schedule (i.e. every 5 seconds). I surmise that the cause of the NullReferenceException is a conflict between the two threads trying to simultaneously access the same SqlConnection object. I deduce from this that all calls to a pooled SqlConnection must be sychronized. This is not obvious from the ADO.NET documentation. ExecuteScalar() has no ref ...Show All

• Visual Basic running VB standalone in VS/TE 2005 beta2?

  Is there some way I can just run the most recent version of VB with VS2005   It seems to be making me have to install the entire team editon frameworks, SS2005, etc....and I just want to use the newest version of VB.  Isn't there a standalone install for VB with VS2005 like VS/Pro in previous releases There is the "VB Express" edition that you can download from: http://lab.msdn.microsoft.com/vs2005/ This Express edition is quite functional/powerful.  It is not the "full" set of features that comes with the VS Team edition but it may be what you are looking for.   You can read more a ...Show All

• Visual Studio Express Editions PLz tell me how to use Split function method in VB.net

  Hi there friends i am having problem in spliting a string by the built in Split method in vb.net plz guide me and tell me the method how to use this function Thankyou plz tell me as fast as u can bye Here is a very simple example: Dim sourceString As String = "This is a string I wish to split into words" Dim arrayOfStrings() As String = sourceString.Split( " " ) Alternatively look in the help: Make sure the help is on the Index Tab Make sure your help is filtered by Visual Basic (top part of the index tab) Type String.Split in the 'Look for' textbox Click on the String.Split method in the ...Show All

• SQL Server Setup failed - no package <sqlncli.msi>

  I tried to install a sql 2005 desktop engine. This fails with the error: An installaton package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package ‘sqlncli.msi’   I used a fresh, new download SQLEXPR.EXE. What shall I do   I have the solution. If someone is interested:   First I extracted the files in a separate directory: SQLEXPR.EXE" /x:c:\sqlexprtmp Then I searched and executed “sqlncli.msi” I clicked on “uninstall”. After this I rebooted the ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. About DX 10 ...

  ... I don't know where to post this: there will be a managed version of it I'm pleased to announce that the DirectX 10 discussion that was part of the overall DirectX presentations at PDC 2005 are now available for viewing through the DirectX Developer Center (http://msdn.com/directx) ...Show All

• Visual C++ MS C++ 2005 express database mismatch error when compiling

  Every time that I attempt to compile a c++ program I get a database mismatch error. When I looked this error up in the included documents, it said that I needed a newer version of dbi.dll. Where can I find this file I know that my programs work because they compile with ms vc++ 6.0 and the gcc complier. Here is the artilce where it told me "how to fix it," but I still cannot find the file that I need. Visual C++ Concepts: Building a C/C++ Program   Fatal Error C1902 program database manager mismatch; please check your installation A program database file (.pdb) was created usin ...Show All

• Smart Device Development Controlling D-Pad in the Today Screen (C#)

  hello, i'm very new to c++, but i'm getting there. i just need keywords as to where or for what i should be looking to make a program that would produce a mouseclick when the left button of the d-pad is clicked when i'm in the today screen. my device doesn't utilize the d-pad's right and left buttons when i'm in the today screen, so i thought that i could assign the left d-pad button to a mouseclick that would click on the start button. i'm using Visual Studio 2005 with Windows Mobile 5.0 SDK. thanks, msafi,  There's no need to refer to people as idiots; I'm sure that you make mistakes as well. Believe i ...Show All