Primary key

[tqmd1]

Dear Experts
How to apply primary key on sno column in the following dataset

  dim sql = "select * from employees"
        Dim da As new SqlClient.SqlDataAdapter (sql,con)
        'ds.Clear()
        da.Fill(ds, "employees")
        TextBox1.DataBindings.Add("text", ds.Tables("employees"), "sno")
        TextBox2.DataBindings.Add("text", ds.Tables("employees"), "Name")
        TextBox3.DataBindings.Add("text", ds.Tables("employees"), "City")
        TextBox4.DataBindings.Add("text", ds.Tables("employees"), "Phone")

Please help

[Bruce Fox]

Normally, that would be done at the DataBase (when it was built).

[tqmd1]

Table employees has primary key on sno column, but when i use these codes it says there is no primary key.

 Me.ds.Tables("employees").Rows.Find(Me.TextBox1.Text)
        Me.BindingContext(ds.Tables("employees")).Position += 1