Frederic's Q&A profile

• Visual C# Construct Enum dynamically possible ????

  I was wondering if it was possible to construct an enum at runtime Let's say i have a lookup table, and i'd like to have an enum for that lookup table. Is it possible to construct the enum dynamically Thanks, Yes, It's called a "Control Designer" (which is what I suggested before). Designers for the standard controls live in the System.Windows.Forms.Design namespace. ...Show All

• SQL Server SSIS Packages Dynamic Connections

  1) We are doing data migration from SQL Server 2000 OLTP design to SQL Server 2005 OLAP design. 2) We have used SSIS packages and data flow tasks in which we mentioned connection strings for source and target containers. 3) We have a master execute package which contains series of execute packages in relational order. 4) When we execute this master package, we should be able to dynamically specify different source and connection strings for all packages. 5) Can we do it with dtexec option /Conn[ection] IDOrName;ConnectionString We know what to give for ID or Name but what do we give for ConnectionString. Will it be the source/target one Can we specify both source and target ones with which the data flow packages get executed. ...Show All

• Software Development for Windows Vista BUG?: Office Tools in Workflow Activity

  I've been creating custom activities for my workflow that make use of VSOT. Compiling, running or working with these activities open multiple copies of both winword and excel in the background without closing them, slowly eating up resources until they are closed manually. Activities make use of the Microsoft Excel & Word 11.0 Object Component Libraries with each making a new instance of ApplicationClass and or Document. Let me know if you want me to supply some code samples, glitch found using beta 2.2 I've just tried the same code in a console application with no problems so i do assume that it is either my code in the workflow activity, or a bug in windows workflow code as follows -------------------------------- ...Show All

