mneedham's Q&A profile

• Windows Forms The line endings in the following file are not consistent. Do you want to normalize the line endings?

  I'm working on a WinForms app in VB 2.0 I'm getting this error message when I open a user control that I have developed. What does error mean and how do I fix it Whether I choose Yes or No, nothing seems to happen, and I still get the error the next time I open the control. Hi, I have the same exact problem in Visual Studio 2008 Beta 2 and also Visual Studio 2005 when I receive updated code from my other co-developer. He is also using Visual Studio 2008 Beta 2. I was wondering what causes this problem. Thanks, McoreD ...Show All

• SQL Server How to enforce SQL Server 2005 to use Worktable?

  I have a problem in SQL Server 2005. In some cases SQL Server produces an execution plan of complex query (8 joins of views, some of views contains couple of joins) which does not contain a woktable creation in tempdb. As a result time of query execution increasion for about 5 seconds to about 4 minutes. All necessary indexes are created. It sims all data located in cache. Is there any way to enforce SQL Server to create worktable Query SELECT [a0].[id],[a0].[Priority],[a0].[Heading],[a0].[DocumentDate],[a0].[LastName],[a0].[FirstName],[a2].[Name],[a1].[Position],[a4].[ContactTime],[a4].[Subject],[a0].[WorkPhone],[a0].[MobilePhone],[a0].[FaxNumber],[a0].[PrimaryEmail],[a5].[ContactTime],[a6].[Value],[a7].[id],[a7].[id_class],[a8].[id ...Show All

• SQL Server Calculating the average over time

  Hi all, As a follow up for my previous post about calculating the number of active subscriptions at any given moment ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1147061&SiteID=1 ) an other 'newby question'. With the measures from my previous post I managed to make two calculated members: [ Active subscriptions SoP] and [Active subscription EoP] (SoP = Start of Period; EoP = End of Period). What I would like to create is an other member which calculates the average number of active subscriptions for a given period, so I can create an pivot like the one below. At the question marks ofcourse should be the average for the entire week. This however is not equal to (10843 + 10866) / 2 = 10854.5 but equals (10854 + 108 ...Show All

• SQL Server Slow query when run in multiple threads

  Hi, I'm trying to stress test my web application, but when I get high load, the queries that used to take 10-20 ms starts taking 500 - 2000+ ms. Or to put it another way, when i run them single threaded i can do about 43000 a minute, when they are run in paralell it drops to about 2500 a minute. What can i do about this There are severeal queries thats affected, but here is one example: update [user] with (ROWLOCK XLOCK) set timestamp = getdate() where userid = 1'' btw: im running sql server 2005 sp 1. The stress test is run on 3 machines total (web, sql and client) the client is simulation 400 users, cliking a page as soon as the last one is loaded, ie there will always be 400 page requests. Hmmm.. w ...Show All

• Architecture SOA and Banks

  Dear All. What do you think How much SOA is suitable Banking Application Is there any sample or presetation about it In real word, which bank has applied SOA in productiivity How much is extendable SOA Application in a Bank I mean if ISV sold his Bank Application based on SOA, and later Bank's developer may add new Service wtihout ISV's interaction. Thanks in advance. Teymur In the early days we hadn t SOA. It was dificult to centralize reference to data and there logic. We had to copy references and logic in the applications. With updates we also had to update all the applications With SOA we nowdays can centrelize services, which can be consumed by other applications. In this way it just uses the ...Show All

• Visual Studio 2008 (Pre-release) getting the june ctp

  hi all, i just started researching WPF and am looking at building a fairly extensive demo application with it. from what i can tell in my few hours of reading about the subject the Vista June CTP is really the environment to be working in. i have downloaded the July CTP and installed the June CTP tools but it would be really nice to be able to use Cider. i dont understand why the June CTP was pulled from msdn subscriber downloads or if there is a way i can get my hands on a copy at this point but would be really interested in getting some more experienced opinions on how to get it or how to get started without it. All the samples i am finding seem to be done for the June CTP as well :P i was also wondering if anyone knew where i c ...Show All

• Visual Studio Team System Custom History Control

  We would like to add a tab to the work items that is similar to the History tab in its functionality, but only lists times where the work item state transitioned and who did it. I could figure it out by reading the database, but this isn't recommended since the DB schema could change. Also, I would need some way to perform a query when the work item's form is shown. I could add a trigger to modify a custom field that contained the information, but again, the trigger would be referencing the schema. Also, I don't like adding to the database in this fashion. If there is an event that is fired every time a work item is changed, I could have the event call a web service and let it modify a custom field if the state had changed. This s ...Show All

• Visual Studio Team System Omitting Process Guidance stuff?

  So right now I'm running a somewhat customized version of the Agile process template. What I'm noticing is that as I create more projects, every one gets its own duplicate copy of the "Process Guidance" pages, which total a good 5+Meg of "stuff". I'm perfectly happy with keeping *a* copy on my Sharepoint portal in case anybody wants to review it, but I really don't need a copy for each and every project. I'm thinking it's just a matter of tweaking the WssTasks.xml under "Windows Sharepoint Services" to omit most of the files under "Process Guidance", except maybe for the initial "ProcessGuidance.html" file which I can massage to merely contain a link to my "master" copy elsewhere. ...Show All

• Visual Studio Team System SQL Server instance not installed

  I just installed the CTP of Team for Database Professionals with no problem. However, when I try to create a SQL2005 project I get a message box saying "The SQL Server Instance (MSSQL$COMPUTERNAME\sql2k5) is not installed and the the project creation fails. This named instance in fact does not exist (as the message box says, very good work). The problem is: why is the CTP is trying to connect to a non-existent instance and why can't I create the project. Any help on removing whatever I need to get this to work would be helpful. Does the CTP only support SQL Express instances When I attempt to create a new SQL 2000 or 2005 Project, it gives me the message that the MSSQL$SQLEXPRESS instance could not ...Show All

• .NET Development How to get headers only from column names but not value from sql statement?

  Hi all, I was looking to construct an sql statement so that I can have only the columen names as a header but with no data. I have tried like this and it is working. But I don't want to give value like "-1". sqlStr = "SELECT FullGrantNumber, FY FROM Grants WHERE SerialNumber= -1; This statement is giving me the two column names without any value but I don't want to use -1. The data type is int. Is there any other way to achive the same Thank you in advance. HI, Why do you want this Do you want just to get the Headers and place it in a datatable If so, you can use the FillSchema methid of an adapter: SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM myTable", conn); DataTable dt = new Da ...Show All

• Visual Studio Express Editions problem invoking active-x control method.

  sir, I want to invoke active-x control method. The object for which is getting created on use of methods(CoGetClassObject , RequestLicKey ,CreateInstanceLic), but i couldn't able to invoke methods of Active-x control. Here is the code which explains the problem. please suggest me for further action. void CContainerView::OnRButtonDown(UINT nFlags, CPoint point) { IClassFactory* pclsf; IClassFactory2* pclsf2; IUnknown* pUnk; ICalendar* pmydll; BSTR lickey; //for mmcontour clsid static CLSID const clsid = { 0x621464c0, 0x5e90, 0x4da2, { 0x9a, 0x6b, 0x9b, 0x7f, 0xdd, 0x31, 0x91, 0x98 } }; //get the IClassFactory Interface pointer IDispatch *pDisp = NULL; HRESULT hr = CoGetClassObject(clsid,CLSCTX_INPROC_SERVER,NULL, IID_IClassFactory, ...Show All

• Visual Studio Express Editions GDI - moving image between pointA and pointB

  Hello, I'm working on something that visualizes network traffic on a network diagram/map. I basically need to move a ball (bitmap image) between two random  points. I figured I'd look at some 2D shooters to get an idea of 'how to fire a bullet from point a to b'. I thought I found everything I need, i.e. the Atan2, cos and sin, radius and degrees calculations. Basic highschool stuff I guess, but my results aren't accurate.  The ball basically doesn't follow the line correctly. Its path slowly moves away from the line, so I'm obviously doing something wrong. I've tried several different versions but I keep ending up with the same results. Here's the relevant code: Private Sub GDIatansincosTest_Load( ByVal sen ...Show All

• Visual C# C# Book Recommendations

  This sticky here will be used for people to post their C# book recommendations. It will help us keep the forum a bit cleaner than making several topics about book recommendations and also helps everything to be in 1 "spot" and alot of people can see the book recommendations that you have given everyone else in this topic. So please, feel free to post your book recommendations here for developing in C#! :-) If possible, include any links where the person would be able to obtain the book from, and it's ISBN number which would be a big help to everyone! Please look at Amazon and read some reviews, this allways helps. But here are some books i can recommand: As you want to start with the basics, you must start wi ...Show All

• Visual Studio Team System the request failed with http status 404

  when I tried to open the team explorer I got the following error the request failed with http status 404 Good morning: I am new to this forum, and stumbled across this problem.  It appears to be the same behavior that I am experiencing with my new installation of TFS.  I have been pulling my hair out... I am receiving the same error: "The request failed with HTTP status 404". I am receiving this error when I attempt to do anything that needs to connect to TFS through VS...(i.e. New Team Project, Team Explorer). I am prompted to provide the server, which I give, and this message appears rather quickly.  I have attempted the fixes provided above to no avail.  Please let me know if there is anything else I can look ...Show All

• Visual Studio Express Editions Stuck inserting into access

  Hi Guys im stuck updating a selected record in my project :o), i know sql part works(See method 2 for correct statment) as i done it inside access :o) both the pasted methods give me an error Method 1 Dim strTEST As String strTEST = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=N:\Inspectors\Database\Inspectors.mdb" Dim sqlConnection1 As New System.Data.SqlClient.SqlConnection(strTEST) Dim cmd As New System.Data.SqlClient.SqlCommand cmd.CommandType = System.Data.CommandType.Text cmd.CommandText = "UPDATE Region SET RegionID = 1, RegionDescription = 'East' WHERE RegionID = 1" cmd.Connection = sqlConnection1 sqlConnection1.Open() cm ...Show All