Andreas Wolff's Q&A profile

• SQL Server Selecting a view and selecting FROM a view is wildly different

  A colleague of mine has a view that returns approx 100000 rows in about 60 seconds. He wants to use the data returned from that view in an OLE DB Source component. When he selects the view from the drop-down list of available tables then SSIS seems to hang without any data being returned (he waited for about 15 mins). He then changed the OLE DB Source component to use a SQL statement and the SQL statement was: SELECT * FROM <viewname> In this instance all the data was returned in approx 60 seconds (as expected). This makes no sense. One would think that selecting a view from the drop-down and doing a SELECT * ...Show All

• Windows Forms For consideration

  Some of these would be better suited to the VS.NET team, I'm not sure how much the winforms team and the VS.NET team work together. 1) I know this would be difficult to implement, and not even sure if you guys have control over VS.NET, but it would be nice to be able to declare super forms/controls as abstract for visual inheritence AND still ...Show All

• Architecture Top Down or Bottom Up SOA?

  This question has been plauquing me for a while. When attempting to deliver to an enterprise service-oriented strategy is it better to do bottom up governance or top down Here's what I mean by this. 1. With bottom up design governance you work to have any line of business application deliver services at the time they deliver their application. Through the conceptual design and envisioning of this application discrete business functions are found and services can be delivered in front of those functions to provide enterprise re-use. Problems: First of all when delivering services for your own line of business application you have very ...Show All

• .NET Development How use c# ADO.NET to insert the data in sql2005

  using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; private string strconn = @"Server=WINXP-SP2\SQLEXPRESS;DataBase=my;Integrated Security = SSPI"; private SqlConnection conn; private SqlCommand cmm; private SqlDataAdapter da; private DataSet ds; conn = new SqlConnection(strconn); cmm = new SqlCommand(); cmm.Connection = conn; cmm.CommandText = "select *from zhaoheng"; cmm.CommandType = CommandType.Text; da = new ...Show All

• .NET Development Regex.Matches: Slow Processing

  I am using Regex.Matches to match somethings in a txt file, it works fine but when the text size increase it takes ages for the program to match something, if i try the same thing with Regex.Replace it goes fatster but using Regex.Replace ain't an option cause i would have to add allot of Regex.Replace lines just to cover most of the possibilities that i have. So i would like to know if there is any other way to make the Regex.Matches work faster. Here is an example of the code i am using: MatchCollection matchs = Regex.Matches(data, ".+was .+\n|.+rode .+\n|.+accepted .+\n|.+ate .+\n"); (Moderator: Thread moved to the Regular Expres ...Show All

• Visual Studio Team System config file for App Under Test is not used when executing test

  I have found what I think is a bug in the Unit Testing Framework: If your App Under Test (AUT) has its own config file, that config file will not be used when you run a test against it from within the IDE's Test View. I have a complete Visual Studio solution which demonstrates this behavior if anyone wants me to email it to them but here is the gist of the example: I have an AUT which has an app.config file that contains a string value: Test_String="Hi There" < xml version="1.0" encoding="utf-8" > <configuration> <configSections> <sectionGroup name="userSettings" type="System.Configuration.UserSettingsG ...Show All

• SQL Server terminal session name

  Is there any way in stored procedure to find out a name of terminal session initiated connection to SQL Server Thanks for response Hi, try SELECT HOST_NAME() HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual C# How to raise a ready control's event

  Is there a way to raise button's click event by code. For examples, button 1's click event maybe used by many place, Another button 2, if user click, is there a way to raise button 1's click event. button1.Click += ...... .... void Button2_Click(Object send, , EventArgs e) { How to raise button 1 event Don't know button1.Click event handler is used by other code Want boradcast event to all listeners } Great post. But what if you don't know a priori that it is button1 that you want to click What if the program makes a choices of button1, button2, and button3 all of which are currently non ...Show All

• Windows Forms Help needed dinding a datagrid to properies of a business entity (including relations)

  The following question is the same as the one found here: http://forums.microsoft.com/msdn/ShowPost.aspx PostID=55284 I want to use a datagrid to display a list of contacts related to an organisation. I want the data to be updatable. A contact is stored in the DB in the following way (slightly edited for ease here). Table Contact - ID, OrganisationID, JobTitle, Name Table ContactTelephone - ID, ContactID, NumberDescription, Number As you can see a contact can have multiple telephone numbers. The relation exists in the buisness entity and on the database. I want to display a table with the following columns: Job Title, Name, Teleph ...Show All

• Visual Studio Express Editions Win2000??? -- will it work

  Will VS Express web edition and sql 2005 express all work on Win2000 if so, does it require a specific service pack for win2k D ...Show All

• .NET Development overview of .Net classes

  Hi, where can I obtain an overview of the .Net-classes in a graphical form (as existed for MFC), or on a poster thank you Chris Have not seen a graphical representation...the closest overview is: http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/cpref_start.asp ...Show All

• Visual Basic FIleOpen Dialog - fileopendialog.showdialog() - Change default view from List to Details

  In my app a user can mouse to File Menu - Open. The fileopendialog.showdialog() has default view of ListView. The user is alway going to have to sort the file list by Date in descending order in order to open the most recent file stored in the network location. How can I make the FileOpenDialog display in Detail View by default and not List View. Thanks, MIke Code Sample dlgOpenFile.InitialDirectory = sDefaultDir dlgOpenFile.FilterIndex = 0 dlgOpenFile.Filter = "All Files|*.*" dlgOpenFile.Title = "Open PO File" If dlgOpenFile.ShowDialog() = Windows.Forms.DialogResult.OK Then 'other ...Show All

• Windows Forms Pass user-specified parameters from windows form to class. HOW?

  Dear all, I have 2 separate code files in a C# project, one of it is a window form and the other is a c# class file.. I want to pass certain parameters entered by the user in the form to the class for it to proceed operation. How do I do that Thanks alot. Class Form1 : Form {     void button1_Click(...)     {         MyClass o = new MyClass();         o.String1 = "Hello";         o.String2 = "World";         o.SomeMethod();    ...Show All

• Visual C# c# to vb.net

  What is going on. When c# first came out M$ was pushing users to move to that. Now I see an article that show that you can now translate c# to vb.net.   http://msdn.microsoft.com/vbasic/default.aspx pull=/msdnmag/issues/06/02/PasteAs/default.aspx   why does it seem like vb.net is being pushed so much more in the 2005 version. I just decided to move to c# from vb.net because of the following. 1.forced declaration of variables 2. told it was better language for businesses (reguardless that vb can do the same) 3. was told c# is more professional where vb.net was used more as hobbiest. 4. Pay is larger 5. Mor ...Show All

• Visual Basic Storing Drag and drop items

  Hello All. I have a "Consultation" form in my VB.NET application. It is meant to catch a history of consultation with a client regarding a project application that they made. When a client files an issue with the company they may include emails, excel documents, pdf's and even (in the future) items for systems not yet written, and so forth. The consultation system goes like this: A Customer/client is a member of an organisation. The client makes the application for funding on behalf of the organisation. If there are any issues like, for example, the application is not filled correctly or completely, or the payments for funding fell down a bl ...Show All