vasudupe's Q&A profile

• SQL Server Help to write query...

  Hi ! There is one table tCustomers. It has following columns: ID, Name, Code... By the mistake in this table has appeared incorrect records (duplicates). How can I write the query to find them I tried: Select c.ID ID1,s.ID ID2, c.NAME NAME1,s.NAME NAME2, c.Code C1, s.Code C2, From tCustomers c, tCustomers s where c.Code=s.Code and c.ID <> s.ID But the result is not that I expected Hi, If only the ID field constain duplicates, you can use the following query: SELECT tCustomers.ID, tCustomers.Name, tCustomers.Code FROM tCustomers WHERE (((tCustomers.ID) In (SELECT [ID] FROM [tCustomers] GROUP BY [ID] HAVING Count(*)>1 ))) ORDER BY tCustomers.ID; If all the fields are duplicated, use the followi ...Show All

• Visual Studio 2008 (Pre-release) Crash occurs for some images

  I add a System.Windows.Controls.Image to a Canvas in a window. For some images i get an exception with the following stack trace. " at System.Windows.Media.MediaContext.NotifyPartitionIsZombie(Int32 failureCode)\r\n at System.Windows.Media.MediaContext.NotifyChannelMessage()\r\n at System.Windows.Media.MediaContext.CompleteRender()\r\n at System.Windows.Interop.HwndTarget.OnResize()\r\n at System.Windows.Interop.HwndTarget.HandleMessage(Int32 msg, IntPtr wparam, IntPtr lparam)\r\n at System.Windows.Interop.HwndSource.HwndTargetFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)\r\n at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handl ...Show All

• SQL Server Unhandled Exception

  After I installed Sql Sever 2005 and open SQL Server Management Studio, I get this error just after connecting to any server (DB / AS / IS).. Also, during the installationm, I had ignored an error that was raised while SSIS was being configured. The error said, that thr is already a 32 bit registry on the target Com + Application. You must remove the registry from that app. I have done the installation of SS2005 X64 edition. Attaching the exception :- See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.TypeLoadException: Method 'GetMenuItems' in type 'Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Default ...Show All

• Windows Forms errorprovider

  Hi, how to clear error provider from all the ctrls . instead of referring all the ctrls is it possible to do in few statements. because i've around 15 ctrls. thanks venp-- Hi,  I'm getting error  on this command (( ErrorProvider )control).Clear(); like the below Error 51 Cannot convert type 'System.Windows.Forms.Control' to 'System.Windows.Forms.ErrorProvider'    venp--- ...Show All

• Visual Basic VB.NET & EMAIL

  I am trying to figure out, for a friend, how to write a VB program that will launch multiple IE's and when those IE's launch fill in the appropriate login name and password for that site. Is there any way that this can be done After adding a WebBrowser control to the project, you will access the WebBrowser.Document property. The Document.Forms property will expose a list of HTMLElement objects which are all the forms on the page. Then you will look through the Form.Children collection of HTMLElements for the needed textboxes. That's about as specific as I can get without knowing exactly what pages you're trying to parse. As stated previously, you'll have to experiment a little until you figure out whic ...Show All

• Visual Studio Is there a manual update for VS 2005 Pro?

  In VS 2005 Pro, "Help -> Check for Updates" redirects to http://update.microsoft.com/microsoftupdate/v6/default.aspx ln=en-us . Then I get an error message: "Network policy settings prevent you from using this website to get updates for your computer. If you believe you have received this message in error, please contact your system administrator. Read more about steps you can take to resolve this problem (error number 0x8DDD0003) yourself ." As it comes out, my company does have a firewall intentionally preventing Automatic Updates, and there is absolutely no way even to temporarily open the door. Then I looked for manual downloads of VS 2005 updates but could only find this ( http://msdn.microsof ...Show All

• .NET Development sdk 2.0 . which framework is needed to run the app

  say i develop an app with the sdk 2.0. If i try to run the app on a computer with .net framework 1.1 will it run no it will not. the CLR version is different therefore it may well complain at startup that the CLR version/framework version was not found therefore you MUST install the correct framework version on the computer. ...Show All

