mnlarsen's Q&A profile

• .NET Development SQL UPDATE - "No value given for one or more required parameters"

  I've used this structure in several other C# database programs with success, until this app.  Now I'm receiving this: "No value given for one or more required parameters." The key is SAMS_ID. The data is text, no numeric fields.  The code I used is below.  I've tried removing the single quotes from around the date field and also from around any fields that contain numbers but still receive the same error. Anyone know what I am forgetting private void buttonEdit_Click ( object sender , System . EventArgs e ) {     string strEditConnect = "" ;     if ( buttonEdit . ...Show All

• Visual Studio Express Editions Printing data

  I have downloaded the free version of Visual Basic 2005 Express Edition from MS, previously I used Delphi. I can build a database, using a datagridview to display records, but there is no Report tool to do any data printing with. There are some net tools ie Print Preview control, Print Document etc but nothing like a Report function. How can I print off my data How to: Complete Windows Forms Print Jobs ms-help://MS.VSExpressCC.v80/MS.NETFramework.v20.en/dv_fxmancli/html/23ec74f7-34c5-4710-82a0-ee2914518548.htm How to: Create Standard Windows Forms Print Jobs ms-help://MS.VSExpressCC.v80/MS.NETFr ...Show All

• Visual Studio Team System Visual studio locking up when doing TFS stuff.

  Hi, I am wondering if anyones else is having a similar problem as me. It seems at certain times when I do various actions (getting latest code, checking in something) the action completes and then Visual Studio locks up to the point where I have to kill the devenv.exe from the task list. It has happened to me quite a few times now. I am running the VPC image for the server and have installed the TFC from the en_vs_2005_tfs_trial.iso file. I really like the product and have convinced my manager we should move to it but I can't really do that in good faith if the team is going to lock up frequently. Cheers, Clint It is true t ...Show All

• Visual Basic How to update timestamp - Please help

  Hello All, I am new to VB.NET (was a VB 6 programmer for the last 8 years). In my database, I have a CreatedBy, CreatedTime field in my "Transaction" table. CreatedBy should be updated with the currently logged on UserID. CreatedTime field should be updated just before the user clicks on "Save". I simply dragged and dropped the "data table" on the form and VB.NET created the grid and also generated all the code for me [Great feature]. However, I do not want the user to type in the value for "UserID" or "Created Time". Instead I would like to do that behind the scenes just before the data is ...Show All

• Visual Studio Team System Measuring decision coverage

  Hello VSTS supports measuring of statement coverage. Are there plans to add support for other code coverage measures as well Of practical interest for me is decision coverage. Has anybody experience with other coverage measurment tools like Clover Thanks Adrian Hey Adrian, Our code coverage tool only currently supports block coverage (which is basically statement coverage, except that we handle composite statements like if(A || B && C) as three seperate blocks as opposed to one statement). We are looking at evaluating some other metrics for future releases. May I ask, what exactly i ...Show All

• .NET Development how to convert?

  With store_db_connection If Val(store_id) = 10 Then ServerName = "192.001.1.16" Else ServerName = "192.168." & Val(store_id) & ".16" End If .Provider = "sqloledb" .Properties("Data Source").Value = ServerName .Properties("Initial Catalog").Value = DatabaseName .Properties("User ID").Value = UserName .Properties("Password").Value = Password .Open() end with Can any one convert this code from vb6 to vb.net for me.i will appriciate it Imports System.Data.SqlClient Dim Store_ID As Integer = ... Dim InitialCatalog As String = ... Dim UserId As String = ... Dim Password As ...Show All

• SQL Server Mission Impossible ? Pivot Table at front end Excel

  I have a table with this field headers Product/Status/USD:- A/Actual/100 A/Budget/90 A/Variance/10 I have created a Pivot Table in Excel with Product as row field (A or B) Status as Column field (Actual, Budget, Variance) USD as Value It looks fine like this but I need to create a column called Variance % which is (Variance/Budget x 100%). Please urgently advise how to create this new % column within Pivot Table. Thanks. Sorry it seems a bit more about Excel but can't get answers in Excel forum... I am not using SQL Server. help... Sorry, but I think your chances better off with trying Exce ...Show All

