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

Can't Update Datagridview

P: n/a
I just can't seem to get the datagridview to update. I'm using 2005 vb.net

Here's my code for loading the grid (works fine) and my attempt at updating
via a save button...

Private SxAdapter As New OleDbDataAdapter()
Private SxSource As New BindingSource()
Private SxTable As New DataTable()

Private Sub GetData(ByVal selectCommand As String)
Try
SQL = "Select LastName, FirstName, TestName, TestDate, Score
from TestScores"
SxAdapter = New OleDbDataAdapter(selectCommand, CS)
Dim MyCommandBuilder As New OleDbCommandBuilder(SxAdapter)
SxTable.Locale = System.Globalization.CultureInfo.InvariantCulture
Me.SxAdapter.Fill(SxTable)
Me.SxSource.DataSource = SxTable
Catch ex As OleDbException
MessageBox.Show("Error")
End Try
End Sub

in the form load...
Me.DataGridView1.DataSource = Nothing
Me.DataGridView1.Rows.Clear()
Me.DataGridView1.DataSource = SxSource
GetData("Select LastName, FirstName, TestName, TestDate, Score from
TestScores")

and the save button...

Try
Me.Validate()
Me.SxSource.EndEdit()
Dim myBuilder As OleDb.OleDbCommandBuilder = New
OleDb.OleDbCommandBuilder(Me.SxAdapter)
Me.SxAdapter.Update(CType(Me.SxSource.DataSource, DataTable))
MsgBox("Update Successful")
Catch ex As Exception
MsgBox("Update Failed")
End Try

I'm stumpled...
Nov 28 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
What does it do? Does it give you an error? Does it just act like
it did the update but it doesn't? In what way doesn't it work?

Robin S.
-------------------------------------------
"Arne Beruldsen" <Ar***********@discussions.microsoft.comwrote in message
news:13**********************************@microsof t.com...
>I just can't seem to get the datagridview to update. I'm using 2005 vb.net

Here's my code for loading the grid (works fine) and my attempt at
updating
via a save button...

Private SxAdapter As New OleDbDataAdapter()
Private SxSource As New BindingSource()
Private SxTable As New DataTable()

Private Sub GetData(ByVal selectCommand As String)
Try
SQL = "Select LastName, FirstName, TestName, TestDate, Score
from TestScores"
SxAdapter = New OleDbDataAdapter(selectCommand, CS)
Dim MyCommandBuilder As New OleDbCommandBuilder(SxAdapter)
SxTable.Locale =
System.Globalization.CultureInfo.InvariantCulture
Me.SxAdapter.Fill(SxTable)
Me.SxSource.DataSource = SxTable
Catch ex As OleDbException
MessageBox.Show("Error")
End Try
End Sub

in the form load...
Me.DataGridView1.DataSource = Nothing
Me.DataGridView1.Rows.Clear()
Me.DataGridView1.DataSource = SxSource
GetData("Select LastName, FirstName, TestName, TestDate, Score from
TestScores")

and the save button...

Try
Me.Validate()
Me.SxSource.EndEdit()
Dim myBuilder As OleDb.OleDbCommandBuilder = New
OleDb.OleDbCommandBuilder(Me.SxAdapter)
Me.SxAdapter.Update(CType(Me.SxSource.DataSource, DataTable))
MsgBox("Update Successful")
Catch ex As Exception
MsgBox("Update Failed")
End Try

I'm stumpled...

Nov 28 '06 #2

P: n/a
Robin...

via the Catch...I simply get "Update Failed"

I'm confused...

"RobinS" wrote:
What does it do? Does it give you an error? Does it just act like
it did the update but it doesn't? In what way doesn't it work?

Robin S.
-------------------------------------------
"Arne Beruldsen" <Ar***********@discussions.microsoft.comwrote in message
news:13**********************************@microsof t.com...
I just can't seem to get the datagridview to update. I'm using 2005 vb.net

Here's my code for loading the grid (works fine) and my attempt at
updating
via a save button...

Private SxAdapter As New OleDbDataAdapter()
Private SxSource As New BindingSource()
Private SxTable As New DataTable()

Private Sub GetData(ByVal selectCommand As String)
Try
SQL = "Select LastName, FirstName, TestName, TestDate, Score
from TestScores"
SxAdapter = New OleDbDataAdapter(selectCommand, CS)
Dim MyCommandBuilder As New OleDbCommandBuilder(SxAdapter)
SxTable.Locale =
System.Globalization.CultureInfo.InvariantCulture
Me.SxAdapter.Fill(SxTable)
Me.SxSource.DataSource = SxTable
Catch ex As OleDbException
MessageBox.Show("Error")
End Try
End Sub

in the form load...
Me.DataGridView1.DataSource = Nothing
Me.DataGridView1.Rows.Clear()
Me.DataGridView1.DataSource = SxSource
GetData("Select LastName, FirstName, TestName, TestDate, Score from
TestScores")

and the save button...

Try
Me.Validate()
Me.SxSource.EndEdit()
Dim myBuilder As OleDb.OleDbCommandBuilder = New
OleDb.OleDbCommandBuilder(Me.SxAdapter)
Me.SxAdapter.Update(CType(Me.SxSource.DataSource, DataTable))
MsgBox("Update Successful")
Catch ex As Exception
MsgBox("Update Failed")
End Try

I'm stumpled...


Nov 28 '06 #3

P: n/a
Robin...

The error reads

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

??

Arne

"RobinS" wrote:
What does it do? Does it give you an error? Does it just act like
it did the update but it doesn't? In what way doesn't it work?

Robin S.
-------------------------------------------
"Arne Beruldsen" <Ar***********@discussions.microsoft.comwrote in message
news:13**********************************@microsof t.com...
I just can't seem to get the datagridview to update. I'm using 2005 vb.net

Here's my code for loading the grid (works fine) and my attempt at
updating
via a save button...

Private SxAdapter As New OleDbDataAdapter()
Private SxSource As New BindingSource()
Private SxTable As New DataTable()

Private Sub GetData(ByVal selectCommand As String)
Try
SQL = "Select LastName, FirstName, TestName, TestDate, Score
from TestScores"
SxAdapter = New OleDbDataAdapter(selectCommand, CS)
Dim MyCommandBuilder As New OleDbCommandBuilder(SxAdapter)
SxTable.Locale =
System.Globalization.CultureInfo.InvariantCulture
Me.SxAdapter.Fill(SxTable)
Me.SxSource.DataSource = SxTable
Catch ex As OleDbException
MessageBox.Show("Error")
End Try
End Sub

in the form load...
Me.DataGridView1.DataSource = Nothing
Me.DataGridView1.Rows.Clear()
Me.DataGridView1.DataSource = SxSource
GetData("Select LastName, FirstName, TestName, TestDate, Score from
TestScores")

and the save button...

Try
Me.Validate()
Me.SxSource.EndEdit()
Dim myBuilder As OleDb.OleDbCommandBuilder = New
OleDb.OleDbCommandBuilder(Me.SxAdapter)
Me.SxAdapter.Update(CType(Me.SxSource.DataSource, DataTable))
MsgBox("Update Successful")
Catch ex As Exception
MsgBox("Update Failed")
End Try

I'm stumpled...


Nov 28 '06 #4

P: n/a
Do you have a primary key defined in your table? And does your SELECT
statement include that field?

Robin S.
===========================
"Arne Beruldsen" <Ar***********@discussions.microsoft.comwrote in message
news:0E**********************************@microsof t.com...
Robin...

The error reads

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

??

Arne

"RobinS" wrote:
>What does it do? Does it give you an error? Does it just act like
it did the update but it doesn't? In what way doesn't it work?

Robin S.
-------------------------------------------
"Arne Beruldsen" <Ar***********@discussions.microsoft.comwrote in
message
news:13**********************************@microso ft.com...
>I just can't seem to get the datagridview to update. I'm using 2005
vb.net

Here's my code for loading the grid (works fine) and my attempt at
updating
via a save button...

Private SxAdapter As New OleDbDataAdapter()
Private SxSource As New BindingSource()
Private SxTable As New DataTable()

Private Sub GetData(ByVal selectCommand As String)
Try
SQL = "Select LastName, FirstName, TestName, TestDate, Score
from TestScores"
SxAdapter = New OleDbDataAdapter(selectCommand, CS)
Dim MyCommandBuilder As New OleDbCommandBuilder(SxAdapter)
SxTable.Locale =
System.Globalization.CultureInfo.InvariantCulture
Me.SxAdapter.Fill(SxTable)
Me.SxSource.DataSource = SxTable
Catch ex As OleDbException
MessageBox.Show("Error")
End Try
End Sub

in the form load...
Me.DataGridView1.DataSource = Nothing
Me.DataGridView1.Rows.Clear()
Me.DataGridView1.DataSource = SxSource
GetData("Select LastName, FirstName, TestName, TestDate, Score from
TestScores")

and the save button...

Try
Me.Validate()
Me.SxSource.EndEdit()
Dim myBuilder As OleDb.OleDbCommandBuilder = New
OleDb.OleDbCommandBuilder(Me.SxAdapter)
Me.SxAdapter.Update(CType(Me.SxSource.DataSource,
DataTable))
MsgBox("Update Successful")
Catch ex As Exception
MsgBox("Update Failed")
End Try

I'm stumpled...



Nov 28 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.