Sean D Wright's Q&A profile

• .NET Development .NET 3.0 install or not?

  I'm extremely reluctant to install the .NET 3.0 framework based on the current disaster of the SP1 for VS 2005. Can anyone tell me what "negative" affects I will be hit with if I elect to install .NET 3.0 framework on my VS 2005 dev box Can VS 2005 and my existing projects even make use of anything in .NET 3.0 framework Thanks, Rob. Hi Rob, The .NET Framework 3.0 includes the .NET Framework 2.0, which you already have installed if you are running VS 2005. In addition, it adds some additional features such as Windows Presentation Foundation (WPF), Windows Communication Foundation (WCF), and Windows Workflow Foundation. You should not see any negative effects of installing .NET 3. ...Show All

• Windows Forms Parameter count does not match Parameter Value count.

  Parameter count does not match Parameter Value count. what does this mean...I am trying to update my sqldb...I have all the right parameters...why elese would this come up Tryin2Bgood wrote: Here is my Query for the Update or Insert...its a Save Function() When i insert a breakpoint it shows me the values of whats in the Database but if i add new values to the controls it never has what was added....Like the new data is not being sent at all..... public void Save() { if (_CustomerID == 0) { SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString,"Customer_Insert", new object [] { _CustomerCode, _Attention, _Class, _LoadType, _VehicleType, _TermNumber, _Status, _Commodity ...Show All

• SQL Server Unable to connect SSRS to other SQL2000 & SQL2005 servers

  I'm able to build data sources and models through the reporting services web site for the local server that SSRS is installed. When I try to create data sources and models to other SQL Server installations (both 2000 & 2005) I recieve the following error message when trying to create the model: Cannot create a connection to data source ''. (rsErrorOpeningConnection) Get Online Help Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. My connection string reads: Data Source=server01;Initial Catalog=OLTPDatabase I left the connection type as 'Microsoft SQL Server' and I'm using 'Windows Integrated Security'. I'm logged in as domain administrator. Thanks, Doug ...Show All

• SQL Server Stored procedure issue. a bridge too far for me

  i have a query that i need to extend but just dont have the knowledge to do so, so hoping someone here could help me this is my current query:- SELECT ES.PatientID, DATEDIFF(day, EP.DateofBirth, GetDate())/365 AS Age, CASE EP.SexCode WHEN 'M' THEN 'MALE' ELSE 'FEMALE'END AS Gender, COUNT(H.HRDID)AS HRD, ES.FourRegularDrugs, isnull(ES.FourRegularDrugsNo,0) as NoOfDrugs, ES.ReadmissSixMonths, PCE.[Primary diagnosis] FROM tblStudyServices ES INNER JOIN tblPatient EP ON EP.PatientID = ES.PatientID INNER JOIN PAS.dbo.[PAS Patient Details] PP ON PP.[PAS key] = EP.PatientInternalNumber INNER JOIN PAS.dbo.[PAS Admission Details] [PAD] ON [PAD].[PAS key 1] = PP.[PAS key] INNER JOIN PAS.dbo.[PAS Consultant Episode] PCE ON PCE.[PAS key 1] = PA ...Show All

• SQL Server How to dublicate a row ?

  I am transferring data from one database to another directly with some minor changes. But in one step i need to dublicate a row (if a column value satisfies a condition). How can i achieve this without using "Multicast-Conditional" split (which requires dublication of all rows and then condition proceeds!). By the way the reason i don't want to use Multicast is the table i am processing has about 20 columns and 20 M rows :( Thanks in advance ! You could use an asynchronous Script Transform. In an asynchronous transform your are responsible for reading the input buffer rows and adding them to the output buffer, so you can do this conditionally, one or more times for each input row. They are a bit painful I find as y ...Show All

• SQL Server how to improve this transaction

  Hello, I have four different transactions such as below and I do one insert and one update in each transaction and it seem it is slow and creates deadlock with the user interface. These transactions are performed against the tables that users are accessing with another user interface. I have following two questions: 1. T2.TextField1 and TextField2 = @TextField2 are Ok, Nok fields so I did not put index since only two distinct values. Should I put indexes on these fields 2. Can I make this transaction let user interface do its task in case accessing the same rows, I can start transaction again but I do not want users get disturbed . BEGIN TRANSACTION pTrans BEGIN INSERT INTO T1 ...Show All

• Software Development for Windows Vista Problem with DependencyProperty

  Hi I have this dep. prop. in a Custom Activity public static DependencyProperty SucceededProperty = DependencyProperty .Register( "Succeeded" , typeof ( bool ), typeof ( CreateCustomer )); [ DesignerSerializationVisibilityAttribute ( DesignerSerializationVisibility .Visible)] [ BrowsableAttribute ( true )] [ CategoryAttribute ( "Parameters" )] public bool Succeeded { get { return (bool)(base.GetValue(SucceededProperty)); } set { base .SetValue(SucceededProperty, value );} } In the Execute method i do something like this: Succeeded = true; But i does not seem to have any effect. How come And second. How do I do it right Thanks in regards Anders, DK ...Show All

• Visual Studio XML Comments File for ASP.NEt 2.0 Application

  Hello, this Qs might have poppued many times but i couldnt find it....with VS 2005 for class libraries while building the dll i have the option o building xml comments file. But in the build option for asp.net web application i did not find the xml comments file build options. Can anyone tell me how to get the xml comments file. This is a huge project so it is difficult to take the pre-compiled exe for each file and try to generate xml using sandcastle. Any help is appreciated. thanks!! sqlnew ...Show All

• Visual Studio 2008 (Pre-release) Propogating inherited DPs to the adorner layer

  I have a TextBox whose adorner layer has an adorner which contains a ListBox. The ListBox displays strings (suggested spellings for misspelled words in the TextBox). When the user spells a word incorrectly, they can press F1 to display a list of suggested spellings in the adorning ListBox. After they select a suggestion, the typo in the TextBox is replaced with the selected suggestion. That part works. I'm having a problem with visual settings. If I'm not mistaken, the adorner (and, hence, the Listbox) is not in the Window's visual tree. That means that the inherited dependency property values of the Window (let's say the FontSize property) will not propogate to the ListBox. With that being the case, how can I achieve such propogation ...Show All

• Visual Studio Team System TFS on Novell Domain

  Dear forum members, We want to migrate to TFS. Is it possible to use Novell as a domain controller for TFS or do I need a microsoft domain controller (W2K3 ) as a host for user accounts for TFS As far as I know only Windows 2003 and Windows 2000 native mode domain controls domain controllers are supported. Please see http://msdn2.microsoft.com/en-us/library/ms252492(VS.80).aspx for more information. Thanks, ...Show All

• Windows Forms Panel/Form lost focus

  I'm currently using a panel in my form to host a DirectX display. I'm using the Form's MouseWheel event for zooming and the panel's MouseMove for the panning. I've recently added a toolstrip slider to adjust a property in the display. All is working well except for once the slider is used I can no longer zoom using the form's MouseWheel event. I still register the MouseMove events on the panel, but the form's MouseWheel and KeyPress are no longer triggered. What am I missing GrkEngineer Your form has lost the focus and can't get it back. Check this thread for a work-around... ...Show All

• .NET Development GDI+

  I am not sure if its a right place for this thread, sorry, move it if needed and was possible. I am using Drawing namespace and learning GDI+. I want to draw some shapes and paths on the screen. The problem is that a window is always needed to create graphics object. It is just like a prison for the shapes. What is the solution I want my shapes to be seen on the desktop and on the wallpaper for example, not in a window. Thanks. Hi, You need to get the mouse offset first private void Form1_MouseDown(object sender, System.Windows.Forms.MouseEventArgs e) { mouse_offset = new Point(-e.X, -e.Y); } private void Form1_MouseMove(object sender, System.Windows.Forms.MouseEventArgs e) { if (e.Button == MouseButt ...Show All

• Software Development for Windows Vista Which Codecs ship with Vista x64?

  Anyone have any idea which video codecs ship with the x64 edition of Vista Just asking because Indeo5 did not ship with XP x64 and I was wondering if the same was true for Vista. I can't find any MSDN articles that discuss this for Vista. Thanks, -Nick ...Show All

• Visual C# Simple binding to Datarow - values don't update???

  Hi, I have a loop that is populating label controls from a Datatable. If I simple bind the datarow to the labels' Text property, when I update the Datatable I expected the changes to be reflected in the label. This is true if I bind the the table directly. // this shows the correct values but they don't update when I update the data in the table ... templabel.DataBindings.Add("Text", dt.Rows[i ] , "state"); ... // when I bind directly to the table, updating the table does reflect the changes. But this option is no good as all my label controls have the same values. ... templabel.DataBindings.Add("Text", dt , "state"); ... What I'm trying to achieve, is when I update the data in the table the changes are reflected automatically in the bo ...Show All

• Visual Studio Team System Just to clarify TeamSystem license - TFS

  I have been reading a lot of different information about TFS x TeamSystem license model, concerning Cals etc One thing I am almost sure is when we sign for MSDN Premium TeamSystem (whether Suite, Dev, Tester or Arch), we do have rights for 5 CALs to access TFS. Another issue has to do with using this package after expiration. I have posted previously about the possibility of signing for MSDN Premium TeamSystetm Suite, and when renewing, choosing a lower package (tester for instance). In this case, I would not receive any other new features on the other versions (in this case Dev and Arch), but I would be fully license covered to continue using the whole package I had up to that moment. Could anyone from Microsoft confirm this 2 in ...Show All