Class SqlParser
Represents a class that performs syntax and lexical analysis of specified Sql code text.
public class SqlParser : SyntaxParser, IComponent, IDisposable, ISyntaxParser, IParser, ILexer, INotify, IUpdate, IImport
- Inheritance
-
SqlParser
- Implements
Examples
Here is how to declare a SqlParser and assign it to the edit control from the C# code:
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
var parser = new Alternet.Syntax.Parsers.Advanced.SqlParser();
var edit = new Alternet.Editor.SyntaxEdit();
edit.Parent = this;
edit.Lexer = parser;
string fileName = "myfile.txt";
if (System.IO.File.Exists(fileName))
{
parser.FileName = fileName;
edit.LoadFile(fileName);
}
}
}
Here is how to declare a SqlParser and assign it to the edit control from the Visual Basic code:
Partial Public Class Form1
Inherits Form
Public Sub New()
InitializeComponent()
End Sub
Private Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs)
Dim parser = New Alternet.Syntax.Parsers.Advanced.SqlParser()
Dim edit = New Alternet.Editor.SyntaxEdit()
edit.Parent = Me
edit.Lexer = parser
Dim fileName As String = "myfile.txt"
If System.IO.File.Exists(fileName) Then
parser.FileName = fileName
edit.LoadFile(fileName)
End If
End Sub
End Class
Remarks
SqlParser is a non-visual component designed to perform syntax highlighting for SQL language. This parser supports complete syntax analysis of the SQL code. When linked to the SyntaxEdit or TextEditor controls, this parser drives additional features such as code completion, code outlining, code formatting, and underlying syntax errors and warnings.

Here are some of the essential features provided by the SqlParser:
- Syntax Highlighting
- IntelliSense (Code completion)
- Code Outlining
- Structure guidelines
- Formatting a selected block of text or the whole document.
Constructors
- SqlParser()
Initializes a new instance of the
SqlParserclass with default settings.
Fields
Properties
- CaseSensitive
Gets or sets a boolean value that indicates whether
SqlParsershould perform case-sensitive analysis of its content.
Methods
- CreateRepository()
Creates
ICodeCompletionRepositoryto perform code completion functionality for this parser.
- GetCompletionType(char)
Obtains type of code completion window from specifies
charparameter.
- ReparseBlock(Point)
Reparses syntax block at specified position.
- ReparseText()
Reparses entire text.
- ResetCodeCompletionChars()
Resets the
CodeCompletionCharsto the default value.
- ResetOptions()
Resets
Optionsto the default value.
- ShouldSerializeCodeCompletionChars()
Indicates whether the
CodeCompletionCharsproperty should be persisted.
- ShouldSerializeFormatCase()
Indicates whether the
FormatCaseproperty should be persisted.
- ShouldSerializeOptions()
Indicates whether the
Optionsproperty should be persisted.
- SmartFormatLine(int, string, StringItemInfo[], ITextUndoList, out bool)
Formats line according to the parser rules.