Look for ZedGraph library. There's an article also here on CP. It's for free! (released under LGPL License) Regards

Well, I found that the syntax highlight works partially. The stylesheet for string (class:vb-string) is included, only boolean miss the stylesheet (class:vb-keyword). I'll keep using the carriage return trick and the next article I'll just send it by email. Thanks and Regards

Yes! :doh: Do you suggest not to? I've checked the HTML and the color tag are there.... It should work...

Hi, I'm using Firefox (latest version) and when I update an article make the syntax highlight working is a fight :doh:. Also if I update just a file without touching the article, the syntax highlight stops working. Until now I did like this: I put a couple of carriage return here, I remove some other there, I cross my fingers and then it's good. Sometimes it's not... (look my latest article :(( ) Furthermore when I use the Preview button I have another issue: when I'm back to the article and I press Next, the preview is shown again..... I don't know if it is the browser or not. Am I missing something? Anyone notice the same? s.

Hi Chris, thanks for replying.... :):):) I really love CodeProject, so don't take my criticism badly but, I do really think my article should be included. Beside this that's not so important, can I just suggest to create a forum for article writer? I'm new to article writing on CP, and I would like to forward my question without feelin' stupid... :sigh: For example the next question should be "When it's the time of listing?" and "Article posted on 31 March will be listed in April or May?". Let me express again my gratitute for the resource you've created. Best Regards

I'm surprised then! :rose: My article is rated more then the actual ones listed! Same is with the popularity value..... Check for VB.NET: http://www.codeproject.com/useritems/PropertyGridEx.asp

[Message Deleted]

In C++ doesn't exists. :) Example: VB: Chr(13) C++: char mychr = 13;

I need a Regular Expression to match the bold part: SELECT * FROM Table WHERE ID = ¶meter but not this one SELECT * FROM Table WHERE ID = "Me&You" Thanks

Hi to all, I working to a query tool. The user can load a query and execute it. Some queries can contain "variables". I looked on Internet and I found they can have different aspect. The Microsoft provider executes with no problem, queries like:* SELECT * FROM Table WHERE ID = :variable I'm trying to execute queries like:

• SELECT * FROM Table WHERE ID = ?
• SELECT * FROM Table WHERE ID = &variable
• SELECT * FROM Table WHERE ID = &<name="variable1" type="string"> They are named as follow:
• Oracle style bindings
• JDBC style bindings
• Name unknown (used for example by QueryReporter)
• Name unknown (used for example by QueryReporter) To do that I've wrote a Regular Expression for each type.
• "[\s]*?:[\s]*?([A-Za-z0-9^\s^<^,]*)"
• "[\s]*?([\?])[\s^,^<]*?"
• "[\s]*?&[\s]*?([A-Za-z0-9_^\s^<^,]*)"
• "&[\s]*?<[\s]*?[nN][aA][mM][eE][\s]*?=[\s]*?""([^""\r\n]*)?""[\s]*?([tT][yY][pP][eE][\s]*?=[\s]*?""([^""\r\n]*)?""[\s]*?)?>" My problem is this one: I want to exclude the strings contained inside "" or '' e.g. I don't want to match ":this" because it's not a variable to bind SELECT * FROM Table WHERE Column = "Hello world :this is me" Hope I've been clear Thanks in advance ;P

Hi, the answer to your need, is use an Attribute to pass the dynamic list to your TypeConverter. Please check my recent article here: http://www.codeproject.com/useritems/PropertyGridEx.asp Here is my TypeConverter ;) :

Public Class CustomChoices
Inherits ArrayList

Public Sub New(ByVal array As ArrayList, Optional ByVal IsSorted As Boolean = False)
    Me.AddRange(array)
    If IsSorted Then Me.Sort()
End Sub

Public Sub New(ByVal array() As String, Optional ByVal IsSorted As Boolean = False)
    Me.AddRange(array)
    If IsSorted Then Me.Sort()
End Sub

Public Sub New(ByVal array() As Integer, Optional ByVal IsSorted As Boolean = False)
    Me.AddRange(array)
    If IsSorted Then Me.Sort()
End Sub

Public Sub New(ByVal array() As Double, Optional ByVal IsSorted As Boolean = False)
    Me.AddRange(array)
    If IsSorted Then Me.Sort()
