Vb net SQL server app use buttons not binding navigator

See more:

SQL

VB12

I have made a vb net app connecting to an sql database, I used binding navigator datagridview and biding source, I instead want to use toolbox buttons, textboxes and not bindigsource.

What I have tried:

this code works

Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Reflection

Public Class Form1
    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        
        Dim i As New Double
        SqlDataAdapter1.Fill(DataSet11, "Table_1")
       For index As Integer = 0 To DataGridView1.RowCount - 1
            i += Convert.ToDouble(Math.Round(DataGridView1.Rows(index).Cells(1).Value,2))
        Next
        TextBox1.Text = Convert.ToString(i)
        
        

    End Sub

    Private Sub BindingNavigator1_RefreshItems(sender As Object, e As EventArgs) Handles BindingNavigator1.RefreshItems
        Me.Table1BindingSource.EndEdit()
        '  Me.BindingContext(DataSet11, "Table_1").EndCurrentEdit()
        If DataSet11.HasChanges Then
            Try
                SqlDataAdapter1.Update(DataSet11, "Table_1")
                DataSet11.AcceptChanges()
            Catch eUpdate As System.Exception

                'Throw eUpdate
                MsgBox(eUpdate.Message.ToString)
            End Try
        End If
    End Sub

    Private Sub ToolStripButton1_Click(sender As Object, e As EventArgs) Handles ToolStripButton1.Click
        Me.Table1BindingSource.CancelEdit()
        DataSet11.Table_1.RejectChanges()
    End Sub 

I want to use only dataset and sqldataadapter with textboxes and nor binding sources
I try and connect a textbox with out binding source text form1 list indexes but missing code for add new delete and navigations.
I tried this but no luck

</pre Me.DataSet11.Table_1.First>

something like this

Public Class Form1
    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Me.BindingContext.Item(DataSet11, "Table_1").AddNew()
        ' Me.DataSet11.Table_1.Last
    End Sub

    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        Me.SqlDataAdapter1.Fill(DataSet11, "Table_1")
    End Sub

    Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
        Me.BindingContext.Item(DataSet11, "Table_1").Position = Me.BindingContext.Item(DataSet11, "Table_1").Position + 1
    End Sub

    Private Sub Button3_Click(sender As Object, e As EventArgs) Handles Button3.Click
        Me.BindingContext.Item(DataSet11, "Table_1").Position = Me.BindingContext.Item(DataSet11, "Table_1").Count - 1
    End Sub

    Private Sub Button4_Click(sender As Object, e As EventArgs) Handles Button4.Click
        Me.BindingContext.Item(DataSet11, "Table_1").Position = Me.BindingContext.Item(DataSet11, "Table_1").Position - 1
    End Sub

    Private Sub Button5_Click(sender As Object, e As EventArgs) Handles Button5.Click
        Me.BindingContext(DataSet11, "Table_1").EndCurrentEdit()
        If DataSet11.HasChanges Then
            Try
                SqlDataAdapter1.Update(DataSet11, "Table_1")
                DataSet11.AcceptChanges()
            Catch eUpdate As System.Exception

                'Throw eUpdate
                MsgBox(eUpdate.Message.ToString)
            End Try
        End If

    End Sub
End Class

I need the move fist delete and cancel code