• Windows Forms Implements ICloneable. form disappear .

  Public Class FormTemplate Inherits Form Implements ICloneable Private Sub BaseForm_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load End Sub Public Function Clone() As Object Implements System.ICloneable.Clone Return Me .MemberwiseClone End Function End Class Public Class MainMenu Inherits FormTemplate Public m_ChildFormNumber As Integer = 0 Public Forms As New List( Of String ) Public Sub New () InitializeComponent() End Sub Public Sub NewForm( Of t As FormTemplate)( ByRef i As t) Dim f As t f = i.Clone If Not Forms.Contains(f.GetTyp ...Show All

• SQL Server Forum Moderator

  i noticed that there are 2 posts with the same title, " Performing Date Range Queries Based on a Non-Calendar Fiscal Year ". will you delete the redundant post that does not have replies. thanks, ken ...Show All

• Visual Studio 2008 (Pre-release) ListBox/polyline error - possibly threads?!?

  i've just discovered a very annoying and unusual error in my application my application draws a series of polylines. for the time being these polylines are hard coded in as strings, and the xaml polyline is binded to this string. i have then got 2 listboxes in my xaml. in my c# code i have a function that splits up the string and then places the x values in the 1st listbox and the y in the 2nd. i have a save button that regenerates the string and so any changes that have been made are now visible on the screen and i have got a delete button that deletes a record and calls the save function. this all works well but i have a problem when i try to add new elements. adding is fine, until there are 10 elements in the list. it then throws a null ...Show All

• .NET Development WSE910/Windows 2000: Security requirements are not satisfied because the security header is not present in the incoming message.

  The WSE3.0 sample : C:\Program Files\Microsoft WSE\v3.0\Samples\CS\QuickStart\Security\WSSecurityAnonymous\Policy can't work when the client is on Windows 2000. It works when the client is on Windows XP, but when i run the client on Windows 2000 Professional, it report an error, the server is running on Windows XP. Exception Message: Security requirements are not satisfied because the security header is not present in the incoming message. Response.Fault: An error occurred when verifying security for the message. SoapVersion: Soap11 It would be best to see the outgoing and incoming messages at the client. Can you enable tracing, and show us the message dump for both machines to compare I presume ...Show All

• Visual Studio Team System Version control API - basic recipes

  I'm working on writing a simple client using the version control API and I'm having trouble with a couple of basic concepts related to server names, local paths and server paths. I'm hoping someone can fill in the gaps with a few recipes - I've looked at some of the samples on various blogs, but haven't found solutions to these basic issues: 1. Given a local path, determine the name of a TFS server that has a mapping for that path (if such a server exists). The code from the example on Buck's blog ( http://blogs.msdn.com/buckh/archive/2005/10/26/485458.aspx ) doesn't seem to work - it never finds a server name. 2. Given a local path, determine the exact name of the server path that maps to it. 3. Given a server path, determine the ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. What is Game Studio Express

  What is to be included with game studio express The Torque Engine Libraries An IDE Documentation I want to be able to make games on this system, but I don't want to have(although the ability to if need would be good) to use outside resources such as external libraries or engines. As a fresh, amatuer, student programmer, I am praying that XNA Express will be friendly to people WITHOUT industry knowledge. And lastly, do I need to own Visual Studio It seems you pretty much answered your own question: XNA Game Studio Express also contains a full set of documentation, how-to’s and starter-kits... ...Show All

• Visual Studio Team System build script question

  Is there any way to avoid this batch from being generated at the begining of build script: GO :on error resume :on error exit IF (@@servername != 'devsrv') BEGIN RAISERROR(N'The server name in the build script %s does not match the name of the target server %s. Verify whether your database project settings are correct and whether your build script is up to date.', 16, 127,N'devsrv',@@servername) WITH NOWAIT RETURN END GO We would like to deploy build script to multiple servers but without rebuilding the project each time with different configuration. only thing that's wrong in script is above server name check. I know we can remove it manualy but maybe there si some switch or build parameter we can set that will exclude ...Show All

• .NET Development SqlDataAdapter: Unable to save data in a SQL database, What's wrong?

  Hi All, I am unable to save data in a SQL database, What's wrong I am coding with VB .NET and I am unable to retrieve data from the database, beside I can read from the database without problems. How can I do, This thing is driving me crazy, it is 4 days that I am tryng to write in the database and I ahve tried everything update, insert. Somebody Know how to manage the SqlDataAdapter, beside the SqlDataReader is working perfectly. I am not used to the SqlDataAdapter. Is there anyone who know how to write in the database or where I am in mistake Thanks in advance. Here is the code: Dim oCmd As SqlClient.SqlCommand Dim oDR As SqlClient.SqlDataReader Dim strSQL, strSQL1, strSQL2 As String Dim adapter As System.Data.SqlClient ...Show All