tengo el siguiente codigo que utiliza un commandbuilder.
Código:
en esta linea me dice que el comando dinamico select sql no puede especificar un comando update ya que no le pasa ninguna referencia al campo clave.Imports System.Data.OleDb Public Class Form1 Inherits System.Windows.Forms.Form Public adtiendas As OleDbDataAdapter Dim cb As OleDbCommandBuilder Public ds As New DataSet Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim comand As String Dim pkey(0) As DataColumn comand = "SELECT stor_id,stor_name,stor_address,city,state,zip FROM stores" adtiendas = New OleDbDataAdapter(comand, con1) adtiendas.Fill(ds, "stores") pkey(0) = ds.Tables("stores").Columns("au_id") ds.Tables("stores").PrimaryKey() = pkey cb = New OleDbCommandBuilder(adtiendas) DataGrid1.DataSource = ds.Tables("stores") End Sub PrivateSub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click adtiendas.Update(ds, "stores")'error ds.Tables("stores").AcceptChanges() EndSub
gracias.saludos