AndrewvanZyl's Q&A profile

• SQL Server Problem with slowly delete many filtered rows in table.

  I use cursor for delete 20 milions rows from one table, but it's very slowly. I want use delete rows in a non-resource consuming manner. I don't need from transaction log, but don't know how turn off it. Please help me! 10x Hi, maybe I am wrong but do you this this could work Delete MyTable where exists (select * from OtherTable where OtherTable.MyTable_ID = MyTable.ID) ...Show All

• Visual C# wanting to right click within FileListBox and change Form title text to selected file.

  how do I access the title bar of the frmTest below thx. -greg namespace TestExplorer { public class frmTest : System.Windows.Forms. Form private void fileListBox1_MouseClick( object sender, MouseEventArgs e) { frmTest . = this .fileListBox1.SelectedItem.ToString; } The Text property gives you access to the window caption on a Windows form. ...Show All

• .NET Development What Privilege Do I Need for Low-Priv Server to Listen on Port?

  I am trying to follow Keith Brown's recommendations in his book "The .NET Devloper's Guide to Security". I have created a server app using HttpListener. The server app runs fine when logged in as Administrator, but when I created a user account and assigned to the Users Group I get an "Access Denied" on the listener.Start() method. I am not sure how to determine what level of security I need to perform this operation. Thanks M.D.A Microsoft's repsonse from the newsgroups regarding this issue: As for the HttpListener's permission issue you mentioned, based on my research, it is caused by the URLACL of the windows xp or windows 2003's HTTP.SYS kernal modulet. By default on ...Show All

• SQL Server Zero converted to null

  I have restore a SQL Server 2000 database in SQL Server 2005. I have a web aplication that uses dll to talk to the database using ODBC - SQL Native Cliente provider. I have a table with a key integer not null. The first element of my table has a key = 0. When the asp page recive the record set the value of the key field is null, why If i use the query directly in the SQL Server the value of the key is 0. Please help. I mange to isolate the problem. I have 2 tables: table1 ("id", "txt_value") 1, fist 2, second table2 ("id", "txt_othervalue") 2, other second when i execute the querie: select table1.id, ...Show All

• Windows Live Developer Forums Windows Media Player and Messenger

  Where do I find the plug-in for Windows Media Player that lets me show contacts what music I'm listening to on Windows Live Messenger Same problem here. This was my solution: On the media player, go to the properties dialog where you can add another plug in. (the one that asks for a .exe or .dll) On the dialog to took for the file, navigate to the directory of your MSN Messenger instalation and look for a file named msgrapp.dll (the name can have a version number after the msngrapp). When you add it, the media player shows it as unknow, but when you activate it, voila!!! Let my know if it works for you as it worked for me. Sorry for the bad english, it's not my native languaje. Good luck. Bye. ...Show All

• Visual Basic move, swop, sort

  hello i have written a piece of code, and have obvioulsy done soemthing wrong as it's not working right. it is supposed to sort a list of names and scores into order, but it just repeats the last line, and i don't know why. i'd be greatful for any words of wisdom form anyone out there my code is: Dim Players() As String Dim total, score, handicap, i,HoleNo As Integer Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Listdisplay.Items.Add( "NAME" & Chr(9) & "HANDICAP" & " " & "TOTAL" & " " & "SCORE" ) Players(0) = "Andy" h ...Show All

• Windows Forms Problem referencing items in a different project in solution

  I am creating an Outlook style application with email and contacts. I have my mainForm which is in its own project. The main form has a splitter. One on the left for the tree. And one on the right for a grid. In the Contacts project, my contacts tree is a user control, with a treeview added to it, and it has another user control with a grid added to it. In my main project, I add a reference to the contacts project. When my program starts up, it programatically adds my contactsTree control to the left side of the splitter, and my contactsGrid control to the right side of the splitter. And so on, for the email it adds the email controls etc. When a user chooses email, the email controls are set to Visible, and the rest of the controls are hi ...Show All

• Visual Basic Issues in converting a usercontrol project from VB 6.0 to VB 2005

  Hi, I'm converting a VB 6.0 project to VB 2005. There are few issues, where i got stuck up. They are 1. 'Ambient' is not a member of 'System.Windows.Forms.UserControl' This is the code that gives this error. If (mbHasFocus Or MyBase.Ambient.DisplayAsDefault) And m_Style <> 0 Then 2. AmbientProperties property Ambient.Font was not upgraded. Ambient.Font is not recognised. How to get his issue resolved 3. UserControl property UserControl.AccessKeys was not upgraded. How to set the AccessKey property for a usercontrol 4. ObjPtr function is not supported. This is the code that gives the error. gcTimerObjects.Add(ObjPtr(Me), mnTimerID) - Me refers to object of objTimer class. How do i find the address of a object 5. ...Show All

• Visual Basic Class not registered

  I just transferred an app from one computer to another and upgraded from VS 2002 to VS 2005. After doing this, I'm getting several errors, the most common one being: Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)). The error occurs on the line that says InitializeComponent() at the end of the region "Window Form Designer generated code" for one of my forms. I looked at my classes in the Class View window, and they appear the same as those on my other machine w/ VS 2002. What do I need to do to register this class The error occurs on the InitializeComponent () line below. # Region "Windows Form Designer generated code " Public Sub New () ...Show All

• Visual Studio How can i force the placement of a port on its parent ?

  I would force the position of a port on the bottom edge on its parent. Is it possible to implement this feature There is a PortPlacementHelper property but it's a non overridable static property. Is it a way Thanks,   Hi Malain, You need to write a BoundsRule for the Port shape. BoundsRules can be applied to any shape, and are used (1) to restrict how the user can resize the shape (not applicable to Ports) and (2) to restrict how the user can place the shape. using System; using Microsoft.VisualStudio.Modeling; using Microsoft.VisualStudio.Modeling.Diagrams; public partial class InPortShape { // For a port shape, overrides the normal port positioning. p ...Show All

• Visual Basic Can't kill Excel.Exe after using Excel component in vb.net

  Hi , I'm using Excel.Application generating excel report via vb.net 2003 , the problem is excel.exe process reminds even after generated excel report closed . I have been using the followed code to close or dispose the process , but it does'nt work either. thenks Dim procList() As Process = Process.GetProcesses() Dim k As Integer For k = 0 To procList.GetUpperBound(0) Step k + 1 If procList(k).ProcessName = "EXCEL" Then procList(k).Close() procList(k).Dispose() End If Next Hi, that is really not the supposed way of releasing a COM server ;) Call System.Runtime.InteropServices.Marshal.ReleaseComObject on every COM va ...Show All

