PiGuy's Q&A profile

• Visual Studio ASP.NET 2.0 Code Model

  Is there a code model available for ASP.NET 2 projects I'm working on an add-in, and in the OnConnection function, I'm looking at the first item in _applicationObject.Solution.Projects, which has a CodeModel property that is set to Nothing. There are two ways of getting a code model: - Using Project.CodeModel - Using ProjectItem.FileCodeModel ProjectItem.FileCodeModel should work fine. If something, it may require you to open invisiblily with Window win = ProjectItem.Open(xxx) before accessing ProjectItem.FileCodeModel. As long as you don't call win.Visible=true the window won't be shown. When done, you call win.Close if the windows was not open (which you can guess at start calling ProjectItem.Is ...Show All

• Smart Device Development Serial Port problems

  Hi. Running Imate SP5m with .NET CF 2.0 SP1 I have contacted Imate (on the side: poor support) who confirm that Raw/Serial IR access is possible and is on COM3. In the registry it says COM4. Anyway... If I use the serial Port class to open COM4 and write to it, I have the issue where when we do a serialport.write("hi");, the application does nothing. it just hangs, no exceptions are thrown. It does not even get to serialPort.Close(); If I use the serial Port class to open COM3 and then write to it, I get an exception @ serialPort.Write("hi");: at System.IO.Ports.SerialStream.WinIOError() at System.IO.Ports.SerialStream.Write() at System.IO.Ports.SerialPort.Write() at SerialIrTests.Form1.mnuStart_Click() at System.Windows.F ...Show All

• SQL Server SQL error number is 5110

  Background: Im creating an ASP .Net app in VS2005. Local machine has SQL express installed and server has developer edition of SQL 2005. When it tries to create the database file on a UNC share it comes up with an error " The file "\\server\Visual Studio Projects\Websites\PWSDelete\App_Data\Personal.mdf" is on a network path that is not supported for database files. An attempt to attach an auto-named database for file \\server\Visual Studio Projects\Websites\PWSDelete\App_Data\Personal.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. " to you guys the error message " The SQL error number is 5110 and the SqlException message is..... " ...Show All

• Software Development for Windows Vista Which Atrributes? WCF & WF

  I am new and trying to grasp the proper design of interfaces for WF and interaction with WCF. It seems that interfaces need a structure like this for WCF: [ ServiceContract ()] public interface IService1 { [ OperationContract ] string MyOperation1( string myValue); [ OperationContract ] string MyOperation2( DataContract1 dataContractValue); } Yet, WF needs something like this: [ ExternalDataExchange ] public interface IService1 { void RaiseMyOperation1( string myValue); event EventHandler < MyOperationEventArgs > MyOperationEvent2; } How are these two supposed to be combined/ work together (yes - its a weird example, but even ...Show All

• Visual C# Working with Excel files - MSDN let me down :-(

  Hi all, I'm having major problems accessing Excel data in files. I've found the following snippet which seems to work:                  Range range = firstSheet.get_Range("A1", "C3");                 //Retrieve the data from the range.                 Object[,] saRet;                 saRet = (System.Object[,])range.get_Value(Type.Missing);                 //D ...Show All

• Visual Studio Team System Cannot jump into the source file

  Hello, I get a warning and try to jump into the source file (via link). This brings the following error: "Could not start Microsoft Visual Studio. Try specifying an alternative source coding editor in Applicaton Settings". Does anybody have an idea about the problem Thank you VP ...Show All

• SQL Server Remote access to sql server

  Hi, I use a VS2005 application with a sql database. All is working well over a local network but I now want remote access to the system via the internet. Is this possible I have a fixed IP address & am wondering if I can just use the ip address as part of the connection string (And if so - how!) Barry Andrew wrote: Think we are getting there now Sort of!! I can open the connection now, but when the app starts it still uses the connection in the settings file... I think I need to take a step back because I think I'm missing something obvious! Just to explain, other than trying to get the remote access to work, I have 2 local server instances here, so I'm quite easily a ...Show All

• Visual Studio VS 2005 Packages - Custom Editor

  Hello, I'm trying to build a package for VS2005, I know how to create the project however I don't know where to start from, it's my first package for VS2005 What I want is to expand the IDE DropDown functionality to work just like in VB.NET, in VB.NET when you click on the Events DropDown List the form/page events show up and you can implement them by choosing your desire events from the list, now,I want to do the same thing for C# ... I've been messing around with the Custom Editor and something is weird, once I click on the CS file through the solution explorer, VS crash, when I choose to see the code through the "View Code" option it's fine. I noticed it happens even if I click on the file to close it. Note, I open ...Show All

• Visual Studio Team System Security Problem with Accessing Work Items

  I have a security problem with accessing work items. I have created a team project based on a customized project template. Among the rest, there are a "Defect" work item and two team queries, "All Defects" and "Active Defects" . MyProject > "Team Project Settings" > "Group Membership..." context menu item shows "Project Groups on MyProject" dialog with the list of the team project groups, including [MyProject]\All that includes another team project group, [MyProject]\Developers that includes a Windows user MyDomain\John . MyProject > "Team Project Settings" > "Security..." context menu item shows "Project Security" dialog with the list of the team project groups and their permissions, particularly, the above-mentioned ...Show All

• Windows Search Technologies Vista 64 and Searching

  It appears that the 64bit version of Vista 64 build 5472 has limited searching facilities. OneNote 2007 for example appears not be be indexed at all even in the application. Searching is important to me so I want to get a bit of a feeling whether I should drop down to 32 bit version Is 64 Bit Vista development going to behind the 32 bit version in areas for some time Ok Paul I have had on win. The WDS 3 B2 allows searching all notebooks in OneNote 2007 under XP 64 bit. I still can not see a solution to Vista 64 bit indexing of OneNote. Am I missig something or am I impatient :-) I use Google Desktop Search as it can index files on the server, something I can not work out in Windows Desktop Search. Too many ...Show All

• Visual Studio RDL to RDLC

  Is this the only way to convert and can this be done programatically and any pitfalls to watch out for RDL-to-RDLC Conversion When converting a .rdl file to .rdlc format, you must manually replace the data source and query information in the report definition with data constructs provided in your application. Rename the .rdl file to use the .rdlc file extension. In Visual Studio 2005, open the solution or project that will contain the report. Create or add the dataset that defines the data you want to use to your projector solution. For more information, see Creating Data Sources for a ReportViewer Report . On the Project menu, click Add Existing Item and then select the .rdlc file that you created in the first step. In th ...Show All

• SQL Server Report server service wont start

  Windows server 2000 sp4. Has existing sql server 2000 development running. Installed sql server 2005 as instance name=sqlserver2005. Reporting server configuration panel - Server status - Start service fails The tellmemore link shows: System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed. at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout) at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start) The Application event log shows: Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'NTSERVER1\ASPNET' is n ...Show All

