Issues with OledbDataAdapte r.Update()

[amessimon]

Hi

I have a problem with an insert statment using the update() method of the
OledbDataAdapte r.
I'm getting the error 'Update requires a valid InsertCommand when passed
DataRow collection with new rows. '
Heres a condensed version of the page.

<%@ Import Namespace="syst em.Data" %>
<%@ Import Namespace="syst em.Data.Oledb" %>
<script language="vb" runat="server">
Sub Page_Load(sende r As Object, e As EventArgs)
Dim objDataSet As New DataSet()
Dim objDataAdapter As New OledbDataAdapte r()
Dim strConnection As String =
ConfigurationSe ttings.AppSetti ngs("Connection String")
Dim strSQL As String = "SELECT [ppcTerm], [pageName], [contentTitle],
[contentBody] FROM tbl_content"
Dim objConnection As New oleDbConnection (strConnection)
Dim objCommand As New oleDbCommand(st rSQL, objConnection)
objDataAdapter. SelectCommand = objCommand
objDataAdapter. Fill(objDataSet )
Dim objNewRow As DataRow = objDataSet.Tabl es(0).NewRow
objNewRow(0) = "value1"
objNewRow(1) = "value2"
objNewRow(2) = "value3"
objNewRow(3) = "value4"
objDataSet.Tabl es(0).Rows.Add( objNewRow)
objDataAdapter. Update(objDataS et)
End sub
</script>

I'm aware there are other ways of doing this like using an INSERT statement,
but i'd like to know why this isnt working.

Thanks for any help in advance.

Simon Ames

[Natty Gur]

Hi,

Although I'm against using datasets (ORM much better), you need to set
objDataAdapter. InsertCommand exectly as you set SelectCommand. Otherwise
the adapter won't know which command to run against changed values in
dataset.

HTH

Natty Gur[MVP]

blog : http://weblogs.asp.net/ngur
Mobile: [phone]
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!