Member Avatar for 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

  • 2 Contributors
  • 1 Reply
  • 102 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

PrimaryKey property of DataTable.

ds.Tables("tableName").PrimaryKey=new DataColumn(){ ds.Tables("tableName").Columns("fieldName")}
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.