Andy Britcliffe's Q&A profile

• .NET Development Some how the update command is not working.

  Hi, im using Web Forms Im trying to update the database but the query is executed correctly and th database is not updated but the returned message is 1, I really dont know whats causing this here is my code. private void UpdatetheDatabase( string connection) { SqlConnection connect = new SqlConnection (connection); SqlCommand update_customer_details = new SqlCommand ( "UPDATE [app_CustomerDetails] " + " SET [Name]=@Name,[City]=@City, " + " WHERE [ID]=@ID" , connect); update_customer_details.Parameters.Add( "@Name" , SqlDbType .NVarChar, 50).Value = txtCustomerName.Text; update_customer_details.Parameters.Add( "@City" , SqlDbType .NVarChar, 50).Value = txtCi ...Show All

• Visual Studio Deploying problem

  I have a report that works excellent locally on my computer. But when I deploy it to my webhost it is not working anymore. After I searched the web, I have manually deployed the three .DLL-files to my bin-directory. Since this wasn't solving my problem I had the webhost to install MS setupkit for reportviewer on the webserver. But I still got the same error message. ' An error has occurred during report processing. Exception has been thrown by the target of an invocation. Object reference not set to an instance of an object. ' Anyone has an idea on whats going on I finally solved this. It was my own fault. T I'd miss to copy he connectionstrings section of the web ...Show All

• SQL Server SQL Server 2005 Management Studio Usability

  I have a strong feeling SQL Server was released without any usability testing, forgive the rant but SQL Server Management Studio really needs rebuilding, and I've got to the point I'm *so* frustrated with it, that in most cases I have developed my own web-based tools to manage SQL Server, especially on production environments where Management Studio is simply unusable. I have to say, after so many years using the tried and tested Query Analyzer and Enterprise Manager, Management Studio is several steps in the wrong direction. 1) General Performance: Right now, I'm still using a PIII, and it's ridiculous how slow Management Studio is in comparison to EM and QA - it can take 5 seconds for the 'modify' menu item when right-clicking on a ...Show All

• SQL Server Logging in SSIS

  Hi: Just implemented logging on my package, and the type of logging is to a text file. Any ideas on where should i store my log folder/file, so when I do my build and deploy, I end up moving the folder as well. Do I have to manually do that How would that work What if I save the log file outside of my project folder Where is the log folder/file path specified Thanks. When you set up the logging you created a connection manager to point to the log file right Then all you need to do is to make sure that connection manager is properly configured in the new environment; meaning that the path you specified exists and the user executing the package has access to it. You could use package configuration to set up the connection man ...Show All

• Smart Device Development URGENT: Unknown file 'Microsoft.WindowsMobile.Utilities.dll'

  Hi there, I'm currently writing an application for the Windows Mobile 5.0 platform. I'm using VS2005, C# and CF 2.0. When I deploy my app, there is a missing library on my customers PDA. This library is 'Microsoft.WindowsMobile.Utilities.dll'. I have searched my disks, but can't locate it anywhere! Does anyone know this library and how to get it best regards Reiner Peter, the PDA of my customer IS a WM 5.0 Device! Although it is a few months older and from a different OEM. The most important difference between the two devices is: my Device is a "PocketPC", the customers device is a "Smartphone"! The most important question for me now is: what can I do best regard ...Show All

• Visual Basic resize Mainfrom via mouse from lower right hand corner of form?

  The MainForm of a windows app has a triangular dot symbol in the lower right corner. A mouse left click should bring up a diagonal arrow and then dragging the mouse up and to the left ( or left and up) should shrink the mainform, moving the right and bottom borders up while the left and top remain unmoved. My form is not shrinking at all Is there a property I need to set, or uncheck I see a Me.Height and a Me.Width but I don't see any other relevant properties to change if I were to do this using MainForm_MouseDown MainForm_MouseUp MainForm_MouseMove any ideas Here are what I think might be relevant code form MainForm.Designer.vb Me .AutoScaleMode = System.Windows.Forms.AutoScaleMode.Inherit Me .AutoSize = ...Show All

• Windows Forms Concurrency violation

  hi, i am new in visual studio and i try to make a program but i have a problem: i use an access database and i have 2 tabels in relation and when i try to delete a row from one i receive msg " Concurrency violation: the DeleteCommand affected 0 of the expected 1 records." this is my code Private Sub BindingNavigatorDeleteItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BindingNavigatorDeleteItem.Click Dim gol = Me .DataGridView1.RowCount() If gol = 0 Then Exit Sub End If dim msj msj=MsgBox( " Soll es wirchlich geloscht werden " , MsgBoxStyle.OkCancel, "A C H T U N G !" ) If msj <> vbOK Then Exit Sub ...Show All

