traynor's Q&A profile

• Visual Basic Windows Form - Runtime Query Builder

  Hi All! I'm pulling out the remaining grey hair I have left trying to figure out how to create a runtime, graphical user interface for building sql queries.  I have Visual Basic .Net 2003 and Infragistics 2005 v2.  Please help! Thank you for the responses.  To be more precise, I'm seeking code or component that has graphical capability much like you would find in a report utility such as Crystal Reports.  The application ...Show All

• SQL Server Error Code 0xC0202009 + connection password

  Hi, I have developed a .dtsx package than runs normally from my computer. When I import it on the server and assign it to a job it always fails. I tried also to run it directly from the server (remote desktop) and also faild. I exported the dtsx file on server and refresh the db connections and after that workd fine from the server. Another work-around was to use windows authentication. Then runs normally from the server. It seems th ...Show All

• SQL Server Database script creation

  In the paste I have used SQL2000 to create db from the Query Analyser. In SQL2005 I can't see Query Analzyer but found under programs --> Microsoft SQL Server 2005 --> Configuration Tools --> Reporting Services Configuration --> Database Setup. It creates a database and I can connect to it from VS.NET. Here is my dilema, I was provided SQL scripts to create tables, stored procs etc. Where and how do I run these scripts to create thes ...Show All

• Visual Basic Is there a quicker way to get a string of characters out of a string without using split

  I have a collection of file names that appear like this: test.txt.zip.pgp. Is the a better way than using split to get the filename with out the extension.   The "first index of" method is just called IndexOf: Dim filename As String = "test.txt.zip.pgp" Dim filenameWithoutExtension As String = filename.Substring(0, filename.IndexOf("."c))   ...Show All

• Visual Studio 2008 (Pre-release) Move Event for a FrameworkElement?

  I'm trying to detetct a change in the position (ie Canvas.Left Canvas.Top)  property of a few FW elements. UpdateLayout is usually tripped (not always) and the sender is null in the UpdateLayout event.   Is there any other way Thanks Ron If you are binding in code, then as suggested on the other reply you should bind to the object directly.  binding.Source= fromObject; if you wish to use Elemen ...Show All

• Visual C# some questions about treeview!!

  I am trying to make a directory tree in c# using a tree view.And i want the node to expand only when any node is double clicked.For doubleclick event i used the following code: this.treeView1.DoubleClick +=new System.EventHandler(treeView1_DoubleClick); private void treeView1_DoubleClick(object sender, EventArgs e){ if (treeView1.SelectedNode !=null){ //expand the selected node   }   } but the problem is this event works if i ...Show All

• Visual Studio Team System How to add a "Private Notes" Tab to the TabControl in the Task work item?

  I would like to customize the Task work item in the Agile Process Template in a way that i add a new tab (HtmlFieldControl) in the tab control at the bottom. So far no problem. The problem: The conten of the field should be visible only to the original author. Everyone should be able to enter his private content in that field. Any way to achieve that We currently do not provide field level security so you can't ...Show All

• Visual Basic Number generator based of a bell curve

  I'm looking to enhance my program with a better number generator than using random with a range.  I'd like to be able to specify a mean, median, range, and standard deviation and have the program create a number. Any help would be appreciated! Thanks, Dat Make use of the "z" statistic from a statistics book.  Generate a random number (using normal VB methods) from -6 to +6. This is the "z" ...Show All

• Visual Studio Tools for Office Is this possible with VSTO 2005?

  I am doing some research into what approach to take on our next project. Basically we need a way to generate a booklet with some 80 or so reports pooled from our DW. There has to be some standard wording (state required) and some fields that are dynamic (like Name or Organization, Year etc.). User should be able to add additional sections in table of content and to add custom footnotes to the reports. Some sections might have to protected so ...Show All

• SQL Server Express SP1 No version #

  I downloaded the SQL Server 2005 Express SP1 product today. If I right click SQLEXPR.EXE, select Properties, and select the Version tab, the File Version value is 0.0.0.0. The version listed for the GA product was 9.0.1399.6. Is this a problem to be concerned about Hi, that shouldn’t bother you, smae for me here. Look at the digital signature date, if it is sometime in April 2006 signed (as mine is) this is ...Show All

• Windows Forms main form losing responsiveness

  Howdy all. I'm building an app and this is essentially how it works. I've got a winform. On the left is a tree control. On the right I've got a panel, which I call ControlHoster. What I do is change the content of the panel's control& ...Show All

• .NET Development Table Adapter, DataSet and Datagridview

  I am brand new to VB2005. Up until now, all I've used is VB6 so please bear with me for not knowing something that is probably very simple. I created a form along with a data source and dropped it on the DataViewGrid control and VB created the Table Adapter and Dataset. How can I change the query in code Or, can't I do that I do NOT want to use a stored or paramerized query. I want to use a completely new SQL query. Some queries may in ...Show All

• Windows Forms parsing xml through classes

  Hi, I am accessing an xml document through the class, automatically created through xsd tool.  This class maintain xml document in a hierarchy of arrays, and you can access your desired xml element or attribute through indexes in the arrays. But th ...Show All

• Windows Live Developer Forums Pushpin in v3 only accepts images as icons

  Hello, What happened to the ability in v2 to simply use a div tag and style as opposed to an image for the pushpin icon. It appears that v3 only accepts an image source. This really has messed us up as we now have to dynamically generate images on the fly which has a huge impact on performance. Any particular reason why this has been changed It appears as if the image source is used in an html img tag (within the pushpin generation). Why ...Show All

• Visual C# How to access classes and properties of .dll file?

  I'm new to C#. Will someone show me how to access the classes and properties of a .dll I already have it reference in my bin folder. Once your C# project has a reference to the .dll (right click on the project in Solution Explorer and select "Add Reference...") you need to add an appropriate "using" statement to your source file to indicate which namespaces you want to use. For example, ...Show All