Code:
/ FX-1434 / FX-1434 / 1.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
- BaseValidator.cs
- DBSchemaRow.cs
- FreezableCollection.cs
- SQLInt16.cs
- Win32MouseDevice.cs
- TableHeaderCell.cs
- DoWorkEventArgs.cs
- ThousandthOfEmRealPoints.cs
- Point.cs
- ToolStripPanel.cs
- DataControlImageButton.cs
- Barrier.cs
- WebHttpBindingElement.cs
- ViewValidator.cs
- Automation.cs
- ClrProviderManifest.cs
- RouteParser.cs
- CancellableEnumerable.cs
- LinqDataSourceDeleteEventArgs.cs
- HiddenFieldPageStatePersister.cs
- MachineKeySection.cs
- DataGridViewBindingCompleteEventArgs.cs
- QilLoop.cs
- HtmlToClrEventProxy.cs
- Enum.cs
- SignalGate.cs
- SessionPageStatePersister.cs
- PrinterResolution.cs
- _BufferOffsetSize.cs
- FamilyMapCollection.cs
- PeerCollaborationPermission.cs
- PreviewPageInfo.cs
- HwndTarget.cs
- DrawListViewColumnHeaderEventArgs.cs
- PagesChangedEventArgs.cs
- BuildManager.cs
- PrintDialog.cs
- EventsTab.cs
- SettingsPropertyValueCollection.cs
- DefaultValueConverter.cs
- SqlStatistics.cs
- SharedPersonalizationStateInfo.cs
- RsaKeyIdentifierClause.cs
- ProcessHost.cs
- StandardBindingElementCollection.cs
- Buffer.cs
- SelectionService.cs
- HashCryptoHandle.cs
- Avt.cs
- DetailsView.cs
- OrderedDictionaryStateHelper.cs
- ObjectStateEntryDbUpdatableDataRecord.cs
- RegexStringValidator.cs
- UnknownBitmapDecoder.cs
- TextRangeBase.cs
- XmlWellformedWriter.cs
- SystemGatewayIPAddressInformation.cs
- ThreadStartException.cs
- MessageHeaderInfoTraceRecord.cs
- ToolStripGripRenderEventArgs.cs
- TrackingCondition.cs
- SpellerError.cs
- CollectionViewSource.cs
- SchemaObjectWriter.cs
- TextClipboardData.cs
- FrameSecurityDescriptor.cs
- DependencyPropertyKind.cs
- DesigntimeLicenseContextSerializer.cs
- RijndaelCryptoServiceProvider.cs
- FillRuleValidation.cs
- ToolBarOverflowPanel.cs
- TemplateBamlTreeBuilder.cs
- PageBreakRecord.cs
- SchemaObjectWriter.cs
- EntityDesignerUtils.cs
- ExtenderProvidedPropertyAttribute.cs
- StringValueConverter.cs
- HtmlInputReset.cs
- CorrelationManager.cs
- CodeDelegateInvokeExpression.cs
- SerializationSectionGroup.cs
- DatagridviewDisplayedBandsData.cs
- Point3DValueSerializer.cs
- DataGridViewImageColumn.cs
- BrowserCapabilitiesFactory.cs
- Line.cs
- ColorConvertedBitmapExtension.cs
- DataGridLinkButton.cs
- Padding.cs
- DiagnosticTraceSource.cs
- StateMachineTimers.cs
- XmlNodeReader.cs
- CodeTypeDeclarationCollection.cs
- PersonalizationState.cs
- ProtocolsSection.cs
- DialogWindow.cs
- ContainerParaClient.cs
- Baml2006ReaderContext.cs
- WorkflowRuntimeServiceElementCollection.cs
- DataGridCommandEventArgs.cs