jtallard's Q&A profile

• Windows Forms cust_id column to hide in gridview

  I am working on a web project to display data in a gridview and I would like to hide the cust_id column in the grid, which is index [3]. I have an Edit (index[0], and two Template columns (index [2] and [3]). The first field being displayed is the cust_id (index[3]). Here is the code I have and the error message I receive is " Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index" protected void Page_Load( object sender, System. EventArgs e) { //calls the dgResults_DataBound method to hide the cust_id column dgResults.DataBound += new EventHandler ( this . dgResults_DataBound ) ; } protected void dgResults_DataBound( object sender, EventA ...Show All

• SQL Server UNION

  Of the two queries below, the first returns the desired result, the union of the select-except statments.  Why doesn't the second query return the same result as the first Is this a mistake/bug on Microsofts side   select * from (select * from TEST1 EXCEPT select * from TEST2) AS A UNION select * from (select * from TEST2 EXCEPT select * from TEST1) AS B       select * from TEST1 EXCEPT select * from TEST2 UNION select * from TEST2 EXCEPT select * from TEST1 They're not evaluated in the same logical order, due to your inclusion of parenthesis. In the first query, set 'A' is UNIONed with set 'B' only after the EXCEPTs ha ...Show All

• Visual Studio Team System Build error in database solution

  One view of my databse project depend on the object which is lying in some other database because of which i am not able to build the solution. Please tell me if there is any way out to resolve this issue. Thanks. Hi, I could not able to comprehend answer completely are you saying that there is an option to link the remote database Or you are suggestion to create a new database in same database project soluion and put all the reffered object there only I tried second option but colud not able to resolve the issue. Please help. ...Show All

• Visual Studio crystal report viewer - login failed

  hi all, i have developed an application in Visual C#.Net with oracle backend. And i was trying to generate a report and when i run the form in which crystal report viewer is placed, it is prompting for login information. I gave the username and password and it is asking for server name and database name also. the server name i gave as 192.168.2.250 and the database name i gave as oracle. the following are the details present in my client machine's tnsnames.ora file: # tnsnames.ora Network Configuration File: F:\Oracle\product\10.1.0\Client_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. ORACLE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.250)(PORT = 1521)) ) (CONNECT_DATA = ...Show All

• Visual Studio Team System Identifying custom fields (Fields collection, GetById, CoreFields enumeration)

  Having retrieved a work item using the Work Item Object Model, its fields are returned in a Fields collection. That collection contains many fields. Some of them are indexed by the CoreFields enumeration. Unsurprisingly these are predefined fields. We however use many custom fields. They are in the fields collection too. How can I easily acces the value of a custom field Is there an enumeration of csutom fields available that can be used with the GetById method Or is there another method for accessing the Fields collection in a Work Item object that I am missing Thus far the only solution I can find is to get a work item, then build an enumeration of all fields myself! How clumsy is that Surely there's a neater way. Here's some ...Show All

• SQL Server upgrading from 2000 to 2005.big issues

  I am trying to upgrade from analysis serivces 2000 to analysis services 2005. When i try to select the instance name, which is "Analysis Services" , i am told i cannot use this name. I have looked this up on the web and found that indeed the name cannot be "Analysis Services" or any keyword. how do i find out the instance id/name of my current installation I only had the default installation of analysis services on the server, and i installed sql server 2005, but my cubes are no longer accessable. all that is in the analysis serivces menu on the start menu is "deployment wizard", and i cant find any cube files to deploy. have i lost my cubes i have a backup of my cubes as cab files. can these be used teh depl ...Show All

• Visual Studio 2008 (Pre-release) Binding Nullable value to SelectedValue in a combo box

  Hi, I'm trying to bind the SelectedValue of a combo box and this works. The only problem I have is if there is no value in "RaceTypeId" because it's nullable, the combo box will select by default the first value in the combo box items. And I dont want that, what should I do to prevent that The ItemsSource of the combo box is set in the code. < ComboBox HorizontalAlignment = " Stretch " VerticalAlignment = " Top " Margin = " 5,2,5,0 " Width = " Auto " Height = " 20 " Grid.Row = " 4 " Grid.Column = " 3 " x:Name = " ComboBoxRace " IsSynchronizedWithCurrentItem = " True " DisplayMemberPath = " Description &qu ...Show All

• SQL Server Cmd shell proxy

  I am attempting to execute xp_cmdshell with a non-sysadmin db login. I have created a Windows account and the associated proxy account in SQL Server. I have verified SQL Server is showing the proxy account credentials. I am still getting the following error. What am I missing Guidance is very appreciated. Microsoft OLE DB Provider for SQL Server error '80040e09' EXECUTE permission denied on object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'. ...Show All

• Windows Forms Problem with DataGridView

  Hi I am using DataGridView for Showing the Data. by default column header is coming in the top of the cell, how to change the apperaance of the column header to bottom of the cell ie how to change the location of the column header from Top to bottom of the cell Is there any property is there in DataGridView or any customization needs to be done if so please let me know Thanks in advance ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Will we be able to shared compiled versions of XNA apps?

  Ok, so before someone flames on me. I searched the forums and what not for a long time, before I posted this. I only saw threads about actually selling the homebrew games and I'm not interested in that. What I want to know: Is there plans in future releases to share only compiled versions or some sort of package I mean if I spend my heart in soul making a game that I think others will will enjoy for the love of the community. It doesn't seem fair that everyone gets my source. So are there plans for just sharing complied versions of some kind If so, whats an approximate time frame Thanks, Nick To a point I agree. The more the community knows, the more games will get created. I'm not ...Show All

• Community Chat Using Vista?

  Good idea Joe! Okay, I'll go first.  I'm using Vista RC1 full time now.  The computer seems quieter--doesn't take so many trips to the hard disk for VM paging.  I find going back to XP an unpleasantry, so I think Microsoft is succeeding here. Glass is nice.  I think the performance is what I expected it to be on an Intel Advanced Graphics card (Dell Dimension 9100).  Office 2007 is also pleasant to use, but they stil have some cleanup work to do on their UI. Who else is using Vista   Brian I have a Celeron 1.2GHz if you want me to check it out on that :-) Automatically Vista will take out the whole graphics system because it doesnt meet the requirements..... Ce ...Show All

• Visual C# Dynamic generate JScript code using C#

  I want to generate a JScript source code file using CodeDom in C# . To be more specific, I use class JScriptCodeProvider. Everything seems fine except when generating , for example the following JScript code: public class Evaluator implements IEvaluator { } My C# code for generating that is: CodeTypeDeclaration Class1 = new CodeTypeDeclaration("Evaluator"); JscriptTest.Types.Add(Class1); Class1.IsClass = true; Class1.BaseTypes.Add(new CodeTypeReference("IEvaluator")); The problem is that CodeTypeDeclaration class only has the collection BaseTypes but not something like InterfaceTypes hence instead of generating "implements", it generates "extends" public class Evaluator e ...Show All

• Visual Basic VB.Net IDE Crashes Often...

  I am having a problem where my VB.Net IDE crashes often throughout the day... I have a Client/Server application that I am developing, shared between the two is a ClassLibrary I developed. So my Client and Server project both have this ClassLibrary as a Project added to the main Solutions. This way if I am in either the Client or the Server code, I can immediately get access to the ClassLibrary code to make changes if needed. Now, my problem is that several times a day, when I attempt to open a form in Design view, I get a white screen with a pink bar on the top that says: One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Visual C++ : Going from 2D to 3D Drawings

  Hi,   I finished an application in Visual C++ 2005 which draws and manipulates different figures on screen using GDI+.  Now, I would like to go a step further and draw those same figures in 3D.  Is there any articles available on the subject   Where should I start   A couple weeks ago, I remember having read something on using DirectX library for this, or maybe something else related.  If it is the right step to take, does anyone have any infos on which library would be the best to use and how to use it   Any example Thanks in advance, Stephane 1) The link you provide is for the latest DirectX SDK so it is definitely the one I would install. ...Show All

• .NET Development FOR XML - ExecuteScalar truncates xml

  I'm writing an asp.net application and I would like to get xml out of my sql server 2005 db using the FOR XML PATH syntax and then associate it with the DocumentSource property of an XML control. I tried using the ExecuteScalar method and the ExecuteReader method and it appears that the xml is being truncated. If I run the query in SQL Mangement Studio it returns all the xml and doesn't truncate it. Any suggestions on how I should do this or why it's truncating would be appreciated. Also, I'm not sure how to associate an xml string with the DocumentSource. Do I need to create a file Thanks, john Wow that is strange, I get the same truncation problem with this code, I'll debug this to see what is up. ...Show All