Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. annethorne

    Need Function to Redact SSNs and CCs from a string

    I think I have found my answer: private static string RedactCC(string stringToRedact) { const string pattern = @"(?:4[0-9]{12}(?:[0-9]{3})?|5[1-5][0-9]{14}|6(?:011|5[0-9][0-9])[0-9]{12}|3[47][0-9]{13}|3(?:0[0-5]|[68][0-9])[0-9]{11}|(?:2131|1800|35\d{3})\d{11})"; stringToRedact...
  2. annethorne

    Need Function to Redact SSNs and CCs from a string

    I have found this reference: http://foobook.org/erbere/scraps/find-and-replace-text-with-regex/ :)
  3. annethorne

    Need Function to Redact SSNs and CCs from a string

    Hi everyone, I need a function to redact possible SSNs and CCs from a string. This is for an application that receives messages from customers, which may contain SSNs or CCs. Instead of passing on that message, we want to redact it of the sensitive information. We do have some SQL...
  4. annethorne

    System.Runtime.InteropServices.COMException

    Hi Fellow Developers, After some searching, we found the solution. I simply had my brother install the following: http://www.microsoft.com/en-us/download/details.aspx?id=13518 ProPhotoTools.msi His system did not have Microsoft.ImageMetadata references in it. All...
  5. annethorne

    System.Runtime.InteropServices.COMException

    Hi Fellow Developers, I have created a Dot Net Windows application for my brother. It reads .jpg files and extracts exif information from them and then saves that information into a .csv file. I have written it on a 64 bit machine. He either has a 64 bit, or a 32 bit machine. I'm not...
  6. annethorne

    Two Questions To Help Me Improve SQL Scripts

    Hi SQL Developer Friends, I would like implement the following techniques in some SQL scripts: 1) Before updating a table, copy it into a new table that has the same table name, appended with an underscore and the datetime. For example if the name of the table was Browsers then I would copy...
  7. annethorne

    Script to run same commands for different values

    Yes... Thank you so much!!! :) Anne
  8. annethorne

    Script to run same commands for different values

    Thank you so very much! This is a very useful technique. I changed it only very slightly as follows: BEGIN TRANSACTION BEGIN Declare @Lookup Table(LookupName VarChar(50), LookupValue VarChar(5000)) Insert Into @Lookup Values('Shelternet_IsActive','true') Insert Into @Lookup...
  9. annethorne

    Script to run same commands for different values

    Hi, I want to write a script for our Release Engineers to run that does the following (which doesn't even work :( though this is the general idea ... and doesn't require my cutting and pasting so much). I think I need to perhaps create some arrays, and use a while statement? But, there may be...
  10. annethorne

    Logging where an error occurred

    Hi, We are currently building a Windows Application with Visual Studio, C# and SQL. Exceptions are caught and logged. Is there a way for us to determine the exact spot in the code where the error occurred, that is the CLASS and the METHOD? Here is the code we use now: catch (Exception error)...
  11. annethorne

    Trigger Help Needed

    Thank you so much George :) Yes it is for the zip code thing :) I really appreciate your help :) Anne
  12. annethorne

    Trigger Help Needed

    Hi, I have never written a trigger before. This is probably very simply, but I need some assistance: The basic concept is as follows. When user puts values into Table One, a TRIGGER occurs and values are automatically put into Table Two: Table One has 3 basic columns, and Table Two has 2...
  13. annethorne

    Inserting many rows programmatically

    Thank you George. What you showed us is very valuable!!! Have a great day! Anne
  14. annethorne

    Inserting many rows programmatically

    Thank You, Thank You, Thank You, SQLDenis!!! Have a Great Day! Anne
  15. annethorne

    Inserting many rows programmatically

    Hi, I know this is very easy... I just don't know how to do it: We have the following table named Wzip_Detail [Wzip_Detail_ID] [int] IDENTITY (1, 1) NOT NULL , [PostalCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [CountryCode] [varchar] (3) COLLATE...
  16. annethorne

    Programmatically populating a table with detail

    Hi, We are creating an ASP Database Application that connects to Sql Server 2000. The application is for associating a zip code with a warehouse. For instance a zip code for the los angeles area would go to the los angeles warehouse and a zip code for the new york area would go to the new...
  17. annethorne

    Editing XML Node (C#)

    Hello, We are building a windows desktop application using C# that reads in an xml file, to create a user interface. The user then enters values into the user interface. We want to be able to save an xml file with the same schema as the original xml file, but with the users entered values into...
  18. annethorne

    Programmatically adding TabPage Contents into DataGrid from XML File

    Hi, We are creating a C# Windows application using VS 2005. It reads in an xml file and creates tab pages that each have a datagrid that holds the specific information for that tab's node. We have been able to programmatically give the tab.text (the label on the tabs), but when we try to add...
  19. annethorne

    Overriding Label CanSelect Property

    Hi, Can any one tell me how to override the System.Windows.Forms.Label.CanSelect property? Thanks! Anne

Part and Inventory Search

Back
Top