• Visual Studio 2008 (Pre-release) Duplicate DataContract while generating proxy

  I have a DataContract name Customer present in a common assembly Customer.dll which is referenced by two services. When I use svcutil to create the proxy for the two services, The Customer type is generated in both proxies (which is valid!). Now, is there a way I can make sure that though I create proxies for both services, I need only one copy of Customer created (because they refer the same DataContract) Thanks. Kishore You can also generate the proxy using shared types as I describe in this post: http://www.dasblonde.net/PermaLink,guid,c132e497-7fdb-4895-9b71-8542d0400d52.aspx svcutil /d:<path> /config:app.config /o:serviceproxy.cs /r:MySharedTypesAssembly.dll http: //localhos ...Show All

• SQL Server SQL Server 2005 Index Behavior: Performance hit

  Hi All Greetings! I have some 20+ SQL 2000 databases on a Server with 2.7 GHz processor and 1 GB RAM. I created a replica of the same setup on a different server (with identical hardware configuration) with SQL Server 2005 instead of SQL Server 2000. Reindexing and Update Statistics were run on SQL Server 2005. Performance of SQL Server 2005 is very bad across all the databases. One thing we identified is that SQL 2005 is not picking up indexes as SQL 2000 did, at places. The result is a table scan. Can someone help us out on what to be done for SQL 2005 to give the best performance TIA Chaithanya ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Help

  Why doesn't someone with knowledge of XNA and C# programming language start a thread to explain the language and how to use it in XNA for people like me who want to make games but cant understand the complicated tutorials that the web has to offer ...Like a programming for dummies tutorials or something... Glenn Wilson wrote: Moving the thread to the XNA Groups. Have a look at http://bluerosesystems.com/CS/blogs/xna101/ , you will find some lessons on the basics of XNA. Also if you have any questions you are more then welcome to ask them here and we will all help. Glenn, Thanks for referencing my blog. I just wanted to update the link, I have migrated the lessons to Window ...Show All

• Visual Studio Reference from one DSL metamodel to another

  Hi, How can I reference from my metamodel to element from another metamodel For example, SDM (is based on old version of DSL), you can inherit or reference on elements from imported metamodels, but they implements it inside SDM. Probably, in the current version of the DSL you have implemented this as DSL functionality May be if all referenced metamodels are loaded to Store it solves some problem, but how does it works for Designer, for instance Evgeny Popov We need this functionality as well, but have been unable to find any built-in way of accomplishing it. We were able to work around it by writing two custom directive processors that load the models being referenced before the DslDirectiveProcess ...Show All