Web part, datagrid og events

Jeg er igang med at lave en web part til sharepoint portal server 2003.

Jeg har nogle problemer med at lave datagrids samt definere events.

Dette er min kode:

    Protected Overrides Sub RenderWebPart(ByVal output As System.Web.UI.HtmlTextWriter)
        output.Write(SPEncode.HtmlEncode([Text]))

        Dim DS As DataSet
        Dim dg As DataGrid

        Dim MyConnection As SqlConnection
        Dim MyCommand As SqlDataAdapter
        Dim Rows As Integer = SPEncode.HtmlEncode([antal])
        MyConnection = New SqlConnection("Server=localhost;Database=Intranet;uid=sa;pwd=xxxxx;")
        MyCommand = New SqlDataAdapter("select * From Sale Order By Id Asc ", MyConnection)

        DS = New DataSet
        MyCommand.Fill(DS, "Authors")

        dg.DataSource = DS.Tables("Authors").DefaultView
        dg.DataBind()

        Controls.Add(dg)
        dg.RenderControl(output)
    End Sub