Code:
/ DotNET / DotNET / 8.0 / untmp / whidbey / REDBITS / ndp / fx / src / Designer / WebForms / System / Web / UI / Design / WebControls / SqlDataSourceParameterParser.cs / 1 / SqlDataSourceParameterParser.cs
//------------------------------------------------------------------------------ //// Copyright (c) Microsoft Corporation. All rights reserved. // //----------------------------------------------------------------------------- namespace System.Web.UI.Design.WebControls { using System; using System.Collections; using System.Diagnostics; using System.IO; using System.Web.UI.WebControls; // ////// Helper class to get list of parameters from an arbitrary SQL query. /// internal static class SqlDataSourceParameterParser { ////// Parses a command and returns an array of parameter names. /// public static Parameter[] ParseCommandText(string providerName, string commandText) { if (String.IsNullOrEmpty(providerName)) { providerName = SqlDataSourceDesigner.DefaultProviderName; } if (String.IsNullOrEmpty(commandText)) { commandText = String.Empty; } ParameterParser parser = null; switch (providerName.ToLowerInvariant()) { case "system.data.sqlclient": parser = new SqlClientParameterParser(); break; case "system.data.odbc": case "system.data.oledb": parser = new MiscParameterParser(); break; case "system.data.oracleclient": parser = new OracleClientParameterParser(); break; } if (parser == null) { Debug.Fail("Trying to parse parameters for unknown provider: " + providerName); return new Parameter[0]; } return parser.ParseCommandText(commandText); } ////// Base class for parameter parsing classes. /// private abstract class ParameterParser { public abstract Parameter[] ParseCommandText(string commandText); } ////// Parses SqlClient parameters of the form: /// select * from authors where col1 = @param1 /// private sealed class SqlClientParameterParser : ParameterParser { ////// List of states for parser. /// private enum State { InText, InQuote, InDoubleQuote, InBracket, InParameter, } ////// Returns true is a character is valid for a named parameter. /// private static bool IsValidParamNameChar(char c) { return (Char.IsLetterOrDigit(c)) || (c == '@') || (c == '$') || (c == '#') || (c == '_'); } public override Parameter[] ParseCommandText(string commandText) { int index = 0; int length = commandText.Length; State state = State.InText; System.Collections.Generic.Listparameters = new System.Collections.Generic.List (); System.Collections.Specialized.StringCollection parameterNames = new System.Collections.Specialized.StringCollection(); while (index < length) { switch (state) { case State.InText: if (commandText[index] == '\'') { state = State.InQuote; } else if (commandText[index] == '"') { state = State.InDoubleQuote; } else if (commandText[index] == '[') { state = State.InBracket; } else if (commandText[index] == '@') { state = State.InParameter; } else { index++; } break; case State.InQuote: index++; while (index < length && commandText[index] != '\'') { index++; } index++; state = State.InText; break; case State.InDoubleQuote: index++; while (index < length && commandText[index] != '"') { index++; } index++; state = State.InText; break; case State.InBracket: index++; while (index < length && commandText[index] != ']') { index++; } index++; state = State.InText; break; case State.InParameter: index++; string paramName = String.Empty; while ((index < length) && (IsValidParamNameChar(commandText[index]))) { paramName += commandText[index]; index++; } // Ignore @@functions since they aren't parameters if (!paramName.StartsWith("@", StringComparison.Ordinal)) { Parameter p = new Parameter(paramName); // Ignore duplicate parameters if (!parameterNames.Contains(paramName)) { parameters.Add(p); parameterNames.Add(paramName); } } state = State.InText; break; } } return parameters.ToArray(); } } /// /// Parses ODBC and OLEDB parameters of the form: /// select * from authors where col1 = ? /// private sealed class MiscParameterParser : ParameterParser { ////// List of states for parser. /// private enum State { InText, InQuote, InDoubleQuote, InBracket, InQuestion, } public override Parameter[] ParseCommandText(string commandText) { int index = 0; int length = commandText.Length; State state = State.InText; System.Collections.Generic.Listparameters = new System.Collections.Generic.List (); while (index < length) { switch (state) { case State.InText: if (commandText[index] == '\'') { state = State.InQuote; } else if (commandText[index] == '"') { state = State.InDoubleQuote; } else if (commandText[index] == '[') { state = State.InBracket; } else if (commandText[index] == '?') { state = State.InQuestion; } else { index++; } break; case State.InQuote: index++; while (index < length && commandText[index] != '\'') { index++; } index++; state = State.InText; break; case State.InDoubleQuote: index++; while (index < length && commandText[index] != '"') { index++; } index++; state = State.InText; break; case State.InBracket: index++; while (index < length && commandText[index] != ']') { index++; } index++; state = State.InText; break; case State.InQuestion: index++; parameters.Add(new Parameter("?")); state = State.InText; break; } } return parameters.ToArray(); } } /// /// Parses OracleClient parameters of the form: /// select * from authors where col1 = :param1 /// private sealed class OracleClientParameterParser : ParameterParser { ////// List of states for parser. /// private enum State { InText, InQuote, InDoubleQuote, InBracket, InParameter, } ////// Returns true is a character is valid for a named parameter. /// private static bool IsValidParamNameChar(char c) { // return (Char.IsLetterOrDigit(c)) || (c == '_'); } public override Parameter[] ParseCommandText(string commandText) { int index = 0; int length = commandText.Length; State state = State.InText; System.Collections.Generic.Listparameters = new System.Collections.Generic.List (); System.Collections.Specialized.StringCollection parameterNames = new System.Collections.Specialized.StringCollection(); while (index < length) { switch (state) { case State.InText: if (commandText[index] == '\'') { state = State.InQuote; } else if (commandText[index] == '"') { state = State.InDoubleQuote; } else if (commandText[index] == '[') { state = State.InBracket; } else if (commandText[index] == ':') { state = State.InParameter; } else { index++; } break; case State.InQuote: index++; while (index < length && commandText[index] != '\'') { index++; } index++; state = State.InText; break; case State.InDoubleQuote: index++; while (index < length && commandText[index] != '"') { index++; } index++; state = State.InText; break; case State.InBracket: index++; while (index < length && commandText[index] != ']') { index++; } index++; state = State.InText; break; case State.InParameter: index++; string paramName = String.Empty; while ((index < length) && (IsValidParamNameChar(commandText[index]))) { paramName += commandText[index]; index++; } Parameter p = new Parameter(paramName); // Ignore duplicate parameters if (!parameterNames.Contains(paramName)) { parameters.Add(p); parameterNames.Add(paramName); } state = State.InText; break; } } return parameters.ToArray(); } } } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007. // Copyright (c) Microsoft Corporation. All rights reserved.
Link Menu
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- Operator.cs
- ExceptionRoutedEventArgs.cs
- OpCellTreeNode.cs
- SQLDateTimeStorage.cs
- MasterPage.cs
- ExpanderAutomationPeer.cs
- CanonicalFontFamilyReference.cs
- BamlLocalizationDictionary.cs
- AssertUtility.cs
- TextSpan.cs
- PartManifestEntry.cs
- LayoutSettings.cs
- ObjectViewEntityCollectionData.cs
- Util.cs
- CompatibleIComparer.cs
- LinkButton.cs
- HtmlControlPersistable.cs
- ForwardPositionQuery.cs
- PropertyToken.cs
- WebDescriptionAttribute.cs
- SubqueryRules.cs
- UrlPropertyAttribute.cs
- XsltOutput.cs
- CustomErrorsSectionWrapper.cs
- Effect.cs
- SiteMapNodeItem.cs
- RectangleConverter.cs
- IOException.cs
- CookieParameter.cs
- LocalIdCollection.cs
- CheckBox.cs
- DataTemplate.cs
- FixedSOMPageElement.cs
- EntityContainerEntitySet.cs
- DbDataSourceEnumerator.cs
- DataControlButton.cs
- VersionPair.cs
- RawStylusInput.cs
- WorkflowMessageEventArgs.cs
- ThumbButtonInfo.cs
- AutomationElementIdentifiers.cs
- NullExtension.cs
- CompareInfo.cs
- GridViewUpdatedEventArgs.cs
- SchemaNamespaceManager.cs
- DiscoveryOperationContext.cs
- MetaModel.cs
- COM2ExtendedUITypeEditor.cs
- FormClosedEvent.cs
- StyleModeStack.cs
- ToolboxDataAttribute.cs
- ComplexTypeEmitter.cs
- MetadataExchangeClient.cs
- ImpersonationOption.cs
- Token.cs
- ListDictionaryInternal.cs
- OuterGlowBitmapEffect.cs
- indexingfiltermarshaler.cs
- Authorization.cs
- MultilineStringEditor.cs
- CqlParser.cs
- MethodExecutor.cs
- HttpRuntimeSection.cs
- CompletedAsyncResult.cs
- FieldAccessException.cs
- ResourceWriter.cs
- ItemCheckEvent.cs
- AttributeCollection.cs
- ClearTypeHintValidation.cs
- RelationshipWrapper.cs
- CompilerTypeWithParams.cs
- XmlBoundElement.cs
- SqlStream.cs
- OptimalTextSource.cs
- ScriptingSectionGroup.cs
- DetailsViewCommandEventArgs.cs
- HighContrastHelper.cs
- BitConverter.cs
- MultilineStringEditor.cs
- DynamicControl.cs
- TypeListConverter.cs
- BamlReader.cs
- DefaultMemberAttribute.cs
- VerificationException.cs
- DataMisalignedException.cs
- OverflowException.cs
- IncrementalHitTester.cs
- TypefaceCollection.cs
- Completion.cs
- PerformanceCounterCategory.cs
- FormViewUpdateEventArgs.cs
- InputScope.cs
- DebugControllerThread.cs
- OleDbMetaDataFactory.cs
- StyleReferenceConverter.cs
- GeneralTransformGroup.cs
- XmlObjectSerializerReadContext.cs
- Rect.cs
- AttributeAction.cs
- FixedSOMPage.cs