C#

Email: theeclypse@hotmail.com   URL: http://www.onyeyiri.co.uk
"All programmers are playwrights and all computers are lousy actors."

string sSQL = "INSERT INTO Customers (FirstName, LastName) VALUES (' ', ' '); SELECT @@IDENTITY;";

OleDbCommand oCmd = new OleDbCommand(sSQL, oConn);
oCmd = new OleDbCommand(sSQL, oConn);
nCustomerID = Convert.ToInt32(oCmd.ExecuteScalar().ToString());

private string StripPunctuation(string sourceString )
 {
   int counter;
   string PunctuationCharacters;
   string buffer = sourceString;
   int StringLength;

   //Initialize the Lookup String
   PunctuationCharacters = "`!@$%^*()+=\\|[]{};:<>/?,~";
   StringLength = PunctuationCharacters.Length;
		
   //Trim the Source (just in case)
   buffer.Trim();
   try
   {
     for (counter = 1 ; counter < StringLength ; counter++)
     {
       buffer.Replace( PunctuationCharacters.Substring(counter, 1), "");
     }

     //Also remove double Quotes
     buffer.Replace((char) 34, (char) 0);

     return buffer;
   }
   catch
   {
     return sourceString;
   }
}