Regex Match

regexmatch.cs

		if (!string.IsNullOrEmpty(id))
		{
			int counter = 0;
			string sPartNum = id + "-";
			bool recSelected;
			//string whereClause = "[PartList].[PartNum] = (SELECT TOP 1 [PartNum] FROM [Erp].[Part] WHERE [Part].[Company] = [PartList].[Company] AND [Part].[PartNum] LIKE '" + sPartNum + "%' and 12345=12345 ORDER BY [PartNum] DESC)";
			string whereClause = "PartNum LIKE '" + sPartNum + "%' BY CreatedOn DESC";

			//nextSeq.ToString().PadLeft(5, '0');
			// Current company only
			DataSet ds = SearchFunctions.listLookup(this.oTrans, "PartAdapter", out recSelected, false, whereClause, false);

			if (recSelected) {
				//DataRow x = ds.Tables[0].Rows[0]["PartNum"];
				int nextSeq = Convert.ToInt32(System.Text.RegularExpressions.Regex.Match(ds.Tables[0].Rows[0]["PartNum"].ToString(), @"\d+").ToString().PadLeft(5, '0')) + 1;
			}
		}