Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
Hi All
 

my DGV database UPDATE Time This Error Show..
 
Unable to cast object of type 'System.Data.DataTable' to type 'System.Windows.Forms.BindingSource'.
 

Here I am USING CODE FOR UPDATE FUNCION
Me.Validate()
 Dim bindingSource1 As New BindingSource
 
        Dim DTable As New DataTable()
        Me.bindingSource1 = Me.dgvView.DataSource
        DTable = Me.bindingSource1.DataSource
        Me.DaAp.Update(DTable)
        MessageBox.Show("UPDATED SUCESSFULLY")
        DTable.AcceptChanges()
 

Please Tell Me How Can i Do to database UPDATE using DGV
Posted 23-Feb-13 8:50am
Edited 23-Feb-13 9:36am
CHill6061.2K
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You REALLY need to go through a VB.NET book. This code is meaningless spaghetti.
 
You don't creat a new bindingsource to do a database update. On top of that, you're creating a new empty DataTable, then ignoring it and letting it go out of scope.
 
You normally have your data in a DataTable object, bind the Grid to it, and when the user wants to submit changes, you call the Update method of a DataAdapter configured to do the update. This is not a replacement for your code, but it comes down to this:
    MyDgv.EndEdit()
    MyDataAdapter.Update(myDataTable)
    MessageBox.Show("UPDATED SUCESSFULLY")
The rest of that code you posted is meaningless garbage.
  Permalink  
Comments
Navas Khanj at 24-Feb-13 5:09am
   
Thanks

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 6,649
1 Sergey Alexandrovich Kryukov 6,270
2 CPallini 5,190
3 George Jonsson 3,574
4 Gihan Liyanage 2,522


Advertise | Privacy | Mobile
Web04 | 2.8.140916.1 | Last Updated 23 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100