• SQL Server Snapshot Agent - Error: Query for data failed

  We've got a problem with our replication. If I try to run the snapshot agent I get the message "Query for data failed". The detail view of this message shows the following: Message: Query for data failed Stack:    at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException()    at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause)    at Microsoft.SqlServer.Repli ...Show All

• .NET Development Searches IN vb.net and access

  Im currently developing a booking system. I am the point now where the allocations are made. however i want to install a facility whereby the product cannot be booked by a customer if it is already booked for the particular day/week. How would go about doing this I know that i should do a DoWhile loop. But in doing so will it check all the entries of a given product in the booking table or stop at the first one it finds How would i code this so that it looks inside the booking table If someone can provide me with sample code of how i could do this, i would be very greatful. //I know that i should d ...Show All

• Software Development for Windows Vista Recognizing Gestures?

  I asked this over in the Avalon area, but it's really a tablet-and-WPF thing, so here goes... Can someone point me to an example of how to recognize simple gestures in WPF I've read lots of "Ink is buit-in in Avalon!" articles, and I've watched presentations that go even as far as using InkAnalyzer to recognize hand writing -- but all I'm looking for is something like recognition of a strike out, and I can't find one for a WPF app. The tantalizing Gesture attribute is there, but I have no idea how to use it! I set my InkCanvas EditingMode to InkAndGesture (or to GestureOnly) and still, no matter what I try, no calls ...Show All

• Visual Studio Team System TFS beta 3 installation

  So where is TFSQL2005AnswerFile.ini referred to in the installation guide And is /inifile: actually supported for unattended install of TFS http://blogs.msdn.com/robcaron/archive/2005/09/29/475530.aspx For Beta 3, there was supposed to be an .ini file in the Team Foundation Server image for installing SQL Server 2005 silently from the command line. As fate would have it, that file never found its way into that image. I just finished posting it to the same download page as the Installation Guide. You can download it here: Long: http://download.microsoft.com/download/c/a/d/cadd2e76-38aa-4b61-9921-8acb710 ...Show All

• SQL Server Report Designer - Writing Mode tb-rl resulting in improper word wrapping in pdf

  I'm using Visual Basic .Net in Development Environment 2003 Version 7.1.3088, .NET Framework 1.1 Version 1.1.4322 SP1 and SQL Server Report Designer Version 8.00.1038.00. I have a text box containing multiple lines of text using the Writing mode tb-rl; the report is landscape with that text box oriented portrait. The text properly rotates 90 degrees and the words break appropriately at the end of each line when looked at in the report. It's also fine when exported to Excel. But when it's exported to pdf, the lines break in the middle of words; it looks like a forced full justification without regard to where the word breaks. For example, &q ...Show All

• Visual Studio Express Editions Math Help

  I guess I am having a brain-lock but I am having problems subtracting. I have a variable called Money that is an integer with an initial value of 10. I want to subtract from it and show the results in a text box. The text box shows the initial value of 10. For example, I want to reduce it by .25 and then show that result in the text box. However, I've tried it a few ways and either it wont reduce or only reduce one time. Suggestions on a simple way to subtract this I display the amount in txtMoney When I do it this way: txtMoney.Text = money - 0.25 and then try it again, it wont reduce it anymore..just that one time...Suggestions ...Show All

• Visual Studio Team System MSDN Subcription

  This is probably not the best place to ask, but I haven't been able to get an answer from the MSDN folks... Any idea if we will be able to transition our existing subscriptions over to VSTS for DP when it is available I currently subscribe to VSTS Dev. Not being an expert on licensing, but the Team System license model is either based on seperate SKU's like Developer, Test or Architect; or you are have a Suite license which includes today Developer, Test and Architect. When VSTE DB will be released this will be the fourth SKU in the Suite. If you can not transfer VSTE Dev in to VSTE Test today, I do ...Show All

• SQL Server Object info ?

  It's the possible to see which object (table,view,proc) used (not changed) in last year Thanks. This does not come for free, but can be done. You can use DDL triggers to create custom logging of DDL changes, also there is a constant lightweight trace for SQL Server 2005 that tracks DDL changes, but this rolls over at 100MB based on file size, so you would have to extract data from this file frequently to prevent its loss. There is a report in SSMS that shows you latest DDL changes in this file. -Euan ...Show All