• SQL Server converting Datatypes:

  Hi All, how do you convert from a date to an int as well as converting from Varchar to and Int in SQL server 2000 I am retrieving the GetDate() which i store in column as Varchar, i then want to use it within my select statement to calulate data which i want to return i.e DECLARE @DateValue AS VARCHAR(20) SELECT @DateValue = ApplicationSettingValue FROM ApplicationSettings WHERE ApplicationSettingKey = 'ProcessDate' print convert(int,@DateValue) - 5 print GetDate() - 35 SELECT ccy_code, NULL, xrate_date, sterling_xrate FROM SylvanTrans.dbo.SIADHP_XRate_Hist WHERE xrate_date >= (CONVERT( int, @DateValue ) - 35 ) ORDER BY xrate_date now my as you can see in my WHERE CLAUSE i want to calculate what is retur ...Show All

• Visual Studio Team System Same Transition but different Users

  Hello, I am currently customizing a work Item and I would like to have the reason, for a transition, to be dependant of the user group. I.e. The transition from state "A" to "B" is available for MyGroupA with reason "reasonA" and "reasonB". The same transition is available for the remaning user with reason "reasonC". I have tried the following solution : <TRANSITION from="A" to="B" for="[project]\MyGroupA"> <REASONS> <DEFAULTREASON value="reasonA"/> <REASON value="reasonB"/> </REASONS> ... </TRANSITION> <TRANSITION from="A" to="B"> <REASONS> ...Show All

• SQL Server design time support for oracle db

  Dear all, i have a question concerning the design time support when accessing different oracle database schemas with SSIS. I'm using an OLEDB-Connection, and in general everything is working fine. I would like to access two different schemas. One for production and one testing. So i have stored my connection properties in a configuration file, which looks different for prod and test. I'm not allowed to connect to the oracle db with the user in who's schema the tables are located. (e.g. schema=prod, my user=readonly) Normally i must type SQL like: "select * from prod.MyTable" for my production datasource and "select * from test.MyTable" for my test datasource. In order to clean up my sql i use the oracle & ...Show All