Dave Byrum's Q&A profile

• SQL Server I found a bug in Sql Server 2000！！！

  Yesterday I created a table in Sql Server 2000,using this script： CREATE TABLE [dbo].[User]( [Id] [int] NOT NULL, [UserName] [nvarchar](20) NOT NULL, [TrueName] [nvarchar](20) NOT NULL, [Password] [nvarchar](60) NOT NULL, [Department] [int] NOT NULL, [Mobile] [nvarchar](20) NULL, [Telephone] [nvarchar](20) NULL, [Remark] [nvarchar](200) NULL, [Enabled] [bit] NOT NULL, [Available] [bit] NOT NULL, CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED ( [Id] ASC ) ON [PRIMARY] ) ON [PRIMARY] There was only one record in it: INSERT INTO [User] VALUES(1,N'SUP',N'Jim',N'213123',1,NULL,NULL,NULL,1,1) After I executed this script： UPDATE [User] SET UserName=N'f',TrueName=N'gg',[Password]=N'dfsdfsdf',Mobile=NULL,Telephone=NULL,Remark=NULL, Ena ...Show All

• Software Development for Windows Vista Simple SM Workflow Action Doesn't Seem Possible... Need Help

  I have a pretty simple state machine workflow. When I transition into State B, I want to delay 20 seconds and then shift into state C. I tried to do this by dropping a stateinitialization activity into state B. I was then going to drop a delay activity into the initialization activity ... but that didn't work - it won't let me drop the delay activity anywhere. I am sure I am just missing something really goofy - how do I hold state B for 20 seconds and then transition to state C every time the WF transitions into state B ...Show All

• Visual Studio Team System Where to get Microsoft.TeamFoundation.WorkItemTracking namespace document and library?

  Hi all, I want to build a "What Is New" page on my internal development web site. The page will list the ChangeSet and the work items relative the changeset. How can I get the work items by a ChangeSet ID from TfsWorkItemTracking database Thank a lot Bill I didn't find the Version Control Object Modal from my VS 2005 SDK. Where is the Microsoft.TeamFoundation.WorkItemTracking namespace document and library ...Show All

