Adding up a column with datareader and sql

See more:

ASP.NET

SQL

DataReader

I would like to add up every row in a column.

I know I am missing a integer changing thing on dr(i).

If there are easier methods please let me know.

Sub Add()
        cmdStr = "SELECT [col3] FROM [table1];"
        End Select
        i = 0
        connStr = "server=myServer;initial catalog=myDB;uid=myID;pwd=myPassword"
        Using conn As New SqlConnection(connStr)
            conn.Open()
            Using cmd As New SqlCommand(cmdStr, conn)
                Using dr As SqlDataReader = cmd.ExecuteReader()
                    While dr.Read()
                        count = count + dr(i)
                        i = i + 1
                    End While
                End Using
            End Using
        End Using
        TextBox2.Text = count
End Sub