• Visual Studio Team System Where to get Microsoft.TeamFoundation.WorkItemTracking namespace document and library?

  Hi all, I want to build a "What Is New" page on my internal development web site. The page will list the ChangeSet and the work items relative the changeset. How can I get the work items by a ChangeSet ID from TfsWorkItemTracking database Thank a lot Bill You can also check http://blogs.msdn.com/narend/archive/2006/08/08/691625.aspx to get workitems for given changesets ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. (Clip) Plane transform?

  Hi all -- I'm porting a water shader to XNA, but first I need to get my clip planes right. I noticed we still need to unproject the plane from camera space to world space, but I cannot find a method that actually allows to transform a plane! Like the MDX Plane.Transform method used to do. I tried to transform 3 world points with the inverse of my world*view*proj matrix, and create a plane including these points, but no luck. There was a bug introduced into the Beta 2 Plane(Vector3,Vector3,Vector3) constructor. It doesn't correctly initialize the plane, so you'll need to calculate it yourself. Here's some code for how I do (you may need to change the order of the vertices for your own program): public static void CreatePlane(re ...Show All

• Visual C# Performance Optimization of C# Application

  hi Is there any guide or documentation available that help me understand various factors that can optimize my application with respect to performance . What steps should i take or what factors should i consider in order to cater the performance issue while coding .How attribute and code analysis feature can really help Any idea , guideline will be highly appreciated .... Thanks Tabish. Hi Salvador, I was searching through the forum for threads on .net performance and I came across your post. I would appreciate if you could help to answer some of my doubts. 1. Since you've designed and implemented a real time auction engine, do you think .net is also suitable for signal processing that requires performance in term of a f ...Show All

• SQL Server Unattended (Silent) install SQL Server Express how do I specify a the built in system account???

  When doing a unattended install of Microsoft SQL Server Express, I have a problem specifing the service to installed to be run under the as local system account. I'm using: SQLACCOUNT & SQLPASSWORD parameters but it just won't work. As default SQL Server is installed using the NETWORK SERVICE account, this causes the database to be read-only. What I want is to specifiy in the script that the service should run under the LOCAL SYSTEM account instead. This must also be OS-language independent. I've tried: SQLACCOUNT=NT AUTHORITY\SYSTEM SQLACCOUNT=NT AUTHORITY\LOCAL SYSTEM SQLACCOUNT=NT AUTHORITY\LOCAL SERVICE SQLACCOUNT=SYSTEM SQLACCOUNT=BUILT-IN\SYSTEM etc. and even some different SID as: S-1-5-18 S-1-5-19 All with no password with ...Show All

• Visual C# Help a newbie! Converting VB6 to C#

  Hi All, I've been given the unenviable task of converting someone's VB6 code for an upload form into C#. I'm not doing to bad at the minute but I'm struggling with some of the conversion. For example I have the following code (in C#): ====================== Hashtable strLang = new Hashtable(); Hashtable strAllowedExtensions = new Hashtable(); private bool SetLang() //*** SetLang() //* Add language strings to the array collection //*** { strLang.Add("INFO_FILE_SPEC", "- Is one of the following formats {0}, and is no bigger than {1}"); strLang.Add("ERROR_MAXSIZE_EXCEEDED", "The CV is bigger than the maximum size allowed."); strLang.Add("ERROR_INVALID_FILETYPE", & ...Show All

• Windows Forms Clicking between forms

  Hi, I' ve got two forms with buttons on both. I need to switch when I want between the forms. Now when I click on a button of another form. The Form gets first the focus. Then I need to click once more for the button_event. Is there a way to click just one time Grtz Annihil8 Question: do you see the button the parent form depress the first time you attempt to click it or does it simply change focus first, then you actually see it depress and the event fires on the 2nd try ...Show All

• SQL Server Table visibility

  Hi, I have a table in my Sql report which dynamically displays data .If there is no data in the dataset i don't want that particular table to be shown.How do we do that / Hi, Thanks Suess , it definitely worked....but the table border remains as it is...i have given border style as solid. I i remove the border style then that table is not displayed(as wanted..) thanks ...Show All

• Visual Basic How to Delete Specific String From a Flat File

  Hello, I have some code that reads each line of a fixed width flat file, and if a line is found where the length of the string is > 384, it writes the line to a text file. The other step that I need to take is to delete the line from the source file. The code is as follows; -***************************************** Public Sub Main() 'find the records where the string length is greater than 384 'write them out to a file 'delete them from the source file Dim oFile As System.IO.File Dim oRead As System.IO.StreamReader Dim oWrite As System.IO.StreamWriter Dim LineIn As String oRead = oFile.OpenText("C:\Learning\SettlementDataTest\SC15_Copies\SingleFile\CDNSC.CDNSC.SC00015.11062006") oW ...Show All

• SQL Server Can't uninstall or reinstall SQL Server 2005 Dev

  Long story short: Installed SQL Server 2005 Developers Edition along with Visual Studio 2005. Everything worked as it should. Then there was a problem installing .NET Framework 2.0 Security Update. Fixed that by uninstall and reinstall of .NET Framework 2.0. Now SQL Server does not work. So I figured uninstall/reinstall. Only problem is that it WILL NOT uninstall. I have tried to uninstall manually per KB article (9009967). That doesn't work either. The error info that I'm geting is: LinkID: 20476 Product Name: Microsoft SQL Server Product Version: 9.00.2047.00 Message source: setup.rll Message ID: 50000 EvtType: stateengine\resourcemodule.cpp@ScheduleActionAction@sqls::ResourceModule::LoadStringW@0x716 I ...Show All

• Visual Basic need help with offsets for LayoutKind.Explicit - unravelling a returned struct from unmanaged into managed

  Mathew Gertz pointed me in the right direction I believe in an earlier post. My P/Invoke is returning valid values for 'name' below at field offset 0 and other values as I can see in QuickWatch. StructA below is passed and returned from the unmanaged C++ dll with valid values. An error is thrown however; System.ExecutionEngineException was unhandled   Message="Exception of type 'System.ExecutionEngineException' was thrown." I would like to try Mathew's idea of using LayoutKind.Explicit rather than LayoutKind.Sequential which I am currently using. If I had <FieldOffset(0)> for the first member of StructA, can anyone help me with how the rest would look I would say Offsets would increase by     1. 4 after each Integ ...Show All

• Visual Studio Express Editions database

  can u help with the display data, i have one mdf tha manages all the employees, but i'd like to show only one category... i searched the web and i found a look and find method but it didnt work.. how can i do do u know where to find an example... kisses ivanatilca wrote: thanks ahmedilyas! i looked over and over those links, and i would like to understand the code but i guess it is too complicated, i am just a begginer in visual, i also found this link http://windowssdk.msdn.microsoft.com/en-us/library/hbsty6z7.aspx but once i select the datagridview i can not find the add Query option..there is one in the Database explorer by clicking the table, but it creates a new table and doesnt show the options to add a name ...Show All

• Windows Forms What is the syntax for DataView Filtering using Child Column?

  Hi. Given 2 related tables, parent and child, how would you write DataView Filter using child column. For example, if you have Customer and Order, and you want to find customers whom made orders in April-2006 - How to write a Filter for this I know that you can list the children and then go back to get the parents of each but it seams more natural to use Filter. Thanks for your help. You can use a sql as: Select * from Customers WHERE CustomerID in ( select CustomerID from orders WHERE OrderDate between '1996-07-08' and '1996-07-15') to do the work, but a RowFilter cannot contain a sub query, For more information about RowFilter expression, read THIS . ...Show All