Just Joe's Q&A profile

• SQL Server Input parameter to function in SQL query

  I am trying to use a Execute SQL task in which I call a query and get back a scalar value. I THINK I have it set up correctly, yet I am getting a very unhelpful error message of: Error: 0xC002F210 at Determine Previous Trade Date, Execute SQL Task: Executing the query "SELECT[Supporting].[dbo].[fGetOffsetTradeDate]( , -1) AS [PreviousTradeDate]" failed with the following error: "Syntax error, permission violation, or other nonspecific error". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. The Parame ...Show All

• Windows Forms column alignment problem

  If I set the column DataGridTextBoxColumn alignment to HorizontalAlignment.Right, the header text also aligns right. It also seems to lose the rightmost character. see screenshot example: <a href="http://site218.webhost4life.com/mdev/colalign/colalignment.jpg">screenshot</a> Any suggestions Thanks. Yes a bug, it's caculating the width of the text, try using a fixed with font. also, lots ...Show All

• Visual Studio Reference to ToolWindow from within Custom Tool

  I've created a ToolWindow in a VsPackage. In the same assembly I also created a CustomTool for generating some code. How can I get a reference to the ToolWindow I've created via the VsPackage Is this possible Hi Stefan, If your custom tool implements IOleObjectWithSite, you should get an IServiceProvider from which you can retrieve the IDE's IVsUIShell interface, and then invoke the FindToolWindow method. There is a sample in the December CTP drop of the Visual Studio SDK, called "GeneratorSample" that illustrates a single file generator (aka custom tool) that also implements IOleObjectWi ...Show All

• Visual Studio Build Solution in IDE and Msbuild

  Hi, Is building a solution using command line msbuild call different from building a solution within VS2005 IDE. If yes, is there any references/tutorials with respect to that. Our solution compiles successfully within the IDE but fails when I call msbuild Project.sln Our solution contains C# projects with web applications and website (website contains one web application as virtual). Thanks MRI When trying to build from command line it gives "path not found error". The structure is as follows: "store" is a website which has a virtual "ui" below it as defined in IIS. On file system sto ...Show All

• Visual C# When does the return return the value

  Hi All! I thought I had this figured out but maybe not.......... Does the return exit the function at the point where it is at ,, or does the return hold the value tell you finish the functions.... Please set me straight cause =================================== if I use this it returns a false all the time//// if ((KeyValue->ToLower()) == "accept") return true; return false; ; =============================================== if I do this it returns the correct value........ if ((KeyValue->ToLower()) == "accept" ){ return true ; } else { return false: } } ...Show All

• Visual Basic reading file LINE by LINE

  I already built a New Character Page that you gill out information like name gender and class that auto-generates stats for the specific character (Stamina, health, mana, strength defence, agaility, and wisdom) and saves each of those stats as individual txt files and puts them in a folder depending on what you put in as your name. Now When I start my game I want to chose what account to play as. I am thinking when I save my character it saves annother textFile called CharacterList.txt and adds a line to that character list for whataver you put in as your name. so if you put in Shredder as your name. it would add a line in the txt file calle ...Show All

• SQL Server Visual Web Developer - how to run sql scripts?

  Hello, I'm using Visual Web Developer, and thru the Data Explorer tab, I have created a database with some tables in it. I have alot of data to insert into a table, and I would like to read in an sql script (text file)- that has alot of INSERT statements in it- so that I can upload data to my table without having to laboriously sit in front of my computer and type in the data. I have searched thru all of the pop-up menu options in the Data Explorer, and I have yet to see any facility to be able to load scripts. But since this part of VWD- has every other feature, I can not think that Microsoft would leave this particular feature out. On the ...Show All

• Windows Forms force the datagrid to refresh?

  Hi, I need to force datagrid to be populated with fresh data from DataSet. Seems datagrid.Refresh() doesnot work. any work around Thanks. That code works fine for me with a bound listbox... I was hoping it would work with a datagrid.  I have no other ideas on how to refresh a datagrid.  Hopefully someone else can jump in and provide&n ...Show All

• Visual C# Showing a Form

  How would I go about showing a form FormName .Show() doesn't work, and I don't know what will. See, I have two forms (Form1 and Form2). When an item from a treeview control that is on Form1 is clicked, I want Form2 to show. I already have the function that runs when the treeview control is clicked (private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)), but I don't know how to display Form2.  When I try Form2.Show(), I get the following error: Error    1    An object reference is required for the nonstatic field, method, or property 'System.Windows.Forms.C ...Show All

• SQL Server cannot view

  Thought I edited a previous post but apparently not. The cannot view problem is with a png file inserted on a start page of a web site. Other Gif and Jpeg files are viewable with IE and Mozilla but not the png file. Sorry for the confusion as I am a new user to these boards and didn't get the post in place as I intended. We've placed some banner ads from sponsors on our web site and I cannot view them with IE. The ones that are there in either Gif or Jpeg are viewable but we have one in png and I cannot see it. This same banner is on another site in Germany and I cannot view that one either. I've also tried ...Show All

• Windows Forms How to Replace Columns Orders

  I have a DataGridView with columns col1,col2,col3 my objective is How to change the order of these columns at the runtime e.g: col3,col1,col2 Please if a VB Code available Thanks many more Changing the DisplayIndex property of each column should re-order the columns in the grid. Hope this helps. ...Show All

• Windows Forms Scrollable control vs panel

  Does it realy make a diff (performance,memory) when inherit from scrolablecontrol in stead of panel. just curious Remco There is no performance penalty for inheritance irrelevant of the depth of the hierarchy except when you are dealing with virtual members.  In this case there is an extra lookup that occurs to find the right method at runtime but again it is a single lookup (the method table is consolidated into a single lookup table when the type is loaded) and therefore is independent of the size of the hierarchy.  At least this is the way that I remember C# and .NET working.  C++ on the oth ...Show All

• Visual Basic DLL PRoblem

  Hi All, I'm newbies to create DLL file. I have wrote a custom class file, and I compiled it as a DLL. However, I just couldn't get it register with regsrv32. And I couldn't import or add this dll as a references to MS Access as well. Can anyone give me some idea on what's the basic step we have to do in order to create a Dll file and use it in MS Access REgards, silkkeng Hi, Just another quick question, as I create a sub New procedures, to load the settings and read and write procedures. how do I make sure whether the dll file resources is free from memory ...Show All

• Visual Studio How do I test for empty properties set on the command line?

  Given the following project I would always expect to get an output of Test = Test. However, if you run it with /p:Test = you will find that you get an output of Test =. Somehow '$(Test)' == '' is neither true nor false. How do I trap this condition or is it a bug in MSBuild <Project xmlns=" http://schemas.microsoft.com/developer/msbuild/2003 " DefaultTarget="Build"> <PropertyGroup> <Test Condition = " ('$(Test)' == '') or (! '$(Test)' == '') ">Test</Test> </PropertyGroup> <Target Name = "Build"> <Message Text = "Test = $(Test)"/> </Target&g ...Show All

• Visual Studio Team System Project Level Attributes

  I'm attempting to create a process template, and I'm wondering if there is a way to create/store project level attributes.  For example, a project would have a client, maybe some billing information, but it would only need entered once per project.  Any help is greatly appreciated. I don't know of a way to create/view/edit any project level properties.  I would suggest that you create a special Work Item Type. You could define it with a couple of fields: "Property Name" and "Property Value". Your template could create several of these records during Project Creation to hold the d ...Show All