Troika's Q&A profile

• Visual Studio Create CR in runtime in C#.net or alter a CR in runtime

  Like the subject says, i need some help, because i need a cr that changes over the time, diferent things will be "printed" on the CR so i need some help how to do a thing like that. Midet. Hi, I want to use crystal reports to make users able to design the report at runtime. Possibly creating new fields of all types available, modify existing fields. Do I have to purchase developer edition of Crystal reports XI to be able to use that functionality (That is not the VS 2005 Version). Do I have to purchase additional licence per user that will create/modify reports Can we customize that runtime report designer component to s ...Show All

• Visual Studio Express Editions MSAccess Database coding, OpenDatabase

  Hi, I use to be quite good using recordsets and so to get to my databases. Any samples somewhere how to do the following it in vb2005: dim dbPictures As Database dim rsPictures As Recordset Set dbPictures = Workspaces(0).OpenDatabase(dbTxt) Sql2 = "Select * from Pictures order by id" Set rsPictures = dbPictures.OpenRecordset(Sql2, dbOpenDynaset) with rsPictures while not .eof .movenext wend end with rspictures.close dbPictures.close Thanx Andrew Imports System Imports System.Data Imports System.Data.SqlClient public class MyClass ' The rest of the code go ...Show All

• Visual C# SQL update command not working

  When trying to execute a ExecuteNonQuery instruction in my C# web page program I receive an error message which says "Operation must use an updateable query". It is referring to an SQL UPDATE command against an Access data base file. What is strange is that the program works perfectly on my main computer but when I transferred the programs to my backup computer I get the above error message. Both computers are running XP sp2 and both have the same Jet engine dll and the same sql server. Does anyone know what can cause the program to not allow an update on a file. Or more importantly, what does this error message mean Dav ...Show All

