SqlDataSourceParameterParser.cs source code in C# .NET

                        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.List parameters = 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.List parameters = 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.List parameters = 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

Network programming in C#, Network Programming in VB.NET, Network Programming in .NET
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
SqlDataSourceParameterParser.cs source code in C# .NET

Source code for the .NET framework in C#

Code:

Link Menu