End Sub

Public Sub New(ByVal array() As Object, Optional ByVal IsSorted As Boolean = False)
    Me.AddRange(array)
    If IsSorted Then Me.Sort()
End Sub

Public ReadOnly Property Items() As ArrayList
    Get
        Return Me
    End Get
End Property

Public Class CustomChoicesTypeConverter
    Inherits TypeConverter
    Private oChoices As CustomChoicesAttributeList = Nothing
    Public Overrides Function GetStandardValuesSupported(ByVal context As System.ComponentModel.ITypeDescriptorContext) As Boolean
        Dim Choices As CustomChoicesAttributeList = context.PropertyDescriptor.Attributes(GetType(CustomChoicesAttributeList))

        If Not Choices Is Nothing Then
            oChoices = Choices
            GetStandardValuesSupported = True
        Else
            GetStandardValuesSupported = False
        End If
    End Function
    Public Overrides Function GetStandardValuesExclusive(ByVal context As System.ComponentModel.ITypeDescriptorContext) As Boolean
        Dim Choices As CustomChoicesAttributeList = context.PropertyDescriptor.Attributes(GetType(CustomChoicesAttributeList))

        If Not Choices Is Nothing Then
            oChoices = Choices
            GetStandardValuesExclusive = True
        Else
            GetStandardValuesExclusive = False
        End If
    End Function
    Public Overrides Function GetStandardValues(ByVal context As System.ComponentModel.ITypeDescriptorContext) As System.

Hi, please feel free to add, modify and use source code from my recent article: http://www.codeproject.com/useritems/PropertyGridEx.asp Kind Regards

Hi to all, I'm trying to develop a query tool. Actually I want to run query like: SELECT * FROM MyTable WHERE MyField = :variable :doh: The problem is that I don't know at the time of running the query, which query is and how many parameters I have. I understood I have to use the Command.Parameters collection, but I'm still looking for some snippets because I didn't found so many examples. Any suggestion are appreciated. :)

Hi, the only SQL Command I know is this one: The SELECT INTO Statement The SELECT INTO statement is most often used to create backup copies of tables or for archiving records. Syntax SELECT column_name(s) INTO newtable [IN externaldatabase] FROM source Check the w3school website for complete documentation: http://www.w3schools.com/sql/sql\_select\_into.asp With Kind Regards

Thanks for your reply, but I want to convert my XML to XLS using XSLT. Here an example of what I want to have! http://support.microsoft.com/?kbid=319180 The code posted already work, I need only a better implementation of the stylesheet... Thanks again :)

Hi to everybody, I need some help :doh: to convert a XML DataSet to an Excel file. I actually using this code: Private Sub TransformXML(ByVal xmlDoc As XmlDataDocument, _ ByVal strXSLPath As String, _ ByVal strSavePath As String)   Dim xt As New XslCompiledTransform   Dim tw As XmlTextWriter   tw = New XmlTextWriter(strSavePath, System.Text.Encoding.UTF8)   tw.Formatting = Formatting.Indented   tw.Indentation = 3   tw.WriteStartDocument()   xt.Load(My.Application.Info.DirectoryPath & strXSLPath)   xt.Transform(xmlDoc, Nothing, tw)   tw.Close() End Sub The XSLT follow here :^): <xsl:stylesheet version="1.0" xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:user="urn:my-scripts" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" > <xsl:template match="/"> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40"> xsl:apply-templates/ </Workbook> </xsl:template> <xsl:template match="/*"> <Worksheet> <xsl:attribute name="ss:Name"> <xsl:value-of select="local-name(/*/*)"/> </xsl:attribute> <Table x:FullColumns="1" x:FullRows="1"> <Row> <xsl:for-each select="*[position() = 1]/*"> <Cell> <Data ss:Type="String"> <xsl:value-of select="local-name()"/> </Data> </Cell> </xsl:for-each> </Row> xsl:apply-templates/ </Table> </Worksheet> </xsl:template> <xsl:template match="/*/*"> <Row> xsl:apply-templates/ </Row> </xsl:template> <xsl:template match="/*/*/*"> <Cell> <Data ss:Type="String"> <xsl:value-of select="."/> </Data> </Cell> </xsl:template> </xsl:stylesheet> The problem is that the XSLT must be