• Smart Device Development Performance System.DateTime.Now

  Hello The API function GetSystemTime(out st); (PInvoke) is about 1500 faster then System.DateTime.Now; System: WinCE50 on ARMV4I TestCode: using System; using System.Data; using System.Runtime.InteropServices; namespace DateTimePerformance { public struct SystemTime { public ushort wYear; public ushort wMonth; public ushort wDayOfWeek; public ushort wDay; public ushort wHour; public ushort wMinute; public ushort wSecond; public ushort wMilliseconds; } /// <summary> /// Summary description for Class1. /// </summary> class Class1 { [DllImport("coredll.dll")] public static extern void GetSystemTime(out SystemTime st); /// <summary> /// The main entry point for the a ...Show All

• Windows Live Developer Forums Support for geocoding from Address to LatLong in FindLocation method

  Hello all, New to the VEMap api, and a current junior developer; I was wondering how any of you manage to get the latitude,longitude after a search using map.FindLocation(...). Clearly there is no support for this as the VESearchResult.LatLong object returned defines the values for latitude/longitudes as undefined. Secondly even after getting the location centered on after a search, I need the result synchronously delivered to my application. Unfortunately it's said in the API that a result is returned and that a call back is optional. Well I tested in javascript the returned value: null/undefined again. Is there a way of getting geocoding done for an address in VEMaps on a search. Do I need to use a call back which spawns mult ...Show All

• .NET Development cannot install 'Security Update for .NET Framework v1.1 sp1 (KB886903)'

  Hello, Just got a new computer running Windows XP Pro. After running windows updates, I've downloaded the Security Update Microsoft .NET Framework, v1.1 sp1, but every time I try to install it fails. http://support.microsoft.com/kb/824643/ I've searched and tried to solve this issue, but nothing has seemed to work: unregister/reregister Windows Installer, manually remove/reinstall NET framework 1.1. I have not been successful at 'repairing' the framework using the cmp, because I cannot locate anything using cmp. Help. All advice is greatly appreciated. And thanks! The sticky is here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=880553&SiteID=1 ...Show All

• Visual Studio Express Editions Questions about Checkbox Column in DataGridView

  I have two questions regarding a checkbox column in a datagrid view on a form. 1. Another column in the datagridview is a buttoncolumn. When you click on the button in a particular row, it opens another form, inserts data from other columns in the specific datagridview row, and allows the user to input additional information. The checkbox notes whether additional information has been entered or not. Right now, when you click on the button, the form opens whether the checkbox is checked or not. I only want to have the form open if the checkbox is unchecked. How do I check to see if the checkbox is checked before I run the proceedure to open the form The name of the checkbox column is DataGridViewCheckBoxColumn1. I've tried an If Then st ...Show All

• Visual Studio Express Editions @dennis - Straw Man Example: getpwd

  can u suggest me a standard method to input a character from keyboard with echo and without echo....like _getch() and _getche() functions. what i mean is these functions are supported by vc++ 2005 express edition but are non standard and hence the code and exe wont be portable. i know that in standard c++ there is no method for above problem .but i want to create functions which are standard and which i can include every time when i require keyboard input i.e i wanna make 2 functions equivalent of _getch() and _getche(). kindly help desolate wrote: yes Dennis i agree with you and i want to experiment with this approach i.e make custom functions using names of our choosing. The definition of the functions will use platform-s ...Show All

• Windows Forms Problem adding row to a datagridview using the BindingNavigator

  I have problem adding row to a datagridview using the BindingNavigator.. This is what I have: Bound datagridview with 2 columns both not null but without default values and the user add new rows using the add button of a Binding Navigator. The form use the dataerror handler to handle the wrong data inserted in the datagridview. This is what happens: I click once the "add row" button and an empty row is added at the end of the datagridview. If I click again the button, without to enter any data to the previous row, the application crash and displays me an unhandledexception. I was trying to handle it in the CellEndEdit event: Private Sub datagrid_CellEndEdit( ByVal sender As Object , ByVal e As System.Windows.Forms. ...Show All

• SQL Server SSIS logic for storedprocedures

  Hi,       Do you have any suggestions of how to transform the below code in SSIS       I guess we should use foreach loop container...... also i would appreciate if you can post some related articles.   Hi, Thanks Jamie... yeah i tried foreach loop that collects input from mergejoin onto a variable(say variable1) and stores in another variable(say variable2)....now how should i access the recordset or resultset from variable2 into foreach loop. In other words, assuming that the foreach loop container works properly which actually should output the merge resultset into a variable. Now could you tell me how can i access the fields from r ...Show All

• Windows Forms Concurrency violation help me please

  hi i use vb.net 2005 and an access database i connect to one table and change many things on the table and then save it again i use the disconnected mode i disappointed i try to solve the concurrency violation like the msdn said (get a fresh copy of the table and merge it to the worked one)but it sometimes save and sometimes not !!!!! although im one user for the database help me thanks in advance. Hi, I'm just taking a wild guess here, but could it be that you have a call to AcceptChanges(), on either the DataSet or the DataTable, within your own code Concurrency exceptions mean that the INSERT, DELETE or UPDATE commands in the DataAdapter has affected 0 rows. When using optimistic concurrency, the WHERE clause of those quer ...Show All

• SQL Server SQL Server 2005: Named Instances/Different Editions

  Hi, We are planning on implementing a high availability solution for critical systems using database mirroring. The SQL Server instances hosting the mirrored copy will be located on servers already licensed for hosting the primary copies of other databases. I understand that we can run multiple instances in a single OS and only have to license the SQL Server once. I also understand that instances used for failover only don't have to be licensed. We will likely have the following scenario: SERVERA MSSQL1A.PrimaryHost Enterprise Edition MSSQL2B.FailoverHost Standard Edition SERVERB MSSQL1B.PrimaryHost Standard Edtion MSSQL2A.FailoverHost Enterprise Edition In other words, some databases on SERVERA i ...Show All

• Visual Studio Team System Error: The server version and database compatibility level of deploy target is not supported.

  Hi, Yesterday I changed a script in my database project. It was something really simple, like changing the default value of a column. Suddenly my project doesn't build anymore and gives the following error: "The server version and database compatibility level of deploy target is not supported." The project version is set to SQL Server 2000. When I change to SQL Server 2005 I get a warning, but I can still build: "Warning TSD250: The column [SomeColumn] on table [dbo].[SomeTable] is being truncated. There may be loss of data." This column is of type ntext. Any ideas what might cause this BTW, I'm working with CTP7. Thanks, Jeffry You're not changing the build target on th ...Show All

• Windows Forms How to Validate a Serial Number or PID in MSI Setups Created in VS.NET ?

  I have been searching all over the net, and I can't find this information. I want to validate a PID before the installation proceed (as most of the microsoft setups). I want to do this in C# but I can't find the pieces of the puzzle. scenario: call a web service when the user hits next, if the returned value is Ok the setup may continues otherwise not. That easy. Thanks for any help! mario thanks man. So this implies that there is no way [using MS msi] to implement a setup like Microsoft does. Ask for a product key and validate the key before the setup proceed. Am I right ...Show All

• SQL Server Dropdown won't show values if only one item is available

  I have a report that has 2 dropdowns, selecting from the first dropdown populates the second one. This works fine in the BI Studio. When I deploy this report to the 'Report Manager' and make a selection from the first dropdown, the second dropdown loads (as expected). I tried to select from the second dropdown (which has only 1 item - which is correct), the dropdown does not appear correctly - as in, I can't see that item. Since we can't attach anything here, below is the link to a screenshot of my issue: http://docs.google.com/View docid=ddd6j2xn_52c5qd5 If you look closely at the screenshot from the link above, you'll see that there is a value in the second dropdown - it just won't show completely - as if the dropdown is not re ...Show All