Ross B.'s Q&A profile

• SQL Server "Select top (n) from <table>" missing from Management Studio

  In sql 2000 one could right-click a table (under Enterprise Manager) and have it return the "top n" rows in the table. That feature seems to be missing from Management Studio. Am I correct or is it just hiding somewhere TIA, Barkingdog No, its definitely not there, you will have to tweak the SQL Statement by clicking the appropiate item in the iconbar. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Windows Forms DataGridViewComboBoxEditingControl ThreadStateException

  Here is the exception and stack trace, it occurs on the user interface thread when I try to open the combobox dropdown in a DataGridView. My application is in a Multi-Threaded Apartment. Current thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it. at System.Windows.Forms.ComboBox.set_AutoCompleteMode(AutoCompleteMode value) at System.Windows.Forms.DataGridViewComboBoxCell.InitializeEditingControl(Int32 rowIndex, Object initialFormattedValue, DataGridViewCellStyle dataGridViewCellStyle) at System.Windows.Forms.DataGridView.InitializeEditingControlValue(DataGridViewCellStyle& dataGridViewCellStyle, DataGridViewCell dataGridViewCel ...Show All

• Software Development for Windows Vista Error in WorkFlow Monitor

  Hi, I have a problem to start Workflow Monitor. It says "Exception in GetWorkflows" and the description is: "No se puede cargar el archivo o ensamblado, 'Proceso, version 1.0.3, Culture = Neutral, PublicKeyToken = null ni una de sus dependencias. El archivo no puede hallar el archivo especificado. In tracking' Database in table Workflow and column WorkFlow Definition appear this: <ns0:VentasAFacturacion documentO="{p1:Null}" x:Name="VentasAFacturacion" ProcesoID="00000000-0000-0000-0000-000000000000" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/workflow" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:p1="http://schemas.microsoft.com/winfx/2006/xam ...Show All

• Visual Studio Team System Project Server to TFS "Loose Integration"

  I have seen numerous posts and heard many quotes from Microsoft and MVPs saying that TFS does not directly integrate with Project Server, but that they do support indirect integration.  See how MSDN ( ( http://msdn2.microsoft.com/en-us/teamsystem/aa718916.aspx ) refers to Rob’s Project Server post.... http://blogs.msdn.com/robcaron/archive/2006/02/22/537486.aspx which suggests loose integration is supported. " Currently, Team Foundation Server supports loose integration with Project Server by using Microsoft Project plans as a means to synchronize data between the two servers. The Project Server–Visual Studio Team System Connector (available on GotDotNet.com) is an illustrative sample solution that explain ...Show All

• SQL Server delete statements deletes more rows than select using the exact same criteria

  I have a situation where a select statement returns about 30 rows of data but a delete statement using the exact same criteria deletes 190 rows from the same table. Here is my select: SELECT * FROM PS_COST C WHERE C.ASSET_ID = '000000000315' AND C.BUSINESS_UNIT = '00010' AND EXISTS (SELECT * FROM PS_OPEN_TRANS OT WHERE OT.CALC_DEPR_STATUS = 'P' AND OT.DTTM_STAMP = C.DTTM_STAMP AND OT.TRANS_TYPE = C.TRANS_TYPE AND OT.ASSET_ID = C.ASSET_ID AND OT.BUSINESS_UNIT = C.BUSINESS_UNIT AND OT.BOOK = C.BOOK) Here is my delete: DELETE PS_COST WHERE ASSET_ID = '000000000315' AND BUSINESS_UNIT = '00010' AND EXISTS (SELECT * FROM PS_OPEN_TRANS OT WHERE OT.CALC_DEPR_STAT ...Show All

• Visual Studio Express Editions displaying text on multiple lines

  Hi everyone :) I was wondering if there was a way to display text on more then one line on a textbox when a user presses a button ( I don't mean the mutiple line option from the textbox ) For example: A user clicks on a button called | Signup | and the text would be displayed like shown below one line at a time: Firstname Lastname Address .. etc. Hi, John You just set the textbox multiline as true, then set the value to textbox.Lines instead of textbox.text, and it displays! For example:             string str1 = "Firstname" ;             string str2 = "Lastname" ;     ...Show All

• Visual Studio Team System Solution Explorer and Source Control Explorer out of sync

  Hello! There are occassions where my Solution explorer and Source control explorer are out of syn no matter how many times I get the latest version or refresh on the solution. This happens randomly and no steps to reproduce. I ultimately end up closing and reopening VS 2005. Many other developers have also been complaining about the same. Please assist! When they get out of sync, are Source Control Explorer and Solution Explorer referring to the same workspace The Source Control Explorer workspace can be seen in the Source Control Explorer's Workspace combobox. The Solution Explorer should be using the workspace that is shown in the Workspace combobox of the Pending Changes toolwindow. If the ...Show All

• Visual C# Unable to open FORM2

  Ok, I have a Form1.cs and a Form2.cs Form1.cs is my main form. HOW do I make Form2.cs open I don't want to create a NEW form, I already have one that I've created and that is apart of my project, how do I make that second form open Thanks, Todd Ok, I just figured it out... I have TWO forms: Form1.cs Form2.cs I want to load the second form from a button click on the FIRST form. Because of the default naming, I was getting confused. Although the filenames are stll "Form1.cs" and "Form2.cs", the variable name for Form1 is "frmMain" and for Form2 is "frmSpecialTeamsEntry". This is what I difined them under the Solution Explorer. In order for me to ...Show All

• Software Development for Windows Vista Developing on Vista - things to look out for?

  I should be getting my sticky little hands on Vista next week, it seems. Whether I should or not is another matter. Are there any articles on things to look out for from the point of view of a developer running Visual Studio 2005, such as security (i.e. not having Admin rights), or could somebody give me a quick rundown of the major issues Thanks, but I was hoping for information about how well Visual Studio 2005 and other developer tools run under Vista, whether there are any issues with trying to perform day-to-day development tasks with the new security features. I'd vaguely heard there was some issue with debugging Are there any compatibility issues which mean I shouldn't switch to Vista as my main development environment straigh ...Show All

• Visual Studio 2008 (Pre-release) Debugging WCF server on Vista RC1 (x64)

  I'm having trouble debugging a WCF server on Vista. It seems that you are not allowed to bind to an adress without elevated privileges, this I fixed (when running *without* a debugger) using e.g http://mark.michaelis.net/Blog/WindowsCommunicationFoundationWithWindowsVistaAndUAC.aspx that is adding a manifest to exe requesting elevated privileges. The problem is, it seems this does not work under the Visual C# (Express) debugger (even though there is a exename.vshost.exe.manifest) with the correct content. I do not get a dialog asking to OK elevated privileges, it just behaves like the the manifest is not there ! ! How do I fix this easy way of fixing is,launch VS.NET under admin account,so it will have all privileges to debug apps (p ...Show All

• Gadgets Flash SetVariable

  Howdy. I've been working on a gadget that allows the users to interact with a flash player by clicking on urls in the gadget. I'm having problems, though, when I try to use the "setVariable" command in javascript. Also, it seems that flash cannot access any javascript commands either! Has anyone else encountered this, or solved the problem This is a similar question. Has anyone been able to call javascript from flash in these gadgets It appears that each gadget is acting as a "code island" to keep javascript functions and variables from colliding. Yet flash is acting as if it is outside of the gadget it's residing in. So when a javascript command is called, it is thrown an error that t ...Show All

• Visual Basic How can I use bindingnavigator to update my dataset and data table into database

  hi, I am using bindingnavigator to review my datatable in dataset, I use several textbox for my fields, I use oledb class, I can review, but when I modify my value in the fields, I can't commit them into database, anybody knows how to do that Another thing, I know how to do master/detail review in bindingnavigator, if I would like to review from detail, how can I make a relation between my data tables in my dataset by the way, i am using access database. thank you why nobody can answer my question I am not sure why currently, oledb in asp.net becomes so hard to use, what hell is dataadapter, dataset, datatable, it is so complicated. it should be easy to use that! In Adodb, it is easy to operate data with record ...Show All

• Visual Studio Express Editions Is this function ok

  Hello, Is this the most efficient way to write the function below Regards, Ken Friend Class form1 Dim A As Boolean Public Function Inpt_State( ByVal A1) If A = True Then A = False Return A Exit Function End If If A = False Then A = True Return A Exit Function End If Return A End Function Public Sub PictureBox1_MouseDown( ByVal sender As Object , ByVal e As System.Windows.Forms.MouseEventArgs) Handles PictureBox1.MouseDown Dim x As Integer = e.X Dim y As Integer = e.Y If x > 0 And x < 20 An ...Show All

• Visual Studio Express Editions need help displaying array values

  i have 150 values in an array and i want to display them in order of the highest first and the lowest last. i have no idea how to do this. Help will be appreciated. thanking in advance oli now it works but i have hit a new problem now. it is not saving the values for "arrtotals(150)" after when it gets to the listbox part. Is there a problem in my loop or anywhere else ...Show All

• SharePoint Products and Technologies DB content migration from Sharepoint 2003 to MOSS 2007

  I have created a new MOSS 2007 portal, now I want to migrate document libraries and user and their permission from SharePoint 2003 to new portal in MOSS 2007. I only want to migrate document libraries and Users, not the complete portal. Can anyone tell me what are the steps that are required to migrate document libraries and user and their permission from SharePoint 2003 to new portal in MOSS 2007 Thanks, Bilal Bilial, In Beta 2 TR you had three options for upgrade Inplace, Gradual and database.  Database seems to have been dropped from the SDK so not sure if this is still a valid approach. However in your scenario, where you have the new MOSS 2007 setup already,  I would reco ...Show All