Code Reuse

[Yahweh]

This is probably an elementary problem, but my Google searches didn't reveal any good answers.I have this function for escaping SQL string:

Public Function SafeSQL(strString as String) as String	Return replace(strString, "'", "''", 1, -1, CompareMethod.Text)End Function

I want to put that code in another file so it can be included globally on all of my pages or make it available selected pages without using the classic asp "<!--#include-->" statement, but I don't know the ASP.Net syntax. Any help would be appreciated

[jesh]

In C# (I don't know VB) I would do something like this:

namspace UtilityFunctions{	public class SQLFunctions	{		public static string MakeSafe(string unsafeString)		{			// whatever you do to make the string safe.		}	}}

Then, to use it in another class/page, you would do something like this:

using UtilityFunctions;public class MyOtherClass{	public void DoIt(string unsafeString)	{		string safeString = SQLFunctions.MakeSafe(unsafeString);	}}

I hope this helps!

[pulpfiction]

In VB.NET

 Namespace Utilities	Public Class SQLFunctions			  Public Shared Function MakeSafe(Byval str as String)						  'Code goes here			  End Function	 End ClassEnd Namespace

To call this function....

 Imports UtilitiesDim unsafe as StringDim safe as String safe = SQLFunctions.MakeSafe(unsafe)