VB.NET

VB.NET RSS

SQL, Dataview, DataTable and DataAdapter.Update

Please support our VB.NET advertiser: Intel Parallel Studio Home

•

Join Date: Oct 2006

Posts: 169

Reputation: ptaylor965 is an unknown quantity at this point

Solved Threads: 19

ptaylor965 ptaylor965 is offline

Offline

Junior Poster

SQL, Dataview, DataTable and DataAdapter.Update

Jun 14th, 2007

when trying to update a sql database i get the following error message on Update

Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information

the column UserID is the PrimaryKey

any ideas would be appreciated

Thanks
Peter

example code:

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
Private dt as new datatable
private dv as new dataview
 
Public sub GetData
    dim da as new SqlDataAdapter("SELECT * FROM tblUser", sqlconn.connectionstring)
    da.fill(dt)
    dt.TableName = "tblUser
 
    dv.table = dt
    dgUserData.datasource = dv
end sub
 
private sub setdata()
    Dim Row As DataRow
    Row = dv.Item(dgUserData.CurrentRow.Index).Row
 
    Row("username") = txtUsername.text
end sub
 
private sub SaveDataToServer()
    dim da as new SqlDataAdapter("SELECT * FROM tblUser", sqlconn.connectionstring)
 
da.update(dt)
 
end sub
 
Private dt as new datatable
private dv as new dataview

Public sub GetData
    dim da as new SqlDataAdapter("SELECT * FROM tblUser", sqlconn.connectionstring)
    da.fill(dt)
    dt.TableName = "tblUser

    dv.table = dt
    dgUserData.datasource = dv
end sub

private sub setdata()
    Dim Row As DataRow
    Row = dv.Item(dgUserData.CurrentRow.Index).Row

    Row("username") = txtUsername.text
end sub

private sub SaveDataToServer()
    dim da as new SqlDataAdapter("SELECT * FROM tblUser", sqlconn.connectionstring)

da.update(dt)

end sub