hallo alle
bin jetzt schon lange verzeifelt am rumpr�beln aber kann einfach meine
datenbank nicht updaten.
habe gerade erst auf aspx umgestellt (von asp).
bekomme diesen fehler:
Update requires a valid InserCommand when passed DataRow collection with new
rows
mein code sieht so aus:
Sub Click(Sender As Object, E As EventArgs)
Dim myConn As OdbcConnection = New OdbcConnection
Dim myAdapter As OdbcDataAdapter = New OdbcDataAdapter
Dim myCB As OdbcCommandBuilder
Dim myDataSet As DataSet = New DataSet
Dim myRow As DataRow
Dim myConnectString, Query As String
Query = "SELECT * FROM news WHERE id=0"
myConnectString = "DSN=myDSN"
myConn.ConnectionString = myConnectString
myAdapter.SelectCommand = new OdbcCommand(Query, myConn)
myAdapter.SelectCommand.Connection.Open
myCB = New OdbcCommandBuilder(myAdapter)
myAdapter.Fill(myDataSet, "news")
myRow = myDataSet.Tables("news").NewRow
myRow.Item("teaser") = "test"
myRow.Item("text") = "test"
myDataSet.Tables("news").Rows.Add(myRow)
myAdapter.Update(myDataSet, "news")
End Sub
vielen dank f�r jede hilfe
markus
_______________________________________________
Asp.net mailing list
[EMAIL PROTECTED]
http://www.glengamoi.com/mailman/listinfo/asp.net
