Thanks Daniel! I'll take a look at those resources. :) Anne

Thanks, that is good to know. A third party wrote the code, so I am not sure. :) Anne

Hi Everyone, The company I work for has outsourced its website to a 3rd party, however we can write a custom error page to track 500 errors. We would like to be able to create such a 500 error page to find out as much as much as we possibly can about what happened to cause the 500 error. Also, we would like to get all the session and cookie data we can from the session that encountered the 500 error. Then, we'd like to save all of that data into a DB table. Have any of you done this sort of thing before, or have any recommendations? All the Best to You! :) Anne

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 = Regex.Replace(
stringToRedact,
pattern,
m => "***-**-" + m.Value.Substring(m.Value.Length - 4, 4));
return stringToRedact;
}

private static string RedactSSN(string stringToRedact)
{
const string pattern = @"\d{3}-\d{2}-\d{4}";
stringToRedact = Regex.Replace(
stringToRedact,
pattern,
m => "***-**-" + m.Value.Substring(m.Value.Length - 4, 4));
return stringToRedact;
}

Maybe this post will help someone else in the future. :) Anne

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

The functions are here: http://files.engineering.com/getfile.aspx?folder=0cc581bd-5691-4c60-b0b2-c35b2b7f7a10&file=dbo.fnFixCCandSSN-sqlFunction.txt http://files.engineering.com/getfile.aspx?folder=b19b9e78-975a-4ca2-9fec-aa852367819b&file=dbo.fnIsLuhnValid-sqlFunction.txt Thank you so very much for your help!!! :) Anne

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 functions that do this, but I want to duplicate what they do in C# as we don't want to use Databases. Have any of you done this sort of thing before? All the Best to You! Anne

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 the Best to You! :) Anne

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 sure which. He runs Microsoft Vista. I run Windows 7. I have built the dot net application using the target platform of x86, so I don't think that is why I am getting the following error. Any and all advice on how to get the app to run on his system, is greatly appreciated. All the Best to You! :) Anne ERROR IS:

See the end of this message for details on invoking

just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************

System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {5F90E37C-44A0-47AF-A4CC-CCA80F0EBC83} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).

at Microsoft.ImageMetadata.NativeAccess.loadWic()

at Microsoft.ImageMetadata.NativeAccess.get_WicAccess()

at Microsoft.ImageMetadata.NativeAccess.initImageTypes()

at Microsoft.ImageMetadata.MetadataPolicy.initImageTypes()

at Microsoft.ImageMetadata.ParseXml.load()

at Microsoft.ImageMetadata.MetadataPolicyManager.loadPolicy(String xmlFilename)

at OEE.DataAccess.ProcessTheData(String imgPath, String logFile) in C:\VS\OtherDotNetApps\OrionExifExtractor\OEE\OEE\DataAccess\DataAccess.cs:line 102

at OEE.DataAccess.ProcessDir(String sourceDir, Int32 recursionLvl, String logFile) in C:\VS\OtherDotNetApps\OrionExifExtractor\OEE\OEE\DataAccess\DataAccess.cs:line 82

at OEE.DataAccess.ProcessDir(String sourceDir, Int32 recursionLvl, String logFile) in C:\VS\OtherDotNetApps\OrionExifExtractor\OEE\OEE\DataAccess\DataAccess.cs:line 92

at OEE.DataAccess.ProcessDir(String sourceDir, Int32 recursionLvl, String logFile) in C:\VS\OtherDotNetApps\OrionExifExtractor\OEE\OEE\DataAccess\DataAccess.cs:line 92

at OEE.DataAccess.ProcessDir(String sourceDir, Int32 recursionLvl, String logFile) in C:\VS\OtherDotNetApps\OrionExifExtractor\OEE\OEE\DataAccess\DataAccess.cs:line 92

at OEE.Form1.btnLoadBCTphotos_Click(Object sender, EventArgs e) in C:\VS\OtherDotNetApps\OrionExifExtractor\OEE\OEE\Form1.cs:line 100

at System.Windows.Forms.Control.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnClick(EventArg

Hi, I have done some searching for this and have not found exactly what I need. I have created a Windows Application in C#, Dot Net Framework 2, for my company. It currently has a Target Platform of "any cpu". The company is slowly migrating to use 64 bit machines. Also we would like to upgrade the Windows Application to Dot Net Framework 4. Management wants to be sure that changing to an x86 target platform (this is the target platform that needs to be used for both x32 and x64 bit machines to run the application) and changing to Dot Net Framework 4, will not break anything. So: For testing, I want to create 2 applications with the same source code. 1) (Using Visual Studio 2005 to build and publish): Current Visual Studio settings: Dot Net Framework 2, and Target Platform: any cpu 2) (Using Visual Studio 2010 to build and publish): Dot Net Framework 4, and Target Platform: x86 In a label on the application, I want to display the Dot Net Version (I know how to do that). Then I also want to display the Target Platform, which will either be : "any cpu" or "x86". After searching the internet for about 15 minutes, I discovered how to differentiate between, x32 and x64; or perhaps between x32 and x86... This is by simply using the IntPtr.Size property. But.. How would I differentiate between "any cpu" and x86. Or what if I wanted to differentiate between x86 and x64? Thanks in advance for any advice anyone can give me with this. :) Anne

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) { ExceptionHandler.LogError(error, Applications.ID, UserProfile.UserID, Applications.Version); throw error; } The error object gives us Source and StackTrace, but not location. Thanks for any help, :) Anne

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 basic columns. Table One NumStart: 1 NumEnd: 3 Code: A Table Two Num: 1 Code: A Num: 2 Code: A Num: 3 Code: A Thank you in advance for any help you can give. Anne

