By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,731 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,731 IT Pros & Developers. It's quick & easy.

Issues with OledbDataAdapter.Update()

P: n/a
Hi

I have a problem with an insert statment using the update() method of the
OledbDataAdapter.
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="system.Data" %>
<%@ Import Namespace="system.Data.Oledb" %>
<script language="vb" runat="server">
Sub Page_Load(sender As Object, e As EventArgs)
Dim objDataSet As New DataSet()
Dim objDataAdapter As New OledbDataAdapter()
Dim strConnection As String =
ConfigurationSettings.AppSettings("ConnectionStrin g")
Dim strSQL As String = "SELECT [ppcTerm], [pageName], [contentTitle],
[contentBody] FROM tbl_content"
Dim objConnection As New oleDbConnection(strConnection)
Dim objCommand As New oleDbCommand(strSQL, objConnection)
objDataAdapter.SelectCommand = objCommand
objDataAdapter.Fill(objDataSet)
Dim objNewRow As DataRow = objDataSet.Tables(0).NewRow
objNewRow(0) = "value1"
objNewRow(1) = "value2"
objNewRow(2) = "value3"
objNewRow(3) = "value4"
objDataSet.Tables(0).Rows.Add(objNewRow)
objDataAdapter.Update(objDataSet)
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
Nov 18 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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: +972-(0)58-888377
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.