Alexander Rust's Q&A profile

• .NET Development Repeatable expression for a comma-separated list

  Is there a way to create a regular expression that would validate something like this: 111-11-1111,222-22-2222,333-3-33,444-44-4444 If I have an expression of ^(\d{3})[\-] (\d{2})[\-] (\d{4})$ for a social security number, I want to be able to repeat that expression for each ssn separated by a comma. This would be coming from a text box the user can enter multiple ssn's separated by commas, so I'm trying to validate the entire string, but each individual ssn within the string. Thanks, --David my apologies if this does not help. Why don't you just take in the string, split it by a comma delimeter or something, then go through each item in the string array and do your regex validation example ...Show All

• SQL Server SQL 2005 Equivalent of SQL 2000 TaskPad VIew

  Hi, u all know that there is a TaskPad view available in SQL 2000 , which provides quite useful GUI about u r server. Is there any equivalent in SQL 2005 http://www.sql-server-performance.com/faq/viewfaq.aspx faqid=141 fyi. ...Show All

• .NET Development DataSet.Copy problem

  Hi! I have a problem with a DataTable that has a DataColumn like this: DataColumn id = new DataColumn ( "Id" , typeof ( SqlInt64 )); id.AutoIncrementSeed = 0; id.AutoIncrement = true ; id.AutoIncrementStep = 1; id.ReadOnly = true ; The DataTable has some rows (id=0, 1, 2, etc.) and I want to make a copy of the DataSet. But when I call the DataSet.Copy method it throws the following DataException: "Cannot convert object of type 'System.Data.SqlTypes.SqlInt64' to object of type 'System.Int64'." If the AutoIncrement=false and I type the values manually it works perfectly. Have you any idea what the problem is Have you tried: DataColumn id = ...Show All

• SQL Server SSIS Inner Join Problem

  I have a Merge Join transofrmation that takes as input Table1 and Table2, which are each OLEDB Sources. Both tables have IsSorted set to true and the join key set to position 1. Table1 contains 242 rows. Table2 contains 61 rows. I connect Table1 and Table2 to my Merge Join Transformation, and slect the join key. For some reason, during transformation, the join is messed up because it spits out 69 records. If I write an equivelent statement is T-SQL, the results are correct: Select Table1.Col1, Table1.Col2, Table2.Col1 FROM Table1 INNER JOIN Table2 ON Table2.JoinKey = Table1.JoinKey The results are 242 because every instance of JoinKey exists in both tables. Having double cheked sorting and data types, I am ...Show All

• .NET Development Does .Net 3.0 include any fixes to 2.0 or is the 2.0 version RTM?

  We have 2 .Net 2.0 hot fixes installed, KB920857 and KB924851. If we point an application at 3.0, will it pick up these hot fixes Or is the 2.0 version that 3.0 supersets just the RTM version Thanks! The .NET Framework 3.0 setup checks for the existence of the .NET Framework 2.0 RTM. If 2.0 RTM is not yet installed, it will install it as part of the 3.0 setup process. In this scenario, your system already has 2.0 RTM + a couple of hotfixes, so running 3.0 setup on that system will cause setup to skip installing 2.0 and only install the remaining parts of 3.0 (like the Windows Presentation Foundation, Windows Communication Foundation, Windows Workflow Foundation, etc). Thanks! Aaron ...Show All

