C#

SELECT
    [Serial Number],
    [Failure Code],
    COUNT(*) AS [Counter]
    FROM
        [Failure Codes]
    WHERE
        [Serial Number] = @SerialNumber
    GROUP BY
        [Serial Number],
        [Failure Code]
    ORDER BY
        [Counter] ASC

Member 8069795 wrote:

file I want is being used by another process

Member 8069795 wrote:

doc.Load("Subscription.xml");

//Load and parse tree nodes
defXmlDoc.Load(xmlPath)

TreeView1.Nodes.Clear()

//Ignore root node and add level 1's as multi roots
For Each node As XmlNode In defXmlDoc.DocumentElement.ChildNodes
    AddNode(node, TreeView1.Nodes)
    AddNodeTree(node, TreeView1.Nodes.Item(TreeView1.Nodes.Count - 1))
Next

defXmlDoc = Nothing

Private Sub AddNode(ByVal xmlNode As XmlNode, ByVal NodeCol As TreeNodeCollection)
     Dim id, label, desc As String
     label = xmlNode.Name
     desc = ""
     id = "Unknown"
     If Not xmlNode.Attributes("label") Is Nothing Then
         label = xmlNode.Attributes.GetNamedItem("label").Value
     End If
     If Not xmlNode.Attributes("description") Is Nothing Then
         desc = xmlNode.Attributes.GetNamedItem("description").Value
     End If
     If Not xmlNode.Attributes("id") Is Nothing Then
         id = xmlNode.Attributes.GetNamedItem("id").Value
         If id > maxId Then maxId = id
     End If
     NodeCol.Add(id, label)
     NodeCol(id).Tag = desc
 End Sub

 Private Sub AddNodeTree(ByVal xmlNode As XmlNode, ByVal treeNode As TreeNode)
     Dim i As Integer
     Dim xNode As XmlNode
     Dim tNode As TreeNode
     Dim nodeList As XmlNodeList
     If (xmlNode.HasChildNodes) Then
         nodeList = xmlNode.ChildNodes
         For i = 0 To nodeList.Count - 1
             xNode = xmlNode.ChildNodes(i)
             AddNode(xNode, treeNode.Nodes)
             tNode = treeNode.Nodes(i)
             AddNodeTree(xNode, tNode)
         Next
     Else
         'Leaf
     End If
 End Sub

using (DbDataReader dr = command.ExecuteReader())
{
     while (dr.Read())
     {
          String col1 = dr[1];
     }
}

Eddy Vluggen wrote:

it might come without headers

GlobX wrote:

pre-loading all the images (including the blank one) at startup and keeping them in memory

GlobX wrote:

you'll only need one in-memory copy

nstk wrote:

I'm not quite sure, that I know how to do the following.

 

GlobX wrote:

pre-loading all the images (including the blank one) at startup and keeping them in memory