• Visual Studio Tools for Office Add-In Only loads when debugging

  Hi all, I did a bit of searching and didn't find any threads about this problem so I apologize if it has been asked before. I have an Outlook 2003 Add-in that I've been working on for quite some time (read: far too long).  :-)  I'm currently working on moving it over to .NET 2.0 (and thus VSTO 2005) and have found the process to be quite smooth thus far.  When I debug the add-in, it runs perfectly and everything goes as expected.  However, when I attempt to install the Add-in, it will no longer load with Outlook and gives the usual message about "A runtime error occurred..." I've had this issue before (back when writing i ...Show All

• SQL Server How to display milliseconds as part of datetime field?

  When I execute the following query: SELECT EntryDate, EntryName, CONVERT(datetime, EntryDate, 121) AS LongEntryDate From Entries ORDER BY EntryDate LongEntry is displayed in the format of "MM/DD/YYYY HH:MM:SS AMPM".  My understanding is that the formatting code 121 (also tried 21 and 113) is suppose to be in the format of "YYYY-MM-DD HH:MM:SS.MMM". I'm using the June CTP of SQL Server 2005, and executing the query via the Database Explorer in Visual Studio 2005 Beta 2. Any suggestions, feedback, work-arounds   Is this a known issue Try the following query: select convert(varchar, getdate(), ...Show All

• Windows Forms I'm going nuts here...

  Trying to find a control that will display nicely formatted text (preferably HTML) dynamically on a Windows form. Does anyone know or have experience with such a beast I have searched all over the Net and found lots of "browser" controls, but I don't want a Web browser - I just want to display nicely formatted text on a Windows form!! Like this: Dim sbText as New StringBuilder() With sbText    .Append("<p><b>This is a bold statement!</b></p>")    .Append("<p>This is a not-so-bold statement.</p>") End With Me.SomeCoolLabelControl.Text = sbText.toString() Any help here would be ...Show All

• Smart Device Development multiple form app, poor performance, design advice?

  We're running into performance problems on our development of a multi-form pocketPC system. We decided a long time ago that each form in this system would be in its own app, and we'd pass the data we needed to move around in xml packets using MSMQ. The reason for this decision was to maximise flexibility, so we can add custom forms for individual customers, and because putting all forms in one app would lead to a BIIIIG app, possibly even appraoching the 32mb limit. However, it's far to slow loading each form, 12+seconds!!! alternatives we're thinking about ====================== Have all the forms in one app, but this would lead to a the bi ...Show All

• Visual Studio Team System .Net Runtime 2.0 Error Reporting Event in Application Eventlog

  Hi I have installed Team Foundation Server RC on a single machine following the latest installation guide. Everything seemed fine after the setup but I get weird event log entries and the TFS is not work. Machine runs on 100% CPU untilization. Application Event log: .NET Runtime 2.0 Error Reporting: Faulting application w3wp.exe, version 6.0.3790.1830, stamp 42435be1, faulting module kernel32.dll, version 5.2.3790.1830, stamp 424377d2, debug 0, fault address 0x00015dea. In System Event Log: A process serving application pool 'TFS AppPool' suffered a fatal communication error with the World Wide Web Publishing Service. The p ...Show All

• SQL Server Create SSAS cube from ADO MDX cubedef

  Hello MDX Gurus! I have a third party OLAP from which I can extract data in form of a ADO MDX cubedef. Now I want to create a SSAS cube from it for which SSAS use ADOMD.NET. The object model of the two are slightly different. Does it exist any converter, mapping code or whatever that could help me convert from MDX to ADOMD.NET effortlessly. Thanks a lot! Not sure what the question is. MDX is a multidimensional query language. Similar to SQL query language. ADOMD.NET is object model you use to build client applications to connect to Analysis Server and issue MDX queries. Hope that helps. Ed ...Show All

• Visual Studio pressing Back-button in Printlayout mode hangs the application

  When in Printlayout mode, hitting Back-button will hang the application in LocalProcessing with Drillthrough. I have been looking for ways  to disable  the  Back-button  when  in Printlayout (preview) mode. However, I couldn't find an appropriate property that would indicate the current display mode. The Back event allows to cancel the Back-button event when needed, but it seems there is no way of knowing the current display mode. Has anyone else had similar experience Are you certain that the app is hanging Is it unresponsive Can you click the stop button on the toolbar EMF re ...Show All

• Visual Studio Tools for Office Help with Outlook Object Model Guard...

  Hi, I've always had problems accessing an AppointmentItem body...and someone pointed me this: http://msdn2.microsoft.com/en-us/library/1thd35d7(vs.80).aspx However, I've this scenario: first of all, I'm accessing to the AppointmentItems from another class, which is not the ThisApplication (and it's not in the same library --> it's another C# project). Second, instead of create an item,I've to READ the items...this is the cycle I'm used to make: foreach (object o in remoteCalendar.Folder.Items) { AppointmentItem appointment = o as AppointmentItem; ... } I tried something stupid like creating an Appointe ...Show All

• Visual Studio Tools for Office How to update Excel CommandBar via Events from C#.NET Addin

  Hi there, I have created a C#.NET (2.0) Excel 2003 Addin. It creates two commandbars. One of the command displays the status of several external components in the form of icons. The C#.NET addin receives information about the status of these components and raises events to update the Excel command bar icons. The events are received and processed ok, however in the processing code I update the icons that are displayed in the command bar and this does not work although the code does execute correctly. I am assuming that this is because that GUI update event is not happening on the main Excel GUI thread. In WinForms I use the PIn ...Show All

• Visual Studio Team System Reducing the change-tracking scope for Team Build reports.

  Hi, In one system, 7 components (.net project) are managed by one Team Project. One build type exists that builds the complete solution. There are some people dedicated to keep track of only the changes within one specific component (one scenario is that one of the components is being shared between other projects and therefore needs more detailed Configuration Management). For the complete build, the build report lists all changes since the last build for the whole projects, but for the smaller build types only covering one .Net project, all other changes in the other .Net projects are included in the build report. ...Show All

• .NET Development SSL on TCP Socket, how in .NET 1.1?

  Is there a way, using intrinsic .NET framework functionality, to open a TCP connection over an SSL channel   I'd rather not get into buying libraries, etc.  Java has the javax.net.ssl.* objects, and I'm not finding an equivalent in .NET. I looked all over the Internet, but nowhere a pointer/solution can be found. Please note this is a socket connection, not an HTTPS connection. Also, it's about .NET version 1.1. Any hints/tips/remarks/howto's (if even possible) would be greatly appreciated... If this is a .NET 2.0 issue, please start a new thead and post your code that is giving you this issue. ...Show All

• Visual Studio Special network security for srcsafe.ini file?

  I have been asked to get SourceSafe 2005 installed and implemented in a relatively small IT group (10 people). I created databases within a network folder which is shared with that IT group. The network permissions for Users on the database folders is set to "modify". But I am questioning if Users should have modify access to the srcsafe.ini file since it contains global settings for the database. Seems like you would not want Users possibly modifying that file. In looking at the MSN page titled "How To: Set Share Permissions for a Database" it makes not special mention of securing this file. Any suggestions, commen ...Show All