• SQL Server loading old data from Staging

  I'm populating a table (B) in SQL Server from a Staging table (A) using a stored procedure.At any point of time, the Staging table holds 60 months' old data.In the first load of the destination table B, I get 13 months of old data whereas for every subsequent load,I need to load the data for the most recent month and delete data for the 1st(oldest) month. For example, if the load procedure runs on December 02,2006, it should pick data for the month of November,2006 from the Staging table and delete data for the 1st month. I have a column DATA_MONTH_KEY in table B which maps to the column DATA_MONTH in my staging table A. I get the data for the first 13 months using: (B.DATA_MONTH_KEY BETWEEN ( DATEADD(month,-13,@startdate)) AND @star ...Show All

• SQL Server Already open DataReader Error

  I am getting the following error when running some of my reports that use a Report Model on a recently built Windows 2003 R2 server with SQL Server 2005 SP2 intalled. The reports run fine our SQL Server 2005 RTM server. W3wp!webserver!7!01/09/2007-12:57:58:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first. Any help would be appreciated. Rick ...Show All

• Visual Studio Deployment, Testing and MsBuild

  We're trying to establish a better build philosophy/strategy for our environment. We are developing a system that controls devices connected to various servers. There are 40 devices in total connected via serial ports. There are 12 servers involved in the system, each running windows services we've written in C#. In order to test the changes we currently mstsc to each server, stop the services, re-register the new build, then start the service back up. This is quite time consuming and we are doing 6-10 builds a day. Testing can only be done when the entire system is online as the 40 devices work in unison to produce a desired function. One solution put forward to speed deployment (and testing) is to write another service that sits ...Show All

• Windows Forms xxx not a valid Win32 application

  I have published my clickonce app to a file server and have installed it on a couple of machines and everything seems fine. But today, one my users got the above error when installing the application. I am guessing there is some component that is missing on her machine and thats why she gets the above error, but I am not sure which one. She has .NET framework 2.0 and is running Windows XP and should be fairly current on the OS updates. Appreciate all the help.... The program name is 'setup.exe' (I am not sure if I can rename this without having to sign the manifest again). But one thing I don't understand is if I am trying to run my 'setup.exe' from the given location, then why does it care if there is a r ...Show All

• .NET Development Reporting facility in Visual Studio.NET

  Hi, I am validating data against certain business rules and printing out a validation report as a plain .txt file.  I would like to make it into a  more readable report. How can I achieve this in Visual Studio.NET 1.1 /C#.  Does Visual Studio have a built in reporting facility that I could use Thanks!             You can take a look at CrystalReports which is included in msdev. Look in the toolbox and you can drag a reporting component onto a form. http://msdn2.microsoft.com/en-us/library/ms345074(VS.80).aspx Personally I serialise data out as xml and present it as html or other document formats using an xslt stylesheet. ...Show All

• Visual Basic Possible? Listbox with collection of User controls as collection

  I have made a user control with a lable and three combo boxes. Is it possible to add this user control as an item(s) in a listbox. yes, but you don't add the control directly. In .net listbox's decide what to render as visible text by calling the tostring() method of the object passed to them, so if you write an object wrapper and set it to an instance of your control then you can e.g. something like so: Public Class ObjectWrapper private Property _yourControl as Control private property _yourText as string public sub New(yourControl as control,yourText as string) _yourControl =yourControl _yourText=yourText end sub public sub overrides tostring() return _yourText end sub ...Show All

• Windows Forms Chat program questions

  This is probably a easy question but i need help. I am using C# and with a friend I am writing a chat program. Now in the program we have the message being sent to a server that then sends the message to a client and is displayed in a text box. The problem is that all the messages are put on the same line and what I want to do is have each message on a different line, if anyone has any ideas could you please help me. Thanks in advance Alister Gough If you are using TextBox then first set its MultiLine Proprty to true and then use this: txtSentChat.Text.AppendText("\n" + newMessage); for RichTextBox use the same code as for the TextBox. Best Regards, ...Show All

• SQL Server Using expressions in custom data flow transformation

  Hi, I'm creating a custom data flow transformation in c#. I would like to use expressions within this component in the same way as in the derived column component: specifying the expression as a custom property of an output column, then evaluating this expression for each row of the buffer and using this evaluated expression to populate my output column values. So I've added an custom expression on my output column, and set its expression type to CPET_NOTIFY IDTSCustomProperty90 exp = col.CustomPropertyCollection.New(); exp.Name = "Expression" ; exp.ExpressionType = DTSCustomPropertyExpressionType .CPET_NOTIFY; But in the ProcessInput method I don't manage to get the evaluated expressions, when I use exp ...Show All

• Visual C++ how to get thread to update editbox?

  Hi, I'm new to programming using mfc. I'm running a thread to read from the serial comport and I would like the data I read from this thread to be reflected back on the main dialog box. I have created an array of editbox in the main dialog box using CEdit Data . How can I pass the get the thread to put the data in the dialog box yours truly, lyndon ...Show All

• .NET Development Path.GetFileName UNC bug

  There appears to be a bug in Path.GetFileName relating to UNC paths: Console .WriteLine( Path .GetFileName( @ \\Server\Share )); outputs: Share But "Share" is not a file or directory by itself. Sorry, the code sample was meant to be: Console.WriteLine(Path.GetFileName(@" \\Server\Share ")); ...Show All