• Visual C# Treeview in ASP.NET

  i want to show user in treeView according to groupwise Hi I am assuming that you can bring that data form the database to A dataset that said i also assumed that your dataset structure will be as follows E Users (Users) E UserId Id E UserName string E GroupId string E Group (Group) E GroupId string A Group Name string where GropuId is a PrimeryKey and the two tebales are linked with the GroupId key of the corospondong table the realtion ship is called GroupsUsers. let us name the abouve group as DataSe ...Show All

• Visual C++ pdh.h - Error Occured

  When I include the pdh.h header file I recceive the following error: error C2040: 'HLOG' : 'void *' differs in levels of indirection from 'struct _HLOG' The error occurs in the header file. Any idea what could I be doing wrong Thanx in advance The only programmers that are better than C programmers are those who code in 1's and 0's..... Programm3r   pintu* wrote: [...] Actually VC6.0 Doesn't Contain any File With name <LMJoin.h> [...] Nevertheless the erroneous line 50 " typedef HANDLE HLOG "  seems to be in PDH.h file from Visual C++ 6.0. Maybe the author mixes files from different versions of Visual Studio   ...Show All

• SQL Server Reinstall Sql Server Express After Developer Edition

  I had to uninstall SQl Server 2005 Developer Edition because of hardware requirements, and reinstall Express Edition download version. But SQL Server Database Services fails with this message: SQL Server Setup has determined that the following account properties are not specified: 'AGTACCOUNT' . Error Code: 28006. The first time I installed Express the flow of setup ended well without any message. How to act Try to call the commandline with the additional parameter AGTACCOUNT="NT AUTHORITY\LOCAL SYSTEM". If you use an ini file your will have to put the appropiate setting in there. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual C++ Setup and Deployment Projects missing

  hi, i have download and intalling visual c++ 2005 and Setup and Deployment Projects template it’s missing. Can someone tell me how can i get it If you mean you've download Visual C++ Express, deployment projects are not supported in any Express version of Visual Studio. You'll have to purchase one of the versions of Visual Studio like Standard, Professional, etc. See http://msdn.microsoft.com/vstudio/products/compare/ for a feature comparison of all versions. ...Show All

• Visual Studio Problems with creation a package

  Hi! I've modified a sample for creation template for new project type. This one is located in Visual Studio 2005 SDK\2006.04\VisualStudioIntegration\Archive\CS_Samples\Project\Project folder. I've added some new items and files to the project. Also I've changed all GUIDs I found in the solution and renamed all entries of "MyProject" to "SergeyProject", but in debug when I tried to create my project I saw that "SergeyProject" is absent in project templates but "MyProject" is present (without all my changes to it). Why This is my first package, so please don't beat me hard :) Could you give me some links to the FAQ, help or something similar, because SDK help looks very strange and old. Maybe you have a document for b ...Show All

• Windows Forms DataRow Values Not Updating In Loop

  I am looping through a DataTable and if the columnName matches the control name then I want to bind the control to the data. The reason I am looping and binding dynamically is because there will be multiple rows and there is an ID in each row that will correspond to a part of a control name. Some controls will not be bound while others will. The code is running but the same data row binds to all controls, as if the loop is never moving to the the next row. Can anyone spot why Also, I'm open to any easier methods: int count = 0; try { DataTable dt1; dt1 = usmDataSet_survey2.Tables["parts_survey"]; foreach (DataRow row in dt1.Rows) { count++; foreach (DataCo ...Show All

• .NET Development Modify System.Exception in SetILFunctionBody

  I am wondering if I can get some help on this. We have working "Proxy" that is invoked via insertion into methods and gathers all the calling arguments, etc. and passes to a handler. We are using the SetILFunctionBody during JIT compilation. It works fine for 1.1, but in 2.0 ONLY works when using LoaderOptimization other than SingleHost when hooking corlib methods such as the System.Exception .ctor. We are hooking many methods - all NON core methods work well. I have come to the conclusion that it has to do with Domain Neutrality of mscorlib (only) being in the shared domain. So, my questions are this: Other than the LoaderOptimizationAttribute OR the args to the CorRuntimeBindEx to load the CLR - how can one override the Loade ...Show All

• Software Development for Windows Vista Examples of using Persistence and Tracking in ASP.NET

  Hi, For Tom Lake's example of: Examples of using Persistence and Tracking in ASP.NET Why all samples seems related to Persistence Service only No code is about Tracking (except Web.Config), such as Create or Insert profile, am I right Andy Ho If you need tracking samples the June CTP contains a number of tracking related samples. Samples\Technologies\Tracking has a set of samples on individual tracking technologies. For full fledge sample tracking based applications see the TerminationTrackingService, TrackingProfileDesigner, and the WorkflowMonitor in Samples\Applications. Thanks, Joel West MS SDE in WF runtime and hosting in Samples\Applications ...Show All