.Net Articles

New code snippet plugin for Live Writer

I am trying out a new code snippet plug-in for Live Writer.

Public Class CommitDB
    Public Function GetCommitStatusAll() As DataSet
        ' Create Instance of Connection and Command Object
        Dim myConnection As New SqlConnection(ConfigurationManager.AppSettings("NorthstarConnectionString"))
        Dim myCommand As New SqlDataAdapter("GetCommitStatusAll", myConnection)

        ' Mark the Command as a SPROC
        myCommand.SelectCommand.CommandType = CommandType.StoredProcedure

        ' Create and Fill the DataSet
        Dim myDataSet As New DataSet
        myCommand.Fill(myDataSet)

        ' Return the DataSet
        Return myDataSet
    End Function
End Class