Thank you so much John for your response and your very clean programming style!!! :) Anne

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 SQL_Latin1_General_CP1_CI_AS NULL , [WarehouseNum] [int] NULL Wzip_Detail_ID will be automatically populated. CountryCode will always be 1 WarehouseNum will always be 1 HOWEVER: PostalCode for row 1 will be: 00000 PostalCode for row 2 will be: 00001 PostalCode for row 3 will be: 00002 PostalCode for the last row will be: 99999 So there will be rows 00000 to 99999 incrementally a total of 100,000 rows (I think) How do I do this programatically in SQL Query Analyzer. Again, I'm sure it is very easy... I just don't know how to do it yet.... Thank you so much in advance for any help you can give, Anne

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 york warehouse. We would like to enter zip code ranges into the following Wzip_Log table. Then we would like to programmatically populate the Wzip_Detail table and the Wzip table. The Wzip_Log table holds zip code ranges, where as the Wzip_Detail and the Wzip table hold individual zip codes. For instance, the Wzip_Log table might have the following record (completely fictitious) Wzip_Log_ID: 1 PostalCode_Start: 11111 PostalCode_End: 11113 CountryCode: USA WarehouseNum: 1 Operator: jdoe Time_Stamp: 00:00:00 6/1/2006 Then we would want the Wzip_Detail table to be populated as follows: Wzip_Detail_ID: 1 Wzip_Log_ID: 1 PostalCode: 11111 CountryCode: USA WarehouseNum: 1 Wzip_Detail_ID: 2 Wzip_Log_ID: 1 PostalCode: 11112 CountryCode: USA WarehouseNum: 1 Wzip_Detail_ID: 3 Wzip_Log_ID: 1 PostalCode: 11113 CountryCode: USA WarehouseNum: 1 The Wzip table would be populated exactly the same as the Wzip_Detail table at this point. However, say a user later updated the Wzip_Log table as follows: Wzip_Log_ID: 2 PostalCode_Start: 11111 PostalCode_End: 11113 CountryCode: USA WarehouseNum: 2 Operator: jdoe Time_Stamp: 01:10:00 6/4/2006 The Wzip_Detail table would contain an INSERT of this data (giving it a total of 6 records) whereas the Wzip table would contain an UPDATE of this data (giving it a total of 3 records) For your reference, here are the table layouts: Table Name: Wzip_Log Wzip_Log_ID int 4 (primary key, Identity) PostalCode_Start varchar 10 PostalCard_End varchar 10 CountryCode varchar 3 WarehouseNum int 4 Operator varchar 50 Time_Stamp datetime 8 Table Name: Wzip_Detail Wzip_Detail_ID int 4 (primary key, Identity) Wzip_Log_ID int 4 (foreign key) PostalCode varchar 10 CountryCode varchar 3 WarehouseNum int 4 Table Name: Wzip Wzip_ID int 4 (primary key, Identity) Wzip_Log_ID int 4 (foreign key) Wzip_Detail_ID int 4 (foreign key) PostalCode varchar 10 CountryCode varchar 3 WarehouseNum int 4 I think there is probably some way to do this prog

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 it. Here is a simple example as part of input document: Needs Cleaning radio yes no We would want the output document to contain: Needs Cleaning radio yes yes no or perhaps Needs Cleaning text yes We aren't too adept at xmlTextReaders and xmlTextWriters yet, and have been doing some research in Google. There was an interesting article that seemed pertinent to this, but it dealt with C++ : http://www.codeproject.com/csharp/dcinsertxml.asp Any help would be appreciated. Thank you! Anne

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 it. Here is a simple example as part of input document: Needs Cleaning radio yes no We would want the output document to contain: Needs Cleaning radio yes yes no or perhaps Needs Cleaning text yes We aren't too adept at xmlTextReaders and xmlTextWriters yet, and have been doing some research in Google. There was an interesting article that seemed pertinent to this, but it dealt with C++ : http://www.codeproject.com/csharp/dcinsertxml.asp Any help would be appreciated. Thank you! Anne

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 the specific data for each tab into a datagrid on the tab's page, all of the data gets added instead of the data for just that node. Perhaps we need to clear the grid first??? Any help would be appreciated. Thank you in advance, Anne Here is a portion of the xml file we are using.<?xml version="1.0" encoding="utf-8"?> <inspection> <inspforms> <inspform> <name>general</name> <sections> <section> <tab>Heading</tab> <label> <name>id</name> <type>text</type> <value> <single>200621</single> </value> </label> <label> <name>request </name> <type>text </type> <value> <single>30 </single> <choices> <choice> </choice> </choices> </value> </label> </section> </sections> </inspform> <inspform> <name>Risk</name> <sections> <section> <tab>Operations</tab> <label> <name>Business Type</name> <type>radio</type> <value> <choices> <choice> <choicename>Corporation</choicename> <choicevalue>

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 the specific data for each tab into a datagrid on the tab's page, all of the data gets added instead of the data for just that node. Perhaps we need to clear the grid first??? Any help would be appreciated. Thank you in advance, Anne Here is a portion of the xml file we are using.<?xml version="1.0" encoding="utf-8"?> <inspection> <inspforms> <inspform> <name>general</name> <sections> <section> <tab>Heading</tab> <label> <name>id</name> <type>text</type> <value> <single>200621</single> </value> </label> <label> <name>request </name> <type>text </type> <value> <single>30 </single> <choices> <choice> </choice> </choices> </value> </label> </section> </sections> </inspform> <inspform> <name>Risk</name> <sections> <section> <tab>Operations</tab> <label> <name>Business Type</name> <type>radio</type> <value> <choices> <choice> <choicename>Corporation</choicename>

Thank you very much Dave!