Wrox Programmer Forums
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 29th, 2006, 10:18 PM
Authorized User
 
Join Date: Oct 2006
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to salemkoten
Default Save data on datagridview

Hi all,
I change data on datagridview then I save it, appear an error message:
 
Quote:
quote:
Quote:
Missing the DataColumn 'ColumnID' in the DataTable 'project' for the SourceColumn 'ColumnID'.
This is my code:
Code:
Private Sub saveBNavigator_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles saveBNavigator.Click
        Me.Validate()
        Me.ProjectDataBindingSource.EndEdit()
        If ds.HasChanges Then
            Dim cmb As New SqlCommandBuilder(Me.ProjectDataAdapter)
            Try
                Me.ds.Tables("project").GetChanges()
                ProjectDataAdapter.Update(ds.Tables("Project"))
            Catch ex As Exception
                MessageBox.Show(ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error)
            End Try
        End If
         End Sub

I'm using VB.net 2005.
Can anybody help me?
Thanks in advance.
SLKT

 
Old November 2nd, 2006, 11:04 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

You will recieve a quicker and better response if you post your question in the correct forum.

P2P Forum > Visual Basic > Pro Visual Basic 2005

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to save DataGridView to temp dataset smithsf22 ADO.NET 1 April 17th, 2008 10:14 PM
capture data in datagridview stealthdevil Visual Basic 2005 Basics 0 January 23rd, 2008 06:49 PM
Update Data in Datagridview munmin2000 Visual Basic 2005 Basics 1 November 5th, 2007 03:27 AM
How do i Update data through a datagridview jazzydonald VB How-To 0 October 26th, 2007 02:52 AM
save changes to datagridview jriggs General .NET 1 May 30th, 2007 08:13 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.