ch1p's Q&A profile

• Visual Studio Autorun does not work

  I attended the VS/SQL Server 2005 Launch in Dallas on 11/30.  I have been trying to install the software received from this event, but cannot install VS 2005.  When I insert the disk in my dvd/cd nothing happens.  When I double click autorun.bat nothing happens.  I contacted my local support which then directed me to the "event help" and told them of the problem.  A week later I get a new CD for disk 2.  Guess what, same problem.  Called event support again and am told they only report the issues and cannot answer any technical questions.  So, has anyone had this problem   Is it worth the frustrat ...Show All

• Windows Forms Added unbound grid rows are blank

  Added unbound grid rows are blank I have a master-child relationship.  The master are unbound controls, and the two children are grids. The column names and types I created in the columncollection. When I save the master, values automatically go into the grid columns and saved.  They appear in the grid and are updated correctly to the database. If I add another row, it's values appear in the second row.  However, the first row's contents become invisible.  Same for each subsequent row.  However, when I save each row, it is updated correctly in the underlying database. How can I get the values to stay visible wh ...Show All

• SQL Server Ad Hoc Company Security

  Is there a way in Ad Hoc reports to prevent users from querying data from another companies data In my database each table row has a company Id so that my application only displays data for the currently logged in users company. Can I inforce this in ad hoc reporting Thanks, Duncan You could create a view that displays only the data for the company of the current user and then grant permission only to that view. ...Show All

• Windows Forms Filling a Combo box

  Hi, can anybody tell me the way to fill a combobox without using a dataset (arraylist for example). I want the combobox to display a special string like a name for example, and i want the value to be a string (not simply the index). Thank. You could use those two properties here, too, but not if you bind the control to a generic& ...Show All

• Windows Forms Adding a default item to a listbox

  I'm getting the following error when trying to set a datasource property to a listbox: "Item collection can't be modified if the Datasource property is set". I want to add a default item to the listbox after the data is loaded, but I get the above msg: Here is my code: cboCustomerID.DataSource = DsCustomerID1.tblCustomerID             cb ...Show All

• Visual Studio Tools for Office Caller / Sender

  Dears, I'm trying to retrieve the information of "calling cell" of a UDF in Excel, but I can't use, for example Application.Caller.Address, in C# code now. What's the equivalent code of Application.Caller (I tried Excel.Range r ca = (Excel.Range)Application.get_caller(1) in C# but it show an error that conversion of Int32 to Excel.Range failed) I want to get the original cell value & formula for a custom UDF in VSTO in the Worksheet_Calculate event handler. (Unlike Worksheet_Change, no Target nor reference to calling cell in Calculate handler base on my understanding) Thanks, You are correct ...Show All

• Visual Studio Team System WorkItem API problem: Cannot update Field Completed Work programatically

  As a part of my project to log time worked on each workitem per week I have this code: private static void SetWorkItemFieldValues( WorkItem workItem, double hoursWorked) { workItem.SyncToLatest(); if (workItem.Fields.Contains( "Completed Work" )) { Field field = workItem.Fields[ "Completed Work" ]; double completedHours = Convert .ToDouble(field.Value) + hoursWorked; field.Value = completedHours; } } The problem is that when the variable hoursWorked is in fact an int value ( like 2 and 3 ) it works fine. But when the value contains a decimal value (like 2.5 and 3.5 ) I get ...Show All

• Visual Studio Team System Out-of-the-box reports description

  Where can I find the Out-of-the-box reports description I know that same reports are self explainary but still I'd like to read a description. Tnx, MartaGK Hello-- The out of the box reports differ based on the methodology you choose. They are documented with the process guidance. 1. On the Help menu, click Team Project Process Guidance. 2. On the Overview page, click the Index tab. 3. On the navigation tab on the left, click Reports. You can click on each report name for a description. Julie MacAller, Microsoft ...Show All

• Visual Basic Split images

  Hi, I’ve got a dude about manage images in Vbasic .net. Is it possible to split images with Vb.net , I mean, over any image in the form (imagebox or something), can I select an area with my mouse and save it as jpg or else Thanks a lot. ...Show All

• Windows Forms BindingSource + Object + nulls = problems

  Ok, so we have a business object, and there's a grid bound to the binding source that holds the objects.  If you clear a string field and move to another row you get an error about not being able to convert DBNull.value to a string. First of all, why isn't the grid saving string.empty instead of null Second, I tried using string for the property but got this error message: Error    1    The type 'string' must be a non-nullable value type in order to use it as parameter 'T' in the generic type or method 'System.Nullable<T>' A. I don't understand what it's saying, and B, how do I get around this so ...Show All

• SQL Server auto numbering

  plz tell me how to make a column(id)that is a primary key to be auto numbered . Hi, you have to create a new column with the identity property and copy the primary key values over to the identity column, then drop the old non-identity column. There is no ALTER Column or ALTER table to do this. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Basic making images with buttons

  i want to make a program where when you check a check box it shows an image.what kind of coding does the button need You need to make a form with a checkbox and and picturbox on it and use code somewhat similar to this. Private Sub CheckBox1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CheckBox1.CheckedChanged If Me.CheckBox1.Checked Then Me.PictureBox1.Load("c:\logo1.gif") Else Me.PictureBox1.Load("c:\logo2.gif") End If End Sub ...Show All

• Visual Studio Tools for Office VSTO MSDN Library

  In MSDN Subscriptions site there is 1 CD for VSTO 2005 Beta 2 and 3 CDs for MSDN Library for VSTO. Can you tell me why there is such huge update for MSDN Library Thanks, Martin Kulov The VSTO CD does not include the documentation. The MSDN Library for Beta 2 is very large (obviously, at 3 CDs), and it contains a lot of content--more than just the VSTO documentation. All of the Visual Studio documentation is in there, as well as all the other articles found on MSDN. It's a separate installation step during Visual Studio installation--it should ask you to insert the media if you want to install the documentation. You can't install only t ...Show All

• SQL Server Problems with SQL express

  Hi all, hope someone can help I am trying to do the follwing: take a backup of the reporting services on my sql server 2005 and moving it to an sql express edition. All is good and the only problem is when trying to restore the keys. i am using the command rskeymgmt /a /f c:\\key.snk /p **** When i trried this on the sql develpoer edition all was good ( the source server) but on the destinatio server which is a sql express edition server i get the folling exception: unable to locate the reporting server windows service for instance MSSQLSERVER I have only one instance of sql server on this machine and it of type sql expre ...Show All

• Visual Studio Express Editions exposing .net component to COM application - Excel 2000

  My config Visual Basic Express 2005 + Excel 2000 I have the following problem. I'm creating a COM Class with VBE2005, i create the dll and then register it with regasm.exe. untill then, no errors what so ever. The code by itself works prefectly in a VBE2005 application. Now, I add the .tlb file generated by regasm to the excel reference (VBA Module). Everything look fine, I can see my classes, functions and subs. when I include the class in a sub in VBA I have access to every visible component of my class. When I try to run it, I have the following error. "Automation Error" the Error Number is -2146232576 ...Show All